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_AD_PS_APINTUNTHS_ALL

Object Details

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

IGS_AD_PS_APINTUNTHS_ALL describes history of changes to admission program application instance unit.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_PS_APINTUNTHS_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADM_PS_APPL_INST_UNIT_HIST_ID
IGS_AD_PS_APINTUNTHS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID ADMISSION_APPL_NUMBER NOMINATED_COURSE_CD ACAI_SEQUENCE_NUMBER UNIT_CD UV_VERSION_NUMBER CAL_TYPE CI_SEQUENCE_NUMBER LOCATION_CD UNIT_CLASS HIST_START_DT
IGS_AD_PS_APINTUNTHS_ALL_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_PS_APPL_INST_UNIT_ID HIST_START_DT

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
ORG_ID	NUMBER	(15)		Operating unit identifier
ADMISSION_APPL_NUMBER	NUMBER	(2)	Yes	Identifies uniquely an admission application for a person
NOMINATED_COURSE_CD	VARCHAR2	(6)	Yes	Describes the program code of the program offering instance that the person is applying for admission to.
ACAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier of an admission program application. The unique identifier is required to allow for preferences on location code, attendance mode, attendance type and unit set code.
UNIT_CD	VARCHAR2	(10)	Yes	Unit code of the unit offering pattern that the person is applying for admission to.
HIST_START_DT	DATE		Yes	The effective start date and time of the history record
HIST_END_DT	DATE		Yes	The effective end date or time of the history record.
HIST_WHO	NUMBER	(15)	Yes	The Oracle username of the person who created the history record
UV_VERSION_NUMBER	NUMBER	(3)		Unit version number of the unit offering pattern that the person is applying for admission to.
CAL_TYPE	VARCHAR2	(10)		Describes the teaching calendar type of the unit offering pattern that the person is applying for admission to.
CI_SEQUENCE_NUMBER	NUMBER	(6)		Describes the teaching calendar sequence number of the unit offering pattern that the person is applying for admission to.
LOCATION_CD	VARCHAR2	(10)		Describes the location code of the unit within the admission program application instance
UNIT_CLASS	VARCHAR2	(10)		Describes the unit class of the unit within the admission program application instance
UNIT_MODE	VARCHAR2	(10)		Describes the attendance mode of the admission program application instance unit.
ADM_UNIT_OUTCOME_STATUS	VARCHAR2	(10)		Describes the outcome status of the admission program application instance unit.
ASS_TRACKING_ID	NUMBER	(9)		Describes the tracking ID of an application that has been forwarded for assessment
RULE_WAIVED_DT	DATE			Describes the date on which a failed rule applying to the offered unit was waived
RULE_WAIVED_PERSON_ID	NUMBER	(15)		Describes the person who waived the unit rule applicable to the offered unit
SUP_UNIT_CD	VARCHAR2	(10)		Describes the superior unit code of the unit version being offered
SUP_UV_VERSION_NUMBER	NUMBER	(3)		Describes the superior unit version number of the unit version being offered
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
ADM_PS_APPL_INST_UNIT_HIST_ID	NUMBER		Yes	The value of this column will uniquely identify the record and is provided by oracle sequence IGS_AD_PS_APINTUNTHS_S
ADM_PS_APPL_INST_UNIT_ID	NUMBER			The value of this column will link the base transaction record

Query Text

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


SELECT PERSON_ID
,      ORG_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      ACAI_SEQUENCE_NUMBER
,      UNIT_CD
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      UV_VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      LOCATION_CD
,      UNIT_CLASS
,      UNIT_MODE
,      ADM_UNIT_OUTCOME_STATUS
,      ASS_TRACKING_ID
,      RULE_WAIVED_DT
,      RULE_WAIVED_PERSON_ID
,      SUP_UNIT_CD
,      SUP_UV_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ADM_PS_APPL_INST_UNIT_HIST_ID
,      ADM_PS_APPL_INST_UNIT_ID
FROM IGS.IGS_AD_PS_APINTUNTHS_ALL;

Dependencies

[top of page]

IGS.IGS_AD_PS_APINTUNTHS_ALL does not reference any database object

IGS.IGS_AD_PS_APINTUNTHS_ALL is referenced by following:

APPS: IGS_AD_PS_APINTUNTHS_ALL