|
XML Tag |
Definition |
|
comcorp |
Five digit system number assigned to each corp. |
|
XML Tag |
Column Name |
Data Type |
Nullable |
Definition |
|
ppvp_corp |
CORP |
INT UNSIGNED |
N |
Five digit accounting corp number assigned to each corp |
|
ppvparamsgroup |
Beginnning ppvparamsgroup delimiter |
|||
|
ppvp_ppvclub |
PPVCLUB |
CHAR(1) |
N |
Flag for using the PPV club discount scheme. Valid Values: |
|
ppvp_svpermastr |
SVPERMASTR |
SMALLINT UNSIGNED |
N |
Number of periods to save masters. Valid Values: 1-22 |
|
ppvp_svpersingl |
SVPERSINGL |
SMALLINT UNSIGNED |
N |
Number of periods to save singles. Valid Values: 1-22 |
|
ppvp_pkgdetail |
PKGDETAIL |
CHAR(1) |
N |
Show PPV package detail on statement as componentsare viewed. Valid Values: 1=use |
|
ppvp_twoway |
TWOWAY |
CHAR(1) |
N |
Flag indicating whether this controller uses two way addressability. Valid Values: 1=using 2 way edits, =not using |
|
ppvp_mastrflag |
MASTRFLAG |
CHAR(1) |
N |
Switch to designate if corp is using master events. Valid Values: blank=no master events,1=using masters |
|
ppvp_evnumlimit |
EVNUMLIMIT |
INT UNSIGNED |
N |
Highest event number allowed (99,999 maximum). Valid Values: |
|
ppvp_ppvmodule |
PPVMODULE |
CHAR(1) |
N |
Flag if corp is using the PPV module. Valid Values: 1 = USING MODULE |
|
ppvp_ppvanal |
PPVANAL |
CHAR(1) |
N |
Flags usage of the PPV Analysis module. Valid Values: 1 = USING MODULE |
|
ppvp_ppvchgonce |
PPVCHGONCE |
CHAR(1) |
N |
Switch for charging ppv by outlet. Valid Values: 1=charge once per event blank=charge by outlet |
|
ppvp_ppvcnclbox |
PPVCNCLBOX |
CHAR(3) |
N |
Cancel reason for PPV on 2-way system. Valid Values: 1-999 |
|
ppvp_ppvdefrcod |
PPVDEFRCOD |
CHAR(2) |
N |
Default rate code for PPV events if no other code provided. Valid Values: |
|
ppvp_ppvdefsum |
PPVDEFSUM |
SMALLINT SIGNED |
N |
Default sum code for PPV events. Valid Values: Range from -1 to +4094, excluding 46, 63, 832,845,2944, 2990, and 4032. -1 = not used. |
|
ppvp_ppvrefrmt |
PPVREFRMT |
CHAR(1) |
N |
PPV reformat...NO APPLY TO SQL. Valid Values: 1=Reformatting the manager file |
|
ppvp_ppvordtyp |
PPVORDTYP |
CHAR(1) |
N |
Edit for determining how to recognize a delinquen t sub who can't order ppv. Valid Values: 1=flat, 2=flat+monthly rate, 3=multi ple of monthly rate, 4=aging |
|
ppvp_ppvordamt |
PPVORDAMT |
NUMERIC SIGNED |
N |
Edit by dollar amount or multiple of monthly rate. Valid Values: |
|
ppvp_ppvcur |
PPVCUR |
CHAR(1) |
N |
Use current money to calculate delinquent balance:ty pe 4 only. Valid Values: 1=use |
|
ppvp_ppvday30 |
PPVDAY30 |
CHAR(1) |
N |
Use 30 day money to calculate delinquent balance: ty pe 4 only. Valid Values: |
|
ppvp_ppvday60 |
PPVDAY60 |
CHAR(1) |
N |
Use 60 day money to calculate delinquent balance: ty. Valid Values: |
|
ppvp_ppvday90 |
PPVDAY90 |
CHAR(1) |
N |
Use 90 day money to calculate delinquent balance: ty pe 4 only. Valid Values: |
|
ppvp_ppvday120 |
PPVDAY120 |
CHAR(1) |
N |
Use 120 day money to calculate delinquent balance:type 4 only. Valid Values: |
|
ppvp_outcrsn1 |
OUTCRSN1 |
CHAR(2) |
N |
Pay/80 adjustment reason for Outage credit reason #1. Valid Values: "00"-"ZZ" |
|
ppvp_outcrdesc1 |
OUTCRDESC1 |
CHAR(8) |
N |
Outage credit reason description #1. Valid Values: |
|
ppvp_outcrsn2 |
OUTCRSN2 |
CHAR(2) |
N |
Pay/80 adjustmet reason for Outage credit reason #2. Valid Values: "00"-"ZZ" |
|
ppvp_outcrdesc2 |
OUTCRDESC2 |
CHAR(8) |
N |
Outage credit reason description #2. Valid Values: |
|
ppvp_outcrsn3 |
OUTCRSN3 |
CHAR(2) |
N |
Pay/80 adjustment reason for Outage credit reason#3. Valid Values: "00"-"ZZ" |
|
ppvp_outcrdesc3 |
OUTCRDESC3 |
CHAR(8) |
N |
Outage credit reason description #3. Valid Values: |
|
ppvp_outcrsn4 |
OUTCRSN4 |
CHAR(2) |
N |
Pay/80 adjustment reason for outage credit reason #4. Valid Values: "00"-"ZZ" |
|
ppvp_outcrdesc4 |
OUTCRDESC4 |
CHAR(8) |
N |
Outage credit reason description #4. Valid Values: |
|
ppvp_outcrsn5 |
OUTCRSN5 |
CHAR(2) |
N |
Pay/80 adjustment reason for Outage credit reason #5. Valid Values: "00"-"ZZ" |
|
ppvp_outcrdesc5 |
OUTCRDESC5 |
CHAR(8) |
N |
Outage credit reason description #5. Valid Values: |
|
ppvp_outcrsn6 |
OUTCRSN6 |
CHAR(2) |
N |
Pay/80 adjustment reason for Outage credit reason #6. Valid Values: "00"-"ZZ" |
|
ppvp_outcrdesc6 |
OUTCRDESC6 |
CHAR(8) |
N |
Outage credit reason description #6. Valid Values: |
|
ppvp_clubratcd1 |
CLUBRATCD1 |
CHAR(2) |
N |
PPV club rate code #1. Valid Values: |
|
ppvp_clubdesc1 |
CLUBDESC1 |
CHAR(8) |
N |
PPV club description #1. Valid Values: |
|
ppvp_clubratcd2 |
CLUBRATCD2 |
CHAR(2) |
N |
PPV club rate code #2. Valid Values: |
|
ppvp_clubdesc2 |
CLUBDESC2 |
CHAR(8) |
N |
PPV club description #2. Valid Values: |
|
ppvp_clubratcd3 |
CLUBRATCD3 |
CHAR(2) |
N |
PPV club rate code #3. Valid Values: |
|
ppvp_clubdesc3 |
CLUBDESC3 |
CHAR(8) |
N |
PPV club description #3. Valid Values: |
|
ppvp_clubratcd4 |
CLUBRATCD4 |
CHAR(2) |
N |
PPV club rate code #4. Valid Values: |
|
ppvp_clubdesc4 |
CLUBDESC4 |
CHAR(8) |
N |
PPV club description #4. Valid Values: |
|
ppvp_clubratcd5 |
CLUBRATCD5 |
CHAR(2) |
N |
PPV club rate code #5. Valid Values: |
|
ppvp_clubdesc5 |
CLUBDESC5 |
CHAR(8) |
N |
PPV club description #5. Valid Values: |
|
ppvp_clubratcd6 |
CLUBRATCD6 |
CHAR(2) |
N |
PPV club rate code #6. Valid Values: |
|
ppvp_clubdesc6 |
CLUBDESC6 |
CHAR(8) |
N |
PPV club description #6. Valid Values: |
|
ppvp_clubratcd7 |
CLUBRATCD7 |
CHAR(2) |
N |
PPV club rate code #7. Valid Values: |
|
ppvp_clubdesc7 |
CLUBDESC7 |
CHAR(8) |
N |
PPV club description #7. Valid Values: |
|
ppvp_ppvrundat |
PPVRUNDAT |
DATETIME |
Y |
Date of last PPV Charging Run. Valid Values: |
|
ppvp_svsumdays |
SVSUMDAYS |
SMALLINT UNSIGNED |
N |
PPV Anal # days to save summary records. Valid Values: |
|
ppvp_rollover |
ROLLOVER |
CHAR(1) |
N |
PPV Analysis rollover flags when it encounters duplicate event numbers. Valid Values: 1=duplicate events in PS file |
|
ppvp_cntpaylvl |
CNTPAYLVL |
CHAR(1) |
N |
For accounts with multiple event orders, switch todetermine how to count for the Buys By Svc Level. Valid Values: blank=use lowest # pays, 1=use highest # pays |
|
ppvp_revpersub |
REVPERSUB |
CHAR(1) |
N |
Calculate revenue per sub based on outage credits. Valid Values: blank=gross revenue, 1=net revenue |
|
ppvp_buysbysvc |
BUYSBYSVC |
CHAR(1) |
N |
Determines how to count master events in the Buy by Service Level Report. Valid Values: blank=singles+subscript'ns, 1=single+mastrs |
|
ppvp_adrsubcnt |
ADRSUBCNT |
INT UNSIGNED |
N |
PPV Analysis Module # of addressable subscribers. Valid Values: |
|
ppvp_mstrevtchrg |
MSTREVTCHRG |
SMALLINT UNSIGNED |
N |
Charge Master Event Flag. Valid Values: 0=Charge master event immediately 1=Charge master event after date of last event in package |
|
ppvp_createmultievts |
CREATEMULTIEVTS |
CHAR(1) |
N |
Charge Master Event Flag. Valid Values: 0=Charge master event immediately 1=Charge master event after date of last event in package |
|
ppvp_createallcomp |
CREATEALLCOMP |
CHAR(1) |
N |
Charge Master Event Flag. Valid Values: 0=Charge master event immediately 1=Charge master event after date of last event in package |
|
ppvp_nvodmode |
NVODMODE |
CHAR(1) |
N |
Charge Master Event Flag. Valid Values: 0=Charge master event immediately 1=Charge master event after date of last event in package |
|
ppvp_palevtcnt |
PALEVTCNT |
INT UNSIGNED |
N |
Charge Master Event Flag. Valid Values: 0=Charge master event immediately 1=Charge master event after date of last event in package |
|
ppvp_autocreatecnt |
AUTOCREATECNT |
INT UNSIGNED |
N |
Charge Master Event Flag. Valid Values: 0=Charge master event immediately 1=Charge master event after date of last event in package |
|
/ppvparamsgroup |
Ending ppvparamsgroup delimiter |