GPSG_NID_TAX_VW(SQL View) |
Index Back |
---|---|
GP Singapore - Tax Ref IdSelects the National Id used as the Tax Reference Id for Singapore employees |
SELECT EMPLID , T.DESCRSHORT , N.NATIONAL_ID FROM PS_PERS_NID N , PS_NID_TYPE_TBL T WHERE N.TAX_REF_ID_SGP = 'Y' AND N.COUNTRY = 'SGP' AND T.COUNTRY = 'SGP' AND T.NATIONAL_ID_TYPE = N.NATIONAL_ID_TYPE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | GPSG_TAX_REF_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Singapore IRAS Tax Reference Id Type |
3 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |