GPSG_IR21_HDR(SQL Table) |
Index Back |
---|---|
IR21 Form headerSingapore IRAS Form IR21 (termination of foreign employee) header 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 | GPSG_8A_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Singapore IR8A/IR8S form Issue Status
W=Awaiting Issue Y=Issued |
6 | GPSG_ISSUE_DATE | Date(10) | DATE | Issue Date of Singapore IR8A data |
7 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
8 | GPSG_REGISTERED_NM | Character(70) | VARCHAR2(70) NOT NULL | Name of company registered with Singapore IRAS |
9 | GPSG_ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Singapore IRAS Reporting address |
10 | GPSG_ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Singapore IRAS Reporting address |
11 | GPSG_ADDRESS3 | Character(30) | VARCHAR2(30) NOT NULL | Singapore IRAS Reporting address |
12 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
13 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL | Name Prefix |
14 | NATIONAL_ID_TYPE | Character(6) | VARCHAR2(6) NOT NULL | National ID Type |
15 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
16 | PERM_STATUS_DT_SGP | Date(10) | DATE | Permanent Status Date |
17 | GPSG_ADDRESS1_OTH | Character(30) | VARCHAR2(30) NOT NULL | Singapore IRAS Reporting address |
18 | GPSG_ADDRESS2_OTH | Character(30) | VARCHAR2(30) NOT NULL | Singapore IRAS Reporting address |
19 | GPSG_ADDRESS3_OTH | Character(30) | VARCHAR2(30) NOT NULL | Singapore IRAS Reporting address |
20 | BIRTHDATE | Date(10) | DATE | Date of Birth |
21 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
22 | NATIONALITY | Character(30) | VARCHAR2(30) NOT NULL | Nationality |
23 | 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 |
24 | MAR_STATUS_DT | Date(10) | DATE | This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */ |
25 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
26 | JOB_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Description |
27 | GPSG_ARRIVAL_DT | Date(10) | DATE | Arrival date in Singapore. |
28 | HIRE_DT | Date(10) | DATE | First Start Date |
29 | TERMINATION_DT | Date(10) | DATE | Termination Date |
30 | GPSG_DEPART_DT | Date(10) | DATE | Departure date from Singapore. |
31 | GPSG_RESIG_DT | Date(10) | DATE | Date of resignation |
32 | GPSG_CESS_RSN | Character(30) | VARCHAR2(30) NOT NULL | Reason for cessation of employment |
33 | COMP_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly |
34 | GPSG_MTH_CESS_RSN | Character(30) | VARCHAR2(30) NOT NULL | Reason for month's notice of cessation of employment |
35 | GPSG_TAX_WHELD | Number(16,2) | DECIMAL(15,2) NOT NULL | Amount of tax withheld |
36 | GPSG_LAST_PAY_DT | Date(10) | DATE | Date Last Salary Paid |
37 | GPSG_LAST_SAL | Number(16,2) | DECIMAL(15,2) NOT NULL | Amount of last salary |
38 | GPSG_PERIOD | Character(30) | VARCHAR2(30) NOT NULL | Period of last payment |
39 | GPSG_NONE_WHELD | Character(30) | VARCHAR2(30) NOT NULL | Reason tax not withheld from final pay |
40 | GPSG_BASIS_WHELD | Character(30) | VARCHAR2(30) NOT NULL | Basis on which tax withheld from final pay |
41 | GPSG_EMPL_BANK | Character(30) | VARCHAR2(30) NOT NULL | Name of bank to which employees salary is deposited |
42 | GPSG_IR21_EMPLR | Character(30) | VARCHAR2(30) NOT NULL | Employer name |
43 | 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 |
44 | GPSG_SPOUSE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Name of spouse |
45 | GPSG_SPOUSE_BDATE | Date(10) | DATE | Spouse's birth date |
46 | GPSG_SPOUSE_ID | Character(20) | VARCHAR2(20) NOT NULL | Spouse's ID Number |
47 | GPSG_SPOUSE_NAT | Character(30) | VARCHAR2(30) NOT NULL | Nationality of spouse |
48 | GPSG_EMPLR_SCHL | Character(30) | VARCHAR2(30) NOT NULL | Name of Employer or School |
49 | GPSG_LOM_NOTICE | Character(1) | VARCHAR2(1) NOT NULL |
Reason for Less than One Month Notice to IRAS
A=Absconded / Left without notic I=Immediate Resignation/Shrt Ntc O=Others. Give details: R=Resigned whilst overseas |
50 | GPSG_TNW_REASON | Character(1) | VARCHAR2(1) NOT NULL |
Reason for Tax not Withheld
D=Did not return from Leave E=Employee owes Company monies O=Others. Give details R=Resigned after Pay day S=Salary already paid via Bank |
51 | GPSG_SPOUSE_INCOME | Character(1) | VARCHAR2(1) NOT NULL |
Spouse income >4000
Y/N Table Edit |
52 | GPSG_DATE_PAYMENT | Date(10) | DATE | Payment Date for Retirement benefits |
53 | GPSG_IR21_MONIES | Character(1) | VARCHAR2(1) NOT NULL |
Withholding Monies
Y/N Table Edit |
54 | GPSG_ER_PAR_TX_RS | Character(30) | VARCHAR2(30) NOT NULL | Detail Section if Income tax borne by Employer is Partial |