GPCH_CA_XML_DEP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	GPCH_EG_DOMAINID	Number(3,0)	SMALLINT NOT NULL	Domain Set ID for the ELM Domain Sets
3	GPCH_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
4	GPCH_CA_CR_STORNO	Character(2)	VARCHAR2(2) NOT NULL	Reduced End Date
5	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default Prompt Table: GPCH_CA_DATA_VW
6	RUN_OPEN_TS	DateTime(26)	TIMESTAMP	Records the time when processing was first initiated for a given calendar group
7	RUN_FINALIZED_TS	DateTime(26)	TIMESTAMP	Finalized Timestamp
8	GPCH_AH_NNSS	Character(20)	VARCHAR2(20) NOT NULL	New Social Insurance ID
9	BIRTHDATE	Date(10)	DATE	Date of Birth
10	GPCH_CA_REFNBR	Character(20)	VARCHAR2(20) NOT NULL	Zentral Reg Reference Number
11	GPCH_EG_PRSN_XML	Long Character	CLOB	used to store the Personal Total XML data generated by the SQR in Year End Process for each employee for each functional type