T7CZERG_PRD01 - Employee register - employee - current picture

Employee register - employee - current picture information is stored in SAP table T7CZERG_PRD01.
It is part of development package P18PS in software component PY-CZ. This development package consists of objects that can be grouped under "HRCZ Public Sector".

Fields for table T7CZERG_PRD01

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
TYPE_DB	Employee register - database type	X	PCZ_ERG_TYPE_DB	CHAR	2
PERNR	Personnel Number	X	PERNR_D	NUMC	16
BEGDA	Start Date	X	BEGDA	DATS	16
SENDING_LAND	Obsolete field		PCZ_ERG_SENDING_LAND	CHAR	120
TITLE	Employee title		PCZ_ERG_TITLE	CHAR	2
NAME	Names		PCZ_ERG_NAME	CHAR	80
SURNAME	Last name		PCZ_ERG_SURNAME	CHAR	80
ACADEMIC_TITLE_INFRONT	University degree before name		PCZ_ERG_ACADEMIC_TITLE_INFRONT	CHAR	30
ACADEMIC_TITLE_BEHIND	University degree after name		PCZ_ERG_ACADEMIC_TITLE_BEHIND	CHAR	30
BIRTHDATE	Date of birth		PCZ_ERG_BIRTHDATE	DATS	16
TYPE_DOCU	Identity card type		PCZ_ERG_TYPE_DOCU	CHAR	4
NUMBER_DOCU	Identity card number		PCZ_ERG_NUMBER_DOCU	CHAR	60
MUNICIPALITY	Municipality name		PCZ_ERG_MUNICIPALITY	CHAR	80
STREET_NAME	Street name		PCZ_ERG_STREET_NAME	CHAR	120
HOUSE_NR	House number		PCZ_ERG_HOUSE_NR	CHAR	20
ORIENT_NR	Orientation number		PCZ_ERG_ORIENT_NR	CHAR	20
POSTE_CODE	Orientation number		PCZ_ERG_ORIENT_NR	CHAR	20
SERVICE_OFFICE_ID	Service office ID		PCZ_ERG_SERVICE_OFFICE_ID	NUMC	16
SERVICE_ID_CARD	Service card number		PCZ_ERG_SERVICE_ID_CARD	CHAR	60
SERVICE_POSITION_EE	Service designation		PCZ_ERG_SERVICE_POSITION_EE	CHAR	6
SERVICE_POS_ID	Obsolete field		PCZ_ERG_SERVICE_POS_ID	NUMC	16
SERVICE_POS_SUP	Obsolete field		PCZ_ERG_SERVICE_POS_SUP	CHAR	80
CONTRACT_TYPE	Service relationship type		PCZ_ERG_CONTRACT_TYPE	CHAR	4
CONTRACT_START_DATE	Service relationship origin date		PCZ_ERG_CONTRACT_START_DATE	DATS	16
CONTRACT_END_DATE	Contract end date		PCZ_ERG_CONTRACT_END_DATE	DATS	16
SALARY_GRADE	Pay grade code		PCZ_ERG_SALARY_GRADE	CHAR	16
SALARY_LEVEL	Pay scale level code		PCZ_ERG_SALARY_LEVEL	CHAR	4
PARTTIME	% of full time		PCZ_ERG_PARTTIME	DEC	3
EMPLOYEE_ID	Empolyee register identifier		PCZ_ERG_EMPLOYEE_ID	NUMC	16
MASSN_NOTE	Additional note		PCZ_ERG_MASSN_NOTE	CHAR	360
CONTRACT_END_TEXT	Fixed time - text description		PCZ_ERG_CONTRACT_END_TEXT	STRG	8
TRANSFER_LOC	Obsolete field		PCZ_ERG_TRANSFER_LOC	STRG	8
SENDING_COUNTRY	Obsolete field		PCZ_ERG_SENDING_COUNTRY	CHAR	6
SERVICE_OFFICE_ID_OUT	Service office ID		PCZ_ERG_SERVICE_OFFICE_ID	NUMC	16
NATIONALITY	Nationality		PCZ_ERG_NATIONALITY	CHAR	6
SERVICE_POS_BOSS	Superior code		PCZ_ERG_SERVICE_POS_BOSS	CHAR	6
CONTRACT_END_DATE_BOSS	Fixed time to for nomination		PCZ_ERG_CONTRACT_END_DATE_BOSS	DATS	16
CONTRACT_END_TEXT_BOSS	Duration to nomination - description		PCZ_ERG_CONTRACT_END_TEXT_BOSS	STRG	8
SUBSTITUTE_TYPE	Code of substitute type		PCZ_ERG_SUBSTITUTE_TYPE	CHAR	6
WORK_COUNTRY	Service place of work - state		PCZ_ERG_WA_COUNTRY	CHAR	6
WORK_REGION	Service place of work - region code		PCZ_ERG_WA_REGION	CHAR	12
WORK_MUNICIPALITY	Service place of work - municipality code		PCZ_ERG_WA_MUNI_CODE	CHAR	12
WORK_MUNICIPALITY_FGN	Service place of work - foreign municipality		PCZ_ERG_WA_MUNI_FOREIGN	CHAR	80
SERVICE_OFFICE_TRFR_ID	Service office ID - transfer		PCZ_ERG_SERVICE_OFFICE_TRFR_ID	NUMC	16
WORK_EMAIL	E-mail address		PCZ_ERG_EMAIL	CHAR	508
WORK_ADDRESS	String		HRBAS_STRING	STRG	8