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_APLINSTUNT_ALL

Object Details

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

IGS_AD_PS_APLINSTUNT_ALL describes admission program unit applications or
admission non-award unit applications.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_PS_APLINSTUNT_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADM_PS_APPL_INST_UNIT_ID
IGS_AD_PS_APLINSTUNT_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
IGS_AD_PS_APLINSTUNT_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_CD UV_VERSION_NUMBER CAL_TYPE CI_SEQUENCE_NUMBER LOCATION_CD UNIT_CLASS
IGS_AD_PS_APLINSTUNT_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_CD
IGS_AD_PS_APLINSTUNT_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_CLASS
IGS_AD_PS_APLINSTUNT_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASS_TRACKING_ID
IGS_AD_PS_APLINSTUNT_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_MODE
IGS_AD_PS_APLINSTUNT_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUP_UNIT_CD SUP_UV_VERSION_NUMBER
IGS_AD_PS_APLINSTUNT_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_UNIT_OUTCOME_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER	(15)		Operating unit identifier
PERSON_ID	NUMBER	(15)	Yes	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
ADMISSION_APPL_NUMBER	NUMBER	(2)	Yes	Uniquely identifies 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	Describes the unit code of the unit offering pattern to that the person is applying for admission
UV_VERSION_NUMBER	NUMBER	(3)	Yes	Describes the unit version number of the unit offering pattern to that the person is applying for admission
CAL_TYPE	VARCHAR2	(10)		Describes the teaching calendar type of the unit offering pattern to that the person is applying for admission
CI_SEQUENCE_NUMBER	NUMBER	(6)		Describes the teaching calendar sequence number of the unit offering pattern to that the person is applying for admission
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. Only one of unit class or unit mode may be nominated.
UNIT_MODE	VARCHAR2	(10)		Describes the unit mode of the unit within the admission program application instance. Only one of unit class or unit mode may be nominated.
ADM_UNIT_OUTCOME_STATUS	VARCHAR2	(10)	Yes	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
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
ADM_PS_APPL_INST_UNIT_ID	NUMBER		Yes	The value of this column will uniquely identify the record and is provided by oracle sequence IGS_AD_PS_APLINSTUNT_S

Query Text

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


SELECT ORG_ID
,      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
,      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
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ADM_PS_APPL_INST_UNIT_ID
FROM IGS.IGS_AD_PS_APLINSTUNT_ALL;

Dependencies

[top of page]

IGS.IGS_AD_PS_APLINSTUNT_ALL does not reference any database object

IGS.IGS_AD_PS_APLINSTUNT_ALL is referenced by following:

APPS: IGS_AD_PS_APLINSTUNT_ALL