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.

[Home] [Help]

Table: IGS_AD_PS_APLINSTUNT_ALL

Product:	IGS - Student System (Obsolete)
Description:	Describes admission program unit applications or admission non-award unit applications
Implementation/DBA Data:	Not implemented in this database

Primary Key: IGS_AD_PS_APLINSTUNT_PK

ADM_PS_APPL_INST_UNIT_ID

Primary Key: IGS_AD_PS_APLINSTUNT_UK

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

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_AD_PS_APLINSTUNT_ALL	IGS_AD_PS_APPL_INST_ALL	IGS_AD_PS_APLINSTUNT_ALL.PERSON_ID IGS_AD_PS_APLINSTUNT_ALL.ADMISSION_APPL_NUMBER IGS_AD_PS_APLINSTUNT_ALL.NOMINATED_COURSE_CD IGS_AD_PS_APLINSTUNT_ALL.ACAI_SEQUENCE_NUMBER
IGS_AD_PS_APLINSTUNT_ALL	IGS_AD_UNIT_OU_STAT	IGS_AD_PS_APLINSTUNT_ALL.ADM_UNIT_OUTCOME_STATUS
IGS_AD_PS_APLINSTUNT_ALL	IGS_AD_LOCATION_ALL	IGS_AD_PS_APLINSTUNT_ALL.LOCATION_CD
IGS_AD_PS_APLINSTUNT_ALL	IGS_PS_UNIT_VER_ALL	IGS_AD_PS_APLINSTUNT_ALL.SUP_UNIT_CD IGS_AD_PS_APLINSTUNT_ALL.SUP_UV_VERSION_NUMBER
IGS_AD_PS_APLINSTUNT_ALL	IGS_TR_ITEM_ALL	IGS_AD_PS_APLINSTUNT_ALL.ASS_TRACKING_ID
IGS_AD_PS_APLINSTUNT_ALL	IGS_AS_UNIT_CLASS_ALL	IGS_AD_PS_APLINSTUNT_ALL.UNIT_CLASS
IGS_AD_PS_APLINSTUNT_ALL	IGS_AS_UNIT_MODE	IGS_AD_PS_APLINSTUNT_ALL.UNIT_MODE
IGS_AD_PS_APLINSTUNT_ALL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_AD_PS_APLINSTUNT_ALL.UNIT_CD IGS_AD_PS_APLINSTUNT_ALL.UV_VERSION_NUMBER IGS_AD_PS_APLINSTUNT_ALL.CAL_TYPE IGS_AD_PS_APLINSTUNT_ALL.CI_SEQUENCE_NUMBER IGS_AD_PS_APLINSTUNT_ALL.LOCATION_CD IGS_AD_PS_APLINSTUNT_ALL.UNIT_CLASS
IGS_AD_PS_APLINSTUNT_ALL	IGS_PS_UNIT_OFR_PAT_ALL	IGS_AD_PS_APLINSTUNT_ALL.UNIT_CD IGS_AD_PS_APLINSTUNT_ALL.UV_VERSION_NUMBER IGS_AD_PS_APLINSTUNT_ALL.CAL_TYPE IGS_AD_PS_APLINSTUNT_ALL.CI_SEQUENCE_NUMBER
IGS_AD_PS_APLINSTUNT_ALL	HZ_PARTIES	IGS_AD_PS_APLINSTUNT_ALL.RULE_WAIVED_PERSON_ID