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_QUALIFICATIONS_TL

Object Details

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

PER_QUALIFICATIONS_TL holds the translated 'group_ranking', 'license_restrictions', 'awarding_body', 'grade_attained', 'professional_body_name', 'reimbursement_arrangements', 'training_completed_units' and 'membership_units' columns for the PER_QUALIFICATIONS' table. The rows are indexed by a primary key obtained by the combination of 'qualification_id' and 'language'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_QUALIFICATIONS_TL_PK

QUALIFICATION_ID
LANGUAGE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_QUALIFICATIONS_TL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUALIFICATION_ID LANGUAGE
PER_QUALIFICATIONS_TL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANGUAGE TITLE

Columns

Name	Datatype	Length	Mandatory	Comments
QUALIFICATION_ID	NUMBER	(15)	Yes	Foreign key to PER_QUALIFICATIONS
LANGUAGE	VARCHAR2	(4)	Yes	Defined language
SOURCE_LANG	VARCHAR2	(4)	Yes	Actual language
TITLE	VARCHAR2	(120)		Translated TITLE from PER_QUALIFICATIONS
GROUP_RANKING	VARCHAR2	(100)		Translated group_ranking
LICENSE_RESTRICTIONS	VARCHAR2	(255)		Translated license_restrictions
AWARDING_BODY	VARCHAR2	(100)		Translated awarding_body
GRADE_ATTAINED	VARCHAR2	(100)		Translated grade_attained
REIMBURSEMENT_ARRANGEMENTS	VARCHAR2	(2000)		Translated reimbursement_arrangements
TRAINING_COMPLETED_UNITS	VARCHAR2	(100)		Translated training_completed_units
MEMBERSHIP_CATEGORY	VARCHAR2	(80)		Translated membership_category
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT QUALIFICATION_ID
,      LANGUAGE
,      SOURCE_LANG
,      TITLE
,      GROUP_RANKING
,      LICENSE_RESTRICTIONS
,      AWARDING_BODY
,      GRADE_ATTAINED
,      REIMBURSEMENT_ARRANGEMENTS
,      TRAINING_COMPLETED_UNITS
,      MEMBERSHIP_CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.PER_QUALIFICATIONS_TL;

Dependencies

[top of page]

HR.PER_QUALIFICATIONS_TL does not reference any database object

HR.PER_QUALIFICATIONS_TL is referenced by following:

HR: PER_QUALIFICATIONS_TL#