GPSG_FA_PST_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 Prompt Table: GP_PYGRP
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id Prompt Table: GPSG_FA_CAL_VW
6	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
7	GPSG_FA_PROC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	GP Singapore Festive Advance interface processing type (Post or Unpost) P=Post U=Unpost
8	FA_CHINESE_NY	Character(1)	VARCHAR2(1) NOT NULL	Chinese New Year Y/N Table Edit Default Value: N
9	FA_CHRISTMAS	Character(1)	VARCHAR2(1) NOT NULL	Festive Advance Type Christmas Y/N Table Edit Default Value: N
10	FA_DEEPAVALI	Character(1)	VARCHAR2(1) NOT NULL	Festive Advance Deepavali Y/N Table Edit
11	FA_HARI_RAYA	Character(1)	VARCHAR2(1) NOT NULL	Festive Advance Type Hari Raya Y/N Table Edit
12	YEARCD	Character(4)	VARCHAR2(4) NOT NULL	Calendar Year
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
15	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
16	PRD_END_DT	Date(10)	DATE	Pay Period End Date
17	GPSG_TYPE_LIST	Character(24)	VARCHAR2(24) NOT NULL	List of FA Types to dynamically specify FA Holiday Types to be selected by GP FA Posting SQL.
18	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
19	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
20	FA_TYPE	Character(3)	VARCHAR2(3) NOT NULL	This field will define the Festive Advance Holiday Type. CHR=Christmas CNY=Chinese New Year DEP=Deepavali HAR=Hari Raya N=Value Not Applicable
21	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id