ADD_PAY_DTA_NLD

(SQL Table)
 Index Back

Additional Pay Data - NLD

ADD_PAY_DTA_NLD record stores the additional pay detail required to create additional payline records during paysheet processing.

  • Parent record: ADD_PAY_ERN_NLD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Prompt Table: PER_ORG_ASGN_VW

    3 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 ADDL_SEQ Number(2,0) SMALLINT NOT NULL Additional Pay Sequence Number

    Default Value: 1

    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: JOB_CURR_VW.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    7 OTH_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Other hours.
    8 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    9 OTH_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Pay
    10 ADDLPAY_REASON Character(3) VARCHAR2(3) NOT NULL Reason for Additional Pay
    A=Anniversary Award
    AWD=Award Data
    BAS=Benefits Administration Credit
    C=Contract Pay
    JOB=Job Other Pay
    N=Not Specified
    O=Outstanding Contribution
    P=Performance Award
    Q=President's Award
    S=Productivity Award

    Default Value: N

    11 EARNINGS_END_DT Date(10) DATE Earnings End Date
    12 GOAL_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Goal Amount
    13 OK_TO_PAY Character(1) VARCHAR2(1) NOT NULL Okay to pay indicator.

    Y/N Table Edit

    Default Value: N