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

TABLE: HR.PER_ELECTION_CONSTITUENCYS

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


This table holds information related to the consituencies participating in the election. These constituencies should be within the Representative Body.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_ELECTION_CONSTITUENCYS_PK
  1. ColumnELECTION_CONSTITUENCY_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_ELECTION_CONSTITUENCYS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnELECTION_CONSTITUENCY_ID
PER_ELECTION_CONSTITUENCYS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_ELECTION_CONSTITUENCYS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnELECTION_ID
PER_ELECTION_CONSTITUENCYS_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONSTITUENCY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ELECTION_CONSTITUENCYS PER_ELECTION_CONSTITUENCYS_FK3 TableHR_ALL_ORGANIZATION_UNITS PER_ELECTION_CONSTITUENCYS CONSTITUENCY_ID
PER_ELECTION_CONSTITUENCYS PER_ELECTION_CONSTITUENCYS_FK2 TablePER_ELECTIONS PER_ELECTION_CONSTITUENCYS ELECTION_ID
Columns
Name Datatype Length Mandatory Comments
ELECTION_CONSTITUENCY_ID NUMBER
Yes Election Constituency ID
ELECTION_ID NUMBER
Yes Election ID
BUSINESS_GROUP_ID NUMBER
Yes Business Group ID
CONSTITUENCY_ID NUMBER
Yes Constituency ID
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Attribute 15
ATTRIBUTE16 VARCHAR2 (150)
Attribute 16
ATTRIBUTE17 VARCHAR2 (150)
Attribute 17
ATTRIBUTE18 VARCHAR2 (150)
Attribute 18
ATTRIBUTE19 VARCHAR2 (150)
Attribute 19
ATTRIBUTE20 VARCHAR2 (150)
Attribute 20
ATTRIBUTE21 VARCHAR2 (150)
Attribute 21
ATTRIBUTE22 VARCHAR2 (150)
Attribute 22
ATTRIBUTE23 VARCHAR2 (150)
Attribute 23
ATTRIBUTE24 VARCHAR2 (150)
Attribute 24
ATTRIBUTE25 VARCHAR2 (150)
Attribute 25
ATTRIBUTE26 VARCHAR2 (150)
Attribute 26
ATTRIBUTE27 VARCHAR2 (150)
Attribute 27
ATTRIBUTE28 VARCHAR2 (150)
Attribute 28
ATTRIBUTE29 VARCHAR2 (150)
Attribute 29
ATTRIBUTE30 VARCHAR2 (150)
Attribute 30
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATED_BY NUMBER

Last 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
Query Text

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


SELECT ELECTION_CONSTITUENCY_ID
,      ELECTION_ID
,      BUSINESS_GROUP_ID
,      CONSTITUENCY_ID
,      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
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM HR.PER_ELECTION_CONSTITUENCYS;

Dependencies

[top of page]

HR.PER_ELECTION_CONSTITUENCYS does not reference any database object

HR.PER_ELECTION_CONSTITUENCYS is referenced by following:

SchemaHR
ViewPER_ELECTION_CONSTITUENCYS#