The Call Work Codes database item descriptions apply to historical items. Historical call work codes database items apply to the following tables:
Intrahour Call Work Codes (hcwc)
Daily Call Work Codes (dcwc)
Weekly Call Work Codes (wcwc)
Monthly Call Work Codes (mcwc)
Unless indicated otherwise, all items listed here are included in all four database tables.
Database item |
Data type |
Column type |
Length |
ACD (index) |
I |
smallint |
2 bytes |
ACDCALLS |
C |
integer |
4 bytes |
ACDTIME |
C |
integer |
4 bytes |
ACWTIME |
C |
integer |
4 bytes |
CWC (index) |
I |
char(16) - ASCII text string |
16 bytes |
INCOMPLETE |
C |
smallint |
2 bytes |
INTRVL |
A |
smallint (hcwc only) |
2 bytes |
PARTIAL_ARCHIVE |
I |
smallint (hcwc only) |
2 bytes |
ROW_DATE (index) |
I |
date - Informix date |
4 bytes |
STARTTIME |
I |
smallint (hcwc only) |
2 bytes |
STARTTIME_UTC |
I |
integer (hcwc only) |
4 bytes |
TENANT |
I |
integer |
4 bytes |
TIMEZONE |
A |
char(40) - ASCII text string (dcwc, wcwc, mcwc only) |
40 bytes |
