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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ALESET1ACTIVITY-GRP, ACTIVITY, RESOURCE-TYPE, COMPANY, RESOURCE-CODE, ROLEPrimaryAC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC120, AC300 +3 more
ALESET2ROLE, RESOURCE-TYPE, COMPANY, RESOURCE-CODE, ACTIVITY-GRP, ACTIVITYAC03.8, AC500
ALESET3ROLE, ACTIVITY, ACTIVITY-GRP, RESOURCE-TYPE, COMPANY, RESOURCE-CODEAC01.1, AC03.7, AC105, AC112, AC113, AC120, AC121, AC123 +22 more (list truncated in source)
ALESET4ACTIVITY, ACTIVITY-GRP, ROLE, RESOURCE-TYPE, COMPANY, RESOURCE-CODEAC10.1, AC110, AC203

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequiredALE-ACTIVITY-GRP → AGP-ACTIVITY-GRP
AcactivityACACTIVITYNot RequiredALE-ACTIVITY → ACV-ACTIVITY
AcassignACASSIGNRequiredALE-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
AcroleACROLERequiredALE-ROLE → ACH-ROLE

One to many (1) — child tables

RelationTableRulesConditionField map
AcreshistACRESHISTALE-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)