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
AC01.1 AC105 AC112 AC113 AC121 AC123
AC13.3 AC130 AC135 AC14.3 AC145 AC160
AC165 AC190 AC191 AC197 AC198 AC200
AC203 AC206 AC207 AC210 AC213 AC218
AC220 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 AC55.1
AC580 AC583 AC90.1 AC92.1 AC93.1 AC94.1
AC95.1 ACBA.1 ACBR.1 ACDL.1 ACDM.2 ACVW.1
SE90.1 AP211 AR250 AR30.5 AR33.2 BR120
BR121 BR130 BR131 BR140 BR142 BR145
BR165 BR19.2 BR190 BR20.9 BR200 BR202
BR204 BR205 BR210 BR212 BR215 BR220
BR245 BR265 BR300 BR400 BR405 BR430
BR450 BR521 BR530 BR580 BRCC.1 MX123
MX500 AC50.1 AC52.1 ACSB.1 BR10.4 BR13.1
BRIP.1
UPDATED BY
AC03.7 AC110 AC120 AC300 AC310 AC500
AC520 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ALE-ACTIVITY-GRP Alpha 15 AC03.7 AC110
Element: Activity GroupThe activity group to which the resource AC120 AC500
is assgned. AC520
ALE-ACTIVITY Alpha 15 AC03.7 AC110
Element: Activity The activity to which the resource is AC500 AC520
assigned. This field is blank when
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.
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:
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
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.
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
ACASNROLE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ALESET1 ACTIVITY-GRP AC01.1 AC03.2
ACTIVITY AC03.3 AC03.4
RESOURCE-TYPE AC03.5 AC03.6
COMPANY AC03.7 AC105
RESOURCE-CODE AC112 AC113
ROLE AC120 AC121
AC123 AC13.3
AC130 AC135
AC14.3 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
...
ALESET2 ROLE AC03.8 AC500
RESOURCE-TYPE
COMPANY
RESOURCE-CODE
ACTIVITY-GRP
ACTIVITY
ALESET3 ROLE AC01.1 AC03.7
ACTIVITY AC105 AC112
ACTIVITY-GRP AC113 AC120
RESOURCE-TYPE AC121 AC123
COMPANY AC13.3 AC130
RESOURCE-CODE AC135 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC240 AC246
AC261 AC265
...
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
|