DW_PERSON_DISABILITY_D

This dimension captures the Person Disability Information

Details

Module: Global Human Resources

Key Columns

PERSON_DISABILITY_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PERSON_DISABILITY_ID NUMBER 38 0 True Person Legistlation Identifier    
EFFECTIVE_START_DATE DATE     True Date at the beginning of the date range within which the row is effective.    
EFFECTIVE_END_DATE DATE     True Date at the end of the date range within which the row is effective.    
SOURCE_RECORD_ID VARCHAR2 256     Source Record Identifier Uniquely identifies the Person Disablity and used as the primary key    
PERSON_ID NUMBER 38 0   Identifier of the Person DW_PERSON_D PERSON_ID
LEGISLATION_CODE VARCHAR2 32     Legislation code derived from Legal Entity. DW_LEGISLATION_D_TL LEGISLATION_CODE
DISABILITY_ORGANIZATION_ID NUMBER 38 0   Disability Organization    
REGISTRATION_ID VARCHAR2 32     ID given to person following registration with disability organization    
REGISTRATION_DATE DATE       Date of registration with organization for the disabled    
REGISTRATION_EXP_DATE DATE       Expiry date of registration with organization for the disabled.    
DISABILITY_CATEGORY VARCHAR2 32     Person Disability Category Name DW_DISABILITY_CATEGORY_D_TL DISABILITY_CATEGORY
DISABILITY_DESCRIPTION VARCHAR2 2048     Person Disability description text    
DISABILITY_DEGREE NUMBER 38 0   Person Disability degree    
DISABILITY_REASON VARCHAR2 32     Person Disability Reason name DW_DISABILITY_REASON_D_TL DISABILITY_REASON
WORK_RESTRICTION VARCHAR2 2048     Person Disability work restriction details    
DISABILITY_STATUS VARCHAR2 32     Denotes the status for the person's disability like Temporary DW_DISABILITY_STATUS_D_TL DISABILITY_STATUS
SELF_DISCLOSED_TYPE VARCHAR2 32     Self Disclosed Disability DW_SELF_DISCLOSED_TYPE_D_TL SELF_DISCLOSED_TYPE
DISCLOSURE_DATE DATE       Disability Disclosure Date    
ACCOMMODATION_REQUEST VARCHAR2 2048     Accommodation Request    
DW_DATE_FROM DATE       Warehouse Effective From Date for the Person Disability record. If Initial extract date is greater than EFFECTIVE_FROM_DATE then Initial extract date is used.    
DW_DATE_TO DATE       Warehouse Effective To Date for the Person Disability record. This is equal to EFFECTIVE_END_DATE    
DW_INITIAL_RECORD_IND NUMBER 38 0   This indicates whether the record is the first event for the assignment to be brought into the warehouse based on initial extract date set by user.