|
XML Tag |
Definition |
|
comcorp |
Five digit system number assigned to each corp. |
|
house |
Six digit house number |
|
cust |
Two digit customer number |
|
XML Tag |
Column Name |
Data Type |
Nullable |
Definition |
|
C_corp |
CORP |
INT UNSIGNED |
N |
Two digit system number assigned to each corp.Thecorp # is unique only within one Tandem system. |
|
c_partition |
PARTITION |
CHAR(2) |
N |
Data hashing value for database management - equals the last 2 digits of the house #. |
|
c_house |
HOUSE |
CHAR(6) |
N |
House number. Valid Values: Alpha/Numeric |
|
c_cust |
CUST |
CHAR(2) |
N |
Customer number. |
|
c_lname |
LNAME |
CHAR(13) |
N |
Customer's last name. |
|
c_fname |
FNAME |
CHAR(8) |
N |
Customer's first name. |
|
c_init |
INIT |
CHAR(2) |
N |
Initials. |
|
c_title |
TITLE |
CHAR(2) |
N |
Title associated with customer's name OR name given a map table OR group title for Rate Increase ORaward title. Valid Values: Alpha-numeric |
|
c_rphon |
RPHON |
CHAR(8) |
N |
Customer's residence phone number. |
|
c_bphone |
BPHONE |
CHAR(10) |
N |
Customer's business phone number. Valid Values: If CREDITCHKTRANS, AAAPPPSSSS where aaa=area codeppp=prefix, ssss=suffix. |
|
c_campg |
Beginning c_campg delimiter |
|||
|
code |
CAMPG |
CHAR(1) |
N |
Campaign code from the installation. |
|
shortdescription |
CHAR(8) |
Campaign code short description |
||
|
longdescription |
CHAR(30) |
Campaign code long description |
||
|
/c_campg |
Ending c_campg delimiter |
|||
|
c_srsn |
Beginning c_csrsn delimiter |
|||
|
code |
SRSN |
CHAR(1) |
N |
Sales reason from the installation. |
|
shortdescription |
CHAR(8) |
Sales reason short description |
||
|
longdescription |
CHAR(30) |
Sales reason long description |
||
|
/c_srsn |
Ending c_srsn delimiter |
|||
|
c_mode |
Beginning c_mode delimiter |
|||
|
code |
MODE |
CHAR(1) |
N |
Frequency of statement sent to the customer. Valid Values: 0=none, 1=monthly, 2=bi-monthly, 3=quarterly, 6=semi-annually, A=annually |
|
shortdescription |
CHAR(8) |
Mode short description |
||
|
longdescription |
CHAR(30) |
Mode short description |
||
|
/c_mode |
Ending c_mode delimiter |
|||
|
c_class |
Beginning c_class delimiter |
|||
|
code |
CLASS |
CHAR(1) |
N |
Customer Class 36 code table #114 *OR* Adjustment class 1-9 *OR* collections class 0=no pay (cont'd). Valid Values: 1,5,9=full pay 2,6,10=full adjustment 3,7,11= partial payment 4,8,12=partial adju stment OR -- if custmaster, 36-code tbl 114, 0-9,A-Z |
|
shortdescription |
CHAR(8) |
Class code short description |
||
|
longdescription |
CHAR(30) |
Class code long description |
||
|
/c_class |
Ending c_class delimiter |
|||
|
c_ctype |
Beginning c_ctype delimiter |
|||
|
code |
CTYPE |
CHAR(1) |
N |
Code describing customer type. |
|
shortdescription |
CHAR(8) |
Customer type short description |
||
|
longdescription |
CHAR(30) |
Customer type long description |
||
|
/c_ctype |
Ending c_ctype delimiter |
|||
|
c_cinfo |
Beginning c_cinfo delimiter |
|||
|
code |
CINFO |
CHAR(1) |
N |
Code for customer information. |
|
shortdescription |
CHAR(8) |
Customer information short description |
||
|
longdescription |
CHAR(30) |
Customer information long description |
||
|
/c_cinfo |
Ending c_cinfo delimiter |
|||
|
c_tvtyp |
Beginning c_tvtype delimiter |
|||
|
code |
TVTYP |
CHAR(1) |
N |
TV type. |
|
shortdescription |
CHAR(8) |
TV type short description |
||
|
longdescription |
CHAR(30) |
TV type long description |
||
|
/c_tvtyp |
Ending c_tvtype delimiter |
|||
|
c_p80 |
P80 |
CHAR(1) |
N |
Flag indicating customer is on DDPF master. Valid Values: 1=on DDPF |
|
c_comtt |
COMTT |
CHAR(1) |
N |
Comment flag. Valid Values: Y=comment record associated with this customer |
|
c_cvtr |
CVTR |
CHAR(1) |
N |
Converter flag. Valid Values: Blank=no boxes, 1=at least one addressable box 2=non-addressable box |
|
c_eftsflg |
EFTSFLG |
CHAR(1) |
N |
Flag indicating if selecting on EFTS customer. Valid Values: 1=EFTS cust, 2=pre-noted, =no |
|
c_hwseq |
HWSEQ |
CHAR(1) |
N |
Code designating Honeywell sequence number. Valid Values: legal values are 0-Z |
|
c_stmtcycle |
STMTCYCLE |
CHAR(1) |
N |
Cycle for this statement image. Valid Values: A-D |
|
c_ssn |
SSN |
CHAR(9) |
N |
Customer's Social Security number. |
|
c_ppvdt |
PPVDT |
DATETIME |
Y |
Last PPV purchase date. |
|
c_form |
Beginning c_form delimiter |
|||
|
code |
FORM |
CHAR(1) |
N |
Type of statement to send to this customer. Valid Values: S=Statement, P=Postcard, Q=Coupon, N=None (EFTS cust) |
|
shortdescription |
CHAR(8) |
Type of statement description |
||
|
longdescription |
CHAR(30) |
|||
|
/c_form |
Ending c_form delimiter |
|||
|
c_dcnt |
Beginning c_dcnt delimiter |
|||
|
code |
DCNT |
CHAR(1) |
N |
Code for discounting the customer's services. Valid Values: One code can be used to denote tax exemption (TAXEMPT in CONTROLPARAMS table) |
|
shortdescription |
CHAR(8) |
Discount code short description |
||
|
longdescription |
CHAR(30) |
Discount code long description |
||
|
/c_dcnt |
Ending c_dcnt delimiter |
|||
|
c_cycle |
Beginning c_cycle delimiter |
|||
|
code |
CYCLE |
CHAR(1) |
N |
In custmaster = customer's billing cycle, in cycletable = valid cycles for corp. Valid Values: A,B,C,D |
|
description |
CHAR(8) |
|||
|
/c_cycle |
Ending c_cycle delimiter |
|||
|
c_drsn |
Beginning c_drsn delimiter |
|||
|
code |
DRSN |
CHAR(1) |
N |
Disconnect reason. |
|
shortdescription |
CHAR(8) |
Disconnect reason short description |
||
|
longdescription |
CHAR(30) |
Disconnect reason long description |
||
|
/c_drsn |
Ending c_drsn delimiter |
|||
|
c_bdate |
BDATE |
DATETIME |
Y |
Bill Date. Valid Values: This customer's start or stop bill date |
|
c_idate |
IDATE |
DATETIME |
Y |
Date of the original install for this customer. Valid Values: |
|
c_rate |
RATE |
NUMERIC UNSIGNED |
N |
Monthly rate. |
|
c_dpst |
DPST |
NUMERIC SIGNED |
N |
Amount of money held on deposit for this customer. |
|
c_wrt |
WRT |
NUMERIC SIGNED |
N |
Amount of money that has been written-off for thisaccount and not recovered yet. Valid Values: Is the amt of the writeoff adj(debit balance amt will have credit amt in the field) OR 1=write to HS |
|
c_cur |
CUR |
NUMERIC SIGNED |
N |
Money in the current money bucket. |
|
c_c30 |
C30 |
NUMERIC SIGNED |
N |
Portion of the balance that is aged 30 days. |
|
c_c60 |
C60 |
NUMERIC SIGNED |
N |
Portion of the balance that is aged 60 days. |
|
c_c90 |
C90 |
NUMERIC SIGNED |
N |
Portion of the balance that is aged 90 days. |
|
c_c120 |
C120 |
NUMERIC SIGNED |
N |
Portion of the balance that is aged 120 days. |
|
c_colst |
Beginning c_colst delimiter |
|||
|
code |
COLST |
CHAR(1) |
N |
Collection status. Valid Values: Blank=not in collections. '1'=in collections "2"=pending npd/in collections "3"=not in collections but has a custcollect record for products |
|
description |
CHAR(40) |
Mode description |
||
|
/c_colst |
Ending c_colst delimiter |
|||
|
c_badr |
BADR |
CHAR(1) |
N |
Designates billing address formats. Valid Values: 1=Billing address only-add'l mail to svc addrs 2=Mailing address - all mail to this address |
|
c_slsrep |
SLSREP |
CHAR(3) |
N |
Sales rep who sold this account. |
|
c_otlcnt |
OTLCNT |
SMALLINT UNSIGNED |
N |
Number of active outlets for this customer. |
|
c_adjcnt |
ADJCNT |
SMALLINT UNSIGNED |
N |
Count for the adjustment comment. |
|
c_pvclb |
PVCLB |
CHAR(1) |
N |
PPV club discount membership. Valid Values: values 1-7 |
|
c_stat |
Beginning c_stat delimiter |
|||
|
code |
STAT |
CHAR(1) |
N |
Status for cust - 1=P/IN 2=P/RS 3=P/CH 4=P/DS 5=ACTIVE 6=DISC 7=X/IN. Valid Values: REFUND STATUS 1,2,3,D,H,P,S,T,W EVENT DESCRIPTION TABLE 1-4 |
|
shortdescription |
CHAR(8) |
Status short description. |
||
|
longdescription |
CHAR(30) |
|
Status long description. |
|
|
/c_stat |
Ending c_stat delimiter |
|||
|
c_ppvled |
PPVLED |
SMALLINT UNSIGNED |
N |
Ledger item number that holds PPV charges for the current period. |
|
c_colcnt |
COLCNT |
SMALLINT UNSIGNED |
N |
Counter for contact comments. |
|
c_nbrpays |
NBRPAYS |
SMALLINT UNSIGNED |
N |
Number of pay services for this customer. Valid Values: 1-9 |
|
c_finbl |
FINBL |
CHAR(1) |
N |
Final bill sent flag. Valid Values: 1=last bill sent 2=transfer type job |
|
c_cxrsn |
Beginning c_cxrsn delimiter |
|||
|
code |
CXRSN |
CHAR(1) |
N |
Reason for cancelling the install. |
|
shortdescription |
CHAR(8) |
Cancel reason short description |
||
|
longdescription |
CHAR(30) |
Cancel reason long description |
||
|
/c_cxrsn |
Ending c_cxrsn delimiter |
|||
|
c_ltwlz |
LTWLZ |
CHAR(1) |
N |
Items posted in twilight - between cutoff and update. |
|
c_lperup |
LPERUP |
CHAR(1) |
N |
Last period this record was updated. Valid Values: A-X |
|
c_coitem |
COITEM |
SMALLINT UNSIGNED |
N |
The ledgr item number (line number) of the first item posted in twilight. |
|
c_nxtslot |
NXTSLOT |
SMALLINT UNSIGNED |
N |
Nxt ldgr slot(line number) to insert new ldgr itemor nxt open slot for assigning jobs to CDW. |
|
c_rem |
REM |
CHAR(1) |
N |
Reminder scheme for this customer. Valid Values: A-D only |
|
c_stmtplan |
STMTPLAN |
SMALLINT UNSIGNED |
N |
Plan # for last statement sent this customer. |
|
c_lastidate |
LASTIDATE |
DATETIME |
Y |
The date the cust was last installed. This date will be updated with each install. (Restart date). |
|
c_annivday |
ANNIVDAY |
SMALLINT SIGNED |
N |
Day of the month specified as the customer's anniversary day. Valid Values: 1-31 |
|
c_chargethrudate |
CHARGETHRUDATE |
DATETIME |
Y |
The last date the charging run was excuted for this sub.. |
|
c_billthrudate |
BILLTHRUDATE |
DATETIME |
Y |
Date updated by DDPF to indicate the bill through period.. |
|
c_drivlicnsnum |
DRIVLICNSNUM |
CHAR(15) |
N |
No longer used...see DRIVERSLCNUM below. |
|
c_twlprorate |
TWLPRORATE |
NUMERIC SIGNED |
N |
In Memo Credit scheme is the sum total of the credit prorates during 'twilight'. |
|
c_crdtprorat |
CRDTPRORAT |
NUMERIC SIGNED |
N |
In the Memo Credit scheme is the sum total of the credit prorates taken...(not during twilight). |
|
c_memocrdt |
MEMOCRDT |
NUMERIC SIGNED |
N |
In the Memo Credit scheme is the total amount of payments,credit adjs,ppv credits not yet posted.. |
|
c_driverslcnum |
DRIVERSLCNUM |
CHAR(21) |
Y |
Drivers License Number. |
|
c_hold |
HOLD |
SMALLINT SIGNED |
N |
Hold option. Valid Values: 0=not on hold. 1=no upgrades. 2=no ppv ordering. 3=no upgrades or ppv. 4=no transfers. 5=no transfers or upgrades. 6=no transfers or ppv7=no transfers, upgrades, or ppv order ing |
|
c_tallybucket |
TALLYBUCKET |
SMALLINT SIGNED |
N |
Tells which bucket in the Customer Tally table is current.. Valid Values: 0 - 24 |
|
c_vip |
VIP |
CHAR(1) |
N |
VIP flag in the customer to exclude the account from collections.. Valid Values: Y=yes |
|
c_rareacd |
RAREACD |
SMALLINT SIGNED |
N |
Residence/home phone area code. |
|
c_rphonarea |
RPHONAREA |
CHAR(1) |
N |
36 code table tied to the residence/home phone number. (used to be 8th digit of phone). Valid Values: 0-9, A-Z |
|
c_custpin |
CUSTPIN |
CHAR(4) |
N |
Customer level personal identification number. Valid Values: numeric |
|
c_pinchgopr |
PINCHGOPR |
CHAR(3) |
N |
Operator who last changed customer PIN. |
|
c_lastpinchgdte_id |
LASTPINCHGDTE_ID |
DATETIME |
Y |
Last PIN change date. |
|
c_custmail |
Beginning c_custmail delimiter |
|||
|
code |
CUSTMAIL |
CHAR(1) |
N |
Customer Mail flag As defined by code 36 table. |
|
shortdescription |
CHAR(8) |
Customer Mail flag short description |
||
|
longdescription |
CHAR(20) |
Customer Mail flag long description |
||
|
/c_custmail |
Ending c_custmail delimiter |
|||
|
c_fastrates |
FASTRATES |
VARCHAR(360) |
N |
Rate codes from custrates stored horizontallyconcatenated. |
|
c_incntcttype1 |
Beginning c_incntcttype1 delimiter |
|||
|
code |
INCNTCTTYPE1 |
CHAR(2) |
N |
INBOUND CUSTOMER CONTACT CODE #1. Valid Values: " 1" - "95", " " |
|
shortdescription |
CHAR(8) |
Inbound customer contact short description |
||
|
longdescription |
CHAR(20) |
Inbound customer contact long description |
||
|
/c_incntcttype1 |
Ending c_incnttype1 delimiter |
|||
|
c_incntcttype2 |
Beginning c_incntcttype2 delimiter |
|||
|
code |
INCNTCTTYPE2 |
CHAR(2) |
N |
INBOUND CUSTOMER CONTACT CODE #2. Valid Values: " 1" - "95", " " |
|
shortdescription |
Inbound customer contact short description |
|||
|
longdescription |
Inbound customer contact long description |
|||
|
/c_incntcttype2 |
Ending c_incntcttype2 delimiter |
|||
|
c_incntcttype3 |
Beginning c_incntcttype3 delimiter |
|||
|
code |
INCNTCTTYPE3 |
CHAR(2) |
N |
INBOUND CUSTOMER CONTACT CODE #3. Valid Values: " 1" - "95", " " |
|
shortdescription |
Inbound customer contact short description |
|||
|
longdescription |
Inbound customer contact long description |
|||
|
/c_incntcttype3 |
Ending c_incntcttype3 delimiter |
|||
|
c_outcntcttype1 |
Beginning c_outcntcttype1 delimiter |
|||
|
code |
OUTCNTCTTYPE1 |
CHAR(2) |
N |
OUTBOUND CUSTOMER CONTACT CODE #1. Valid Values: " 1" - "95", " " |
|
shortdescription |
Outbound customer contact short description |
|||
|
longdescription |
Outbound customer contact long description |
|||
|
/c_outcntcttype1 |
Ending c_outcntcttype1 delimiter |
|||
|
c_outcntcttype2 |
Beginning c_outcntcttype2 delimiter |
|||
|
code |
OUTCNTCTTYPE2 |
CHAR(2) |
N |
OUTBOUND CUSTOMER CONTACT CODE #2. Valid Values: " 1" - "95", " " |
|
shortdescription |
Outbound customer contact short description |
|||
|
longdescription |
Outbound customer contact long description |
|||
|
c_outcntcttype2 |
Ending c_outcntcttype2 delimiter |
|||
|
c_outcntcttype3 |
Beginning c_outcntcttype3 delimiter |
|||
|
code |
OUTCNTCTTYPE3 |
CHAR(2) |
N |
OUTBOUND CUSTOMER CONTACT CODE #3. Valid Values: " 1" - "95", " " |
|
shortdescription |
Outbound customer contact short description |
|||
|
longdescription |
Outbound customer contact long description |
|||
|
/c_outcntcttype3 |
Ending c_outcntcttype3 delimiter |
|||
|
c_hsds |
HSDS |
SMALLINT UNSIGNED |
N |
Indicates whether HSDS rate codes exist on account. Valid Values: 0= no HSDS rate codes1= at least 1 HSDS rate code on the account |
|
cba_bil1 |
BIL1 |
VARCHAR(26) |
N |
The 'in care of' line. |
|
cba_bil2 |
BIL2 |
VARCHAR(26) |
N |
Street address. |
|
cba_bil3 |
BIL3 |
VARCHAR(17) |
N |
City and state. |
|
cba_bil4 |
BIL4 |
VARCHAR(6) |
N |
Billing zip code. |
|
customercomments |
Beginning customercomments delimiter |
|||
|
cmnt_comtyp |
Beginning cmnt_comtyp delimiter |
|||
|
code |
COMTYP |
CHAR(1) |
N |
Type of comment record if in COMMENTMASTER will beH,J,Y,1-6 If in WIPORDCOMMS will be N,W. Valid Values: h=house, j=adjustment,y=contact 1-6=customer but if wip comment n = order, w = wip |
|
description |
CHAR(20) |
Comment type description |
||
|
/cmnt_comtyp |
Ending cmnt_comtyp delimiter |
|||
|
cmnt_cntact |
CNTACT |
SMALLINT UNSIGNED |
N |
Contact. |
|
cmnt_opr |
OPR |
CHAR(3) |
N |
ID of the operator responsible for latest transaction. Valid Values: "---" = ARU, "***" = Upload "###" = VOD API |
|
cmnt_tmstp |
TMSTP |
DATETIME |
N |
Timestamp of when the comment was keyed. |
|
cmnt_commt |
COMMT |
VARCHAR(350) |
N |
Text of a free form comment. |
|
/customercomments |
Ending customercomments delimiter |