Call Work Codes database items

Last Updated : Nov 20, 2024 |
Prolog information
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