DW_EB_X_EBS_COMMON_W_MFG_RESOURCE_D
The MFG Resource dimension contains attributes defining Manufacturing Resources like Resource Name,Resource Type Name,Resource Code,Resource Type Code,Resource Category.
Details
Module: Common Tables (EBS_COMMON)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | Surrogate key to uniquely identify a record. | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle 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 | System field. This column identifies the last modified date and time of the auxiliary table's record that acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | System field. This column identifies the last modified date and time of the auxiliary table's record that acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | System field. This column identifies the last modified date and time of the auxiliary table's record that acts as a source for the current table. | |||
| CHANGED_BY_WID | NUMBER | 38 | Foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension that specifies 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 waslast modified in the source system. | |||
| COST_CODE_TYPE | VARCHAR2 | 50 CHAR | Cost Code Type | |||
| COST_CODE_TYPE_NAME | VARCHAR2 | 255 CHAR | Cost Code Type Name. | |||
| CREATED_BY_WID | NUMBER | 38 | 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. | |||
| 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, Oracle recommends that you define separate unique source IDs for each of your different source instances. | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of Y indicates 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. | |||
| ETL_PROC_WID | NUMBER | 38 | Oracle System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| EXPENDITURE_TYPE_CODE | VARCHAR2 | 50 CHAR | Expenditure Type code. | |||
| EXPENDITURE_TYPE_NAME | VARCHAR2 | 255 CHAR | Expenditure Type name | |||
| 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. | |||
| RESOURCE_CATEGORY | VARCHAR2 | 50 CHAR | Manifacture Resource Category. | |||
| RESOURCE_CODE | VARCHAR2 | 50 CHAR | Resource code for Manufacture | |||
| RESOURCE_NAME | VARCHAR2 | 255 CHAR | Manugacture Resource name. | |||
| RESOURCE_TYPE_CODE | VARCHAR2 | 50 CHAR | Manugacture Resource type code. | |||
| RESOURCE_TYPE_NAME | VARCHAR2 | 255 CHAR | Manugacture Resource type name. | |||
| 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. | |||
| UNIT_OF_MEASURE | VARCHAR2 | 50 CHAR | Unit of Measure. | |||
| 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 |