Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width33%

CDR_RECORD_DEF

Col #Column NameData TypeField LengthNot 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

  
Column
width33%