PAY_CYCLESP_DEPYCL_NONVW(SQL View) |
Index Back |
|---|---|
Pay Cycles To Set InactiveSelect Pay Cycles To Set Inactive |
| SELECT a.pay_cycle , a.descr FROM PS_PYCYCL a , PS_PYCYCL_stat b WHERE a.pay_cycle = b.pay_cycle AND b.pay_run_ap_status IN ('C','2','N','D') AND b.PAY_CYCLE_SEQ_NUM = ( SELECT MAX(PAY_CYCLE_SEQ_NUM) FROM PS_PYCYCL_stat c WHERE b.pay_cycle=c.pay_cycle) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_CYCLE |
Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |