FV_TR_TREAS_ACCOUNT_SYMBOLS_
This table contains Treasury Account Symbols Information.
Details
-
Schema: FUSION
-
Object owner: FV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FV_TR_TREAS_ACCT_SYMBOLS_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, TREASURY_ACCOUNT_SYMBOL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TREASURY_ACCOUNT_SYMBOL_ID | NUMBER | 18 | Yes | Unique identifier for Treasury Account Symbol. | |
| TREAS_STRUCTURE_INSTANCE_ID | NUMBER | 18 | Budget Authority segment instance assigned to Treasury Symbol year of availability. | ||
| FED_ACCOUNT_SYMBOL_ID | NUMBER | 18 | Identifier for Federal Account Symbol. | ||
| LEDGER_ID | NUMBER | 18 | Unique identifier for the ledger. | ||
| SUB_LEVEL_PREFIX_CODE | VARCHAR2 | 30 | The Treasury Account Symbol component that when populated, represents a programmatic breakdown of the account for Treasury publication purposes. | ||
| ALLOCATION_TRANSFER_AGENCY | VARCHAR2 | 3 | The Treasury Account Symbol component that identifies the agency receiving funds through an allocation transfer. | ||
| AUTHORITY_DURATION_CODE | VARCHAR2 | 30 | Indicates whether a Treasury Account Symbol is an annual year account (A), multi-year account (M) or no-year account (X). | ||
| BEG_YEAR_OF_AVAILABILITY | VARCHAR2 | 4 | The Treasury Account Symbol component that identifies the first year of availability under law that an account may incur new obligations, in annual and multiyear accounts. | ||
| END_YEAR_OF_AVAILABILITY | VARCHAR2 | 4 | The Treasury Account Symbol component that identifies the last year of availability under law that an account may incur new obligations, in annual and multiyear accounts. | ||
| AVAILABILITY_TYPE_CODE | VARCHAR2 | 30 | The Treasury Account Symbol component that identifies no-year accounts (X), clearing/suspense accounts (F), Treasury central summary general ledger accounts (A), and merged-surplus accounts (M). | ||
| SUB_ACCOUNT_CODE | VARCHAR2 | 30 | The Treasury Symbol component that Identifies an available receipt or other Treasury-defined subdivision of the main account. | ||
| TREASURY_ACCOUNT_SYMBOL | VARCHAR2 | 35 | The identification code assigned by Treasury, in collaboration with Office of Management and Budget and the owner agency, to an individual appropriation, receipt, or other fund account. | ||
| FUND_TYPE_CODE | VARCHAR2 | 30 | The code that establishes how the Treasury Account Symbol will be funded. | ||
| FINANCING_ACCOUNT_CODE | VARCHAR2 | 30 | Indicates whether the Federal Account Symbol is a direct loan financing account, a guaranteed loan financing account, or is not a financing account as defined by the Federal Credit Reform Act of 1990. | ||
| REPORTING_TYPE_CODE | VARCHAR2 | 30 | Identifies a Treasury Account Symbols as Governmentwide Treasury Account Symbol reportable, Data Act reportable, or both. | ||
| PRIOR_YEAR_ADJUSTMENT_FLAG | VARCHAR2 | 1 | Identifies if a Treasury Account Symbol is subject to prior year accounting. | ||
| START_DATE | DATE | The date when the Treasury Account Symbol is available for use. | |||
| EXPIRATION_DATE | DATE | Represents the date when a Treasury Account Symbol expires and is the last date an obligation can occur. | |||
| CANCELLATION_DATE | DATE | Represents the last date on which a fund may disbursed. For most funds, it is 5 years beyond the ending fiscal year of the period of availability unless specified otherwise in law. | |||
| END_DATE | DATE | The date when the treasury symbol is no longer available for use. | |||
| COPY_TREAS_ACC_SYMBOL_FLAG | VARCHAR2 | 1 | Identifies if a the Treasury Account Symbol which will expire in the currently fiscal year should be copied with next year's fiscal year. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| 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. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Audit action type. Valid values are INSERT, UPDATE, and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Stores a bitmap of 1s and 0s for 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 |
|---|---|---|---|
| FV_TR_TREAS_ACCT_SYMBOLS_N1_ | Non Unique | Default | TREASURY_ACCOUNT_SYMBOL_ID |
| FV_TR_TREAS_ACCT_SYMBOLS_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, TREASURY_ACCOUNT_SYMBOL_ID |