| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID
|
| 3 |
GPSG_CPY_TAX_REF |
Character(11) |
VARCHAR2(11) NOT NULL |
Singapore Company Tax Reference Number
Prompt Table:
GPSG_IRAS_CPY
|
| 4 |
GPSG_TAX_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Tax Year for Singapore IRAS Reporting
|
| 5 |
GPSG_RECREATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Recreate option for Singapore IRAS processes run control
Y/N Table Edit
Default Value: N
|
| 6 |
GPSG_CREATE_DATE |
Date(10) |
DATE NOT NULL |
Creation Date of Singapore IR8A data
Default Value: %Date
|
| 7 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GPSG_PYGRP_VW
|
| 8 |
GPSG_AP8A_4B |
Character(1) |
VARCHAR2(1) NOT NULL |
Singapore IRAS Appendix 8A - indicates if amount category 4B (Interest) is to be recalculated.
Y/N Table Edit
Default Value: Y
|
| 9 |
GPSG_AP8A_4C |
Character(1) |
VARCHAR2(1) NOT NULL |
Singapore IRAS Appendix 8A - indicates if amount category 4C (Life Insurance) is to be recalculated.
Y/N Table Edit
Default Value: Y
|
| 10 |
GPSG_AP8A_4D |
Character(1) |
VARCHAR2(1) NOT NULL |
Singapore IRAS Appendix 8A - indicates if amount category 4D (Holiday Passages) is to be recalculated.
Y/N Table Edit
Default Value: Y
|
| 11 |
GPSG_AP8A_4E |
Character(1) |
VARCHAR2(1) NOT NULL |
Singapore IRAS Appendix 8A - indicates if amount category 4E (Education Expenses) is to be recalculated.
Y/N Table Edit
Default Value: Y
|
| 12 |
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.
Y/N Table Edit
Default Value: Y
|
| 13 |
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.
Y/N Table Edit
Default Value: Y
|
| 14 |
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.
Y/N Table Edit
Default Value: Y
|
| 15 |
GPSG_AP8A_4I |
Character(1) |
VARCHAR2(1) NOT NULL |
Singapore IRAS Appendix 8A - indicates if amount category 4I (Motor Vehicles) is to be recalculated.
Y/N Table Edit
Default Value: Y
|
| 16 |
GPSG_AP8A_4J |
Character(1) |
VARCHAR2(1) NOT NULL |
Singapore IRAS Appendix 8A - indicates if amount category 4J (Car Benefits) is to be recalculated.
Y/N Table Edit
Default Value: Y
|
| 17 |
GPSG_AP8A_4K |
Character(1) |
VARCHAR2(1) NOT NULL |
Singapore IRAS Appendix 8A - indicates if amount category 4K (Other Benefits) is to be recalculated.
Y/N Table Edit
Default Value: Y
|
| 18 |
GPSG_EMPL_ORDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Order option for Singapore IRAS reporting processes run control
E=Employee ID
N=Name
T=Tax Reference Number
Default Value: N
|
| 19 |
GPSG_APP8A_ORDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Order option for Singapore Appendix 8A reporting process run control
E=Employee ID
N=Name
Default Value: E
|
| 20 |
GPSG_IR21_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag indicates if the current process is creating IR21 forms or not.
Default Value: N
|
| 21 |
GPSG_FROM_DT |
Date(10) |
DATE |
From Date for IRAS Run Control
|
| 22 |
GPSG_TO_DT |
Date(10) |
DATE |
To Date for IRAS Run Control
|
| 23 |
GPSG_BONUS_DT |
Date(10) |
DATE |
Date Non-Contractual Bonus was declared, for use in Singapore IRAS reporting.
|
| 24 |
GPSG_DIR_FEE_DT |
Date(10) |
DATE |
Date Director's Fees were approved, for use in Singapore IRAS reporting.
|
| 25 |
GPSG_COMMSN_FROM |
Date(10) |
DATE |
From Date of period covered by Commission payments, for use in Singapore IRAS reporting.
|
| 26 |
GPSG_COMMSN_TO |
Date(10) |
DATE |
End Date of period covered by Commission payments, for use in Singapore IRAS reporting.
|
| 27 |
GPSG_REPRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reprint option for Singapore IRAS processes run control
Y/N Table Edit
Default Value: N
|
| 28 |
GPSG_DEPT_PRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Department option for Singapore IRAS processes run control
Y/N Table Edit
Default Value: N
|
| 29 |
GPSG_NAME_PRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee name sort option for Singapore IRAS processes run control
Y/N Table Edit
Default Value: N
|
| 30 |
GPSG_PGRP_PRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Group sort option for Singapore IRAS processes run control
Y/N Table Edit
Default Value: N
|
| 31 |
GPSG_COMMENTS_PRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Comments print option for Singapore IRAS processes run control
Y/N Table Edit
Default Value: N
|
| 32 |
GPSG_IR21_APP1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag indicates if the IR21 create process should also create the Appendix 1 data.
Y/N Table Edit
Default Value: Y
|
| 33 |
GPSG_FORM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to select whether the form is IR8A or IR8E
A=Form IR8A
E=Form IR8E
|
| 34 |
GPSG_RECREATE_IR21 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recreate option for Singapore IR21 creation process
Y/N Table Edit
Default Value: N
|
| 35 |
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
|
| 36 |
GPSG_A_END_DATE |
Date(10) |
DATE |
Creation Date of Singapore IR8A data
|