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

VIEW: APPS.IGS_EN_ATD_TYPE_LOAD

Object Details
Object Name: IGS_EN_ATD_TYPE_LOAD
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_EN_ATD_TYPE_LOAD
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 calculates the load factor for a student based on attendance type, lower enrolment load range, upper enrolment load range and total student units.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ORG_ID NUMBER (15)
Operating Unit Identifier.
CAL_TYPE VARCHAR2 (10) Yes The name of a load calendar type associated with the specified attendance type. Load calendars are used to determine student course attendance type, student EFTSU, credit point-based fees, HECS liabilities and for reporting to government. In this context, they enable the definition of a load range for each attendance type within a specified load calendar type. For example, the attendance type PART TIME may be defined as a load range of 0.001 - 0.374 when occurring in LOAD CALENDAR SEMESTER 1.
ATTENDANCE_TYPE VARCHAR2 (2) Yes This field describes the attendance types for a course.Examples- Full-time, Part-time. DETYA element reference 330.
LOWER_ENR_LOAD_RANGE NUMBER (7) Yes A value which determines the lower limit of the attendance type loadrange for the specified load calendar type.
UPPER_ENR_LOAD_RANGE NUMBER (7) Yes A value which determines the upper limit of the attendance type load range for the specified load calendar type.
DEFAULT_EFTSU NUMBER (7)
This field describes the EFTSU value that is the default for the context institution-defined attedendance type within a load calendar.Where the standard academic year is represented by two load calendars equivalent to Semester 1 and Semester 2, the default values for a part-time enrolment is typically 0.25, and for a full-time enrolment,0.5 EFTSU.
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
,      ORG_ID
,      CAL_TYPE
,      ATTENDANCE_TYPE
,      LOWER_ENR_LOAD_RANGE
,      UPPER_ENR_LOAD_RANGE
,      DEFAULT_EFTSU
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_ATD_TYPE_LOAD;

Dependencies

[top of page]

APPS.IGS_EN_ATD_TYPE_LOAD references the following:

SchemaAPPS
SynonymIGS_EN_ATD_TYPE_LOAD_ALL
APPS.IGS_EN_ATD_TYPE_LOAD is referenced by following:

SchemaAPPS
Package BodyIGF_AP_OSS_INTR_DTLS - show dependent code
Package BodyIGF_AW_COA_GEN - show dependent code
Package BodyIGF_DB_DISB - show dependent code
Package BodyIGF_GR_PELL_CALC - show dependent code
Package BodyIGF_SL_REL_DISB - show dependent code
Package BodyIGS_CA_VAL_QLITY - show dependent code
Package BodyIGS_EN_GEN_002 - show dependent code
Package BodyIGS_EN_GEN_006 - show dependent code
Package BodyIGS_EN_NSC_PKG - show dependent code
PL/SQL PackageIGS_EN_PRC_LOAD - show dependent code
Package BodyIGS_EN_PRC_LOAD - show dependent code
Package BodyIGS_EN_SEVIS - show dependent code
Package BodyIGS_EN_VAL_SCA - show dependent code
Package BodyIGS_PS_VAL_ATL - show dependent code