GPCH_CA_XML_BEN (SQL Table)	Index Back
Child Allowance View CHE Overrides for eAHV: ReferenceNbr and Exclude

GPCH_CA_XML_BEN

(SQL Table)

Child Allowance View CHE

Overrides for eAHV: ReferenceNbr and Exclude

# 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 RUN_OPEN_TS DateTime(26) TIMESTAMP Records the time when processing was first initiated for a given calendar group

6 RUN_FINALIZED_TS DateTime(26) TIMESTAMP Finalized Timestamp

7 GPCH_AH_NNSS Character(20) VARCHAR2(20) NOT NULL New Social Insurance ID

8 BIRTHDATE Date(10) DATE Date of Birth

9 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

#	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	RUN_OPEN_TS	DateTime(26)	TIMESTAMP	Records the time when processing was first initiated for a given calendar group
6	RUN_FINALIZED_TS	DateTime(26)	TIMESTAMP	Finalized Timestamp
7	GPCH_AH_NNSS	Character(20)	VARCHAR2(20) NOT NULL	New Social Insurance ID
8	BIRTHDATE	Date(10)	DATE	Date of Birth
9	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