GPCH_EG_PSTATUS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	GPCH_RC_PAY_YEAR	Number(4,0)	SMALLINT NOT NULL	Pay Year
3	GPCH_EG_DOMAINID	Number(3,0)	SMALLINT NOT NULL	Domain Set ID for the ELM Domain Sets
4	GPCH_EG_REQUEST_ID	Character(30)	VARCHAR2(30) NOT NULL	Holds Request ID in the ELM File
5	GPCH_SI_PROV_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Provider Type 0=Identify 1=Others 2=UVG-LAA 3=KTG-AMC 4=UVGZ-LAAC 5=FAK-CAF 6=BVG-LPP 7=AHV-AVS 8=LAW-CDS 9=BFS-OFS A=QST-IS B=Write File E=EO-APG
6	GPCH_SI_PROV_CD	Character(6)	VARCHAR2(6) NOT NULL	Provider Code
7	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
8	GPCH_EG_USERKEY	Character(2)	VARCHAR2(2) NOT NULL	GPCH ELM Userkey to Specify Canton
9	GPCH_EG_RESPONSEID	Character(30)	VARCHAR2(30) NOT NULL	Response ID for ELM
10	GPCH_REPORT_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Report Status for Year End Process 0001=Success 0002=Accepted 0003=Warning 0004=Error 0005=Soap Fault 0006=Fault 0007=Ignored 0008=Open 0009=N 0010=File Error
11	GPCH_EG_COMPLETE	Character(1)	VARCHAR2(1) NOT NULL	GPCH ELM Complete Flag Y/N Table Edit Default Value: N
12	FILE_DATA_CHAR	Long Character(32000)	CLOB	File Data
13	GPCH_EG_SNT_TIME	DateTime(26)	TIMESTAMP	GPCH:ELM File Sent TimeStamp
14	GPCH_EG_RCV_TIME	DateTime(26)	TIMESTAMP	Time at which the ELM file is Recieved
15	GPCH_EG_RESEND	Character(1)	VARCHAR2(1) NOT NULL	GPCH ELM Flag for Resend Y/N Table Edit Default Value: N
16	GPCH_EG_REQID_OLD	Character(30)	VARCHAR2(30) NOT NULL	Old Request ID for ELM
17	GPCH_EG_RESPID_OLD	Character(30)	VARCHAR2(30) NOT NULL	Old Response Id for ELM file