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]

TABLE: IGS.IGS_PR_OU_TYPE_ALL

Object Details

Object Name:	IGS_PR_OU_TYPE_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_PR_OU_TYPE_ALL
Subobject Name:
Status:	VALID

IGS_PR_OU_TYPE_ALL describes the types of outcomes from a progression rule check. For example, suspended, excluded, successful, manual, if the outcome must be applied manually. These outcome types must map back onto system-defined outcome types. For example, an institution might want to define suspension and exclusion, that both map back onto the system-defined type of exclusion.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PR_OU_TYPE_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROGRESSION_OUTCOME_TYPE
IGS_PR_OU_TYPE_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DFLT_RESTRICTED_ATT_TYPE
IGS_PR_OU_TYPE_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENCUMBRANCE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRESSION_OUTCOME_TYPE	VARCHAR2	(10)	Yes	The code of an institution-defined outcome type for a progression rule such as program exclusion or program suspension. Each outcome type must be mapped to one of the set of system values comprising like expulsion, exclusion. A student's course progression status is derived from the outcomes applied to their student program attempt.
S_PROGRESSION_OUTCOME_TYPE	VARCHAR2	(30)	Yes	The system outcome type for a progression rule onto that the institution-defined value has been mapped. The set of system statuses comprises expulsion system values. For example, exclusion, manual, probation and others.
DESCRIPTION	VARCHAR2	(60)	Yes	Describes an institution-defined progression rule outcome type such as program exclusion or program suspension. Each outcome type must be mapped to one of the set of system values comprising expulsion, exclusion and others.
ENCUMBRANCE_TYPE	VARCHAR2	(10)		Describes the type of hold that results from the context progression outcome. The default effects of the hold type must align with the system progression outcome type onto the record that is mapped. A progression outcome type of exclusion must be aligned with an academic hold that is associated with either the system hold effect of EXC_COURSE, or EXC_CRS_GP or EXC_CRS_US or EXC_CRS_U.
DFLT_RESTRICTED_ENROLMENT_CP	NUMBER	(6)		Default number of credit points that the student program attempt is restricted to in a subsequent progression period as a consequence of the progression outcome. The number is only applicable where the related hold type results in either the RSTR_GE_CP or RETR_LE_CP system hold effect type.
DFLT_RESTRICTED_ATT_TYPE	VARCHAR2	(2)		The default attendance type that the student program attempt is restricted to in a subsequent progression period as a consequence of the progression outcome. The value only applies where the related hold type results in a RSTR_AT_TY system hold effect type.
CLOSED_IND	VARCHAR2	(1)	Yes	Indicates and specifies if the progression type is open or closed. Selecting the indicator as checked closes the outcome type and prevents its further application in progression rule checks.
POSITIVE_OUTCOME_IND	VARCHAR2	(1)		Indicates whether the outcome is positive.
COMMENTS	VARCHAR2	(2000)		A text-based facility for entering additional information about the context progression rule outcome type. For example, it can be appropriate to describe the circumstances under that the outcome would be applied together with any effects of the related hold type and or other enrollment restrictions.
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
ORG_ID	NUMBER	(15)		Holds the information of the organization that entered this data. This field will be used for row level security in a multi-organization setup.

Query Text

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


SELECT PROGRESSION_OUTCOME_TYPE
,      S_PROGRESSION_OUTCOME_TYPE
,      DESCRIPTION
,      ENCUMBRANCE_TYPE
,      DFLT_RESTRICTED_ENROLMENT_CP
,      DFLT_RESTRICTED_ATT_TYPE
,      CLOSED_IND
,      POSITIVE_OUTCOME_IND
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_PR_OU_TYPE_ALL;

Dependencies

[top of page]

IGS.IGS_PR_OU_TYPE_ALL does not reference any database object

IGS.IGS_PR_OU_TYPE_ALL is referenced by following:

APPS: IGS_PR_OU_TYPE_ALL