GPFR_PS1_LNG

(SQL Table)
Index Back

Payslip setup body (ern/ded)

Setup for the body of the payslip (earnings or deductions) - Related/language record A related language record enables text fields on a table to be translated into various languages for use in other countries.

  • Related Language Record for GPFR_PAY_SLIP_1 GPFR_PSLP1_NRVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPFR_PAY_SLIP_ID Character(6) VARCHAR2(6) NOT NULL Payslip ID

    Prompt Table: GPFR_PAY_SLIP_H

    2 GPFR_PYSL_B_A Character(1) VARCHAR2(1) NOT NULL Payslip or Annex
    A=Annex
    B=Pay-slip

    Default Value: B

    3 GPFR_ELEMENT_ORDER Number(9,2) DECIMAL(8,2) NOT NULL Print Order of the element in payslip
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description