EMPLIDPrompt Table: PERS_SRCH_GBL
BALANCE_GRP_NUMGPSG_TAX_YEARGPSG_CPY_TAX_REFPrompt Table: GPSG_IRAS_CPY
GPSG_RES_TYPE1=Residence1
2=Residence2
Default Value: 1
F=Fully Furnished
S=Semi Furnished
F=Fully Furnished
S=Semi Furnished
GPSG_IR21_APP1(SQL Table) |
Index Back |
|---|---|
IR21 Appendix 1Singapore 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_RES_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Field created to verify Whether Accomodation is Fully Furnished or Semi Furnished.
1=Residence1 2=Residence2 Default Value: 1 |
| 6 | GPSG_ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Singapore IRAS Reporting address |
| 7 | GPSG_ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Singapore IRAS Reporting address |
| 8 | GPSG_ADDRESS3 | Character(30) | VARCHAR2(30) NOT NULL | Singapore IRAS Reporting address |
| 9 | GPSG_AP8A_RES_VAL | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Value of place of residence. |
| 10 | GPSG_AP8A_RES_VL_1 | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Value of place of residence. |
| 11 | GPSG_AP8A_RES_VL_2 | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Value of place of residence. |
| 12 | GPSG_AP8A_RES_FR | Date(10) | DATE | Singapore Appendix 8A Form (Benefits in Kind) - From date of occupation of residence. |
| 13 | GPSG_AP8A_RES_FR_1 | Date(10) | DATE | Singapore Appendix 8A Form (Benefits in Kind) - From date of occupation of residence. |
| 14 | GPSG_AP8A_RES_FR_2 | Date(10) | DATE | Singapore Appendix 8A Form (Benefits in Kind) - From date of occupation of residence. |
| 15 | GPSG_AP8A_RES_TO | Date(10) | DATE | Singapore Appendix 8A Form (Benefits in Kind) - To date of occupation of residence. |
| 16 | GPSG_AP8A_RES_TO_1 | Date(10) | DATE | Singapore Appendix 8A Form (Benefits in Kind) - To date of occupation of residence. |
| 17 | GPSG_AP8A_RES_TO_2 | Date(10) | DATE | Singapore Appendix 8A Form (Benefits in Kind) - To date of occupation of residence. |
| 18 | GPSG_AP8A_ER_RENT | Number(16,2) | DECIMAL(15,2) NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Rent paid by employer. |
| 19 | GPSG_AP8A_ER_RNT_1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Rent paid by employer. |
| 20 | GPSG_AP8A_ER_RNT_2 | Number(16,2) | DECIMAL(15,2) NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Rent paid by employer. |
| 21 | GPSG_AP8A_EE_RENT | Number(16,2) | DECIMAL(15,2) NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Rent paid by employee. |
| 22 | GPSG_AP8A_EE_RNT_1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Rent paid by employee. |
| 23 | GPSG_AP8A_EE_RNT_2 | Number(16,2) | DECIMAL(15,2) NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Rent paid by employee. |
| 24 | GPSG_AP8A_RES_SHR | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Number of persons sharing residence. |
| 25 | GPSG_AP8A_RES_SH_1 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Number of persons sharing residence. |
| 26 | GPSG_AP8A_RES_SH_2 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Number of persons sharing residence. |
| 27 | GPSG_AP8A_HTL_SLFN | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Self/Wife/Child > 20 years old - number of persons. |
| 28 | GPSG_AP8A_HTSLFN_1 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Self/Wife/Child > 20 years old - number of persons. |
| 29 | GPSG_AP8A_HTSLFN_2 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Self/Wife/Child > 20 years old - number of persons. |
| 30 | GPSG_AP8A_HTL_SLFD | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Self/Wife/Child > 20 years old - period provided (in days). |
| 31 | GPSG_AP8A_HTSLFD_1 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Self/Wife/Child > 20 years old - period provided (in days). |
| 32 | GPSG_AP8A_HTSLFD_2 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Self/Wife/Child > 20 years old - period provided (in days). |
| 33 | GPSG_AP8A_HTL_WIFN | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Self/Wife/Child > 20 years old - number of persons. |
| 34 | GPSG_AP8A_HTLWIFN1 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Self/Wife/Child > 20 years old - number of persons. |
| 35 | GPSG_AP8A_HTLWIFN2 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Self/Wife/Child > 20 years old - number of persons. |
| 36 | GPSG_AP8A_HTL_WIFD | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Self/Wife/Child > 20 years old - number of persons. |
| 37 | GPSG_AP8A_HTLWIFD1 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Self/Wife/Child > 20 years old - number of persons. |
| 38 | GPSG_AP8A_HTLWIFD2 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Self/Wife/Child > 20 years old - number of persons. |
| 39 | GPSG_AP8A_HTL_CH8N | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children 8 - 20 years old - number of persons. |
| 40 | GPSG_AP8A_HTCH8N_1 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children 8 - 20 years old - number of persons. |
| 41 | GPSG_AP8A_HTCH8N_2 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children 8 - 20 years old - number of persons. |
| 42 | GPSG_AP8A_HTL_CH8D | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children 8 - 20 years old - period provided (in days). |
| 43 | GPSG_AP8A_HTCH8D_1 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children 8 - 20 years old - period provided (in days). |
| 44 | GPSG_AP8A_HTCH8D_2 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children 8 - 20 years old - period provided (in days). |
| 45 | GPSG_AP8A_HTL_CH3N | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children 3 - 7 years old - number of persons. |
| 46 | GPSG_AP8A_HTCH3N_1 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children 3 - 7 years old - number of persons. |
| 47 | GPSG_AP8A_HTCH3N_2 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children 3 - 7 years old - number of persons. |
| 48 | GPSG_AP8A_HTL_CH3D | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children 3 - 7 years old - period provided (in days). |
| 49 | GPSG_AP8A_HTCH3D_1 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children 3 - 7 years old - period provided (in days). |
| 50 | GPSG_AP8A_HTCH3D_2 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children 3 - 7 years old - period provided (in days). |
| 51 | GPSG_AP8A_HTL_CH0N | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children under 3 years old - number of persons. |
| 52 | GPSG_AP8A_HTCH0N_1 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children under 3 years old - number of persons. |
| 53 | GPSG_AP8A_HTCH0N_2 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children under 3 years old - number of persons. |
| 54 | GPSG_AP8A_HTL_CH0D | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children under 3 years old - period provided (in days). |
| 55 | GPSG_AP8A_HTCH0D_1 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children under 3 years old - period provided (in days). |
| 56 | GPSG_AP8A_HTCH0D_2 | Number(3,0) | SMALLINT NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Hotel Accomodation for Children under 3 years old - period provided (in days). |
| 57 | GPSG_FURNISHED | Character(1) | VARCHAR2(1) NOT NULL |
Field created to verify Whether Accomodation is Furnished or Semi
Furnished
F=Fully Furnished S=Semi Furnished |
| 58 | GPSG_AP8A_EE_HTL | Number(18,2) | DECIMAL(17,2) NOT NULL | Amount paid by Employee(Hotel) |
| 59 | GPSG_AP8A_ER_HTL | Number(18,2) | DECIMAL(17,2) NOT NULL | Rent paid by Employer (Hotel) |
| 60 | GPSG_AP8A_RES_VL_P | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Singapore Appendix 8A Form (Benefits in Kind) - Value of place of residence. |
| 61 | GPSG_FURNISHED_1 | Character(1) | VARCHAR2(1) NOT NULL |
Field created to verify Whether Accomodation is Fully Furnished or Semi Furnished.
F=Fully Furnished S=Semi Furnished |
| 62 | GPSG_AP8A_EE_HTL_1 | Number(18,2) | DECIMAL(17,2) NOT NULL | Rent paid by Employee for hotel |
| 63 | GPSG_AP8A_ER_HTL_1 | Number(18,2) | DECIMAL(17,2) NOT NULL | Rent paid by Employer for Hotel |