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_QUALIFICATION_TYPES

Object Details

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

Maintains the list of qualiification types that can be attained.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_QUALIFICATION_TYPES_PK

QUALIFICATION_TYPE_ID
ZD_EDITION_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_QUALIFICATION_TYPES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUALIFICATION_TYPE_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
QUALIFICATION_TYPE_ID	NUMBER	(9)	Yes	PK of entity
NAME	VARCHAR2	(150)	Yes	Holds name of qualification type.
CATEGORY	VARCHAR2	(30)	Yes	A grouping or categorization of the qualification type.
RANK	NUMBER	(9)		Holds the rank of the qualification
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield 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.
INFORMATION1	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION2	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION3	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION4	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION5	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION6	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION7	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION8	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION9	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION10	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION11	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION12	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION13	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION14	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION15	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION16	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION17	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION18	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION19	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION20	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION21	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION22	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION23	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION24	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION25	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION26	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION27	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION28	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION29	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION30	VARCHAR2	(150)		Developer Descriptive Flexfield
INFORMATION_CATEGORY	VARCHAR2	(30)		Developer Descriptive Flexfield
QUAL_FRAMEWORK_ID	NUMBER	(10)		Unit Standard Framework Qualification Id
QUALIFICATION_TYPE	VARCHAR2	(100)		Unit Standard Framework Qualification Type
CREDIT_TYPE	VARCHAR2	(100)		Unit Standard Framework Credit Type
CREDITS	NUMBER	(10)		Unist Standard Framework Credits
LEVEL_TYPE	VARCHAR2	(40)		Unit Standard Framework Level Type
LEVEL_NUMBER	NUMBER	(10)		Unit Standard Framework Level
FIELD	VARCHAR2	(100)		Unit Standard Framework Field
SUB_FIELD	VARCHAR2	(100)		Unit Standard Framework Sub Field
PROVIDER	VARCHAR2	(150)		Unit Standard Framework Provider
QA_ORGANIZATION	VARCHAR2	(150)		Unit Standard Framework QA Organization
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT QUALIFICATION_TYPE_ID
,      NAME
,      CATEGORY
,      RANK
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
,      INFORMATION_CATEGORY
,      QUAL_FRAMEWORK_ID
,      QUALIFICATION_TYPE
,      CREDIT_TYPE
,      CREDITS
,      LEVEL_TYPE
,      LEVEL_NUMBER
,      FIELD
,      SUB_FIELD
,      PROVIDER
,      QA_ORGANIZATION
,      ZD_EDITION_NAME
FROM HR.PER_QUALIFICATION_TYPES;

Dependencies

[top of page]

HR.PER_QUALIFICATION_TYPES does not reference any database object

HR.PER_QUALIFICATION_TYPES is referenced by following:

HR: PER_QUALIFICATION_TYPES#