DW_EB_X_EBS_PROJECTS_W_PROJ_FUNDING_HDR_F
This fact table stores funding data from the OLTP summarized by agreement, project and task. It is used to provide metrics like Baselined Amount, Unbaselined Amount, Revenue Amount, Invoice Amount etc. Funding Metrics can be analyzed by Project, Task, Agreement, Organizations, Customer etc.
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. | |||
| AGREEMENT_CUSTOMER_ACCOUNT_WID | NUMBER | 38 | Key to Agreeement Customer Account Dimension | DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D | ||
| AGREEMENT_CUSTOMER_WID | NUMBER | 38 | Key to Agreement Customer Dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| AGREEMENT_OPER_UNIT_WID | NUMBER | 38 | Key to Contract BU Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| AGREEMENT_ORGANIZATION_WID | NUMBER | 38 | Key to Agreement Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| AGREEMENT_WID | NUMBER | 38 | Key to Project Contracts Dimension | DW_EB_X_EBS_AR_W_CONTRACT_HDR_D | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. 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 | Siebel System field. 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 | Siebel System field. 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 | Siebel System field. 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 foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign 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 | Identifies the date and time when the record was initially created in the source system. | |||
| 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. | |||
| DOC_ACCRUED_AMT | NUMBER | 38,10 | Total amount accrued against the baselined funding in transaction currency | |||
| DOC_AGREEMENT_AMT | NUMBER | 38,10 | Amount of revenue authorized for the agreement in transaction currency | |||
| DOC_ALLOCATED_AMT | NUMBER | 38,10 | Total amount allocated from the agreement to the project or task in transaction currency | |||
| DOC_BASELINED_AMT | NUMBER | 38,10 | Total baselined amount allocated from the agreement to the project or task in transaction currency | |||
| DOC_BILLED_AMT | NUMBER | 38,10 | Total amount billed against the baselined funding in transaction currency | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | Transaction Currency Code | |||
| DOC_UNBASELINED_AMT | NUMBER | 38,10 | Total unbaselined amount allocated from the agreement to the project or task in transaction currency | |||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| GLOBAL1_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from transaction Currency to Global1 Currency | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from transaction Currency to Global2 Currency | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from transaction Currency to Global3 Currency | ||||
| LOC_ACCRUED_AMT | NUMBER | 38,10 | Total amount accrued against the baselined funding in local currency | |||
| LOC_ALLOCATED_AMT | NUMBER | 38,10 | Total amount allocated from the agreement to the project or task in local currency | |||
| LOC_BASELINED_AMT | NUMBER | 38,10 | Total baselined amount allocated from the agreement to the project or task in local currency | |||
| LOC_BILLED_AMT | NUMBER | 38,10 | Total amount billed against the baselined funding in local currency | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | Local Currency Code | |||
| LOC_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from transaction currency to local currency | ||||
| LOC_UNBASELINED_AMT | NUMBER | 38,10 | Total unbaselined amount allocated from the agreement to the project or task in local currency | |||
| OPERATING_UNIT_ORG_WID | NUMBER | 38 | Key to Operating Unit Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PAYMENT_TERMS_WID | NUMBER | 38 | Key to Payment Terms Dimension | DW_EB_X_EBS_COMMON_W_PAYMENT_TERMS_D | ||
| PROJECT_WID | NUMBER | 38 | Key to Project Dimension | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| PROJ_ACCRUED_AMT | NUMBER | 38,10 | Total amount accrued against the baselined funding in project currency | |||
| PROJ_ALLOCATED_AMT | NUMBER | 38,10 | Total amount allocated from the agreement to the project or task in project currency | |||
| PROJ_BASELINED_AMT | NUMBER | 38,10 | Total baselined amount allocated from the agreement to the project or task in project currency | |||
| PROJ_BILLED_AMT | NUMBER | 38,10 | Total amount billed against the baselined funding in project currency | |||
| PROJ_CURR_CODE | VARCHAR2 | 30 CHAR | Project currency code | |||
| PROJ_EXCHANGE_RATE | NUMBER | Exchange Rate for conversion from transaction currency to project currency | ||||
| PROJ_LOCATION_WID | NUMBER | 38 | Key to Project Location Dimension | DW_EB_X_EBS_COMMON_W_GEO_D | ||
| PROJ_MANAGER_WID | NUMBER | 38 | Key to Project Manager Dimension | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| PROJ_OPER_UNIT_WID | NUMBER | 38 | Key to Project BU Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJ_ORGANIZATION_WID | NUMBER | 38 | Key to 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 | ||
| PROJ_STATUS_WID | NUMBER | 38 | Key to Project Status Dimension | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| PROJ_UNBASELINED_AMT | NUMBER | 38,10 | Total unbaselined amount allocated from the agreement to the project or task in project currency | |||
| ROW_WID | NUMBER | 38 | Surrogate key to uniquely identify a record. | |||
| TASK_ORGANIZATION_WID | NUMBER | 38 | Key to Task Organization Dimension | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| TASK_WID | NUMBER | 38 | Key to Task Dimension | DW_EB_X_EBS_COMMON_W_TASK_D | ||
| 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. | |||
| 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 |