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_AV_ADV_STND_UNIT

Object Details

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

View Type

A Business Intelligence System view

Describes a unit granted as advanced standing.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the person number.
PERSON_NAME	VARCHAR2	(360)	Yes	Describes the person name.
PROGRAM_CODE	VARCHAR2	(6)	Yes	Describes the program against advanced standing that is approved or granted.
PROGRAM_VERSION_NUMBER	NUMBER	(3)	Yes	Describes the version number of the program against advanced standing that is approved or granted.
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Describes the program title against advanced standing that is approved or granted.
EXEMPTION_INSTITUTION_CODE	VARCHAR2	(30)	Yes	Describes the institution student undertook the study that resulted in the unit advanced standing.
EXEMPTION_INSTITUTION_NAME	VARCHAR2	(360)	Yes	This field describes the institution name where the exemption was obtained.
ADV_STAND_UNIT_CODE	VARCHAR2	(10)	Yes	Identifies the unit the student is being given in advanced standing.
ADV_STAND_UNIT_VERSION_NUMBER	NUMBER	(3)	Yes	Identifies each version of a unit uniquely with version number.
ADV_STAND_UNIT_TITLE	VARCHAR2	(90)	Yes	Identifies the unit title the student is being given in advanced standing.
PREVIOUS_UNIT_CODE	VARCHAR2	(10)		Describes the unit abbreviation from the student's academic history
PREVIOUS_UNIT_NAME	VARCHAR2	(80)		Description of the unit from the student's academic history
PREVIOUS_TERM	VARCHAR2	(30)		Describes the term in which the previous unit was taken
ADMISSION_TEST_TYPE	VARCHAR2	(30)		Describes the types of admission test against that results may be recorded for a student
TEST_SEGMENT_NAME	VARCHAR2	(30)		Describes the sub category of the admission test type
ADV_STANDING_TYPE	VARCHAR2	(10)	Yes	Describes the type of advanced standing.
CAL_TYPE	VARCHAR2	(10)		Describes the Calendar Type
CI_SEQUENCE_NUMBER	NUMBER	(6)		Describes the Sequence Number
TERM_CALENDAR	VARCHAR2	(30)		Description of the Calendar instance
CREDIT_PERCENTAGE	VARCHAR2	(0)		Describes the percentage of credit for the unit that is to be granted as advanced standing.-- Obsolete
CREDIT_POINTS	NUMBER	(6)		Describes the Credit Point Granted details.
GRADING_SCHEMA_CD	VARCHAR2	(10)		Describes the Grade Schema Code.
GRD_SCH_VERSION_NUMBER	NUMBER	(3)		Describes the valid Pass Grade belong to the above grading Schema.
GRADE	VARCHAR2	(5)		Describes the Grade details, should be a valid grade.
_LA:ADV_STND_RECOGNITION_TYP	CHAR	(87)		Describes the available types of recognition that apply to the units, unit sets that form the advanced standing.
_LA:ASU_UNIT_GRANTING_STATUS	CHAR	(85)		Describes the granting status of the advanced standing unit record. For example, CANCELLED, GRANTED, REVOKED.
APPROVED_DT	DATE		Yes	Describes the date unit was approved for advanced standing purposes.
AUTHORISING_PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the Person Number of the officer who authorized the advanced standing.
AUTHORISING_PERSON_NAME	VARCHAR2	(360)	Yes	Describes the Person Name of the officer who authorized the advanced standing.
GRANTED_DT	DATE			Describes the date the granting status of the unit was changed to GRANTED.
EXPIRY_DT	DATE			Describes the date, the approval for the advanced standing unit level expired.
CANCELLED_DT	DATE			Describes the date the granting status of the unit was changed to CANCELLED.
REVOKED_DT	DATE			Describes the date the granting status of the unit was changed to REVOKED.
COMMENTS	VARCHAR2	(2000)		Provides comments about the advanced standing unit.
PROGRAM_GROUP_IND	VARCHAR2	(1)	Yes	Describes whether the unit is to be regarded as program-grouped. Setting the indicator to checked means that the unit is program-grouped.
ADV_STAND_UNIT_ID	NUMBER	(15)	Yes	System Generated number to store the primary key
PERSON_ID	NUMBER	(15)	Yes	Describes the ID that uniquely identifies a person.
UNIT_DETAILS_ID	NUMBER	(15)		Previous unit identifier
TST_RSLT_DTLS_ID	NUMBER	(15)		Test segment identifier
DEG_AUD_DETAIL_ID	NUMBER			Degree Audit Details ID
AUTHORISING_PERSON_ID	NUMBER	(15)	Yes	Describes the Person ID of the officer who authorized the advanced standing.
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

Query Text

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


SELECT PERSON_NUMBER
,      PERSON_NAME
,      PROGRAM_CODE
,      PROGRAM_VERSION_NUMBER
,      PROGRAM_TITLE
,      EXEMPTION_INSTITUTION_CODE
,      EXEMPTION_INSTITUTION_NAME
,      ADV_STAND_UNIT_CODE
,      ADV_STAND_UNIT_VERSION_NUMBER
,      ADV_STAND_UNIT_TITLE
,      PREVIOUS_UNIT_CODE
,      PREVIOUS_UNIT_NAME
,      PREVIOUS_TERM
,      ADMISSION_TEST_TYPE
,      TEST_SEGMENT_NAME
,      ADV_STANDING_TYPE
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      TERM_CALENDAR
,      CREDIT_PERCENTAGE
,      CREDIT_POINTS
,      GRADING_SCHEMA_CD
,      GRD_SCH_VERSION_NUMBER
,      GRADE
,      _LA:ADV_STND_RECOGNITION_TYP
,      _LA:ASU_UNIT_GRANTING_STATUS
,      APPROVED_DT
,      AUTHORISING_PERSON_NUMBER
,      AUTHORISING_PERSON_NAME
,      GRANTED_DT
,      EXPIRY_DT
,      CANCELLED_DT
,      REVOKED_DT
,      COMMENTS
,      PROGRAM_GROUP_IND
,      ADV_STAND_UNIT_ID
,      PERSON_ID
,      UNIT_DETAILS_ID
,      TST_RSLT_DTLS_ID
,      DEG_AUD_DETAIL_ID
,      AUTHORISING_PERSON_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_AV_ADV_STND_UNIT;

Dependencies

[top of page]

APPS.IGSFV_AV_ADV_STND_UNIT references the following:

APPS: HZ_PARTIES; IGS_AD_TERM_DETAILS; IGS_AD_TERM_UNITDTLS; IGS_AD_TEST_SEGMENTS; IGS_AD_TST_RSLT_DTLS; IGS_AV_STND_UNIT_ALL; IGS_CA_INST_ALL; IGS_PS_UNIT_VER_ALL; IGS_PS_VER_ALL

APPS.IGSFV_AV_ADV_STND_UNIT is not referenced by any database object