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_STDNT_TRN

Object Details

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

This entity describes the link between two programs, which were involved in a program transfer.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PS_STDNT_TRN_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD TRANSFER_COURSE_CD TRANSFER_DT
IGS_PS_STDNT_TRN_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID TRANSFER_COURSE_CD
IGS_PS_STDNT_TRN_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EFFECTIVE_TERM_CAL_TYPE EFFECTIVE_TERM_SEQUENCE_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Describes ID code that uniquely identifies a person.
COURSE_CD	VARCHAR2	(6)	Yes	Code used to identify the program in that the student is enrolled. See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA.
TRANSFER_COURSE_CD	VARCHAR2	(6)	Yes	Program code that the student program attempt has been transferred from.
TRANSFER_DT	DATE		Yes	Describes the date the student program attempt record transfer was processed.
COMMENTS	VARCHAR2	(2000)		Provides any comments about the link between the Transfer to program and the transfer from program associated with the student program attempt record transfer.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
APPROVED_DATE	DATE			Approved date
EFFECTIVE_TERM_CAL_TYPE	VARCHAR2	(10)		Effective term calendar type
EFFECTIVE_TERM_SEQUENCE_NUM	NUMBER	(6)		Effective term sequence number
DISCONTINUE_SOURCE_FLAG	VARCHAR2	(1)		Indicated whether to discontinue the source program after transfer.
TRANSFER_ADV_STAND_FLAG	VARCHAR2	(1)		Indicates whether to transfer advanced standing for future dated transfer
UOOIDS_TO_TRANSFER	VARCHAR2	(4000)		Indiactes uooids to transfer for future dated transfer
SUSA_TO_TRANSFER	VARCHAR2	(4000)		Indicates unit set attempts to transfer for future dated transfer
STATUS_FLAG	VARCHAR2	(1)	Yes	Indicates whether the transfer is processed/unprocessed/cleaned up
STATUS_DATE	DATE			Indicates when the transfer is actually done

Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      TRANSFER_COURSE_CD
,      TRANSFER_DT
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      APPROVED_DATE
,      EFFECTIVE_TERM_CAL_TYPE
,      EFFECTIVE_TERM_SEQUENCE_NUM
,      DISCONTINUE_SOURCE_FLAG
,      TRANSFER_ADV_STAND_FLAG
,      UOOIDS_TO_TRANSFER
,      SUSA_TO_TRANSFER
,      STATUS_FLAG
,      STATUS_DATE
FROM IGS.IGS_PS_STDNT_TRN;

Dependencies

[top of page]

IGS.IGS_PS_STDNT_TRN does not reference any database object

IGS.IGS_PS_STDNT_TRN is referenced by following:

APPS: IGS_PS_STDNT_TRN