PYCYC_CRNCY_VW

(SQL View)
 Index Back

Prompt for Current Pay Cycles

Used as a prompt view to select the current pay cycles.

SELECT DISTINCT PAY_CYCLE , CURRENCY_PYMNT FROM PS_PYCYCL_DATA A WHERE A.PYMNT_SELCT_STATUS NOT IN ('D','V','N') AND A.PAY_CYCLE_SEQ_NUM = ( SELECT MAX(B.PAY_CYCLE_SEQ_NUM) FROM PS_PYCYCL_STAT B WHERE B.PAY_CYCLE = A.PAY_CYCLE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code