[Home] [Help] [Dependency Information]
Object Name: | OTA_MAND_MULTI_ENR_REQ_MEMBERS |
---|---|
Object Type: | TABLE |
Owner: | OTA |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_MAND_MULTI_ENR_REQ_MEM_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PERSON_ACTION_ID |
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. |
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;
OTA.OTA_MAND_MULTI_ENR_REQ_MEMBERS does not reference any database object
OTA.OTA_MAND_MULTI_ENR_REQ_MEMBERS is referenced by following:
|
|
|