1. Tables and Views for Financials
  2. FV_TR_FUND_ATTRIBUTES_

FV_TR_FUND_ATTRIBUTES_

This table contains funds associated to a treasury symbol along with fund attributes.

Details

  • Schema: FUSION

  • Object owner: FV

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

FV_TR_FUND_ATTRIBUTES_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, FUND_VALUE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
FUND_VALUE_ID NUMBER 18 Yes Unique identifier for a fund code value.
FUND_STRUCTURE_INSTANCE_ID NUMBER 18 Natural account segment instance assigned to Fund attribute.
FUND_CODE VARCHAR2 25 An agency-defined shorthand code used to identify an individual appropriation, receipt, or other fund account or an agency subdivision of a Treasury Account Symbol.
TREASURY_ACCOUNT_SYMBOL_ID NUMBER 18 Unique identifier for Treasury Account Symbol. Active
LEDGER_ID NUMBER 18 Unique identifier for the ledger. Active
APPORTIONMENT_CATEGORY_CODE VARCHAR2 30 Identifies Office of Management and Budget apportionments by quarters (Category A) or by other specified time periods, programs, activities, projects, objects, or combinations of these (Category B), or are not subject to apportionment (Category E).
DIRECT_OR_REIMBURSABLE_CODE VARCHAR2 30 Identifies whether amounts for goods, services, and joint project support are financed by offsetting collections.
BUDGET_BEA_CATEGORY_CODE VARCHAR2 30 Identifies whether the Budget Enforcement Act category for budget is mandatory or discretionary for budgets.
OUTLAYS_BEA_CATEGORY_CODE VARCHAR2 30 Identifies whether the Budget Enforcement Act category is mandatory or discretionary for outlays.
BORROWING_SOURCE_CODE VARCHAR2 30 Identifies whether borrowing took place from the public, Treasury, or a Federal financing bank. Active
BUDGET_SUBFUNCTION_CODE VARCHAR2 30 Office of Management and Budget assigns each expenditure and offsetting receipt account a three-digit code that corresponds to the account's sub-functional classification (e.g., national defence, income security, agriculture). Annually, Office of Management and Budget consults with Congressional Budget Office and other relevant budget and appropriation committee staff members regarding functional and sub-functional classification. This process, which is required by statute, typically occurs from October through December. Active
CUSTODIAL_NON_CUSTODIAL_CODE VARCHAR2 30 Custodial amounts are reported on the Statement of Custodial Activity or on the custodial footnote. Non-custodial amounts are not reported on the Statement of Custodial Activity nor on the custodial footnote.
DEFINITE_OR_INDEFINITE_CODE VARCHAR2 30 Identifies if the Treasury Account Symbol appropriation is definite or indefinite.
REQUISITION_CLOSING_METHOD VARCHAR2 1 Identifies if commitments for a requisition should be closed in the pre-closing or the closing period.
COPY_FUND_FLAG VARCHAR2 1 Identifies if fund attributes should be copied to the next year for a fund assigned to Treasury Account Symbol which will expire in the currently fiscal year.
NEXT_YEAR_FUND_CODE VARCHAR2 25 Fund value that will be used in the next year if the Copy fund to next year is checked.
YEAR_OF_BUDGET_AUTHORITY_CODE VARCHAR2 30 Identifies whether outlays are from the new budget authority or from budget authority carried forward from the prior year.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
FUNDING_DERIVATION_TYPE_CODE VARCHAR2 30 Funding derivation type code. Value indicates whether the funding is derived from the general fund or not.
DEFAULT_PAYMENT_BETC_CODE VARCHAR2 8 Default value for the Payment Business Event Type Code.
DEFAULT_COLLECTION_BETC_CODE VARCHAR2 8 Default value for the Collection Business Event Type Code.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Audit action type. Valid values are INSERT, UPDATE, and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Bitmap of 1s and 0s to denote each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Audit impersonator account profile. All actions performed using the impersonator account are audited. Users can view audit history to retrieve the audited information that was filtered by an impersonated profile.

Indexes

Index Uniqueness Tablespace Columns Status
FV_TR_FUND_ATTRIBUTES_N1_ Non Unique Default FUND_VALUE_ID
FV_TR_FUND_ATTRIBUTES_U1_ Unique FUSION_TS_TX_DATA LAST_UPDATE_DATE, LAST_UPDATED_BY, FUND_VALUE_ID Active