FV_DATA_ACT_REPORT

Details

Schema: FUSION
Object owner: FV
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
FV_DATA_ACT_REP_SUMMARY_PK	REPORT_SUMMARY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
REPORT_SUMMARY_ID	NUMBER		18	Yes	Unique identifier of the summary record
FILE_CODE	VARCHAR2	30		Yes	File code that has been processed.
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.
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.
BALANCE_DR	NUMBER				Accumulated debit amount for the CCID and federal attribute combination.
BALANCE_CR	NUMBER				Accumulated credit amount for the CCID and federal attribute combination.
ACCOUNTED_BALANCE	NUMBER				"It holds the begin balance of the year if the period number is 0. BEGINNING Balance of the year = BALANCE_DR - BALANCE_CR It holds the ending balance of the period if the period number is not 0. ENDING Balance of the period = BEGINNING Balance of the year + PTD till the period num."
REPORT_RUN_ID	NUMBER		18	Yes	Unique identifier of the file processing attributes.
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_SUMMARY_N1	Non Unique	FUSION_TS_TX_DATA	FILE_CODE, 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, TREASURY_ACCOUNT_SYMBOL
FV_DATA_ACT_REP_SUMMARY_N2	Non Unique	FUSION_TS_TX_DATA	FILE_CODE, LEDGER_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, TREASURY_ACCOUNT_SYMBOL, USSGL_ACCOUNT
FV_DATA_ACT_REP_SUMMARY_U1	Unique	FUSION_TS_TX_DATA	REPORT_SUMMARY_ID