Groups
CDR_FIELD_FORMAT_DEF
| Col # | Column Name | Data Type | Field Length | Not 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 (Class:CdrFieldFormatDef, Table: CDR_FIELD_FORMAT_DEF) defines the format of a field defitnion (CDR_FIELD_DEF) (see /wiki/spaces/Integration/pages/119155850).