Data Element Dictionary › Attribute_Name Table

Previous Topic: attmnt_folder Table

Next Topic: Audit_Log Table

Attribute_Name Table

Provides corresponding user name for an object attribute. Default population for the table should set at_name and at_dflt to the same thing. The user sees and is able to modify only the at_name. at_dflt is used to restore the default name. at_desc could be user changeable or not. It is of use for identifying the attribute for an as yet unplanned user maintenance application. at_sys should never be seen by the user, nor should at_obj.

Field

Data Type

Reference

Remarks

at_desc

STRING 240

 

Specifies the description of the attribute.

at_dflt

STRING 30

 

Specifies the default external name.

at_name

STRING 30

 

Specifies the user name for attribute.

at_obj

STRING 30 S_KEY

 

Specifies the system object name.

at_sys

STRING 30 S_KEY

 

Specifies the system name.

del

INTEGER NOT_NULL

 

Deleted flag

0—Active

1—Inactive/marked as deleted

id

INTEGER UNIQUE NOT_NULL KEY

 

Unique (to the table) Numeric ID