GPMY_CP22_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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	GPMY_ORG_LINK_OPTN	Character(2)	VARCHAR2(2) NOT NULL	Organizational Link Option CO=Company DE=Department ET=Establishment LO=Location PG=Pay Group
6	GPMY_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	ORG_LINK_UNIT	Character(12)	VARCHAR2(12) NOT NULL	Contains ID of an org unit to which a source bank is assigned. can be Company, Dept, Location, Pay Group or Pay Entity ID
8	GPMY_TAX_NBR	Character(12)	VARCHAR2(12) NOT NULL	GPMY_TAX_NBR
9	GPMY_FROM_DT	Date(10)	DATE	From Date
10	GPMY_TO_DT	Date(10)	DATE	To Date
11	GPMY_REGISTERED_NM	Character(50)	VARCHAR2(50) NOT NULL	Registered Name
12	GPMY_EMPL_TAX_NBR	Character(16)	VARCHAR2(16) NOT NULL	Tax Reference Number
13	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
14	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
15	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
16	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
17	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
18	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
19	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
20	COUNTRY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Country Description
21	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
22	GPMY_BUS_EMAIL	Character(70)	VARCHAR2(70) NOT NULL	Employee Email address
23	GPMY_WHR_VALUE	Character(150)	VARCHAR2(150) NOT NULL	Dynamic where clause
24	GPMY_WHR_VALUE1	Character(150)	VARCHAR2(150) NOT NULL	Dynamic where clause
25	GPMY_WHR_VALUE2	Character(150)	VARCHAR2(150) NOT NULL	Dynamic where clause
26	GPMY_WHR_VALUE3	Character(150)	VARCHAR2(150) NOT NULL	Dynamic where clause