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
AC03.1 | AC03.2 | AC03.3 | AC03.4 | AC03.5 | AC03.6 |
AC110 | AC120 | AC300 | AC500 | AC520 | 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. |
|
||||||||||
AAN-ACTIVITY Element: Activity | Alpha 15 Required key. This is the activity to which the resource is assigned. |
|
||||||||||
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 |
|
||||||||||
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). |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
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. |
|
||||||||||
AAN-MX-VALUE Element: Mx Value | Alpha 32 The attribute value. |
|
||||||||||
AAN-BEGIN-DATE Element: Begin Date | Numeric 8 (yyyymmdd) The begin date for this effort period. |
|
||||||||||
AAN-END-DATE Element: End Date | Numeric 8 (yyyymmdd) The end date for this effort period. |
|
||||||||||
AAN-BILL-RATE Element: Bill Rate | Signed 13.4 The billing rate that is set up for a resource for a specific activity. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AANSET1 |
ACTIVITY-GRP ACTIVITY COMPANY RESOURCE-TYPE RESOURCE-CODE |
|
| ||||||||||||||||||||||||||||||||||||
AANSET3 |
COMPANY RESOURCE-CODE RESOURCE-TYPE ACTIVITY-GRP ACTIVITY |
|
| ||||||||||||||||||||||||||||||||||||
AANSET5 |
ACTIVITY ACTIVITY-GRP COMPANY RESOURCE-CODE RESOURCE-TYPE |
|
| ||||||||||||||||||||||||||||||||||||
AANSET7 |
RESOURCE-TYPE ACTIVITY-GRP ACTIVITY COMPANY RESOURCE-CODE |
|
| ||||||||||||||||||||||||||||||||||||
AANSET8 |
COMPANY EMPLOYEE-ASSET ACTIVITY-GRP ACTIVITY RESOURCE-TYPE RESOURCE-CODE |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acactgrp | ACACTGRP |
Not Required
| ||||||||||||||||||
Acactivity | ACACTIVITY |
Not Required
| ||||||||||||||||||
Acresource | ACRESOURCE |
Not Required
| ||||||||||||||||||
Amasset | AMASSET |
Not Required
| ||||||||||||||||||
Apcompany | APCOMPANY |
Not Required
| ||||||||||||||||||
Apvenmast | APVENMAST |
Not Required
| ||||||||||||||||||
Employee | EMPLOYEE |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acasnrole | ACASNROLE |
| |||||||||||||||||||||||||||
Accommitx | ACCOMMITX |
| |||||||||||||||||||||||||||
Acreshist | ACRESHIST |
| |||||||||||||||||||||||||||
Histastasgn | ACRESHIST |
| |||||||||||||||||||||||||||
Histastrole | ACRESHIST |
| |||||||||||||||||||||||||||
Histempasgn | ACRESHIST |
| |||||||||||||||||||||||||||
Histemprole | ACRESHIST |
| |||||||||||||||||||||||||||
Histeqpasgn | ACRESHIST |
| |||||||||||||||||||||||||||
Histeqprole | ACRESHIST |
| |||||||||||||||||||||||||||
Histperasgn | ACRESHIST |
| |||||||||||||||||||||||||||
Histperrole | ACRESHIST |
| |||||||||||||||||||||||||||
Histvenasgn | ACRESHIST |
| |||||||||||||||||||||||||||
Histvenrole | ACRESHIST |
|
All trademarks and registered trademarks are the property of their
respective owners.