GPTH_SSO110_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	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
8	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
9	YEAR	Character(4)	VARCHAR2(4) NOT NULL	Character field to represent a year
10	FROMDATE	Date(10)	DATE	From Date
11	THRUDATE	Date(10)	DATE	End Date
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	ASOFDATE	Date(10)	DATE	As of Date
14	GPTH_DOWN_TO_TXT	Character(1)	VARCHAR2(1) NOT NULL	This field represents that if the report need a Data Media File Default Value: N
15	GPTH_COVER_PAGE	Character(1)	VARCHAR2(1) NOT NULL	This field represent that if the report need an Cover Page Default Value: Y
16	GPTH_DETAIL_PAGE	Character(1)	VARCHAR2(1) NOT NULL	This field represents that if the report need a detail page Default Value: N
17	PROCESSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	GPTH_SI_BRANCH_NO	Character(6)	VARCHAR2(6) NOT NULL	Social Security Branch Number
19	GPTH_MONTH	Character(7)	VARCHAR2(7) NOT NULL	GPTH_MONTH