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_UR_INT

Object Details

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

Contains Unit Version, Unit Section or Unit Section Occurrence reference codes to be imported into the IGS_PS_UNIT_REF_CD, IGS_PS_USEC_REF_CD or IGS_PS_USEC_OCUR_REF 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 Reference Code
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_UR_INT_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	UNIT_REFERENCE_INT_ID
IGS_PS_LGCY_UR_INT_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	UNIT_CD VERSION_NUMBER
IGS_PS_LGCY_UR_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_REFERENCE_INT_ID	NUMBER	(15)	Yes	Unique identifier of the Legacy Unit Reference 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.
DATA_TYPE	VARCHAR2	(10)	Yes	Indicator to tell the process where the reference is to be loaded. Must be one of:'UNIT','SECTION' and 'OCCURRENCE'
TEACH_CAL_ALTERNATE_CODE	VARCHAR2	(10)		Teaching Calendar alternate code that is passed in for the teaching period. Must be specified if the data type is not UNIT.
LOCATION_CD	VARCHAR2	(10)		Institution-defined location code, typically of a campus, at that a unit offering option is offered. Must be specified if the data type is not UNIT.
UNIT_CLASS	VARCHAR2	(10)		Institution-defined code that identifies a unit class. Must be specified if the data type is not UNIT.
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
START_TIME	DATE			No Longer Used
END_TIME	DATE			No Longer Used
REFERENCE_CD_TYPE	VARCHAR2	(10)	Yes	Type or classification of a system unit reference code.
REFERENCE_CD	VARCHAR2	(30)	Yes	System reference code for a unit. For example, an Interactive Voice Response System code used to represent a unit.
DESCRIPTION	VARCHAR2	(60)		Description, or name, of the unit reference code.
IMPORT_STATUS	VARCHAR2	(1)		Record's Import status, allowable values are 'U'-Unprocessed(Default), 'R'-Ready for Reprocessing, 'E'-Error, 'W'-Warning, 'I'-Imported
USO_START_DATE	DATE			No Longer Used
USO_END_DATE	DATE			No Longer Used
NO_SET_DAY_IND	VARCHAR2	(1)		No Longer Used
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.
GEN_REF_FLAG	VARCHAR2	(1)		Flag to indicate the reference code is general reference code or specific (unit or unit section) requirements reference code. If the value is 'Y' then it is a generic reference code otherwise it is a specific (unit or unit section) reference code. If the value is not provided the legacy API considers its value as 'Y'.
OCCURRENCE_IDENTIFIER	VARCHAR2	(30)		Unique identity for an occurrence within a unit section.
PRODUCTION_USO_ID	NUMBER	(10)		Unique Identifier of Unit Section Occurrence in Production Table (IGS_PS_USEC_OCCURS_ALL).

Query Text

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


SELECT BATCH_ID
,      UNIT_REFERENCE_INT_ID
,      UNIT_CD
,      VERSION_NUMBER
,      DATA_TYPE
,      TEACH_CAL_ALTERNATE_CODE
,      LOCATION_CD
,      UNIT_CLASS
,      MONDAY
,      TUESDAY
,      WEDNESDAY
,      THURSDAY
,      FRIDAY
,      SATURDAY
,      SUNDAY
,      START_TIME
,      END_TIME
,      REFERENCE_CD_TYPE
,      REFERENCE_CD
,      DESCRIPTION
,      IMPORT_STATUS
,      USO_START_DATE
,      USO_END_DATE
,      NO_SET_DAY_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GEN_REF_FLAG
,      OCCURRENCE_IDENTIFIER
,      PRODUCTION_USO_ID
FROM IGS.IGS_PS_LGCY_UR_INT;

Dependencies

[top of page]

IGS.IGS_PS_LGCY_UR_INT does not reference any database object

IGS.IGS_PS_LGCY_UR_INT is referenced by following:

APPS: IGS_PS_LGCY_UR_INT