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_AS_SUA_ASS_V

Object Details

Object Name:	IGS_AS_SUA_ASS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_AS_SUA_ASS_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)
PERSON_ID	NUMBER	(15)	Yes	The student's person ID.
COURSE_CD	VARCHAR2	(6)	Yes	The code of the course associated with the student's unit attempt. Each student unit attempt exists within a specified course.
UNIT_CD	VARCHAR2	(10)	Yes	The code identifying the unit in which the student is enrolled.
VERSION_NUMBER	NUMBER	(3)	Yes	The version number of the unit in which the student is enrolled. The version number defaults to the current version upon entry of the unit code.
CAL_TYPE	VARCHAR2	(10)	Yes	Units are offered in treaching calendars. For example SEM - 1 -semester 1-, SEM - 2 -semester 2- and YR-LONG -a year long teaching period-.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The system generated sequence number of the calendar instance -??? Which clanedar instance?-
ACAD_ALTERNATE_CODE	VARCHAR2	(10)		The short code used to describe the academic period associated with the unit attempt.
TEACH_ALTERNATE_CODE	VARCHAR2	(10)		The short alternate code for the teaching period in which the student is enrolled in the unit.
LOCATION_CD	VARCHAR2	(10)	Yes	The location at which the student is enrolled in the unit.
UNIT_CLASS	VARCHAR2	(10)	Yes	The class in which the student is enrolled for the unit attempt. Eg. D-day-, E-evening- classes.
UNIT_MODE	VARCHAR2	(10)		The attendance mode of the student's unit attempt. Eg. ON and OFF.
CI_START_DT	DATE		Yes	The start date of which calendar instnance ??? Teaching period?
CI_END_DT	DATE		Yes	The end date of which calendar instnance ??? Teaching calendar?
UOO_ID	NUMBER	(7)	Yes	STUDENT_UNIT_ATTEMPT.UOO_ID
ENROLLED_DT	DATE			The date on which the student enrolled in the unit.
UNIT_ATTEMPT_STATUS	VARCHAR2	(30)	Yes	The status of the student's unit attempt. Available statuses are UNCONFIRM, ENROLLED, DISCONTIN, COMPLETED and INVALID.
ADMINISTRATIVE_UNIT_STATUS	VARCHAR2	(10)		The administrative unit status -AUS- attached to a discontinued unit. Examples of AUS may include WE - withdrawn early- WL - withdrawn Late- WF- Withdrawn Fail. When a unit is discontinued an AUS is defaulted based on pre-determined discontinuation date critieria. The default AUS can be over-ridden. AUS are instiution defined.
DISCONTINUED_DT	DATE			The date on which the student discontinued enrolment in the unit.
RULE_WAIVED_DT	DATE			The date on which a unit enrolment rule -pre-requisite, co-requisite etc- was waived thereby permitting enrolment in the context unit.
RULE_WAIVED_PERSON_ID	NUMBER	(15)		The identification number of a staff member authorised to waive unit enrolment rules -pre-requisite, co-requsite etc-. Use the Find Person Form to search for the person's ID.
RULE_WAIVED_PERSON_NUMBER	VARCHAR2	(30)		Rule waiver person number
NO_ASSESSMENT_IND	VARCHAR2	(1)	Yes	An indicator which specifies whether or not the student is to be assessed in the unit and receive a formal grade. Setting the indicator -ticked- means that the student is not to be assessed.
SUP_UNIT_CD	VARCHAR2	(10)		The code of a superior unit in which the student is enrolled. A list of values is available. The superior unit must be linked to one or more sub-unit enrolments. -See also Element 354 of the Higher Education Student Data Collection Documentation 1997, DETYA.
SUP_VERSION_NUMBER	NUMBER	(3)		The version number of the suoerior unit in which the student is enrolled. The version number defaults to the current version upon entry of the unit code.
EXAM_LOCATION_CD	VARCHAR2	(10)		The code of an examination centre nominated by the student as their examination location for this particular unit. This codes over-rides any different examination location nominated for the student's course attempt as a whole. A list of values is avaialbe.
ALTERNATIVE_TITLE	VARCHAR2	(90)		The alternative title of the Academic Calendar in which the student is enrolled.
OVERRIDE_ENROLLED_CP	NUMBER	(6)		Functionality not in Phase 1
OVERRIDE_EFTSU	NUMBER	(7)		Functionality not in Phase 1
OVERRIDE_ACHIEVABLE_CP	NUMBER	(6)		Functionality not in Phase 1
OVERRIDE_OUTCOME_DUE_DT	DATE			Functionality not in Phase 1
OVERRIDE_CREDIT_REASON	VARCHAR2	(2000)		Functionality not in Phase 1
PERSON_NUMBER	VARCHAR2	(30)	Yes
FULL_NAME	VARCHAR2	(450)
SEX_MEANING	VARCHAR2	(80)
BIRTH_DT	DATE
API_PERSON_ID	VARCHAR2	(20)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
WAITLIST_DT	DATE
ADMINISTRATIVE_PRIORITY	NUMBER
CALL_NUMBER	NUMBER			Call Number
INITIAL_LAST_NAME	VARCHAR2	(450)
DEG_AUD_DETAIL_ID	NUMBER			Degree Audit Detail Id
TEACH_CAL_DESCRIPTION	VARCHAR2	(30)		Teaching Calendar Description

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ACAD_ALTERNATE_CODE
,      TEACH_ALTERNATE_CODE
,      LOCATION_CD
,      UNIT_CLASS
,      UNIT_MODE
,      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
,      RULE_WAIVED_PERSON_NUMBER
,      NO_ASSESSMENT_IND
,      SUP_UNIT_CD
,      SUP_VERSION_NUMBER
,      EXAM_LOCATION_CD
,      ALTERNATIVE_TITLE
,      OVERRIDE_ENROLLED_CP
,      OVERRIDE_EFTSU
,      OVERRIDE_ACHIEVABLE_CP
,      OVERRIDE_OUTCOME_DUE_DT
,      OVERRIDE_CREDIT_REASON
,      PERSON_NUMBER
,      FULL_NAME
,      SEX_MEANING
,      BIRTH_DT
,      API_PERSON_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      WAITLIST_DT
,      ADMINISTRATIVE_PRIORITY
,      CALL_NUMBER
,      INITIAL_LAST_NAME
,      DEG_AUD_DETAIL_ID
,      TEACH_CAL_DESCRIPTION
FROM APPS.IGS_AS_SUA_ASS_V;

Dependencies

[top of page]

APPS.IGS_AS_SUA_ASS_V references the following:

APPS: HZ_PARTIES; IGS_CA_GEN_001 - show dependent code; IGS_CA_INST; IGS_EN_GEN_003 - show dependent code; IGS_EN_GEN_007 - show dependent code; IGS_EN_GEN_014 - show dependent code; IGS_EN_SU_ATTEMPT_SV; IGS_PE_PERSON; IGS_PS_GEN_006 - show dependent code; IGS_PS_UNIT_OFR_OPT

APPS.IGS_AS_SUA_ASS_V is referenced by following:

APPS: IGS_AS_GEN_006 - show dependent code