GPDE_TA_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	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_PYENT
5	GPDE_RC_REPORTNAME	Character(8)	VARCHAR2(8) NOT NULL	Print Class
6	FROMDATE	Date(10)	DATE	From Date Default Value: %date
7	THRUDATE	Date(10)	DATE	End Date Default Value: %date
8	GPDE_TA_FILE_NAME1	Character(30)	VARCHAR2(30) NOT NULL	Tax Auditor Access
9	GPDE_TA_EXTENSION1	Character(10)	VARCHAR2(10) NOT NULL	Tax Auditor Access
10	GPDE_TA_FILE_NAME2	Character(30)	VARCHAR2(30) NOT NULL	Tax Auditor Access
11	GPDE_TA_EXTENSION2	Character(10)	VARCHAR2(10) NOT NULL	Tax Auditor Access
12	GPDE_TA_HTML_FILE	Character(30)	VARCHAR2(30) NOT NULL	Tax Auditor Access
13	GPDE_TA_EXTENSION3	Character(10)	VARCHAR2(10) NOT NULL	Tax Auditor Access
14	GPDE_TA_MEDIA	Character(30)	VARCHAR2(30) NOT NULL	Tax Auditor Access
15	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
16	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
17	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
18	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
19	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
20	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
21	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
22	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
23	PRD_END_DT	Date(10)	DATE	Pay Period End Date
24	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
25	GPDE_RP_DBA_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Double Taxation Agreement YTD
26	GPDE_RP_ATE_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Expatriate Agreement GrossYTD
27	BEGIN_DT	Date(10)	DATE	Begin Date
28	END_DT	Date(10)	DATE	end date
29	GPDE_TA_CALC_VAL1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Tax Auditor Access
30	GPDE_TA_CALC_VAL2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Tax Auditor Access
31	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
32	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
33	GPDE_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
34	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
35	GPDE_TA_FIELD_NBR	Number(2,0)	SMALLINT NOT NULL	Descr
36	COUNTER	Signed Number(6,0)	DECIMAL(5) NOT NULL	Counter