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_US_INT

Object Details

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

Contains Unit Section information to be imported into the IGS_PS_UNIT_OFR_OPT_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 Section
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_US_INT_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	UNIT_SECTION_INT_ID
IGS_PS_LGCY_US_INT_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	UNIT_CD VERSION_NUMBER
IGS_PS_LGCY_US_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_SECTION_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.
TEACH_CAL_ALTERNATE_CODE	VARCHAR2	(10)	Yes	Teaching Calendar alternate code that is passed in for the teaching period.
LOCATION_CD	VARCHAR2	(10)	Yes	Institution-defined location code, typically of a campus, at that a unit offering option is offered.
UNIT_CLASS	VARCHAR2	(10)	Yes	Institution-defined code that identifies a unit class. Also used to identify the unit section code.
CALL_NUMBER	NUMBER			This is a unique identifier needed to support Interactive Voice Response registration.
IVRS_AVAILABLE_IND	VARCHAR2	(1)		Unique identifier needed to support Interactive Voice Response System registration.
UNIT_SECTION_STATUS	VARCHAR2	(30)	Yes	Status of unit section. E.g. Cancelled, Closed, Hold and Open.
UNIT_SECTION_START_DATE	DATE			Start date of unit section is specified.
UNIT_SECTION_END_DATE	DATE			End date of unit section is specified.
OFFERED_IND	VARCHAR2	(1)		Indicator that specifies whether the unit offering option is available for offering. Setting the checkbox ticked makes the offering available.
STATE_FINANCIAL_AID	VARCHAR2	(1)		Indicator for eligibility of the unit section to qualify for state financial aid funding
FEDERAL_FINANCIAL_AID	VARCHAR2	(1)		Indicator for eligibility of the unit section to qualify for federal financial aid funding
GRADING_SCHEMA_PRCDNCE_IND	VARCHAR2	(1)		Indicator that specifies whether any grading schema attached to the unit offering option takes precedence over the grading schema attached to the enrolled student's program offering.
UNIT_QUOTA	NUMBER	(6)		An enrollment quota that restricts the number of students who might be enrolled in a particular unit offering.
UNIT_QUOTA_RESERVED_PLACES	NUMBER	(6)		Subset of the enrollment quota that is presently reserved.
INSTITUTIONAL_FINANCIAL_AID	VARCHAR2	(1)		Indicator for eligibility of the unit section to qualify for institutional financial aid funding.
GRADING_SCHEMA_CD	VARCHAR2	(10)		The code that identifies the grading schema. A grading schema describes the set of available marks and grades, which can be used in the assessment of student unit attempts. There may be multiple grading schemas for any one institution.
GS_VERSION_NUMBER	NUMBER	(3)		Version Number of the grading schema.
UNIT_CONTACT_NUMBER	VARCHAR2	(30)		Person identification number of a staff member who is the contact for a particular unit offering.
SS_ENROL_IND	VARCHAR2	(1)		Self Service Enrollment Indicator
OWNER_ORG_UNIT_CD	VARCHAR2	(30)		The responsible organization unit for the unit section.
ATTENDANCE_REQUIRED_IND	VARCHAR2	(1)		Indicator to control the unit sections for which Attendance self service roster are produced for faculty to enter/report Attendance Hours as per the date aliases set in Academic Records.
RESERVED_SEATING_ALLOWED	VARCHAR2	(1)		If value is 'Y' then Reserved seating will be allowed otherwise Reserved seating will not be allowed.
SPECIAL_PERMISSION_IND	VARCHAR2	(1)		Indicates if special permission is required for the unit.
SS_DISPLAY_IND	VARCHAR2	(1)		Excludes unit from displaying in unit search windows in self service enrollments.
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.
ANON_UNIT_GRADING_IND	VARCHAR2	(1)		Indicates whether anonymous unit grading is applicable to the unit section .
ANON_ASSESS_GRADING_IND	VARCHAR2	(1)		Indicates whether anonymous assessment item grading is applicable to the unit section.
NON_STD_USEC_IND	VARCHAR2	(1)		Indicates whether the Unit Section is Standard or Non Standard
AUDITABLE_IND	VARCHAR2	(1)		Indicates if the unit section can be audited.
AUDIT_PERMISSION_IND	VARCHAR2	(1)		Indicates whether permission is required for auditing.
WAITLIST_ALLOWED	VARCHAR2	(1)		Indicator to show whether waitlist is allowed for the unit or not.
MAX_STUDENTS_PER_WAITLIST	NUMBER	(6)		Maximum number of students who can be waitlisted is shown.
MINIMUM_CREDIT_POINTS	NUMBER	(6)		Minimum credit points
MAXIMUM_CREDIT_POINTS	NUMBER	(6)		Maximum credit points
VARIABLE_INCREMENT	NUMBER	(6)		Variable increment of credit points
LECTURE_CREDIT_POINTS	NUMBER	(6)		Lecture credit points.
LAB_CREDIT_POINTS	NUMBER	(6)		Laboratory credit points.
OTHER_CREDIT_POINTS	NUMBER	(6)		Any other credit points.
CLOCK_HOURS	NUMBER	(6)		Number of clock hours.
WORK_LOAD_CP_LECTURE	NUMBER	(6)		Work load credit points on lecture
WORK_LOAD_CP_LAB	NUMBER	(6)		Work load credit point for laboratory.
CONTINUING_EDUCATION_UNITS	NUMBER	(6)		Units for continuing education.
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.
CLAIMABLE_HOURS	NUMBER	(7)		The maximum hours that a student in a class can claim.
REFERENCE_SHORT_TITLE	VARCHAR2	(40)		Short title for unit section reference.
REFERENCE_SUBTITLE_MOD_FLAG	VARCHAR2	(1)		Subtitle modifiable flag for unit section.
REFERENCE_CLASS_SCH_EXCL_FLAG	VARCHAR2	(1)		Class schedule exclusion flag for the unit section.
REFERENCE_REC_EXCLUSION_FLAG	VARCHAR2	(1)		Exclude unit section from displaying in self service records windows and on transcripts and exclude unit section from Grade Point Average calculation.
REFERENCE_TITLE	VARCHAR2	(90)		Title for the unit section.
REFERENCE_SUBTITLE	VARCHAR2	(80)		Subtitle of the unit section.
REFERENCE_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column.
REFERENCE_ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment.
REFERENCE_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.
ENROLLMENT_EXPECTED	NUMBER	(6)		Expected number of enrollments.Validations performed while importing:Inherits from unit level if not provided (i.e., Enrollment Expected of this unit version).
ENROLLMENT_MINIMUM	NUMBER	(6)		Minimum number of enrollments.Validations performed while importing:Inherits from unit level if not provided (i.e., Enrollment Minimum of this unit version).Enrollment Minimum should not be greater than Enrollment Maximum.
ENROLLMENT_MAXIMUM	NUMBER	(6)		Maximum number of enrollments.Validations performed while importing:Inherits from unit level if not provided (i.e., Enrollment Maximum of this unit version).Enrollment Minimum should not be greater than Enrollment Maximum Enrollment Maximum should not be greater than Override Enrollment Maximum Advance Maximum should not be greater than Enrollment Maximum Actual Enrollment of unit section should not be greater than Enrollment Maximum. If enrollment maximum is null then override maximum should be null.
ADVANCE_MAXIMUM	NUMBER	(6)		Maximum number of advance enrollments.Validations performed while importing:Inherits from unit level if not provided. (i.e., Advance Maximum of this unit version). Advance Maximum should not be greater than Enrollment Maximum.
USEC_WAITLIST_ALLOWED	VARCHAR2	(1)		Waitlist allowed indicator.Validations performed while importing:Inherits from unit offering pattern level if not provided (i.e., waitlist allowed of this unit offering pattern). Waitlist can be allowed at unit section level only if it is allowed at unit offering pattern level. Maximum Students Per Waitlist is defaulted to zero if waitlist is not allowed for unit section. If waitlist is allowed then maximum students per waitlist should be greater then actual waitlist.
USEC_MAX_STUDENTS_PER_WAITLIST	NUMBER	(6)		Maximum number of students per waitlist. Validations performed while importing:Inherits from unit offering pattern level if not provided (i.e., Maximum number of students per waitlist of this unit offering pattern). Maximum Students Per Waitlist is defaulted to zero if waitlist is not allowed for unit section. If waitlist is allowed then maximum students per waitlist should be greater then unit section actual waitlist.
OVERRIDE_ENROLLMENT_MAXIMUM	NUMBER	(6)		This field stores the value till which the actual enrollment can increase without requiring that the maximum enrollment be increased. Validations performed while importing:Inherits from unit level if not provided. (i.e., Override Enrollment Maximum of this unit version). Enrollment Maximum should not be greater than Override Enrollment Maximum. Unit Section Actual Enrollment should not be greater than Override Enrollment Maximum if enrollment maximum is null then override maximum should be null.
MAX_AUDITORS_ALLOWED	NUMBER	(6)		Indicates maximum number of auditors allowed. Validations performed while importing:Inherits from unit level if not provided. (i.e., Maximum Auditors Allowed of this unit version). Maximum auditors allowed should be null If the unit section is not auditable.
ACHIEVABLE_CREDIT_POINTS	NUMBER	(6)		Number of credit points awarded upon successful completion of the unit section.
ENROLLED_CREDIT_POINTS	NUMBER	(6)		Number of credit points in which the student is considered to be enrolled.
NOT_MULTIPLE_SECTION_FLAG	VARCHAR2	(1)		Indicating whether this unit section should be excluded from multiple unit section.
SUP_UNIT_CD	VARCHAR2	(10)		Unit code for the superior unit section.
SUP_VERSION_NUMBER	NUMBER			Unit version number for the superior unit section.
SUP_TEACH_CAL_ALTERNATE_CODE	VARCHAR2	(10)		Teaching calendar alternate code for the superior unit section.
SUP_LOCATION_CD	VARCHAR2	(10)		Location code for the superior unit section.
SUP_UNIT_CLASS	VARCHAR2	(10)		Unit Class for the superior unit section.
DEFAULT_ENROLL_FLAG	VARCHAR2	(1)		Indicate whether to enroll the subordinate unit section when the superior unit section is enrolled.
BILLING_CREDIT_POINTS	NUMBER			Audit Credit Points
BILLING_HRS	NUMBER			Billable Credit Points

Query Text

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


SELECT BATCH_ID
,      UNIT_SECTION_INT_ID
,      UNIT_CD
,      VERSION_NUMBER
,      TEACH_CAL_ALTERNATE_CODE
,      LOCATION_CD
,      UNIT_CLASS
,      CALL_NUMBER
,      IVRS_AVAILABLE_IND
,      UNIT_SECTION_STATUS
,      UNIT_SECTION_START_DATE
,      UNIT_SECTION_END_DATE
,      OFFERED_IND
,      STATE_FINANCIAL_AID
,      FEDERAL_FINANCIAL_AID
,      GRADING_SCHEMA_PRCDNCE_IND
,      UNIT_QUOTA
,      UNIT_QUOTA_RESERVED_PLACES
,      INSTITUTIONAL_FINANCIAL_AID
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      UNIT_CONTACT_NUMBER
,      SS_ENROL_IND
,      OWNER_ORG_UNIT_CD
,      ATTENDANCE_REQUIRED_IND
,      RESERVED_SEATING_ALLOWED
,      SPECIAL_PERMISSION_IND
,      SS_DISPLAY_IND
,      REV_ACCOUNT_CD
,      ANON_UNIT_GRADING_IND
,      ANON_ASSESS_GRADING_IND
,      NON_STD_USEC_IND
,      AUDITABLE_IND
,      AUDIT_PERMISSION_IND
,      WAITLIST_ALLOWED
,      MAX_STUDENTS_PER_WAITLIST
,      MINIMUM_CREDIT_POINTS
,      MAXIMUM_CREDIT_POINTS
,      VARIABLE_INCREMENT
,      LECTURE_CREDIT_POINTS
,      LAB_CREDIT_POINTS
,      OTHER_CREDIT_POINTS
,      CLOCK_HOURS
,      WORK_LOAD_CP_LECTURE
,      WORK_LOAD_CP_LAB
,      CONTINUING_EDUCATION_UNITS
,      WORK_LOAD_OTHER
,      CONTACT_HRS_LECTURE
,      CONTACT_HRS_LAB
,      CONTACT_HRS_OTHER
,      NON_SCHD_REQUIRED_HRS
,      EXCLUDE_FROM_MAX_CP_LIMIT
,      CLAIMABLE_HOURS
,      REFERENCE_SHORT_TITLE
,      REFERENCE_SUBTITLE_MOD_FLAG
,      REFERENCE_CLASS_SCH_EXCL_FLAG
,      REFERENCE_REC_EXCLUSION_FLAG
,      REFERENCE_TITLE
,      REFERENCE_SUBTITLE
,      REFERENCE_ATTRIBUTE_CATEGORY
,      REFERENCE_ATTRIBUTE1
,      REFERENCE_ATTRIBUTE2
,      REFERENCE_ATTRIBUTE3
,      REFERENCE_ATTRIBUTE4
,      REFERENCE_ATTRIBUTE5
,      REFERENCE_ATTRIBUTE6
,      REFERENCE_ATTRIBUTE7
,      REFERENCE_ATTRIBUTE8
,      REFERENCE_ATTRIBUTE9
,      REFERENCE_ATTRIBUTE10
,      REFERENCE_ATTRIBUTE11
,      REFERENCE_ATTRIBUTE12
,      REFERENCE_ATTRIBUTE13
,      REFERENCE_ATTRIBUTE14
,      REFERENCE_ATTRIBUTE15
,      REFERENCE_ATTRIBUTE16
,      REFERENCE_ATTRIBUTE17
,      REFERENCE_ATTRIBUTE18
,      REFERENCE_ATTRIBUTE19
,      REFERENCE_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
,      ENROLLMENT_EXPECTED
,      ENROLLMENT_MINIMUM
,      ENROLLMENT_MAXIMUM
,      ADVANCE_MAXIMUM
,      USEC_WAITLIST_ALLOWED
,      USEC_MAX_STUDENTS_PER_WAITLIST
,      OVERRIDE_ENROLLMENT_MAXIMUM
,      MAX_AUDITORS_ALLOWED
,      ACHIEVABLE_CREDIT_POINTS
,      ENROLLED_CREDIT_POINTS
,      NOT_MULTIPLE_SECTION_FLAG
,      SUP_UNIT_CD
,      SUP_VERSION_NUMBER
,      SUP_TEACH_CAL_ALTERNATE_CODE
,      SUP_LOCATION_CD
,      SUP_UNIT_CLASS
,      DEFAULT_ENROLL_FLAG
,      BILLING_CREDIT_POINTS
,      BILLING_HRS
FROM IGS.IGS_PS_LGCY_US_INT;

Dependencies

[top of page]

IGS.IGS_PS_LGCY_US_INT does not reference any database object

IGS.IGS_PS_LGCY_US_INT is referenced by following:

APPS: IGS_PS_LGCY_US_INT