Setting Up DATA Act Reports

Installation Options - Federal Processing Options Page

INSTALLATION_FD

Enable federal award data for procurement and financial assistance fields and to define these fields to generate DATA Act File C.

DATA Act Definition Page

FOMB_ATTR_XREF

Map an attribute from file C to a PeopleSoft ChartField for those attributes defined as ChartFields.

Federal Program Activity Mapping Page

FOMB_PRJACT_MAP

Map a Federal Program Activity Code to a PeopleSoft ChartField value or range of values for one or multiple ChartFields.

DATA Act Trees Page

FOMB_PRJTREES

Specify translation and derivation trees for Federal Object Class and USSGL accounts.

DATA Act Balance Fields Page

DATA_ACT_BALANCE

Determine the General Ledger accounts that comprise the calculations for selected balance fields in Files A, B, and C.

DATA Act Balance Fields Sequencing Page

DATA_ACT_BAL_SEQ

Define the order in which balance fields should be sequenced.

Run DATA Act Interface Page

FOMB_RUNCNTL

Run processes that extract data to the staging tables and create the output bulk file for DATA Act files A & B.

Run Data Act File C Page

DATA_C_RUNCNTL

Run processes that extract data to the staging tables and create the output bulk file for DATA Act File C.

Description

Displays a description of the Data Element or attribute.

Field Name

Select the ChartField with which the attribute is associated.

ChartField Attribute

Select the attribute associated with the ChartField that contains values required for reporting to Treasury.

Effective Dates

Select a date from which the mapping is effective.

Status

Indicates whether the effective-dated row is Active or Inactive.

Priority

Enter the priority order in which Federal Program should be assigned in the event that there are ChartField values in the Values by ChartFields section that overlap across one or more Programs. This priority is applied across all Federal Program Codes under the same Business Unit.

Description

Enter a description of the Federal Program Activity.

Program Activity Reporting key

Enter the 15-character Program Activity Reporting Key (FED_PARK). This value is pulled into the Data Act Files B and C reporting, outbound file reporting, and summarization.

This field is optional and is not edited by the system.

Field Name

Select ChartField combinations to use in mapping Federal Programs. The ChartFields that appear in this link are dependent on ChartField configuration.

For more information, see Using Standard ChartField Configuration.

Range From and Range To

Enter a From and to value for the selected ChartField.

Tree Group

Enter an identifier for the tree group. This identifier is used on the DATA Act File C Interface Run Control page.

Account Rollup Tree and Account Tree Level

Select the tree created for account rollup. The account rollup tree is used to translate General Ledger accounts to the six-digit USSGL account values required by the U.S. Treasury, and to denote which USSGL accounts are required for reporting.

Select the Account Rollup tree level to be used for reporting.

Object Class ChartField, Object Class Tree, and Level

Select the ChartField that is used to derive Federal Object Class.

Select the tree created for Object Class. The Object Class tree is used to derive the Federal Object Class from the ChartField value in the ledger as well as to specify which Object Classes should be included in the report.

Select the Object Class tree level to be used for reporting.

Disaster Emergency Fund Code ChartField, Disaster Emergency Fund Code Tree, and Level

Select the ChartField that is used to derive the Disaster Emergency Fund Code.

Select the tree for the Disaster Emergency Fund Code (DEFC). The tree is used to derive the DEFC from the ChartField value and to specify what to include in reports.

Select the Disaster Emergency Fund Code tree level to use for reporting.

Balance Field Name

Enter the balance field name for which accounts and account actions are to be defined. These fields are used when reporting to the U.S. Treasury and the values much match the Treasury’s pre-defined values.

File Type

Select from these values:

• File A

• File B

• File B and C

• File C

Begin/End

Select and option to indicate whether the reporting period beginning or ending balance is reportable in the file. Options are:

• Begin: reporting beginning balance.

• End: reporting ending balance.

Account

Select the Account ChartField value that applies to the calculation for the selected balance field.

Account Action

Select an option to indicate whether the amount should be added or subtracted from the balance total. Options are:

• Add

• Deduct

Sequence Number

Enter a sequence number (1-999) for determining the order in the file.

Balance Field Name

Select the balance field name for each sequence. Only balance fields that have been created for the selected file type using the DATA Act Balance Fields Page are available for selection.

Business Unit

Select the business unit for which you want to run the DATA Act File C interface.

Report ID

Select a free-form Report ID to identify the dataset for the program run.

Tree Group

Select the Tree Group for attributes and tree derivation.

Fiscal Year

Enter the fiscal year for which to select data.

From Period

Enter the accounting period from which to select data for the detail data reporting. Summary reporting always uses a From Period of 1 for cumulative reporting.

To Period

Enter the accounting period from which to select data in the fiscal year entered.

Report Type

Select one of these options:

• Detail and Summary: select to create File C with detailed transactions and summary balances.

• Detail: select to create File C with detailed transactions.

File Name

Enter the name for the bulk file. You must use a .csv file extension. Do not enter a path.

Accounting Period

Select adjustment accounting period(s) to be included as part of the ending balance.

TAS

Select one or more TAS that are associated with the funds being reported. This is a required field.