GPSG_IR21_DTL(SQL Table) |
Index Back |
|---|---|
IR21 Form detail recordSingapore IRAS Form IR21 (termination of foreign employee) details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | 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. |
| 3 | GPSG_CPY_TAX_REF |
Character(11) | VARCHAR2(11) NOT NULL | Singapore Company Tax Reference Number |
| 4 | GPSG_TAX_YEAR |
Number(4,0) | SMALLINT NOT NULL | Tax Year for Singapore IRAS Reporting |
| 5 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 6 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 7 | GPSG_IR21_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Singapore IRAS Form IR21 Type
D=Additional M=Amended O=Original |
| 8 | GPSG_TAX_YR_START | Date(10) | DATE | Tax Year Start Date for Singapore IRAS Reporting |
| 9 | GPSG_TAX_YR_STRT_1 | Date(10) | DATE | Tax Year Start Date for Singapore IRAS Reporting |
| 10 | GPSG_TAX_YR_STRT_2 | Date(10) | DATE | Tax Year Start Date for Singapore IRAS Reporting |
| 11 | GPSG_TAX_YR_END | Date(10) | DATE | Tax Year End Date for Singapore IRAS Reporting |
| 12 | GPSG_TAX_YR_END_1 | Date(10) | DATE | Tax Year End Date for Singapore IRAS Reporting |
| 13 | GPSG_TAX_YR_END_2 | Date(10) | DATE | Tax Year End Date for Singapore IRAS Reporting |
| 14 | GPSG_8A_INCOME_TOT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees total income, for IR8A reporting |
| 15 | GPSG_8A_INC_TOT_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees total income, for IR8A reporting |
| 16 | GPSG_8A_INC_TOT_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees total income, for IR8A reporting |
| 17 | GPSG_8A_CNT_BONUS | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Contractual Bonus amount for IR8A reporting |
| 18 | GPSG_8A_CNT_BNS_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Contractual Bonus amount for IR8A reporting |
| 19 | GPSG_8A_CNT_BNS_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Contractual Bonus amount for IR8A reporting |
| 20 | GPSG_8A_NC_BONUS | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Non-Contractual Bonus amount for IR8A reporting |
| 21 | GPSG_8A_NC_BNS_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Non-Contractual Bonus amount for IR8A reporting |
| 22 | GPSG_8A_NC_BNS_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Non-Contractual Bonus amount for IR8A reporting |
| 23 | GPSG_BONUS_DT | Date(10) | DATE | Date Non-Contractual Bonus was declared, for use in Singapore IRAS reporting. |
| 24 | GPSG_8A_DIR_FEE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Directors Fees amount for IR8A reporting |
| 25 | GPSG_8A_DIR_FEE_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Directors Fees amount for IR8A reporting |
| 26 | GPSG_8A_DIR_FEE_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Directors Fees amount for IR8A reporting |
| 27 | GPSG_DIR_FEE_DT | Date(10) | DATE | Date Director's Fees were approved, for use in Singapore IRAS reporting. |
| 28 | GPSG_8A_COMMSN | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Commission payments for IR8A reporting |
| 29 | GPSG_8A_COMMSN_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Commission payments for IR8A reporting |
| 30 | GPSG_8A_COMMSN_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Commission payments for IR8A reporting |
| 31 | GPSG_8A_ALLOW_TOT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Total Allowances for IR8A reporting |
| 32 | GPSG_8A_ALLW_TOT_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Total Allowances for IR8A reporting |
| 33 | GPSG_8A_ALLW_TOT_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Total Allowances for IR8A reporting |
| 34 | GPSG_8A_GRATUITY | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Gratuity Payments for IR8A reporting |
| 35 | GPSG_8A_GRATUITY_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Gratuity Payments for IR8A reporting |
| 36 | GPSG_8A_GRATUITY_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Gratuity Payments for IR8A reporting |
| 37 | GPSG_8A_NOTICE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Payment in lieu of Notice for IR8A reporting |
| 38 | GPSG_8A_NOTICE_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Payment in lieu of Notice for IR8A reporting |
| 39 | GPSG_8A_NOTICE_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Payment in lieu of Notice for IR8A reporting |
| 40 | GPSG_8A_LOSS_OFFIC | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Payments for Loss of Office for IR8A reporting |
| 41 | GPSG_8A_LOSS_OFF_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Payments for Loss of Office for IR8A reporting |
| 42 | GPSG_8A_LOSS_OFF_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Payments for Loss of Office for IR8A reporting |
| 43 | GPSG_8A_RETIRE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Retirement Benefit payments , for IR8A reporting |
| 44 | GPSG_8A_RETIRE_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Retirement Benefit payments , for IR8A reporting |
| 45 | GPSG_8A_RETIRE_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Retirement Benefit payments , for IR8A reporting |
| 46 | GPSG_RETIRE_FUND | Character(30) | VARCHAR2(30) NOT NULL | Name of Retirement Fund for Singapore IRAS reporting |
| 47 | GPSG_8A_OS_PENSION | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Overseas Pension payments , for IR8A reporting |
| 48 | GPSG_8A_OS_PENS_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employee's Overseas Pension payments , for IR8A reporting |
| 49 | GPSG_8A_OS_PENS_2 | 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_CPF_VOL_ER | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employers voluntary contributions to CPF for an employee , for IR8A reporting |
| 52 | GPSG_CPF_VOL_ER_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employers voluntary contributions to CPF for an employee , for IR8A reporting |
| 53 | GPSG_CPF_VOL_ER_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employers voluntary contributions to CPF for an employee , for IR8A reporting |
| 54 | GPSG_8A_SHARE_GAIN | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees gain on value of share options , for IR8A reporting |
| 55 | GPSG_8A_SHARE_GN_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees gain on value of share options , for IR8A reporting |
| 56 | GPSG_8A_SHARE_GN_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees gain on value of share options , for IR8A reporting |
| 57 | GPSG_ESOP_APPLIC | Character(1) | VARCHAR2(1) NOT NULL |
ESOP Applicable flag
Y/N Table Edit Default Value: N |
| 58 | GPSG_8A_BIK | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees total value of benefits in kind, for IR8A reporting |
| 59 | GPSG_8A_BIK_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees total value of benefits in kind, for IR8A reporting |
| 60 | GPSG_8A_BIK_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees total value of benefits in kind, for IR8A reporting |
| 61 | GPSG_CPF_COMP_EE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees compulsory contributions to CPF, for IR8A reporting |
| 62 | GPSG_CPF_COMP_EE_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees compulsory contributions to CPF, for IR8A reporting |
| 63 | GPSG_CPF_COMP_EE_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees compulsory contributions to CPF, for IR8A reporting |
| 64 | GPSG_PENS_FUND | Character(30) | VARCHAR2(30) NOT NULL | Name of Pension Fund in which employee is enrolled for Singapore IRAS reporting |
| 65 | GPSG_CPF_VOL_EE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees voluntary contributions to CPF, for IR8A reporting |
| 66 | GPSG_CPF_VOL_EE_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees voluntary contributions to CPF, for IR8A reporting |
| 67 | GPSG_CPF_VOL_EE_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees voluntary contributions to CPF, for IR8A reporting |
| 68 | GPSG_8A_DONATIONS | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees total donations, for IR8A reporting |
| 69 | GPSG_8A_DONATNS_1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees total donations, for IR8A reporting |
| 70 | GPSG_8A_DONATNS_2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Singapore employees total donations, for IR8A reporting |
| 71 | GPSG_TOTAL_MBMF | Signed Number(24,2) | DECIMAL(22,2) NOT NULL | Total Contributions Deducted For MBMF |
| 72 | GPSG_TOTAL_MBMF_1 | Signed Number(24,2) | DECIMAL(22,2) NOT NULL | Stores the value of MBF of last year |
| 73 | GPSG_8A_MBMF_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 |
| 74 | 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 |
| 75 | 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 |
| 76 | 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 |
| 77 | 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 |
| 78 | 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 |