CDR_FILE_DEF

Groups

CDR_FILE_DEF

Col #	Column Name	Data Type	Field Length	Not Null?	Comments
1	ID	NUMBER	22	N
2	NAME	VARCHAR2	250	Y	Name of the Cdr File Definition
3	DESCRIPTION	VARCHAR2	250	Y	Description of Cdr File Definition
4	KEY	VARCHAR2	100	Y	Unique key of a file defintion
5	CODE	VARCHAR2	250	Y	Code, in-case sub classing is needed in the future
6	MAX_RECORDS	NUMBER	22	Y	Maximum number of records in a file (Default value -1 (no maximum number of records))
7	CDR_PARSER_ID	NUMBER	22	Y	Parser used for parsing a file into records (CDR_PARSER_ID = CDR_PARSER.ID)
8	BILLING_SOURCE_TABLE_NAME	VARCHAR2	250	N	Table name for storing file information source
9	RECORD_SEPARATOR_ID	NUMBER	22	Y	Type of separator used for separating one record from another (RECORD_SEPARATOR_ID = ITEM_SEPARATOR.ID). The default is a carriage return line feed
10	FILENAME_FORMAT	VARCHAR2	250	Y	Format of filename to be loaded (Perl regular expression format). If set only filenames that match the format will be processed otherwise all files are processed
11	EXPORT_TYPE	VARCHAR2	100	Y	The type of file records to be exported. Used when generating export files. The source table (for export) must have a column with name 'EXPORT_TYPE' whose value must match this value
12	PRE_EXPORT_PROCEDURE	VARCHAR2	250	Y	Used when exporting files. Called before any final generation processing commences. Used to add extra export values that can only be added at time of export
13	XML_DOCUMENT_DEF_ID	NUMBER	22	Y	Used when exporting XML files. (XML_DOCUMENT_DEF_ID = XML_DOCUMENT_DEF.ID)
14	BILLING_SOURCE_CLASS	VARCHAR2	800	Y	Class used to model the table defined in the column 'BILLING_SOURCE_TABLE_NAME'.
15	FILE_NAME_SUFFIX	VARCHAR2	40	Y	Suffix (extension) to be added to the export filename.
16	FILE_NAME_GENERATOR_METHOD	VARCHAR2	400	Y	Method on the BILLING_SOURCE_CLASS used to generate a filename during export. This method must take the ID of the record in the 'BILLING_SOURCE_TABLE_NAME' table, and the CDR_FILE_DEF ID as parameters. For example for exporting a CDR file, the ID will be the ID of the appropriate SP_FILE_HEADER record linked to the rated BILLING_RECORDs (BILLING_RECORD.SP_FILE_ID = SP_FILE_HEADER.ID) being exported.
17	PRE_PROCESSOR_METHOD	VARCHAR2	800	Y	Can specify e.g. method to be used for file validation before processing of files.
18	POST_PROCESSOR_METHOD	VARCHAR2	800	Y	Can specify e.g. method to be used for file validation after processing of files.
19	ERROR_PROCESSOR_METHOD	VARCHAR2	800	Y	Method in the BILLING_SOURCE_CLASS called after processing a file. The method must take CdrFileDef object as parameter. Could be used for validating contents of the detail against information on the trailer.
20	RECORD_FOR_HEADER	VARCHAR2	1	Y	Possible values are Y and N. This column is solely taken into an account if the PERSIST column has the value Y. In case the first line in the loaded file must be stored in the BATCH_FILE_LINE table, the RECORD_FOR_HEADER column must be set to Y.
21	STATUS_COLUMN_NAME	VARCHAR2	400	Y	String value. Defines the column name for status of billing source table. If left empty a default name of STATUS is used.
22	NUMBER_OF_RECS_COLUMN_NAME	VARCHAR2	400	Y	String with default value 'NUMBER_OF_RECS'. Defines the column name, where the number of the content lines in a loaded file must be stored.
23	DATE_LOADED_COLUMN_NAME	VARCHAR2	400	Y	String with default value 'DATE_LOADED'. Defines the column name, where the time of the loading must be stored. The column is mandatory in the billing source table.
24	SAVE_RECORD_ORDER	VARCHAR2	1	Y	Char with possible values 'Y'/'N' and default value 'N'. Defines whether line number of a loaded record must be stored in the db.
25	RECORD_ORDER_COLUMN_NAME	VARCHAR2	400	Y	String with default value 'LINE_IN_FILE'. Defines the column name, where the line-number of the loaded record must be stored.
26	STATUS_VALUE	VARCHAR2	40	Y	String with default value '0'. Defines the status of the loaded file.

Defines a CDR file (see File Processor Framework).