Lawson Insight Technical Documentation |
|
ACASNROLE
ACASNROLE FILE
The Assignment Role file will store the roles associated with a resource
assignment. This file is maintained via AC03.7 (Resources).
REFERENCED BY
ACBR.1 ACDL.1 AC01.1 AC105 AC112 AC113
AC121 AC123 AC128 AC13.3 AC130 AC135
AC14.3 AC145 AC160 AC165 AC169 AC190
AC191 AC197 AC198 AC200 AC203 AC206
AC207 AC210 AC213 AC218 AC220 AC225
AC240 AC246 AC261 AC265 AC290 AC295
AC298 AC30.3 AC32.1 AC34.1 AC346 AC35.1
AC36.1 AC400 AC401 AC410 AC412 AC420
AC421 AC440 AC460 AC471 AC472 AC473
AC480 AC490 AC493 AC494 AC50.1 AC52.1
AC527 AC55.1 AC580 AC583 AC90.1 AC92.1
AC93.1 AC94.1 AC95.1 ACBA.1 ACDM.2 ACDM.9
ACSB.1 ACVW.1 SE90.1 AP211 AR21.2 AR237
AR239 AR250 AR257 AR27.2 AR29.1 AR296
AR30.5 AR32.1 AR33.2 AR38.5 AR39.3 AR39.4
AR42.1 AR42.2 AR42.7 AR43.1 AR502 AR503
AR55.1 AR560 AR575 AR800 AR91.1 ARLL.1
BR10.4 BR120 BR121 BR13.1 BR130 BR131
BR140 BR142 BR145 BR151 BR152 BR153
BR154 BR155 BR156 BR157 BR165 BR19.2
BR190 BR20.9 BR200 BR202 BR204 BR205
BR210 BR212 BR215 BR220 BR245 BR251
BR252 BR253 BR254 BR265 BR300 BR400
BR405 BR422 BR430 BR450 BR521 BR530
BR580 BRIP.1 MX123 MX500 SN02.1 SNAC.1
UPDATED BY
AC03.7 AC110 AC120 AC300 AC310 AC500
AC520 PW110 PW510 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ALE-ACTIVITY-GRP Alpha 15 AC03.7 AC110
Element: Activity Grp The activity group to which the AC120 AC500
resource is assigned. AC520 PW110
PW510
ALE-ACTIVITY Alpha 15 AC03.7 AC110
Element: Activity The activity to which the resource is AC500 AC520
assigned. This field is blank when PW110 PW510
resources are assigned to the activity
group.
ALE-COMPANY Numeric 4 AC03.7 AC110
Element: Company Resource Company. Identifies the AP AC500 AC520
company if the resource type = V. PW110 PW510
Identifies the HR company if the
resource type = E. It is blank for type
A, P or Q resources.
ALE-RESOURCE-TYPE Alpha 1 AC03.7 AC110
Element: Resource Type The type of resource. Valid values AC500 AC520
include: PW110 PW510
P - AC Person
Q - Equipment
E - Employee
V - Vendor
A - Asset
ALE-RESOURCE-CODE Alpha 10 AC03.7 AC110
Element: Resource Code The code identifying the resource AC500 AC520
assigned to the activity or activity PW110 PW510
group.
ALE-ROLE Alpha 12 AC03.7 AC110
Element: Role The code that identifies a role that a AC500 AC520
resource has in relation to activities. PW110 PW510
ALE-PERCENT Signed 7.3 AC03.7 AC110
Element: Percent The amount of credit responsibility AC520
this employee has for the grant/project.
This is used for role records.
ALE-CONFLICT-FLAG Alpha 1 AC03.7 AC110
Element: Conflict Flag Conflict of interest flag. This is used AC520
for role records.
N = No
Y = Yes
ALE-CMT-EFFORT-PCT Signed 13.6
Element: Effort Pct The percentage of employee time
committed to the grant or project for
the duration of the activity.
ACASNROLE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ALESET1 ACTIVITY-GRP AC03.2 AC03.3
ACTIVITY AC03.4 AC03.5
RESOURCE-TYPE AC03.6 AC03.7
COMPANY AC120 AC300
RESOURCE-CODE AC310 AC520
ROLE ACBR.1 ACDL.1
ALESET2 ROLE AC03.8 AC500
RESOURCE-TYPE PW110 PW510
COMPANY
RESOURCE-CODE
ACTIVITY-GRP
ACTIVITY
ALESET3 ROLE AC01.1 AC03.7
ACTIVITY AC105 AC112
ACTIVITY-GRP AC113 AC120
RESOURCE-TYPE AC121 AC123
COMPANY AC128 AC13.3
RESOURCE-CODE AC130 AC135
AC14.3 AC145
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
...
ALESET4 ACTIVITY AC10.1 AC110
ACTIVITY-GRP AC203
ROLE
RESOURCE-TYPE
COMPANY
RESOURCE-CODE
ACASNROLE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Required
ALE-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Not Required
ALE-ACTIVITY -> ACV-ACTIVITY
Acassign ACASSIGN Required
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
Acrole ACROLE Required
ALE-ROLE -> ACH-ROLE
ACASNROLE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acreshist ACRESHIST
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
|