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]

VIEW: APPS.IGSBV_STUDENT_PRG_TRANSFERS

Object Details

Object Name:	IGSBV_STUDENT_PRG_TRANSFERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSBV_STUDENT_PRG_TRANSFERS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This entity contains the student program attempt transfers.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_IDENTIFIER	NUMBER	(15)	Yes	Describes the person ID that uniquely identifies the person.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the person number for the person ID
PERSON_NAME	VARCHAR2	(360)	Yes	Full Name of the Person.
PROGRAM_CODE	VARCHAR2	(6)	Yes	Code used to identify the program in which the student is enrolled.
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Title for the program
TRANSFER_PROGRAM_CODE	VARCHAR2	(6)	Yes	The program code that the student program attempt has been transferred 'From'
TRANSFER_PROGRAM_TITLE	VARCHAR2	(90)	Yes	Transferred program title
TRANSFER_DATE	DATE		Yes	The transfer date describes the date student program attempt transfer was processed
COMMENTS	VARCHAR2	(2000)		This field provides any comments about the link between the transfer To program and the Transfer From program associated with the student course attempt 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
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_IDENTIFIER
,      PERSON_NUMBER
,      PERSON_NAME
,      PROGRAM_CODE
,      PROGRAM_TITLE
,      TRANSFER_PROGRAM_CODE
,      TRANSFER_PROGRAM_TITLE
,      TRANSFER_DATE
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      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 APPS.IGSBV_STUDENT_PRG_TRANSFERS;

Dependencies

[top of page]

APPS.IGSBV_STUDENT_PRG_TRANSFERS references the following:

APPS: HZ_PARTIES; IGS_EN_STDNT_PS_ATT_ALL; IGS_PS_STDNT_TRN; IGS_PS_VER_ALL

APPS.IGSBV_STUDENT_PRG_TRANSFERS is not referenced by any database object