How GTAS Attributes Are Derived

This topic describes how the GTAS attributes are derived for USSGL accounts when you run the GTAS accumulation process.

When you run the GTAS accumulation process, the attributes are derived for USSGL accounts using the following logic:

1. The process selects journal lines that match the selection criteria as described in the preceding topic, GTAS Accumulation Data Selection Criteria, and the parameters selected when running the GTAS accumulation process.

2. The attributes and the attribute values for each journal line are derived.

   The process identifies the required attributes for each USSGL account from the USSGL account attributes table. The process then assigns federal attribute values using the following logic:

   1. Default value: First, the process checks for a default value in the Manage Federal Attributes setup task.
   2. Attribute assignment: Next, the process assigns attributes based on the specified category and source defined in the Manage Federal Attributes setup task.

      Here's how the values are assigned based on the category:

      • Trading Partner: The attribute values are derived as follows:
        • Trading Partner TAS defined at the distributions, line locations, or lines in the Payables or Receivables transactions.
        • Trading Partner TAS defined at the supplier site for Payables transactions, or customer account for Receivables transactions.
        • Trading Partner Agency Identifier defined at the supplier site for Payables or customer account for Receivables transactions.
        For more information, see Considerations for Deriving Attributes for Trading Partner Category.
      • Federal Attribute Supplemental Rules: Attribute values are assigned using the federal attribute supplemental rules setup.
      • Ledger: Attribute values are determined from the segment associated with the ledger in the chart of accounts.
      • Federal Account Attributes: Attribute values are derived from the attribute associated with the natural account.
      • Federal Fund Attributes: Attribute values are derived from the attribute associated with the fund.
      • Purchase Order: Attributes are defined using the global descriptive flexfield on the purchase order.
   3. Finally, the process checks for any overrides in the federal attribute supplemental rules.
   Note: Values are assigned to only those attributes that meet the following criteria:

   • The parent USSGL account for the natural account exists in the USSGL table.
   • The natural account and the USSGL account are part of the account hierarchy.
   • The attribute is GTAS-reportable.

Considerations for Deriving Attributes for Trading Partner Category

This topic describes how GTAS is reported for these attributes for the Trading Partner category: Federal or Non-Federal Code, Trading Partner Agency Identifier, and Trading Partner Main Account.

The GTAS accumulation process uses the following logic to derive the attributes for the Trading Partner category:

1. First, the process determines if a default value is configured for the attribute using the Manage Federal Attributes task in the Functional Setup Manager.
2. As described in the preceding topic, How GTAS Attributes Are Derived, the process derives the attribute value based on the category and source configured for the attribute. For example, if the attribute “Federal or Non-Federal Code” is mapped to the category “Trading Partner” and source “Federal or Non-Federal Code source,” the process derives the attribute value from the customer for Receivables and the supplier for Payables. If the attribute is “Trading Partner Agency Identifier” or “Trading Partner Main Account,” the process derives the attribute value from the transaction, or the supplier or customer.
3. Finally, the process checks for any overrides in the federal attribute supplemental rules.