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: OTA.OTA_NOTRNG_HISTORIES

Object Details

Object Name:	OTA_NOTRNG_HISTORIES
Object Type:	TABLE
Owner:	OTA
FND Design Data:	OTA.OTA_NOTRNG_HISTORIES
Subobject Name:
Status:	VALID

Records attendance data for external training events initiated outside of OTA.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_NOTRNG_HISTORIES_PK

NOTA_HISTORY_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_NOTRNG_HISTORIES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	NOTA_HISTORY_ID
OTA_NOTRNG_HISTORIES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTACT_ID
OTA_NOTRNG_HISTORIES_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_VERSION_ID
OTA_NOTRNG_HISTORIES_N0	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID
OTA_NOTRNG_HISTORIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
OTA_NOTRNG_HISTORIES		OTA_ACTIVITY_VERSIONS	OTA_NOTRNG_HISTORIES ACTIVITY_VERSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
NOTA_HISTORY_ID	NUMBER	(38)	Yes	Primary key for history records
PERSON_ID	NUMBER	(10)	Yes	The ID of the person associated with the training
CONTACT_ID	NUMBER	(9)		The ID of the contact person associated with the history
TRNG_TITLE	VARCHAR2	(80)	Yes	The title/name of the training
PROVIDER	VARCHAR2	(80)	Yes	The name of the training provider
TYPE	VARCHAR2	(30)		The type of training (ILT, MEDIA, OJT, Experience)
CENTRE	VARCHAR2	(80)		The name of the site were training was taken
COMPLETION_DATE	DATE		Yes	The date associated with the training
AWARD	VARCHAR2	(80)		The distinction or award granted
RATING	VARCHAR2	(30)		The scholastic rating achieved
DURATION	NUMBER			The number of duration units
DURATION_UNITS	VARCHAR2	(30)		The duration units
ACTIVITY_VERSION_ID	NUMBER	(9)		The name of an equivalent OTA Course
STATUS	VARCHAR2	(30)		The current status of the training
VERIFIED_BY_ID	NUMBER	(15)		The ID of the verifier of the training
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
NTH_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
NTH_INFORMATION1	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION2	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION3	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION4	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION5	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION6	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION7	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION8	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION9	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION10	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION11	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION12	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION13	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION14	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION15	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION16	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION17	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION18	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION19	VARCHAR2	(150)		Descriptive flexfield segment column
NTH_INFORMATION20	VARCHAR2	(150)		Descriptive flexfield segment column
ORG_ID	NUMBER	(15)		This column is meant to be utilized for ORG_ID compliance
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes	Version control parameter
BUSINESS_GROUP_ID	NUMBER	(9)	Yes	Foreign Key to HR_ALL_ORGANIZATION_UNITS
CUSTOMER_ID	NUMBER			Foreign Key to RA_CUSTOMERS
ORGANIZATION_ID	NUMBER	(15)		Foreign Key to HR_ALL_ORGANIZATION_UNITS

Query Text

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


SELECT NOTA_HISTORY_ID
,      PERSON_ID
,      CONTACT_ID
,      TRNG_TITLE
,      PROVIDER
,      TYPE
,      CENTRE
,      COMPLETION_DATE
,      AWARD
,      RATING
,      DURATION
,      DURATION_UNITS
,      ACTIVITY_VERSION_ID
,      STATUS
,      VERIFIED_BY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      NTH_INFORMATION_CATEGORY
,      NTH_INFORMATION1
,      NTH_INFORMATION2
,      NTH_INFORMATION3
,      NTH_INFORMATION4
,      NTH_INFORMATION5
,      NTH_INFORMATION6
,      NTH_INFORMATION7
,      NTH_INFORMATION8
,      NTH_INFORMATION9
,      NTH_INFORMATION10
,      NTH_INFORMATION11
,      NTH_INFORMATION12
,      NTH_INFORMATION13
,      NTH_INFORMATION14
,      NTH_INFORMATION15
,      NTH_INFORMATION16
,      NTH_INFORMATION17
,      NTH_INFORMATION18
,      NTH_INFORMATION19
,      NTH_INFORMATION20
,      ORG_ID
,      OBJECT_VERSION_NUMBER
,      BUSINESS_GROUP_ID
,      CUSTOMER_ID
,      ORGANIZATION_ID
FROM OTA.OTA_NOTRNG_HISTORIES;

Dependencies

[top of page]

OTA.OTA_NOTRNG_HISTORIES does not reference any database object

OTA.OTA_NOTRNG_HISTORIES is referenced by following:

APPS: OTA_NOTRNG_HISTORIES; OTA_NOTRNG_HISTORIES_WHO