FND Design Data [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: TableIGS.IGS_AD_LOCATION_ALL
Primary Key: IGS_AD_LOCATION_PK
  1. ColumnLOCATION_CD
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_AD_LOCATION_ALL FK Joins to TableIGS_FI_ACC_ALL IGS_AD_LOCATION_ALL.REV_ACCOUNT_CD
IGS_AD_LOCATION_ALL FK Joins to TableHZ_PARTIES IGS_AD_LOCATION_ALL.COORD_PERSON_ID
IGS_AD_LOCATION_ALL FK Joins to TableIGS_AD_LOCATION_TYPE_ALL IGS_AD_LOCATION_ALL.LOCATION_TYPE
TableIGS_AD_BUILDING_ALL FK Joins to IGS_AD_LOCATION_ALL IGS_AD_BUILDING_ALL.LOCATION_CD
TableIGS_AD_PS_APLINSTUNT_ALL FK Joins to IGS_AD_LOCATION_ALL IGS_AD_PS_APLINSTUNT_ALL.LOCATION_CD
TableIGS_AD_PS_APPL_INST_ALL FK Joins to IGS_AD_LOCATION_ALL IGS_AD_PS_APPL_INST_ALL.LOCATION_CD
TableIGS_AD_LOC_ACCTS_ALL FK Joins to IGS_AD_LOCATION_ALL IGS_AD_LOC_ACCTS_ALL.LOCATION_CD
TableIGS_AS_ITEM_ASSESSOR FK Joins to IGS_AD_LOCATION_ALL IGS_AS_ITEM_ASSESSOR.LOCATION_CD
TableIGS_AD_PECRS_OFOP_DT FK Joins to IGS_AD_LOCATION_ALL IGS_AD_PECRS_OFOP_DT.LOCATION_CD
TableIGS_AD_PRD_PS_OF_OPT FK Joins to IGS_AD_LOCATION_ALL IGS_AD_PRD_PS_OF_OPT.LOCATION_CD
TableIGS_AZ_GROUPS FK Joins to IGS_AD_LOCATION_ALL IGS_AZ_GROUPS.LOCATION_CD
TableIGS_FI_FEE_AS_RT FK Joins to IGS_AD_LOCATION_ALL IGS_FI_FEE_AS_RT.LOCATION_CD
TableIGS_PS_FEE_TRG FK Joins to IGS_AD_LOCATION_ALL IGS_PS_FEE_TRG.LOCATION_CD
TableIGS_PS_OFR_OPT_ALL FK Joins to IGS_AD_LOCATION_ALL IGS_PS_OFR_OPT_ALL.LOCATION_CD
TableIGS_AS_EXM_LOC_SPVSR FK Joins to IGS_AD_LOCATION_ALL IGS_AS_EXM_LOC_SPVSR.EXAM_LOCATION_CD
TableIGS_FI_FEE_AS_RATE FK Joins to IGS_AD_LOCATION_ALL IGS_FI_FEE_AS_RATE.LOCATION_CD
TableIGF_AP_FA_ANT_DATA FK Joins to IGS_AD_LOCATION_ALL IGF_AP_FA_ANT_DATA.PROGRAM_LOCATION_CD
TableIGF_AW_COA_RATE_DET FK Joins to IGS_AD_LOCATION_ALL IGF_AW_COA_RATE_DET.PROGRAM_LOCATION_CD
TableIGS_AD_PANEL_DTLS FK Joins to IGS_AD_LOCATION_ALL IGS_AD_PANEL_DTLS.LOCATION_CD
TableIGS_AD_PNMEMBR_DTLS FK Joins to IGS_AD_LOCATION_ALL IGS_AD_PNMEMBR_DTLS.LOCATION_CD
TableIGS_FI_FTCI_ACCTS FK Joins to IGS_AD_LOCATION_ALL IGS_FI_FTCI_ACCTS.LOCATION_CD
TableIGS_OR_LOC_REGION FK Joins to IGS_AD_LOCATION_ALL IGS_OR_LOC_REGION.LOCATION_CD
TableIGS_OR_ORG_ALT_IDS FK Joins to IGS_AD_LOCATION_ALL IGS_OR_ORG_ALT_IDS.ORG_STRUCTURE_ID
TableIGS_OR_ORG_NOTES FK Joins to IGS_AD_LOCATION_ALL IGS_OR_ORG_NOTES.ORG_STRUCTURE_ID
TableIGS_PE_ACT_SITE FK Joins to IGS_AD_LOCATION_ALL IGS_PE_ACT_SITE.ACTIVITY_SITE_CD
TableIGS_PS_US_UNSCHED_CL FK Joins to IGS_AD_LOCATION_ALL IGS_PS_US_UNSCHED_CL.LOCATION_CD
TableIGS_SS_APP_PGM_STG FK Joins to IGS_AD_LOCATION_ALL IGS_SS_APP_PGM_STG.LOCATION_CD
TableIGS_AD_LOCATION_REL FK Joins to IGS_AD_LOCATION_ALL IGS_AD_LOCATION_REL.LOCATION_CD
TableIGS_AD_LOCATION_REL FK Joins to IGS_AD_LOCATION_ALL IGS_AD_LOCATION_REL.SUB_LOCATION_CD
TableIGS_OR_ORG_ACCR_DTLS FK Joins to IGS_AD_LOCATION_ALL IGS_OR_ORG_ACCR_DTLS.ORG_STRUCTURE_ID
TableIGS_OR_ORG_ALT_IDS FK Joins to IGS_AD_LOCATION_ALL IGS_OR_ORG_ALT_IDS.ORG_STRUCTURE_ID
TableIGS_OR_ORG_NOTES FK Joins to IGS_AD_LOCATION_ALL IGS_OR_ORG_NOTES.ORG_STRUCTURE_ID
TableIGS_OR_UNIT_LOC FK Joins to IGS_AD_LOCATION_ALL IGS_OR_UNIT_LOC.LOCATION_CD
TableIGS_PS_PAT_STUDY_UNT FK Joins to IGS_AD_LOCATION_ALL IGS_PS_PAT_STUDY_UNT.UNIT_LOCATION_CD
TableIGS_PS_PAT_OF_STUDY FK Joins to IGS_AD_LOCATION_ALL IGS_PS_PAT_OF_STUDY.LOCATION_CD
TableIGS_AS_SASSESS_TYPE FK Joins to IGS_AD_LOCATION_ALL IGS_AS_SASSESS_TYPE.NON_CNTRL_EXAM_LOC_CD
TableIGS_EN_STDNT_PS_ATT_ALL FK Joins to IGS_AD_LOCATION_ALL IGS_EN_STDNT_PS_ATT_ALL.EXAM_LOCATION_CD
TableIGS_AD_SBM_PS_FNTRGT FK Joins to IGS_AD_LOCATION_ALL IGS_AD_SBM_PS_FNTRGT.LOCATION_CD
TableIGS_EN_SU_ATTEMPT_ALL FK Joins to IGS_AD_LOCATION_ALL IGS_EN_SU_ATTEMPT_ALL.EXAM_LOCATION_CD
TableIGS_AS_UNITASS_ITEM_ALL FK Joins to IGS_AD_LOCATION_ALL IGS_AS_UNITASS_ITEM_ALL.LOCATION_CD
TableIGS_FI_UNIT_FEE_TRG FK Joins to IGS_AD_LOCATION_ALL IGS_FI_UNIT_FEE_TRG.LOCATION_CD
TableIGS_PS_UNIT_LOCATION FK Joins to IGS_AD_LOCATION_ALL IGS_PS_UNIT_LOCATION.LOCATION_CODE
TableIGS_PS_UNIT_OFR_OPT_ALL FK Joins to IGS_AD_LOCATION_ALL IGS_PS_UNIT_OFR_OPT_ALL.LOCATION_CD
TableIGS_GR_VENUE_ALL FK Joins to IGS_AD_LOCATION_ALL IGS_GR_VENUE_ALL.EXAM_LOCATION_CD