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_MAND_MULTI_ENR_REQ_MEMBERS

Object Details

Object Name:	OTA_MAND_MULTI_ENR_REQ_MEMBERS
Object Type:	TABLE
Owner:	OTA
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_MAND_MULTI_ENR_REQ_MEM_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MANDATORY_ENR_REQUEST_ID	NUMBER	(15)	Yes	Mandatory Enrollment Request Id is used to uniquely idenftify the members records to be processed for a particular request.
PERSON_ID	NUMBER	(15)	Yes	Persond Id for which the mandatory enrollment need to be created.
ASSIGNMENT_ID	NUMBER	(10)	Yes	Assignment Id of the person for whom mandatory enrollment need to be created.
ERROR_MESSAGE	VARCHAR2	(500)		Error message contains errors raised while creating mandatory enrollment for a person.
COMPLETED_COURSE_PREREQ	VARCHAR2	(1)		Completed Course Prereq tells whether the learner has completed the required course prerequisites.
COMPLETED_COMPETENCE_PREREQ	VARCHAR2	(1)		Completed Competene Prereq tells whether the learner has all the required competencies.
CREATE_ENROLLMENT	VARCHAR2	(1)		Create Enrollment specifies whether to create mandatory enrollment for a particular person or not.
EVENT_ID	NUMBER	(15)		Event Id specifies the class in which a person need to be enrolled mandatorily.
MBR_BG_ID	NUMBER	(15)	Yes	Business Group Id of the person being mandatorily enrolled in to a class.
ORGANIZATION_ID	NUMBER	(9)		Organization id of the person's assignment who is mandatorily enrolled in to a class.
CERTIFICATION_ID	NUMBER	(15)		Certification Id in which the person being processed need to be subscribed automatically.
PERSON_ACTION_ID	NUMBER	(15)		Person Action Id is used to uniquely identify a member record in a range to be 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 MANDATORY_ENR_REQUEST_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      ERROR_MESSAGE
,      COMPLETED_COURSE_PREREQ
,      COMPLETED_COMPETENCE_PREREQ
,      CREATE_ENROLLMENT
,      EVENT_ID
,      MBR_BG_ID
,      ORGANIZATION_ID
,      CERTIFICATION_ID
,      PERSON_ACTION_ID
,      ACTION_STATUS_CD
FROM OTA.OTA_MAND_MULTI_ENR_REQ_MEMBERS;

Dependencies

[top of page]

OTA.OTA_MAND_MULTI_ENR_REQ_MEMBERS does not reference any database object

OTA.OTA_MAND_MULTI_ENR_REQ_MEMBERS is referenced by following:

OTA: OTA_MAND_MULTI_ENR_REQ_MEMBER#