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 AC50.1 AC52.1 ACSB.1 BR10.4 BR13.1
BRIP.1


UPDATED BY
AC03.7 AC110 AC120 AC300 AC500 AC520
ACDL.1 AC01.1 AC105 AC112 AC113 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 AC220
AC225 AC240 AC246 AC247 AC256 AC261
AC265 AC290 AC295 AC297 AC298 AC30.3
AC310 AC311 AC32.1 AC34.1 AC346 AC35.1
AC36.1 AC400 AC401 AC410 AC412 AC420
AC421 AC440 AC460 AC471 AC472 AC473
AC480 AC490 AC493 AC494 AC527 AC55.1
AC580 AC583 AC90.1 AC92.1 AC93.1 AC94.1
AC95.1 AC97.1 ACBA.1 ACDM.2 ACDM.9 ACVW.1
SE90.1 AP211 ARLL.1 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 BR254 BR265 BR300
BR400 BR405 BR422 BR430 BR450 BR521
BR530 BR580 GL299 MX123 MX500 SN02.1
SNAC.1 AC10.1

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.
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 02:02:47 2016

Home
Contact Us



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