eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGS_EN_ATD_TYPE

Object Details

Object Name:	IGS_EN_ATD_TYPE
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_EN_ATD_TYPE
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.

View incorporating various attendance types available. i.e. full-time, part-time.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
ORG_ID	NUMBER	(15)		Operating Unit Identifier.
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	The code of an institution-defined attendance type. Anattendance 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
,      ORG_ID
,      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.IGS_EN_ATD_TYPE;

Dependencies

[top of page]

APPS.IGS_EN_ATD_TYPE references the following:

APPS: IGS_EN_ATD_TYPE_ALL

APPS.IGS_EN_ATD_TYPE is referenced by following:

APPS: IGF_AP_AWYR_ATMAP_V; IGF_AP_IA_LOOKUP_V; IGF_AW_ANTICIPATED_DATA - show dependent code; IGF_AW_AWD_DISB_V; IGF_AW_DP_TEACH_PRDS_V; IGF_AW_FUND_MAST_V; IGF_AW_LI_IMPORT - show dependent code; IGF_SP_FUND_MAST_V; IGF_SP_STDNT_REL_V; IGS_AD_GEN_002 - show dependent code; IGS_AD_GEN_004 - show dependent code; IGS_AD_GEN_010 - show dependent code; IGS_AD_VAL_APCOO - show dependent code; IGS_AD_WF_P2A - show dependent code; IGS_CA_VAL_QLITY - show dependent code; IGS_EN_GEN_002 - show dependent code; IGS_EN_GEN_006 - show dependent code; IGS_EN_SPA_TERMS_API - show dependent code; IGS_EN_VAL_ENCMB - show dependent code; IGS_EN_VAL_PEE - show dependent code; IGS_EN_VAL_SCA - show dependent code; IGS_FI_1098T_EXTRACT_DATA - show dependent code; IGS_FI_FEE_AS_RATE_V; IGS_FI_VAL_CFAR - show dependent code; IGS_GE_VAL_PARAM - show dependent code; IGS_PRECREATE_APPL_PUB - show dependent code; IGS_PR_GEN_006 - show dependent code; IGS_PR_MILESTONE_CRV_ATT_V; IGS_PR_OU_TYPE_V; IGS_PS_VAL_COO - show dependent code; IGS_PS_VAL_GAT - show dependent code; IGS_RE_GEN_001 - show dependent code; IGS_ST_GEN_004 - show dependent code