GetOperatorId

Input XML Tags

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

opr

Three character operator id

Output XML Tags

XML Tag

Column Name

Data Type

Nullable

Definition

opr_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

opr_opr

OPR

CHAR(3)

N

ID of operator

opr_addbox

ADDBOX

CHAR(1)

N

1 = operator can add/delete boxes

opr_addhse

ADDHSE

CHAR(1)

N

1 = operator can add/delete houses

opr_askcodes

ASKCODES

CHAR(1)

N

1 = operator can add more rate codes in Order Entry

opr_autochg

AUTOCHG

CHAR(1)

N

1 = operator can no truck auto-complete change of service orders

opr_autodisc

AUTODISC

CHAR(1)

N

1 = an operator can no truck auto-comp disconnect orders.

opr_autoinst

AUTOINST

CHAR(1)

N

1 = an operator can no truck auto-complete installs

opr_autorstr

AUTORSTR

CHAR(1)

N

1 = an operator can no truck auto-complete restarts

opr_autosro

AUTOSRO

CHAR(1)

N

1 = an operator can no truck auto-complete sro

opr_autotc

AUTOTC

CHAR(1)

N

1 = an operator can no truck auto-complete trouble calls

opr_batchadj

BATCHADJ

SMALLINT UNSIGNED

N

adjustment batch number that can be reopened

opr_batchdate

BATCHDATE

YEAR TO DAY

N

payment batch number that can be reopened

opr_batchpay

BATCHPAY

SMALLINT UNSIGNED

N

program that created the batch, 1=o/e, 2=checkin

opr_batchprog

BATCHPROG

CHAR(1)

N

y = operator is allowed entry into this program/option

opr_boxmaint01

BOXMAINT01

CHAR(1)

N

y = operator is allowed entry into this program/option

opr_boxmaint02

BOXMAINT02

CHAR(1)

N

y = operator is allowed entry into this program/option

opr_boxmaint03

BOXMAINT03

CHAR(1)

N

y = operator is allowed entry into this program/option

opr_boxmaint04

BOXMAINT04

CHAR(1)

N

y = operator is allowed entry into this program/option

opr_boxmaint05

BOXMAINT05

CHAR(1)

N

y = operator is allowed entry into this program/option

opr_boxmaint06

BOXMAINT06

CHAR(1)

N

y = operator is allowed entry into this program/option

opr_canpost

CANPOST

CHAR(1)

N

1 = an operator can post

opr_chgcoll

CHGCOLL

CHAR(1)

N

1 = ok to change whether this operator can chagne coll status/event AND override NACHA prenotification

opr_chghouse

CHGHOUSE

CHAR(1)

N

1 = operator can change house data

opr_seccode

SECCODE

CHAR(1)

N

password for operator id or group id

opr_credppv

CREDPPV

CHAR(1)

N

1 = operator can key in the PPV Credit

opr_crlimit

CRLIMIT

NUMERIC(7,2)

N

maximum credit adjustment for an account

opr_dept

DEPT

CHAR(3)

N

department number

opr_drlimits

DRLIMITS

NUMERIC(7,2)

N

maximum debit adjustment for one account

opr_frevents

FREVENTS

CHAR(1)

N

Flag for whether this operator can change the PPV Charging level; blank = skip, 1 = change charging level

opr_init

INIT

CHAR(2)

N

initials

opr_last

LAST

CHAR(12)

N

last name of operator

opr_makfree

MAKFREE

CHAR(1)

N

1 = operator can keyin free rate codes

opr_mustdochg

MUSTDOCHG

CHAR(1)

N

1 = operator can key a must do change of service

opr_mustdodisc

MUSTDODISC

CHAR(1)

N

1 = operator can key a must do disconnect

opr_mustdoinst

MUSTDOINST

CHAR(1)

N

1 = operator can key a must do install

opr_mustdorsch

MUSTDORSCH

CHAR(1)

N

1 = operator can key a must do reschedule

opr_mustdosro

MUSTDOSR0

CHAR(1)

N

1 = operator can key a must do sro

opr_mustdotc

MUSTDOTC

CHAR(1)

N

1 = operator can key a must do trouble call

opr_notrk

NOTRK

CHAR(1)

N

1 = operator can take a no-truck order

opr_install

INSTALL

CHAR(1)

N

Allow operator access to install option in the Order Processing program; Y = yes, N = no

opr_restart

RESTART

CHAR(1)

N

Allow operator access to restart option in the Order Processing program; Y = yes, N = no

opr_chgofsvc

CHGOFSVC

CHAR(1)

N

Allow operator access to change of service option in theOrder Processing program; Y = yes, N = no

opr_disc

DISC

CHAR(1)

N

Allow operator access to the disconnect option in the Order Processing program; Y = yes, N = no

opr_resched

RESCHED

CHAR(1)

N

Allow operator access to the reschedule option in the Order Processing program; Y = yes, N = no

opr_cancel

CANCEL

CHAR(1)

N

Allow operator access to the cancel option in the Order Processing program; Y = yes, N = no

opr_troublecall

TROUBLECALL

CHAR(1)

N

Allow operator access to the trouble call option in the Order Processing program; Y = yes, N = no

opr_specialreq

SPECIALREQ

CHAR(1)

N

Allow operator access to the special request option in the Order Processing program; Y = yes, N = no

opr_ppvorder

PPVORDER

CHAR(1)

N

Allow operator access to the PPV order option in the Order Processing program; Y = yes, N = no

opr_chghousecust

CHGHOUSECUST

CHAR(1)

N

Allow operator access to the change house/customer option in the Order Processing program; Y = yes, N = no

opr_display

DISPLAY

CHAR(1)

N

Allow operator access to the display box info option in the Order Processing program; Y = yes, N = no

opr_chgboxdata

CHGBOXDATA

CHAR(1)

N

Allow operator access to the change box data option in the Order Processing program; Y = yes, N = no

opr_payadj

PAYADJ

CHAR(1)

N

Allow operator access to the Payments and Adjustments option in the Order Processing program; Y = yes, N = n

opr_chgmoneystat

CHGMONEY

CHAR(1)

N

Allow operator access to the change money status option in the Order Processing program; Y = yes, N = no

opr_sendaltr

SENDALTR

CHAR(1)

N

Allow operator access to the send a letter option in the Order Processing program; Y = yes, N = no

opr_dispsystbl

DISPSYSTBL

CHAR(1)

N

Allow operator access to the display system tables option in the Order Processing program; Y = yes, N = no

opr_scratchpad

SCRATCHPAD

CHAR(1)

N

Allow operator access to the scratch pad option in the Order Processing program; Y = yes, N = no

opr_chgcorp

CHGCORP

CHAR(1)

N

Allwo operator access to the change corp option in the Order Processing program; Y = yes, N = no

opr_transfer

TRANSFER

CHAR(1)

N

Allow the operator access to the transfer option in the Order Processing program; Y = yes, N = no

opr_priboxmaint

PRIBOXMAINT

SMALLINT UNSIGNED

N

box maintenance program priority

opr_prioe

PRIOE

SMALLINT UNSIGNED

N

o/e program priority

opr_pripayadj

ORIPAYADH

SMALLINT UNSIGNED

N

pay/adj program priority

opr_prog01

PROG01

CHAR(1)

N

Y = allow access to program on menu

opr_prog02

PROG02

CHAR(1)

N

Y = allow access to program on menu

opr_prog03

PROG03

CHAR(1)

N

Y = allow access to program on menu

opr_prog04

PROG04

CHAR(1)

N

Y = allow access to program on menu

opr_prog05

PROG05

CHAR(1)

N

Y = allow access to program on menu

opr_prog06

PROG06

CHAR(1)

N

Y = allow access to program on menu

opr_prog07

PROG07

CHAR(1)

N

Y = allow access to program on menu

opr_prog08

PROG08

CHAR(1)

N

Y = allow access to program on menu

opr_prog09

PROG09

CHAR(1)

N

Y = allow access to program on menu

opr_prog010

PROG10

CHAR(1)

N

Y = allow access to program on menu

opr_prog011

PROG11

CHAR(1)

N

Y = allow access to program on menu

opr_prog012

PROG12

CHAR(1)

N

Y = allow access to program on menu

opr_prog013

PROG13

CHAR(1)

N

Y = allow access to program on menu

opr_prog014

PROG14

CHAR(1)

N

Y = allow access to program on menu

opr_prog015

PROG15

CHAR(1)

N

Y = allow access to program on menu

opr_prog016

PROG16

CHAR(1)

N

Y = allow access to program on menu

opr_prog017

PROG17

CHAR(1)

N

Y = allow access to program on menu

opr_prog018

PROG18

CHAR(1)

N

Y = allow access to program on menu

opr_quota01

QUOTA01

CHAR(1)

N

Y = allow operator to access this option of Quota Maintenance

opr_quota02

QUOTA02

CHAR(1)

N

Y = allow operator to access this option of Quota Maintenance

opr_quota03

QUOTA03

CHAR(1)

N

Y = allow operator to access this option of Quota Maintenance

opr_quota04

QUOTA04

CHAR(1)

N

Y = allow operator to access this option of Quota Maintenance

opr_quota05

QUOTA05

CHAR(1)

N

Y = allow operator to access this option of Quota Maintenance

opr_quota06

QUOTA06

CHAR(1)

N

Y = allow operator to access this option of Quota Maintenance

opr_quota07

QUOTA07

CHAR(1)

N

Y = allow operator to access this option of Quota Maintenance

opr_quota08

QUOTA08

CHAR(1)

N

Y = allow operator to access this option of Quota Maintenance

opr_quota09

QUOTA09

CHAR(1)

N

Y = allow operator to access this option of Quota Maintenance

opr_rteassg

RTEASSG

CHAR(1)

N

Y = operator can complete route assign

opr_savlog

SAVLOG

CHAR(1)

N

Y - save operator logon

opr_stat

STAT

CHAR(1)

N

 

opr_sysfunc

SYSFUNC

CHAR(1)

N

1 = operator is allowe into the System Functions menu

opr_takadj

TAKADJ

CHAR(1)

N

1 = operator can issue adjustments

opr_takpay

TAKPAY

CHAR(1)

N

1 = operator can take payments

opr_xoppv

XOPPV

CHAR(1)

N

1 = operator can cancel PPV orders

opr_prog19

PROG19

CHAR(1)

N

Y = allow access to program on menu

opr_prog20

PROG20

CHAR(1)

N

Y = allow access to program on menu

opr_prog21

PROG21

CHAR(1)

N

Y = allow access to program on menu

opr_prog22

PROG22

CHAR(1)

N

Y = allow access to program on menu

opr_prog23

PROG23

CHAR(1)

N

Y = allow access to program on menu

opr_prog24

PROG24

CHAR(1)

N

Y = allow access to program on menu

opr_prog25

PROG25

CHAR(1)

N

Y = allow access to program on menu

opr_prog26

PROG26

CHAR(1)

N

Y = allow access to program on menu

opr_prog27

PROG27

CHAR(1)

N

Y = allow access to program on menu

opr_prog28

PROG28

CHAR(1)

N

Y = allow access to program on menu

opr_prog29

PROG29

CHAR(1)

N

Y = allow access to program on menu

opr_prog30

PROG30

CHAR(1)

N

Y = allow access to program on menu

opr_prog31

PROG31

CHAR(1)

N

Y = allow access to program on menu

opr_prog32

PROG32

CHAR(1)

N

Y = allow access to program on menu

opr_prog33

PROG33

CHAR(1)

N

Y = allow access to program on menu

opr_prog34

PROG34

CHAR(1)

N

Y = allow access to program on menu

opr_prog35

PROG35

CHAR(1)

N

Y = allow access to program on menu

opr_prog36

PROG36

CHAR(1)

N

Y = allow access to program on menu

opr_prog37

PROG37

CHAR(1)

N

Y = allow access to program on menu

opr_prog38

PROG38

CHAR(1)

N

Y = allow access to program on menu

opr_prog39

PROG39

CHAR(1)

N

Y = allow access to program on menu

opr_prog40

PROG40

CHAR(1)

N

Y = allow access to program on menu

opr_prog41

PROG41

CHAR(1)

N

Y = allow access to program on menu

opr_prog42

PROG42

CHAR(1)

N

Y = allow access to program on menu

opr_prog43

PROG43

CHAR(1)

N

Y = allow access to program on menu

opr_prog44

PROG44

CHAR(1)

N

Y = allow access to program on menu

opr_prog45

PROG45

CHAR(1)

N

Y = allow access to program on menu

opr_prog46

PROG46

CHAR(1)

N

Y = allow access to program on menu

opr_prog47

PROG47

CHAR(1)

N

Y = allow access to program on menu

opr_prog48

PROG48

CHAR(1)

N

Y = allow access to program on menu

opr_prog49

PROG49

CHAR(1)

N

Y = allow access to program on menu

opr_prog50

PROG50

CHAR(1)

N

Y = allow access to program on menu

opr_prog51

PROG51

CHAR(1)

N

Y = allow access to program on menu

opr_prog52

PROG52

CHAR(1)

N

Y = allow access to program on menu

opr_prog53

PROG53

CHAR(1)

N

Y = allow access to program on menu

opr_prog54

PROG54

CHAR(1)

N

Y = allow access to program on menu

opr_prog55

PROG55

CHAR(1)

N

Y = allow access to program on menu

opr_prog56

PROG56

CHAR(1)

N

Y = allow access to program on menu

opr_prog57

PROG57

CHAR(1)

N

Y = allow access to program on menu

opr_prog58

PROG58

CHAR(1)

N

Y = allow access to program on menu

opr_prog59

PROG59

CHAR(1)

N

Y = allow access to program on menu

opr_prog60

PROG60

CHAR(1)

N

Y = allow access to program on menu

opr_prog61

PROG61

CHAR(1)

N

Y = allow access to program on menu

opr_prog62

PROG62

CHAR(1)

N

Y = allow access to program on menu

opr_prog63

PROG63

CHAR(1)

N

Y = allow access to program on menu

opr_prog64

PROG64

CHAR(1)

N

Y = allow access to program on menu

opr_prog65

PROG65

CHAR(1)

N

Y = allow access to program on menu

opr_prog66

PROG66

CHAR(1)

N

Y = allow access to program on menu

opr_prog67

PROG67

CHAR(1)

N

Y = allow access to program on menu

opr_prog68

PROG68

CHAR(1)

N

Y = allow access to program on menu

opr_prog69

PROG69

CHAR(1)

N

Y = allow access to program on menu

opr_prog70

PROG70

CHAR(1)

N

Y = allow access to program on menu

opr_btchseq

BTCHSEQ

SMALLINT UNSIGNED

N

re-open batch sequence number

opr_delchecks

DELCHECKS

CHAR(1)

N

1 = operator can delete refund checks

opr_quickaccess

QUICKACCESS

SMALLINT UNSIGNED

N

quick access method in Order Entry; 0 = none, 1 = account number, 2 = phone number

opr_ovrannivday

OVRANNIVDAY

SMALLINT UNSIGNED

N

1 = operator can override the default anniversary day

opr_jobsfortech

JOBSFORTECH

CHAR(1)

N

Allow operator access to display job status in the Dispatch option in the Order Processing program; Y = yes, N = no

opr_chgjobstat

CHGJOBSTAT

CHAR(1)

N

Allow operator access to change job status in the Dispatch option in the Order Processing program; Y = yes, N = no

opr_reassignjob

REASSIGNJOB

CHAR(1)

N

Allow operator access to reassign a job in the Dispatch option in the Order Processing program; Y = yes, N = no

opr_notdonejobs

NOTDONEJOBS

CHAR(1)

N

Allow operator access to not done jobs in the Dispatch option in the Order Processing program; Y = yes, N = no

opr_pooljobs

POOLJOBS

CHAR(1)

N

Allow operator access to display pool jobs in the Dispatch option in the Order Processing program; Y = yes, N = no

opr_assignjobs

ASSIGNJOBS

CHAR(1)

N

Allow operator access to pool assign jobs in the Dispatch option in the Order Processing program; Y = yes, N = no

opr_oealerts

OEALERTS

CHAR(1)

N

Allow operator access to the Order Processing Alerts; Y = yes, N = no

opr_outagemod

OUTAGEMOD

CHAR(1)

N

1 = allow operator use of the interactive outage module

opr_setoutage

SETOUTAGE

CHAR(1)

N

Allow operator access to the 'set outage' option in the outage module; Y = yes, N = no

opr_delbox

DELBOX

CHAR(1)

N

Allow operator ability to remove boxes from the database; Y = yes, N = no

opr_orderentry

ORDERENTRY

CHAR(1)

N

Allow operator access to the Order Entry option; Y = yes, N = no

opr_recalcppvmask

RECALCPPVMASK

CHAR(1)

N

Allow operator ability to select option to recalculate the PPV mask; Y = yes, N = no

opr_delhouse

DELHOUSE

CHAR(1)

N

Allow operator ability to delete house and address from the database; Y = yes, N = no

opr_chghouseaddrs

CHGHOUSEADDRS

CHAR(1)

N

Allow operator ability to change house and address information; Y = yes, N = no

opr_chgcustdata

CHGCUSTDATA

CHAR(1)

N

Allow operator ability to change customer data; Y = yes, N = n

opr_chgefts

CHGEFTS

CHAR(1)

N

Allow operator ability to change EFTS information; Y = yes, N = no

opr_chgrefunds

CHGREFUNDS

CHAR(1)

N

Allow operator ability to change refund information; Y = yes, N = no

opr_dispatch

DISPATCH

CHAR(1)

N

Allow operator acces to the Dispatch option; Y = yes, N = no

opr_clearoutage

CLEAROUTAGE

CHAR(1)

N

Allow operator the ability to 'clear outage' in the outage module; Y = yes, N= no

opr_clearcalltot

CLEARCALLTOT

CHAR(1)

N

Allow opeator the ability to 'clear call totals' in the outage module; Y = yes, N = no

opr_chkinnotrks

CHKINNOTRKS

CHAR(1)

N

Allow operator access to the Check In No Trucks option in the Ordeer Processing program; Y = yes, N = no

opr_autochkin

AUTOCHKIN

CHAR(1)

N

Allow operator to access Auto-Checkin option in the Order Processing program; Y = yes, N = no

opr_chkindailywrk

CHKINDAILYWRK

CHAR(1)

N

Y = allow operator to check in daily work

opr_ovrideprenote

OVRIDEPRENOTE

CHAR(1)

N

Allow operator to override pre-notification in the EFTS scheme; Y = yes, N = no

opr_ovrideppvbal

OVRIDEPPVBAL

CHAR(1)

N

Allow operator to override the PPV balance restrictions; Y = yes, N = no

opr_paylimit

PAYLIMIT

NUMERIC(7,2)

N

operator can not enter a payment greater than this amount

opr_chgopr

CHGOPR

CHAR(3)

N

Operator that last changed this record

opr_chgdate

CHGDATE

YEAR TO MINUTE

N

Date this record was last changed

opr_begbalcash

BEGBALCASH

NUMERIC(7,2)

N

Beginning cash balance for the front counter drawer for this operator 0.00 = 99999.99

opr_begbalchk

BEGBALCHK

NUMERIC(7,2)

N

Beginning balance for any checks for the front counter drawer for this operator 0.00 - 99999.99

opr_begbalmo

BEGBALMO

NUMERIC(7,2)

N

Beginnint balance for money orders for the front counter drawer for this operator 0.00 - 99999.99

opr_begbalcrdtcrd

BEGBALCRDTCRD

NUMERIC(7,2)

N

Beginning balance for credit cards for the front counter drawer for this operator 0.00 - 99999.99

opr_stmtport

STMTPORT

SMALLINT UNSIGNED

N

Statement Image printer port

opr_chgcolldate

CHGCOLLDATE

SMALLINT UNSIGNED

N

Flag designating if the operator can change the next step collections date and the max # of days. 0 = cannot change, 1,2…max number of ndays allowed to advance the date in order procesing

opr_chgcollpath

CHGCOLLPATH

CHAR(1)

N

operator can change an accounts collections path; Y = yes, N = no

opr_chgcolstepclass

CHGCOLSTEPCLASS

CHAR(1)

N

 

opr_chgholds

CHGHOLDS

SMALLINT UNSIGNED

N

Flag designating if the operator can place or remove a collections hold on an account (upgrade or ppv ordering) 0 = no, 1 = yes

opr_purgecolprod

PURGECOLPROD

CHAR(1)

N

Flag designates if the operator has the option to delte products before the number of days to save has expired ; Y = yes, N = no

opr_cnclchg

CNCLCHG

CHAR(1)

N

Allowed to access the disconnect option when there is a pending change on the account. Y = yes - OP will cancel/complete the pending change automatically when the disconnect is placed

opr_forceopenclosecoll

FORCEOPENCLOSECOLL

SMALLINT UNSIGNED

N

Determines if operator can force open close collection; Y or blank

opr_queueplaceassignremove

QUEUEPLACEASSIGNREMOVE

SMALLINT UNSIGNED

N

Flag designates if the operator can place/assign/or remove accounts in the collection queue; 0 = no, 1 = yes

opr_agencyplaceassignremove

AGENCYPLACEASSIGNREMOVE

SMALLINT UNSIGNED

N

Flag designates if the operator can place/assign/or remove accounts from a collection agency; 0 = no, 1 = yes

opr_chgvip

CHGVIP

CHAR(1)

N

Flag designating if the operator can change the customer VIP flag; Y = yes, N = no

opr_regionopr

REGIONOPR

CHAR(1)

N

Flag designating regional or national access; 0 = no regional or national access, 1 = regional access, 2 = national access

opr_chgtally

CHGTALLY

CHAR(1)

N

Flag designating if the operator can change a tally count; Y = yes, N = no

opr_collque

COLLQUE

CHAR(1)

N

Flag desgnation if this operator can place accts into the collection queue; Y = yes, N = no

opr_cqassign

CQASSIGN

CHAR(1)

N

Flag designating if the operator can asign accts in the queue to collectors; Y = yes, N = no

opr_chgdelcustpin

CHGDELCUSTPIN

CHAR(1)

N

Flag indicating if operator allowe d to change customer PIN; Y = yes, N = no

opr_changeaux

CHANGEAUX

CHAR(1)

N

Flag to allow/disallow an operator to change/ener auxilliary field information in Order Processing; Y = yes, N = no

opr_screenpopext

SCREENPOPEXT

CHAR(12)

N

Unique identifier to relate operator with CAM extension to receive call information

opr_screenpopagent

SCREENPOPAGENT

CHAR(1)

N

Designates an operator as one to receive automatic account access with a call; Y = yes, N = no

opr_inboundcontact

INBOUNDCONTACT

SMALLINT UNSIGNED

N

Allow entry of inbound customer contact information; 0 = no, 1 = yes

opr_outboundcontact

OUTBOUNDCONTACT

SMALLINT UNSIGNED

N

Allow entry of outbound customer contact codes; 0 = no, 1 = yes

opr_regiondisp

REGIONDISP

CHAR(1)

N

Flag designating regional access to Dispatch; 0 = no, 1 = yes

opr_regionckin

REGIONCKIN

CHAR(1)

N

Flag designating regional access to Check In; 0 = no, 1 = yes

opr_regionpay

REGIONPAY

CHAR(1)

N

Flag designating regional access to Pay/Adjst, 0 = no, 1 = yes

opr_regionpost

REGIONPOST

CHAR(1)

N

Flag designating regional access to Posting; 0 = no, 1 = yes

opr_regionbox

REGIONBOX

CHAR(1)

N

Flag designating regional access to Box Maintenance; 0 = no, 1 = yes

opr_taxexempt

TAXEXEMPT

CHAR(1)

N

Flag indicating if this operator can change tax exempt information in Order Entry; Y = yes, N = no

 

 

Source Tables