DW_EB_X_EBS_PROJECTS_W_PROJ_RSRC_UTILIZATION_F
Project resource utilization Fact table stores detailed information by day for each assignment in Oracle Project Resource Management. It also stores similar information for each unassigned day for all resources that can be scheduled. It has the available/capacity/actual hours etc.
Details
Module: Projects (EBS_PROJECTS)
Business Name: Project Resource Utilization Fact
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 | Datasource Num Id | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | Integration Id | |||
| ASSIGNMENT_QTY | NUMBER | 28,10 | item qty | |||
| ASSIGNMENT_STATUS_WID | NUMBER | 38 | Status of the assignment | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| ASSIGNMENT_TYPE_WID | NUMBER | 38 | Indicates Assignment Type | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| ASSIGNMENT_WID | NUMBER | 38 | DW_EB_X_EBS_PROJECTS_W_PROJ_ASSIGNMENT_D | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary 1 Changed on Date | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary 2 Changed on Date | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary 3 Changed on Date | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary 4 Changed on Date | |||
| AVAILABLE_RESOURCE_FLG | VARCHAR2 | 38 CHAR | A value of 'Y' in this column indicates if the resource is avaiable for that date | |||
| CHANGED_BY_WID | NUMBER | 38 | OLTP user who last updated the transaction | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | OLTP last update date of the transaction | |||
| CREATED_BY_WID | NUMBER | 38 | OLTP user who created the transaction | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | OLTP creation date of the transaction | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | Delete Flag | |||
| EMP_WID | NUMBER | 38 | Resource identifier | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| ETL_GEN_ROW_FLG | VARCHAR2 | 1 CHAR | ||||
| ETL_PROC_WID | NUMBER | 38 | ETL Process Identifier | |||
| EXPENDITURE_BU_WID | NUMBER | 38 | Expenditure OU | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| EXPENDITURE_CLASS_WID | NUMBER | 38 | The class of the expenditure type. | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| EXPENDITURE_ORGANIZATION_WID | NUMBER | 38 | Expenditure Organization | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| EXPENDITURE_TYPE_WID | NUMBER | 38 | The expenditure type. | DW_EB_X_EBS_COMMON_W_FINANCIAL_RESOURCE_D | ||
| FORECAST_DT_WID | NUMBER | The date of the forecast item/ expenditure item in proj cal | DW_EB_X_EBS_PROJECTS_W_HOLIDAY_DAY_D | |||
| GL_ACCOUNTING_DT_WID | NUMBER | 38 | The date of the forecast item/ expenditure item | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| JOB_WID | NUMBER | 38 | The identifier of the job of an employee as of the expenditure item date. | DW_EB_X_EBS_PROJECTS_W_JOB_D | ||
| POSITION_DH_WID | NUMBER | 38 | mgr hier | DW_EB_X_EBS_COMMON_W_POSITION_DH | ||
| PROJECT_WID | NUMBER | 38 | Identifier of the project | DW_EB_X_EBS_COMMON_W_PROJECT_D | ||
| PROJ_ACCOUNTING_DT_WID | NUMBER | 38 | The date of the forecast item/ expenditure item in gl cal | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| PROJ_BU_WID | NUMBER | 38 | Project OU | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJ_LOCATION_WID | NUMBER | 38 | The identifier of the project LOCATION for the requirement or assignment | DW_EB_X_EBS_COMMON_W_GEO_D | ||
| PROJ_MANAGER_WID | NUMBER | 38 | Manager of the project | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| PROJ_ORGANIZATION_WID | NUMBER | 38 | Project Organization | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJ_ROLE_WID | NUMBER | 38 | The identifier of the project role for the requirement or assignment | DW_EB_X_EBS_COMMON_W_PROJECT_ROLE_D | ||
| PROJ_STATUS_WID | NUMBER | 38 | Project status | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| ROW_WID | NUMBER | 38 | System generated row id | |||
| RQRMNT_ID | VARCHAR2 | 80 CHAR | Identifier of the REQUIREMENT | |||
| RSRC_CAPACITY_QTY | NUMBER | 28,10 | capacity qty | |||
| RSRC_LOCATION_WID | NUMBER | 38 | The identifier of the RESOURCE LOCATION for the requirement or assignment | DW_EB_X_EBS_COMMON_W_GEO_D | ||
| TASK_WID | NUMBER | 38 | Identifier of the task | DW_EB_X_EBS_COMMON_W_TASK_D | ||
| TENANT_ID | VARCHAR2 | 80 CHAR | Tenant Id | |||
| UOM | VARCHAR2 | 30 CHAR | Base unit of measure | |||
| WORK_TYPE_WID | NUMBER | 38 | Work Types are predefined types of work, for example, Vacation, Training, and Administration. | DW_EB_X_EBS_PROJECTS_W_WORK_TYPE_D | ||
| W_FORECAST_TYPE | VARCHAR2 | 30 CHAR | Assignment or Unassigned row | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | Generic Extension Column | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |