IN_USAGE_DT_AET(SQL Table) |
Index Back |
|---|---|
State table for usage desktop |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | START_DT | Date(10) | DATE | Start Date |
| 3 | END_DT | Date(10) | DATE | End Date |
| 4 | KEY_DATE_01 | Date(10) | DATE | Key Date 01 |
| 5 | END_DATE_01 | Date(10) | DATE | End Date |
| 6 | KEY_DATE_02 | Date(10) | DATE | Key Date 02 |
| 7 | END_DATE_02 | Date(10) | DATE | End Date |
| 8 | KEY_DATE_03 | Date(10) | DATE | Key Date 03 |
| 9 | END_DATE_03 | Date(10) | DATE | End Date |
| 10 | KEY_DATE_04 | Date(10) | DATE | Key Date 04 |
| 11 | END_DATE_04 | Date(10) | DATE | End Date |
| 12 | KEY_DATE_05 | Date(10) | DATE | Key Date 05 |
| 13 | END_DATE_05 | Date(10) | DATE | End Date |
| 14 | KEY_DATE_06 | Date(10) | DATE | Key Date 06 |
| 15 | END_DATE_06 | Date(10) | DATE | End Date |
| 16 | KEY_DATE_07 | Date(10) | DATE | Key Date 07 |
| 17 | END_DATE_07 | Date(10) | DATE | End Date |
| 18 | KEY_DATE_08 | Date(10) | DATE | Key Date 08 |
| 19 | END_DATE_08 | Date(10) | DATE | End Date |
| 20 | KEY_DATE_09 | Date(10) | DATE | Key Date 09 |
| 21 | END_DATE_09 | Date(10) | DATE | End Date |
| 22 | KEY_DATE_10 | Date(10) | DATE | Key Date 10 |
| 23 | END_DATE_10 | Date(10) | DATE | End Date |
| 24 | KEY_DATE_11 | Date(10) | DATE | Key Date 11 |
| 25 | END_DATE_11 | Date(10) | DATE | End Date |
| 26 | START_DTTM | DateTime(26) | TIMESTAMP | start date time |
| 27 | END_DTTM | DateTime(26) | TIMESTAMP | end date time |
| 28 | KEY_DTTM_01 | DateTime(26) | TIMESTAMP | Key Date Time 01 |
| 29 | END_DTTM_01 | DateTime(26) | TIMESTAMP | End DateTime 01 |
| 30 | KEY_DTTM_02 | DateTime(26) | TIMESTAMP | Key Date Time 02 |
| 31 | END_DTTM_02 | DateTime(26) | TIMESTAMP | End DateTime 02 |
| 32 | KEY_DTTM_03 | DateTime(26) | TIMESTAMP | Key Date Time 03 |
| 33 | END_DTTM_03 | DateTime(26) | TIMESTAMP | End DateTime 03 |
| 34 | KEY_DTTM_04 | DateTime(26) | TIMESTAMP | Key Date Time 04 |
| 35 | END_DTTM_04 | DateTime(26) | TIMESTAMP | End DateTime 04 |
| 36 | KEY_DTTM_05 | DateTime(26) | TIMESTAMP | Key Date Time 05 |
| 37 | END_DTTM_05 | DateTime(26) | TIMESTAMP | End DateTime 05 |
| 38 | KEY_DTTM_06 | DateTime(26) | TIMESTAMP | Key DateTime 06 |
| 39 | END_DTTM_06 | DateTime(26) | TIMESTAMP | End DateTime 06 |
| 40 | KEY_DTTM_07 | DateTime(26) | TIMESTAMP | Key DateTime 07 |
| 41 | END_DTTM_07 | DateTime(26) | TIMESTAMP | End DateTime 07 |
| 42 | KEY_DTTM_08 | DateTime(26) | TIMESTAMP | Key DateTime 08 |
| 43 | END_DTTM_08 | DateTime(26) | TIMESTAMP | End DateTime 08 |
| 44 | KEY_DTTM_09 | DateTime(26) | TIMESTAMP | Key DateTime 09 |
| 45 | END_DTTM_09 | DateTime(26) | TIMESTAMP | End DateTime 09 |
| 46 | KEY_DTTM_10 | DateTime(26) | TIMESTAMP | Key DateTime 10 |
| 47 | END_DTTM_10 | DateTime(26) | TIMESTAMP | End DateTime 10 |
| 48 | KEY_DTTM_11 | DateTime(26) | TIMESTAMP | Key DateTime 11 |
| 49 | END_DTTM_11 | DateTime(26) | TIMESTAMP | End DateTime 11 |