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.IGSFV_AS_SUA_REFERENCE_CODES

Object Details

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

View Type

A Business Intelligence System view

Student Unit Attempt Reference Codes

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_NAME	VARCHAR2	(360)	Yes	Name of this party
PERSON_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this party
PROGRAM_CODE	VARCHAR2	(6)	Yes	Program ID - part of foreign key to SUA
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Title or full name of the program.
UNIT_CODE	VARCHAR2	(10)	Yes	Code used to identify the unit
UNIT_TITLE	VARCHAR2	(90)	Yes	Title of the unit.
CALENDAR_TYPE	VARCHAR2	(10)	Yes	Type of teaching calendar within the institution. For example, SEM-1, YR-LONG.
CALENDAR_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the calendar instance.
CALENDAR_DESCRIPTION	VARCHAR2	(30)		Description for the Calendar Instance
REFERENCE_CODE_TYPE	VARCHAR2	(10)	Yes	The reference code type
REFERENCE_CODE	VARCHAR2	(30)	Yes	The reference code applied to the student unit attempt
APPLIED_PROGRAM_CODE	VARCHAR2	(6)	Yes	The program code under which the reference code is saved.
APPLIED_PROGRAM_TITLE	VARCHAR2	(90)	Yes	Title or full name of the program.
PERSON_ID	NUMBER	(15)	Yes	Unique identification for this party.
UNIT_VERSION_NUMBER	NUMBER	(3)	Yes	Version number is used to uniquely identify each version of a unit.
PROGRAM_VERSION_NUMBER	NUMBER	(3)	Yes	Number signifying the version of the program for that the student enrolls.
REFERENCE_CODE_ID	NUMBER	(10)	Yes	Reference Code ID - foreign key to reference code
CREATED_BY	NUMBER	(15)	Yes	Created By -Standard Who Column
CREATION_DATE	DATE		Yes	Creation Date -Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Last Updated By -Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Last Update Date Standard Who Column
UOO_ID	NUMBER	(7)	Yes	Unit Offering Option ID - part of foreign key to SUA

Query Text

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


SELECT PERSON_NAME
,      PERSON_NUMBER
,      PROGRAM_CODE
,      PROGRAM_TITLE
,      UNIT_CODE
,      UNIT_TITLE
,      CALENDAR_TYPE
,      CALENDAR_SEQUENCE_NUMBER
,      CALENDAR_DESCRIPTION
,      REFERENCE_CODE_TYPE
,      REFERENCE_CODE
,      APPLIED_PROGRAM_CODE
,      APPLIED_PROGRAM_TITLE
,      PERSON_ID
,      UNIT_VERSION_NUMBER
,      PROGRAM_VERSION_NUMBER
,      REFERENCE_CODE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      UOO_ID
FROM APPS.IGSFV_AS_SUA_REFERENCE_CODES;

Dependencies

[top of page]

APPS.IGSFV_AS_SUA_REFERENCE_CODES references the following:

APPS: HZ_PARTIES; IGS_AS_SUA_REF_CDS; IGS_CA_INST_ALL; IGS_EN_STDNT_PS_ATT_ALL; IGS_EN_SU_ATTEMPT_ALL; IGS_PS_UNIT_VER_ALL; IGS_PS_VER_ALL

APPS.IGSFV_AS_SUA_REFERENCE_CODES is not referenced by any database object