Home > Technical > Table Definitions > AREADEPT
If the user in a certain management area is only allowed to see/use certain department, those departments are listed here. If no records exist for a management area, the user can see any department. 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. |
STRDEPTCODE |
VARCHAR(10) |
The department the user is allowed to see. When a user does a search for items, only items in the department will be visible. |
YSNMODIFY |
VARCHAR(1) |
If 'T' the user can modify items that belong in this department. 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 + STRDEPTCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |