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_RU_OU_ALL

Object Details

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

IGS_PR_RU_OU_ALL describes the outcomes applicable to failure of the related progression rule in the way described by the attributes of the outcome. A given rule can have multiple outcomes for any given failure type if required. For example, 1 failure results in probation, 2 failures result in suspension, 3 failures result in exclusion.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PR_RU_OU_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROGRESSION_RULE_CAT PRA_SEQUENCE_NUMBER SEQUENCE_NUMBER
IGS_PR_RU_OU_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENCMB_COURSE_GROUP_CD
IGS_PR_RU_OU_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESTRICTED_ATTENDANCE_TYPE
IGS_PR_RU_OU_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROGRESSION_OUTCOME_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRESSION_RULE_CAT	VARCHAR2	(10)	Yes	Describes the progression rule category to that the outcome applies
PRA_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the progression rule sequence number to that the outcome applies
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the unique sequence number attributed to the outcome
NUMBER_OF_FAILURES	NUMBER	(2)		Required number of failures of the nominated progression rule that would cause the associated outcome to apply. The number of failures can be stipulated as either simple repeat failures of the rule repeat or consecutive repeat failures consecrpt.
PROGRESSION_OUTCOME_TYPE	VARCHAR2	(10)	Yes	The code of a progression outcome type that can be applied as a consequence of failure of the context rule. For example, exclusion or probation. If applicable, progression outcome types are mapped via hold to system hold effects that can be applied to individual student program attempts as a consequence of failure of the rule.
APPLY_AUTOMATICALLY_IND	VARCHAR2	(1)	Yes	Indicates and specifies if the outcome is applied automatically to the student's program attempt, or simply created as are commended outcome that requires approval prior to its application. For example, probation outcomes are frequently applied automatically. By contrast an exclusion outcome is typically subject to consideration by a committee prior to application. Selecting the checkbox selected applies the outcome automatically.
PRG_RULE_REPEAT_FAIL_TYPE	VARCHAR2	(30)		Describes the repeat failure type causing the outcome. The type can be stipulated as either simple repeat failures of the rule repeat or consecutive repeat failures consecrpt.
OVERRIDE_SHOW_CAUSE_IND	VARCHAR2	(1)		Indicates and allows the default value of the show cause indicator to be overidden at an individual rule outcome level. For example, if probation rules do not allow a period of show cause prior to the application of outcomes, selecting the indicator checked will override the default value and allow a period of show cause. By contrast, if exclusion rules by default allow a period of show cause prior to the application of outcomes selecting the indicator would override the default and not allow show cause in this instance.
OVERRIDE_APPEAL_IND	VARCHAR2	(1)		Indicates that allows the default value of the appeal indicator to be overridden at an individual rule outcome level. For example, if probation rules do not allow a period of appeal following the application of outcomes, selecting the indicator checked will override the default value and allow a period of appeal. By contrast if exclusion rules by default allow a period of appeal after the application of outcomes, selecting the indicator would override the default and not allow an appeal.
DURATION	NUMBER	(3)		Describes the duration of the outcome in progression periods. Expulsion and exclusion outcomes must be open ended. Suspension outcomes must have a defined end period. Probation outcomes can be either open ended or have a defined end period. An end date is not applicable to a no penalty outcome. The duration of a penalty can be specified either in terms of effectively enrolled progression periods or simply as a number of successive periods.
DURATION_TYPE	VARCHAR2	(10)		The type of outcome duration either effective or normal.The duration of a penalty can be specified either in terms of effectively enrolled progression periods meaning effective or simply as a number of successive progression periods meaning normal.
RANK	NUMBER	(2)		Describes the rank of a progression outcome in relation to other outcomes in certain circumstances can be applied as a importance is factored in when streamlining the bulk approval or waiving consequence of failure of the rule. By default, the highest ranked process. The number '1' is the highest rank. Outcome is applied by the system bulk approval process. If in an individual circumstance an alternative outcome should apply, higher ranked outcomes must be struck out.
ENCMB_COURSE_GROUP_CD	VARCHAR2	(10)		The code of a default program group from that the student is to be excluded from as a result of the progression rule outcome. A program group code is only applicable ifthe related hold type results in a program group exclusion EXC_CRS_GP.
RESTRICTED_ENROLMENT_CP	NUMBER	(6)		The 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 if the related hold type results in either the RSTR_GE_CP or RETR_LE_CP system hold effect type.
RESTRICTED_ATTENDANCE_TYPE	VARCHAR2	(2)		The 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 if the related holdtype results in a RSTR_AT_TY system hold effect type.
COMMENTS	VARCHAR2	(2000)		A text-based facility for entering additional information about the circumstances under that the context progression rule outcome is applicable.
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)		Operating unit identifier
LOGICAL_DELETE_DT	DATE			Indicates whether the rule outcome is logically deleted or not

Query Text

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


SELECT PROGRESSION_RULE_CAT
,      PRA_SEQUENCE_NUMBER
,      SEQUENCE_NUMBER
,      NUMBER_OF_FAILURES
,      PROGRESSION_OUTCOME_TYPE
,      APPLY_AUTOMATICALLY_IND
,      PRG_RULE_REPEAT_FAIL_TYPE
,      OVERRIDE_SHOW_CAUSE_IND
,      OVERRIDE_APPEAL_IND
,      DURATION
,      DURATION_TYPE
,      RANK
,      ENCMB_COURSE_GROUP_CD
,      RESTRICTED_ENROLMENT_CP
,      RESTRICTED_ATTENDANCE_TYPE
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      LOGICAL_DELETE_DT
FROM IGS.IGS_PR_RU_OU_ALL;

Dependencies

[top of page]

IGS.IGS_PR_RU_OU_ALL does not reference any database object

IGS.IGS_PR_RU_OU_ALL is referenced by following:

APPS: IGS_PR_RU_OU_ALL