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_SU_ATTEMPT

Object Details

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

Implements the student unit attempt

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
OVERRIDE_EFTSU	NUMBER	(7)		This field describes the EFTSU figure entered as an override for the particular student unit attempt. This figure will be used by the system as a 'base EFTSU' whenever calculating EFTSU.
OVERRIDE_ACHIEVABLE_CP	NUMBER	(6)		This field describes the achievable credit point value which appliesto the student unit attempt. This value will override that contained in the unit entity.
OVERRIDE_OUTCOME_DUE_DT	DATE			*** Future functionality.
OVERRIDE_CREDIT_REASON	VARCHAR2	(2000)		This field describes the reason for overriding the achievable or enrolled credit point values.
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
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program.
ADMINISTRATIVE_PRIORITY	NUMBER			The priority given by the administration to a waitlist.
WAITLIST_DT	DATE			The date on which a student is put onto a waitlist.
WAITLIST_MANUAL_IND	VARCHAR2	(1)		Indicates whether waitlist position is changed manually. Allowable Values Y-Manually changed, N-System changed
DCNT_REASON_CD	VARCHAR2	(10)		The code which describes the reason for discontinuation of a program by the student.
ORG_ID	NUMBER	(15)		Operating Unit Identifier.
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
COURSE_CD	VARCHAR2	(6)	Yes	A code used to identify the course in which the student is enrolled. See also Element 307 Higher Education Student Data CollectionDocumentation 1997, DETYA.
UNIT_CD	VARCHAR2	(10)	Yes	The code used to identify the unit.
VERSION_NUMBER	NUMBER	(3)	Yes	Version number is used to uniquely identify each version of a unit.
CAL_TYPE	VARCHAR2	(10)	Yes	This field is the name of a type of teaching calendar within the university. Examples- SEM-1, YR-LONG.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	This field uniquely identifies the calendar instance.
LOCATION_CD	VARCHAR2	(10)	Yes	This field is the location name or code. The locationrepresents a geographical location and is used to indicate where units are offered.
UNIT_CLASS	VARCHAR2	(10)	Yes	This field describes the code that uniquely identifies the unit class
CI_START_DT	DATE		Yes	This field describes the date from which an instance of a calendar is effective
CI_END_DT	DATE		Yes	This field is the date from which an instance of a calendar is no longer effective example- teaching period Semester 1, 1999 may end on30/06/1999.
UOO_ID	NUMBER	(7)	Yes	The unique identifier for a unit offering option.
ENROLLED_DT	DATE			This field describes the date on which the enrolment in the unit took effect. If this date is not set, the student has notconfirmed their enrolment in the unit attempt.
UNIT_ATTEMPT_STATUS	VARCHAR2	(30)	Yes	This field describes the system-defined unit attempt statuses..
ADMINISTRATIVE_UNIT_STATUS	VARCHAR2	(10)		This field describes institution-defined administrative statuses.Examples- WD-EARLY-Withdrawn Early, WD-LATE -Withdrawn Late.
DISCONTINUED_DT	DATE			This field describes the date on which the discontinuation of the unit attempt took effect.
RULE_WAIVED_DT	DATE			This field describes the date on which a failed rule applying to the unit attempt was waived.
RULE_WAIVED_PERSON_ID	NUMBER	(15)		This field describes the person who waived the unit rule applicable to the unit attempt.
NO_ASSESSMENT_IND	VARCHAR2	(1)	Yes	An indicator which specifies whether or not the student is seekinga formal grade for the student unit attempt. Setting the checkbox ticked signifies that the student is simply auditing the unit andwill not be formally assessed.
SUP_UNIT_CD	VARCHAR2	(10)		This field describes the superior unit code of the unit version being attempted.
SUP_VERSION_NUMBER	NUMBER	(3)		This field describes the superior unit version number of the unit version being attempted.
EXAM_LOCATION_CD	VARCHAR2	(10)		This field describes the code that uniquely identifies an examination location.
ALTERNATIVE_TITLE	VARCHAR2	(90)		This field describes the alternative title for the student unitattempt. This alternative title will override the title contained inthe unit table example-it would appear on the student's transcript.
OVERRIDE_ENROLLED_CP	NUMBER	(6)		This field describes the enrolled credit point value which appliesto the student unit attempt. This value will override that contained in the unit entity.
GRADING_SCHEMA_CODE	VARCHAR2	(10)		Grading Schema Code
GS_VERSION_NUMBER	NUMBER	(3)		Grading schema version number
ENR_METHOD_TYPE	VARCHAR2	(10)		Enrollment method type
FAILED_UNIT_RULE	VARCHAR2	(30)		Failed unit rule
CART	VARCHAR2	(1)		Indicates whether the unit attempt is added to the cart or not.
RSV_SEAT_EXT_ID	NUMBER	(15)		Indicates the Reserve Seating Priority and Preference used for Enrollment
ORG_UNIT_CD	VARCHAR2	(30)		Captures the Organization unit code for the student unit attempt.
SESSION_ID	NUMBER			Session Identifier
SUBTITLE	VARCHAR2	(90)
DEG_AUD_DETAIL_ID	NUMBER			Degree Audit Detail ID
STUDENT_CAREER_TRANSCRIPT	VARCHAR2	(1)
STUDENT_CAREER_STATISTICS	VARCHAR2	(1)
CORE_INDICATOR_CODE	VARCHAR2	(30)		The core indicator indicates whether a student unit attempt is Core, Optional, Elective or null.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard Descriptive Flex Field Column.
ATTRIBUTE1	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE2	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE3	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE4	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE5	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE6	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE7	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE8	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE9	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE10	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE11	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE12	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE13	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE14	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE15	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE16	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE17	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE18	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE19	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE20	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
WLST_PRIORITY_WEIGHT_NUM	NUMBER			Sum of waitlist priority weights the student satisfied, when moved into waitlist queue.
WLST_PREFERENCE_WEIGHT_NUM	NUMBER			Sum of waitlist preference weights the student satisfied, when moved into waitlist queue.
UPD_AUDIT_FLAG	VARCHAR2	(1)	Yes	Indicates if this unit has been audited
SS_SOURCE_IND	VARCHAR2	(1)	Yes	Indicates if swap page created this unit attempt

Query Text

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


SELECT ROW_ID
,      OVERRIDE_EFTSU
,      OVERRIDE_ACHIEVABLE_CP
,      OVERRIDE_OUTCOME_DUE_DT
,      OVERRIDE_CREDIT_REASON
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ADMINISTRATIVE_PRIORITY
,      WAITLIST_DT
,      WAITLIST_MANUAL_IND
,      DCNT_REASON_CD
,      ORG_ID
,      PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      LOCATION_CD
,      UNIT_CLASS
,      CI_START_DT
,      CI_END_DT
,      UOO_ID
,      ENROLLED_DT
,      UNIT_ATTEMPT_STATUS
,      ADMINISTRATIVE_UNIT_STATUS
,      DISCONTINUED_DT
,      RULE_WAIVED_DT
,      RULE_WAIVED_PERSON_ID
,      NO_ASSESSMENT_IND
,      SUP_UNIT_CD
,      SUP_VERSION_NUMBER
,      EXAM_LOCATION_CD
,      ALTERNATIVE_TITLE
,      OVERRIDE_ENROLLED_CP
,      GRADING_SCHEMA_CODE
,      GS_VERSION_NUMBER
,      ENR_METHOD_TYPE
,      FAILED_UNIT_RULE
,      CART
,      RSV_SEAT_EXT_ID
,      ORG_UNIT_CD
,      SESSION_ID
,      SUBTITLE
,      DEG_AUD_DETAIL_ID
,      STUDENT_CAREER_TRANSCRIPT
,      STUDENT_CAREER_STATISTICS
,      CORE_INDICATOR_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      WLST_PRIORITY_WEIGHT_NUM
,      WLST_PREFERENCE_WEIGHT_NUM
,      UPD_AUDIT_FLAG
,      SS_SOURCE_IND
FROM APPS.IGS_EN_SU_ATTEMPT;

Dependencies

[top of page]

APPS.IGS_EN_SU_ATTEMPT references the following:

APPS: IGS_EN_SU_ATTEMPT_ALL

APPS.IGS_EN_SU_ATTEMPT is referenced by following:

APPS: IGF_AP_GEN_001 - show dependent code; IGF_AW_COA_GEN - show dependent code; IGF_DB_DISB - show dependent code; IGF_GR_PELL_CALC - show dependent code; IGF_SL_REL_DISB - show dependent code; IGF_SP_GEN_001 - show dependent code; IGS_AD_GEN_001 - show dependent code; IGS_AD_GEN_002 - show dependent code; IGS_AS_ADI_UPLD_AIO_PKG - show dependent code; IGS_AS_ADI_UPLD_AIO_PKG - show dependent code; IGS_AS_ADI_UPLD_PR_PKG - show dependent code; IGS_AS_ADI_UPLD_UG_PKG - show dependent code; IGS_AS_ANON_GRD_PKG - show dependent code; IGS_AS_CALC_AWARD_MARK - show dependent code; IGS_AS_CALC_AWARD_MARK - show dependent code; IGS_AS_FINALIZE_GRADE - show dependent code; IGS_AS_GEN_003 - show dependent code; IGS_AS_GEN_004 - show dependent code; IGS_AS_GEN_005 - show dependent code; IGS_AS_GEN_006 - show dependent code; IGS_AS_GEN_007 - show dependent code; IGS_AS_INCOMP_GRADE - show dependent code; IGS_AS_NOTIFY_PKG - show dependent code; IGS_AS_PRC_TRANSCRPT - show dependent code; IGS_AS_PROD_DOC - show dependent code; IGS_AS_SS_DOC_REQUEST - show dependent code; IGS_AS_SUAH_LOAD_V; IGS_AS_SUAO_LGCY_PUB - show dependent code; IGS_AS_SUARC_LGCY_PUB - show dependent code; IGS_AS_SUA_EXAM_CLASH_V; IGS_AS_SUA_H_V; IGS_AS_SUA_INQ_V; IGS_AS_SUA_LOAD_V; IGS_AS_SUA_SES_ATTS_PKG - show dependent code; IGS_AS_SUA_SES_ATTS_PKG - show dependent code; IGS_AS_SU_ATMPT_PAT_PKG - show dependent code; IGS_AS_SU_ATTEMPT_LKUP_V; IGS_AS_SU_STMPTOUT_MID; IGS_AS_SU_STMPTOUT_PKG - show dependent code; IGS_AS_TRNCMT_LGCY_PUB - show dependent code; IGS_AS_UAI_ETISTD_EXAM_V; IGS_AS_UAI_EXAMINATION_V; IGS_AS_UAI_SUA_V; IGS_AS_UAP_SUA_V; IGS_AS_USECAI_SUA_V; IGS_AS_VAL_SCAP - show dependent code; IGS_AS_VAL_SUAAI - show dependent code; IGS_AS_VAL_SUAAP - show dependent code; IGS_AS_VAL_SUAO - show dependent code; IGS_AS_VAL_UAI - show dependent code; IGS_AU_GEN_003 - show dependent code; IGS_AV_GEN_001 - show dependent code; IGS_DA_XML_ACADEMICPROGRAM_V; IGS_DA_XML_PKG - show dependent code; IGS_DA_XML_PKG - show dependent code; IGS_EN_ADD_UNITS_API - show dependent code; IGS_EN_DASHBOARD - show dependent code; IGS_EN_DROP_UNITS_API - show dependent code; IGS_EN_DROP_UNITS_API - show dependent code; IGS_EN_ELGBL_OVERRIDE - show dependent code; IGS_EN_ELGBL_PROGRAM - show dependent code; IGS_EN_ELGBL_UNIT - show dependent code; IGS_EN_ELGB_OVR_UOO_PKG - show dependent code; IGS_EN_ENROLL_WLST - show dependent code; IGS_EN_ENROLL_WLST - show dependent code; IGS_EN_FUTURE_DT_TRANS - show dependent code; IGS_EN_FUTURE_DT_TRANS - show dependent code; IGS_EN_GEN_001 - show dependent code; IGS_EN_GEN_002 - show dependent code; IGS_EN_GEN_004 - show dependent code; IGS_EN_GEN_005 - show dependent code; IGS_EN_GEN_006 - show dependent code; IGS_EN_GEN_007 - show dependent code; IGS_EN_GEN_008 - show dependent code; IGS_EN_GEN_009 - show dependent code; IGS_EN_GEN_010 - show dependent code; IGS_EN_GEN_010 - show dependent code; IGS_EN_GEN_011 - show dependent code; IGS_EN_GEN_012 - show dependent code; IGS_EN_GEN_013 - show dependent code; IGS_EN_GEN_015 - show dependent code; IGS_EN_GEN_015 - show dependent code; IGS_EN_GEN_017 - show dependent code; IGS_EN_GEN_018 - show dependent code; IGS_EN_GEN_LEGACY - show dependent code; IGS_EN_GET_SUAEH_DTL - show dependent code; IGS_EN_GET_SUAEH_DTL - show dependent code; IGS_EN_IVR_PUB - show dependent code; IGS_EN_NSC_PKG - show dependent code; IGS_EN_OFR_WLST_OPT - show dependent code; IGS_EN_OFR_WLST_OPT - show dependent code; IGS_EN_PLAN_UTILS - show dependent code; IGS_EN_PRC_LOAD - show dependent code; IGS_EN_PRC_LOAD - show dependent code; IGS_EN_REINSTATE_PKG - show dependent code; IGS_EN_SEVIS - show dependent code; IGS_EN_SS_SCHEDULE_DISP_V; IGS_EN_STDNT_PS_ATT_PKG - show dependent code; IGS_EN_SUA_API - show dependent code; IGS_EN_SUA_LGCY_PUB - show dependent code; IGS_EN_SUA_PLACEMENT_DET_V; IGS_EN_SUA_V; IGS_EN_SUA_YEAR_V; IGS_EN_SUSA_YEAR_V; IGS_EN_SU_ATTEMPT_PKG - show dependent code; IGS_EN_TIMESLOTS - show dependent code; IGS_EN_TRANSFER_APIS - show dependent code; IGS_EN_VAL_BULKRULE - show dependent code; IGS_EN_VAL_ENCMB - show dependent code; IGS_EN_VAL_PCE - show dependent code; IGS_EN_VAL_PUE - show dependent code; IGS_EN_VAL_SCA - show dependent code; IGS_EN_VAL_SCI - show dependent code; IGS_EN_VAL_SCT - show dependent code; IGS_EN_VAL_SUA - show dependent code; IGS_EN_VAL_SUT - show dependent code; IGS_EN_WLST_GEN_PROC - show dependent code; IGS_FI_GEN_001 - show dependent code; IGS_FI_GEN_005 - show dependent code; IGS_FI_GEN_008 - show dependent code; IGS_FI_GEN_008 - show dependent code; IGS_FI_GET_SUAEH - show dependent code; IGS_FI_PRC_DISC_SUA - show dependent code; IGS_FI_PRC_SP_FEES - show dependent code; IGS_FI_PRC_STDNT_DPSTS - show dependent code; IGS_HE_EXTRACT_FIELDS_PKG - show dependent code; IGS_HE_ST_UNT_VS_ALL_PKG - show dependent code; IGS_IN_GEN_001 - show dependent code; IGS_IN_GEN_001 - show dependent code; IGS_PR_ACAD_DETAILS - show dependent code; IGS_PR_ACAD_DETAILS - show dependent code; IGS_PR_ACAD_LOAD_V; IGS_PR_ACAD_PROGRAM_V; IGS_PR_ACAD_YEAR_V; IGS_PR_CLASS_RANK - show dependent code; IGS_PR_CLASS_RANK - show dependent code; IGS_PR_CP_GPA - show dependent code; IGS_PR_CP_GPA - show dependent code; IGS_PR_GEN_001 - show dependent code; IGS_PR_GEN_002 - show dependent code; IGS_PR_GEN_004 - show dependent code; IGS_PR_GEN_005 - show dependent code; IGS_PR_GEN_006 - show dependent code; IGS_PR_GET_CLASS_STD - show dependent code; IGS_PR_SDT_PROG_PRD_V; IGS_PR_STU_ACAD_V; IGS_PR_SUA_FINAL_OUTCOME_V; IGS_PR_SUA_INQ_V; IGS_PS_GEN_003 - show dependent code; IGS_PS_GEN_008 - show dependent code; IGS_PS_VALIDATE_GENERIC_PKG - show dependent code; IGS_PS_VALIDATE_LGCY_PKG - show dependent code; IGS_PS_VAL_UV - show dependent code; IGS_PS_WF_EVENT_HOOK_PKG - show dependent code; IGS_PS_WF_EVENT_HOOK_PKG - show dependent code; IGS_PT_GEN_PKG - show dependent code; IGS_RE_GEN_001 - show dependent code; IGS_RE_GEN_001 - show dependent code; IGS_RE_GEN_002 - show dependent code; IGS_RE_VAL_CAH - show dependent code; IGS_RU_GEN_001 - show dependent code; IGS_RU_VAL_UNIT_RULE - show dependent code; IGS_SESSION_VALIDITY - show dependent code; IGS_SS_ENROLL_PKG - show dependent code; IGS_SS_ENR_DETAILS - show dependent code; IGS_SS_EN_RULE_CART_MAX_V; IGS_SS_EN_SUA_DTLS_V; IGS_SS_EN_USEC_EXAM_SCH_V; IGS_SS_EN_WRAPPERS - show dependent code; IGS_SS_EN_WRAPPERS - show dependent code; IGS_SS_FACULTY_PKG - show dependent code; IGS_SS_FACULTY_PKG - show dependent code; IGS_ST_GEN_001 - show dependent code; IGS_ST_GEN_003 - show dependent code; IGS_ST_GEN_003 - show dependent code; IGS_ST_GEN_004 - show dependent code