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_PS_LGCY_UV_INT

Object Details

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

Contains Unit Versions to be imported into the IGS_PS_UNIT_VER_ALL table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_PS_LGCY_BAT_INT table.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Legacy Unit
Category: BUSINESS_ENTITY IGS_UNIT

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PS_LGCY_UV_INT_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	UNIT_VERSION_INT_ID
IGS_PS_LGCY_UV_INT_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	UNIT_CD VERSION_NUMBER
IGS_PS_LGCY_UV_INT_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	IMPORT_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(15)	Yes	Batch Identifier, used to identify the set of records to be processed.
UNIT_VERSION_INT_ID	NUMBER	(15)	Yes	Unique identifier of the Legacy Unit Version Interface Table.
UNIT_CD	VARCHAR2	(10)	Yes	Code used to identify a unit.
VERSION_NUMBER	NUMBER	(3)	Yes	Version Number is used to uniquely identify each version of a unit.
START_DT	DATE		Yes	Date on that this version of the unit became current.
REVIEW_DT	DATE			Date on that this version of the unit is due for review.
EXPIRY_DT	DATE			Date on that the unit version expires. Students already studying this unit version may remain enrolled. No further enrollments are normally allowable.
END_DT	DATE			Date on that this version of the unit ends. No students can remain enrolled in unit after its end date has been reached.
UNIT_STATUS	VARCHAR2	(10)	Yes	Institution-defined status of a unit that maps to a system unit status.
TITLE	VARCHAR2	(90)	Yes	Title of the unit.
SHORT_TITLE	VARCHAR2	(40)	Yes	Short name of the unit.
TITLE_OVERRIDE_IND	VARCHAR2	(1)		Indicator that specifies whether the title of the unit can be overridden at the student unit attempt level. Setting the checkbox ticked allows the title to be overridden.
ABBREVIATION	VARCHAR2	(20)		Abbreviated name of the unit.
UNIT_LEVEL	VARCHAR2	(4)	Yes	Normal year level of the unit.
CREDIT_POINT_DESCRIPTOR	VARCHAR2	(30)	Yes	Institution's name for credit points.
SUPP_EXAM_PERMITTED_IND	VARCHAR2	(1)		Indicator that specifies whether a supplementary examination or other supplementary assessment can be granted in this unit. Setting the checkbox ticked allows supplementary assessment to be granted.
COORD_PERSON_NUMBER	VARCHAR2	(30)	Yes	Person number of the unit coordinator used to select the person id for the coordinator.
OWNER_ORG_UNIT_CD	VARCHAR2	(30)	Yes	Code of the organizational unit that owns the unit.
AWARD_COURSE_ONLY_IND	VARCHAR2	(1)		Indicator that specifies whether the unit is available only to award program students. Setting the checkbox ticked restricts enrollment to award program students.
RESEARCH_UNIT_IND	VARCHAR2	(1)		Indicator that specifies whether the unit is classified as a research unit. Setting the checkbox ticked classifies the unit as research. Research units are normally only available to students enrolled in research programs.
SUB_UNIT_ALLOWED_IND	VARCHAR2	(1)		Indicator that specifies whether this unit can be classified as a sub-unit in a superior or sub-unit relationship. Setting the checkbox ticked allows the unit to be a sub-unit. Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_DP2.doc - Obsolete
SUP_UNIT_ALLOWED_IND	VARCHAR2	(1)		Indicator that specifies whether this unit can be classified as a superior unit in a superior or sub-unit relationship. Setting the checkbox ticked allows the unit to be a superior unit. Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_DP2.doc - Obsolete
INDUSTRIAL_IND	VARCHAR2	(1)		Indicator that specifies whether this unit is classified as an industrial experience unit.
PRACTICAL_IND	VARCHAR2	(1)		Indicator that specifies whether this unit is classified as a practical experience unit.
REPEATABLE_IND	VARCHAR2	(1)		Indicator that specifies whether the unit can count more than once towards the satisfaction of program requirements. Setting the checkbox ticked enables a student to repeat an already passed unit.
ASSESSABLE_IND	VARCHAR2	(1)		Indicator that specifies whether the unit is assessed. Setting the checkbox ticked indicates that the unit is assessed.
ACHIEVABLE_CREDIT_POINTS	NUMBER	(6)		Number of credit points awarded upon successful completion of the unit.
ENROLLED_CREDIT_POINTS	NUMBER	(6)	Yes	Number of credit points in that the student is considered to be enrolled.
POINTS_OVERRIDE_IND	VARCHAR2	(1)		Indicator that specifies whether it is possible to override the number of credit points awarded upon successful completion on the unit. Setting the checkbox ticked allows the enrolled credit points and the enrolled EFTSU to be overridden.
POINTS_INCREMENT	NUMBER	(6)		If the override credit points indicator is set , this field records the allowable credit point increment.
POINTS_MIN	NUMBER	(6)		If the override credits points indicator is set , this field records the minimum number of credit points that can be awarded upon successful completion of the unit.
POINTS_MAX	NUMBER	(6)		If the override credits points indicator is set , this field records the maximum number of credit points that can be awarded upon successful completion of the unit.
UNIT_INT_COURSE_LEVEL_CD	VARCHAR2	(10)		Internal program level grouping of the unit.
SUBTITLE	VARCHAR2	(90)		Another title for the unit.
SUBTITLE_APPROVED_IND	VARCHAR2	(1)		Official subtitle that has been approved by the institution or an organizational unit.
SUBTITLE_CLOSED_IND	VARCHAR2	(1)		The subtitle is available for use or not.
SUBTITLE_MODIFIABLE_FLAG	VARCHAR2	(1)		Sub Title modifiable indicator.
APPROVAL_DATE	DATE			Approval date.
LECTURE_CREDIT_POINTS	NUMBER	(6)		Lecture credit points.
LAB_CREDIT_POINTS	NUMBER	(6)		Laboratory credit points.
OTHER_CREDIT_POINTS	NUMBER	(6)		Other credit points.
CLOCK_HOURS	NUMBER	(6)		Clock hours.
WORK_LOAD_CP_LECTURE	NUMBER	(6)		Lecture work load credit point
WORK_LOAD_CP_LAB	NUMBER	(6)		Lab wok load credit points.
CONTINUING_EDUCATION_UNITS	NUMBER	(6)		Continuing education units.
ENROLLMENT_EXPECTED	NUMBER	(6)		Expected enrollment
ENROLLMENT_MINIMUM	NUMBER	(6)		Minimum enrollment.
ENROLLMENT_MAXIMUM	NUMBER	(6)		Maximum enrollment.
ADVANCE_MAXIMUM	NUMBER	(6)		Maximum waitlist in advance
STATE_FINANCIAL_AID	VARCHAR2	(1)		State financial aid.
FEDERAL_FINANCIAL_AID	VARCHAR2	(1)		Federal financial aid.
INSTITUTIONAL_FINANCIAL_AID	VARCHAR2	(1)		Institutional financial aid
SAME_TEACHING_PERIOD	VARCHAR2	(1)		Same teaching period indicator
MAX_REPEATS_FOR_CREDIT	NUMBER	(3)		Number of maximum repeats for credits.
MAX_REPEATS_FOR_FUNDING	NUMBER	(3)		Number of maximum repeats for funding
MAX_REPEAT_CREDIT_POINTS	NUMBER	(5)		Maximum repeat credit points
SAME_TEACH_PERIOD_REPEATS	NUMBER	(3)		Same teaching period repeats
SAME_TEACH_PERIOD_REPEATS_CP	NUMBER	(5)		Same teaching period repeats credit points.
IVR_ENROL_IND	VARCHAR2	(1)		Interactive Voice Response Enrollment Indicator
SS_ENROL_IND	VARCHAR2	(1)		Self Service Enrollment Indicator
WORK_LOAD_OTHER	NUMBER	(5)		Work load for any component other than lecture and laboratory.
CONTACT_HRS_LECTURE	NUMBER	(5)		Contact hours for Lecture.
CONTACT_HRS_LAB	NUMBER	(5)		Contact hours for Laboratory
CONTACT_HRS_OTHER	NUMBER	(5)		Contact hours for any component other than lecture and laboratory.
NON_SCHD_REQUIRED_HRS	NUMBER	(5)		Non Scheduled Required Hours
EXCLUDE_FROM_MAX_CP_LIMIT	VARCHAR2	(1)		Exclude a unit's achievable credit points from counting in a student's maximum credit point's limit.
RECORD_EXCLUSION_FLAG	VARCHAR2	(1)		Excludes unit from displaying in self service records window and on transcripts, and excludes unit from Grade Point Average calculations.
SS_DISPLAY_IND	VARCHAR2	(1)		Excludes unit from displaying in unit search windows in self service enrollments.
ENROL_LOAD_ALT_CD	VARCHAR2	(10)		Load Calendar alternate code that is passed in for the last enrolled period.
OFFER_LOAD_ALT_CD	VARCHAR2	(10)		Load Calendar alternate code that is passed in for the last period that this unit was offered.
CURRICULUM_ID	VARCHAR2	(10)		Links different version of unit when then unit code changes. Also required for mandated reporting by some states.
CURRICULUM_DESCRIPTION	VARCHAR2	(80)		The description for the curriculum id.
CURRICULUM_CLOSED_IND	VARCHAR2	(1)		This indicates id curriculum id is available for use or not.
OVERRIDE_ENROLLMENT_MAX	NUMBER	(6)		This field stores the value till which the actual enrollment can increase without requiring that the maximum enrollment be increased.
REPEAT_CODE	VARCHAR2	(10)		Indicates the repeat family to which the unit belongs.
LEVEL_CODE	VARCHAR2	(10)		Indicates the unit type level to which unit may be assigned.
SPECIAL_PERMISSION_IND	VARCHAR2	(1)		Indicates if special permission is required for the unit
REV_ACCOUNT_CD	VARCHAR2	(40)		Revenue Account Code (An alpha numeric string). It is populated with the revenue account code when GL is not installed and system uses any other external account systems.
CLAIMABLE_HOURS	NUMBER	(7)		The maximum hours that a student in a class can claim.
ANON_UNIT_GRADING_IND	VARCHAR2	(1)		Anonymous Unit Grading
ANON_ASSESS_GRADING_IND	VARCHAR2	(1)		Anonymous Assessment Item Grading
AUDITABLE_IND	VARCHAR2	(1)		Indicates if a unit can be audited.
MAX_AUDITORS_ALLOWED	NUMBER	(6)		Indicates maximum number of allowed auditors.
AUDIT_PERMISSION_IND	VARCHAR2	(1)		Indicates if permitted to audit.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column. If entered the category must already exist.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment.
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment.
IMPORT_STATUS	VARCHAR2	(1)		Record's Import status, allowable values are 'U'-Unprocessed(Default), 'R'-Ready for Reprocessing, 'E'-Error, 'W'-Warning, 'I'-Imported
CREATED_BY	NUMBER	(15)		Standard WHO columns.
CREATION_DATE	DATE			Standard WHO columns.
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO columns.
LAST_UPDATE_DATE	DATE			Standard WHO columns.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO columns.
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program.
BILLING_CREDIT_POINTS	NUMBER			Audit Credit Points
OVRD_WKLD_VAL_FLAG	VARCHAR2	(1)		Override workload validation flag
WORKLOAD_VAL_CODE	VARCHAR2	(30)		Workload validation type. SELECT lookup_code from igs_lookup_Values WHERE lookup_type = 'WKLD_VAL_TYPE'
BILLING_HRS	NUMBER			Billable Credit Points

Query Text

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


SELECT BATCH_ID
,      UNIT_VERSION_INT_ID
,      UNIT_CD
,      VERSION_NUMBER
,      START_DT
,      REVIEW_DT
,      EXPIRY_DT
,      END_DT
,      UNIT_STATUS
,      TITLE
,      SHORT_TITLE
,      TITLE_OVERRIDE_IND
,      ABBREVIATION
,      UNIT_LEVEL
,      CREDIT_POINT_DESCRIPTOR
,      SUPP_EXAM_PERMITTED_IND
,      COORD_PERSON_NUMBER
,      OWNER_ORG_UNIT_CD
,      AWARD_COURSE_ONLY_IND
,      RESEARCH_UNIT_IND
,      SUB_UNIT_ALLOWED_IND
,      SUP_UNIT_ALLOWED_IND
,      INDUSTRIAL_IND
,      PRACTICAL_IND
,      REPEATABLE_IND
,      ASSESSABLE_IND
,      ACHIEVABLE_CREDIT_POINTS
,      ENROLLED_CREDIT_POINTS
,      POINTS_OVERRIDE_IND
,      POINTS_INCREMENT
,      POINTS_MIN
,      POINTS_MAX
,      UNIT_INT_COURSE_LEVEL_CD
,      SUBTITLE
,      SUBTITLE_APPROVED_IND
,      SUBTITLE_CLOSED_IND
,      SUBTITLE_MODIFIABLE_FLAG
,      APPROVAL_DATE
,      LECTURE_CREDIT_POINTS
,      LAB_CREDIT_POINTS
,      OTHER_CREDIT_POINTS
,      CLOCK_HOURS
,      WORK_LOAD_CP_LECTURE
,      WORK_LOAD_CP_LAB
,      CONTINUING_EDUCATION_UNITS
,      ENROLLMENT_EXPECTED
,      ENROLLMENT_MINIMUM
,      ENROLLMENT_MAXIMUM
,      ADVANCE_MAXIMUM
,      STATE_FINANCIAL_AID
,      FEDERAL_FINANCIAL_AID
,      INSTITUTIONAL_FINANCIAL_AID
,      SAME_TEACHING_PERIOD
,      MAX_REPEATS_FOR_CREDIT
,      MAX_REPEATS_FOR_FUNDING
,      MAX_REPEAT_CREDIT_POINTS
,      SAME_TEACH_PERIOD_REPEATS
,      SAME_TEACH_PERIOD_REPEATS_CP
,      IVR_ENROL_IND
,      SS_ENROL_IND
,      WORK_LOAD_OTHER
,      CONTACT_HRS_LECTURE
,      CONTACT_HRS_LAB
,      CONTACT_HRS_OTHER
,      NON_SCHD_REQUIRED_HRS
,      EXCLUDE_FROM_MAX_CP_LIMIT
,      RECORD_EXCLUSION_FLAG
,      SS_DISPLAY_IND
,      ENROL_LOAD_ALT_CD
,      OFFER_LOAD_ALT_CD
,      CURRICULUM_ID
,      CURRICULUM_DESCRIPTION
,      CURRICULUM_CLOSED_IND
,      OVERRIDE_ENROLLMENT_MAX
,      REPEAT_CODE
,      LEVEL_CODE
,      SPECIAL_PERMISSION_IND
,      REV_ACCOUNT_CD
,      CLAIMABLE_HOURS
,      ANON_UNIT_GRADING_IND
,      ANON_ASSESS_GRADING_IND
,      AUDITABLE_IND
,      MAX_AUDITORS_ALLOWED
,      AUDIT_PERMISSION_IND
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      IMPORT_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      BILLING_CREDIT_POINTS
,      OVRD_WKLD_VAL_FLAG
,      WORKLOAD_VAL_CODE
,      BILLING_HRS
FROM IGS.IGS_PS_LGCY_UV_INT;

Dependencies

[top of page]

IGS.IGS_PS_LGCY_UV_INT does not reference any database object

IGS.IGS_PS_LGCY_UV_INT is referenced by following:

APPS: IGS_PS_LGCY_UV_INT