Alphabetical Field Summary
Alphabetical Index Summary
Alphabetical Trigger Summary
Other tables who reference user-access
allow-department Data type: CHARACTER
Format: x(60) (Initial Value: *)
Description: List of departments to allow access to
Help: List of department allowed, '*' for all, '!dept' to omit one
allow-division Data type: CHARACTER
Format: x(60) (Initial Value: *)
Description: List of divisions to allow access to
Help: List of divisions allowed, '*' for all, '!division' to omit
allow-group Data type: CHARACTER
Format: x(60) (Initial Value: *)
Description: List of employee groups to allow access to
Help: List of groups allowed, '*' for all, '!group' to omit one
allow-job Data type: CHARACTER
Format: x(60) (Initial Value: *)
Description: List of job codes to allow access to
Help: List of job codes allowed, '*' for all, '!job' to omit one
allow-location Data type: CHARACTER
Format: x(60) (Initial Value: *)
Description: List of locations to allow access to
Help: List of locations allowed, '*' for all, '!location' to omit
cre-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date this record was created
cre-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user who created this record
Attributes: Mandatory
extern-guid Data type: CHARACTER
Format: x(32)
Description: External Global Unique ID for this record
Attributes: Index Component
override-ssn Data type: CHARACTER
Format: x(70)
Description: List of override SSN's that are always allowed
Help: Employee SSN that are allowed regardless of other criteria
primary-key Data type: INTEGER
Format: zzzzzzzzz9
Help: Unique, Primary key for record
upd-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date this record was last updated
upd-user-name Data type: CHARACTER
Format: x(16)
Description: Name of user who last updated this record
user-name Data type: CHARACTER
Format: x(16)
Help: Login name of user to place restrictions on
Attributes: Index Component, Mandatory
view-unlisted Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes to allow viewing unlisted employees, No otherwise.
Created on 12/28/2020 by DBHTML V1.2