[Home] [Help] [Dependency Information]

TABLE: HR.PER_ELECTIONS

Object Details

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

This table stores election related information, Representative Body for which election is being held.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_ELECTIONS_PK

1. ELECTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_ELECTIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ELECTION_ID
PER_ELECTIONS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REP_BODY_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_ELECTIONS		HR_ALL_ORGANIZATION_UNITS	PER_ELECTIONS REP_BODY_ID
PER_ELECTIONS		HR_ALL_ORGANIZATION_UNITS	PER_ELECTIONS BUSINESS_GROUP_ID
PER_ELECTION_CANDIDATES		PER_ELECTIONS	PER_ELECTION_CANDIDATES ELECTION_ID
PER_ELECTION_CONSTITUENCYS		PER_ELECTIONS	PER_ELECTION_CONSTITUENCYS ELECTION_ID

Columns

Query Text

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

SELECT ELECTION_ID
,      BUSINESS_GROUP_ID
,      ELECTION_DATE
,      REP_BODY_ID
,      PREVIOUS_ELECTION_DATE
,      NEXT_ELECTION_DATE
,      RESULT_PUBLISH_DATE
,      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
,      ELECTION_INFORMATION_CATEGORY
,      ELECTION_INFORMATION1
,      ELECTION_INFORMATION2
,      ELECTION_INFORMATION3
,      ELECTION_INFORMATION4
,      ELECTION_INFORMATION5
,      ELECTION_INFORMATION6
,      ELECTION_INFORMATION7
,      ELECTION_INFORMATION8
,      ELECTION_INFORMATION9
,      ELECTION_INFORMATION10
,      ELECTION_INFORMATION11
,      ELECTION_INFORMATION12
,      ELECTION_INFORMATION13
,      ELECTION_INFORMATION14
,      ELECTION_INFORMATION15
,      ELECTION_INFORMATION16
,      ELECTION_INFORMATION17
,      ELECTION_INFORMATION18
,      ELECTION_INFORMATION19
,      ELECTION_INFORMATION20
,      ELECTION_INFORMATION21
,      ELECTION_INFORMATION22
,      ELECTION_INFORMATION23
,      ELECTION_INFORMATION24
,      ELECTION_INFORMATION25
,      ELECTION_INFORMATION26
,      ELECTION_INFORMATION27
,      ELECTION_INFORMATION28
,      ELECTION_INFORMATION29
,      ELECTION_INFORMATION30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      DESCRIPTION
,      ELECTION_INFO_CATEGORY
FROM HR.PER_ELECTIONS;

Dependencies

[top of page]

HR.PER_ELECTIONS does not reference any database object

HR.PER_ELECTIONS is referenced by following:

APPS

PER_ELECTIONS

PER_ELECTIONS_WHO

PUBLIC

PER_ELECTIONS