Table INSCRIPT @ L.V. Expertise X3

Table	Abbreviation	Title	Module	Activity code
INSCRIPT	INS	Registrations	Training

Key	Description	Duplicates
INS1	SES+REFNUM	No
INS0	STG+SES+REFNUM	No
INS2	REFNUM	Yes

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
AUUID	Single identifier		AUUID
CATFRT	Category 2483		ADI			[ADI]CODE=453;CATFRT	Block
CPCAFT	Induced skill		CPC			[CPC]CPC0=[INS]CPCAFT	Block	CPC
CREDAT	Date created		D
CREDATTIM	Date time		ADATIM
CRETIM	Time		L	8
CREUSR	Creation user		A	5
CTRNUM	Contract		CTR
DEM	Request no.		DEM			[DEM]DEM0=[INS]DEM	Block
DESCATACN	Action category		HRCAN			[HRCAN]HRCAN0=[V]GDOSLEG(1);DESCATACN	Block
DESNATFIS	Fiscal nature		HRFCN			[HRFCN]HRFCN0=[V]GDOSLEG(1);DESNATFIS	Block
EXPNUM	Export number		L	8
FLGTPS	Time entry validation		M	4	1
HABAFT	Authorization created	10	ADI			[ADI]CODE=397;HABAFT	Block
HABFLG	To renew	10	M	4	1
HABSTR	Granting date	10	D
LEVAFT	Induced level		NIV					CPC
NBRDAY	Days		DCB	4.2
NBRDAY2	No. days outside WT		DCB	4.2
NBRHOUIPT	Number of hours		DCB	9.2
NBRHOUIPT2	No. of hours outside of WH		DCB	9.2
REFNUM	Employee ID		MAT			[ID]ID0=REFNUM	Block
REFPER	Reference period		A	10				KPO
REQNUMHTT	Outside of WH slip		VCR
REQNUMSTT	Slip for working hours		VCR
SES	Session		SES			[SES]SES0=SES	Block
STA	Status		M	15	459
STG	Training period		STG			[STG]STG0=STG	Block
TRFREQ	Slip transferred		M	4	1
TRFTPS	Time transfer		M	4	1
UPDCPC	Update		M	4	1
UPDDAT	Change date		D
UPDDATTIM	Date time		ADATIM
UPDHAB	Auth update		M	4	1
UPDTIM	Time		L	8
UPDUSR	Change user		A	5