GPCH_CA_XML_ALL

#	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	GPCH_CA_TYPE	Number(2,0)	SMALLINT NOT NULL	Field to store Allowance Type.
7	GPCH_CA_CR_BGN	Date(10)	DATE	Reduced End Date
8	RUN_OPEN_TS	DateTime(26)	TIMESTAMP	Records the time when processing was first initiated for a given calendar group
9	GPCH_CA_CR_END	Date(10)	DATE	Reduced End Date
10	RUN_FINALIZED_TS	DateTime(26)	TIMESTAMP	Finalized Timestamp
11	GPCH_AH_NNSS	Character(20)	VARCHAR2(20) NOT NULL	New Social Insurance ID
12	BIRTHDATE	Date(10)	DATE	Date of Birth
13	GPCH_CA_REFNBR	Character(20)	VARCHAR2(20) NOT NULL	Zentral Reg Reference Number
14	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
15	GPCH_CA_STRNO_DONE	Character(1)	VARCHAR2(1) NOT NULL	Reduced End Date
16	GPCH_EG_ISSU_DAT	Date(10)	DATE	Issued Date.
17	SOURCE_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates the source of payable time. S - system generated U - User entered O - Offset O=Offset S=System Generated U=User Reported