The contents of the sample are output to a database which is accessible using ActiveX Data Objects (ADO). Callback inserts a record for each customer of the sample into the cb_sample table of the ADO database. The InService application will not be responsible for deleting or archiving records. Output to redundant databases is not supported.
The following list defines the required columns for the cb_sample table. Other columns may be defined for use by the VRU module but will not be referenced by Callback interface. Only the customer-specific values provided by the CSS (oms_css.dll) will be inserted into the table.
|
Column |
Description |
|---|---|
|
Sampleid |
Identifier defining the nth sample generated |
|
Sequencenum |
Sequence of customer within the sample |
|
Eventnum |
Obtained from the InService application at the closing of the event. It is empty when a sample is generated through use of Generate Customer List command. |
|
Insertdts |
Timestamp when record was inserted by the Callback application |
|
Calldts |
Creation Timestamp associated with the InService outage event. It is empty when a sample is generated via use of Generate Customer List command. |
|
Restoredts |
Restore timestamp associated with the InService outage event. Empty when a sample is generated via use of Generate Customer List command. |
|
Genmode |
Generation mode where ‘A’ = automatic request or ‘M’ = manual request |
|
Seltype |
Defines which phase in which this customer was selected. ‘T’ = tagged, ‘S’ = station or transformer, or ‘R’ random selection |
|
Complete |
Indicates the sample is complete. This column is Set to ‘T’ once the entire sample is completed. |
|
Term |
Defines the originator’s terminal or nodename. It is only defined for manual requests. |
|
Empid |
Defines originator’s employee identifier |
|
Cisxfrmrname |
CSS transformer name |
|
Cisname |
CSS customer name |
|
Cisaddress |
CSS customer address |
|
Cisphone |
CSS customer phone |
|
Cisaccountnumber |
CSS customer account number |
|
Cismeter |
CSS meter number |
|
Cispremisenum |
CSS premise number |
|
Rowid |
Row Identifier (SQL Server only). In an SQL Server database, this column contains the unique row identifier used by DBRecovery. |