GPCHINS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	GPCH_EG_YEP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to check whether the Reports are Run from Year End Dashboard
5	GPCH_EG_DOMAINID	Number(3,0)	SMALLINT NOT NULL	Domain Set ID for the ELM Domain Sets
6	GPCH_EG_REQUEST_ID	Character(30)	VARCHAR2(30) NOT NULL	Holds Request ID in the ELM File
7	GPCH_RUN_OPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Run Options for Individual Reports in Year end Processing N=NO Y=YES
8	GPCH_CANCEL_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Cancel Option
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
11	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
12	GPCH_RC_PAY_YEAR	Number(4,0)	SMALLINT NOT NULL	Pay Year
13	GPCH_RC_FROM_DT	Date(10)	DATE	From Date
14	GPCH_RC_TO_DT	Date(10)	DATE	To Date
15	GPCH_RC_ADJUST_DT	Date(10)	DATE	Use for the report GPCHSI08
16	GPCH_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
17	GPCH_RC_RUN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Run Type A=Interface B=Print C=Interface and Print D=Finalise E=Print Earlier Version
18	GPCH_TX_FLG	Character(1)	VARCHAR2(1) NOT NULL	Field to check if run from classic
19	GPCH_SI_PROV_CD	Character(6)	VARCHAR2(6) NOT NULL	Provider Code
20	GPCH_PK_INS_PLAN	Character(2)	VARCHAR2(2) NOT NULL	PK Insurance Plan
21	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
22	GPCH_PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number