Groups
CDR_RECORD_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 | ||
| 3 | CODE | VARCHAR2 | 100 | Y | Defines how to process a record. Possible values are HEADER, TRAILER or DETAIL | |
| 4 | DESCRIPTION | VARCHAR2 | 250 | Y | ||
| 5 | CDR_FILE_DEF_ID | NUMBER | 22 | N | ||
| 6 | FIELD_SEPARATOR_ID | NUMBER | 22 | N | ||
| 7 | MAX_LENGTH | NUMBER | 22 | Y | ||
| 8 | FULL_LENGTH | CHAR | 1 | Y | ||
| 9 | CDR_PARSER_ID | NUMBER | 22 | Y | ||
| 10 | RECORD_TABLE_NAME | VARCHAR2 | 250 | N | ||
| 11 | RECORD_TABLE_CODE | VARCHAR2 | 250 | Y | ||
| 12 | RECORD_IDENTIFIER_TYPE | VARCHAR2 | 250 | Y | ||
| 13 | PERSIST | VARCHAR2 | 1 | Y | ||
| 14 | RECORD_CLASS | VARCHAR2 | 800 | Y | ||
| 15 | SOURCE_TABLE_KEY | VARCHAR2 | 800 | Y | ||
| 16 | STATUS_COLUMN_NAME | VARCHAR2 | 400 | Y | ||
| 17 | STATUS_VALUE | VARCHAR2 | 40 | Y | ||
| 18 | HOOKPOINT_KEY | VARCHAR2 | 400 | Y | ||
| 19 | DATE_LOADED_COLUMN_NAME | VARCHAR2 | 400 | Y |