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

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Rowid
PERSON_ID	NUMBER	(15)	Yes	Person ID that has been modified and is part of request made
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person number for the person.
PERSON_NAME	VARCHAR2	(360)	Yes	Person name.
FULL_NAME	VARCHAR2	(450)		Full Name of the Person.
SEX_MEANING	VARCHAR2	(80)		Sex of the person.
BIRTH_DT	DATE			Birth date of the person.
API_PERSON_ID	VARCHAR2	(20)		Alternate person id.
ENCUMBERED_IND	VARCHAR2	(4000)		Indecated the if the person is encumbred.
DECEASED_IND	VARCHAR2	(1)		Indecated the if the person is deceased.
COURSE_CD	VARCHAR2	(6)	Yes	Program Code for the program application instance
UNIT_CD	VARCHAR2	(10)	Yes	Unit Code for which the override applied
CAL_TYPE	VARCHAR2	(10)	Yes	Unit Load Calendar Type
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unit Load Calendar Instance
ACAD_ALT_CODE	VARCHAR2	(10)		Academic alternate code.
TEACH_ALT_CODE	VARCHAR2	(10)		Teaching alternate code.
ASS_ID	NUMBER	(10)	Yes	The assessment item ID of an assessment item that has been linked to the student and against whom the history is getting tracked. An assessment item ID is a system-generated number that is used to uniquely identify an assessment item. An assessment item must first be assigned to one or more unit offerings before it can be assigned to student unit attempts.
CREATION_DT	DATE		Yes	Creation Date.
ATTEMPT_NUMBER	NUMBER	(2)	Yes	Number of the attempt made.
ASSESSMENT_TYPE	VARCHAR2	(10)	Yes	Type of assessment
REFERENCE	VARCHAR2	(10)		References of the assessment item
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
UOO_ID	NUMBER	(7)	Yes	Unit Section identifier
LOCATION_CD	VARCHAR2	(10)	Yes	Unit Section Location code
UNIT_CLASS	VARCHAR2	(10)	Yes	Unit Section Unit Class

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      PERSON_NUMBER
,      PERSON_NAME
,      FULL_NAME
,      SEX_MEANING
,      BIRTH_DT
,      API_PERSON_ID
,      ENCUMBERED_IND
,      DECEASED_IND
,      COURSE_CD
,      UNIT_CD
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ACAD_ALT_CODE
,      TEACH_ALT_CODE
,      ASS_ID
,      CREATION_DT
,      ATTEMPT_NUMBER
,      ASSESSMENT_TYPE
,      REFERENCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      UOO_ID
,      LOCATION_CD
,      UNIT_CLASS
FROM APPS.IGS_AS_SUAAI_HIST_V;

Dependencies

[top of page]

APPS.IGS_AS_SUAAI_HIST_V references the following:

APPS: FND_LOOKUP_VALUES; HZ_PARTIES; IGS_AS_ASSESSMNT_ITM; IGS_AS_GEN_003 - show dependent code; IGS_AS_SU_ATMPT_ITM; IGS_CA_GEN_001 - show dependent code; IGS_EN_GEN_003 - show dependent code; IGS_EN_GEN_014 - show dependent code; IGS_PE_ALT_PERS_ID; IGS_PE_HZ_PARTIES; IGS_PE_PERSON_BASE_V; IGS_PE_PERSON_ID_TYP; IGS_PS_UNIT_OFR_OPT

APPS.IGS_AS_SUAAI_HIST_V is not referenced by any database object