GPES_PAYSLIP_AP

(SQL Table)
Index Back

Payslip Contributions

This table is used to store the deductions that are used to print the social security constribution lines

  • Related Language Record: GPES_PSLPAP_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPES_PAYSLIP_ID Character(6) VARCHAR2(6) NOT NULL Pay Slip Identification
    2 EFFDT Date(10) DATE Effective Date
    3 GPES_PIN_PS1_NUM Number(8,0) INTEGER NOT NULL Pay slip Pin Number

    Prompt Table: GP_PIN_DD0_VW

    4 GPES_ELEMENT_ORD Number(9,2) DECIMAL(8,2) NOT NULL Print Order of the element in payslip
    5 GPES_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

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 CONCEPT_ESP Character(2) VARCHAR2(2) NOT NULL Social Security contribution concept
    10=Common Contingency
    20=Temporal Disability
    30=Permanent Disability D & S
    40=Professional Training
    50=FOGASA
    60=Unemployment
    70=Structural Overtime
    80=Non Structural Overtime

    Default Value: 10

    8 GPES_LINES_BEFORE Number(2,0) SMALLINT NOT NULL Number of lines before the element in payslip
    9 GPES_LINES_AFTER Number(2,0) SMALLINT NOT NULL Number of lines after the element in payslip

    Default Value: 1