| keyid |
varchar(100) |
|
false |
|
|
|
| userid |
varchar(50) |
|
true |
|
|
User GUID |
| startdate |
timestamp without time zone |
|
true |
|
|
Start Time (UTC) |
| startdateltc |
timestamp without time zone |
|
true |
|
|
Start Time (LTC) |
| daystartoffsetsecs |
integer |
|
true |
|
|
Start of Day Offset |
| adherenceperc |
numeric(20,2) |
|
true |
|
|
Adherence Percentage |
| conformperc |
numeric(20,2) |
|
true |
|
|
Conformance Percentage |
| impact |
varchar(50) |
|
true |
|
|
What was the overall impact of adherence? |
| adherenceschedulesecs |
integer |
|
true |
|
|
The Total Adherence Time that adherence is measured against |
| conformanceschedulesecs |
integer |
|
true |
|
|
The Total Conformance Time that adherence is measured against |
| conformanceactualsecs |
integer |
|
true |
|
|
Total Time Agent in Conformance |
| exceptioncount |
integer |
|
true |
|
|
Total Exception Count |
| exceptiondurationsecs |
integer |
|
true |
|
|
Impacted Seconds |
| impactseconds |
integer |
|
true |
|
|
Impacted Seconds |
| schedulelengthsecs |
integer |
|
true |
|
|
Total Scheduled Time (Seconds) |
| actuallengthsecs |
integer |
|
true |
|
|
Total Actual Scheduled Time length |
| updated |
timestamp without time zone |
|
true |
|
|
Date Row was updated (UTC) |