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

Object Details

Object Name:	PQH_CORPS_DEFINITIONS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQH.PQH_CORPS_DEFINITIONS
Subobject Name:
Status:	VALID

Corp Definition

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_CORPS_DEFINITIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CORPS_DEFINITION_ID
PQH_CORPS_DEFINITIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NAME
PQH_CORPS_DEFINITIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BEN_PGM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CORPS_DEFINITION_ID	NUMBER	(15)	Yes	Primary Key
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business Group Identifier
NAME	VARCHAR2	(240)	Yes	Corp Name
STATUS_CD	VARCHAR2	(30)	Yes	status Code
RETIREMENT_AGE	NUMBER	(10)		Retirement Age
CATEGORY_CD	VARCHAR2	(30)	Yes	Category Code
EFFECTIVE_START_DATE	DATE			Obsoleted column.
EFFECTIVE_END_DATE	DATE			Obsoleted column.
RECRUITMENT_END_DATE	DATE			Recruitment End Date
CORPS_TYPE_CD	VARCHAR2	(30)		Corp Type Code
STARTING_GRADE_STEP_ID	NUMBER	(15)		Starting Grade Step Identifier
NATURE_TYPE_CD	VARCHAR2	(30)		Obsoleted column.
TASK_DESC	VARCHAR2	(2000)		Task Description
SECONDMENT_THRESHOLD	NUMBER	(5)		Secondary Threshhold
NORMAL_HOURS	NUMBER	(15)		Normal Hours
NORMAL_HOURS_FREQUENCY	VARCHAR2	(30)		Normal Hour's Frequency
MINIMUM_HOURS	NUMBER	(15)		Minimum Hours
MINIMUM_HOURS_FREQUENCY	VARCHAR2	(30)		Minimum Hour's frequency
INFORMATION_TYPE	VARCHAR2	(30)		Obsoleted column.
INFORMATION1	VARCHAR2	(150)		Obsoleted column.
INFORMATION2	VARCHAR2	(150)		Obsoleted column.
INFORMATION3	VARCHAR2	(150)		Obsoleted column.
INFORMATION4	VARCHAR2	(150)		Obsoleted column.
INFORMATION5	VARCHAR2	(150)		Obsoleted column.
INFORMATION6	VARCHAR2	(150)		Obsoleted column.
INFORMATION7	VARCHAR2	(150)		Obsoleted column.
INFORMATION8	VARCHAR2	(150)		Obsoleted column.
INFORMATION9	VARCHAR2	(150)		Obsoleted column.
INFORMATION10	VARCHAR2	(150)		Obsoleted column.
INFORMATION11	VARCHAR2	(150)		Obsoleted column.
INFORMATION12	VARCHAR2	(150)		Obsoleted column.
INFORMATION13	VARCHAR2	(150)		Obsoleted column.
INFORMATION14	VARCHAR2	(150)		Obsoleted column.
INFORMATION15	VARCHAR2	(150)		Obsoleted column.
INFORMATION16	VARCHAR2	(150)		Obsoleted column.
INFORMATION17	VARCHAR2	(150)		Obsoleted column.
INFORMATION18	VARCHAR2	(150)		Obsoleted column.
INFORMATION19	VARCHAR2	(150)		Obsoleted column.
INFORMATION20	VARCHAR2	(150)		Obsoleted column.
INFORMATION21	VARCHAR2	(150)		Obsoleted column.
INFORMATION22	VARCHAR2	(150)		Obsoleted column.
INFORMATION23	VARCHAR2	(150)		Obsoleted column.
INFORMATION24	VARCHAR2	(150)		Obsoleted column.
INFORMATION25	VARCHAR2	(150)		Obsoleted column.
INFORMATION26	VARCHAR2	(150)		Obsoleted column.
INFORMATION27	VARCHAR2	(150)		Obsoleted column.
INFORMATION28	VARCHAR2	(150)		Obsoleted column.
INFORMATION29	VARCHAR2	(150)		Obsoleted column.
INFORMATION30	VARCHAR2	(150)		Obsoleted column.
INFORMATION_CATEGORY	VARCHAR2	(30)		Obsoleted column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE26	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE27	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE28	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE29	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE30	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	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
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number
DATE_FROM	DATE		Yes	Start Date
DATE_TO	DATE			End Date
TYPE_OF_PS	VARCHAR2	(30)		Type of Public Sector Organization
PRIMARY_PROF_FIELD_ID	NUMBER	(15)		Primary Professional Field shared type identifier
STARTING_GRADE_ID	NUMBER			Starting Grade Identifier
BEN_PGM_ID	NUMBER	(15)		Benefits : Program Identifier
PROBATION_PERIOD	NUMBER	(15)		Probation Period
PROBATION_UNITS	VARCHAR2	(30)		Probation Period Units

Query Text

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


SELECT CORPS_DEFINITION_ID
,      BUSINESS_GROUP_ID
,      NAME
,      STATUS_CD
,      RETIREMENT_AGE
,      CATEGORY_CD
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      RECRUITMENT_END_DATE
,      CORPS_TYPE_CD
,      STARTING_GRADE_STEP_ID
,      NATURE_TYPE_CD
,      TASK_DESC
,      SECONDMENT_THRESHOLD
,      NORMAL_HOURS
,      NORMAL_HOURS_FREQUENCY
,      MINIMUM_HOURS
,      MINIMUM_HOURS_FREQUENCY
,      INFORMATION_TYPE
,      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
,      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
,      ATTRIBUTE_CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      DATE_FROM
,      DATE_TO
,      TYPE_OF_PS
,      PRIMARY_PROF_FIELD_ID
,      STARTING_GRADE_ID
,      BEN_PGM_ID
,      PROBATION_PERIOD
,      PROBATION_UNITS
FROM HR.PQH_CORPS_DEFINITIONS;

Dependencies

[top of page]

HR.PQH_CORPS_DEFINITIONS does not reference any database object

HR.PQH_CORPS_DEFINITIONS is referenced by following:

HR: PQH_CORPS_DEFINITIONS#