FND Design Data [Home] [Help]

Table: IGS_UC_DEFAULTS

Product: IGS - Student System
Description: Holds default values that will get applied to UCAS application records being imported into OSS . This table will always hold 1 record at any time
Implementation/DBA Data: TableIGS.IGS_UC_DEFAULTS
Primary Key: IGS_UC_DEFAULTS_PK
  1. ColumnSYSTEM_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_UC_DEFAULTS FK Joins to TableIGS_PE_PERSON_ID_TYP IGS_UC_DEFAULTS.NI_NUMBER_ALT_PERS_TYPE
IGS_UC_DEFAULTS FK Joins to TableIGS_AD_SS_APPL_TYP IGS_UC_DEFAULTS.APPLICATION_TYPE
IGS_UC_DEFAULTS FK Joins to TableIGS_AD_CODE_CLASSES IGS_UC_DEFAULTS.DECISION_REASON_ID
IGS_UC_DEFAULTS FK Joins to TableIGS_AD_OU_STAT IGS_UC_DEFAULTS.OBSOLETE_OUTCOME_STATUS
IGS_UC_DEFAULTS FK Joins to TableIGS_AD_OU_STAT IGS_UC_DEFAULTS.PENDING_OUTCOME_STATUS
IGS_UC_DEFAULTS FK Joins to TableIGS_AD_OU_STAT IGS_UC_DEFAULTS.REJECTED_OUTCOME_STATUS
IGS_UC_DEFAULTS FK Joins to TableHZ_PARTIES IGS_UC_DEFAULTS.DECISION_MAKE_ID
TableIGS_UC_APPLICANTS FK Joins to IGS_UC_DEFAULTS IGS_UC_APPLICANTS.SYSTEM_CODE
TableIGS_UC_CRSE_DETS FK Joins to IGS_UC_DEFAULTS IGS_UC_CRSE_DETS.SYSTEM_CODE
TableIGS_UC_CYC_DEFAULTS FK Joins to IGS_UC_DEFAULTS IGS_UC_CYC_DEFAULTS.SYSTEM_CODE
TableIGS_UC_SYS_CALNDRS FK Joins to IGS_UC_DEFAULTS IGS_UC_SYS_CALNDRS.SYSTEM_CODE
TableIGS_UC_SYS_DECISION FK Joins to IGS_UC_DEFAULTS IGS_UC_SYS_DECISION.SYSTEM_CODE
TableIGS_UC_TRANSACTIONS FK Joins to IGS_UC_DEFAULTS IGS_UC_TRANSACTIONS.SYSTEM_CODE
TableIGS_UC_UCAS_CONTROL FK Joins to IGS_UC_DEFAULTS IGS_UC_UCAS_CONTROL.SYSTEM_CODE