1. Tables and Views for Financials
  2. FV_DATA_ACT_REP_TRX_ACTIVITY

FV_DATA_ACT_REP_TRX_ACTIVITY

This table stores information about the transaction details from gl_je_headers and gl_je_lines for the ussgl accounts defined to calculate DATA Act balances.

Details

  • Schema: FUSION

  • Object owner: FV

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FV_DATA_ACT_REP_TRX_ACTY_PK

REPORT_TRX_ID

Columns

Name Datatype Length Precision Not-null Comments
REPORT_TRX_ID NUMBER 18 Yes Unique identifier of the gl transactions that are used for the file generation.
LEDGER_ID NUMBER 18 Yes Unique identifier of the ledger.
CODE_COMBINATION_ID NUMBER 18 Yes Key flexfield combination defining column
PERIOD_NUM NUMBER 18 Yes Accounting period number code of Oracle Fusion General Ledger balance.
PERIOD_YEAR NUMBER 18 Yes Accounting period year code of Oracle Fusion General Ledger balance.
PROGRAM_ACTIVITY_CODE VARCHAR2 30 The program activity code for the agency defined in federal attribute supplemental rules.
BUDGET_OBJECT_CLASS VARCHAR2 30 The budget object class code defined in federal attribute supplemental rules.
DIRECT_OR_REIMBURSABLE_CODE VARCHAR2 30 The direct or reimbursable code defined in federal fund attributes. It is based on the ORA_FV_DIRECT_OR_REIMBURSEABLE lookup. Valid values are D and R.
DISASTER_EMERGENCY_FUND_CODE VARCHAR2 30 The disaster emergency fund code defined in federal attribute supplemental rules.
PIID_NUMBER VARCHAR2 150 The procurement instrument identifier derived from the purchase order.
PARENT_AWARD_NUMBER VARCHAR2 150 The parent award number derived from the purchase order.
FAIN_NUMBER VARCHAR2 150 The federal award identification number derived from the purchase order.
URI VARCHAR2 150 The uniform resource identifier derived from the purchase order.
JE_HEADER_ID NUMBER 18 Yes Journal entry header identifier.
JE_LINE_NUM NUMBER 18 Yes Line on the supplier's response.
REPORT_RUN_ID NUMBER 18 Yes Unique identifier of the file processing attributes.
TREASURY_ACCOUNT_SYMBOL VARCHAR2 35 Yes 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_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.
USSGL_ACCOUNT VARCHAR2 6 Yes A six-digit number used to identify a specific U.S. Standard General Ledger account. The U.S. Standard General Ledger account must be in the U.S. Standard General Ledger chart of accounts.
POSTED_DATE DATE Yes Date on which journal batch was posted.
JE_SOURCE VARCHAR2 25 Yes Journal source. Foreign key to GL_JE_SOURCES_B.
JE_CATEGORY VARCHAR2 25 Yes Journal category. Foreign key to GL_JE_CATEGORIES_B.
PERIOD_NAME VARCHAR2 15 Yes Accounting period. Foreign key to GL_PERIODS.
ACCOUNTED_DR NUMBER Journal entry line debit amount in base currency.
ACCOUNTED_CR NUMBER Journal entry line credit amount in base currency.
ORIGINAL_ACCOUNTED_DR NUMBER Original debit amount in base currency for the journal entry line.
ORIGINAL_ACCOUNTED_CR NUMBER Original credit amount in base currency for the journal entry line.
JE_BATCH_ID NUMBER 18 Yes Journal entry batch defining column.
PROCESS_FILE_CODE VARCHAR2 10 Identifies the DATA Act files that are processed for the journal line, for example, file B, file C, or both file B and file C.
INCLUDE_BAL_CALC_FILE_CODE VARCHAR2 10 Identifies whether the journal line is included in the DATA Act balance calculations for file B, file C, or both file B and file C.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Indexes

Index Uniqueness Tablespace Columns
FV_DATA_ACT_REP_TRX_ACTY_N1 Non Unique FUSION_TS_TX_DATA LEDGER_ID, CODE_COMBINATION_ID, PERIOD_NUM, PERIOD_YEAR, PROGRAM_ACTIVITY_CODE, BUDGET_OBJECT_CLASS, DIRECT_OR_REIMBURSABLE_CODE, DISASTER_EMERGENCY_FUND_CODE, PIID_NUMBER, PARENT_AWARD_NUMBER, FAIN_NUMBER, URI, JE_HEADER_ID, JE_LINE_NUM
FV_DATA_ACT_REP_TRX_ACTY_U1 Unique FUSION_TS_TX_DATA REPORT_TRX_ID