eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.HRBV_DISABILITIES_V

Object Details

Object Name:	HRBV_DISABILITIES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Deployment factors (from PER_DEPLOYMENT_FACTORS table).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EFFECTIVE_START_DATE	DATE		Yes	Effective start date.
EFFECTIVE_END_DATE	DATE		Yes	Effective end date.
REGISTRATION_DATE	DATE			Registration date.
REGISTRATION_EXP_DATE	DATE			Registration expiry date.
CATEGORY	VARCHAR2	(30)	Yes	(Lookup code based on lookup type DISABILITY_CATEGORY).
CATEGORY_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type DISABILITY_CATEGORY).
DESCRIPTION	VARCHAR2	(2000)		Description.
DEGREE	NUMBER	(5)		Degree.
QUOTA_FTE	NUMBER	(5)	Yes	Quota fte.
REASON	VARCHAR2	(30)		(Lookup code based on lookup type DISABILITY_REASON).
REASON_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type DISABILITY_REASON).
PRE_REGISTRATION_JOB	VARCHAR2	(30)		Pre registration job.
WORK_RESTRICTION	VARCHAR2	(2000)		Work restriction.
DIS_INFORMATION_CATEGORY	VARCHAR2	(30)		Dis information category.
DIS_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION21	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION22	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION23	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION24	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION25	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION26	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION27	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION28	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION29	VARCHAR2	(150)		Developer descriptive flexfield column.
DIS_INFORMATION30	VARCHAR2	(150)		Developer descriptive flexfield column.
STATUS_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type DISABILITY_STATUS).
STATUS	VARCHAR2	(30)		(Lookup code based on lookup type DISABILITY_STATUS).
_DF:DIS	CHAR	(28)		Descriptive Flexfield Column
DISABILITY_ID	NUMBER	(10)	Yes	Primary key for PER_DISABILITIES_F.
PERSON_ID	NUMBER	(10)	Yes	Foreign key to PER_ALL_PEOPLE_F.
INCIDENT_ID	NUMBER	(10)		Foreign key to PER_WORK_INCIDENTS.
ORGANIZATION_ID	NUMBER	(15)		Foreign key to HR_ALL_ORGANIZATION_UNITS.
REGISTRATION_ID	VARCHAR2	(30)		Registration Id.
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column

Query Text

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


SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      REGISTRATION_DATE
,      REGISTRATION_EXP_DATE
,      CATEGORY
,      CATEGORY_M
,      DESCRIPTION
,      DEGREE
,      QUOTA_FTE
,      REASON
,      REASON_M
,      PRE_REGISTRATION_JOB
,      WORK_RESTRICTION
,      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
,      STATUS_M
,      STATUS
,      _DF:DIS
,      DISABILITY_ID
,      PERSON_ID
,      INCIDENT_ID
,      ORGANIZATION_ID
,      REGISTRATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.HRBV_DISABILITIES_V;

Dependencies

[top of page]

APPS.HRBV_DISABILITIES_V references the following:

APPS: HR_BIS - show dependent code; PER_DISABILITIES_F

APPS.HRBV_DISABILITIES_V is not referenced by any database object