Home > Technical > Table Definitions > 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. |
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. |
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) |