Page Comparison

ID

Unique ID

NAME

Name of Field

CODE

For sub-classing

DESCRIPTION

Description of field

FILE_SPECIFICATION_NAME

Name of field in the Specification document

DB_COLUMN_NAME

Name of field in the Database table

CDR_FIELD_FORMAT_DEF_ID

ID of the format definition used to format the field, (CDR_FIELD_DEF.CDR_FIELD_FORMAT_DEF_ID = CDR_FIELD_FORMAT_DEF.ID)

SUMMABLE

Not used

SUM_FIELD_DEF_ID

Not used

MAX_LENGTH

Defines the maximum length of a field

FULL_LENGTH

Defines if the length of the field must be equal to MAX_LENGTH.

MANDATORY

Defines if the field must have a value

FIELD_POSITION

Defines the position of the field in a record (Not actually used)

START_INDEX

Defines start index of field in record. If a record does not have index separated fields, then this value is set to -1

END_INDEX

Defines end index of field in record. If a record does not have index separated fields, then this value is set to -1

FILLER

Defines what to use to fill the field. For example leading or trailer zero, white space, etc. Used for exporting
If a white space has to be used as filler, the value of this column must be WHITESPACE.

PADDING

Defines where the fillers should be placed on the field. Possible values are LEFT or RIGHT or NONE. Used for exporting
If NONE is used, no padding is done even  if the FULL_LENGTH is set to 'Y'. So use it cautiously.

FORMAT

Defines the format of the field. If present, it is used, else the value in the defined CDR_FIELD_FORMAT_DEF is used

EXPORTER_METHOD

A method on the CdrField class that must be called before this field is exported

DEFAULT_VALUE

Field default value

EMPTY_WHEN_ZERO

Sometimes a field might have a value of zero in the database, but should be exported as an empty field. This field can take either 'Y' or 'N' as values. default value is 'N', meaning field is exported as it is, otherwise if the field has a value of zero, it is exported as an empty string