Home > Technical > Table Definitions > AREADEPT

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.

MANAGEMENTAREA.strAreaCode

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.

DEPT.strDeptCode

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)