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.HR_ORG_INFO_TYPES_BY_CLASS

Object Details

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

HR_ORG_INFO_TYPES_BY_CLASS is an intersection table between
HR_ORG_INFORMATION_TYPES and HR_ORGANIZATION_INFORMATION. This table
defines the information type structures that are available for each
organization classification. The rows in this table are predefined
and are not maintained by any forms.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HR_ORG_INFO_TYPES_BY_CLASS_PK

ORG_CLASSIFICATION
ORG_INFORMATION_TYPE

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_ORG_INFO_TYPES_BY_CLASS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORG_CLASSIFICATION ORG_INFORMATION_TYPE
HR_ORG_INFO_TYPES_BY_CLASS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_INFORMATION_TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_ORG_INFO_TYPES_BY_CLASS		HR_ORG_INFORMATION_TYPES	HR_ORG_INFO_TYPES_BY_CLASS ORG_INFORMATION_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_CLASSIFICATION	VARCHAR2	(40)	Yes	Classification type of an organization. For example, HR Organization, Business Group, etc.
ORG_INFORMATION_TYPE	VARCHAR2	(40)	Yes	Developer descriptive flexfield column.
MANDATORY_FLAG	VARCHAR2	(30)	Yes	An indication of whether a particular type of organization information is mandatory for a class.
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.
ENABLED_FLAG	VARCHAR2	(30)	Yes	Enabled Flag

Query Text

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


SELECT ORG_CLASSIFICATION
,      ORG_INFORMATION_TYPE
,      MANDATORY_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ENABLED_FLAG
FROM HR.HR_ORG_INFO_TYPES_BY_CLASS;

Dependencies

[top of page]

HR.HR_ORG_INFO_TYPES_BY_CLASS does not reference any database object

HR.HR_ORG_INFO_TYPES_BY_CLASS is referenced by following:

APPS: HR_ORG_INFO_TYPES_BY_CLASS; HR_ORG_INFO_TYPES_BY_CLASS_WHO
PUBLIC: HR_ORG_INFO_TYPES_BY_CLASS