# 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 |  |  | This column is for Oracle Internal use only. 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 | 999 |  |  | Person Disability description text |  |
DISABILITY_DEGREE | NUMBER |  |  |  | Person Disability degree |  |
DISABILITY_REASON | VARCHAR2 | 32 |  |  | Person Disability Reason name | DW_DISABILITY_REASON_D_TL | DISABILITY_REASON
WORK_RESTRICTION | VARCHAR2 | 999 |  |  | 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 | 999 |  |  | 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. |  |

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