ACASNROLE

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 AC13.3 AC14.3
AC34.1 AC35.1 AC36.1 AC55.1 ACBA.1 ACDM.2
ACDM.9 ACVW.1 BR13.1 BR254 SN02.1 SNAC.1


UPDATED BY
AC03.2 AC03.3 AC03.4 AC03.5 AC03.6 AC03.7
AC03.8 AC10.1 AC110 AC112 AC113 AC120
AC121 AC123 AC128 AC130 AC135 AC145
AC147 AC160 AC165 AC169 AC190 AC191
AC196 AC197 AC198 AC200 AC203 AC206
AC207 AC210 AC213 AC218 AC220 AC225
AC240 AC246 AC247 AC256 AC261 AC265
AC290 AC295 AC297 AC298 AC30.3 AC300
AC310 AC311 AC32.1 AC346 AC400 AC401
AC410 AC412 AC420 AC421 AC440 AC460
AC471 AC472 AC473 AC480 AC490 AC493
AC494 AC50.1 AC500 AC52.1 AC520 AC527
AC580 AC583 AC90.1 AC92.1 AC93.1 AC94.1
AC95.1 AC97.1 ACSB.1 SE90.1 AP211 ARLL.1
BR10.4 BR120 BR121 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 BR265 BR300 BR400 BR405 BR422
BR430 BR450 BR521 BR530 BR580 BRIP.1
GL299 MX123 MX500

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ALE-ACTIVITY-GRP
Element: Activity Grp		Alpha 15
The activity group to which the resource is assigned.
AC03.7 AC110
AC120 AC500
AC520
ALE-ACTIVITY
Element: Activity		Alpha 15
The 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
Element: Company		Numeric 4
Resource 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
Element: Resource Type		Alpha 1
The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor A - Asset
AC03.7 AC110
AC500 AC520
ALE-RESOURCE-CODE
Element: Resource Code		Alpha 10
The code identifying the resource assigned to the activity or activity group.
AC03.7 AC110
AC500 AC520
ALE-ROLE
Element: Role		Alpha 12
The code that identifies a role that a resource has in relation to activities.
AC03.7 AC110
AC500 AC520
ALE-PERCENT
Element: Percent		Signed 7.3
The amount of credit responsibility this employee has for the grant/project. This is used for role records.
AC03.7 AC110
AC520
ALE-CONFLICT-FLAG
Element: Conflict Flag		Alpha 1
Conflict of interest flag. This is used for role records.
N = No
Y = Yes
AC03.7 AC110
AC520
ALE-CMT-EFFORT-PCT
Element: Effort Pct		Signed 13.6
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
ACTIVITY
RESOURCE-TYPE
COMPANY
RESOURCE-CODE
ROLE
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC03.7
AC120 AC300
AC520 ACBR.1
ACDL.1
ALESET2 ROLE
RESOURCE-TYPE
COMPANY
RESOURCE-CODE
ACTIVITY-GRP
ACTIVITY
AC03.8 AC500
ALESET3 ROLE
ACTIVITY
ACTIVITY-GRP
RESOURCE-TYPE
COMPANY
RESOURCE-CODE
...
AC01.1 AC03.7
AC105 AC112
AC113 AC120
AC121 AC123
AC128 AC13.3
AC130 AC135
AC14.3 AC145
AC147 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
ALESET4 ACTIVITY
ACTIVITY-GRP
ROLE
RESOURCE-TYPE
COMPANY
RESOURCE-CODE
AC10.1 AC110
AC203


ACASNROLE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Thu Jun 09 11:03:51 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.