[Home] [Help] [Dependency Information]
Object Name: | OTA_MAND_MULTI_ENR_REQ_MEMBER# |
---|---|
Object Type: | VIEW |
Owner: | OTA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MANDATORY_ENR_REQUEST_ID | NUMBER | (15) | Yes | |
PERSON_ID | NUMBER | (15) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
ERROR_MESSAGE | VARCHAR2 | (500) | ||
COMPLETED_COURSE_PREREQ | VARCHAR2 | (1) | ||
COMPLETED_COMPETENCE_PREREQ | VARCHAR2 | (1) | ||
CREATE_ENROLLMENT | VARCHAR2 | (1) | ||
EVENT_ID | NUMBER | (15) | ||
MBR_BG_ID | NUMBER | (15) | Yes | |
ORGANIZATION_ID | NUMBER | (9) | ||
CERTIFICATION_ID | NUMBER | (15) | ||
PERSON_ACTION_ID | NUMBER | (15) | ||
ACTION_STATUS_CD | VARCHAR2 | (30) |
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_MEMBER#;
|
|
|