PTIAAUTASKIDPTIAAUJOBIDPTIAAUTASK(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIAAUTASKID |
Character(100) | VARCHAR2(100) NOT NULL | Task ID |
| 2 | PTIAAUJOBID |
Character(100) | VARCHAR2(100) NOT NULL | Job ID |
| 3 | PTIAAUTASKTYPE | Character(20) | VARCHAR2(20) NOT NULL | Task Type |
| 4 | PTIAAUTASKSUBTYPE | Character(20) | VARCHAR2(20) NOT NULL | Task Subtype |
| 5 | PTIAAUTASKSTATE | Character(20) | VARCHAR2(20) NOT NULL | Task State |
| 6 | PTIA_DTTM_START | DateTime(26) | TIMESTAMP | DateTime Stamp Start |
| 7 | PTIA_DTTM_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 8 | PTIAAULOGMESSAGE | Long Character | CLOB | Log Message |