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     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, 2022, Oracle and/or its affiliates.