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_INS_INT

Object Details

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

Contains Unit Section Occurrence Instructor information to be imported into the IGS_PS_USEC_TCH_RESP and IGS_PS_USO_INSTRCTRS tables 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 Instructors
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_INS_INT_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	USO_INSTRUCTOR_INT_ID
IGS_PS_LGCY_INS_INT_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	UNIT_CD VERSION_NUMBER
IGS_PS_LGCY_INS_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. The following select statement can be used for getting the list of valid batch id values "Select batch_id from IGS_PS_LGCY_BAT_INT".
USO_INSTRUCTOR_INT_ID	NUMBER	(15)	Yes	Unique Identifier of Unit Section Occurrence Instructor Interface table.
INSTRUCTOR_PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number of Instructor.Validation while importing:Person number is valid one in the system. Person number corresponds to valid Instructor (i.e. person type of either 'STAFF' or 'FACULTY'.)
PRODUCTION_USO_ID	NUMBER	(10)		Unique Identifier of Unit Section Occurrence in Production Table (IGS_PS_USEC_OCCURS_ALL). If production unit section occurrence identifier is provided then no need to provide teaching calendar alternate code, location code , unit class, Sunday - Saturday, start time and end time. The following query can be used to get the valid unit section occurrence identifier. SELECT unit_section_occurrence_id FROM igs_ps_usec_occurs.
UNIT_CD	VARCHAR2	(10)	Yes	Code used to identify the unit. Used in the process of identifying the unit section occurrence uniquely in the system, if production unit section occurrence identifier is not provided.
VERSION_NUMBER	NUMBER	(3)	Yes	Version number is used to uniquely identify each version of a unit. Used in the process of identifying the unit section occurrence uniquely in the system, if production unit section occurrence identifier is not provided.
TEACH_CAL_ALTERNATE_CODE	VARCHAR2	(10)		Teaching Calendar alternate code that is passed in for the teaching period. Must be specified if Production unit section occurrence identifier is not provided. Used in the process of identifying the unit section occurrence uniquely in the system, if production unit section occurrence identifier is not provided. The following query can be used to get the valid teaching calendarsSELECT alternate_code FROM igs_ca_inst a, igs_ca_type b WHERE a.cal_type = b.cal_type AND b.s_cal_cat = 'TEACHING'
LOCATION_CD	VARCHAR2	(10)		Institution-defined location code, typically of a campus, at that a unit offering option is offered. Must be specified if Production unit section occurrence identifier is not provided. Used in the process of identifying the unit section occurrence uniquely in the system, if production unit section occurrence identifier is not provided. The following query can be used to get the valid location code SELECT location_cd FROM IGS_AD_LOCATION.
UNIT_CLASS	VARCHAR2	(10)		Institution-defined code that identifies a unit class. Must be specified if Production unit section occurrence identifier is not provided. Used in the process of identifying the unit section occurrence uniquely in the system, if production unit section occurrence identifier is not provided. The following query can be used to get the valid unit class SELECT unit_class FROM igs_as_unit_class.
MONDAY	VARCHAR2	(1)		No Longer Used
TUESDAY	VARCHAR2	(1)		No Longer Used
WEDNESDAY	VARCHAR2	(1)		No Longer Used
THURSDAY	VARCHAR2	(1)		No Longer Used
FRIDAY	VARCHAR2	(1)		No Longer Used
SATURDAY	VARCHAR2	(1)		No Longer Used
SUNDAY	VARCHAR2	(1)		No Longer Used
USO_START_DATE	DATE			No Longer Used
USO_END_DATE	DATE			No Longer Used
START_TIME	DATE			No Longer Used
END_TIME	DATE			No Longer Used
CONFIRMED_FLAG	VARCHAR2	(1)		Indicates instructor is confirmed for teaching responsibility. Can have value either 'Y' or 'N'. The workload for the faculty will only be counted if the confirmed flag is 'Y'.
WL_PERCENTAGE_ALLOCATION	NUMBER	(5)		Percentage workload allocated for the instructor. Can have value in the range of 0.00 to 100.00. If percentage allocation of workload is provided then instructional lecture, laboratory and other load will be calculated.
INSTRUCTIONAL_LOAD_LECTURE	NUMBER	(6)		Instructional workload for lecture on the instructor. Instructional lecture workload provided should not constitute to more than 100% allocation of workload.
INSTRUCTIONAL_LOAD_LABORATORY	NUMBER	(6)		Instructional workload for laboratory on the instructor. Instructional laboratory workload provided should not constitute to more than 100% allocation of workload.
INSTRUCTIONAL_LOAD_OTHER	NUMBER	(6)		Other Instructional workload on the instructor. Other Instructional workload provided should not constitute to more than 100% allocation of workload.
LEAD_INSTRUCTOR_FLAG	VARCHAR2	(1)		Lead instructor flag to indicate the instructor is lead instructor of unit section.
IMPORT_STATUS	VARCHAR2	(1)		Record's Import status, allowable values are 'U' - Unprocessed, '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.
NO_SET_DAY_IND	VARCHAR2	(1)		No Longer Used
OCCURRENCE_IDENTIFIER	VARCHAR2	(30)		Unique identity for an occurrence within a unit section.

Query Text

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


SELECT BATCH_ID
,      USO_INSTRUCTOR_INT_ID
,      INSTRUCTOR_PERSON_NUMBER
,      PRODUCTION_USO_ID
,      UNIT_CD
,      VERSION_NUMBER
,      TEACH_CAL_ALTERNATE_CODE
,      LOCATION_CD
,      UNIT_CLASS
,      MONDAY
,      TUESDAY
,      WEDNESDAY
,      THURSDAY
,      FRIDAY
,      SATURDAY
,      SUNDAY
,      USO_START_DATE
,      USO_END_DATE
,      START_TIME
,      END_TIME
,      CONFIRMED_FLAG
,      WL_PERCENTAGE_ALLOCATION
,      INSTRUCTIONAL_LOAD_LECTURE
,      INSTRUCTIONAL_LOAD_LABORATORY
,      INSTRUCTIONAL_LOAD_OTHER
,      LEAD_INSTRUCTOR_FLAG
,      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
,      NO_SET_DAY_IND
,      OCCURRENCE_IDENTIFIER
FROM IGS.IGS_PS_LGCY_INS_INT;

Dependencies

[top of page]

IGS.IGS_PS_LGCY_INS_INT does not reference any database object

IGS.IGS_PS_LGCY_INS_INT is referenced by following:

APPS: IGS_PS_LGCY_INS_INT