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
AC112 AC113 AC121 AC123 AC128 AC130
AC135 AC145 AC147 AC160 AC165 AC169
AC190 AC191 AC196 AC197 AC198 AC200
AC206 AC207 AC210 AC218 AC220 AC225
AC240 AC246 AC256 AC261 AC265 AC297
AC30.3 AC310 AC311 AC32.1 AC346 AC400
AC401 AC41.1 AC41.4 AC412 AC42.1 AC420
AC421 AC440 AC46.1 AC473 AC490 AC493
AC494 AC50.1 AC52.1 AC527 AC54.1 AC540
AC580 AC583 AC90.1 AC92.1 AC93.1 AC94.1
AC95.1 AC97.1 ACAC.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 BR40.3 BR400
BR405 BR422 BR43.1 BR430 BR450 BR46.1
BR521 BR530 BR580 BRIP.1 GL299 MX123
MX500 AC01.1 AC105 AC13.3 AC34.1 AC35.1
AC36.1 AC55.1 ACBA.1 ACDL.1 ACDM.2 ACDM.9
ACVW.1 BR13.1 BR254 SN02.1 SNAC.1 BR96.1
ACBR.1


UPDATED BY
AC03.1 AC03.2 AC03.3 AC03.4 AC03.5 AC03.6
AC10.1 AC110 AC120 AC203 AC213 AC247
AC290 AC295 AC298 AC300 AC410 AC460
AC471 AC472 AC480 AC500 AC520

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 AC110
AC120 AC500
AC520
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 AC110
AC500 AC520
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 AC110
AC500 AC520
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 AC110
AC500 AC520
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 AC110
AC500 AC520
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 AC110
AC500 AC520
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
AC110 AC500
AC520
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 AC110
AC500 AC520
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 AC110
AC500 AC520
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 AC110
AC500 AC520
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 AC110
AC500 AC520
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 AC500
AC520
AAN-MX-VALUE
Element: Mx Value
Alpha 32
The attribute value.
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC500
AC520
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 AC500
AC520
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 AC500
AC520
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
...
AC01.1 AC03.7
AC105 AC112
AC113 AC120
AC121 AC123
AC128 AC13.3
AC130 AC135
AC145 AC147
AC160 AC165
AC169 AC190
AC191 AC196
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AANSET3 COMPANY
RESOURCE-CODE
RESOURCE-TYPE
ACTIVITY-GRP
ACTIVITY
AC03.1 AC203
AC520 ACDL.1
BR96.1
AANSET5 ACTIVITY
ACTIVITY-GRP
COMPANY
RESOURCE-CODE
RESOURCE-TYPE
AC10.1 AC110
AC203
AANSET7 RESOURCE-TYPE
ACTIVITY-GRP
ACTIVITY
COMPANY
RESOURCE-CODE
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC50.1
AC500 ACBR.1
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: Thu Jun 09 11:03:52 2016

Home
Contact Us



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