DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_PR_STU_OU_HIST_ALL

Object Details
Object Name: IGS_PR_STU_OU_HIST_ALL
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_PR_STU_OU_HIST_ALL
Subobject Name:
Status: VALID


IGS_PR_STU_OU_HIST_ALL describes the student outcome history.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_PR_STU_OU_HIST_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
ColumnSEQUENCE_NUMBER
ColumnHIST_START_DT
ColumnCOURSE_CD
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 that the outcome has been applied
SEQUENCE_NUMBER NUMBER (6) Yes Describes the unique sequence number of the outcome
HIST_START_DT DATE
Yes Iindicates the history start date
APPEAL_COMMENTS VARCHAR2 (2000)
Indicates the appeal comments
APPEAL_DT DATE

Describes the date on that the student appealed the outcome
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 process is not an option, the date is set on approval of the outcome based on the appropriate offset cut-off dates. The date can be over ridden by authorized users.
APPEAL_OUTCOME_DT DATE

The date on that the decision was made in respect of the 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
APPLIED_DT DATE

The date on that the progression outcome was applied to the student program attempt, through either holds or enrollment functionality like discontinuation
COMMENTS VARCHAR2 (2000)
A text based facility for entering additional comments about the student program attempt progression outcome.
DECISION_DT DATE

Describes the date that the current decision status was made. 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
DECISION_STATUS VARCHAR2 (10)
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 cause or 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 nopealty 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.
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 if the related hold type results in a program group exclusion.
EXPIRY_DT DATE

Indicates the expiry date
HIST_END_DT DATE
Yes Indicates the history end date
HIST_WHO VARCHAR2 (30) Yes Indicates the user who modified this record
PRA_SEQUENCE_NUMBER NUMBER (6)
Describes the progression rule sequence number
PRG_CAL_TYPE VARCHAR2 (10)
Describes the progression calendar type in that the rule was tested and from that the outcome originates
PRG_CI_SEQUENCE_NUMBER NUMBER (6)
Describes the progression calendar 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 hold with one or more system defined hold effect types and a restricted credit point value or a restricted attendance type value.
PROGRESSION_RULE_CAT VARCHAR2 (10)
The code of an institution-defined category of program progression rules
PRO_PRA_SEQUENCE_NUMBER NUMBER (6)
Iindicates the relation between progression rule sequence number and the progression rule outcome number
PRO_SEQUENCE_NUMBER NUMBER (6)
Describes the progression outcome sequence number
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 system hold effect type.
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.
RULE_CHECK_DT DATE

Date of the progression rule failure
SHOW_CAUSE_COMMENTS VARCHAR2 (2000)
A text-based facility for entering additional information about the student's show cause application
SHOW_CAUSE_DT DATE

The date that the student submitted their show cause application
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_OUTCOME_DT DATE

The date that the decision was made in respect of the student's show cause application.
SHOW_CAUSE_OUTCOME_TYPE DATE

Describes the outcome of the student's show cause application. The value will be either upheld or dismissed.
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

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
,      HIST_START_DT
,      APPEAL_COMMENTS
,      APPEAL_DT
,      APPEAL_EXPIRY_DT
,      APPEAL_OUTCOME_DT
,      APPEAL_OUTCOME_TYPE
,      APPLIED_DT
,      COMMENTS
,      DECISION_DT
,      DECISION_ORG_UNIT_CD
,      DECISION_OU_START_DT
,      DECISION_STATUS
,      DURATION
,      DURATION_TYPE
,      ENCMB_COURSE_GROUP_CD
,      EXPIRY_DT
,      HIST_END_DT
,      HIST_WHO
,      PRA_SEQUENCE_NUMBER
,      PRG_CAL_TYPE
,      PRG_CI_SEQUENCE_NUMBER
,      PROGRESSION_OUTCOME_TYPE
,      PROGRESSION_RULE_CAT
,      PRO_PRA_SEQUENCE_NUMBER
,      PRO_SEQUENCE_NUMBER
,      RESTRICTED_ATTENDANCE_TYPE
,      RESTRICTED_ENROLMENT_CP
,      RULE_CHECK_DT
,      SHOW_CAUSE_COMMENTS
,      SHOW_CAUSE_DT
,      SHOW_CAUSE_EXPIRY_DT
,      SHOW_CAUSE_OUTCOME_DT
,      SHOW_CAUSE_OUTCOME_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_PR_STU_OU_HIST_ALL;

Dependencies

[top of page]

IGS.IGS_PR_STU_OU_HIST_ALL does not reference any database object

IGS.IGS_PR_STU_OU_HIST_ALL is referenced by following:

SchemaAPPS
SynonymIGS_PR_STU_OU_HIST_ALL