| TIME |
time |
yes |
|
Standard time formatted as time |
| TIMESTRING |
nchar |
yes |
|
Standard time formatted as HHMM |
| HOUR |
tinyint |
yes |
|
Standard hour formatted as tinyint |
| HOURSTRING |
nchar |
yes |
|
Standard hour formatted as string |
| MINUTE |
tinyint |
yes |
|
Minute formatted as tinyint |
| MINUTESTRING |
char(2) |
yes |
|
Minute formatted as string |
| MILITARYHOUR |
tinyint |
yes |
|
Hour as tinyint using 24 hour format |
| MILITARYHOURSTRING |
nchar |
yes |
|
Hour as string using 24 hour format |
| AMPM |
nchar |
yes |
|
AM or PM |
| AMPMCODE |
bit |
yes |
|
Code for AM (0) or PM (1) |
| STANDARDTIME |
nchar |
yes |
|
Standard time formatted as HH:MM AM/PM |
| MILITARYTIME |
nchar |
yes |
|
24 hour time formatted as HH:MM |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |