GPSG_IR21_HDR

(SQL Table)
Index Back

IR21 Form header

Singapore 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