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

VIEW: APPS.IGF_AP_AWYR_ATMAP_V

Object Details
Object Name: IGF_AP_AWYR_ATMAP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_AP_AWYR_ATMAP_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CAL_TYPE VARCHAR2 (10) Yes
SEQUENCE_NUMBER NUMBER (15) Yes
ATTENDANCE_TYPE VARCHAR2 (2) Yes The code of an institution-defined attendance type. An attendance type identifies whether a student is classified as part-time or full-time in the course, based on their study load in the reference year. Each attendance type must be mapped to a government attendance type DETYA element 330.
DESCRIPTION VARCHAR2 (60) Yes The description of an institution-defined attendance type. An attendance type identifies whether a student is classified as part-time or full-time in the course, based on their study load in the reference year. Each attendance type must be mapped to a government attendance type DETYA element 330.
GOVT_ATTENDANCE_TYPE VARCHAR2 (30) Yes The code of a government attendance type DETYA element 330 .An attendance type identifies whether a student is classified as part-time or full-time in the course, based on their study load in the reference year.
LOWER_ENR_LOAD_RANGE NUMBER (7) Yes The lower end of the enrolment load range in EFTSU which defines the attendance type. The range specified by the lower and upper load values is used by the system to derive the student course attendance type in an academic period. For example, a lower range value of 0.001 EFTSU and an upper range value of 0.749 EFTSU may define the PART-TIME attendance type in a standard academic year.
UPPER_ENR_LOAD_RANGE NUMBER (7) Yes The upper end of the enrolment load range in EFTSU which defines the attendance type. The range specified by the lower andupper load values is used by the system to derive the student course attendance type in an academic period. For example, a lower rangevalue of 0.750 EFTSU and an upper range value of 99.000 EFTSU maydefine the FULL-TIME attendance type in a standard academic year.
RESEARCH_PERCENTAGE NUMBER (5)
Describes the default attendance percentage for a given attendance type. For example, research students offered a full-time candidature would normally have a default attendance percentage = 100%.Part-time research students would normally have a defaultattendance percentage = 50%. Attendance percentage is one of the factors considered in the calculation of minimum and maximum submission dates for research students.
CLOSED_IND VARCHAR2 (1) Yes An indicator which specifies if the attendance type is open or closed. Setting the checkbox to 'closed' ticked prevents use of the attendance type 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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      CAL_TYPE
,      SEQUENCE_NUMBER
,      ATTENDANCE_TYPE
,      DESCRIPTION
,      GOVT_ATTENDANCE_TYPE
,      LOWER_ENR_LOAD_RANGE
,      UPPER_ENR_LOAD_RANGE
,      RESEARCH_PERCENTAGE
,      CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGF_AP_AWYR_ATMAP_V;

Dependencies

[top of page]

APPS.IGF_AP_AWYR_ATMAP_V references the following:

SchemaAPPS
ViewIGF_AP_BATCH_AW_MAP
ViewIGS_EN_ATD_TYPE

APPS.IGF_AP_AWYR_ATMAP_V is not referenced by any database object