|
|
ACPERCMPLX FILE
AC Percent Complete Detail
This file contains activity and account category percent complete information
from AC65.1 (Activity Percentage of Completion) and AC65.2 (Percent Complete
by Account Category). It includes activity, account category, amount type,
percent complete, total budget, date, cost-to-date, and
cost-to-complete.
REFERENCED BY
AC265
UPDATED BY
AC165 AC300 AC310 AC65.2 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEX-RECORD-TYPE Alpha 1 AC165 AC65.2
Element: Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
PEX-ACTIVITY Alpha 15 AC165 AC65.2
Element: Activity Required key. This is the activity for
the percent complete information.
PEX-DATE Numeric 8 (yyyymmdd) AC165 AC65.2
Element: Date Required key. This is the date as of
which the percentage complete was
calculated.
PEX-ACCT-CATEGORY Alpha 5 AC165 AC65.2
Element: Account CategoRequired key. This is the account
category for the percent complete
information.
PEX-AMOUNT-TYPE Alpha 1 AC165 AC65.2
Element: Amount Type This field indicates the type for the
budget: Amount or Units.
A = Amount
U = Unit
PEX-PERC-COMPLETE Signed 7.3 AC165 AC65.2
Element: Percent CompleThis is the percentage complete for the
account category.
PEX-TOTAL-BUDGET Signed 15.2 AC165 AC65.2
Element: Total Budget This is the total budget for the
account category.
PEX-COST-TO-DATE Signed 15.2 AC165 AC65.2
Element: Cost-to-Date This is the cost-to-date amount for the
account category.
PEX-COST-TO-CMPLT Signed 15.2 AC165 AC65.2
Element: Cost-to-CompleThis is the cost to complete, or the
amount remaining to be expended, for the
account category.
PEX-BUDGET-TYPE Alpha 1 AC165 AC65.2
Element: Budget Type This field indicates the budget type:
Amount or Units.
ACPERCMPLX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEXSET1 RECORD-TYPE AC10.1 AC165
ACTIVITY AC265 AC300
BUDGET-TYPE AC310 AC65.2
DATE*
ACCT-CATEGORY
PEXSET2 ACTIVITY KeyChange AC310
RECORD-TYPE
BUDGET-TYPE
ACCT-CATEGORY
DATE*
ACPERCMPLX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
PEX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Required
PEX-ACTIVITY -> ACV-ACTIVITY
|
