GPCH_VGEN_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	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	GPCH_RC_PAY_YEAR	Number(4,0)	SMALLINT NOT NULL	Pay Year
6	GPCH_EG_DOMAINID	Number(3,0)	SMALLINT NOT NULL	Domain Set ID for the ELM Domain Sets
7	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 C=Base AL08 D=GRFI-FRFI E=EO-APG I=BNK_BNQ
8	GPCH_SI_PROV_CD	Character(6)	VARCHAR2(6) NOT NULL	Provider Code
9	GPCH_VIEWGEN_OVRD	Character(1)	VARCHAR2(1) NOT NULL	ViewGen Plugin Override A=Anonymizer P=Plausibility V=Validator
10	GPCH_VIEWGEN_PARAM	Character(100)	VARCHAR2(100) NOT NULL	GPCH_VIEWGEN_PARAM
11	APPCLASS_PATH	Character(254)	VARCHAR2(254) NOT NULL	Application Class Full Path
12	XML_NODE_PATH	Character(250)	VARCHAR2(250) NOT NULL	Node value
13	FILE_PATH	Character(127)	VARCHAR2(127) NOT NULL	Input/Output file path
14	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
15	FILE_PATH2	Character(127)	VARCHAR2(127) NOT NULL	File Path and Name
16	FILE_NAME2	Character(80)	VARCHAR2(80) NOT NULL	File Name
17	GROUP_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	Group List
18	GPCH_EG_SORT_1	Character(1)	VARCHAR2(1) NOT NULL	Sort Criteria 1. C=Residence Canton E=Emplid F=Firstname G=Language L=Lastname
19	GPCH_EG_SORT_2	Character(1)	VARCHAR2(1) NOT NULL	Sort Criteria 2. C=Residence Canton E=Emplid F=Firstname G=Language L=Lastname
20	GPCH_EG_SORT_3	Character(1)	VARCHAR2(1) NOT NULL	Sort Criteria 3. C=Residence Canton E=Emplid F=Firstname G=Language L=Lastname
21	GPCH_TX_CANTON	Character(2)	VARCHAR2(2) NOT NULL	Canton