Options C

On/Off or Value

Option

Default

Description

Dynamic

v

cactrrea

This option holds the Cancel Contract reason to use in fees. This is a Dynamic option.

v

callURL

This option holds the URL to be called in the Invoice Status and Payment Status tabs. This option allows users to link to a credit card/ACH processor outside of SBN. When users click on View Invoice, an external window linked to the processor will display, allowing them to make payments to or credit an account. This option holds both the URL to be called in the Invoice Status and Payment Status tabs as well as a list of parameters that SBN passes to the URL.

You may include these parameters as part of the option value:

• @clientcode@

• @acct_no@

• @acct_bal@

• @acct_name@

• @terminal@

v

canctrpw

Off

This option when on allows Contract Master #548 Cancel screen to be password protected. (Confirm button required if filled).

+

c

cbsmseml

On

Combined sms and emial in same sbn client form

-

v

cfcnt1

0

This option defines the value to use for counter 1 to charge variable cycle fees for SMS/Email messages in Monitoring.

v

cfcnt2

0

This option defines the value to use for counter 2 to charge variable cycle fees for alarm signals processed in Monitoring.

v

cfcnt3

0

This option defines the value to use for counter 3 to charge variable cycle fees for alarm exceptions in Monitoring.

v

cfcnt4

0

This option defines the value to use for counter 4 to charge variable cycle fees for false events in Monitoring.

v

cfcnt5

0

This option defines the value to use for counter 5 to charge variable cycle fees for client defined uses in Monitoring.

v

charconv

set char_convert off

Define this option to convert language-dependent characters in reports before sending the results to the client.

All clients not running in English must define this option.

c

chkcomm

On

When this option is on and a user logs into the GUI version, SBN provides a prompt when unread communication log records are available.

c

chknotic

Off

When on, SBN displays a notice assigned to a user in program #1503 the first time the user logs onto SBN. SBN does not display the notice again after the user accepts it.

Use option lognotic to display a user notice every time the user logs onto SBN, regardless of how many times the user accepts it.

+

v

chkvoid

30

Use this option to define the number of days SBN keeps voided AP vouchers before deleting them.

v

cirevex

-1

This option is for Protectron conversion issue only.

This option affects credit invoice work orders of a specific work type. The default of -1 causes no change to the system.

v

citycom

ad.city+’,’+ad.state+ad.zip

This option defines the format of the City column in Alarm Queue.

v

cjoin

.

This option is code in use for CROSS JOIN.

v

clogweb

blank

Use this option to define the URL that opens when you press the Launch URL button in the New Record window of the Communication Log (program #1888). You may also enter the parameters that SBN passes from the Communication Log entry to the URL.

Use the following parameters:

• @userbr@ - User Branch

• @userid@ - User ID

• @key1@ - Key 1

• @key2@ - Key 2

• @commcode@ - Communication Code

• @gen_src@ - Generating Source

• @lead_no@ - Marketing Inquiry number associated with the installation

• @acct_no@ - Account Number

• @ctr_no@ - Contract Number

• @ins_no@ - Installation Number

 +

v

cmsepos

ctr_no_sch

Use this option to define the default cursor position in Contract Master (program #548) when you choose the Search dialog box.

v

cmtab

blank

Use this option to define the order of the program tabs in Contract Master (program #548). The numbers to identify the tabs are: 01 Work Orders, 02 Collections, 03 Account Adjustments, 04 Account Change Log, 05 Contract Search, 06 Installation Data, 07 Miscellaneous Fields, 08 Invoice Status, 09 Payment Status, 10 Contract Change Log, 11 Contracts on Account, 12 Cycle Fee Change Log, 13 Cycle Fees, 14 Contract Texts, 15 Payment Methods, 16 Linked Billing Accounts, 17 Reminder Log, 18 Financed Work Orders.

For example, enter 02 08 13 for the value of this option to make the Collections tab appear first, Invoice Status tab second, and the Cycle Fees tab third. SBN will display the tabs you do not enter here to the right of the specified tabs in default order when you open Contract Master.

Note: The tab order entered in the Prg 548 Tabs field of Actions (program #1502) for your user action profile overrides the sequence entered for this option.

  +

v

cnschead

cnschd1 - cnsch6

"Name  Street1  City"

convert(char(24),ltrim(fname+'')+''+ltrim(ianame+'')+name)+''+

convert(char(23),ltrim(street1no1+'')+street1+''+street1no2)+''+

convert(char(12),city)

Contract name Search.

Total length must not exceed 61 characters.

v

cntmax

Counter max for counter bar

v

cog1

Use this option to define the event number values to return to a PDA.

This option is part of the Cognito integration enhancement.

+

v

cog10

Use this option to define the item code (from program #1535) to use on Cognito work orders for the weekend labor rate.

This option is part of the Cognito integration enhancement.

+

v

cog11

Use this option to define the item code (from program #1535) to use on Cognito work orders for the holiday labor rate.

This option is part of the Cognito integration enhancement.

+

v

cog12

Use this option to define the item code (from program #1535) to use on Cognito work orders for the special access labor rate.

This option is part of the Cognito integration enhancement.

+

v

cog13

Use this option to define the email address to which SBN sends RINT notifications.

This option is part of the Cognito integration enhancement.

+

v

cog14

Use this option to define a service request status code (from program #1525) that triggers SBN to send a sales email.

This option is part of the Cognito integration enhancement.

v

cog15

Use this option to define a service request status code (from program #1525) that triggers SBN to send an installation email.

This option is part of the Cognito integration enhancement.

v

cog16

Use this option to define a call type (from program #1524) that SBN uses for Action/Cause and Used Parts on Cognito service requests.

This option is part of the Cognito integration enhancement.

+

v

cog17

Use this option to define the item code (from program #1535) to use on Cognito work orders for the National Account Trip item that is less than 60.

This option is part of the Cognito integration enhancement.

+

v

cog18

Use this option to define the item code (from program #1535) to use on Cognito work orders for the National Account Trip item that is between 60 and 99.

This option is part of the Cognito integration enhancement.

+

v

cog19

Use this option to define the item code (from program #1535) to use on Cognito work orders for the National Account Trip item that is between 100 and 199.

This option is part of the Cognito integration enhancement.

+

v

cog2

Use this option to define the maximum number of Alarm Log records to return to a PDA.

This option is part of the Cognito integration enhancement.

+

v

cog20

Use this option to define the item code (from program #1535) to use on Cognito work orders for the National Account Trip item that is greater than 199.

This option is part of the Cognito integration enhancement.

+

v

cog21

Use this option to define a work order status that triggers special Cognito processing.

This option is part of the Cognito integration enhancement.

v

cog22

Use this option to define an item mask for CoC sys_info.

This option is part of the Cognito integration enhancement.

v

cog23

Use this option to define the number of rows of service request history to return to a handheld device.

This option is part of the Cognito integration enhancement.

v

cog24

Use this option to define the email address SBN uses for National Account service.

This option is part of the Cognito integration enhancement.

+

v

cog25

Use this option to define the email address SBN uses for National Account fire inspections.

This option is part of the Cognito integration enhancement.

+

v

cog26

Use this option to define the email address SBN uses for National Account maintenance.

This option is part of the Cognito integration enhancement.

+

v

cog27

Use this option to define a service request status code (from program #1525) that represents a fire inspection.

This option is part of the Cognito integration enhancement.

+

v

cog28

Use this option to define a service request status code (from program #1525) that represents maintenance.

This option is part of the Cognito integration enhancement.

+

v

cog29

Use this option to define a service request status code (from program #1525) that represents service.

This option is part of the Cognito integration enhancement.

+

c

cog3

When off, an operator can manually release a scheduled job to Cognito.

This option is part of the Cognito integration enhancement.

+

v

cog30

Use this option to define a list of dealers (from program #1537) included in the Parts List distribution.

This option is part of the Cognito integration enhancement.

+

v

cog31

Use this option to define a list of item codes (from program #1535) that represent Standard service on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog32

Use this option to define a list of item codes (from program #1535) that represent Premium service on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog33

Use this option to define a list of item codes (from program #1535) that represent Parts-Only service on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog34

Use this option to define a list of item codes (from program #1535) that represent Labor-Only service on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog35

Use this option to define a list of item codes (from program #1535) that represent batteries on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog36

Use this option to define an item code (from program #1535) that represents the standard trip/travel charge on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog37

Use this option to define a list of item codes (from program #1535) that represent Premium service on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog38

Use this option to define an item code (from program #1535) that represents the normal travel charge on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog39

Use this option to define an item code (from program #1535) that represents the non-business travel charge on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog4

Use this option to define the number of days to keep records in Cognito queues.

This option is part of the Cognito integration enhancement.

+

v

cog40

Use this option to define an item code (from program #1535) that represents the weekend travel charge on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog41

Use this option to define an item code (from program #1535) that represents the holiday travel charge on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog42

Use this option to define an item code (from program #1535) that represents the rate-based travel charge on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog43

Use this option to define a list of item codes (from program #1535) that represent special "no count" items on a Cognito work order.

This option is part of the Cognito integration enhancement.

+

v

cog44

72

Use this option to define the number of hours back that a Cognito technician can view information in the Alarm Log.

+

v

cog45

COGNITO

Use this option to define the error account in program #1794 to which SBN sends notifications of interface failure between the CognitoDataPush and Cognito.

+

v

cog46

Use this option to define the Message ID in program #1766 to use as the text of emails that SBN sends when a Cognito technician is en route to a job.

This email is sent to the email address on the service request or work order.

+

v

cog47

Use this option to enter the text to use in the subject line of emails that SBN sends when a Cognito technician is en route to a job.

This email is sent to the email address on the service request or work order.

+

v

cog48

Use this option to define the Message ID in program #1766 to use as the text of emails that SBN sends when a Cognito technician is scheduled for a job.

This email is sent to the email address on the service request or work order.

+

v

cog49

Use this option to enter the text to use in the subject line of emails that SBN sends when a Cognito technician is scheduled for a job.

This email is sent to the email address on the service request or work order.

+

v

cog5

Use this option to define the dollar amount limit at which a Cognito PDA automatically outdates a service request.

This option is part of the Cognito integration enhancement.

v

cog50

Use this option to define the Message ID in program #1766 to use as the text of emails that SBN sends when a service request for a Cognito technician is outdated.

This email is sent to the email address on the service request.

+

v

cog51

Use this option to enter the text to use in the subject line of emails that SBN sends when a service request for a Cognito technician is outdated.

This email is sent to the email address on the service request.

+

c

cog52

When on, SBN calls stored procedure hsm_get_email in pro_fe_cognito_tracking_email to retrieve customer email addresses for service ticket email notification from the Cognito web service.

v

cog53

N

Use this option to define the default value used by stored procedure fe_cognito_close_us that determines whether to close a Cognito work order. Valid values are Y (yes) or N (no).

+

v

cog54

COMP

+

v

cog55

NOAC

No access code to use for cognito interface.

v

cog56

Service Ticket status to Suppress update messages

v

cog6

Use this option to define the code that SBN enters for the Generating Source of Cognito work order Communication Log (program #1888) entries.

This option is part of the Cognito integration enhancement.

+

v

cog7

Use this option to define the code that SBN enters for the Communication Code of Cognito work order Communication Log (program #1888) entries.

This option is part of the Cognito integration enhancement.

+

v

cog8

Use this option to define the item code (from program #1535) to use on Cognito work orders for the normal labor rate.

This option is part of the Cognito integration enhancement.

+

v

cog9

Use this option to define the item code (from program #1535) to use on Cognito work orders for the non-business labor rate.

This option is part of the Cognito integration enhancement.

+

v

cogst1

blank

Use this option to define the service request status that initiates changes to the associated work order defined by options cogst2-cogst4. (Define service request status codes in program #1525.)

+

v

cogst2

blank

Use this option to define the work order type to change the work order associated with a service request to when the service request status is changed to the value of option cogst1 and the service request Chargeable flag is checked. (Define work order types in program #1796.)

+

v

cogst3

blank

Use this option to define the hold reason to add to the work order associated with a service request when the service request status is changed to the value of option cogst1 and the service request Chargeable flag is checked. (Define work order hold reasons in program #1896.)

+

v

cogst4

blank

Use this option to define the hold reason to add to the work order associated with a service request when the service request status is changed to the value of option cogst1 and the service request Chargeable flag is not checked. (Define work order hold reasons in program #1896.)

The value of this option also determines the hold reason to apply to the work order associated with a service request when the service request is outdated and closed.

+

v

cogst5

blank

Use this option to define the work order type to change the work order associated with a service request to when the service request status is changed to the value of option cogst1. (Define work order types in program #1796.)

    +

v

collagen

Use this option to:

• Define the default Vendor Type from the vendor master

• Identify collection agencies

This limits the menu used in Contract Master/Collections (program #548) to contain only vendors with this type.

v

comaappr

 XX

Use this option to define a series of 6 flags that indicate which commission types SBN calculates and stores in the Commission Change Log in Work Orders when a user approves a work order.

Type either an X or x in each of the fields that apply.

Lowercase x indicates the commission calculation will prepay a percentage of the commission based on the percentage defined in the commission type (program #1805). At invoicing 100% commission is calculated, but the discrepancy is not handled inside of SBN.

Position definitions are:

• Installers

• Sales Persons

• Telemarketers

• Managers

• Technicians

• Patrol-Officers

Defaults are in positions 2 and 3.

v

comaclos

X  XXX

Use this option to define a series of 6 flags that indicate which commission types SBN calculates and stores in the Commission Change Log in Work Orders when a user closes a work order.

Type either an X or x in each of the fields that apply.

Position definitions are:

• Installers

• Sales Persons

• Telemarketers

• Managers

• Technicians

• Patrol-Officers

Default is in position 1 and 4-6.

v

comcan

365

Use this option to define the maximum age of a contract, in days, for SBN to hold commission deductions when a user cancels a contract.

When this option defined with a value greater than zero, SBN compares the number of days elapsed from the contract Inservice Date to the contract End Date. If the result is greater than the default value, SBN does not deduct commission.

When this option is defined with a value of 0 (zero) deduction only occurs if flagged when choosing Cancel Contract [F6].

v

cominvo

Use this option to define a series of 6 flags that indicate which commission types SBN calculates and stores in the Commission Change Log in Work Orders when a user invoices a work order.

Type an x in each of the fields that apply.

Lowercase x indicates the commission calculation will insert 50% of the commission into the log. At invoicing 100% commission is calculated, but the discrepancy is not handled inside of SBN.

Position definitions are:

• Installers

• Sales Persons

• Telemarketers

• Managers

• Technicians

• Patrol-Officers

v

comlookb

168

Use this option to define the Communications Log history time (in hours).

v

comppaym

Use this option to define a series of 6 flags that indicate which commission types SBN calculates and stores in the Commission Change Log in Work Orders when a user posts a payment.

Type an x in each of the fields that apply.

Position definitions are:

• Installers

• Sales Persons

• Telemarketers

• Managers

• Technicians

• Patrol-Officers

v

comprof

XX

Use this option to define a series of 6 flags that indicate which commission types SBN calculates and stores in the Commission Change Log in Work Orders.

Type an x in each of the fields that apply.

Position definitions are:

• Installers

• Sales Persons

• Telemarketers

• Managers

• Technicians

• Patrol-Officers

Defaults are in positions 2 and 3.

v

comsave

Use this option to define a series of 6 flags that indicate which commission types SBN calculates and stores in the Commission Change Log in Work Orders when a user approves a work order.

Type an x in each of the fields that apply.

Position definitions are:

• Installers

• Sales Persons

• Telemarketers

• Managers

• Technicians

• Patrol-Officers

v

comso574

43

Use this option to define the Work Order Queue as the generating source for entries that a user creates in the Communication Log (program #1888) after choosing [CTRL+W] from the Work Order Queue.

Define this option with the internal number of the source for the Work Order Queue.

Run the following query in Interactive SQL (program #550) to find the internal number:
SELECT * from &communication_sources&
The internal number to use is the number in the s#scr column that corresponds with 574 in the source column.

+

v

comsosv

45

Use this option to define the generating source for entries that a user creates in the Communication Log (program #1888) after choosing [CTRL+W] from the Service Log tab of program #559.

Define this option with the internal number of the source for the program you want to use.

Run the following query in Interactive SQL (program #550) to find the internal number:
SELECT * from &communication_sources&

The internal number to use is the number in the s#scr column that corresponds with the program in the source column.

+

v

comsowo

44

Use this option to define the generating source for entries that a user creates in the Communication Log (program #1888) after choosing [CTRL+W] from a work order.

Define this option with the internal number of the source for the program you want to use.

Run the following query in Interactive SQL (program #550) to find the internal number:
SELECT * from &communication_sources&

The internal number to use is the number in the s#scr column that corresponds with the program in the source column.

+

v

comtpaym

bl

Use this option to define a series of 6 flags that indicate which commission types SBN calculates and stores in the Commission Change Log in Work Orders when a user posts a payment.

Type an x in each of the fields that apply.

Position definitions are:

• Installers

• Sales Persons

• Telemarketers

• Managers

• Technicians

• Patrol Officers

v

contweb

blank

Use this option to define a website that opens when you choose the Website button in Contract Master (program #548).

+

c

cpytsk1

Off

ma_alarmqueue1 will not insert to cpo_ma_alarmqueue

+

c

cpytsk1-16

On

When one of these options is off, the corresponding Alarm Queue (1-16) will not insert to cpo_ma_alarmqueue. (Option cpytsk1 is for ma_alarmqueue1, option cpytsk2 is for ma_alarmqueue2, etc.)

When on, these options populate the copytask outbound Alarm Queue tables so they are copied to the secondary server.

Note: Do not turn off all of these options. At least one of these options must be on in order for pro_cp_ma_moniout.sql to compile.

c

crbyacg

Off

When this option is on and a user calculates reminders in Reminder Calculation (program #1570), SBN calculates charges/reminders by subgroups within accounts and creates one reminder per group.

When this option is off and a user calculates reminders, SBN calculates charges/reminders by account and creates one reminder per account.

Example: If a user calculates reminders and:

• Account 1 has three reminder groups

• Account 2 has two reminder groups

When this option is on, SBN creates:

• Three reminders for Account 1

• Two reminders for Account 2

When this option is off, SBN creates:

• One reminder at the highest reminder subgroup for Account 1

• One reminder at the highest reminder subgroup for Account 2

When this option is on and a user exports reminders from Reminder Calculation (program #1570), the export lists the amount to pay by account, by remainder group.

When this option is off and a user exports reminders from Reminder Calculation (program #1570) the export lists amount to pay by account only.

Warning: Change this option with extreme care. Changing settings in the middle of running reminder calculations could have unintended consequences.

+

v

crchgrev

This option replaces crchgrev_flg in the billing_globals table.

Use this option to define the revenue type for reminder charges.

When blank, SBN will not create a reminder batch.

When defined, SBN creates reminder batch if reminder profile contains defined charges.

Warning: Change this option with extreme care. Changing settings in the middle of running reminder calculations could have unintended consequences.

+

v

crelogin

sbnpro..ba_create_login_no_op

SQL procedure hook to allow custom handling of new SBN user logins

c

crgrp

Off

This option replaces crpgrp_flg in the billing_globals table.

When this option is on and a user calculates reminders in Reminder Calculation (program #1570), SBN shifts reminder groups based on the past due date.

When this option is off and a user calculates reminders, SBN calculates reminder groups in sequence, regardless of how many days past due.

Example 1:

If current/last level is 4 and Reminder Group is blank:

   1.   You select a due date that includes 4 reminder group levels past due.

   2.   You calculate reminders.

If off, SBN calculates Group 1

If on, SBN calculates Group 4

Example 2:

If current/last level is 4 and Reminder Group is blank:

   1.   You select a due date that includes 6 reminder group levels past due.

   2.   You calculate reminders.

If off, SBN skips Group 5 and calculates reminders for Group 6 (SBN includes charges for Group 5 in Group 6.)

If on, SBN calculates Group 4.

Warning: Change this option with extreme care. Changing settings in the middle of running reminder calculations could have unintended consequences.

+

c

crpdue

On

This option replaces the crpdue_flg in the billing_globals table.

Although this option is dynamic, it should always be on. When this option is on and a user calculates reminders in Reminder Calculation (program #1570), SBN considers only past due invoices.

Off functionality is not possible at this time. When the off functionality is available and this option is off, when a user calculates reminders SBN will consider all open invoices.

Warning: Change this option with extreme care. Changing settings in the middle of running reminder calculations could have unintended consequences.

+

v

crypcdwd

Name of encryption algorithm for codeword

c

cs001

On

When on, RapidEyeViewer produces debug statements into a log file.

When off, you will get only an entry stating the input parameters received.

+

v

cssepos

ins_no_sch

Use this option to define the default cursor position for Customer Data (program #559) when a user returns from the Search dialog box.

v

cstmzn

60

Use this option to define the time zone offset from GMT, in minutes, for the central station.

c

ctios

On

turns on CtiOs integration

-

v

currdef

blank

Use this option to define the default currency in the Currency field when creating a new billing account in Contract Master (program #548). This option also defines the default currency in the Currency field of a new work order if there is no currency defined for the associated billing account.

+

v

currdef2

blank

Use this option to define the default currency in the Cycle Currency field when creating a new billing account in Contract Master (program #548). This option also defines the default currency in the Cycle Currency field of a new work order if there is no cycle currency defined for the associated billing account.

+