XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

6 digit house number

cust

2 digit customer number

XML Tag

Column Name

Data Type

Nullable

Definition

cc_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

cc_partition

PARTITION

CHAR(2)

N

Data hashing value for database management - equals the last 2 digits of the house #. Valid Values:

cc_house

HOUSE

CHAR(6)

N

Up to six digit house number

cc_cust

CUST

CHAR(2)

N

Two digit customer number

cc_nextdate

NEXTDATE

DATETIME

Y

Date the next collections step will occur.. Valid Values:

cc_nextpath

NEXTPATH

SMALLINT SIGNED

N

Next Path the account will have at the time of theNEXTDATE. Valid Values:

cc_nextstep

NEXTSTEP

SMALLINT SIGNED

N

Next collection step number. Valid Values: Jan-99

cc_nextclass

NEXTCLASS

SMALLINT SIGNED

N

Next collection step class. Valid Values:

cc_waiting

WAITING

SMALLINT SIGNED

N

Waiting indicator - waiting for charging or disconnect to be completed by DDPF. Valid Values: 1=waiting for NPD 2=waiting for DRD

cc_queue

QUEUE

SMALLINT SIGNED

N

Flag designating if account is in the CollectionsQueue. Valid Values: 0=not in queue 1=in collections queue

cc_collector

COLLECTOR

CHAR(3)

N

Designates the collector id or agency. Valid Values: if 1st position is '*' then 2nd is 95 code agencytable otherwise is the collector ID.

cc_prognbr

PROGNBR

CHAR(3)

N

Last 3 number of the program that last updatedthe row.. Valid Values: 3 numbers - does not include the rev.

cc_lastdate

LASTDATE

DATETIME

Y

The date of the last record update OR date of the last collection step.. Valid Values:

cc_lastpath

LASTPATH

SMALLINT SIGNED

N

The path the account had at the time of the laststep.. Valid Values:

cc_laststep

LASTSTEP

SMALLINT SIGNED

N

Last collection step number. Valid Values:

cc_lastclass

LASTCLASS

SMALLINT SIGNED

N

Last collection step class. Valid Values: