PY_MOD_PYFRQ_VW

(SQL View)
 Index Back

Comp Frequency View

A view of the Frequency Table used in paycheck modeling that specifies the frequencies valid for the Comp Frequency.

SELECT DISTINCT A.FREQUENCY_ID , A.DESCRSHORT , A.DESCR50 , A.FREQUENCY_TYPE FROM PS_FREQUENCY_TBL A WHERE A.EFF_STATUS = 'A' AND (A.FREQUENCY_TYPE <> 'H' OR (A.FREQUENCY_TYPE = 'H' AND A.USE_STD_HOURS_SW = 'Y')) AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_FREQUENCY_TBL A_ED WHERE A_ED.FREQUENCY_ID = A.FREQUENCY_ID AND A_ED.EFFDT <= %CurrentDateIn)

  • Related Language Record: PY_MOD_FRQ_L_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    H=Hourly
    M=Monthly
    S=Semimonthly
    W=Weekly
    2 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    4 FREQUENCY_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates the type of a frequency ID.
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    F=Every Four Weeks
    H=Hourly
    M=Monthly
    Q=Quarterly
    S=Semimonthly
    W=Weekly