Home > Technical > Table Definitions > AREACLASS

AREACLASS

If the user in a certain management area is only allowed to see/use certain classifications, those classifications are listed here. If no records exist for a management area, the user can see any classification. The records link back to the master record in MANAGEMENTAREA.

Column

Type

Description

STRAREACODE

VARCHAR(10)

The management area code to which this record belongs.

MANAGEMENTAREA.strAreaCode

STRCLASSCODE

VARCHAR(10)

The classification the user is allowed to see. When a user does a search for items, only items in the classification will be visible.
CLASS.strClassCode

YSNMODIFY

VARCHAR(1)

If 'T' the user can modify items that belong in this classification. If 'F', they can view but not edit the item.

INTUPDATE

INT

Not currently used.

INTINSERTEDBY

INT

Not currently used.

DTMLOCALINSERTED

DATETIME

Not currently used.

DTMUTCINSERTED

DATETIME

Not currently used.

INTUPDATEDBY

INT

Not currently used.

DTMLOCALUPDATED

DATETIME

Not currently used.

DMUTCUPDATED

DATETIME

Not currently used.

 

Primary Key: STRAREACODE + STRCLASSCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)