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_ESTABLISHMENTS

Object Details

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

This entity is used to maintain a list of educational establishments
e.g. schools, colleges, universities, etc.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_ESTABLISHMENTS_PK

ESTABLISHMENT_ID

Unique Key: PER_ESTABLISHMENTS_UK

NAME
LOCATION

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_ESTABLISHMENTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ESTABLISHMENT_ID
PER_ESTABLISHMENTS_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME LOCATION

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_ESTABLISHMENT_ATTENDANCES		PER_ESTABLISHMENTS	PER_ESTABLISHMENT_ATTENDANCES ESTABLISHMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ESTABLISHMENT_ID	NUMBER	(9)	Yes	PK of entity
NAME	VARCHAR2	(160)	Yes	Maintains the name of an educational establishment
LOCATION	VARCHAR2	(240)	Yes	Holds the location details of an establishment
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.
PARTY_ID	NUMBER	(15)		Foriegn key to hz_parties.
EST_INFORMATION_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield structure defining column.
EST_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
EST_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.

Query Text

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


SELECT ESTABLISHMENT_ID
,      NAME
,      LOCATION
,      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
,      PARTY_ID
,      EST_INFORMATION_CATEGORY
,      EST_INFORMATION1
,      EST_INFORMATION2
,      EST_INFORMATION3
,      EST_INFORMATION4
,      EST_INFORMATION5
,      EST_INFORMATION6
,      EST_INFORMATION7
,      EST_INFORMATION8
,      EST_INFORMATION9
,      EST_INFORMATION10
,      EST_INFORMATION11
,      EST_INFORMATION12
,      EST_INFORMATION13
,      EST_INFORMATION14
,      EST_INFORMATION15
,      EST_INFORMATION16
,      EST_INFORMATION17
,      EST_INFORMATION18
,      EST_INFORMATION19
,      EST_INFORMATION20
FROM HR.PER_ESTABLISHMENTS;

Dependencies

[top of page]

HR.PER_ESTABLISHMENTS does not reference any database object

HR.PER_ESTABLISHMENTS is referenced by following:

APPS: PER_ESTABLISHMENTS; PER_ESTABLISHMENTS_WHO
PUBLIC: PER_ESTABLISHMENTS