GPIN_PSLP_ED

(SQL Table)
Index Back

Payslip ErnDed Definition

GP IND- Payslip Earnings and Deductions definition record

  • Related Language Record: GPIN_PS_ED_LNG
  • Parent record: GPIN_PSLP_SECT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPIN_PAYSLIP_ID Character(18) VARCHAR2(18) NOT NULL This field is used to uniquely identify a payslip template.
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    4 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number
    5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: %GP_EDIT_FLD7

    6 GPIN_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

    Default Value: 10

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: N

    8 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

    Prompt Table: GPIN_ENT_PSL_VW

    9 GPIN_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

    Default Value: N

    10 GPIN_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

    Default Value: N

    11 GPIN_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

    Default Value: N

    12 GPIN_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

    Default Value: N

    13 GPIN_YTD_AC_AMT Number(8,0) INTEGER NOT NULL This field will be used to store the pin num of the year-to-date amount accumulator that will be included on the on-line and hard-copy payslips.

    Prompt Table: GPIN_ACM_SCH_VW

    14 GPIN_YTD_AC_UNITS Number(8,0) INTEGER NOT NULL This field will be used to store the pin num of the year-to-date unit accumulator that will be included on the on-line and hard-copy payslips.

    Prompt Table: GPIN_ACM_SCH_VW

    15 GPIN_YTD_AC_AMT_YN Character(1) VARCHAR2(1) NOT NULL This field controls the display of YTD amounts on the payslip inquiry

    Y/N Table Edit

    Default Value: N

    16 GPIN_YTD_AC_UNT_YN Character(1) VARCHAR2(1) NOT NULL This field controls the display of YTD units on the payslip inquiry

    Y/N Table Edit

    Default Value: N