ACASSIGN

Activity Resource Assignment

This file contains resource assignment information from AC03.2 (AC Person Assignment), AC03.3 (HR Employee Assignment), AC03.4 (Vendor Assignment), AC03.5 (Asset Assignment), and AC03.6 (Equipment Assignment). It includes resource codes, their descriptions, and the assignment of resources to activities and activity groups. The resources must have been defined already in AC03.1 (Resource), HR11.1 (Employee), AM20.2 (Additions and Adjustments), or AP10.1 (Vendor).

REFERENCED BY
AC200 AC210 ACAC.1 ACSB.1 ACVW.1 AP211
GL299 MX123 MX500 SN02.1 SNAC.1


UPDATED BY
AC03.1 AC03.2 AC03.3 AC03.4 AC03.5 AC03.6
AC10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAN-ACTIVITY-GRP
Element: Activity Group
Alpha 15
Required key. This is the activity group to which the resource is assigned.
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity to which the resource is assigned.
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-RESOURCE-TYPE
Element: Resource Type
Alpha 1
Key field. This field indicates the type of resource this is. Valid values include: Q = Equipment P = Person E = Payroll Employee A = Asset V = AP/EE Vendor
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-RESOURCE-CODE
Element: Resource Code
Alpha 10
Required key. This code identifies a resource assigned to an activity. The resource must first be defined in HR11.1 (Employee), AM20.2 (Additions and Adjustments), AP10.1 (Vendor), or AC03.1 (Resource).
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-COMPANY
Element: Company
Numeric 4
Key field. Required for resource types Employee and Vendor. This is the company number for this assignment. If you leave this field blank, it defaults to the activity responsible company.
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-EMPLOYEE-ASSET
Element: Employee
Numeric 10
This field is required for Employee and Asset resource types. It allows you to establish a relationship with the Employee and Asset files for Drill Around and selects.
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-DESCRIPTION
Element: Resource Description
Alpha 30 (Lower Case)
Required. This is the description of the resource. If you leave this field blank, the description defaults from the Resource Source file.
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AAN-TO-COMPANY
Element: Company
Numeric 4
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.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-MATRIX-CAT
Element: Matrix Cat
Alpha 12
Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis.
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-MX-VALUE
Element: Mx Value
Alpha 32
The attribute value.
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-BEGIN-DATE
Element: Begin Date
Numeric 8 (yyyymmdd)
The begin date for this effort period.
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
The end date for this effort period.
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AAN-BILL-RATE
Element: Bill Rate
Signed 13.4
The billing rate that is set up for a resource for a specific activity.


ACASSIGN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AANSET1 ACTIVITY-GRP
ACTIVITY
COMPANY
RESOURCE-TYPE
RESOURCE-CODE
AC03.7 AC200
AC210 ACAC.1
ACSB.1 ACVW.1
AP211 GL299
MX123 MX500
SN02.1 SNAC.1
AANSET3 COMPANY
RESOURCE-CODE
RESOURCE-TYPE
ACTIVITY-GRP
ACTIVITY
AC03.1
AANSET5 ACTIVITY
ACTIVITY-GRP
COMPANY
RESOURCE-CODE
RESOURCE-TYPE
AC10.1
AANSET7 RESOURCE-TYPE
ACTIVITY-GRP
ACTIVITY
COMPANY
RESOURCE-CODE
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6
AANSET8 COMPANY
EMPLOYEE-ASSET
ACTIVITY-GRP
ACTIVITY
RESOURCE-TYPE
RESOURCE-CODE
KeyChange, Subset
WhereRESOURCE-TYPE ="E"


ACASSIGN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Not Required
AAN-ACTIVITY-GRP->AGP-ACTIVITY-GRP (AGPSET1)
Acactivity ACACTIVITY Not Required
AAN-ACTIVITY->ACV-ACTIVITY
Acresource ACRESOURCE Not Required
Valid When AAN-RESOURCE-TYPE ="P"
OrAAN-RESOURCE-TYPE ="Q"
AAN-RESOURCE-CODE->RSC-RESOURCE-CODE
AAN-RESOURCE-TYPE->RSC-RESOURCE-TYPE
Amasset AMASSET Not Required
Valid When AAN-RESOURCE-TYPE ="A"
AAN-EMPLOYEE-ASSET->AST-ASSET
Apcompany APCOMPANY Not Required
Valid When AAN-RESOURCE-TYPE ="V"
AAN-COMPANY->CPY-COMPANY
Apvenmast APVENMAST Not Required
Valid When AAN-RESOURCE-TYPE ="V"
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
AAN-RESOURCE-CODE->VEN-VENDOR
Employee EMPLOYEE Not Required
Valid When AAN-RESOURCE-TYPE ="E"
AAN-COMPANY->EMP-COMPANY
AAN-EMPLOYEE-ASSET->EMP-EMPLOYEE


ACASSIGN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acasnrole ACASNROLE
AAN-ACTIVITY-GRP->ALE-ACTIVITY-GRP
AAN-ACTIVITY->ALE-ACTIVITY
AAN-RESOURCE-TYPE->ALE-RESOURCE-TYPE
AAN-COMPANY->ALE-COMPANY
AAN-RESOURCE-CODE->ALE-RESOURCE-CODE
  ALE-ROLE
Accommitx ACCOMMITX
AAN-COMPANY->MIX-RESOURCE-COMP
AAN-RESOURCE-TYPE->MIX-RESOURCE-TYPE
AAN-RESOURCE-CODE->MIX-RESOURCE-CODE
  MIX-SYSTEM
  MIX-TRANS-DATE
  MIX-ACTIVITY-GRP
  MIX-ACTIVITY
  MIX-ACCT-CATEGORY
  MIX-ATN-OBJ-ID
Acreshist ACRESHIST
AAN-ACTIVITY-GRP->RSH-ACTIVITY-GRP
AAN-ACTIVITY->RSH-ACTIVITY
AAN-RESOURCE-TYPE->RSH-RESOURCE-TYPE
  RSH-RESOURCE-CODE
  RSH-COMPANY
  RSH-ROLE
  RSH-FIELD-ID
  RSH-SEQ-NUMBER
Histastasgn ACRESHIST
AAN-ACTIVITY-GRP->RSH-ACTIVITY-GRP
AAN-ACTIVITY->RSH-ACTIVITY
AAN-RESOURCE-TYPE->RSH-RESOURCE-TYPE
440->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histastrole ACRESHIST
AAN-ACTIVITY-GRP->RSH-ACTIVITY-GRP
AAN-ACTIVITY->RSH-ACTIVITY
AAN-RESOURCE-TYPE->RSH-RESOURCE-TYPE
441->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histempasgn ACRESHIST
AAN-ACTIVITY-GRP->RSH-ACTIVITY-GRP
AAN-ACTIVITY->RSH-ACTIVITY
AAN-RESOURCE-TYPE->RSH-RESOURCE-TYPE
420->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histemprole ACRESHIST
AAN-ACTIVITY-GRP->RSH-ACTIVITY-GRP
AAN-ACTIVITY->RSH-ACTIVITY
AAN-RESOURCE-TYPE->RSH-RESOURCE-TYPE
421->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histeqpasgn ACRESHIST
AAN-ACTIVITY-GRP->RSH-ACTIVITY-GRP
AAN-ACTIVITY->RSH-ACTIVITY
AAN-RESOURCE-TYPE->RSH-RESOURCE-TYPE
450->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histeqprole ACRESHIST
AAN-ACTIVITY-GRP->RSH-ACTIVITY-GRP
AAN-ACTIVITY->RSH-ACTIVITY
AAN-RESOURCE-TYPE->RSH-RESOURCE-TYPE
451->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histperasgn ACRESHIST
AAN-ACTIVITY-GRP->RSH-ACTIVITY-GRP
AAN-ACTIVITY->RSH-ACTIVITY
AAN-RESOURCE-TYPE->RSH-RESOURCE-TYPE
410->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histperrole ACRESHIST
AAN-ACTIVITY-GRP->RSH-ACTIVITY-GRP
AAN-ACTIVITY->RSH-ACTIVITY
AAN-RESOURCE-TYPE->RSH-RESOURCE-TYPE
411->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histvenasgn ACRESHIST
AAN-ACTIVITY-GRP->RSH-ACTIVITY-GRP
AAN-ACTIVITY->RSH-ACTIVITY
AAN-RESOURCE-TYPE->RSH-RESOURCE-TYPE
430->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histvenrole ACRESHIST
AAN-ACTIVITY-GRP->RSH-ACTIVITY-GRP
AAN-ACTIVITY->RSH-ACTIVITY
AAN-RESOURCE-TYPE->RSH-RESOURCE-TYPE
431->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER


File created: Wed Jun 08 20:46:54 2016

Home
Contact Us



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