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 |
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 | Yes | 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 | Yes | Unique identifier for Treasury Account Symbol. | Active | |
| LEDGER_ID | NUMBER | 18 | Yes | Unique identifier for the ledger. | Active | |
| APPORTIONMENT_CATEGORY_CODE | VARCHAR2 | 30 | Yes | 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 | Yes | Identifies whether amounts for goods, services, and joint project support are financed by offsetting collections. | ||
| BUDGET_BEA_CATEGORY_CODE | VARCHAR2 | 30 | Yes | Identifies whether the Budget Enforcement Act category for budget is mandatory or discretionary for budgets. | ||
| OUTLAYS_BEA_CATEGORY_CODE | VARCHAR2 | 30 | Yes | 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 | Yes | 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 | Yes | 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 | Yes | 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 | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | 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 | Yes | 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| FV_TR_FUND_ATTRIBUTES_N1 | Non Unique | FUSION_TS_TX_DATA | TREASURY_ACCOUNT_SYMBOL_ID | |
| FV_TR_FUND_ATTRIBUTES_U1 | Unique | FUSION_TS_TX_DATA | FUND_VALUE_ID | Active |
| FV_TR_FUND_ATTRIBUTES_U2 | Unique | FUSION_TS_TX_DATA | FUND_CODE, LEDGER_ID |