PTIAAUJOBIDPTIAAUJOB(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIAAUJOBID |
Character(100) | VARCHAR2(100) NOT NULL | Job ID |
| 2 | PTIAAUJOBNAME | Character(100) | VARCHAR2(100) NOT NULL | Job Name |
| 3 | PTIAAUJOBSTATE | Character(20) | VARCHAR2(20) NOT NULL | Job State |
| 4 | PTIAAUJOBCALLBACK | Character(200) | VARCHAR2(200) NOT NULL | Job Callback |
| 5 | PTIA_DTTM_START | DateTime(26) | TIMESTAMP | DateTime Stamp Start |
| 6 | PTIA_DTTM_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 7 | PTIAAUJOBDATA | Long Character | CLOB | Job Data |