Cfa Attrib

This column holds the generated ID of the attribute.

This column holds the ID of the group this attribute belongs to.

This column holds the description of the attribute. The value should be a qualified SQL name

This column maps the attribute to a storage column on the entity specific CFAS Storage/Extension table. The value should be a qualified SQL name

This column determines the order which the attribute will be displayed on the CFAS UI.

This column holds the data type of the attribute

This column holds the UI item type that should be displayed on the Custom Data Entry UI. Valid values are TI (text item), RG (record group), LI (list item), CB (check box) and DT (date).

This column holds the ID of the record group associated with the attribute. Record groups are only needed when the attribute uses the record group (RG) UI item type. Record groups are defined on the CFA_REC_GROUP table. CFA record groups must be defined before an attribute using the record group is defined.

This column holds the specific custom code type associated with the attribute. Code types are only needed when the attribute uses the list item (LI) UI item type.

This column determines if the field is disabled (display only) or editable. The value of the attribute should be sourced from CFA_ATTRIB_GROUP_SET.DEFAULT_FUNC if the attribute is disabled.

This column determines if the field is required to be not null when a record is created in the custom extension storage table.

This column determines the maximum valid length the user can enter for field on the UI. A value is recommended for Char and Number attributes, and not valid for date attributes.

This value determines if the lowest numeric value that can be entered in the field. This value is optional and should only be populated when the data type of the attribute is NUMBER or DATE.

This value determines if the highest numeric value that can be entered in the field. This value is optional and should only be populated when the data type of the attribute is NUMBER or DATE.

This column holds the name (package and function) of code that should be called to validate this attribute.

This column indicates whether the attribute is displayed in the CFAS UI when accessed from the base UI. Used for simulation purposes.

This indicates if the attribute is Oracle defined. Oracle defined attributes can not be further customized.

This column indicates whether the editor is required for the attribute.