INC_EARE_VW_NLD

(SQL View)
 Index Back

View incidental hours

This view creates the possibility to enter and correct hourly-based incidental pay.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.ERNCD , A.CURRENCY_CD , A.SHIFT , A.OTH_HRS , A.HOURLY_RT , A.OTH_PAY , A.PERIOD_BEGIN_NLD , A.PERIOD_END_NLD , A.COMMENTS_NLD , A.OK_TO_PAY FROM PS_INC_EARNING_NLD A WHERE EXISTS ( SELECT 'X' FROM PS_EARNINGS_TBL B WHERE B.ERNCD = A.ERNCD AND (B.PERMANENCY_NLD = 'I' OR B.PERMANENCY_NLD = 'B') AND B.PAYMENT_TYPE = 'H')

  • Parent record: PER_ORG_ASGN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Prompt Table: INC_EARH_VW_NLD

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

    Default Value: JOB_CURR_VW.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    7 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=1
    2=2
    3=3
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating
    8 OTH_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Other Hours
    9 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    10 OTH_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Pay
    11 PERIOD_BEGIN_NLD Date(10) DATE Begin Period
    12 PERIOD_END_NLD Date(10) DATE End Period
    13 COMMENTS_NLD Character(80) VARCHAR2(80) NOT NULL Comments
    14 OK_TO_PAY Character(1) VARCHAR2(1) NOT NULL OK to Pay

    Y/N Table Edit

    Default Value: Y