DW_EB_X_EBS_PROJECTS_W_PROJ_RSRC_RQRMNT_F
Project resource requirements Fact table stores details of all resources requirements for a project.
Details
Module: Projects (EBS_PROJECTS)
Business Name: Project Resource Requirement 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_TYPE_WID | NUMBER | 38 | Indicates Assignment Type (open or staffed) | DW_EB_X_EBS_COMMON_W_XACT_TYPE_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 | |||
| BILL_RATE | NUMBER | |||||
| BILL_RATE_CURR_CD | VARCHAR2 | 15 CHAR | ||||
| 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 | |||
| EFFORT_QTY_IN_DAYS | NUMBER | 10 | Total number of days of the requirement | |||
| EFFORT_QTY_IN_HOURS | NUMBER | 10 | Total number of hours of the requirement | |||
| ETL_PROC_WID | NUMBER | 38 | ETL Process Identifier | |||
| EXPENDITURE_CLASS_WID | NUMBER | 38 | The class of the expenditure type. | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| EXPENDITURE_TYPE_WID | NUMBER | 38 | The expenditure type. | DW_EB_X_EBS_COMMON_W_FINANCIAL_RESOURCE_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 | ||
| PROJECT_WID | NUMBER | 38 | Identifier of the project | DW_EB_X_EBS_COMMON_W_PROJECT_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 | 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 Org | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PROJ_ROLE_WID | NUMBER | 38 | The identifier of the project role for the requirement | 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_END_DT | TIMESTAMP | 6 | The end date of the requirement | |||
| RQRMNT_END_DT_WID | NUMBER | 38 | The end date of the requirement | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| RQRMNT_LOCATION_WID | NUMBER | 38 | The identifier of the RESOURCE LOCATION for the requirement or assignment | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | ||
| RQRMNT_NAME | VARCHAR2 | 255 CHAR | Name of the requirement | |||
| RQRMNT_NUM | VARCHAR2 | 80 CHAR | requirement number | |||
| RQRMNT_START_DT | TIMESTAMP | 6 | The start date of the requirement | |||
| RQRMNT_START_DT_WID | NUMBER | 38 | The start date of the requirement | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| RQRMNT_STATUS_WID | NUMBER | 38 | Indicates requirement Status | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| RSRC_QTY | NUMBER | 10 | Number of resources required | |||
| TASK_WID | NUMBER | 38 | 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 | ||
| X_CUSTOM | VARCHAR2 | 10 CHAR | Generic Extension Column | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |