GPNZ_PSLP

(SQL Table)
 Index Back

GP NZL - Payslip Definition

GP NZL - Payslip definition record

  • Related Language Record: GPNZ_PSLP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPNZ_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: NZL

    6 GPNZ_EXCL_PRNT Character(2) VARCHAR2(2) NOT NULL This field will be used to identify if there will be any exclusions (department or location) when generating the hard-copy payslips.
    10=None
    20=Department
    30=Location

    Default Value: 10

    7 GPNZ_DEL_OPT Character(2) VARCHAR2(2) NOT NULL This field will be used to identify the delivery address for the payslip.
    20=Department
    30=Location
    50=Home Address
    60=Mail Address

    Default Value: 50

    8 GPNZ_LBL_ACUM1 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 1 that will be used for on-line and hard-copy payslips.
    9 GPNZ_LBL_ACUM2 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 2 that will be used for on-line and hard-copy payslips.
    10 GPNZ_LBL_ACUM3 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 3 that will be used for on-line and hard-copy payslips.
    11 GPNZ_LBL_ACUM4 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 4 that will be used for on-line and hard-copy payslips.
    12 GPNZ_LBL_ACUM5 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 5 that will be used for on-line and hard-copy payslips.
    13 GPNZ_LBL_ACUM6 Character(10) VARCHAR2(10) NOT NULL This field will be used to store the label for accumulator 6 that will be used for on-line and hard-copy payslips.
    14 GPNZ_SORT_KEY1 Character(2) VARCHAR2(2) NOT NULL This field will be used to identify the first sort key.
    00=Not Applicable
    10=Pay Entity
    20=Location
    30=Department
    40=Employee Name
    50=Paygroup
    15 GPNZ_SORT_KEY2 Character(2) VARCHAR2(2) NOT NULL This field will be used to determine the second sort key
    00=Not Applicable
    10=Pay Entity
    20=Location
    30=Department
    40=Employee Name
    50=Paygroup
    16 GPNZ_SORT_KEY3 Character(2) VARCHAR2(2) NOT NULL This field will be used to identify the third sort key.
    00=Not Applicable
    10=Pay Entity
    20=Location
    30=Department
    40=Employee Name
    50=Paygroup