DW_TA_REGULATORY_RESPONSES_D

This dimension captures the Regulatory Response Details

Details

Module: Recruiting

Key Columns

RESPONSE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RESPONSE_ID NUMBER 38 0 True Stores Response Id    
SOURCE_RECORD_ID NUMBER 38 0   Unique Key    
JOB_APPLICATION_ID NUMBER 38 0   Stores Job Application Id DW_TA_JOB_APPLICATION_D JOB_APPLICATION_ID
PERSON_ID NUMBER 38 0   Stores Person Id DW_PERSON_D PERSON_ID
LEGISLATION_CODE VARCHAR2 32     Legislation code derived from Job Requisition Locations.    
ATTRIBUTE_1 VARCHAR2 512     Gender    
ATTRIBUTE_2 VARCHAR2 512     Ethnicity    
ATTRIBUTE_3 VARCHAR2 512     Veteran Status    
ATTRIBUTE_4 VARCHAR2 512     Disability Status    
ATTRIBUTE_5 VARCHAR2 512     Marital Status    
ATTRIBUTE_6 VARCHAR2 512     Religion    
ATTRIBUTE_7 VARCHAR2 512     Disability Category    
ATTRIBUTE_8 VARCHAR2 512     Disability Reason    
ATTRIBUTE_DATE_1 DATE       Disclosure Date    
ATTRIBUTE_DATE_2 DATE       Date of Birth