GPCHUTALL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
4	GPCH_AL_PIN_CNT	Number(3,0)	SMALLINT NOT NULL	Pin Counter
5	GPCH_AL_RUN_CNT	Number(3,0)	SMALLINT NOT NULL	Run Control Counter
6	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
7	GPCH_RC_FROM_DT	Date(10)	DATE	From Date
8	GPCH_RC_TO_DT	Date(10)	DATE	To Date
9	GPCH_RC_INC_P_CALC	Character(1)	VARCHAR2(1) NOT NULL	Include Pending Calculations
10	GPCH_AL_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record Name
11	GPCH_AL_RECNAME1	Character(15)	VARCHAR2(15) NOT NULL	Record Name
12	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
13	GPCH_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
14	GPCH_AL_BASE_LANG	Character(3)	VARCHAR2(3) NOT NULL	Base Language
15	GPCH_AL_RPT_LANG	Character(3)	VARCHAR2(3) NOT NULL	Report Language
16	GPCH_RC_REPORTNAME	Character(8)	VARCHAR2(8) NOT NULL	Print Class
17	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type
18	GPCH_RC_PAY_YEAR	Number(4,0)	SMALLINT NOT NULL	Pay Year
19	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag
20	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
21	GPCH_LOOP	Number(3,0)	SMALLINT NOT NULL	Loop
22	PAY_ENTITY_CRITERA	Long Character	CLOB	Pay Entity Criterya