PTAI_ITEM_IDPTAI_LIST_IDPTAI_START_DTTMPTAI_USGE_STATS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTAI_ITEM_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item ID |
| 2 | PTAI_LIST_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item List ID |
| 3 | PTAI_START_DTTM |
DateTime(26) | TIMESTAMP | Step Start DateTime |
| 4 | PTAI_END_DTTM | DateTime(26) | TIMESTAMP | End DateTime |
| 5 | PTAI_ACTL_DUR | Number(8,2) | DECIMAL(7,2) NOT NULL | Elapsed Duration |