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_IN_RSLT_UNTS

Object Details

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

Storage for the Resulting Unit information from the 3rd party about Units for the Students in the Degree Audit Request. --Obsolete

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_DA_IN_RSLT_UNTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RSLT_UNIT_ID
IGS_DA_IN_RSLT_UNTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID PERSON_ID

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
RSLT_UNIT_ID	NUMBER		Yes	Sequence number generated by the third party software which assists in linking the information below to the correct result unit generated by the third party software
RESLT_UNIT_GROUP	VARCHAR2	(3)	Yes	Grouping number assigned by the third party software which is associated with the transfer evaluation's result unit code/version. Assists in linking the transfer evaluation source and result units. This value will be stored in the degree audit details linked to Advanced Standing
RESLT_UNIT_DPMASK	VARCHAR2	(20)	Yes	Degree program filter assigned by the third party software which is associated with the transfer evaluation's result unit code/ version. Assists in linking the transfer evaluation's source and result units. This value will be store in the degree audit details linked to Advanced Standing.
RESLT_UNIT_INST_ID	VARCHAR2	(30)		Id of the institution where the transfer evaluation's result units are to be applied toward program requirements
RESLT_UNIT_ALT_INST_ID	VARCHAR2	(20)		Alternate institution id for institution where the transfer evaluation's result units are to be applied toward program requirements
RESLT_UNIT_CODE	VARCHAR2	(10)		Code generated by the third party software for the transfer evaluation's result unit
RESLT_UNIT_CODE_VERSION	NUMBER	(3)		Version generated by the third party software which is associated with the above transfer evaluation's result unit
RESLT_UNIT_TITLE	VARCHAR2	(90)		Title generated by the third party software which is associated with the result unit code/version above
RESLT_UNIT_LEVEL	VARCHAR2	(4)		Unit level generated by the third party software which is associated with the result unit code/version above
RESLT_UNIT_LEVEL_TITLE	VARCHAR2	(90)		Title generated by the third party software which is associated with the result unit level above
RESLT_UNIT_TEACH_PERIOD	NUMBER	(15)		Term generated by the third party software which indicates the term the transfer evaluation's result unit's credits should be applied to the student's program
RESLT_UNIT_EARNED_CRED	NUMBER	(9)		Value generated by the third party software which indicates the number of credits earned for the transfer evaluation's unit code/ version above
RESLT_UNIT_GRADE	VARCHAR2	(5)		Value generated by the third party software which indicates grade associated with the transfer evaluation's result unit code version above
RESLT_UNIT_GPA_PTS	NUMBER			Value generated by the third party software - indicates grade point average points calculated by the third party software for the transfer evaluation's result unit code/ version above
RESLT_UNIT_QUAL_PTS_EARNED	NUMBER			Value generated by the third party software - indicates number of quality points to be associated with the transfer evaluation's result unit code/ version above
RESLT_UNIT_SEQ_CODE	VARCHAR2	(3)		Value generated by the third party software - indicates unit sequence code
RESLT_UNIT_COUNT	VARCHAR2	(1)		Value generated by the third party software - indicates count
RESLT_UNIT_PSEUDO_FLAG	VARCHAR2	(1)		Value generated by the third party software - indicates that the transfer evaluation's result unit code is a pseudo unit
RESLT_ALT_UNIT_ID1	VARCHAR2	(15)		Value generated by the third party software - transfer evaluation unit code decision supplement 1
RESLT_ALT_UNIT_ID2	VARCHAR2	(15)		Value generated by the third party software - transfer evaluation unit code decision supplement 2
RESLT_ALT_UNIT_ID3	VARCHAR2	(15)		Value generated by the third party software - transfer evaluation unit code decision supplement 3
RESLT_ALT_UNIT_PSEUDO_FLG1	VARCHAR2	(1)		Value generated by the third party software - indicates that the transfer evaluation unit code decision supplement 1 is a pseudo unit
RESLT_ALT_UNIT_PSEUDO_FLG2	VARCHAR2	(1)		Value generated by the third party software - indicates that the transfer evaluation unit code decision supplement 2 is a pseudo unit
RESLT_ALT_UNIT_PSEUDO_FLG3	VARCHAR2	(1)		Value generated by the third party software - indicates that the transfer evaluation unit code decision supplement 3 is a pseudo unit
RESLT_UNIT_FLAG1	VARCHAR2	(10)		Value generated by the third party software which will be stored in the degree audit details and will used by the third party software for processing subsequent requests
RESLT_UNIT_FLAG2	VARCHAR2	(10)		Value generated by the third party software which will be stored in the degree audit details and will used by the third party software for processing subsequent requests
RESLT_UNIT_FLAG3	VARCHAR2	(10)		Value generated by the third party software which will be stored in the degree audit details and will used by the third party software for processing subsequent requests
RESLT_UNIT_FLAG4	VARCHAR2	(10)		Value generated by the third party software which will be stored in the degree audit details and will used by the third party software for processing subsequent requests
RESLT_UNIT_FLAG5	VARCHAR2	(10)		Value generated by the third party software which will be stored in the degree audit details and will used by the third party software for processing subsequent requests
RESLT_DA_UNIT_CODE1	VARCHAR2	(1)		Code generated by the third party software - indicates a unit characteristic code which has meaning to the third party software in subsequent report requests
RESLT_DA_UNIT_CODE2	VARCHAR2	(1)		Code generated by the third party software - indicates a unit characteristic code which has meaning to the third party software in subsequent report requests
RESLT_DA_UNIT_CODE3	VARCHAR2	(1)		Code generated by the third party software - indicates a unit characteristic code which has meaning to the third party software in subsequent report requests
RESLT_DA_UNIT_CODE4	VARCHAR2	(1)		Code generated by the third party software - indicates a unit characteristic code which has meaning to the third party software in subsequent report requests
RESLT_DA_UNIT_CODE5	VARCHAR2	(1)		Code generated by the third party software - indicates a unit characteristic code which has meaning to the third party software in subsequent report requests
RESLT_DA_UNIT_CODE6	VARCHAR2	(1)		Code generated by the third party software - indicates a unit characteristic code which has meaning to the third party software in subsequent report requests
RESLT_DA_UNIT_CODE7	VARCHAR2	(1)		Code generated by the third party software - indicates a unit characteristic code which has meaning to the third party software in subsequent report requests
RESLT_DA_UNIT_CODE8	VARCHAR2	(1)		Code generated by the third party software - indicates a unit characteristic code which has meaning to the third party software in subsequent report requests
RESLT_DA_UNIT_CODE9	VARCHAR2	(1)		Code generated by the third party software - indicates a unit characteristic code which has meaning to the third party software in subsequent report requests
RESLT_DA_UNIT_CODE10	VARCHAR2	(1)		Code generated by the third party software - indicates a unit characteristic code which has meaning to the third party software in subsequent report requests
RESLT_DA_UNIT_CODE11	VARCHAR2	(1)		Code generated by the third party software - indicates a unit characteristic code which has meaning to the third party software in subsequent report requests
RESLT_DA_UNIT_CODE12	VARCHAR2	(1)		Code generated by the third party software - indicates a unit characteristic code which has meaning to the third party software in subsequent report requests
RESLT_REF_INST_ID	VARCHAR2	(8)		Reference Institution Id associated with the referenced transfer evaluation
RESLT_REF_INST_CD	VARCHAR2	(3)		Reference Institution associated with the referenced transfer evaluation
RESLT_REF_TITLE	VARCHAR2	(30)		Reference Title associated with the referenced transfer evaluation
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
,      RSLT_UNIT_ID
,      RESLT_UNIT_GROUP
,      RESLT_UNIT_DPMASK
,      RESLT_UNIT_INST_ID
,      RESLT_UNIT_ALT_INST_ID
,      RESLT_UNIT_CODE
,      RESLT_UNIT_CODE_VERSION
,      RESLT_UNIT_TITLE
,      RESLT_UNIT_LEVEL
,      RESLT_UNIT_LEVEL_TITLE
,      RESLT_UNIT_TEACH_PERIOD
,      RESLT_UNIT_EARNED_CRED
,      RESLT_UNIT_GRADE
,      RESLT_UNIT_GPA_PTS
,      RESLT_UNIT_QUAL_PTS_EARNED
,      RESLT_UNIT_SEQ_CODE
,      RESLT_UNIT_COUNT
,      RESLT_UNIT_PSEUDO_FLAG
,      RESLT_ALT_UNIT_ID1
,      RESLT_ALT_UNIT_ID2
,      RESLT_ALT_UNIT_ID3
,      RESLT_ALT_UNIT_PSEUDO_FLG1
,      RESLT_ALT_UNIT_PSEUDO_FLG2
,      RESLT_ALT_UNIT_PSEUDO_FLG3
,      RESLT_UNIT_FLAG1
,      RESLT_UNIT_FLAG2
,      RESLT_UNIT_FLAG3
,      RESLT_UNIT_FLAG4
,      RESLT_UNIT_FLAG5
,      RESLT_DA_UNIT_CODE1
,      RESLT_DA_UNIT_CODE2
,      RESLT_DA_UNIT_CODE3
,      RESLT_DA_UNIT_CODE4
,      RESLT_DA_UNIT_CODE5
,      RESLT_DA_UNIT_CODE6
,      RESLT_DA_UNIT_CODE7
,      RESLT_DA_UNIT_CODE8
,      RESLT_DA_UNIT_CODE9
,      RESLT_DA_UNIT_CODE10
,      RESLT_DA_UNIT_CODE11
,      RESLT_DA_UNIT_CODE12
,      RESLT_REF_INST_ID
,      RESLT_REF_INST_CD
,      RESLT_REF_TITLE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM IGS.IGS_DA_IN_RSLT_UNTS;

Dependencies

[top of page]

IGS.IGS_DA_IN_RSLT_UNTS does not reference any database object

IGS.IGS_DA_IN_RSLT_UNTS is referenced by following:

APPS: IGS_DA_IN_RSLT_UNTS