FV_REPORTING_GTAS_BULK_EXTRACT
This table stores GTAS bulk file balances for USSGL and federal attributes.
Details
-
Schema: FUSION
-
Object owner: FV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FV_GTAS_BULK_EXTRACT_PK |
GTAS_BULK_EXTRACT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GTAS_BULK_EXTRACT_ID | NUMBER | 18 | Yes | Unique identifier for the bulk file data. | |
| LEDGER_ID | NUMBER | 18 | 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. | ||
| REPORTING_PERIOD_NUM | VARCHAR2 | 10 | The reporting period for GTAS bulk file reporting. For example, reporting period 01 indicates October, 02 indicates November, and so on. | ||
| 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. | ||
| TRADING_PARTNER_AGENCY_NUM | VARCHAR2 | 30 | The Treasury Account Symbol component which identifies the agency that is responsible for the budget account. | ||
| TRADING_PARTNER_MAIN_ACCOUNT | VARCHAR2 | 30 | The Treasury Account Symbol component which represents the type and purpose of the fund. | ||
| ALLOCATION_TRANSFER_AGENCY | VARCHAR2 | 30 | The Treasury Account Symbol component that identifies the agency receiving funds through an allocation transfer. | ||
| BEGIN_YEAR_OF_AVAILABILITY | VARCHAR2 | 30 | The Treasury Account Symbol component that identifies the first year of availability under law that an account may incur new obligations, in annual and multiyear accounts. | ||
| END_YEAR_OF_AVAILABILITY | VARCHAR2 | 30 | The Treasury Account Symbol component that identifies the last year of availability under law that an account may incur new obligations, in annual and multiyear accounts. | ||
| AVAILABILITY_TYPE_CODE | VARCHAR2 | 30 | The Treasury Account Symbol component that identifies no-year accounts (X), clearing/suspense accounts (F), Treasury central summary general ledger accounts (A), and merged-surplus accounts (M). | ||
| SUB_ACCOUNT_CODE | VARCHAR2 | 30 | The Treasury Symbol component that Identifies an available receipt or other Treasury-defined subdivision of the main account. | ||
| 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. | ||
| AGENCY_IDENTIFIER | VARCHAR2 | 30 | 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 | 30 | 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. | ||
| BEGIN_BALANCE | NUMBER | The beginning period balance for the account used for GTAS reporting. | |||
| AMOUNT_DR | NUMBER | Indicates the accounted transaction debit amount. | |||
| AMOUNT_CR | NUMBER | Indicates the accounted transaction credit amount. | |||
| END_BALANCE | NUMBER | The ending period balance for the account used for GTAS reporting. | |||
| FORMATTED_REPORTING_AMOUNT | VARCHAR2 | 150 | The formatted beginning or ending period balance amount for GTAS bulk file reporting. | ||
| EXCEPTION_FLAG | VARCHAR2 | 1 | Indicates whether the journal line has exceptions. A value of Y indicates that there are exceptions. | ||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or 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. | |
| 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_GTAS_BULK_EXTRACT_N1 | Non Unique | FUSION_TS_TX_IDX | REQUEST_ID, PERIOD_YEAR, CREATED_BY |
| FV_GTAS_BULK_EXTRACT_U1 | Unique | FUSION_TS_TX_IDX | GTAS_BULK_EXTRACT_ID |