BUDGET TRANSACTION DETAIL Table
View exposing detailed budget transaction records including budget document attributes, amounts, workflow dates, public and private comments, and cost collector information used for budget reporting and auditability.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPROVED_BY_USER |
Approved by user as provided by the source. |
VARCHAR2 |
8 |
APPROVED_DATE |
Date associated with approved. |
DATE |
|
BASE_AMOUNT |
Base amount as provided by the source. |
NUMBER |
15,2 |
BASE_FLAG |
Base flag as provided by the source. |
VARCHAR2 |
1 |
BUDGET_DOCUMENT_STATUS_CODE |
Code identifying budget document status. |
VARCHAR2 |
1 |
BUDGET_DOCUMENT_TYPE_KEY |
Surrogate key identifying the budget document type. |
VARCHAR2 |
3 |
BUDGET_DRAFT_REASON_KEY |
Surrogate key identifying the budget draft reason. |
VARCHAR2 |
6 |
BUDGET_DRAFT_STATUS_KEY |
Surrogate key identifying the budget draft status. |
VARCHAR2 |
2 |
BUDGET_POSTRULE_KEY |
Surrogate key identifying the budget postrule. |
VARCHAR2 |
1 |
CALCULATION_CODE |
Code identifying calculation. |
VARCHAR2 |
8 |
COMMENT_AUTHOR_NAME |
Comment author name as provided by the source. |
VARCHAR2 |
30 |
COMMENT_AUTHOR_POSITION |
Comment author position as provided by the source. |
VARCHAR2 |
20 |
COMMENT_REQUEST_SOURCE |
Comment request source as provided by the source. |
VARCHAR2 |
15 |
COST_COLLECTOR_FP_KEY |
Surrogate key identifying the cost collector fp. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Surrogate key identifying the cost collector fy. |
VARCHAR2 |
12 |
COST_COLLECTOR_ID |
Business identifier for the cost collector. |
VARCHAR2 |
7 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
COST_COLLECTOR_NAME |
Cost collector name as provided by the source. |
VARCHAR2 |
100 |
CREATED_BY_USER |
Created by user as provided by the source. |
VARCHAR2 |
8 |
CREATED_DATE |
Date associated with created. |
DATE |
|
FISCAL_YEAR |
Fiscal year as provided by the source. |
NUMBER |
4 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
MODIFIED_BY_USER |
Modified by user as provided by the source. |
VARCHAR2 |
8 |
MODIFIED_DATE |
Date associated with modified. |
DATE |
|
NIMBUS_LINE_ITEM_TEXT |
Nimbus line item text as provided by the source. |
VARCHAR2 |
80 |
NON_BASE_AMOUNT |
Non base amount as provided by the source. |
NUMBER |
15,2 |
ORIG_COMMENT |
Orig comment as provided by the source. |
VARCHAR2 |
2000 |
PRIVATE_COMMENT |
Private comment as provided by the source. |
VARCHAR2 |
2000 |
PUBLIC_COMMENT |
Public comment as provided by the source. |
VARCHAR2 |
2000 |
PUBLIC_COMMENT_AUTHOR |
Public comment author as provided by the source. |
VARCHAR2 |
30 |
PUBLIC_COMMENT_REQUEST_SOURCE |
Public comment request source as provided by the source. |
VARCHAR2 |
15 |
RECORD_COUNTER |
Record counter as provided by the source. |
NUMBER |
1 |
SUBMITTED_BY_USER |
Submitted by user as provided by the source. |
VARCHAR2 |
8 |
SUBMITTED_DATE |
Date associated with submitted. |
DATE |
|
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
TRANSACTION_LINE_NUMBER |
Transaction line number as provided by the source. |
NUMBER |
5 |
TRANSACTION_NUMBER |
Transaction number as provided by the source. |
NUMBER |
7 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |