PYCYC_MTRIC_VW (SQL View)	Index Back
Prompt for Current Pay Cycles Used as a prompt view to select the current pay cycles.

PYCYC_MTRIC_VW

(SQL View)

Prompt for Current Pay Cycles

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

SELECT DISTINCT PAY_CYCLE 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