FV_DATA_ACT_BALANCES_EXTRACT
This table stores the calculated balance amount for the DATA Act Files.
Details
-
Schema: FUSION
-
Object owner: FV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FV_DATA_ACT_BAL_EXTRACT_PK |
BALANCES_EXTRACT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BALANCES_EXTRACT_ID | NUMBER | 18 | Yes | Unique identifier of the report balance | |
| FILE_CODE | VARCHAR2 | 30 | Yes | File code that has been processed. | |
| SEQUENCE_NUMBER | NUMBER | 6 | Yes | Sequence number to identify the report balance for a file code | |
| 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. | |
| PROGRAM_ACTIVITY_CODE | VARCHAR2 | 30 | The program activity code for the agency defined in federal attribute supplemental rules. | ||
| PARK_CODE | VARCHAR2 | 30 | The Program Activity Reporting Key for the agency defined in federal attribute supplemental rules. | ||
| 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. | ||
| 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. | ||
| TO_PERIOD_NUM | NUMBER | 18 | Yes | Period number that idecates till which period the report has been executed. | |
| REPORT_RUN_ID | NUMBER | 18 | Yes | Unique identifier of the file processing attributes. | |
| BALANCE_HEADER_ID_1 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_1 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_2 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_2 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_3 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_3 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_4 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_4 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_5 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_5 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_6 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_6 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_7 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_7 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_8 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_8 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_9 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_9 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_10 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_10 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_11 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_11 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_12 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_12 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_13 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_13 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_14 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_14 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_15 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_15 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_16 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_16 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_17 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_17 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_18 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_18 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_19 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_19 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_20 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_20 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_21 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_21 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_22 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_22 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_23 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_23 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_24 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_24 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_25 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_25 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_26 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_26 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_27 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_27 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_28 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_28 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_29 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_29 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_30 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_30 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_31 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_31 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_32 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_32 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_33 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_33 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_34 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_34 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_35 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_35 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_36 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_36 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_37 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_37 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_38 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_38 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_39 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_39 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_40 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_40 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_41 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_41 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_42 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_42 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_43 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_43 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_44 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_44 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_45 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_45 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_46 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_46 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_47 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_47 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_48 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_48 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_49 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_49 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_50 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_50 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_51 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_51 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_52 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_52 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_53 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_53 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_54 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_54 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_55 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_55 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_56 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_56 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_57 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_57 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_58 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_58 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_59 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_59 | NUMBER | Balance amount that belongs to the balance header id | |||
| BALANCE_HEADER_ID_60 | NUMBER | 18 | Balance header id for which the balance amount belongs | ||
| BALANCE_AMOUNT_60 | NUMBER | Balance amount that belongs to the balance header id | |||
| 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. | ||
| REPORTING_ATTRIBUTE1 | VARCHAR2 | 150 | Indicates the reporting attribute1 code associated with the account. | ||
| REPORTING_ATTRIBUTE2 | VARCHAR2 | 150 | Indicates the reporting attribute2 code associated with the account. | ||
| REPORTING_ATTRIBUTE3 | VARCHAR2 | 150 | Indicates the reporting attribute3 code associated with the account. | ||
| REPORTING_ATTRIBUTE4 | VARCHAR2 | 150 | Indicates the reporting attribute4 code associated with the account. | ||
| REPORTING_ATTRIBUTE5 | VARCHAR2 | 150 | Indicates the reporting attribute5 code associated with the account. | ||
| REPORTING_ATTRIBUTE6 | VARCHAR2 | 150 | Indicates the reporting attribute6 code associated with the account. | ||
| REPORTING_ATTRIBUTE7 | VARCHAR2 | 150 | Indicates the reporting attribute7 code associated with the account. | ||
| REPORTING_ATTRIBUTE8 | VARCHAR2 | 150 | Indicates the reporting attribute8 code associated with the account. | ||
| REPORTING_ATTRIBUTE9 | VARCHAR2 | 150 | Indicates the reporting attribute9 code associated with the account. | ||
| REPORTING_ATTRIBUTE10 | VARCHAR2 | 150 | Indicates the reporting attribute10 code associated with the account. | ||
| REPORTING_ATTRIBUTE11 | VARCHAR2 | 150 | Indicates the reporting attribute11 code associated with the account. | ||
| REPORTING_ATTRIBUTE12 | VARCHAR2 | 150 | Indicates the reporting attribute12 code associated with the account. | ||
| REPORTING_ATTRIBUTE13 | VARCHAR2 | 150 | Indicates the reporting attribute13 code associated with the account. | ||
| REPORTING_ATTRIBUTE14 | VARCHAR2 | 150 | Indicates the reporting attribute14 code associated with the account. | ||
| REPORTING_ATTRIBUTE15 | VARCHAR2 | 150 | Indicates the reporting attribute15 code associated with the account. | ||
| REPORTING_ATTRIBUTE16 | VARCHAR2 | 150 | Indicates the reporting attribute16 code associated with the account. | ||
| REPORTING_ATTRIBUTE17 | VARCHAR2 | 150 | Indicates the reporting attribute17 code associated with the account. | ||
| REPORTING_ATTRIBUTE18 | VARCHAR2 | 150 | Indicates the reporting attribute18 code associated with the account. | ||
| REPORTING_ATTRIBUTE19 | VARCHAR2 | 150 | Indicates the reporting attribute19 code associated with the account. | ||
| REPORTING_ATTRIBUTE20 | VARCHAR2 | 150 | 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| FV_DATA_ACT_BAL_EXTRACT_U1 | Unique | FUSION_TS_TX_DATA | BALANCES_EXTRACT_ID | |
| FV_DATA_ACT_BAL_EXTRACT_U2 | Unique | FUSION_TS_TX_DATA | FILE_CODE, SEQUENCE_NUMBER, TREASURY_ACCOUNT_SYMBOL, PROGRAM_ACTIVITY_CODE, BUDGET_OBJECT_CLASS, DIRECT_OR_REIMBURSABLE_CODE, DISASTER_EMERGENCY_FUND_CODE, PIID_NUMBER, PARENT_AWARD_NUMBER, FAIN_NUMBER, URI, TO_PERIOD_NUM, REPORT_RUN_ID | Obsolete |
| FV_DATA_ACT_BAL_EXTRACT_U3 | Unique | FUSION_TS_TX_DATA | FILE_CODE, SEQUENCE_NUMBER, REPORT_RUN_ID |