# 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

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 |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.