DW_EB_X_EBS_PROJECTS_W_EMPLOYMENT_D
DW_EB_X_EBS_PROJECTS_W_EMPLOYMENT_D dimension table stores the attributes with respect to an employment. By definition, 'Employment' is a contract between two parties, one being the employer and the other being the employee. In a commercial setting, the employer conceives of a productive activity, generally with the intention of creating profits, and the employee contributes labor to the enterprise, usually in return for payment of wages. Employment also exists in the public, non-profit and household sectors. The grain of this table is at an 'Employment' level. Examples of attributes stored in this table includes employment status, full or part time employment, pay cycle, FLSA status and so on. This table is designed to be a Type-1 dimension.
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 |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | Surrogate key to uniquely identify a record. | ||
| ACTIVE_FLG | VARCHAR2 | 30 CHAR | Identifies whether the record is Active/Enabled in the source | |||
| ASSIGNMENT_PRIMARY_CODE | VARCHAR2 | 30 CHAR | ||||
| ASSIGNMENT_STATUS_CODE | VARCHAR2 | 80 CHAR | ||||
| ASSIGNMENT_TYPE_CODE | VARCHAR2 | 30 CHAR | ||||
| 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. | |||
| C_EMPLOYEE_CAT_CODE | VARCHAR2 | 50 CHAR | ||||
| C_EMPLOYMENT_CAT_CODE | VARCHAR2 | 80 CHAR | ||||
| 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. | |||
| DELETE_FLG | VARCHAR2 | 30 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. | |||
| EMPLOYEE_CAT_CODE | VARCHAR2 | 50 CHAR | ||||
| EMPLOYMENT_CAT_CODE | VARCHAR2 | 80 CHAR | ||||
| EMPL_TYPE_SUBTYPE_WID | NUMBER | 38 | EMPL_TYPE_SUBTYPE_WID | |||
| 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. | |||
| FLSA_STATUS_CODE | VARCHAR2 | 50 CHAR | Fair Labor Standard Act Code - Status. This job is exempt from EEO reporting. | |||
| HOURLY_FLG | VARCHAR2 | 30 CHAR | Describes whether the employment is Hourly or Salaried | |||
| HOURLY_SALARIED_CODE | VARCHAR2 | 30 CHAR | ||||
| 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. | |||
| PERSON_TYPE_CODE | VARCHAR2 | 80 CHAR | ||||
| PERSON_TYPE_ID | VARCHAR2 | 80 CHAR | ||||
| PRIMARY_ASG_FLG | VARCHAR2 | 30 CHAR | ||||
| SALARY_BASIS_CODE | VARCHAR2 | 80 CHAR | ||||
| 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. | |||
| UNION_CODE | VARCHAR2 | 50 CHAR | Identifies the Union Code for an Employee | |||
| UNION_FLG | VARCHAR2 | 30 CHAR | Identifies if an employee belongs to any Union or Non Union | |||
| W_ASG_ACTIVE_INACTIVE_CODE | VARCHAR2 | 80 CHAR | ||||
| W_EXEMPT_FLG | VARCHAR2 | 80 CHAR | Describes whether the employment is exempt or non-exempt | |||
| W_FULL_TIME_FLG | VARCHAR2 | 80 CHAR | Describes whether the employment is Fulltime or Part time | |||
| W_HOURLY_FLG | VARCHAR2 | 30 CHAR | W_HOURLY_FLG | |||
| W_PRIMARY_ASG_FLG | VARCHAR2 | 30 CHAR | ||||
| W_REG_TEMP_CODE | VARCHAR2 | 80 CHAR | ||||
| W_WORKER_SUBTYPE_CODE | VARCHAR2 | 80 CHAR | ||||
| W_WORKER_TYPE_CODE | VARCHAR2 | 80 CHAR | ||||
| 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 |