GPSG_IRAS_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	GPSG_CPY_TAX_REF	Character(11)	VARCHAR2(11) NOT NULL	Singapore Company Tax Reference Number
5	GPSG_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year for Singapore IRAS Reporting
6	GPSG_RECREATE	Character(1)	VARCHAR2(1) NOT NULL	Recreate option for Singapore IRAS processes run control
7	GPSG_CREATE_DATE	Date(10)	DATE	Creation Date of Singapore IR8A data
8	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
9	GPSG_TAX_YR_START	Date(10)	DATE	Tax Year Start Date for Singapore IRAS Reporting
10	GPSG_TAX_YR_END	Date(10)	DATE	Tax Year End Date for Singapore IRAS Reporting
11	GPSG_EMPL_LIST	Character(1)	VARCHAR2(1) NOT NULL	Indicates that specific employees are listed for inclusion in the Singapore IRAS processes.
12	GPSG_AP8A_4B	Character(1)	VARCHAR2(1) NOT NULL	Singapore IRAS Appendix 8A - indicates if amount category 4B (Interest) is to be recalculated.
13	GPSG_AP8A_4C	Character(1)	VARCHAR2(1) NOT NULL	Singapore IRAS Appendix 8A - indicates if amount category 4C (Life Insurance) is to be recalculated.
14	GPSG_AP8A_4D	Character(1)	VARCHAR2(1) NOT NULL	Singapore IRAS Appendix 8A - indicates if amount category 4D (Holiday Passages) is to be recalculated.
15	GPSG_AP8A_4E	Character(1)	VARCHAR2(1) NOT NULL	Singapore IRAS Appendix 8A - indicates if amount category 4E (Education Expenses) is to be recalculated.
16	GPSG_AP8A_4F	Character(1)	VARCHAR2(1) NOT NULL	Singapore IRAS Appendix 8A - indicates if amount category 4F (Long Service Awards) is to be recalculated.
17	GPSG_AP8A_4G	Character(1)	VARCHAR2(1) NOT NULL	Singapore IRAS Appendix 8A - indicates if amount category 4G (Club Subscription & Fees) is to be recalculated.
18	GPSG_AP8A_4H	Character(1)	VARCHAR2(1) NOT NULL	Singapore IRAS Appendix 8A - indicates if amount category 4H (Gain on sale of assets) is to be recalculated.
19	GPSG_AP8A_4I	Character(1)	VARCHAR2(1) NOT NULL	Singapore IRAS Appendix 8A - indicates if amount category 4I (Motor Vehicles) is to be recalculated.
20	GPSG_AP8A_4J	Character(1)	VARCHAR2(1) NOT NULL	Singapore IRAS Appendix 8A - indicates if amount category 4J (Car Benefits) is to be recalculated.
21	GPSG_AP8A_4K	Character(1)	VARCHAR2(1) NOT NULL	Singapore IRAS Appendix 8A - indicates if amount category 4K (Other Benefits) is to be recalculated.
22	GPSG_IR21_PROC	Character(1)	VARCHAR2(1) NOT NULL	Flag indicates if the current process is creating IR21 forms or not. Default Value: N
23	GPSG_FROM_DT	Date(10)	DATE	From Date for IRAS Run Control
24	GPSG_TO_DT	Date(10)	DATE	To Date for IRAS Run Control
25	GPSG_BONUS_DT	Date(10)	DATE	Date Non-Contractual Bonus was declared, for use in Singapore IRAS reporting.
26	GPSG_DIR_FEE_DT	Date(10)	DATE	Date Director's Fees were approved, for use in Singapore IRAS reporting.
27	GPSG_COMMSN_FROM	Date(10)	DATE	From Date of period covered by Commission payments, for use in Singapore IRAS reporting.
28	GPSG_COMMSN_TO	Date(10)	DATE	End Date of period covered by Commission payments, for use in Singapore IRAS reporting.
29	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type
30	ORDER_BY_SEQ	Number(2,0)	SMALLINT NOT NULL	Added in Mouse Over Label
31	GPSG_FORM_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field is used to select whether the form is IR8A or IR8E A=Amendment C=IR8A/IR8S
32	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
33	FIELDNAME1	Character(18)	VARCHAR2(18) NOT NULL	Field Name 1
34	FIELDNAME2	Character(18)	VARCHAR2(18) NOT NULL	Field Name 2