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_BULK_ENR_REQ_MEMBERS

Object Details

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

Bulk Enrollment request member hold the data of the leaner whom is requested to be enrolled into Class, Learning Path or Learning Certification via Bulk Enrollment.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_BULK_ENR_REQ_MEMBERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ACTION_ID
OTA_BULK_ENR_REQ_MEMBERS_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BULK_ENR_REQUEST_ID PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BULK_ENR_REQUEST_ID	NUMBER	(15)	Yes	Foreign key to OTA_BULK_ENR_REQUESTS
PERSON_ID	NUMBER	(10)	Yes	Foreign key to PER_ALL_PEOPLE_F
ASSIGNMENT_ID	NUMBER	(10)	Yes	Foreign key to PER_ALL_ASSIGNMENTS_F
ENROLLMENT_STATUS	VARCHAR2	(30)		Status of the enrollment
ERROR_MESSAGE	VARCHAR2	(500)		Error message while enrolling the person
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
BOOKING_ID	NUMBER
MBR_BG_ID	NUMBER	(15)		Business Group Id of a person's assignment.
PERSON_ACTION_ID	NUMBER	(15)		Person Action Id is used to uniquely identify a member in a range being processed.
ACTION_STATUS_CD	VARCHAR2	(30)		Action Status Cd specifies the processing status of the member record.

Query Text

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


SELECT BULK_ENR_REQUEST_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      ENROLLMENT_STATUS
,      ERROR_MESSAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      BOOKING_ID
,      MBR_BG_ID
,      PERSON_ACTION_ID
,      ACTION_STATUS_CD
FROM OTA.OTA_BULK_ENR_REQ_MEMBERS;

Dependencies

[top of page]

OTA.OTA_BULK_ENR_REQ_MEMBERS does not reference any database object

OTA.OTA_BULK_ENR_REQ_MEMBERS is referenced by following:

OTA: OTA_BULK_ENR_REQ_MEMBERS#