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 This column is for Oracle Internal use only. 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