DBA Data[Home] [Help] [Dependency Information]


TABLE: HR.PER_ELECTIONS

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


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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_ELECTIONS_PK
  1. ColumnELECTION_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_ELECTIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnELECTION_ID
PER_ELECTIONS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_ELECTIONS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREP_BODY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ELECTIONS PER_ELECTIONS_FK2 TableHR_ALL_ORGANIZATION_UNITS PER_ELECTIONS REP_BODY_ID
PER_ELECTIONS PER_ELECTIONS_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_ELECTIONS BUSINESS_GROUP_ID
TablePER_ELECTION_CANDIDATES PER_ELECTION_CANDIDATES_FK2 PER_ELECTIONS PER_ELECTION_CANDIDATES ELECTION_ID
TablePER_ELECTION_CONSTITUENCYS PER_ELECTION_CONSTITUENCYS_FK2 PER_ELECTIONS PER_ELECTION_CONSTITUENCYS ELECTION_ID
Columns
Name Datatype Length Mandatory Comments
ELECTION_ID NUMBER
Yes Election Id
BUSINESS_GROUP_ID NUMBER
Yes Business Group Id
ELECTION_DATE DATE
Yes Election Date
REP_BODY_ID NUMBER
Yes Rep Body Id
PREVIOUS_ELECTION_DATE DATE

Previous Election Date
NEXT_ELECTION_DATE DATE

Next Election Date
RESULT_PUBLISH_DATE DATE

Result Publish Date
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Attribute1
ATTRIBUTE2 VARCHAR2 (150)
Attribute2
ATTRIBUTE3 VARCHAR2 (150)
Attribute3
ATTRIBUTE4 VARCHAR2 (150)
Attribute4
ATTRIBUTE5 VARCHAR2 (150)
Attribute5
ATTRIBUTE6 VARCHAR2 (150)
Attribute6
ATTRIBUTE7 VARCHAR2 (150)
Attribute7
ATTRIBUTE8 VARCHAR2 (150)
Attribute8
ATTRIBUTE9 VARCHAR2 (150)
Attribute9
ATTRIBUTE10 VARCHAR2 (150)
Attribute10
ATTRIBUTE11 VARCHAR2 (150)
Attribute11
ATTRIBUTE12 VARCHAR2 (150)
Attribute12
ATTRIBUTE13 VARCHAR2 (150)
Attribute13
ATTRIBUTE14 VARCHAR2 (150)
Attribute14
ATTRIBUTE15 VARCHAR2 (150)
Attribute15
ATTRIBUTE16 VARCHAR2 (150)
Attribute16
ATTRIBUTE17 VARCHAR2 (150)
Attribute17
ATTRIBUTE18 VARCHAR2 (150)
Attribute18
ATTRIBUTE19 VARCHAR2 (150)
Attribute19
ATTRIBUTE20 VARCHAR2 (150)
Attribute20
ATTRIBUTE21 VARCHAR2 (150)
Attribute21
ATTRIBUTE22 VARCHAR2 (150)
Attribute22
ATTRIBUTE23 VARCHAR2 (150)
Attribute23
ATTRIBUTE24 VARCHAR2 (150)
Attribute24
ATTRIBUTE25 VARCHAR2 (150)
Attribute25
ATTRIBUTE26 VARCHAR2 (150)
Attribute26
ATTRIBUTE27 VARCHAR2 (150)
Attribute27
ATTRIBUTE28 VARCHAR2 (150)
Attribute28
ATTRIBUTE29 VARCHAR2 (150)
Attribute29
ATTRIBUTE30 VARCHAR2 (150)
Attribute30
ELECTION_INFORMATION_CATEGORY VARCHAR2 (30)
ELECTION_INFORMATION1 VARCHAR2 (30)
Election Information 1
ELECTION_INFORMATION2 VARCHAR2 (30)
Election Information 2
ELECTION_INFORMATION3 VARCHAR2 (30)
Election Information 3
ELECTION_INFORMATION4 VARCHAR2 (30)
Election Information 4
ELECTION_INFORMATION5 VARCHAR2 (30)
Election Information 5
ELECTION_INFORMATION6 VARCHAR2 (30)
Election Information 6
ELECTION_INFORMATION7 VARCHAR2 (30)
Election Information 7
ELECTION_INFORMATION8 VARCHAR2 (30)
Election Information 8
ELECTION_INFORMATION9 VARCHAR2 (30)
Election Information 9
ELECTION_INFORMATION10 VARCHAR2 (30)
Election Information 10
ELECTION_INFORMATION11 VARCHAR2 (30)
Election Information 11
ELECTION_INFORMATION12 VARCHAR2 (30)
Election Information 12
ELECTION_INFORMATION13 VARCHAR2 (30)
Election Information 13
ELECTION_INFORMATION14 VARCHAR2 (30)
Election Information 14
ELECTION_INFORMATION15 VARCHAR2 (30)
Election Information 15
ELECTION_INFORMATION16 VARCHAR2 (30)
Election Information 16
ELECTION_INFORMATION17 VARCHAR2 (30)
Election Information 17
ELECTION_INFORMATION18 VARCHAR2 (30)
Election Information 18
ELECTION_INFORMATION19 VARCHAR2 (30)
Election Information 19
ELECTION_INFORMATION20 VARCHAR2 (30)
Election Information 20
ELECTION_INFORMATION21 VARCHAR2 (30)
Election Information 21
ELECTION_INFORMATION22 VARCHAR2 (30)
Election Information 22
ELECTION_INFORMATION23 VARCHAR2 (30)
Election Information 23
ELECTION_INFORMATION24 VARCHAR2 (30)
Election Information 24
ELECTION_INFORMATION25 VARCHAR2 (30)
Election Information 25
ELECTION_INFORMATION26 VARCHAR2 (30)
Election Information 26
ELECTION_INFORMATION27 VARCHAR2 (30)
Election Information 27
ELECTION_INFORMATION28 VARCHAR2 (30)
Election Information 28
ELECTION_INFORMATION29 VARCHAR2 (30)
Election Information 29
ELECTION_INFORMATION30 VARCHAR2 (30)
Election Information 30
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATED_BY NUMBER

Lst Update By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
CREATED_BY NUMBER

Created By
CREATION_DATE DATE

Creation Date
OBJECT_VERSION_NUMBER NUMBER
Yes Object Version Number
DESCRIPTION VARCHAR2 (60)
Description
ELECTION_INFO_CATEGORY VARCHAR2 (30)
Election Info Category
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:

SchemaHR
ViewPER_ELECTIONS#