Split/Skill database items

Last Updated : Nov 20, 2024 |

The Split/Skill database item descriptions apply to historical items. Historical split/skill database items apply to the following tables:

  • Intrahour Split/Skill (hsplit)

  • Daily Split/Skill (dsplit)

  • Weekly Split/Skill (wsplit)

  • Monthly Split/Skill (msplit)

Unless indicated otherwise, all of the database items listed here are included in all four database tables.

Database item

Data type

Column type

Length

ABNCALLS

C

integer

4 bytes

ABNCALLS1-ABNCALLS10

C

integer

4 bytes

ABNCALLSACC1-ABNCALLSACC10

C

integer (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

ABNRINGCALLS

C

integer

4 bytes

ABNTIME

C

integer

4 bytes

ACCEPTABLE

C

integer

4 bytes

ACCEPTABLEACC

C

integer

4 bytes

ACD (index)

C

integer (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

ACDAUXOUTCALLS

A

integer

4 bytes

ACDCALLS

C

integer

4 bytes

ACDCALLS1-ACDCALLS10

C

integer

4 bytes

ACDCALLSACC1-ACDCALLSACC10

C

integer (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

ACDCALLS_R1

C

integer

4 bytes

ACDCALLS_R2

C

integer

4 bytes

ACDTIME

C

integer (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

ACWINCALLS

C

integer

4 bytes

ACWINTIME

C

integer (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

ACWOUTADJCALLS

C

integer

4 bytes

ACWOUTCALLS

C

integer

4 bytes

ACWOUTOFFCALLS

C

integer (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

ACWOUTOFFTIME

C

integer (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

ACWOUTTIME

C

integer

4 bytes

ACWTIME

C

integer (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

AGSURPDELIVERIES

C

integer

4 bytes

AGSURPNPREFCALLS

C

integer

4 bytes

AGSURPPREFCALLS

C

integer

4 bytes

ANSTIME

C

integer

4 bytes

ASSISTS

C

integer

4 bytes

AUXINCALLS

C

integer

4 bytes

AUXINTIME

C

integer

4 bytes

AUXOUTADJCALLS

C

integer

4 bytes

AUXOUTCALLS

C

integer

4 bytes

AUXOUTOFFCALLS

C

integer

4 bytes

AUXOUTOFFTIME

C

integer

4 bytes

AUXOUTTIME

C

integer

4 bytes

BACKUPCALLS

C

integer

4 bytes

BUSYCALLS

C

integer

4 bytes

BUSYTIME

C

integer

4 bytes

CALLSOFFERED

C

integer

4 bytes

CALLSURPDELIVERIES

C

integer

4 bytes

CONFERENCE

C

integer

4 bytes

DA_ACWINCALLS

C

integer

4 bytes

DA_ACWINTIME

C

integer

4 bytes

DA_ACWOCALLS

C

integer

4 bytes

DA_ACWOTIME

C

integer

4 bytes

DEQUECALLS

C

integer

4 bytes

DEQUETIME

C

integer

4 bytes

DISCCALLS

C

integer

4 bytes

DISCTIME

C

integer

4 bytes

EVENT1-EVENT9

C

integer

4 bytes

HIGHCALLS

C

integer

4 bytes

HOLDABNCALLS

C

integer

4 bytes

HOLDCALLS

C

integer

4 bytes

HOLDTIME

C

integer (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_ACDAUXINTIME

C

integer

4 bytes

I_ACDAUX_OUTTIME

C

integer

4 bytes

I_ACDOTHERTIME

C

integer

4 bytes

I_ACDTIME

C

integer (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_ACDTIME_R1

C

integer

4 bytes

I_ACDTIME_R2

C

integer

4 bytes

I_ACWINTIME

C

integer

4 bytes

I_ACWOUTTIME

C

integer

4 bytes

I_ACWTIME

C

integer (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_ACWTIME_R1

C

integer

4 bytes

I_ACWTIME_R2 3

C

integer

4 bytes

I_ARRIVED

C

integer

4 bytes

I_AUXINTIME

C

integer

4 bytes

I_AUXOUTTIME

C

integer

4 bytes

I_AUXTIME

C

integer (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_AUXTIME0

C

integer

4 bytes

I_AUXTIME1-9

C

integer

4 bytes

I_AUXSTBYTIME_R1

C

integer

4 bytes

I_AUXSTBYTIME_R2

C

integer

4 bytes

I_AUXTIME_R1

C

integer

4 bytes

I_AUXTIME_R2

C

integer

4 bytes

I_AVAILTIME

C

integer (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_DA_ACDTIME

C

integer

4 bytes

I_DA_ACWTIME

C

integer

4 bytes

I_NORMTIME

C

integer

4 bytes

I_OL1TIME

C

integer

4 bytes

I_OL2TIME

C

integer

4 bytes

I_OTHERSTBYTIME_R1

C

integer

4 bytes

I_OTHERSTBYTIME_R2

C

integer

4 bytes

I_OTHERTIME

C

integer (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_OTHERTIME_R1

C

integer

4 bytes

I_OTHERTIME_R2

C

integer

4 bytes

I_RINGTIME

C

integer

4 bytes

I_RINGTIME_R1

C

integer

4 bytes

I_RINGTIME_R2

C

integer

4 bytes

I_STAFFTIME

C

integer (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_TAUXTIME

C

integer

4 bytes

I_TAVAILTIME

C

integer (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_TOTHERTIME

C

integer (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

ICRPULLCALLS

C

integer

4 bytes

ICRPULLRINGCALLS

C

integer

4 bytes

ICRPULLTIME

C

integer

4 bytes

INCOMPLETE

C

smallint

2 bytes

INFLOWCALLS

C

integer

4 bytes

INTERFLOWCALLS

C

integer

4 bytes

INTRDELIVERIES

C

integer

4 bytes

INTRVL

A

smallint

2 bytes

LOWCALLS

C

integer

4 bytes

MAXINQUEUE

M

integer (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

MAXOCWTIME

M

integer

4 bytes

MAXSTAFFED

M

integer (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

MAXTOP

M

integer

4 bytes

MAX_TOT_PERCENTS

C

integer

4 bytes

MEDCALLS

C

integer

4 bytes

NOANSREDIR

C

integer

4 bytes

O_ABNCALLS

C

integer

4 bytes

O_ACDCALLS

C

integer

4 bytes

O_ACDTIME

C

integer

4 bytes

O_ACWTIME

C

integer

4 bytes

O_OTHERCALLS

C

integer

4 bytes

OTHERCALLS

C

integer

4 bytes

OTHERTIME

C

integer

4 bytes

OUTFLOWCALLS

C

integer

4 bytes

OUTFLOWTIME

C

integer

4 bytes

PARTIAL_ARCHIVE

I

smallint

2 bytes

PERIOD1-PERIOD9

A

smallint

2 bytes

PERIODCHG

A

integer (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

PHANTOMABNS

C

integer

4 bytes

REDIRECTCALLS

C

integer

4 bytes

RINGCALLS

C

integer

4 bytes

RINGTIME

C

integer

4 bytes

ROIFREDIR

C

integer

4 bytes

ROOFREDIR

C

integer

4 bytes

ROW_DATE (index)

I

date - Informix date

4 bytes

RSV_LEVEL

smallint

2 bytes

SERVICELEVEL

A

integer (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

SLVLABNS

C

integer

4 bytes

SLVLABNSACC

C

integer

4 bytes

SLVLOUTFLOWS

C

integer

4 bytes

SPLIT (index)

I

smallint (dsplit, wsplit, msplit)

2 bytes

STARTTIME

I

smallint (hsplit only)

2 bytes

STARTTIME_UTC

I

integer (hsplit only)

4 bytes

SVCLEVELCHG

A

integer (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

TENANT

I

integer

4 bytes

TARGETACDCALLS

integer

4 bytes

TARGETABNS

integer

4 bytes

TARGETOUTFLOWS

integer

4 bytes

TIMEZONE

A

char(40) - ASCII text (dsplit, wsplit, msplit only)

40 bytes

TOPCALLS

C

integer

4 bytes

TRANSFERRED

C

integer

4 bytes