[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_ATD_MODE |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_EN_ATD_MODE |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
This view incorporates various university defined attendance modes like Internal, External and Multimodal. These modes are used for enrolment process.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ATTENDANCE_MODE | VARCHAR2 | (2) | Yes | The code of an institution-defined attendance mode. An attendance mode identifies the mode of attendance in which a student undertakes a course. Each attendance mode must be mapped to a government attendance type -DETYA element 329 . Examples are N -On Campus , F -Off Campus and M -Multi-modal. |
DESCRIPTION | VARCHAR2 | (60) | Yes | The description of an institution-defined attendance mode.An attendance mode identifies the mode of attendance in which a student undertakes a course. Each attendance mode must be mapped to a government attendance type- DETYA element 329 . Examples are ONCAMPUS, OFF CAMPUS and MULTI-MODAL. |
GOVT_ATTENDANCE_MODE | VARCHAR2 | (1) | Yes | The code of a government attendance mode DETYA element 329.An attendance mode identifies the mode of attendance by which a student undertakes a course. Examples are 1 - INTERNAL MODE OFATTENDANCE, 2 - EXTERNAL MODE OF ATTENDANCE. |
CLOSED_IND | VARCHAR2 | (1) | Yes | An indicator which specifies if the attendance mode is open orclosed. Setting the checkbox to 'closed' ticked prevents use of the attendance mode in new course offering option records. |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ORG_ID | NUMBER | (15) | Operating Unit Identifier. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ATTENDANCE_MODE
, DESCRIPTION
, GOVT_ATTENDANCE_MODE
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM APPS.IGS_EN_ATD_MODE;
|
|
|