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


TABLE: HR.PER_SPECIAL_INFO_TYPES

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


This table holds the definitions of extra information types that may
that are available to each Business Group. Each special information
type is a user defined structure for the personal analysis key
flexfield. The name of the special information type is the same as
the name of the corresponding key flexfield structure.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_SPECIAL_INFO_TYPES_PK
  1. ColumnSPECIAL_INFORMATION_TYPE_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_SPECIAL_INFO_TYPES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSPECIAL_INFORMATION_TYPE_ID
PER_SPECIAL_INFO_TYPES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_SPECIAL_INFO_TYPES PER_SPECIAL_INFO_TYPES_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_SPECIAL_INFO_TYPES BUSINESS_GROUP_ID
TablePER_SPECIAL_INFO_TYPE_USAGES PER_SPECIAL_INFO_TYPE_USAG_FK1 PER_SPECIAL_INFO_TYPES PER_SPECIAL_INFO_TYPE_USAGES SPECIAL_INFORMATION_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
SPECIAL_INFORMATION_TYPE_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
ID_FLEX_NUM NUMBER
Yes Key flexfield structure foreign key.
ENABLED_FLAG VARCHAR2 (30)
Indicates if a special information type is enabled for the Business Group.
REQUEST_ID NUMBER (15)
Standard Who Column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column.
PROGRAM_ID NUMBER (15)
Standard Who Column.
PROGRAM_UPDATE_DATE DATE

Standard Who column.
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.
MULTIPLE_OCCURRENCES_FLAG VARCHAR2 (30)
If null, treat as Y.
COMMENTS LONG (0)
General remark.
Query Text

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


SELECT SPECIAL_INFORMATION_TYPE_ID
,      BUSINESS_GROUP_ID
,      ID_FLEX_NUM
,      ENABLED_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
,      MULTIPLE_OCCURRENCES_FLAG
,      COMMENTS
FROM HR.PER_SPECIAL_INFO_TYPES;

Dependencies

[top of page]

HR.PER_SPECIAL_INFO_TYPES does not reference any database object

HR.PER_SPECIAL_INFO_TYPES is referenced by following:

SchemaAPPS
SynonymPER_SPECIAL_INFO_TYPES
TriggerPER_SPECIAL_INFO_TYPES_WHO
SchemaPUBLIC
SynonymPER_SPECIAL_INFO_TYPES