T5BS3 - Employee information except reductions ( level 3 )

Employee information except reductions ( level 3 ) information is stored in SAP table T5BS3.
It is part of development package PC12 in software component PY-BE. This development package consists of objects that can be grouped under "HR accounting: Belgium".

Fields for table T5BS3

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
DECID	SI Declaration identifier	X	P12_DECID	NUMC	12
STREF	Reference pointing to the detailed declaration info	X	P12_STREF	NUMC	6
RSZCA	Employer Class (SI Employer Category) (00036)	X	RSZCA	CHAR	6
RSZNR	SI Registration Number (employer) (00011)	X	RSZNR	NUMC	18
RSZKN	Worker Code (SI Employee Category) (00037)	X	RSZKN	CHAR	6
PERNR	Personnel Number	X	PERSNO	NUMC	16
STRAV	Worker's range number		STRAV	CHAR	10
RSZRR	INSS - National ID Number (00024)		RSZRR	NUMC	22
GBDAT	Date of Birth		GBDAT	DATS	16
GBORT	Birthplace		PAD_GBORT	CHAR	80
RSZGL	Country/Region code for place of birth		RSZG0	CHAR	10
DDREC	Correction proposal code		DDREC	CHAR	2
NSSOC	Employer number with Social Office		NSSOC	CHAR	30
RSZLA	Language Key		SPRAS	LANG	2
NACHN	Last Name		PAD_NACHN	CHAR	80
VORNA	First Name		PAD_VORNA	CHAR	80
GESCH	Gender Key		GESCH	CHAR	2
STRAS	Street and House Number		STRAS	CHAR	60
HSNMR	House Number		PAD_HSNMR	CHAR	20
ORT01	City		PAD_ORT01	CHAR	80
POSTA	Identification of an apartment in a building		PAD_POSTA	CHAR	20
PSTLZ	Postal Code		PSTLZ	CHAR	20
RSZBL	Sender SI country/region code		RSZB0	CHAR	10
DECES	SI declaration date of death		P12_DECES	DATS	16
PENS	SI declaration date of retirement		P12_PENS	DATS	16
ESCE	SI declaration date of entry		P12_ESCE	DATS	16
SORT	SI declaration date of leaving		P12_SORT	DATS	16
FRONT	Border worker		FRONT	CHAR	2
ARTIS	Artist		ARTIS	CHAR	2
CHOM	Unemployed		CKOM0	CHAR	2
INTER	International address version ID		INTER	CHAR	2
TDOMI	Domestic worker		TDOMI	CHAR	2
DEBST	Begindate in employee category		P12_BEGD3	DATS	16
FINST	Enddate in employee category		P12_ENDD3	DATS	16
TREMP	Employment notion		TREMP	CHAR	2
NSTAG	Training employee		NSTAG	CHAR	2
NOPEP	Notion first professional experiance		PC12_NPEPR	CHAR	4
BVFAM	Marital Status		BVFAM	CHAR	2
RSZNA	Obsolete: SI Nationality		RSZNA	CHAR	2
BVECH	Partner's Profession		BVECH	CHAR	2
FAMSA	Type of Family Record		FAMSA	CHAR	8
DTRIM	File creation date		DTRIM	DATS	16
FTRIM	End of three months period		FTRIM	DATS	16
BESTE	Frequency of payment		BEST0	CHAR	2
BEGPC	Joint Commission (00046)		BEGPC	CHAR	14
BECNR	Contract Number		BECNR	CHAR	30
ARBER	Expiration Date of Work Permit		ARBER	DATS	16
BEANN	Contract duration		BEANN	CHAR	4
CTTYP	Contract Type		CTTYP	CHAR	4
NSUIT	Activity range number		NSUIT	CHAR	6
SSGE	Range number HQ		SSGE0	CHAR	8
STQUA	Student capacity		STQUA	NUMC	2
STAMT	Student salary		P12_STAMT	INT4	4
STDAG	Number of paid days (students)		P12_STDAG	INT4	4
DPD92	Double Holiday Pay after 1992		P12_DPD92	INT4	4
COTSP	Contribution code		COTSP	CHAR	2
MTCOT	Special contribution: amount		P12_MTCOT	INT4	4
AMSOL	Solidarity contribution on company car		P12_AMSOL	INT4	4
AMELA	Contribution extra-legal advantage : amount		P12_AMELA	INT4	4