|
ACRESOURCE FILE
Activity Resource
This file contains resource definition information from AC03.1 (Resource). It
includes resource code, type, description, standard cost, resource class, as
well as resource names, title, telephone number, and E-mail address.
REFERENCED BY
AC145 AC17.2 AC17.6 AC18.1 AC18.5 AC210
AC217 AC218 AC240 AC295 AC41.1 AC41.4
AC42.1 AC46.1 AC50.1 AC500 AC52.1 AC54.1
AC540 AC69.2 AC92.2 AC92.4 AC92.6 ACAC.1
BR40.3 BR43.1 BR46.1 ET530 ET540 PW110
PW510
UPDATED BY
AC03.1 AC520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RSC-RESOURCE-CODE Alpha 10 AC03.1 AC520
Element: Resource Code Required key. This code identifies a
personnel or equipment resource assigned
to an activity. The resource must first
be defined in HR11 (Employee) or AC03.1
(Resource).
RSC-RESOURCE-TYPE Alpha 1 AC03.1 AC520
Element: Resource Type This is the resource type, indicating
whether the resource is equipment or a
person.
Q = Equipment
P = Person
RSC-DESCRIPTION Alpha 30 (Lower Case) AC03.1 AC217
Element: Resource DescrRequired. This is the description of AC218 AC520
the resource.
RSC-LAST-NAME Alpha 30 (Lower Case) AC03.1 AC217
Element: Last Name Required. This is the last name of the AC218 AC520
personnel resource.
RSC-FIRST-NAME Alpha 15 (Lower Case) AC03.1 AC217
Element: First Name Required. This is the first name of the AC218 AC520
personnel resource.
RSC-MIDDLE-INIT Alpha 1 AC03.1 AC520
Element: Middle InitialOptional. This is the middle initial of
the personnel resource.
RSC-TITLE Alpha 30 (Lower Case) AC03.1 AC520
Element: Title Optional. This is the title of the
personnel resource.
RSC-PHONE-COUNTRY Alpha 6 AC03.1 AC520
Element: Telephone (CouOptional. This is the prefix of the
telephone number for the resource. For
example, the country or city telephone
code.
RSC-PHONE Alpha 15 AC03.1 AC520
Element: Phone This is the telephone number.
RSC-PHONE-EXT Alpha 5 AC03.1 AC520
Element: Telephone ExteOptional. This is the telephone
extension for the resource.
RSC-E-MAIL-ADDR Alpha 60 AC03.1 AC520
Element: Email Address This is the E-mail address for the
resource.
RSC-COMPANY Numeric 4 AC03.1 AC520
Element: 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.
RSC-ACCT-UNIT Alpha 15 AC03.1 AC520
Element: Acct Unit 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.
RSC-ACCOUNT Numeric 6 AC03.1 AC520
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
RSC-SUB-ACCT Numeric 4 AC03.1 AC520
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
RSC-ROLE Alpha 12 AC03.1
Element: Role The code that identifies a role that a
resource has in relation to activities.
ACRESOURCE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RSCSET1 RESOURCE-CODE AC03.1 AC03.2
RESOURCE-TYPE AC03.6 AC03.7
AC145 AC17.2
AC17.6 AC18.1
AC18.5 AC210
AC217 AC218
AC240 AC295
AC41.1 AC41.4
AC42.1 AC46.1
AC50.1 AC500
AC52.1 AC520
AC54.1 AC540
AC69.2 AC92.2
AC92.4 AC92.6
ACAC.1 BR40.3
...
RSCSET2 LAST-NAME KeyChange AC03.1
FIRST-NAME
MIDDLE-INIT
RESOURCE-CODE
RESOURCE-TYPE
ACRESOURCE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acassign ACASSIGN
Zeroes -> AAN-COMPANY
RSC-RESOURCE-CODE -> AAN-RESOURCE-CODE
RSC-RESOURCE-TYPE -> AAN-RESOURCE-TYPE
AAN-ACTIVITY-GRP
AAN-ACTIVITY
Acresrtx ACRESRTX
RSC-RESOURCE-TYPE -> RRX-RESOURCE-TYPE
RSC-RESOURCE-CODE -> RRX-RESOURCE-CODE
RRX-COMPANY
RRX-EFFECTIVE-DATE
|