FV_REPORTING_TRX_ACTIVITY
This table stores federal activity and attribute details.
Details
-
Schema: FUSION
-
Object owner: FV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FV_REPORTING_TRX_ACTIVITY_PK |
TRANSACTION_ACTIVITY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ACTIVITY_ID | NUMBER | 18 | Yes | Unique identifier for the transaction activity. | |
| LEDGER_ID | NUMBER | 18 | Yes | Unique identifier of the ledger. | |
| FISCAL_YEAR | VARCHAR2 | 30 | The fiscal year of a period for Budgetary Control Only Calendars. Free text field. Not validated. | ||
| PERIOD_YEAR | NUMBER | 18 | Denotes the accounting calendar year represented by a numerical value, such as 2009. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Indicates the accounting period for the calendar year. | ||
| PERIOD_NUM | NUMBER | 18 | Unique period number within the accounting calendar year. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Key flexfield combination defining column. | ||
| JE_HEADER_ID | NUMBER | 18 | Unique identifier for the journal entry header. | ||
| JE_LINE_NUM | NUMBER | 18 | Line number of the journal entry. | ||
| JE_SOURCE | VARCHAR2 | 25 | Indicates the journal entry source. | ||
| JE_CATEGORY | VARCHAR2 | 25 | Indicates the journal category. | ||
| JE_BATCH_ID | NUMBER | 18 | Unique identifier of the journal entry batch. | ||
| EVENT_ID | NUMBER | 18 | Identifier of the categorization of accounting events that is unique within an application and event class. | ||
| GL_DATE | DATE | Date on journal entry was created. | |||
| POSTED_DATE | DATE | Date journal entry header was posted. | |||
| TRANSACTION_NUMBER | VARCHAR2 | 240 | Identifier of a business relationship involving one or more parties and products, such as a change in the ownership, location or status of a product. | ||
| 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_CODE | VARCHAR2 | 25 | 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 | 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 account. | ||
| NATURAL_ACCOUNT | VARCHAR2 | 25 | The natural account segment value. | ||
| TRADING_PARTNER_ID | NUMBER | 18 | Unique identifier of the Supplier or Customer. | ||
| PARTY_USAGE_CODE | VARCHAR2 | 30 | Unique code for the party usage. A value of S indicates supplier and C indicates customer. | ||
| AGENCY_IDENTIFIER | VARCHAR2 | 3 | The Treasury Account Symbol component associated with the trading partner which identifies the agency that is responsible for the budget account. | ||
| MAIN_ACCOUNT_CODE | VARCHAR2 | 4 | The Treasury Account Symbol component associated with the trading partner which represents the type and purpose of the fund. | ||
| BALANCE_TYPE_CODE | VARCHAR2 | 30 | The code for the GTAS balance type that indicates the type of balance, for example, beginning, ending, and so on. It is based on the ORA_FV_GTAS_BALANCE_TYPE lookup. | ||
| FEDERAL_OR_NONFEDERAL_CODE | VARCHAR2 | 30 | Identifies the federal or non-federal codes associated with the account. It is based on the ORA_FV_FED_OR_NONFED_CODE lookup. | ||
| EXCHANGE_OR_NONEXCHANGE_CODE | VARCHAR2 | 30 | Identifies the exchange or non-exchange codes associated with the account. It is based on the ORA_FV_EXCHANGE_OR_NO_EXCHANGE lookup. | ||
| CUSTODIAL_OR_NONCUSTODIAL_CODE | VARCHAR2 | 30 | Identifies the custodial or non-custodial codes associated with the account. It is based on the ORA_FV_CUST_OR_NONCUST_CODE lookup. | ||
| AUTHORITY_TYPE_CODE | VARCHAR2 | 30 | Identifies the authority type codes associated with the account. It is based on the ORA_FV_AUTHORITY_TYPE lookup. | ||
| APPORTIONMENT_CATEGORY_CODE | VARCHAR2 | 30 | Identifies the apportionment category codes associated with the account. It is based on the ORA_FV_APPORTIONMENT_CAT_CODE lookup. | ||
| APPORTIONMENT_CATEGORY_B_CODE | VARCHAR2 | 30 | Indicates the apportionment category B code is defined in federal supplemental rules. | ||
| PROGRAM_REPORT_CODE | VARCHAR2 | 30 | Indicates program reporting category code defined in federal supplemental rules. | ||
| YEAR_OF_BUDGET_AUTHORITY_CODE | VARCHAR2 | 30 | Identifies the year of budget authority indicator code associated with the account. It is based on the ORA_FV_NEW_OR_BAL lookup. | ||
| AVAILABILITY_TIME_CODE | VARCHAR2 | 30 | Identifies the current or subsequent codes associated with the account. It is based on the ORA_FV_CURR_OR_SUBSEQUENT lookup. | ||
| BEA_CATEGORY_CODE | VARCHAR2 | 30 | Identifies the Budget Enforcement Act (BEA) category codes associated with the account. It is based on the ORA_FV_BEA_CATEGORY_CODE lookup. | ||
| BORROWING_SOURCE_CODE | VARCHAR2 | 30 | Identifies the borrowing source codes associated with the account. It is based on the ORA_FV_BORROWING_SOURCE lookup. | ||
| PYA_CODE | VARCHAR2 | 30 | Identifies the prior year adjustment codes associated with the account. It is based on the ORA_FV_PRIOR_YEAR_ADJUSTMENT lookup. | ||
| DIRECT_OR_REIMBURSABLE_CODE | VARCHAR2 | 30 | Identifies the direct or reimbursable codes associated with the account. It is based on the ORA_FV_DIRECT_OR_REIMBURSEABLE lookup. | ||
| BUDGET_IMPACT_INDICATOR_CODE | VARCHAR2 | 30 | Identifies the budget impact indicator codes associated with the account. It is based on the ORA_FV_BUDGT_IMPACT_INDICATOR lookup. | ||
| CREDIT_COHORT_YEAR | VARCHAR2 | 25 | Indicates the credit cohort year segment value. | ||
| REDUCTION_TYPE_CODE | VARCHAR2 | 30 | Identifies the reduction type codes associated with the account. It is based on the ORA_FV_REDUCTION_TYPE lookup. | ||
| DISASTER_EMERGENCY_FUND_CODE | VARCHAR2 | 30 | Indicates the disaster emergency fund code associated with the account. | ||
| BUDGET_OBJECT_CLASS | VARCHAR2 | 30 | Indicates the budget object class associated with the account. | ||
| DEBIT_CREDIT_INDICATOR_CODE | VARCHAR2 | 30 | Identifies the debit or credit code associated with the account. It is based on the ORA_FV_NORMAL_BALANCE lookup. | ||
| AMOUNT_DR | NUMBER | Indicates the accounted transaction debit amount. | |||
| AMOUNT_CR | NUMBER | Indicates the accounted transaction credit amount. | |||
| DEBIT_CREDIT_CODE | VARCHAR2 | 30 | Yes | Indicates whether the journal line amount is a debit amount (DR) or credit amount (CR). | |
| EXCEPTION_FLAG | VARCHAR2 | 1 | Indicates whether the journal line has exceptions. A value of 'Y' indicates that there are exceptions. | ||
| REPORTED_FLAG | VARCHAR2 | 1 | Indicates whether the journal line is already processed as part of the Bulk File Creation Process. A value of 'Y' indicates that the record is processed. | ||
| REPORTING_ATTRIBUTE1 | VARCHAR2 | 30 | Indicates the reporting attribute1 code associated with the account. | ||
| REPORTING_ATTRIBUTE2 | VARCHAR2 | 30 | Indicates the reporting attribute2 code associated with the account. | ||
| REPORTING_ATTRIBUTE3 | VARCHAR2 | 30 | Indicates the reporting attribute3 code associated with the account. | ||
| REPORTING_ATTRIBUTE4 | VARCHAR2 | 30 | Indicates the reporting attribute4 code associated with the account. | ||
| REPORTING_ATTRIBUTE5 | VARCHAR2 | 30 | Indicates the reporting attribute5 code associated with the account. | ||
| REPORTING_ATTRIBUTE6 | VARCHAR2 | 30 | Indicates the reporting attribute6 code associated with the account. | ||
| REPORTING_ATTRIBUTE7 | VARCHAR2 | 30 | Indicates the reporting attribute7 code associated with the account. | ||
| REPORTING_ATTRIBUTE8 | VARCHAR2 | 30 | Indicates the reporting attribute8 code associated with the account. | ||
| REPORTING_ATTRIBUTE9 | VARCHAR2 | 30 | Indicates the reporting attribute9 code associated with the account. | ||
| REPORTING_ATTRIBUTE10 | VARCHAR2 | 30 | Indicates the reporting attribute10 code associated with the account. | ||
| REPORTING_ATTRIBUTE11 | VARCHAR2 | 30 | Indicates the reporting attribute11 code associated with the account. | ||
| REPORTING_ATTRIBUTE12 | VARCHAR2 | 30 | Indicates the reporting attribute12 code associated with the account. | ||
| REPORTING_ATTRIBUTE13 | VARCHAR2 | 30 | Indicates the reporting attribute13 code associated with the account. | ||
| REPORTING_ATTRIBUTE14 | VARCHAR2 | 30 | Indicates the reporting attribute14 code associated with the account. | ||
| REPORTING_ATTRIBUTE15 | VARCHAR2 | 30 | Indicates the reporting attribute15 code associated with the account. | ||
| REPORTING_ATTRIBUTE16 | VARCHAR2 | 30 | Indicates the reporting attribute16 code associated with the account. | ||
| REPORTING_ATTRIBUTE17 | VARCHAR2 | 30 | Indicates the reporting attribute17 code associated with the account. | ||
| REPORTING_ATTRIBUTE18 | VARCHAR2 | 30 | Indicates the reporting attribute18 code associated with the account. | ||
| REPORTING_ATTRIBUTE19 | VARCHAR2 | 30 | Indicates the reporting attribute19 code associated with the account. | ||
| REPORTING_ATTRIBUTE20 | VARCHAR2 | 30 | Indicates the reporting attribute20 code associated with the account. | ||
| 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. | |
| 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FV_REPORTING_TRX_ACTIVITY_U1 | Unique | FUSION_TS_TX_DATA | TRANSACTION_ACTIVITY_ID |