FND Design Data [Home] [Help]

Table: IGS_UC_QUAL_DETS

Product: IGS - Student System
Description: The qualification details table will hold the qualifications awarded to an applicant.
Implementation/DBA Data: TableIGS.IGS_UC_QUAL_DETS
Primary Key: IGS_UC_QUAL_DETS_PK
  1. ColumnQUAL_DETS_ID
Primary Key: IGS_UC_QUAL_DETS_UK
  1. ColumnPERSON_ID
  2. ColumnEXAM_LEVEL
  3. ColumnSUBJECT_CODE
  4. ColumnYEAR
  5. ColumnSITTING
  6. ColumnAWARDING_BODY
  7. ColumnAPPROVED_RESULT
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_UC_QUAL_DETS FK Joins to TableIGS_PS_AWD IGS_UC_QUAL_DETS.EXAM_LEVEL
IGS_UC_QUAL_DETS FK Joins to TableIGS_PS_FLD_OF_STUDY_ALL IGS_UC_QUAL_DETS.SUBJECT_CODE
IGS_UC_QUAL_DETS FK Joins to TableIGS_AS_GRD_SCH_GRADE IGS_UC_QUAL_DETS.GRADING_SCHEMA_CD
IGS_UC_QUAL_DETS.VERSION_NUMBER
IGS_UC_QUAL_DETS.APPROVED_RESULT
IGS_UC_QUAL_DETS FK Joins to TableIGS_AS_GRD_SCH_GRADE IGS_UC_QUAL_DETS.GRADING_SCHEMA_CD
IGS_UC_QUAL_DETS.VERSION_NUMBER
IGS_UC_QUAL_DETS.CLAIMED_RESULT
IGS_UC_QUAL_DETS FK Joins to TableIGS_AS_GRD_SCH_GRADE IGS_UC_QUAL_DETS.GRADING_SCHEMA_CD
IGS_UC_QUAL_DETS.VERSION_NUMBER
IGS_UC_QUAL_DETS.PREDICTED_RESULT
IGS_UC_QUAL_DETS FK Joins to TableHZ_PARTIES IGS_UC_QUAL_DETS.PERSON_ID
TableIGS_AV_STND_UNIT_LVL_ALL FK Joins to IGS_UC_QUAL_DETS IGS_AV_STND_UNIT_LVL_ALL.QUAL_DETS_ID