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
|