DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.IGS_EN_ATD_MODE

Object Details
Object Name: IGS_EN_ATD_MODE
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_EN_ATD_MODE
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.IGS_EN_ATD_MODE references the following:

SchemaAPPS
SynonymIGS_EN_ATD_MODE_ALL
APPS.IGS_EN_ATD_MODE is referenced by following:

SchemaAPPS
ViewIGF_AP_IA_LOOKUP_V
Package BodyIGF_AW_ANTICIPATED_DATA - show dependent code
Package BodyIGS_AD_GEN_002 - show dependent code
Package BodyIGS_AD_GEN_010 - show dependent code
Package BodyIGS_AD_VAL_APCOO - show dependent code
Package BodyIGS_AD_WF_P2A - show dependent code
Package BodyIGS_EN_ELGBL_PROGRAM - show dependent code
Package BodyIGS_EN_GEN_009 - show dependent code
Package BodyIGS_EN_GEN_010 - show dependent code
Package BodyIGS_EN_SPA_TERMS_API - show dependent code
Package BodyIGS_EN_VAL_SUA - show dependent code
ViewIGS_FI_FEE_AS_RATE_V
Package BodyIGS_FI_VAL_CFAR - show dependent code
Package BodyIGS_FI_VAL_FAR - show dependent code
Package BodyIGS_GE_VAL_PARAM - show dependent code
Package BodyIGS_PRECREATE_APPL_PUB - show dependent code
Package BodyIGS_PS_VAL_AM - show dependent code
Package BodyIGS_PS_VAL_COO - show dependent code
Package BodyIGS_PS_VAL_GAM - show dependent code
Package BodyIGS_ST_GEN_001 - show dependent code
Package BodyIGS_ST_GEN_004 - show dependent code