DW_JOB_FAMILY_CURRENT_D
It holds Job Families. Job Families enable identification of related jobs that may not reflect the same attributes as other jobs in the same grouping. It holds only current records.
Details
Module: Global Human Resources
Key Columns
JOB_FAMILY_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| JOB_FAMILY_ID | NUMBER | 38 | 0 | True | Transaction system generated primary key column.For translation refer table DW_JOB_FAMILY_D_CURRENT_TL joining this ID. | DW_JOB_FAMILY_D_CURRENT_TL | JOB_FAMILY_ID |
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Unique Source Record Identifier This column contains JOB_FAMILY_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. | ||||
| BUSINESS_GROUP_ID | NUMBER | 38 | 0 | Identifier of Enterprise, used for multi-tenancy partitioning. | |||
| ACTIVE_STATUS | VARCHAR2 | 32 | Indicates if a job family is active or inactive. | ||||
| JOB_FAMILY_CODE | VARCHAR2 | 256 | Code for Job Family |