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_STDNT_PR_OU_ALL

Object Details

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

IGS_PR_STDNT_PR_OU_ALL describes a progression outcome applied to a student, either manually or by the system, as a result of failing a progression rule. This detail is subject to approval, waiving and other prior to application to the student, unless an automatic outcome.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PR_STDNT_PR_OU_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD SEQUENCE_NUMBER
IGS_PR_STDNT_PR_OU_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROGRESSION_OUTCOME_TYPE
IGS_PR_STDNT_PR_OU_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENCMB_COURSE_GROUP_CD
IGS_PR_STDNT_PR_OU_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD PRG_CAL_TYPE PRG_CI_SEQUENCE_NUMBER RULE_CHECK_DT PROGRESSION_RULE_CAT PRA_SEQUENCE_NUMBER
IGS_PR_STDNT_PR_OU_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DECISION_ORG_UNIT_CD DECISION_OU_START_DT
IGS_PR_STDNT_PR_OU_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESTRICTED_ATTENDANCE_TYPE
IGS_PR_STDNT_PR_OU_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROGRESSION_RULE_CAT PRA_SEQUENCE_NUMBER PRO_SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Describes the person identifier to whom the outcome has been applied
COURSE_CD	VARCHAR2	(6)	Yes	Describes the code of the program attempt to thatthe outcome has been applied
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the unique sequence number of the outcome
PRG_CAL_TYPE	VARCHAR2	(10)		Describes the progression calendar type that the rulewas tested and from that the outcome originates
PRG_CI_SEQUENCE_NUMBER	NUMBER	(6)		Describes the progression calendar sequence number
RULE_CHECK_DT	DATE			Date of the progression rule failure
PROGRESSION_RULE_CAT	VARCHAR2	(10)		Code of an institution-defined category of program progression rules
PRA_SEQUENCE_NUMBER	NUMBER	(6)		Describes the progression rule sequence number
PRO_SEQUENCE_NUMBER	NUMBER	(6)		Describes the progression outcome sequence number
PROGRESSION_OUTCOME_TYPE	VARCHAR2	(10)		The code of the progression rule outcome type exclusion, expulsion, manual, nopenalty, probation or suspension. If applicable, the outcome type is linked to an hold with one or more system defined hold effect types and a restricted credit point value or a restricted attendance type value.
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 nopenalty 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 effective or simply as a number of successive progression periods normal.
DECISION_STATUS	VARCHAR2	(10)	Yes	Describes the decision status of the outcome. Values are pending a recommended outcome has been created by the system. Approved a progression outcome has been approved and will be applied as a result of a progression rule failure. No decision on its application has been made. Waived outcome has been waived. Cancelled outcome has been cancelled as result of show cause or appeal. Removed outcome has been removed for reasons other than show causeor appeal.
DECISION_DT	DATE			Describes the date on that the current decision status was made, like the decision to recommend, approve, waive, cancel or remove the progression outcome.
DECISION_ORG_UNIT_CD	VARCHAR2	(30)		The code of the organizational unit responsible for the current progression outcome decision status.
DECISION_OU_START_DT	DATE			Describes the organizational unit start date
APPLIED_DT	DATE			The date on that the progression outcome was applied to the student program attempt, through either hold or enrollment functionality like discontinuation.
SHOW_CAUSE_EXPIRY_DT	DATE			Describes the expiry date of the show cause period. This date is set on approval of the outcome based on the appropriate offset or cut-off dates and can be overridden by authorized users.
SHOW_CAUSE_DT	DATE			The date on that the student submitted their show cause application.
SHOW_CAUSE_OUTCOME_DT	DATE			The date on that the decision was made in respect ofthe student's show cause application
SHOW_CAUSE_OUTCOME_TYPE	VARCHAR2	(10)		Describes the outcome of the student's show cause application. The value will be either upheld or dismissed.
APPEAL_EXPIRY_DT	DATE			The expiry date for lodgment of an appeal. The date is set in one of two ways.1. Where both show cause and appeal processes are available to the student, the date is set following the decision to dismiss the show cause application. 2. Where a show cause processis not an option, the date is set on approval of the outcome based on the appropriate offset or cut-off dates. The date may be overridden by authorized users.
APPEAL_DT	DATE			Describes the date on tjat the student appealed the outcome
APPEAL_OUTCOME_DT	DATE			The date on that the decision was made in respect ofthe student's appeal application
APPEAL_OUTCOME_TYPE	VARCHAR2	(10)		Describes the outcome of the student's appeal application. The value will be either upheld or dismissed.
ENCMB_COURSE_GROUP_CD	VARCHAR2	(10)		The code of a default course group from which the student is to be excluded from as a result of the progression rule outcome. A program group code is only applicable if the 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 orRETR_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 hold type results in a RSTR_AT_TY systemhold effect type.
COMMENTS	VARCHAR2	(2000)		A text based facility for entering additional comments about the student program attempt progression outcome
SHOW_CAUSE_COMMENTS	VARCHAR2	(2000)		A text-based facility for entering additional information about the student's show cause application
APPEAL_COMMENTS	VARCHAR2	(2000)		A text-based facility for entering additional information about thestudent's appeal application
EXPIRY_DT	DATE			Indicates the expiry date
PRO_PRA_SEQUENCE_NUMBER	NUMBER	(6)		Idicates the relation between the progression rule sequence number and the progression rule outcome number
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

Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      SEQUENCE_NUMBER
,      PRG_CAL_TYPE
,      PRG_CI_SEQUENCE_NUMBER
,      RULE_CHECK_DT
,      PROGRESSION_RULE_CAT
,      PRA_SEQUENCE_NUMBER
,      PRO_SEQUENCE_NUMBER
,      PROGRESSION_OUTCOME_TYPE
,      DURATION
,      DURATION_TYPE
,      DECISION_STATUS
,      DECISION_DT
,      DECISION_ORG_UNIT_CD
,      DECISION_OU_START_DT
,      APPLIED_DT
,      SHOW_CAUSE_EXPIRY_DT
,      SHOW_CAUSE_DT
,      SHOW_CAUSE_OUTCOME_DT
,      SHOW_CAUSE_OUTCOME_TYPE
,      APPEAL_EXPIRY_DT
,      APPEAL_DT
,      APPEAL_OUTCOME_DT
,      APPEAL_OUTCOME_TYPE
,      ENCMB_COURSE_GROUP_CD
,      RESTRICTED_ENROLMENT_CP
,      RESTRICTED_ATTENDANCE_TYPE
,      COMMENTS
,      SHOW_CAUSE_COMMENTS
,      APPEAL_COMMENTS
,      EXPIRY_DT
,      PRO_PRA_SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_PR_STDNT_PR_OU_ALL;

Dependencies

[top of page]

IGS.IGS_PR_STDNT_PR_OU_ALL does not reference any database object

IGS.IGS_PR_STDNT_PR_OU_ALL is referenced by following:

APPS: IGS_PR_STDNT_PR_OU_ALL