[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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). |
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;
IGS.IGS_PS_LGCY_UR_INT does not reference any database object
IGS.IGS_PS_LGCY_UR_INT is referenced by following:
|
|
|