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]

TABLE: HR.PER_MEDICAL_ASSESSMENTS

Object Details

Object Name:	PER_MEDICAL_ASSESSMENTS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_MEDICAL_ASSESSMENTS
Subobject Name:
Status:	VALID

This table stores the detatils of any medical assessment a person may have.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_MEDICAL_ASSESSMENTS_PK

MEDICAL_ASSESSMENT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_MEDICAL_ASSESSMENTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	MEDICAL_ASSESSMENT_ID
PER_MEDICAL_ASSESSMENTS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID
PER_MEDICAL_ASSESSMENTS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
PER_MEDICAL_ASSESSMENTS_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCIDENT_ID
PER_MEDICAL_ASSESSMNETS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DISABILITY_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_MEDICAL_ASSESSMENTS		HR_ALL_ORGANIZATION_UNITS	PER_MEDICAL_ASSESSMENTS ORGANIZATION_ID
PER_MEDICAL_ASSESSMENTS		PER_WORK_INCIDENTS	PER_MEDICAL_ASSESSMENTS INCIDENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MEDICAL_ASSESSMENT_ID	NUMBER	(10)	Yes	Primary key. Generated from sequence PER_MEDICAL_ASSESSMENT_S
PERSON_ID	NUMBER	(10)	Yes	Foreign Key to Per_Person_F
EXAMINER_NAME	VARCHAR2	(240)		Medical Examiners Name
ORGANIZATION_ID	NUMBER	(15)		Foreign key to HR_ALL_ORGANIZATION_UNITS.
CONSULTATION_DATE	DATE		Yes	Date of medical consultation
CONSULTATION_TYPE	VARCHAR2	(30)	Yes	Type of medical assessment
CONSULTATION_RESULT	VARCHAR2	(30)		Result of medical assessment
DISABILITY_ID	NUMBER	(10)		Foreign Key to Per_Disabilities_F
INCIDENT_ID	NUMBER	(10)		Foreign Key to Per_Work_Incidents
NEXT_CONSULTATION_DATE	DATE			Date of next medical assessments
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			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.

Query Text

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


SELECT MEDICAL_ASSESSMENT_ID
,      PERSON_ID
,      EXAMINER_NAME
,      ORGANIZATION_ID
,      CONSULTATION_DATE
,      CONSULTATION_TYPE
,      CONSULTATION_RESULT
,      DISABILITY_ID
,      INCIDENT_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 HR.PER_MEDICAL_ASSESSMENTS;

Dependencies

[top of page]

HR.PER_MEDICAL_ASSESSMENTS does not reference any database object

HR.PER_MEDICAL_ASSESSMENTS is referenced by following:

HR: PER_MEDICAL_ASSESSMENTS#