IN_USAGE_DT_AET(SQL Table) |
Index Back |
---|---|
State table for usage desktop |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | 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 |