DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PER_DISABILITIES_F

Object Details
Object Name: PER_DISABILITIES_F
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_DISABILITIES_F
Subobject Name:
Status: VALID


This date tracked table stores the detatils of any disabilities a person may have.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_DISABILITIES_F_PK
  1. ColumnDISABILITY_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
PER_DISABILITIES_F_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDISABILITY_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_DISABILITIES_F PER_DISABILITIES_F_FK3 TableHR_ALL_ORGANIZATION_UNITS PER_DISABILITIES_F ORGANIZATION_ID
PER_DISABILITIES_F PER_DISABILITIES_F_FK2 TablePER_WORK_INCIDENTS PER_DISABILITIES_F INCIDENT_ID
Columns
Name Datatype Length Mandatory Comments
DISABILITY_ID NUMBER (10) Yes Primary key. Generated from sequence PER_DISABILITIES_S.
EFFECTIVE_START_DATE DATE
Yes Effective Start Date
EFFECTIVE_END_DATE DATE
Yes Effective End Date
PERSON_ID NUMBER (10) Yes Foreign key to PER_PEOPLE_F.
INCIDENT_ID NUMBER (10)
Foreign key to PER_WORK_INCIDENTS.
ORGANIZATION_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS.
ASSIGNMENT_ID NUMBER (10)
REGISTRATION_ID VARCHAR2 (30)
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.
ASSESSMENT_DUE_DATE DATE

CATEGORY VARCHAR2 (30) Yes Official category of disability.
DESCRIPTION VARCHAR2 (2000)
Description of disability.
DEGREE NUMBER (5)
Assessed percentage of disability.
QUOTA_FTE NUMBER (5) Yes Full time equivalence quota.
REASON VARCHAR2 (30)
Reason for disability.
PRE_REGISTRATION_JOB VARCHAR2 (30)
Name of job held by person at disability registration date.
WORK_RESTRICTION VARCHAR2 (2000)
Description of restriction(s) to work.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flex structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE21 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE22 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE23 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE24 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE25 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE26 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE27 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE28 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE29 VARCHAR2 (150)
Descriptive flex column.
ATTRIBUTE30 VARCHAR2 (150)
Descriptive flex column.
DIS_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flex structure defining column
DIS_INFORMATION1 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION2 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION3 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION4 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION5 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION6 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION7 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION8 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION9 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION10 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION11 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION12 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION13 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION14 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION15 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION16 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION17 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION18 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION19 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION20 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION21 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION22 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION23 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION24 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION25 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION26 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION27 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION28 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION29 VARCHAR2 (150)
Developer descriptive flex column.
DIS_INFORMATION30 VARCHAR2 (150)
Developer descriptive flex column.
LAST_UPDATE_DATE DATE

standard Who column.
LAST_UPDATED_BY NUMBER (15)
standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
standard Who column.
CREATED_BY NUMBER (15)
standard Who column.
CREATION_DATE DATE

standard Who column.
OBJECT_VERSION_NUMBER NUMBER (9) Yes System-generated version of row. Increments by one with each update.
STATUS VARCHAR2 (30) Yes Status of the record
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DISABILITY_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PERSON_ID
,      INCIDENT_ID
,      ORGANIZATION_ID
,      ASSIGNMENT_ID
,      REGISTRATION_ID
,      REGISTRATION_DATE
,      REGISTRATION_EXP_DATE
,      ASSESSMENT_DUE_DATE
,      CATEGORY
,      DESCRIPTION
,      DEGREE
,      QUOTA_FTE
,      REASON
,      PRE_REGISTRATION_JOB
,      WORK_RESTRICTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      DIS_INFORMATION_CATEGORY
,      DIS_INFORMATION1
,      DIS_INFORMATION2
,      DIS_INFORMATION3
,      DIS_INFORMATION4
,      DIS_INFORMATION5
,      DIS_INFORMATION6
,      DIS_INFORMATION7
,      DIS_INFORMATION8
,      DIS_INFORMATION9
,      DIS_INFORMATION10
,      DIS_INFORMATION11
,      DIS_INFORMATION12
,      DIS_INFORMATION13
,      DIS_INFORMATION14
,      DIS_INFORMATION15
,      DIS_INFORMATION16
,      DIS_INFORMATION17
,      DIS_INFORMATION18
,      DIS_INFORMATION19
,      DIS_INFORMATION20
,      DIS_INFORMATION21
,      DIS_INFORMATION22
,      DIS_INFORMATION23
,      DIS_INFORMATION24
,      DIS_INFORMATION25
,      DIS_INFORMATION26
,      DIS_INFORMATION27
,      DIS_INFORMATION28
,      DIS_INFORMATION29
,      DIS_INFORMATION30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      STATUS
FROM HR.PER_DISABILITIES_F;

Dependencies

[top of page]

HR.PER_DISABILITIES_F does not reference any database object

HR.PER_DISABILITIES_F is referenced by following:

SchemaAPPS
SynonymPER_DISABILITIES_F
TriggerPER_DISABILITIES_F_WHO
SchemaPUBLIC
SynonymPER_DISABILITIES_F