ACROLE – The Activity Management Role file stores resource roles and descriptions.

System
Activity Management (AC)
Prefix
ACH
Primary key
ROLE
Fields
3
Updated by
1 program
Referenced by
136 programs

ACROLE is the The Activity Management Role file stores resource roles and descriptions. table in Lawson Activity Management (prefix ACH). It is indexed by ROLE (ACHSET1); alternate indexes: ACHSET2. It is updated by AC03.8 and referenced by AC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 and 128 more. The table has 3 fields, 2 indexes and 0 documented relations.

About ACROLE

The Activity Management Role file stores resource roles and descriptions. This file is maintained via AC03.8 (Roles). This file stores the role, type and description. Valid types include manager, administrator and principal investigator.

Fields (3)

Column = COBOL field name without the ACH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ACH-ROLE PK
ROLE		Alpha 12The code that identifies a role that a resource has in relation to activities.AC03.8
ACH-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.AC03.8
ACH-RECORD-TYPE
RECORD_TYPE		Alpha 1The record type indicates if this is a system defined or user defined record. Currently there are three system defined types; manager, administrator, and principal investigator. " " = User Defined
  • 1 Manager
  • 2 Administrator
  • 3 Principal Investigator
AC03.8

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ACHSET1ROLEPrimaryAC03.1, AC03.7, AC03.8, AC203, AC52.1, AC520
ACHSET2RECORD-TYPE, ROLEKeyChangeAC01.1, AC03.7, AC03.8, AC105, AC112, AC113, AC120, AC121 +22 more (list truncated in source)

Programs

Updated by (1)

Referenced by (136)