EMPLIDPrompt Table: PERS_SRCH_GBL
BALANCE_GRP_NUMGPSG_TAX_YEARGPSG_CPY_TAX_REFPrompt Table: GPSG_IRAS_CPY
GPSG_BEN_TYPEU=Units
V=Value
GPSG_IR21_BNF(SQL Table) |
Index Back |
|---|---|
IR21 Appendix 1 BenefitsSingapore IRAS IR21 Appendix 1 Form - Benefits in Kind |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 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_TAX_YEAR |
Number(4,0) | SMALLINT NOT NULL | Tax Year for Singapore IRAS Reporting |
| 4 | GPSG_CPY_TAX_REF |
Character(11) | VARCHAR2(11) NOT NULL |
Singapore Company Tax Reference Number
Prompt Table: GPSG_IRAS_CPY |
| 5 | GPSG_BEN_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Benifit Types used in Singapore IRAS reporting |
| 6 | GPSG_BEN_UNIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Singapore IRAS Reporting Benefits Units Type
U=Units V=Value |
| 7 | GPSG_UNIT_CNT | Number(4,0) | SMALLINT NOT NULL | Singapore IRAS reporting of benefefits in kind - Number of units |
| 8 | GPSG_UNIT_CNT_1 | Number(4,0) | SMALLINT NOT NULL | Singapore IRAS reporting of benefefits in kind - Number of units |
| 9 | GPSG_UNIT_CNT_2 | Number(4,0) | SMALLINT NOT NULL | Singapore IRAS reporting of benefefits in kind - Number of units |
| 10 | GPSG_UNIT_VAL | Number(16,2) | DECIMAL(15,2) NOT NULL | Singapore IRAS reporting of benefefits in kind - value of benefit |
| 11 | GPSG_UNIT_VAL_1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Singapore IRAS reporting of benefefits in kind - value of benefit |
| 12 | GPSG_UNIT_VAL_2 | Number(16,2) | DECIMAL(15,2) NOT NULL | Singapore IRAS reporting of benefefits in kind - value of benefit |