Filter
Top Products
306 APPENDIX E: MANUALLY CONFIGURING THE BILLING SUPPORT SERVER
To edit the table:
1 Using a text editor, open one of the following files:
■ To load data into an empty table, open the
/opt/3com/VCX/bss/db/cwbss/bulkload/bss_acct_server_map_data.txt
file.
■ To append data, open the
/opt/3com/VCX/bss/db/cwbss/bulkload/custom/bss_acct_server_map_
data.txt file.
2 Add one row for each billing support server/accounting server
relationship. For example:
|DESCRIPTION|SETUP_DATE|SERVER_ID_BSS|SERVER_ID_ACCT|FLG_COL
LECT_REQ
BSS and Accounting server|19-NOV-2001 00:00:00|1|1||
3 Save and close the file.
Configuring
job_collect_cdr
The job_collect_cdr table schedules the job that copies CDRs from the
accounting server database. The billing support server may get CDRs
from a single accounting server or from multiple accounting servers,
depending on the configuration of the table.
SERVER_ID_ACCT A unique identifier for this accounting server.
SERVER_ID_ACCT in this table must match a
SERVER_ID_ACCT in the acct_server_list table.
Integer
FLG_COLLECT_REQ Not used. N/A
Table 110 bss_acct_server_map Fields
Column Name Description Value
Table 111 job_collect_cdr Fields
Column Name Description Value
JOB_ID The unique identifier for the job. Integer
JOB_NUMBER This value is assigned by Oracle, not by user
assignment.
N/A
JOB_TO_SUBMIT The job name, usually a stored procedure
name, such as CWU.UPLOAD.
string
JOB_NEXT_RUN The next date/time the job will be run. Date
(continued)