GPNL_NRP_PACLVW

(SQL View)
Index Back

Payslip Accumultaors

This table is used to store the accumulators that are used to print the totals

SELECT GPNL_PAYSLIP_ID , GPNL_ELEMENT_ORD , GPNL_PIN_PS1_NUM + 50000000 , LANGUAGE_CD , DESCR FROM PS_GPNL_PSLPAC_LNG

# 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_PIN_PS1_NUM Number(8,0) INTEGER NOT NULL Pay slip Pin Number

Prompt Table: GP_PIN_AC4_VW

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description