| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
BALANCE_GRP_NUM |
Character(3) |
VARCHAR2(3) NOT NULL |
This field will be used to determine the grouping of balances from the different jobs of the employee.
|
| 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_8A_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Singapore IR8A/IR8S form Issue Status
W=Awaiting Issue
Y=Issued
Default Value: W
|
| 7 |
GPSG_CREATE_DATE |
Date(10) |
DATE |
Creation Date of Singapore IR8A data
|
| 8 |
GPSG_ISSUE_DATE |
Date(10) |
DATE |
Issue Date of Singapore IR8A data
|
| 9 |
GPSG_CPY_REF_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Singapore Company Tax Reference Type
|
| 10 |
NATIONAL_ID_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
National ID Type
|
| 11 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 12 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 13 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 14 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
|
| 15 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
|
| 16 |
GPSG_JOB_DESCR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Employee's job description for Singapore IRAS reporting
|
| 17 |
GPSG_JOB_DESCR2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Employee's other job description for Singapore IRAS reporting
|
| 18 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 19 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 20 |
GPSG_ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Singapore IRAS Reporting address
|
| 21 |
GPSG_ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Singapore IRAS Reporting address
|
| 22 |
GPSG_ADDRESS3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Singapore IRAS Reporting address
|
| 23 |
GPSG_8A_GROSS |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Gross Salary for IR8A reporting
|
| 24 |
GPSG_8A_CNT_BONUS |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Contractual Bonus amount for IR8A reporting
|
| 25 |
GPSG_8A_NC_BONUS |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Non-Contractual Bonus amount for IR8A reporting
|
| 26 |
GPSG_BONUS_DT |
Date(10) |
DATE |
Date Non-Contractual Bonus was declared, for use in Singapore IRAS reporting.
|
| 27 |
GPSG_8A_DIR_FEE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Directors Fees amount for IR8A reporting
|
| 28 |
GPSG_DIR_FEE_DT |
Date(10) |
DATE |
Date Director's Fees were approved, for use in Singapore IRAS reporting.
|
| 29 |
GPSG_8A_COMMSN |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Commission payments for IR8A reporting
|
| 30 |
GPSG_COMMSN_FROM |
Date(10) |
DATE |
From Date of period covered by Commission payments, for use in Singapore IRAS reporting.
|
| 31 |
GPSG_COMMSN_TO |
Date(10) |
DATE |
End Date of period covered by Commission payments, for use in Singapore IRAS reporting.
|
| 32 |
GPSG_COMMSN_REG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether Commission is paid regularly (monthly) or as a one-time payment for Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 33 |
GPSG_COMMSN_1TM |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether Commission is paid regularly (monthly) or as a one-time payment for Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 34 |
GPSG_8A_PENSION |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Pension payments for IR8A reporting
|
| 35 |
GPSG_8A_ALLOW_TRAN |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee'sTransport Allowance for IR8A reporting
|
| 36 |
GPSG_8A_ALLOW_ENT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Entertainment Allowance for IR8A reporting
|
| 37 |
GPSG_8A_ALLOW_OTH |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Other Allowances for IR8A reporting
|
| 38 |
GPSG_8A_ALLOW_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Total Allowances for IR8A reporting
|
| 39 |
GPSG_8A_GRATUITY |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Gratuity Payments for IR8A reporting
|
| 40 |
GPSG_8A_NOTICE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Payment in lieu of Notice for IR8A reporting
|
| 41 |
GPSG_8A_LOSS_OFFIC |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Payments for Loss of Office for IR8A reporting
|
| 42 |
GPSG_8A_GRAT_OTH |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore IRAS Reporting field: Lumpsum payment
|
| 43 |
GPSG_OTHER_REASON |
Character(50) |
VARCHAR2(50) NOT NULL |
Singapore IRAS Reporting: Reason of Lumpsum Payment
|
| 44 |
GPSG_OTHER_BASIS |
Character(50) |
VARCHAR2(50) NOT NULL |
Singapore IRAS Reporting: Basis of arriving at Lumpsum Payment
|
| 45 |
GPSG_RETIRE_FUND |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of Retirement Fund for Singapore IRAS reporting
|
| 46 |
GPSG_8A_RET_PRE93 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Retirement Benefit payment accrued up to 31/12/1992, for IR8A reporting
|
| 47 |
GPSG_8A_RET_POST |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Retirement Benefit payment accrued since 1/1/1993, for IR8A reporting
|
| 48 |
GPSG_8A_RETIRE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Retirement Benefit payments , for IR8A reporting
|
| 49 |
GPSG_8A_OS_PENSION |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Overseas Pension payments , for IR8A reporting
|
| 50 |
GPSG_OS_PENS_FUND |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of Overseas Pension Fund from which Pension payments have been recieved for Singapore IRAS reporting
|
| 51 |
GPSG_8A_SHARE_GAIN |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employees gain on value of share options , for IR8A reporting
|
| 52 |
GPSG_8A_BIK |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employees total value of benefits in kind, for IR8A reporting
|
| 53 |
GPSG_8A_INCOME_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employees total income, for IR8A reporting
|
| 54 |
GPSG_ER_PAYS_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the employer pays the employee's tax for Singapore IRAS reporting.
F=Tax fully borne by ER
H=Tax borne by EE
M=Not Applicable
N=No
O=Tax Partially borne by ER
P=Partial
Y=Yes
Default Value: N
|
| 55 |
GPSG_CPF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the employee is enrolled for CPF, for Singapore IRAS reporting.
C=CPF
N=None
O=Designated Fund
Default Value: N
|
| 56 |
GPSG_CPF_VOL_ER |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employers voluntary contributions to CPF for an employee , for IR8A reporting
|
| 57 |
GPSG_CPF_COMP_EE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employees compulsory contributions to CPF, for IR8A reporting
|
| 58 |
GPSG_CPF_VOL_EE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employees voluntary contributions to CPF, for IR8A reporting
|
| 59 |
GPSG_CPF_VOL_REAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates the reason for voluntary CPF contributions, for Singapore IRAS reporting.
N=None
O=Other
P=Overseas Posting
|
| 60 |
GPSG_PENS_FUND |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of Pension Fund in which employee is enrolled for Singapore IRAS reporting
|
| 61 |
GPSG_8A_DONATIONS |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employees total donations, for IR8A reporting
|
| 62 |
GPSG_8A_MBMF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that donations were made to MBMF by the employee for Singapore IRAS reporting.
|
| 63 |
GPSG_8A_MBF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that donations were made to MBMF by the employee for Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 64 |
GPSG_8A_YMF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that donations were made to MBMF by the employee for Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 65 |
GPSG_8A_CCHEST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that donations were made to Community Chest by the employee for Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 66 |
GPSG_8A_SINDA_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that donations were made to SINDA by the employee for Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 67 |
GPSG_8A_CDAC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that donations were made to CDAC by the employee for Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 68 |
GPSG_8A_ECF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that donations were made to ECF by the employee for Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 69 |
GPSG_8A_OTHDON_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that donations were made to other tax exempt funds by the employee for Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 70 |
GPSG_OS_FROM_DT |
Date(10) |
DATE |
Start Date of period during which employee was posted overseas, for use in Singapore IRAS reporting.
|
| 71 |
GPSG_OS_TO_DT |
Date(10) |
DATE |
End Date of period during which employee was posted overseas, for use in Singapore IRAS reporting.
|
| 72 |
GPSG_OS_CPF_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that CPF contributions are required by contract of employement while employee was posted overseas. For Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 73 |
GPSG_CPF_CAP_APPLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that capping has been applied to CPF contributions. For Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 74 |
GPSG_8S_CPF_VOL_ER |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employers voluntary contributions to CPF for reporting on IR8S form
|
| 75 |
GPSG_8S_CPF_VOL_EE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's voluntary contributions to CPF for reporting on IR8S form.
|
| 76 |
GPSG_CPF_VOL_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that Voluntary CPF contributions were required. For Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 77 |
GPSG_8A_INSURANCE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's Insurance amount for reporting on IR8A file.
|
| 78 |
GPSG_8A_INSUR_ADJ |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Singapore employee's adjustment to the Insurance amount for reporting on IR8A file.
|
| 79 |
GPSG_SECTION45_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the Section 45 is required, for Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 80 |
GPSG_IR21_ESOP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the ESOP deferral is applicable, for Singapore IRAS reporting.
Y/N Table Edit
Default Value: N
|
| 81 |
GPSG_GRAT_DESCR |
Character(200) |
VARCHAR2(200) NOT NULL |
Description of Gratuity or other Compensation payment for Singapore IRAS reporting.
|
| 82 |
GPSG_SHR_OPT_DESCR |
Character(200) |
VARCHAR2(200) NOT NULL |
Description of gains on share options for Singapore IRAS reporting.
|
| 83 |
GPSG_8S_REMARKS |
Character(200) |
VARCHAR2(200) NOT NULL |
Remarks for inclusion on Singapore IR8S reporting.
|
| 84 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 85 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 86 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 87 |
GPSG_IR8S_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether an IR8S form is required for this employee.
|
| 88 |
GPSG_TOTAL_MBMF |
Signed Number(24,2) |
DECIMAL(22,2) NOT NULL |
Total Contributions Deducted For MBMF
|
| 89 |
GPSG_8A_EXGRATIA |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
IR 8A - Ex-gratia amount
|
| 90 |
GPSG_PAYMNT_REASON |
Character(50) |
VARCHAR2(50) NOT NULL |
IR 8A - Reason of Payment
|
| 91 |
GPSG_BASIS_PAYMNT |
Character(50) |
VARCHAR2(50) NOT NULL |
IR 8A - Basis of Payment
|
| 92 |
GPSG_CPF_CONT |
Character(1) |
VARCHAR2(1) NOT NULL |
If approval has been obtained from CPF to make Full Contribution
N=No
Y=Yes
|
| 93 |
GPSG_REN_PR_DT |
Date(10) |
DATE |
Date of Renouncement of SGP Permanent Residency
|
| 94 |
GPSG_APP_IRAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval obtained from IRAS.
N=No
Y=Yes
|
| 95 |
GPSG_APP_IRAS_DT |
Date(10) |
DATE |
Date of approval obtained from IRAS.
|
| 96 |
GPSG_BANK_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Name of the bank.
1=DBS/POSB
2=UOB/OUB
3=OCBC
4=Others
|
| 97 |
GPSG_DIVISION |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of the Division/Branch.g
|
| 98 |
GPSG_EXM_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt Income/Remission Indicator.
1=Tax Remission on OCLA
2=Tax remission on OHQ
2=Tax remission on OHQ
3=Seaman
4=Exemption
5=OS Pen.Fund - Tax Concession
6=Income from OS Employment
7=Income-OS Employment&Pen.Fund
N=Not Applicable
Default Value: N
|
| 99 |
GPSG_INCOM_TAX_EE |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Fixed amount of income tax liability for which tax is borne by the employee.
|
| 100 |
GPSG_INCOM_TAX_ER |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount of employment income for which tax is borne by the employer.
|
| 101 |
GPSG_8A_GAIN_BFR |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Gains and Profits from Share Options before 2003
|
| 102 |
GPSG_INCOM_TAX_REM |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Exempt Income/Income subject to Tax Remission.
|