SP_PYCYCL_CLSLG

(SQL View)
 Index Back

Security View for Pay Cycle


SELECT b.oprclass , a.pay_cycle , a.language_cd , a.descr FROM PS_PYCYCL_LG a , ps_sec_pycycl_cls b WHERE (a.pay_cycle = b.pay_cycle OR ((%Substring(a.pay_cycle, 1, 3) = 'XPC' OR %Substring(a.pay_cycle, 1, 3) = 'RST') AND %Substring(a.pay_cycle, 1, 3) = b.pay_cycle)) AND a.pay_cycle <> 'XPC' AND a.pay_cycle <> 'RST'

  • Related Language Record for SP_PYCYCL_CLSVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description