PAY_CYCLEPrompt Table: SP_PYCYCL_NONVW
PAY_RUN_DTPYCYCL_STAT_VW3(SQL View) |
Index Back |
|---|---|
PayCycles by Pay Run Date |
| select distinct a.pay_cycle, a.pay_run_dt, a.oprid, a.pay_thru_dt from PS_PYCYCL_STAT a where a.pay_run_ap_status='C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_CYCLE |
Character(6) | VARCHAR2(6) NOT NULL |
Pay Cycle
Prompt Table: SP_PYCYCL_NONVW |
| 2 | PAY_RUN_DT |
Date(10) | DATE | Payment Run Date |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | PAY_THRU_DT | Date(10) | DATE | Pay Through Date |