ACASNROLE

The Assignment Role file will store the roles associated with a resource assignment. This file is maintained via AC03.7 (Resources).
UPDATED BY
AC03.7 AC03.2 AC03.3 AC03.4 AC03.5 AC03.6
AC03.8 AC200 AC210 ACSB.1 ACVW.1 AP211
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
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
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
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
ALE-RESOURCE-CODE
Element: Resource Code
Alpha 10
The code identifying the resource assigned to the activity or activity group.
AC03.7
ALE-ROLE
Element: Role
Alpha 12
The code that identifies a role that a resource has in relation to activities.
AC03.7
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
ALE-CONFLICT-FLAG
Element: Conflict Flag
Alpha 1
Conflict of interest flag. This is used for role records.
N = No
Y = Yes
AC03.7
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
ALESET2 ROLE
RESOURCE-TYPE
COMPANY
RESOURCE-CODE
ACTIVITY-GRP
ACTIVITY
AC03.8
ALESET3 ROLE
ACTIVITY
ACTIVITY-GRP
RESOURCE-TYPE
COMPANY
RESOURCE-CODE
AC03.7 AC200
AC210 ACSB.1
ACVW.1 AP211
GL299 MX123
MX500 SN02.1
SNAC.1
ALESET4 ACTIVITY
ACTIVITY-GRP
ROLE
RESOURCE-TYPE
COMPANY
RESOURCE-CODE
AC10.1


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: Wed Jun 08 20:46:53 2016

Home
Contact Us



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