ACASNROLE – The Assignment Role file will store the roles associated with a resource assignment.

System
Activity Management (AC)
Prefix
ALE
Primary key
ACTIVITY-GRP, ACTIVITY, RESOURCE-TYPE, COMPANY, RESOURCE-CODE, ROLE
Fields
9
Updated by
134 programs
Referenced by
7 programs

ACASNROLE is the The Assignment Role file will store the roles associated with a resource assignment. table in Lawson Activity Management (prefix ALE). It is indexed by ACTIVITY-GRP, ACTIVITY, RESOURCE-TYPE, COMPANY, RESOURCE-CODE, ROLE (ALESET1); alternate indexes: ALESET2, ALESET3 and ALESET4. It is related 1:1 to ACACTGRP, ACACTIVITY, ACASSIGN and ACROLE and 1:M to ACRESHIST. It is updated by AC01.1, AC03.7, AC10.1, AC105, AC110, AC112, AC113, AC120 and 126 more and referenced by AC50.1, AC52.1, ACBR.1, ACSB.1, BR10.4, BR13.1 and BRIP.1. The table has 9 fields, 4 indexes and 5 documented relations.

About ACASNROLE

The Assignment Role file will store the roles associated with a resource assignment. This file is maintained via AC03.7 (Resources).

Fields (9)

Column = COBOL field name without the ALE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ALE-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15The activity group to which the resource is assigned.AC03.7, AC110, AC120, AC500, AC520
#ALE-ACTIVITY PK
ACTIVITY		Alpha 15The activity to which the resource is assigned. This field is blank when resources are assigned to the activity group.AC03.7, AC110, AC500, AC520
#ALE-COMPANY PK
COMPANY		Numeric 4Resource Company. Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AC03.7, AC110, AC500, AC520
#ALE-RESOURCE-TYPE PK
RESOURCE_TYPE		Alpha 1The type of resource.AC03.7, AC110, AC500, AC520
#ALE-RESOURCE-CODE PK
RESOURCE_CODE		Alpha 10The code identifying the resource assigned to the activity or activity group.AC03.7, AC110, AC500, AC520
#ALE-ROLE PK
ROLE		Alpha 12The code that identifies a role that a resource has in relation to activities.AC03.7, AC110, AC500, AC520
#ALE-PERCENT
PERCENT		Signed 7.3The amount of credit responsibility this employee has for the grant/project. This is used for role records.AC03.7, AC110, AC520
#ALE-CONFLICT-FLAG
CONFLICT_FLAG		Alpha 1Conflict of interest flag. This is used for role records.
  • N No
  • Y Yes
AC03.7, AC110, AC520
#ALE-CMT-EFFORT-PCT
CMT_EFFORT_PCT		Signed 13.6The percentage of employee time committed to the grant or project for the duration of the activity.—

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ALESET1
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. RESOURCE-TYPE
  4. COMPANY
  5. RESOURCE-CODE
  6. ROLE
PrimaryAC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC120, AC300 +3 more
ALESET2
  1. ROLE
  2. RESOURCE-TYPE
  3. COMPANY
  4. RESOURCE-CODE
  5. ACTIVITY-GRP
  6. ACTIVITY
AC03.8, AC500
ALESET3
  1. ROLE
  2. ACTIVITY
  3. ACTIVITY-GRP
  4. RESOURCE-TYPE
  5. COMPANY
  6. RESOURCE-CODE
AC01.1, AC03.7, AC105, AC112, AC113, AC120, AC121, AC123 +22 more (list truncated in source)
ALESET4
  1. ACTIVITY
  2. ACTIVITY-GRP
  3. ROLE
  4. RESOURCE-TYPE
  5. COMPANY
  6. RESOURCE-CODE
AC10.1, AC110, AC203

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACTGRPACACTIVITYACASSIGNACROLEACRESHISTACASNROLE

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequired
ALE-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYNot Required
ALE-ACTIVITY→ACV-ACTIVITY
AcassignACASSIGNRequired
ALE-ACTIVITY-GRP→AAN-ACTIVITY-GRP
ALE-ACTIVITY→AAN-ACTIVITY
ALE-COMPANY→AAN-COMPANY
ALE-RESOURCE-TYPE→AAN-RESOURCE-TYPE
ALE-RESOURCE-CODE→AAN-RESOURCE-CODE
AcroleACROLERequired
ALE-ROLE→ACH-ROLE

One to many (1) — child tables

RelationTableRulesConditionField map
AcreshistACRESHIST
ALE-ACTIVITY-GRP→RSH-ACTIVITY-GRP
ALE-ACTIVITY→RSH-ACTIVITY
ALE-RESOURCE-TYPE→RSH-RESOURCE-TYPE
—→RSH-RESOURCE-CODE
—→RSH-COMPANY
—→RSH-ROLE
—→RSH-FIELD-ID
—→RSH-SEQ-NUMBER

Programs

Updated by (134)

Referenced by (7)