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

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 Yes Identifies the type of agency as either internal or trading partner. Active
AGENCY_IDENTIFIER VARCHAR2 3 Yes The Treasury Account Symbol component that identifies the agency that is responsible for the budget account. Active
MAIN_ACCOUNT_CODE VARCHAR2 4 Yes The Treasury Account Symbol component that represents the type and purpose of the fund. Active
FED_ACCOUNT_SYMBOL_TITLE VARCHAR2 240 Yes 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 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
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Indexes

Index Uniqueness Tablespace Columns Status
FV_TR_FED_ACCT_SYMBOLS_U1 Unique FUSION_TS_TX_IDX FED_ACCOUNT_SYMBOL_ID, ORA_SEED_SET1 Active
FV_TR_FED_ACCT_SYMBOLS_U11 Unique FUSION_TS_TX_IDX FED_ACCOUNT_SYMBOL_ID, ORA_SEED_SET2
FV_TR_FED_ACCT_SYMBOLS_U2 Unique FUSION_TS_TX_IDX AGENCY_IDENTIFIER, MAIN_ACCOUNT_CODE, ORA_SEED_SET1 Active
FV_TR_FED_ACCT_SYMBOLS_U21 Unique FUSION_TS_TX_IDX AGENCY_IDENTIFIER, MAIN_ACCOUNT_CODE, ORA_SEED_SET2