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) |
