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]

VIEW: APPS.IGS_PS_VER_HIST_V

Object Details

Object Name:	IGS_PS_VER_HIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_PS_VER_HIST_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
COURSE_CD	VARCHAR2	(6)	This field describes the course code. DEET element reference 307.
VERSION_NUMBER	NUMBER	(3)	The version number of the course. There can only be one version of a course with a system status of ACTIVE and an unset EXPIRY DATE.
HIST_START_DT	DATE		The effective start date/time of the history record.
HIST_END_DT	DATE		The effective end date/time of the history record.
HIST_WHO	NUMBER	(15)	The Oracle username of the person who created the history record.
START_DT	DATE		The date on which the course version became current.
REVIEW_DT	DATE		The date on which the course version is due for review. No automatic closure/rollover is implied by this date.
EXPIRY_DT	DATE		The date on which the course version expires. Students already enrolled may remain in an expired course version. New students are not normally enrolled in an expired course version unless they are also granted an amount of advanced standing which would enable them to complete course requirements before the version is due to end.
END_DT	DATE		The date on which the course version is completely ended. All students will have completed or been transferred to other versions. No more students may be enrolled in the version.
COURSE_STATUS	VARCHAR2	(10)	An institution-defined course status which indicates the level of course. activity of the course version. A course is established with a status of PLANNED. For students to be enrolled in the course it must be ACTIVE.
TITLE	VARCHAR2	(90)	The full name of the course, (DETYA element 308).
SHORT_TITLE	VARCHAR2	(40)	The short title of the course version.
ABBREVIATION	VARCHAR2	(20)	The abbreviated course version name.
SUPP_EXAM_PERMITTED_IND	VARCHAR2	(1)	An indicator which specifies whether or not supplementary examinations or other assessment can be undertaken by students enrolled in this course. Setting the checkbox (ticked) allows supplementary assessment to be granted.
GENERIC_COURSE_IND	VARCHAR2	(1)	Indicates whether the course is a 'generic' course. Students in a generic course can transfer to any of the courses in the related group at any point during their enrolment.
GRADUATE_STUDENTS_IND	VARCHAR2	(1)	Describes whether or not students may graduate after completing this course. Setting the checkbox (ticked) enables students to graduate upon completion of course requirements. The indicator is not set for non-award courses.
COUNT_INTRMSN_IN_TIME_IND	VARCHAR2	(1)	An indicator which specifies whether or not to count the duration of a student's intermission when checking the maximum time allowed to complete a course. Setting the checkbox includes the intermission period in the calculation of elapsed time.
INTRMSN_ALLOWED_IND	VARCHAR2	(1)	Indicates whether intermission is allowed for this course version.
COURSE_TYPE	VARCHAR2	(10)	An institution-defined course type. Course type indicates the type of higher education course. Each course type must map to a Government course type (DETYA element reference number 310). Examples are: HIGHER DOCTORATE, DIPLOMA, NON-AWARD COURSE.
CT_DESCRIPTION	VARCHAR2	(60)	A description of the institution-defined course type.
RESPONSIBLE_ORG_UNIT_CD	VARCHAR2	(30)	The unique code of the organisational unit responsible for this course version.
RESPONSIBLE_OU_START_DT	DATE		The start date of the organisational unit responsible for this course version.
OU_DESCRIPTION	VARCHAR2	(360)	The description of an organisational unit. An organisational unit is a business unit of an institution or organisation. Common organisational units in tertiary institutions are faculties, schools, departments and divisions. Each organisational unit must be assigned a start date, description, status, organisational type and member type. An institution code may be assigned to an organisational unit.
GOVT_SPECIAL_COURSE_TYPE	VARCHAR2	(2)	A code which identifies courses of special interest to DETYA, (element 312).
GSCT_DESCRIPTION	VARCHAR2	(60)	A description of the Government special course type.
QUALIFICATION_RECENCY	NUMBER		The time period (in years) for which other studies will be recognised for the purpose of granting advanced standing in this course.
EXTERNAL_ADV_STND_LIMIT	NUMBER		The maximum amount of advanced standing which can be granted in the course for studies undertaken outside the institution.
INTERNAL_ADV_STND_LIMIT	NUMBER		The maximum amount of advanced standing which can be granted in the course for studies undertaken at the institution.
CONTACT_HOURS	NUMBER		The minimum number of contact hours required for completion of the course.
CREDIT_POINTS_REQUIRED	NUMBER		The minimum number of credit points required to complete course requirements.
GOVT_COURSE_LOAD	NUMBER		The aggregate EFTSU value for a course, expressed in tenths, (e.g. 3.0 is represented as 30). DETYA element 350.
STD_ANNUAL_LOAD	NUMBER		Describes the load in credit points which a full-time student would normally study in a year if enrolled in the course. This is used to calculate the relative weighting of the units (EFTSU).
ANNUAL_INSTRUCTION_TIME	NUMBER		Annula Instruction Time of the program mesaured in weeks.
COURSE_TOTAL_EFTSU	NUMBER		The total EFTSU for the course.
STD_FT_COMPLETION_TIME	NUMBER		OBSOLETE. A DETYA code which indicates the standard time to complete therequirements of the course on a full-time basis (e.g. 30 = 3 years).Not in current use.
STD_PT_COMPLETION_TIME	NUMBER		OBSOLETE. A DETYA code which indicates the standard time to complete therequirements of the course on a part-time basis (e.g. 60 = 6 years).Not in current use.
MAX_INTRMSN_DURATION	NUMBER		COURSE_VERSION.MAX_INTRMSN_DURATION
NUM_OF_UNITS_BEFORE_INTRMSN	NUMBER		The number of units a student must complete before being allowed intermission.
MIN_SBMSN_PERCENTAGE	NUMBER		This field contains the percentage of the total effective full time days which must be attained prior to submission of a research thesis. This detail applies only to research courses.
MIN_CP_PER_CALENDAR	NUMBER
APPROVAL_DATE	DATE
EXTERNAL_APPROVAL_DATE	DATE
FEDERAL_FINANCIAL_AID	VARCHAR2	(1)
INSTITUTIONAL_FINANCIAL_AID	VARCHAR2	(1)
MAX_CP_PER_TEACHING_PERIOD	NUMBER
RESIDENCY_CP_REQUIRED	NUMBER
STATE_FINANCIAL_AID	VARCHAR2	(1)
PRIMARY_PROGRAM_RANK	NUMBER		Primary Program rank Lower the value, higher the rank for the program to be primary program
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
MAX_WLST_PER_STUD	NUMBER		Maximum waitlists allowed per student

Query Text

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


SELECT COURSE_CD
,      VERSION_NUMBER
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      START_DT
,      REVIEW_DT
,      EXPIRY_DT
,      END_DT
,      COURSE_STATUS
,      TITLE
,      SHORT_TITLE
,      ABBREVIATION
,      SUPP_EXAM_PERMITTED_IND
,      GENERIC_COURSE_IND
,      GRADUATE_STUDENTS_IND
,      COUNT_INTRMSN_IN_TIME_IND
,      INTRMSN_ALLOWED_IND
,      COURSE_TYPE
,      CT_DESCRIPTION
,      RESPONSIBLE_ORG_UNIT_CD
,      RESPONSIBLE_OU_START_DT
,      OU_DESCRIPTION
,      GOVT_SPECIAL_COURSE_TYPE
,      GSCT_DESCRIPTION
,      QUALIFICATION_RECENCY
,      EXTERNAL_ADV_STND_LIMIT
,      INTERNAL_ADV_STND_LIMIT
,      CONTACT_HOURS
,      CREDIT_POINTS_REQUIRED
,      GOVT_COURSE_LOAD
,      STD_ANNUAL_LOAD
,      ANNUAL_INSTRUCTION_TIME
,      COURSE_TOTAL_EFTSU
,      STD_FT_COMPLETION_TIME
,      STD_PT_COMPLETION_TIME
,      MAX_INTRMSN_DURATION
,      NUM_OF_UNITS_BEFORE_INTRMSN
,      MIN_SBMSN_PERCENTAGE
,      MIN_CP_PER_CALENDAR
,      APPROVAL_DATE
,      EXTERNAL_APPROVAL_DATE
,      FEDERAL_FINANCIAL_AID
,      INSTITUTIONAL_FINANCIAL_AID
,      MAX_CP_PER_TEACHING_PERIOD
,      RESIDENCY_CP_REQUIRED
,      STATE_FINANCIAL_AID
,      PRIMARY_PROGRAM_RANK
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MAX_WLST_PER_STUD
FROM APPS.IGS_PS_VER_HIST_V;

Dependencies

[top of page]

APPS.IGS_PS_VER_HIST_V references the following:

APPS: IGS_AU_GEN_002 - show dependent code; IGS_GE_DATE - show dependent code; IGS_GE_NUMBER - show dependent code; IGS_OR_INST_ORG_BASE_V; IGS_PS_GOVT_SPL_TYPE; IGS_PS_TYPE; IGS_PS_VER; IGS_PS_VER_HIST

APPS.IGS_PS_VER_HIST_V is not referenced by any database object