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.PER_MEDICAL_ASSESSMENTS_V

Object Details

Object Name:	PER_MEDICAL_ASSESSMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_MEDICAL_ASSESSMENTS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
MEDICAL_ASSESSMENT_ID	NUMBER	(10)	Yes	Primary Key
PERSON_ID	NUMBER	(10)	Yes	Foreign key to PER_PEOPLE_F
EXAMINER_NAME	VARCHAR2	(240)		Name of medical examiner
ORGANIZATION_ID	NUMBER	(15)		Foreign key to HR_ALL_ORGANIZATION_UNITS.
NAME	VARCHAR2	(240)		Name of person who the examination is for.
CONSULTATION_DATE	DATE		Yes	Date medical examination took place
CONSULTATION_TYPE	VARCHAR2	(30)	Yes	Type of consultation
CONSULTATION_TYPE_DESC	VARCHAR2	(80)		Full lenght description of the consultation type
INCIDENT_ID	NUMBER	(10)		Foreign key to PER_WORK_INCIDENTS
INCIDENT_REFERENCE	VARCHAR2	(30)		Work Incident Reference
INCIDENT_DATE	DATE			Date of Work Incident
CONSULTATION_RESULT	VARCHAR2	(30)		Consultation Result
CONSULTATION_RESULT_DESC	VARCHAR2	(80)		Full length description of the consultation result
DISABILITY_ID	NUMBER	(10)		Foreign Key to PER_DISABILITIES_F
NEXT_CONSULTATION_DATE	DATE			Date next consultation is due
DESCRIPTION	VARCHAR2	(2000)		Description of medical assessment
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.
MEA_INFORMATION_CATEGORY	VARCHAR2	(30)		Developer descriptive flex structure defining column
MEA_INFORMATION1	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION2	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION3	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION4	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION5	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION6	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION7	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION8	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION9	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION10	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION11	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION12	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION13	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION14	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION15	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION16	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION17	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION18	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION19	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION20	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION21	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION22	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION23	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION24	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION25	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION26	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION27	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION28	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION29	VARCHAR2	(150)		Developer descriptive flex column
MEA_INFORMATION30	VARCHAR2	(150)		Developer descriptive flex column
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes

Query Text

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


SELECT MEDICAL_ASSESSMENT_ID
,      PERSON_ID
,      EXAMINER_NAME
,      ORGANIZATION_ID
,      NAME
,      CONSULTATION_DATE
,      CONSULTATION_TYPE
,      CONSULTATION_TYPE_DESC
,      INCIDENT_ID
,      INCIDENT_REFERENCE
,      INCIDENT_DATE
,      CONSULTATION_RESULT
,      CONSULTATION_RESULT_DESC
,      DISABILITY_ID
,      NEXT_CONSULTATION_DATE
,      DESCRIPTION
,      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
,      MEA_INFORMATION_CATEGORY
,      MEA_INFORMATION1
,      MEA_INFORMATION2
,      MEA_INFORMATION3
,      MEA_INFORMATION4
,      MEA_INFORMATION5
,      MEA_INFORMATION6
,      MEA_INFORMATION7
,      MEA_INFORMATION8
,      MEA_INFORMATION9
,      MEA_INFORMATION10
,      MEA_INFORMATION11
,      MEA_INFORMATION12
,      MEA_INFORMATION13
,      MEA_INFORMATION14
,      MEA_INFORMATION15
,      MEA_INFORMATION16
,      MEA_INFORMATION17
,      MEA_INFORMATION18
,      MEA_INFORMATION19
,      MEA_INFORMATION20
,      MEA_INFORMATION21
,      MEA_INFORMATION22
,      MEA_INFORMATION23
,      MEA_INFORMATION24
,      MEA_INFORMATION25
,      MEA_INFORMATION26
,      MEA_INFORMATION27
,      MEA_INFORMATION28
,      MEA_INFORMATION29
,      MEA_INFORMATION30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM APPS.PER_MEDICAL_ASSESSMENTS_V;

Dependencies

[top of page]

APPS.PER_MEDICAL_ASSESSMENTS_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_ALL_ORGANIZATION_UNITS_TL; HR_GENERAL - show dependent code; PER_MEDICAL_ASSESSMENTS; PER_WORK_INCIDENTS

APPS.PER_MEDICAL_ASSESSMENTS_V is referenced by following:

PUBLIC: PER_MEDICAL_ASSESSMENTS_V