DW_EB_X_EBS_PROJECTS_W_PROJ_REVENUE_HDR_F
This fact table stores data at the revenue header level (Draft Revenue), this table will contain metrics defined only at the header level in OLTP, like Unearned Revenue and Unbilled Receivables and aggregated metrics from the Line tables for the amounts defined at the Line item only (like Revenue Amount). It contains both Expenditure and Event revenue records.
Details
Module: Projects (EBS_PROJECTS)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | |||
| ACCT_DOC_ID_1 | VARCHAR2 | 80 CHAR | ||||
| ACCT_DOC_ID_2 | VARCHAR2 | 80 CHAR | ||||
| ACCT_DOC_ID_3 | VARCHAR2 | 80 CHAR | ||||
| ACCT_DOC_ID_4 | VARCHAR2 | 80 CHAR | ||||
| AGREEMENT_WID | NUMBER | 38 | Key to Project Contract Dimension | DW_EB_X_EBS_AR_W_CONTRACT_HDR_D | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| CHANGED_BY_WID | NUMBER | 38 | This is a key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | This is the date, in Julian format, on which the record was last updated in the source system. This column also functions as a key to DW_EB_X_EBS_COMMON_W_DAY_D | |||
| CONTRACT_BU_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| CONTRACT_ORGANIZATION_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| CREATED_BY_WID | NUMBER | 38 | This is a key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | This is the date, in Julian format, on which the record was created in the source system. This column also functions as a key to DW_EB_X_EBS_COMMON_W_DAY_D | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| DRAFT_REVENUE_NUM | NUMBER | 15 | ||||
| ENTERPRISE_GL_DT_WID | NUMBER | 38 | Key to the Enterprise Day Dimension | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| ETL_PROC_WID | NUMBER | 38 | This column is the unique identifier for the specific ETL process used to create or update this data | |||
| EVENT_WID | NUMBER | 38 | The identifier of the draft revenue in the revenue distribution line | DW_EB_X_EBS_PROJECTS_W_EVENT_D | ||
| GL_ACCOUNTING_DT_WID | NUMBER | 38 | Key to the GL Multi-Calendar Day Dimension | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| GL_MCAL_CAL_WID | NUMBER | 38 | Key to the GL Multi-Calendar Dimension | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | Functional Currency Code | |||
| LOC_REALIZED_GAINS_AMT | NUMBER | 38,10 | ||||
| LOC_REALIZED_LOSSES_AMT | NUMBER | 38,10 | ||||
| LOC_TO_GLOBAL1_EXCHANGE_RATE | NUMBER | Conversion rate used to convert from functional currency to DW global currency 1 | ||||
| LOC_TO_GLOBAL2_EXCHANGE_RATE | NUMBER | Conversion rate used to convert from functional currency to DW global currency 2 | ||||
| LOC_TO_GLOBAL3_EXCHANGE_RATE | NUMBER | Conversion rate used to convert from functional currency to DW global currency 3 | ||||
| LOC_UNBILLED_RECEIVABLE | NUMBER | 28,10 | Total unbilled receivable amount in functional currency | |||
| LOC_UNEARNED_REVENUE | NUMBER | 28,10 | Total unearned revenue amount in functional currency | |||
| PA_MCAL_CAL_WID | NUMBER | 38 | Key to the Project Multi-Calendar Dimension | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| PROJECT_WID | NUMBER | 38 | Key to Project Dimension | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| PROJ_ACCOUNTING_DT_WID | NUMBER | 38 | Key to the Project Multi-Calendar Day Dimension | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| PROJ_LOCATION_WID | NUMBER | 38 | Key to the Project Geography Dimension | DW_EB_X_EBS_COMMON_W_GEO_D | ||
| PROJ_MANAGER_WID | NUMBER | 38 | Key to the Project Manager Employee Dimension | |||
| PROJ_OPER_UNIT_WID | NUMBER | 38 | Key to the Project Business Unit Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJ_ORGANIZATION_WID | NUMBER | 38 | Key to the Project Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJ_PR_CUSTOMER_ACCOUNT_WID | NUMBER | 38 | Key to Project Primary Customer Account Dimension | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | ||
| PROJ_PR_CUSTOMER_WID | NUMBER | 38 | Key to Project Primary Customer Dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| REALIZED_GAINS_GL_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | |||
| REALIZED_LOSSES_GL_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | |||
| REV_STATUS_WID | NUMBER | 38 | Key to the Revenue Status Dimension | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| ROW_WID | NUMBER | 38 | Surrogate key to uniquely identify a record. | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model | |||
| TRANSFER_REJECTION_REASON | VARCHAR2 | 250 CHAR | ||||
| UNBILLED_GL_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | |||
| UNEARNED_GL_ACCOUNT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |