COMPANYPAYGROUPPAY_END_DTCYCLE_SELECTB=Both
F=Off-Cycle
O=On-Cycle
PY_FILE_TAGPY_DDPCTL2_VW(SQL View) |
Index Back |
|---|---|
Direct Deposit Control ViewDirect Deposit Control View by Company, Paygroup and Pay End Date |
| SELECT DISTINCT COMPANY , PAYGROUP , PAY_END_DT , 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 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 3 | PAY_END_DT |
Date(10) | DATE | Pay Period End Date |
| 4 | CYCLE_SELECT |
Character(1) | VARCHAR2(1) NOT NULL |
Off-Cycle
B=Both F=Off-Cycle O=On-Cycle |
| 5 | PY_FILE_TAG |
Character(21) | VARCHAR2(21) NOT NULL | File Tag associated with the direct deposit file. |
| 6 | CREATION_DT | Date(10) | DATE | Creation Date |