CDR_FIELD_FORMAT_DEF

Owned by Søren Duusgaard (Deactivated)
Last updated: 05.09.2014

Groups

CDR_FIELD_FORMAT_DEF

Col #Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

NAME

VARCHAR2

250

Y

 Name of Field format definition.
3

CODE

VARCHAR2

100

Y

 Code used for sub-classing.
4

DESCRIPTION

VARCHAR2

250

Y

 Description of field format definition.
5

FILLER

VARCHAR2

10

Y

 Filler used to format field before export. If present in the corresponding CDR_FIELD_DEF, the filler from CDR_FIELD_DEF is used.
6

PADDING

VARCHAR2

100

Y

 Padding used to format field before export. If present in the corresponding CDR_FIELD_DEF, the padding from CDR_FIELD_DEF is used.
7

DECIMAL_PLACES

NUMBER

22

Y

 Number of decimal places to use. If decimal format is present in the corresponding CDR_FIELD_DEF, the format from CDR_FIELD_DEF is used.
8

DECIMAL_SEPARATOR

CHAR

1

Y

 No longer used. The COUNTRY_LOCALE now defines the decimal separator.
9

DATE_FORMAT

VARCHAR2

100

Y

 Format of date, if this is a date format definition (CODE = 'DATE'). If format is present in the corresponding CDR_FIELD_DEF, the format from CDR_FIELD_DEF is used.
10

DATA_FORMAT

VARCHAR2

100

Y

 Format of field data (regular expression), if this is a data format definition (CODE = 'DATA'). If format is present in the corresponding CDR_FIELD_DEF, the format from CDR_FIELD_DEF is used.
11

TIME_FORMAT

VARCHAR2

100

Y

 Format of time, if this is a time format definition (CODE = 'TIME'. If format is present in the corresponding CDR_FIELD_DEF, the format from CDR_FIELD_DEF is used.
12

COUNTRY_LOCALE

VARCHAR2

12

Y

 Locale used to define the decimal separator, Used for Decimal (CODE = 'DECIMAL'), signed-decimal (CODE = 'SIGNED-DECIMAL') format definitions. Examples are such as "NL" and "GB".

A CDR field format definition defines the format of a field defitnion (CDR_FIELD_DEF) (see File Processor Framework).