GPNL_NRP_PSLNVW(SQL View) |
Index Back |
|---|---|
Payslip LinesThis table is used to store the earnings and deductions that are used to print the lines |
| SELECT GPNL_PAYSLIP_ID , GPNL_ELEMENT_ORD , GPNL_ELEM_DESCR , DESCR , GPNL_PIN_TYPE , GPNL_PIN_PS1_NUM + 50000000 , GPNL_RETRO_TYPE , GPNL_LINES_BEFORE , GPNL_LINES_AFTER , GPNL_PSLIP_SEPARAT , GPNL_BASE_PRINT , GPNL_PCT_PRINT , GPNL_RATE_PRINT , GPNL_UNIT_PRINT , GPNL_PS_REG_COL , GPNL_PS_REGTOT_COL , GPNL_PS_NREG_COL , GPNL_PS_NRGTOT_COL , GPNL_PS_TOT_COL FROM PS_GPNL_PSLIP_LN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPNL_PAYSLIP_ID |
Character(6) | VARCHAR2(6) NOT NULL | Pay Slip Identification |
| 2 | GPNL_ELEMENT_ORD | Number(9,2) | DECIMAL(8,2) NOT NULL | Print Order of the element in payslip |
| 3 | GPNL_ELEM_DESCR | Character(1) | VARCHAR2(1) NOT NULL |
Source for the description of an element in payslip
E=Element T=User Text Default Value: E |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | GPNL_PIN_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Element Type |
| 6 | GPNL_PIN_PS1_NUM | Number(8,0) | INTEGER NOT NULL | Pay slip Pin Number |
| 7 | GPNL_RETRO_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Retro Type
10=Current and Deltas 20=Current and Adjustment 30=One Line Default Value: 30 |
| 8 | GPNL_LINES_BEFORE | Number(2,0) | SMALLINT NOT NULL | Number of lines before the element in payslip |
| 9 | GPNL_LINES_AFTER | Number(2,0) | SMALLINT NOT NULL | Number of lines after the element in payslip |
| 10 | GPNL_PSLIP_SEPARAT | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to specify if theacumulator will be included on the Payslips with a sparator line
Y/N Table Edit Default Value: N |
| 11 | GPNL_BASE_PRINT | 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 Payslips.
Y/N Table Edit Default Value: N |
| 12 | GPNL_PCT_PRINT | 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 Payslips.
Y/N Table Edit Default Value: N |
| 13 | GPNL_RATE_PRINT | 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 Payslips.
Y/N Table Edit Default Value: N |
| 14 | GPNL_UNIT_PRINT | 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 Payslips.
Y/N Table Edit Default Value: N |
| 15 | GPNL_PS_REG_COL | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to specify if the earning or deduction will be printed in the Regular column on the Payslips.
Y/N Table Edit Default Value: N |
| 16 | GPNL_PS_REGTOT_COL | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to specify if the earning or deduction will be printed in the Regular and Total columns on the Payslips.
Y/N Table Edit Default Value: N |
| 17 | GPNL_PS_NREG_COL | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to specify if the earning or deduction will be printed in the non Regular column on the Payslips.
Y/N Table Edit Default Value: N |
| 18 | GPNL_PS_NRGTOT_COL | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to specify if the earning or deduction will be printed in the non Regular and Total columns on the Payslips.
Y/N Table Edit Default Value: N |
| 19 | GPNL_PS_TOT_COL | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to specify if the earning or deduction will be printed in the Total column on the Payslips.
Y/N Table Edit Default Value: N |