XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

XML Tag

Column Name

Data Type

Nullable

Definition

cp_acctcorp

ACCTCORP

INT UNSIGNED

N

Home account corp number. Valid Values: All 5 digits of the corp number

cp_corp

CORP

INT UNSIGNED

N

Two digit system number assigned to each corp.The corp # is unique only within one Tandem system.. Valid Values:

cp_release

RELEASE

CHAR(3)

N

DDP software release corp is currently using. Valid Values:

cp_dname

DNAME

CHAR(22)

N

Business name of system. Valid Values:

cp_daddrs

DADDRS

CHAR(25)

N

Corp address. Valid Values:

cp_dcity

DCITY

CHAR(25)

N

City/State/Zip portion of Mailing address for corp. Valid Values:

cp_dphone1

DPHONE1

CHAR(7)

N

Corp office phone number. Valid Values:

cp_ddesc1

DDESC1

CHAR(6)

N

Corp office phone description. Valid Values:

cp_dphone2

DPHONE2

CHAR(7)

N

Corp service phone number. Valid Values:

cp_ddesc2

DDESC2

CHAR(6)

N

Corp service phone description. Valid Values:

cp_dfrnch

DFRNCH

CHAR(44)

N

Corp franchise name. Valid Values:

cp_defcity

DEFCITY

CHAR(18)

N

Default city. Valid Values:

cp_defstate

DEFSTATE

CHAR(2)

N

Default state. Valid Values:

cp_stopacct

STOPACCT

CHAR(6)

N

Account number assignment, stopping number. Valid Values:

cp_colorwarn

COLORWARN

CHAR(1)

N

Warning Screen color for order entry and dispatch. Valid Values: 0=cyan, 1=white, 2=red, 3=yellow, 4=magenta; 2=default

cp_colorgrid

COLORGRID

CHAR(1)

N

Background screen color for order entry and dispatch. Valid Values: 0=cyan, 1=white; default=0

cp_lglmgtbeg

LGLMGTBEG

SMALLINT UNSIGNED

N

Beginning legal management area range. Valid Values:

cp_lglmgtend

LGLMGTEND

SMALLINT UNSIGNED

N

Ending legal management area range. Valid Values:

cp_lglftaxbeg

LGLFTAXBEG

SMALLINT UNSIGNED

N

Beginning legal franchise tax area range. Valid Values:

cp_lglftaxend

LGLFTAXEND

SMALLINT UNSIGNED

N

Ending legal franchise tax area range. Valid Values:

cp_secure

SECURE

CHAR(6)

N

Master security. Valid Values:

cp_alarmpass

ALARMPASS

CHAR(6)

N

Password to clear alarm on CRT. Valid Values:

cp_timediff

TIMEDIFF

SMALLINT SIGNED

N

Time difference between Tandem location and corp site. Valid Values:

cp_dprioe

DPRIOE

CHAR(3)

N

Default program priority, Order Entry. Valid Values:

cp_dpridisp

DPRIDISP

CHAR(3)

N

Default program priority, Dispatch. Valid Values:

cp_dprichkin

DPRICHKIN

CHAR(3)

N

Default program priority, Checkin. Valid Values:

cp_dpripay

DPRIPAY

CHAR(3)

N

Default program priority, Pay/Adj. Valid Values:

cp_dpribox

DPRIBOX

CHAR(3)

N

Default program priority, Box Maintenance. Valid Values:

cp_dprimass

DPRIMASS

CHAR(3)

N

Default program priority in Mass Corrections. Valid Values:

cp_dpripost

DPRIPOST

CHAR(3)

N

Default program priority, Posting. Valid Values:

cp_saveart

SAVEART

CHAR(1)

N

Save ARTs. Valid Values: 1= don't purge

cp_hookoe

HOOKOE

CHAR(8)

N

Hook program, overlay to Order Entry. Valid Values:

cp_hookdisp

HOOKDISP

CHAR(8)

N

Hook program, overlay to Dispatch. Valid Values:

cp_hookchkin

HOOKCHKIN

CHAR(8)

N

Hook program, overlay to Checkin. Valid Values:

cp_jobmax

JOBMAX

SMALLINT UNSIGNED

N

Maximum number of jobs for Job Scheduler. Valid Values:

cp_daystart

DAYSTART

CHAR(2)

N

Work day start hour. Valid Values:

cp_daystop

DAYSTOP

CHAR(2)

N

Work day stop hour. Valid Values:

cp_altdrive

ALTDRIVE

CHAR(2)

N

Alternate drive for Job Scheduler if it encountersan error. Valid Values:

cp_payadjver

PAYADJVER

CHAR(1)

N

Switch for displaying subscriber's balance due in the payment field or name/address. Valid Values: blank= no auto verify; 1 = auto verify; 2 = auto verify and auto balance

cp_schdsatstr

SCHDSATSTR

DATETIME

Y

Job Scheduler Saturday start time. Valid Values:

cp_schdsatstp

SCHDSATSTP

DATETIME

Y

Job Scheduler Saturday stop time. Valid Values:

cp_schdsunstr

SCHDSUNSTR

DATETIME

Y

Job Scheduler Sunday start time. Valid Values:

cp_schdsunstp

SCHDSUNSTP

DATETIME

Y

Job Scheduler Sunday stop time. Valid Values:

cp_schwkdystr

SCHWKDYSTR

DATETIME

Y

Job Scheduler weekday start time. Valid Values:

cp_schwkdystp

SCHWKDYSTP

DATETIME

Y

Job Scheduler weekday stop time. Valid Values:

cp_schdnbr

SCHDNBR

SMALLINT UNSIGNED

N

Maximum Number of Job Schedulers. Valid Values:

cp_skipupdate

SKIPUPDATE

CHAR(1)

N

Flag indicating whether to skip update of mode, cycle, form, anniv day when running Update. Valid Values: 1=yes

cp_masscoropr

MASSCOROPR

CHAR(3)

N

Not used (to be deleted from table). Valid Values:

cp_curcycle

CURCYCLE

CHAR(1)

N

Current cycle. Valid Values: CYCLETABLE

cp_notape

NOTAPE

CHAR(1)

N

How to handle Cutoff files. Valid Values: blank=write tape, N=no tape write, 1=transmit 56

cp_curperod

CURPEROD

CHAR(1)

N

Current period code. Valid Values: a-x

cp_coprogrm

COPROGRM

CHAR(1)

N

Cutoff program has been started; flag is set afterStep 1 Promo processing & is cleared at end of run. Valid Values: 1=yes (cutoff in progress) - carried over from TBOL, no programs read this parameter< /font>

cp_lstcoper

LSTCOPER

CHAR(1)

N

Last cutoff period code. Valid Values: a-x

cp_wipsavper

WIPSAVPER

SMALLINT SIGNED

N

Number of periods to save completed work. Valid Values: 1-22

cp_hotap

HOTAP

CHAR(1)

N

Flag indicating whether Corp uses Hot Tap disconnect scheme. Valid Values: 1=send p/ds as complete

cp_lstupdper

LSTUPDPER

CHAR(1)

N

Last period code updated. Valid Values: a-x

cp_schedswt

SCHEDSWT

CHAR(1)

N

Schedule area switch. Valid Values: 1=mgt, 2=f/t, 3=zip

cp_chkfrmt

CHKFRMT

CHAR(1)

N

Refunds check format. Valid Values: blank=standard, 1=Canada, 2=Sarasota, 3=Tulsa, 4= Culver City

cp_duptag

DUPTAG

CHAR(1)

N

Flag to determine if o/e duplicates the tag number when adding a house. Valid Values:

cp_locswt

LOCSWT

SMALLINT UNSIGNED

N

Area Switch for which area the locator will represent...if zip, it is the last 3-5 char's. Valid Values: 1=mgt area, 2=f/tax, 3=zip code

cp_multiofc

MULTIOFC

CHAR(1)

N

Separate prt's for route cards/work orders by schedule area. Valid Values: 1=yes

cp_finalrpt

FINALRPT

CHAR(1)

N

Code indicating sort order for DDP cutoff report. Valid Values: 1=mgt, 2=f/t, 3=zip

cp_busidx1

BUSIDX1

CHAR(2)

N

Not used. Valid Values: blank

cp_busidx2

BUSIDX2

CHAR(2)

N

Not Used. Valid Values: blank

cp_busidx3

BUSIDX3

CHAR(2)

N

Not used. Valid Values: blank

cp_curpass

CURPASS

CHAR(1)

N

Pass code for the current DDPF audit. Valid Values: A-X

cp_lastpass

LASTPASS

CHAR(1)

N

Last pass code for DDPF audit. Valid Values: A-X

cp_p80audit

P80AUDIT

INT UNSIGNED

N

Number of accounts to send to DDPF to be auditted. Valid Values: =audit entire database,current sub in house

cp_p80prt

P80PRT

SMALLINT UNSIGNED

N

Print file # for DDP Financials reports. Valid Values:

cp_lboxbch

LBOXBCH

CHAR(1)

N

Make DDP batch and bank batch the same size (couldbe greater than 999 documents). Valid Values: 1=make bank and DDP batches the same size

cp_lstlbdate

LSTLBDATE

DATETIME

Y

Date of last lockbox tape/transmission. Valid Values:

cp_monendcyc

MONENDCYC

CHAR(1)

N

Month-end cycle code. Valid Values: A-D

cp_nbrcycles

NBRCYCLES

CHAR(2)

N

Number of cycles. Valid Values: 1-8

cp_lstcomon

LSTCOMON

CHAR(2)

N

Last month's cutoff. Valid Values:

cp_lstcocyc

LSTCOCYC

CHAR(1)

N

Last cycle cutoff. Valid Values: A-D

cp_taxempt

TAXEMPT

CHAR(1)

N

Tax exempt code from discount table. Valid Values:

cp_areachgs

AREACHGS

CHAR(1)

N

Not used (to be deleted from table). Valid Values:

cp_zipswt

ZIPSWT

CHAR(1)

N

Using ZIP+4 module. Valid Values: 1=yes

cp_crisdate

CRISDATE

DATETIME

Y

Current cris/cros version date, last time files were updated with zip+4/carrier route information. Valid Values:

cp_crisupd

CRISUPD

CHAR(1)

N

Flag to Request ZIP file from DDP Financials. Valid Values: 1=request on next cutoff

cp_zipchg

ZIPCHG

CHAR(1)

N

Zip file has been manually modified. Valid Values: 1=changes

cp_outagemod

OUTAGEMOD

CHAR(1)

N

Flag indicating use of the Interactive Outage Module. Valid Values: 1=yes

cp_ledgext

LEDGEXT

CHAR(1)

N

Flag indicating use of the Ledger Extension Module. Valid Values: 1=yes

cp_advpro

ADVPRO

CHAR(1)

N

Flag used to determine if Database Maint or Cutoffwill perform the swap transaction for promo codes. Valid Values: 1=yes/Cutoff will

cp_noprmopro

NOPRMOPRO

CHAR(1)

N

Don't prorate on the promo/retail swap transaction. Valid Values: 1=don't prorate

cp_printer

PRINTER

CHAR(1)

N

Statement image printer port flag. Valid Values: blank=Okidata 192, 1=Data Products Laser, 2=Okidata 320

cp_stmtimage

STMTIMAGE

CHAR(1)

N

Flag indicating use of Statement Image module. Valid Values: 1=yes

cp_stmtport

STMTPORT

SMALLINT UNSIGNED

N

Statement image printer port. Valid Values:

cp_rtrestrt

RTRESTRT

CHAR(6)

N

Not used (to be deleted from table). Valid Values:

cp_repaymt

REPAYMT

CHAR(6)

N

Not used (to be deleted from table). Valid Values:

cp_lasthous

LASTHOUS

CHAR(6)

N

Last house record processed by the MT Builder. Valid Values:

cp_rsvd

RSVD

CHAR(3)

N

Reserved. Valid Values:

cp_rsvd1

RSVD1

CHAR(1)

N

Reserved value. Valid Values:

cp_rsvd2

RSVD2

CHAR(1)

N

Reserved value. Valid Values:

cp_rsvd3

RSVD3

CHAR(1)

N

Reserved value. Valid Values:

cp_rsvd4

RSVD4

CHAR(1)

N

Reserved value. Valid Values:

cp_rsvd5

RSVD5

CHAR(1)

N

Reserved value. Valid Values:

cp_rsvd6

RSVD6

CHAR(1)

N

Reserved value. Valid Values:

cp_rsvd7

RSVD7

CHAR(1)

N

Reserved value. Valid Values:

cp_rsvd8

RSVD8

CHAR(1)

N

Reserved value. Valid Values:

cp_sqzpurgdat

SQZPURGDAT

DATETIME

Y

Last time Daily Processing was run in Database Maintenance. Valid Values:

cp_wrkfile

WRKFILE

CHAR(2)

N

Statement image work file drive assignment. Valid Values:

cp_cyca

CYCA

CHAR(2)

N

Drive assignment for cycle A statement image files. Valid Values:

cp_cycb

CYCB

CHAR(2)

N

Drive assignment for cycle B statement image files. Valid Values:

cp_cycc

CYCC

CHAR(2)

N

Drive assignment for cycle C statement image files. Valid Values:

cp_cycd

CYCD

CHAR(2)

N

Drive assignment for cycle D statement image files. Valid Values:

cp_prtdriv

PRTDRIV

CHAR(2)

N

Print file drive assignment. Valid Values:

cp_bxtrdrv

BXTRDRV

CHAR(2)

N

Not used. Valid Values:

cp_sendfrees

SENDFREES

CHAR(1)

N

Send frees (all free accounts) to DDPF. Valid Values:

cp_xpfiles

XPFILES

SMALLINT SIGNED

N

Current promo transaction file number. Valid Values: 1-9

cp_fndrive

FNDRIVE

CHAR(2)

N

Disk drive to place the financial files on.. Valid Values:

cp_xptrans

XPTRANS

INT SIGNED

N

# of transactions in the current XP file. Valid Values:

cp_xpmaxtrans

XPMAXTRANS

INT SIGNED

N

Maximum # of transactions per XP file. Valid Values:

cp_xp1purge

XP1PURGE

SMALLINT UNSIGNED

N

Purge flag for the XP1 file. Valid Values: 1=Cutoff program will purge at next Cutoff

cp_xp2purge

XP2PURGE

SMALLINT UNSIGNED

N

Purge flag for the XP2 file. Valid Values: 1=Cutoff program will purge at next Cutoff

cp_xp3purge

XP3PURGE

SMALLINT UNSIGNED

N

Purge flag for the XP3 file. Valid Values: 1=Cutoff program will purge at next Cutoff

cp_xp4purge

XP4PURGE

SMALLINT UNSIGNED

N

Purge flag for the XP4 file. Valid Values: 1=Cutoff program will purge at next Cutoff

cp_xp5purge

XP5PURGE

SMALLINT UNSIGNED

N

Purge flag for the XP5 file. Valid Values: 1=Cutoff program will purge at next Cutoff

cp_xp6purge

XP6PURGE

SMALLINT UNSIGNED

N

Purge flag for the XP6 file. Valid Values: 1=Cutoff program will purge at next Cutoff

cp_xp7purge

XP7PURGE

SMALLINT UNSIGNED

N

Purge flag for the XP7 file. Valid Values: 1=Cutoff program will purge at next Cutoff

cp_xp8purge

XP8PURGE

SMALLINT UNSIGNED

N

Purge flag for the XP8 file. Valid Values: 1=Cutoff program will purge at next Cutoff

cp_masscorprg

MASSCORPRG

CHAR(5)

N

Not used (to be deleted from table). Valid Values:

cp_xp9purge

XP9PURGE

SMALLINT UNSIGNED

N

Purge flag for the XP9 file. Valid Values: 1=Cutoff program will purge at next Cutoff

cp_excluse

EXCLUSE

SMALLINT UNSIGNED

N

Switch to indicate if CUTOFF has exclusive access to the database.. Valid Values: 0=Data base open to all programs, 1=CUTOFF has exclusive access. Some programs can't run.

cp_opt10perf

OPT10PERF

SMALLINT UNSIGNED

N

Indicates if option 10 of Order Entry will write to the Operator Performance table. Valid Values: 0=don't write 1=write entry

cp_opt12perf

OPT12PERF

SMALLINT UNSIGNED

N

Indicates if Option 12 of Order Entry will write to the Operator Performance table. Valid Values: 0=don't write 1=write entry

cp_lsthseadted

LSTHSEADTED

CHAR(6)

N

Last house number audited via Cutoff and DDPF. Valid Values:

cp_uploadrsvd

UPLOADRSVD

SMALLINT UNSIGNED

N

Reserved for the Upload program. Valid Values:

cp_arursvd

ARURSVD

SMALLINT UNSIGNED

N

ARU reserved value. Valid Values:

cp_colorwindw

COLORWINDW

SMALLINT UNSIGNED

N

Controls the background and text color for the standard window used in the DDP programs. Valid Values: 0-255

cp_annivbill

ANNIVBILL

SMALLINT UNSIGNED

N

Flag indicating if corp is using Anniversary Billing. Valid Values: 1=yes

cp_offcyclefirstbills

OFFCYCLEFIRSTBILLS

CHAR(1)

N

Flag indicating if corp is using off-cycle first bills. Valid Values: N=not using, Y=send, 1=suppress off-cyc 1st bill if true cyc is nxt cyc, 2=suppress if within 2 cyc

cp_memobills

MEMOBILLS

SMALLINT UNSIGNED

N

Flag indicating if corp is using memo bills. Valid Values: 0=not using memo bills, 1=using memo bills

cp_oprperfage

OPRPERFAGE

SMALLINT SIGNED

N

Number of Days to save for the operator performance records.. Valid Values: 14-9999 (includes current date)

cp_adjcommaxln

ADJCOMMAXLN

SMALLINT UNSIGNED

N

Max number of lines allowed for an adjustment comment. Valid Values: 1-10

cp_hscommaxln

HSCOMMAXLN

SMALLINT UNSIGNED

N

Max number of lines allowed for a house comment. Valid Values: 1-10

cp_cntcommaxln

CNTCOMMAXLN

SMALLINT UNSIGNED

N

Max number of lines allowed for a contact comment. Valid Values: 1-10

cp_ordcommaxln

ORDCOMMAXLN

SMALLINT UNSIGNED

N

Max number of lines allowed for an order comment. Valid Values: 1-10

cp_wipcommaxln

WIPCOMMAXLN

SMALLINT UNSIGNED

N

Max number of lines allowed for a WIP comment. Valid Values: 1-10

cp_flscommaxln

FLSCOMMAXLN

SMALLINT UNSIGNED

N

Max number of lines allowed for a flash comment. Valid Values: 1-10

cp_ccom1maxln

CCOM1MAXLN

SMALLINT UNSIGNED

N

Max number of lines allowed for customer comment 1. Valid Values: 1-10

cp_ccom2maxln

CCOM2MAXLN

SMALLINT UNSIGNED

N

Max number of lines allowed for customer comment 2. Valid Values: 1-10

cp_ccom3maxln

CCOM3MAXLN

SMALLINT UNSIGNED

N

Max number of lines allowed for customer comment 3. Valid Values: 1-10

cp_ccom4maxln

CCOM4MAXLN

SMALLINT UNSIGNED

N

Max number of lines allowed for customer comment 4. Valid Values: 1-10

cp_ccom5maxln

CCOM5MAXLN

SMALLINT UNSIGNED

N

Max number of lines allowed for customer comment 5. Valid Values: 1-10

cp_ccom6maxln

CCOM6MAXLN

SMALLINT UNSIGNED

N

Max number of lines allowed for customer comment 6. Valid Values: 1-10

cp_ccomdflt

CCOMDFLT

SMALLINT UNSIGNED

N

Customer comment number used as a default in OrderProcessing.. Valid Values: 1-6

cp_ccomtitle1

CCOMTITLE1

CHAR(15)

N

Title to use for customer comment 1. Valid Values:

cp_ccomtitle2

CCOMTITLE2

CHAR(15)

N

Title to use for customer comment 2. Valid Values:

cp_ccomtitle3

CCOMTITLE3

CHAR(15)

N

Title to use for customer comment 3. Valid Values:

cp_ccomtitle4

CCOMTITLE4

CHAR(15)

N

Title to use for customer comment 4. Valid Values:

cp_ccomtitle5

CCOMTITLE5

CHAR(15)

N

Title to use for customer comment 5. Valid Values:

cp_ccomtitle6

CCOMTITLE6

CHAR(15)

N

Title to use for customer comment 6. Valid Values:

cp_relsubvol

RELSUBVOL

CHAR(8)

N

If using programs/prt files 'flipped'(name flipped)Lets the Menu know how to build the file name.. Valid Values: If blank-names not flipped(DDP2100A.EXE) If as a value(DDPA2)that value is the subvol(DD PA2.DDP2100A

cp_memoppvmnt

MEMOPPVMNT

SMALLINT UNSIGNED

N

Flag designating if apply memo credits in the PPV Maintenance program.. Valid Values: 0 = no 1 = yes

cp_memolckbx

MEMOLCKBX

SMALLINT UNSIGNED

N

Flag designating if create memo credits in the Lockbox program. Valid Values: 0 = no 1 = yes

cp_memopayadj

MEMOPAYADJ

SMALLINT UNSIGNED

N

Flag designating if creating memo credits in the Pay/Adj program. Valid Values: 0 = no 1= yes

cp_memoop

MEMOOP

SMALLINT UNSIGNED

N

Flag designating if creating memo credits in the Order Processing program. Valid Values: 0=no 1=yes

cp_cutoffalertdte

CUTOFFALERTDTE

DATETIME

Y

Used to notify the cable system it is time to run a cutoff.... Valid Values: NULL = no alert (either cleared or not time yet) Date in field is the cutoff date and time to alert

cp_contactmodule

CONTACTMODULE

SMALLINT UNSIGNED

N

CORP IS USING THE CUSTOMER CONTACT MODULE. Valid Values: 0 = NO, 1 = YES

cp_rgnschd

RGNSCHD

SMALLINT UNSIGNED

N

Flag determining whether or not a corp's reports cwith the regional job schedular. Valid Values: 1=Yes

mcp_frontcounter

FRONTCOUNTER

CHAR(1)

N

Flag designating if using front counter tools. Valid Values: N = no Y = yes

mcp_olvq

OLVQ

CHAR(1)

N

Flag indicating whether or not the OLVQ module isin use in the associated corp.. Valid Values: Blank = OLVQ module is not in use."Y" = OLVQ module is in use.

mcp_autoprintwofrntcntr

AUTOPRINTWOFRNTCNTR

CHAR(1)

N

Auto print work orders at front counter after tak ing an order. Valid Values: Y=autoprint N=give a prompt to print or not.

mcp_autoprintrept

AUTOPRINTREPT

CHAR(1)

N

Auto Print receipts at front counter. Valid Values: Y=autoprint receipts N= give a prompt

mcp_auroprintboxrept

AUROPRINTBOXREPT

CHAR(1)

N

Y IF FRONTCOUNTER TOOLS SHOULD PRINT A BOX RECEIPTWITHOUT PROMPTING THE USER. Valid Values: Y N

mcp_autoprintdrawertally

AUTOPRINTDRAWERTALLY

CHAR(1)

N

Flag to designate if print is automatic or ask. Valid Values: Y = will be automatic N= will give prompt

mcp_autoprintboxagrmnt

AUTOPRINTBOXAGRMNT

CHAR(1)

N

Flag to designate if print is automatic or ask. Valid Values: Y = will be automatic N= will give prompt

mcp_autoprintwo

AUTOPRINTWO

CHAR(1)

N

Flag to designate if print is automatic or ask. Valid Values: Y = will be automatic N= will give prompt

mcp_defltareacd

DEFLTAREACD

CHAR(3)

N

Default phone area code if there is none already.. Valid Values:

mcp_dispdefltareacd

DISPDEFLTAREACD

CHAR(1)

N

Display default phone area code in Order Entry. Valid Values:

mcp_reqareacd

REQAREACD

CHAR(1)

N

Flag if area code is required or not. Valid Values: Y=yes, is required

mcp_ampsavper

AMPSAVPER

SMALLINT UNSIGNED

N

Number of periods to save amp history. Valid Values:

mcp_bbrdlocswt

BBRDLOCSWT

SMALLINT UNSIGNED

N

Bulletin board area locator switch. Valid Values: 1=mgt 2=f/tax 3=zip

mcp_cmpchgsvcrsn

CMPCHGSVCRSN

CHAR(3)

N

Reason code to use when forcing a change of service to a complete in order to create a NPD. Valid Values: 1-999

mcp_frequentbuyer

FREQUENTBUYER

CHAR(1)

N

Flag to indicate if the corp is using the Frequent Buyer Module. Valid Values: 'N' or 'Y'

mcp_usingauxfields

USINGAUXFIELDS

CHAR(1)

N

Flag to indicate if the corp is using Auxiliary Fields. Valid Values: 'N' or 'Y'

mcp_enhdualacct

ENHDUALACCT

CHAR(1)

N

Using enhanced dual account scheme. Valid Values: Y=using enhanced dual account scheme, N=not using enhanced scheme

mcp_gatewaymod

GATEWAYMOD

CHAR(1)

N

Is the corp using the optional Remote Field AccessManagement System for SQL. Valid Values: Y, N

mcp_techbatchindispatch

TECHBATCHINDISPATCH

CHAR(1)

N

Does the corp want to have tech batches open in Dispatch.. Valid Values: Y N

mcp_gatewayrouting

GATEWAYROUTING

SMALLINT SIGNED

N

Establishes the degree to which if at all the FSM system is routing.. Valid Values: 0 = not at all,1 = partial routing by remote system, 2 = remote system doing all routing.

mcp_masterpin

MASTERPIN

CHAR(4)

N

System Master PIN security code. Valid Values:

mcp_singlechannelconvfactor

SINGLECHANNELCONVFACTOR

SMALLINT UNSIGNED

N

Variable to adjust the number of customers in an outage to observed numbers.. Valid Values: Positive integer values.

mcp_distroconvfactor

DISTROCONVFACTOR

SMALLINT UNSIGNED

N

Variable to adjust the number of potential customers on an amp.. Valid Values: Positive integer values

mcp_viewablechannels

VIEWABLECHANNELS

SMALLINT UNSIGNED

N

Number of channles on a system. Used in calculating outage reports.. Valid Values: Positive integer values.

mcp_dictionaryrelease

DICTIONARYRELEASE

CHAR(3)

N

The current data dictionary release number. Valid Values:

mcp_screenpopinuse

SCREENPOPINUSE

CHAR(1)

N

CORP IS USING CALL SERVER (CAM) TO GET ACCT INFOSIMULTANEOUS WITH CALL. Valid Values: Y OR N

mcp_verifybatch

VERIFYBATCH

CHAR(1)

N

CORP IS USING CALL SERVER (CAM) TO GET ACCT INFOSIMULTANEOUS WITH CALL. Valid Values: Y OR N

mcp_paycardauthinuse

PAYCARDAUTHINUSE

SMALLINT UNSIGNED

N

Corp is using the payment card authorizationinterface system. Valid Values: 0=no 1=yes

mcp_creditchkmod

CREDITCHKMOD

CHAR(1)

N

Flag used to indicate whether or not the corp isusing the optional credit-check interface modulefor DDP/SQL. *For TELETRACK (3.17) merge to 4.0.Column name was TELETRACKMOD on 3.17.. Valid Values: Y or N(Default)