RUN_IDCYCLE_SELECTB=Both
F=Off-Cycle
O=On-Cycle
PY_FILE_TAGPY_DDPCTL1_VW(SQL View) |
Index Back |
|---|---|
Direct Deposit Control ViewDirect Deposit Control View by Run ID |
| SELECT DISTINCT RUN_ID , CYCLE_SELECT , PY_FILE_TAG , CREATION_DT FROM PS_PY_DDP_CNTRL WHERE PY_DDP_VERSION = '1' AND PY_RESET_DDP = 'N' AND RUN_ID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Pay Run ID |
| 2 | CYCLE_SELECT |
Character(1) | VARCHAR2(1) NOT NULL |
Off-Cycle
B=Both F=Off-Cycle O=On-Cycle |
| 3 | PY_FILE_TAG |
Character(21) | VARCHAR2(21) NOT NULL | File Tag associated with the direct deposit file. |
| 4 | CREATION_DT | Date(10) | DATE | Creation Date |