COMPANYPAYGROUPPAY_END_DTRUN_IDCYCLE_SELECTB=Both
F=Off-Cycle
O=On-Cycle
PY_FILE_TAG0=DDP001
1=PY_DIRDEP
Y/N Table Edit
PY_DDP_CNTRL(SQL Table) |
Index Back |
|---|---|
Direct Deposit ControlUnique identifier for the direct deposit file created by either DDP001 or PY_DIRDEP. |
| # | 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 | RUN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Pay Run ID |
| 5 | CYCLE_SELECT |
Character(1) | VARCHAR2(1) NOT NULL |
Off-Cycle
B=Both F=Off-Cycle O=On-Cycle |
| 6 | PY_FILE_TAG |
Character(21) | VARCHAR2(21) NOT NULL | File Tag associated with the direct deposit file. |
| 7 | CREATION_DT | Date(10) | DATE | Creation Date |
| 8 | PY_DDP_VERSION | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the program which created the direct deposit file.
0=DDP001 1=PY_DIRDEP |
| 9 | PY_RESET_DDP | Character(1) | VARCHAR2(1) NOT NULL |
Reset direct deposit file indicator.
Y/N Table Edit |
| 10 | PY_RESET_DT | DateTime(26) | TIMESTAMP | Reset direct deposit file date and time. |