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_EN_LGCY_SPA_INT

Object Details

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

Contains the Student Program Attempt (and Research Candidacy) information to be imported into the IGS_EN_STDNT_PS_ATT_ALL (and optionally IGS_RE_CANDIDATURE_ALL) table 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: Ipmort Legacy Student Program Attempt
Category: BUSINESS_ENTITY IGS_STUDENT_PROGRAM

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_LGCY_SPA_INT_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	LEGACY_EN_SPA_INT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(15)	Yes	Batch Identifier, used to identify the set of records to be processed.
LEGACY_EN_SPA_INT_ID	NUMBER	(15)	Yes	Unique identifier of the EN Student Program Attempt record.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Identifier
PROGRAM_CD	VARCHAR2	(6)	Yes	Code used to identify the program for that the student is enrolled.
VERSION_NUMBER	NUMBER	(3)	Yes	Number signifying the version of the program for that the student enrolls.
CAL_TYPE	VARCHAR2	(10)	Yes	Name of the calendar type for that the program is offered. It is usual for award programs to be offered in the standard academic calendar.
LOCATION_CD	VARCHAR2	(10)	Yes	The location, typically a campus, from that the student's program is offered.
ATTENDANCE_MODE	VARCHAR2	(2)	Yes	Institution-defined attendance modes for that the program is offered. Institution-defined attendance modes may include.
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	Institution-defined attendance type for that the program is offered. Institution-defined attendance types may include, for example, F - Full-time and P - Part-time.
STUDENT_CONFIRMED_IND	VARCHAR2	(1)		Indicator that specifies whether a commencing student has confirmed their intention to enroll. Setting the checkbox changes the program status from UNCONFIRM to INACTIVE or ENROLLED and inserts the program commencement date.
COMMENCEMENT_DT	DATE			Date on that the student commenced the current program for the first time.
PRIMARY_PROGRAM_TYPE	VARCHAR2	(10)		Type of the program attempt. The value can be PRIMARY or SECONDARY
PRIMARY_PROG_TYPE_SOURCE	VARCHAR2	(10)		How the program type associated with the program type. Valid value can be "Manual" or "System"
KEY_PROGRAM	VARCHAR2	(1)		Y/N Value
PROVISIONAL_IND	VARCHAR2	(1)		Indicator that specifies whether the student's admission and enrolment in the program is provisional. Setting the checkbox indicates that the program candidature is provisional. The indicator is maintained manually.
DISCONTINUED_DT	DATE			Effective date on that the student's program attempt was discontinued.
DISCONTINUATION_REASON_CD	VARCHAR2	(10)		Identifies the primary reason behind the discontinuation of the student's program attempt.
LAPSED_DT	DATE			Describes the date for that the student program attempt status was changed to lapsed.
FUNDING_SOURCE	VARCHAR2	(10)		Funding Source applicable to the student's program attempt. A majority of students are funded from the Common wealth-operating grant, however an increasing number of students are self-funded or paid for by industry.
EXAM_LOCATION_CD	VARCHAR2	(10)		Code of an examination center nominated by the student as their default examination location. This location is overridden if the student nominates a different location for a specific unit.
NOMINATED_COMPLETION_YR	NUMBER	(4)		Year that the student considers they will have completed all program requirements. The student also nominates the expected period - Summer, Mid-year or End of Year of program completion.
NOMINATED_COMPLETION_PERD	VARCHAR2	(30)		Period, or part of the year, at that time the student considers they will have completed all program requirements. The student also nominates the year of expected program completion.
RULE_CHECK_IND	VARCHAR2	(1)		Indicator that specifies whether the system will check the student's academic record for program completion. Setting the indicator causes the system to check program completion rules.
WAIVE_OPTION_CHECK_IND	VARCHAR2	(1)		Indicator that specifies whether any warnings applied as a result of forced element program offering option checks are waived. Checks are made of the student's location attendance mode and attendance type.
LAST_RULE_CHECK_DT	DATE			Describes the date of the last complete rule check of the student's enrolment.
PUBLISH_OUTCOMES_IND	VARCHAR2	(1)		Indicator that specifies whether the student is to have their results published in the press and or on public notice - boards. De-selecting the indicator suppresses publication of results except in a formal certificate of results..
COURSE_RQRMNT_COMPLETE_IND	VARCHAR2	(1)		Indicator that signifies the student program attempt is complete. When set processes within the graduation subsystem are run to obtain academic organizational unit approval.
COURSE_RQRMNTS_COMPLETE_DT	DATE			The date upon which the program requirements were deemed to have been completed.
S_COMPLETED_SOURCE_TYPE	VARCHAR2	(10)		Describes whether completion of program requirements was detected by the system (SYSTEM) following evaluation of rules, or set manually (MANUAL).
ADVANCED_STANDING_IND	VARCHAR2	(1)		Indicator that specifies whether or not the student has been granted an amount of advanced standing that contributes towards the satisfaction of program requirements. Details of any approved and granted advanced standing are maintained in the advanced standing details form.
FEE_CAT	VARCHAR2	(10)		Fee category applicable to the student's program attempt Fee categories are used to define the set of fees and charges applicable to a student studying a particular program.
CORRESPONDENCE_CAT	VARCHAR2	(10)		Correspondence category applicable to the student's program attempt. Correspondence categories are used to define the set of system generated and non-system originated correspondence items that will be sent to the student.
SELF_HELP_GROUP_IND	VARCHAR2	(1)		Indicator that specifies whether the student wants to participate in a self-help group for their enrolled program attempt. Setting the checkbox includes the student in the self-help group.
ADM_ADMISSION_APPL_NUMBER	NUMBER	(2)		Describes the admissions application number that resulted in the student program attempt.
ADM_NOMINATED_COURSE_CD	VARCHAR2	(6)		Describes the admissions program code that resulted in the student program attempt.
ADM_SEQUENCE_NUMBER	NUMBER	(6)		Describes the admissions application sequence number that resulted in the student program attempt.
CLASS_STANDING_OVERRIDE	VARCHAR2	(50)		Class Standing Override
CATALOG_CAL_ALTERNATE_CODE	VARCHAR2	(10)		Alternate Calendar type for the catalogue.
OVERRIDE_CMPL_DT	DATE			Override Expected Completion Date
MANUAL_OVR_CMPL_DT_IND	VARCHAR2	(1)		Manual override completion date indicator. Possible values 'Y' and 'N'. If this column has a value of 'Y' then the completion date is overridden. Default value should be 'N'.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flex field structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE2	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE3	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE4	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE5	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE6	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE7	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE8	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE9	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE10	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE11	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE12	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE13	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE14	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE15	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE16	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE17	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE18	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE19	VARCHAR2	(150)		Attribute for descriptive flexfield
ATTRIBUTE20	VARCHAR2	(150)		Attribute for descriptive flexfield
RE_ATTENDANCE_PERCENTAGE	NUMBER	(5)		Describes the current attendance percentage of the candidate. The attendance percentage represents the total attendance of the research candidature and program work unit attempts.
RE_GOVT_TYPE_OF_ACTIVITY_CD	VARCHAR2	(10)		Describes the Government type of activity code that best reflects the research undertaken by the candidate.
RE_MAX_SUBMISSION_DT	DATE			Describes the latest date the thesis can be submitted. This system-derived value can be overridden.
RE_MIN_SUBMISSION_DT	DATE			Describes the earliest date the thesis can be submitted. This system date can be overridden.
RE_RESEARCH_TOPIC	VARCHAR2	(2000)		Describes the broad research topic of the candidature. More detailed descriptions are entered against the thesis details. This field is required for candidature details.
RE_INDUSTRY_LINKS	VARCHAR2	(2000)		Describes any industries associated with the thesis
IMPORT_STATUS	VARCHAR2	(1)		Record's Import status
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			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

Query Text

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


SELECT BATCH_ID
,      LEGACY_EN_SPA_INT_ID
,      PERSON_NUMBER
,      PROGRAM_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      STUDENT_CONFIRMED_IND
,      COMMENCEMENT_DT
,      PRIMARY_PROGRAM_TYPE
,      PRIMARY_PROG_TYPE_SOURCE
,      KEY_PROGRAM
,      PROVISIONAL_IND
,      DISCONTINUED_DT
,      DISCONTINUATION_REASON_CD
,      LAPSED_DT
,      FUNDING_SOURCE
,      EXAM_LOCATION_CD
,      NOMINATED_COMPLETION_YR
,      NOMINATED_COMPLETION_PERD
,      RULE_CHECK_IND
,      WAIVE_OPTION_CHECK_IND
,      LAST_RULE_CHECK_DT
,      PUBLISH_OUTCOMES_IND
,      COURSE_RQRMNT_COMPLETE_IND
,      COURSE_RQRMNTS_COMPLETE_DT
,      S_COMPLETED_SOURCE_TYPE
,      ADVANCED_STANDING_IND
,      FEE_CAT
,      CORRESPONDENCE_CAT
,      SELF_HELP_GROUP_IND
,      ADM_ADMISSION_APPL_NUMBER
,      ADM_NOMINATED_COURSE_CD
,      ADM_SEQUENCE_NUMBER
,      CLASS_STANDING_OVERRIDE
,      CATALOG_CAL_ALTERNATE_CODE
,      OVERRIDE_CMPL_DT
,      MANUAL_OVR_CMPL_DT_IND
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      RE_ATTENDANCE_PERCENTAGE
,      RE_GOVT_TYPE_OF_ACTIVITY_CD
,      RE_MAX_SUBMISSION_DT
,      RE_MIN_SUBMISSION_DT
,      RE_RESEARCH_TOPIC
,      RE_INDUSTRY_LINKS
,      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
FROM IGS.IGS_EN_LGCY_SPA_INT;

Dependencies

[top of page]

IGS.IGS_EN_LGCY_SPA_INT does not reference any database object

IGS.IGS_EN_LGCY_SPA_INT is referenced by following:

APPS: IGS_EN_LGCY_SPA_INT