PY_MOD_FRQ_L_VW

(SQL View)
Index Back

Rel. Lang. for PY_MOD_PYFRQ_VW

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

SELECT DISTINCT A.FREQUENCY_ID , B.LANGUAGE_CD , B.DESCRSHORT , B.DESCR50 FROM PS_FREQUENCY_TBL A , PS_FREQ_TBL_LANG B WHERE A.FREQUENCY_ID = B.FREQUENCY_ID AND A.EFFDT = B.EFFDT AND 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 for PY_MOD_PYFRQ_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50