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