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_DA_OUT_AUDT_DTL

Object Details

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

IGS_DA_OUT_AUDIT_DTL is for future use. --Obsolete

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_DA_OUT_AUDT_DTL_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	BATCH_ID PERSON_ID UNIT_SEQ_NUM OSS_UNIT_LOCATOR

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Unique ID for a request
PERSON_ID	NUMBER	(15)	Yes	Unique identifier for a person
UNIT_SEQ_NUM	NUMBER		Yes	Contains references to the unit sequence number in advanced standing, assessment or enrollment tables It is a programmatic sequence and is a part of the primary key.
OSS_UNIT_LOCATOR	VARCHAR2	(2)	Yes	OSS Unit Locator indicating where the data is coming from in OSS. Academic history, Advanced standing or Student unit attempts in enrollments, i.e. AH, EN, AS.
UNIT_SEQ_CODE	VARCHAR2	(3)		Unit Sequence Code
DA_COUNT	VARCHAR2	(1)		Count
UNIT_PSEUDO_UNIT_FLG	VARCHAR2	(1)		Indicates unit is a pseudounit
UNIT_EVAL_LOCK	VARCHAR2	(1)		Unit has been included in a transfer credit evaluation and decision is locked
DA_GROUP	VARCHAR2	(3)		Identifies grouping related to transfer evaluation decision and can assist in linking source units to transfer evaluation results
DPMASK	VARCHAR2	(20)		Degree program filter and can assist in linking source units to transfer evaluation results
ALT_UNIT_ID1	VARCHAR2	(15)		Transfer evaluation unit code decision supplement 1
ALT_UNIT_ID2	VARCHAR2	(15)		Transfer evaluation unit code decision supplement 2
ALT_UNIT_ID3	VARCHAR2	(15)		Transfer evaluation unit code decision supplement 3
ALT_UNIT_PSEUDOUNIT_FLAG1	VARCHAR2	(1)		Indicates alternate unit 1 is a pseudo unit
ALT_UNIT_PSEUDOUNIT_FLAG2	VARCHAR2	(1)		Indicates alternate unit 2 is a pseudo unit
ALT_UNIT_PSEUDOUNIT_FLAG3	VARCHAR2	(1)		Indicates alternate unit 3 is a pseudo unit
UNIT_FLAG1	VARCHAR2	(10)		Instructs action in third party software
UNIT_FLAG2	VARCHAR2	(10)		Instructs action in third party software.Unit Flag 2
UNIT_FLAG3	VARCHAR2	(10)		Instructs action in third party software .Unit Flag 3
UNIT_FLAG4	VARCHAR2	(10)		Instructs action in third party software.Unit Flag 4
UNIT_FLAG5	VARCHAR2	(10)		Instructs action in third party software.Unit Flag 5
DEG_AUD_UNIT_CODE1	VARCHAR2	(1)		Unit characteristic code
DEG_AUD_UNIT_CODE2	VARCHAR2	(1)		Unit characteristic code
DEG_AUD_UNIT_CODE3	VARCHAR2	(1)		Unit characteristic code
DEG_AUD_UNIT_CODE4	VARCHAR2	(1)		Unit characteristic code
DEG_AUD_UNIT_CODE5	VARCHAR2	(1)		Unit characteristic code
DEG_AUD_UNIT_CODE6	VARCHAR2	(1)		Unit characteristic code
DEG_AUD_UNIT_CODE7	VARCHAR2	(1)		Unit characteristic code
DEG_AUD_UNIT_CODE8	VARCHAR2	(1)		Unit characteristic code
DEG_AUD_UNIT_CODE9	VARCHAR2	(1)		Unit characteristic code
DEG_AUD_UNIT_CODE10	VARCHAR2	(1)		Unit characteristic code
DEG_AUD_UNIT_CODE11	VARCHAR2	(1)		Unit characteristic code
DEG_AUD_UNIT_CODE12	VARCHAR2	(1)		Unit characteristic code
DEG_AUD_COMMENTS	VARCHAR2	(255)		Degree Audit Comments
REF_INST_ID	VARCHAR2	(8)		Reference Institution Identification - id for transfer evaluations referenced institution.
REF_INST_CODE	VARCHAR2	(3)		Reference Institution Code - code which represents an alternate institition id and used in combination with reference institution id to further define transfer evaluations referenced institution
REF_TITLE	VARCHAR2	(30)		Title of transfer evaluations referenced institution
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT BATCH_ID
,      PERSON_ID
,      UNIT_SEQ_NUM
,      OSS_UNIT_LOCATOR
,      UNIT_SEQ_CODE
,      DA_COUNT
,      UNIT_PSEUDO_UNIT_FLG
,      UNIT_EVAL_LOCK
,      DA_GROUP
,      DPMASK
,      ALT_UNIT_ID1
,      ALT_UNIT_ID2
,      ALT_UNIT_ID3
,      ALT_UNIT_PSEUDOUNIT_FLAG1
,      ALT_UNIT_PSEUDOUNIT_FLAG2
,      ALT_UNIT_PSEUDOUNIT_FLAG3
,      UNIT_FLAG1
,      UNIT_FLAG2
,      UNIT_FLAG3
,      UNIT_FLAG4
,      UNIT_FLAG5
,      DEG_AUD_UNIT_CODE1
,      DEG_AUD_UNIT_CODE2
,      DEG_AUD_UNIT_CODE3
,      DEG_AUD_UNIT_CODE4
,      DEG_AUD_UNIT_CODE5
,      DEG_AUD_UNIT_CODE6
,      DEG_AUD_UNIT_CODE7
,      DEG_AUD_UNIT_CODE8
,      DEG_AUD_UNIT_CODE9
,      DEG_AUD_UNIT_CODE10
,      DEG_AUD_UNIT_CODE11
,      DEG_AUD_UNIT_CODE12
,      DEG_AUD_COMMENTS
,      REF_INST_ID
,      REF_INST_CODE
,      REF_TITLE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM IGS.IGS_DA_OUT_AUDT_DTL;

Dependencies

[top of page]

IGS.IGS_DA_OUT_AUDT_DTL does not reference any database object

IGS.IGS_DA_OUT_AUDT_DTL is referenced by following:

APPS: IGS_DA_OUT_AUDT_DTL