GPSG_PAYSLIP_IDEFFDTDefault Value: %date
SEQ_NUM10=Description
20=Custom
30=Element Name
Prompt Table: GPSG_ED_SRCH
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
GPSG_NRP_PS5_VW(SQL View) |
Index Back |
|---|---|
GPSG - Itemized PayslipGP Singapore -Itemized Payslip record |
| SELECT GPSG_PAYSLIP_ID , EFFDT , SEQ_NUM , GPSG_DESC_TYPE , DESCR , PIN_NUM + 50000000 , GPSG_UNT_COMP_YN , GPSG_RTE_COMP_YN , GPSG_BSE_COMP_YN , GPSG_PCT_COMP_YN , GPSG_DATES_COMP_YN FROM PS_GPSG_PSLP_ITMZD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPSG_PAYSLIP_ID |
Character(18) | VARCHAR2(18) NOT NULL | Defines the payslip template ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | GPSG_DESC_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
This field will be used to identify which of the earnings/deductions description will be included on the on-line and hard-copy payslips. The options are Element Description, Element Name, or Custom (user entered).
10=Description 20=Custom 30=Element Name |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | PIN_NUM | Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: GPSG_ED_SRCH |
| 7 | GPSG_UNT_COMP_YN | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to specify if the unit component of an earning or deduction will be included on the on-line and hard-copy payslips.
Y/N Table Edit |
| 8 | GPSG_RTE_COMP_YN | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to specify if the rate component of an earning or deduction will be included on the on-line and hard-copy payslips.
Y/N Table Edit |
| 9 | GPSG_BSE_COMP_YN | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to specify if the base component of an earning or deduction will be included on the on-line and hard-copy payslips.
Y/N Table Edit |
| 10 | GPSG_PCT_COMP_YN | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to specify if the percent component of an earning or deduction will be included on the on-line and hard-copy payslips.
Y/N Table Edit |
| 11 | GPSG_DATES_COMP_YN | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to specify if the Arrears From and To Dates of an earning or deduction will be included on the payslips under Arrears Section (as part of Itemized payslip).
Y/N Table Edit |