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_LGCY_SPO_INT

Object Details

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

Contains Student Progression Outcome details to be imported into the IGS_PR_STDNT_PR_OU_ALL, IGS_PR_STDNT_PR_PS, IGS_PR_STDNT_PR_UNIT, IGS_PR_SDT_PR_UNT_ST tables by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Legacy Progression Outcome
Category: BUSINESS_ENTITY IGS_STUDENT_PROGRAM

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PR_LGCY_SPO_INT_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	LEGACY_PR_SPO_INT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LEGACY_PR_SPO_INT_ID	NUMBER	(15)	Yes	Unique identifier of the PR Progression Outcome record
BATCH_ID	NUMBER	(15)	Yes	Batch Identifier
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person number of the progression outcome.
PROGRAM_CD	VARCHAR2	(6)	Yes	Program code to which the progression outcome applies.
PRG_CAL_ALTERNATE_CODE	VARCHAR2	(10)	Yes	Progression calendar type in which the outcome is to be applied.
PROGRESSION_OUTCOME_TYPE	VARCHAR2	(10)		The code of the progression rule outcome type.
DURATION	NUMBER	(3)		Duration of the outcome, expressed in progression periods.
DURATION_TYPE	VARCHAR2	(10)		Outcome duration type.
DECISION_STATUS	VARCHAR2	(10)	Yes	Decision status of the outcome.
DECISION_DT	DATE			Date on which the decision to recommend, approve, waive, cancel or remove the progression outcome was taken.
DECISION_ORG_UNIT_CD	VARCHAR2	(30)		Code of the organizational unit responsible for the current progression outcome decision status.
SHOW_CAUSE_EXPIRY_DT	DATE			Expiry date of the show cause period.
SHOW_CAUSE_DT	DATE			The date on which the student submitted their show cause application.
SHOW_CAUSE_OUTCOME_DT	DATE			The date on which the decision was made in respect of the students show cause application
SHOW_CAUSE_OUTCOME_TYPE	VARCHAR2	(10)		Outcome of the students show cause application.
APPEAL_EXPIRY_DT	DATE			The expiry date for lodgement of an appeal.
APPEAL_DT	DATE			Date on which the student raised an appeal against the outcome.
APPEAL_OUTCOME_DT	DATE			The date on which the decision was made in respect of the students appeal application
APPEAL_OUTCOME_TYPE	VARCHAR2	(10)		Outcome of the students appeal application.
ENCMB_PROGRAM_GROUP_CD	VARCHAR2	(10)		Encumbered Program group code from which the outcome is excluding.
RESTRICTED_ENROLMENT_CP	NUMBER	(6)		Credit points the program attempt is restricted to due to the progression outcome
RESTRICTED_ATTENDANCE_TYPE	VARCHAR2	(2)		Attendance type the program attempt is restricted to due to the progression outcome.
COMMENTS	VARCHAR2	(2000)		Miscellaneous textual comments about the outcome.
SHOW_CAUSE_COMMENTS	VARCHAR2	(2000)		Textual comments about the students show cause application
APPEAL_COMMENTS	VARCHAR2	(2000)		Textual comments about the students appeal application
EXPIRY_DT	DATE			The expiry date of the outcome.
AWARD_CD	VARCHAR2	(10)		The award code granted to the student as a result of the outcome.
SPO_PROGRAM_CD	VARCHAR2	(6)		The program from which the outcome is suspending or excluding the student.
UNIT_CD	VARCHAR2	(10)		The unit code from which the outcome is excluding the student from, or requiring them to take.
S_UNIT_TYPE	VARCHAR2	(10)		Indicates whether the unit is an exclusion or requirement.
UNIT_SET_CD	VARCHAR2	(10)		The Unit Set code from which the student is to be excluded.
US_VERSION_NUMBER	NUMBER	(3)		The Version number of the unit set applicable at the time the exclusion is applied.
IMPORT_STATUS	VARCHAR2	(1)		Record Import Status , Allowable values are U - Unprocessed (Default)R - Ready For ProcessingE - ErrorW - WarningI - Imported
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
REQUEST_ID	NUMBER	(15)		Standard concurrent program who column
PROGRAM_ID	NUMBER	(15)		Standard concurrent program who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard concurrent program who column
PROGRAM_UPDATE_DATE	DATE			Standard concurrent program who column
FUND_CODE	VARCHAR2	(30)		Indicates the excluded Financial Aid Fund Code related to a particular Student Progression Outcome.

Query Text

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


SELECT LEGACY_PR_SPO_INT_ID
,      BATCH_ID
,      PERSON_NUMBER
,      PROGRAM_CD
,      PRG_CAL_ALTERNATE_CODE
,      PROGRESSION_OUTCOME_TYPE
,      DURATION
,      DURATION_TYPE
,      DECISION_STATUS
,      DECISION_DT
,      DECISION_ORG_UNIT_CD
,      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_PROGRAM_GROUP_CD
,      RESTRICTED_ENROLMENT_CP
,      RESTRICTED_ATTENDANCE_TYPE
,      COMMENTS
,      SHOW_CAUSE_COMMENTS
,      APPEAL_COMMENTS
,      EXPIRY_DT
,      AWARD_CD
,      SPO_PROGRAM_CD
,      UNIT_CD
,      S_UNIT_TYPE
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      IMPORT_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      FUND_CODE
FROM IGS.IGS_PR_LGCY_SPO_INT;

Dependencies

[top of page]

IGS.IGS_PR_LGCY_SPO_INT does not reference any database object

IGS.IGS_PR_LGCY_SPO_INT is referenced by following:

APPS: IGS_PR_LGCY_SPO_INT