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_LOCATION_ALL

Product:	IGS - Student System
Description:	Describes available geographic locations at which programs and units may be offered or taught
Implementation/DBA Data:	IGS.IGS_AD_LOCATION_ALL

Primary Key: IGS_AD_LOCATION_PK

LOCATION_CD

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_AD_LOCATION_ALL	IGS_FI_ACC_ALL	IGS_AD_LOCATION_ALL.REV_ACCOUNT_CD
IGS_AD_LOCATION_ALL	HZ_PARTIES	IGS_AD_LOCATION_ALL.COORD_PERSON_ID
IGS_AD_LOCATION_ALL	IGS_AD_LOCATION_TYPE_ALL	IGS_AD_LOCATION_ALL.LOCATION_TYPE
IGS_AD_BUILDING_ALL	IGS_AD_LOCATION_ALL	IGS_AD_BUILDING_ALL.LOCATION_CD
IGS_AD_PS_APLINSTUNT_ALL	IGS_AD_LOCATION_ALL	IGS_AD_PS_APLINSTUNT_ALL.LOCATION_CD
IGS_AD_PS_APPL_INST_ALL	IGS_AD_LOCATION_ALL	IGS_AD_PS_APPL_INST_ALL.LOCATION_CD
IGS_AD_LOC_ACCTS_ALL	IGS_AD_LOCATION_ALL	IGS_AD_LOC_ACCTS_ALL.LOCATION_CD
IGS_AS_ITEM_ASSESSOR	IGS_AD_LOCATION_ALL	IGS_AS_ITEM_ASSESSOR.LOCATION_CD
IGS_AD_PECRS_OFOP_DT	IGS_AD_LOCATION_ALL	IGS_AD_PECRS_OFOP_DT.LOCATION_CD
IGS_AD_PRD_PS_OF_OPT	IGS_AD_LOCATION_ALL	IGS_AD_PRD_PS_OF_OPT.LOCATION_CD
IGS_AZ_GROUPS	IGS_AD_LOCATION_ALL	IGS_AZ_GROUPS.LOCATION_CD
IGS_FI_FEE_AS_RT	IGS_AD_LOCATION_ALL	IGS_FI_FEE_AS_RT.LOCATION_CD
IGS_PS_FEE_TRG	IGS_AD_LOCATION_ALL	IGS_PS_FEE_TRG.LOCATION_CD
IGS_PS_OFR_OPT_ALL	IGS_AD_LOCATION_ALL	IGS_PS_OFR_OPT_ALL.LOCATION_CD
IGS_AS_EXM_LOC_SPVSR	IGS_AD_LOCATION_ALL	IGS_AS_EXM_LOC_SPVSR.EXAM_LOCATION_CD
IGS_FI_FEE_AS_RATE	IGS_AD_LOCATION_ALL	IGS_FI_FEE_AS_RATE.LOCATION_CD
IGF_AP_FA_ANT_DATA	IGS_AD_LOCATION_ALL	IGF_AP_FA_ANT_DATA.PROGRAM_LOCATION_CD
IGF_AW_COA_RATE_DET	IGS_AD_LOCATION_ALL	IGF_AW_COA_RATE_DET.PROGRAM_LOCATION_CD
IGS_AD_PANEL_DTLS	IGS_AD_LOCATION_ALL	IGS_AD_PANEL_DTLS.LOCATION_CD
IGS_AD_PNMEMBR_DTLS	IGS_AD_LOCATION_ALL	IGS_AD_PNMEMBR_DTLS.LOCATION_CD
IGS_FI_FTCI_ACCTS	IGS_AD_LOCATION_ALL	IGS_FI_FTCI_ACCTS.LOCATION_CD
IGS_OR_LOC_REGION	IGS_AD_LOCATION_ALL	IGS_OR_LOC_REGION.LOCATION_CD
IGS_OR_ORG_ALT_IDS	IGS_AD_LOCATION_ALL	IGS_OR_ORG_ALT_IDS.ORG_STRUCTURE_ID
IGS_OR_ORG_NOTES	IGS_AD_LOCATION_ALL	IGS_OR_ORG_NOTES.ORG_STRUCTURE_ID
IGS_PE_ACT_SITE	IGS_AD_LOCATION_ALL	IGS_PE_ACT_SITE.ACTIVITY_SITE_CD
IGS_PS_US_UNSCHED_CL	IGS_AD_LOCATION_ALL	IGS_PS_US_UNSCHED_CL.LOCATION_CD
IGS_SS_APP_PGM_STG	IGS_AD_LOCATION_ALL	IGS_SS_APP_PGM_STG.LOCATION_CD
IGS_AD_LOCATION_REL	IGS_AD_LOCATION_ALL	IGS_AD_LOCATION_REL.LOCATION_CD
IGS_AD_LOCATION_REL	IGS_AD_LOCATION_ALL	IGS_AD_LOCATION_REL.SUB_LOCATION_CD
IGS_OR_ORG_ACCR_DTLS	IGS_AD_LOCATION_ALL	IGS_OR_ORG_ACCR_DTLS.ORG_STRUCTURE_ID
IGS_OR_ORG_ALT_IDS	IGS_AD_LOCATION_ALL	IGS_OR_ORG_ALT_IDS.ORG_STRUCTURE_ID
IGS_OR_ORG_NOTES	IGS_AD_LOCATION_ALL	IGS_OR_ORG_NOTES.ORG_STRUCTURE_ID
IGS_OR_UNIT_LOC	IGS_AD_LOCATION_ALL	IGS_OR_UNIT_LOC.LOCATION_CD
IGS_PS_PAT_STUDY_UNT	IGS_AD_LOCATION_ALL	IGS_PS_PAT_STUDY_UNT.UNIT_LOCATION_CD
IGS_PS_PAT_OF_STUDY	IGS_AD_LOCATION_ALL	IGS_PS_PAT_OF_STUDY.LOCATION_CD
IGS_AS_SASSESS_TYPE	IGS_AD_LOCATION_ALL	IGS_AS_SASSESS_TYPE.NON_CNTRL_EXAM_LOC_CD
IGS_EN_STDNT_PS_ATT_ALL	IGS_AD_LOCATION_ALL	IGS_EN_STDNT_PS_ATT_ALL.EXAM_LOCATION_CD
IGS_AD_SBM_PS_FNTRGT	IGS_AD_LOCATION_ALL	IGS_AD_SBM_PS_FNTRGT.LOCATION_CD
IGS_EN_SU_ATTEMPT_ALL	IGS_AD_LOCATION_ALL	IGS_EN_SU_ATTEMPT_ALL.EXAM_LOCATION_CD
IGS_AS_UNITASS_ITEM_ALL	IGS_AD_LOCATION_ALL	IGS_AS_UNITASS_ITEM_ALL.LOCATION_CD
IGS_FI_UNIT_FEE_TRG	IGS_AD_LOCATION_ALL	IGS_FI_UNIT_FEE_TRG.LOCATION_CD
IGS_PS_UNIT_LOCATION	IGS_AD_LOCATION_ALL	IGS_PS_UNIT_LOCATION.LOCATION_CODE
IGS_PS_UNIT_OFR_OPT_ALL	IGS_AD_LOCATION_ALL	IGS_PS_UNIT_OFR_OPT_ALL.LOCATION_CD
IGS_GR_VENUE_ALL	IGS_AD_LOCATION_ALL	IGS_GR_VENUE_ALL.EXAM_LOCATION_CD