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.IGSBV_ST_PR_CONCENTRATION_ATTS

Object Details

Object Name:	IGSBV_ST_PR_CONCENTRATION_ATTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSBV_ST_PR_CONCENTRATION_ATTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Describes student's attempt at program unit set

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_IDENTIFIER	NUMBER	(15)	Yes	Describes the ID code that uniquely identifies a person
PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the person number for a person id
PERSON_NAME	VARCHAR2	(360)	Yes	Full Name of the person.
PROGRAM_CODE	VARCHAR2	(6)	Yes	A code used to identify the program in which the student is enrolled.
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Title of the program code
UNIT_SET_CODE	VARCHAR2	(10)	Yes	The unit set code that is being attempted. Unit sets comprise lists of units or rules that constitute a logical set of units. Unit sets are used to represent concepts such as majors, minors, strands, streams and lists.
UNIT_SET_VERSION_NUMBER	NUMBER	(3)	Yes	Describes the unit set version number which is being attempted
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the internal sequence number
UNIT_SET_TITLE	VARCHAR2	(90)	Yes	Title of the unit set
SELECTION_DATE	DATE			The date the student selected the unit set. There may be multiple attempts of a unit set by a student over time.
STUDENT_CONFIRMED_FLAG	VARCHAR2	(1)	Yes	Indicates if or not the student has confirmed their attempt at the unit set
_LA:STU_CONFIRMED_FLAG_DESC	CHAR	(63)		Student Confirmed Flag Description
END_DATE	DATE			The date on which the student unit set attempt was ended.
PARENT_UNIT_SET_CODE	VARCHAR2	(10)		The parent unit set code. If required it indicates that the unit set in context is a subordinate to another unit set. The parent unit set may be a major that is superior to the unit set in context that may be a minor.
PARENT_SEQUENCE_NUMBER	NUMBER	(6)		The parent unit set attempt sequence number under which the current attempt is being studied. For example, a minor may be studied within a major.
PRIMARY_SET_FLAG	VARCHAR2	(1)	Yes	If the primary set indicator is set checked it indicates that the unit set is the primary set. Primary unit sets display on official notification.
_LA:PRIMARY_SET_FLAG_DESC	CHAR	(57)		Primary Set Flag Description
VOLUNTARY_END_FLAG	VARCHAR2	(1)	Yes	Indicates if the ending of the unit set attempt was voluntary. If not, the student was removed due to a progression breach or other administrative reason.
_LA:VOLUNTARY_END_FLAG_DESC	CHAR	(59)		Voluntary End Flag Description
AUTHORISED_PERSON_IDENTIFIER	NUMBER	(15)		The person ID of the staff member who authorized the unit set, for inclusion in the students record or authorized the removal of the unit set from the students record
AUTHORISED_ON	DATE			The date on which the unit set was authorized.
OVERRIDE_TITLE	VARCHAR2	(90)		The override title of the unit set.
RQRMNTS_COMPLETE_FLAG	VARCHAR2	(1)	Yes	Indicates if the student has completed the requirements of the unit set. This can be set by either the system or manually, as indicated by the source type.
_LA:RQRMNTS_COMP_FLAG_DESC	CHAR	(62)		Requirements Complete Flag Description
RQRMNTS_COMPLETE_DATE	DATE			The date on which the unit set requirements was complete.
COMPLETED_FLAG_SOURCE_TYPE	VARCHAR2	(10)		The source of the completion flag. It can be either system applied or manually applied.
CATALOG_CALENDAR_TYPE	VARCHAR2	(10)		Calendar Type for Catalog Year
CATALOG_CAL_SEQUENCE_NUM	NUMBER	(6)		Sequence Number for Catalog Year
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

Query Text

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


SELECT PERSON_IDENTIFIER
,      PERSON_NUMBER
,      PERSON_NAME
,      PROGRAM_CODE
,      PROGRAM_TITLE
,      UNIT_SET_CODE
,      UNIT_SET_VERSION_NUMBER
,      SEQUENCE_NUMBER
,      UNIT_SET_TITLE
,      SELECTION_DATE
,      STUDENT_CONFIRMED_FLAG
,      _LA:STU_CONFIRMED_FLAG_DESC
,      END_DATE
,      PARENT_UNIT_SET_CODE
,      PARENT_SEQUENCE_NUMBER
,      PRIMARY_SET_FLAG
,      _LA:PRIMARY_SET_FLAG_DESC
,      VOLUNTARY_END_FLAG
,      _LA:VOLUNTARY_END_FLAG_DESC
,      AUTHORISED_PERSON_IDENTIFIER
,      AUTHORISED_ON
,      OVERRIDE_TITLE
,      RQRMNTS_COMPLETE_FLAG
,      _LA:RQRMNTS_COMP_FLAG_DESC
,      RQRMNTS_COMPLETE_DATE
,      COMPLETED_FLAG_SOURCE_TYPE
,      CATALOG_CALENDAR_TYPE
,      CATALOG_CAL_SEQUENCE_NUM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_ST_PR_CONCENTRATION_ATTS;

Dependencies

[top of page]

APPS.IGSBV_ST_PR_CONCENTRATION_ATTS references the following:

APPS: HZ_PARTIES; IGS_AS_SU_SETATMPT; IGS_EN_STDNT_PS_ATT_ALL; IGS_EN_UNIT_SET_ALL; IGS_PS_VER_ALL

APPS.IGSBV_ST_PR_CONCENTRATION_ATTS is not referenced by any database object