1. Tables and Views for Financials
  2. FV_TR_FED_ACCOUNT_SYMBOLS_

FV_TR_FED_ACCOUNT_SYMBOLS_

This table contains Federal U.S. Standard General Ledger Account Information.

Details

  • Schema: FUSION

  • Object owner: FV

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

FV_TR_FED_ACCOUNT_SYMBOLS_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, FED_ACCOUNT_SYMBOL_ID

Columns

Name Datatype Length Precision Not-null Comments Status
FED_ACCOUNT_SYMBOL_ID NUMBER 18 Yes Identifier for Federal Account Symbol. Active
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
AGENCY_TYPE_CODE VARCHAR2 30 Identifies the type of agency as either internal or trading partner. Active
AGENCY_IDENTIFIER VARCHAR2 3 The Treasury Account Symbol component that identifies the agency that is responsible for the budget account. Active
MAIN_ACCOUNT_CODE VARCHAR2 4 The Treasury Account Symbol component that represents the type and purpose of the fund. Active
FED_ACCOUNT_SYMBOL_TITLE VARCHAR2 240 The title of the Federal Account Symbol assigned by Treasury. Federal Account Symbols constitute the "basic" elements of the Treasury Account Symbol . For example, appropriation and fund accounts are listed with an agency identifier and main account code; no-year accounts include the "X." Receipt accounts are listed with the main account and sub-account code. Active
NON_FED_EXCEPTION_FLAG VARCHAR2 1 Identifies if a Federal Account Symbol is exempt from requiring non Federal trading partners to make advances for reimbursable work. Active
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. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
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
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_FED_ACCOUNT_SYMBOLS_N1_ Non Unique Default FED_ACCOUNT_SYMBOL_ID
FV_TR_FED_ACCOUNT_SYMBOLS_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, FED_ACCOUNT_SYMBOL_ID