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_CODE_CLASSES

Product:	IGS - Student System (Obsolete)
Description:	Holds information about different codes, class to which code belongs, and description
Implementation/DBA Data:	Not implemented in this database

Primary Key: IGS_AD_CODE_CLASSES_PK

CODE_ID

Primary Key: IGS_AD_CODE_CLASSES_U1

NAME
CLASS
CLASS_TYPE_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_AD_APPL_EVAL	IGS_AD_CODE_CLASSES	IGS_AD_APPL_EVAL.RATING_TYPE_ID
IGS_AD_ACAD_HONORS	IGS_AD_CODE_CLASSES	IGS_AD_ACAD_HONORS.ACAD_HONOR_TYPE_ID
IGS_AD_APP_INTENT	IGS_AD_CODE_CLASSES	IGS_AD_APP_INTENT.INTENT_TYPE_ID
IGS_AD_ADV_PLACEMENT	IGS_AD_CODE_CLASSES	IGS_AD_ADV_PLACEMENT.EXEMPTION_ID
IGS_AD_APP_REQ	IGS_AD_CODE_CLASSES	IGS_AD_APP_REQ.APPLICANT_FEE_STATUS
IGS_AD_ATHLETICS	IGS_AD_CODE_CLASSES	IGS_AD_ATHLETICS.ATHLETICS_SPORT_ID
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.CERTAINTY_OF_CHOICE_ID
IGS_AD_CREDENTIALS	IGS_AD_CODE_CLASSES	IGS_AD_CREDENTIALS.RATING
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.DEGREE_GOAL_ID
IGS_AD_SPL_INTERESTS	IGS_AD_CODE_CLASSES	IGS_AD_SPL_INTERESTS.SPECIAL_INTEREST_TYPE_ID
IGS_AD_SPL_TALENTS	IGS_AD_CODE_CLASSES	IGS_AD_SPL_TALENTS.SPECIAL_TALENT_TYPE_ID
IGS_AD_TST_RSLT_DTLS	IGS_AD_CODE_CLASSES	IGS_AD_TST_RSLT_DTLS.IRREGULARITY_CODE_ID
IGS_AD_TEST_RESULTS	IGS_AD_CODE_CLASSES	IGS_AD_TEST_RESULTS.EDU_LEVEL_ID
IGS_AD_TEST_RESULTS	IGS_AD_CODE_CLASSES	IGS_AD_TEST_RESULTS.GRADE_ID
IGS_AD_TEST_RESULTS	IGS_AD_CODE_CLASSES	IGS_AD_TEST_RESULTS.SCORE_SOURCE_ID
IGS_AD_TERM_UNITDTLS	IGS_AD_CODE_CLASSES	IGS_AD_TERM_UNITDTLS.UNIT_DIFFICULTY
IGS_AD_TRANSCRIPT	IGS_AD_CODE_CLASSES	IGS_AD_TRANSCRIPT.TRANSCRIPT_SOURCE
IGS_AD_TRANSCRIPT	IGS_AD_CODE_CLASSES	IGS_AD_TRANSCRIPT.ENTERED_GS_ID
IGS_AD_TRANSCRIPT	IGS_AD_CODE_CLASSES	IGS_AD_TRANSCRIPT.CONV_GS_ID
IGS_AD_EDUGOAL	IGS_AD_CODE_CLASSES	IGS_AD_EDUGOAL.EDU_GOAL_ID
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.HOUSING_ID
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.INSTITUTION_CONTROL_ID
IGS_AD_I_ENTRY_STATS	IGS_AD_CODE_CLASSES	IGS_AD_I_ENTRY_STATS.TEST_SOURCE_ID
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.INSTITUTION_SETTING_ID
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.PROGRAM_INTEREST_ID
IGS_AD_APL_RVPF_RSL	IGS_AD_CODE_CLASSES	IGS_AD_APL_RVPF_RSL.RATING_TYPE_ID
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.EMPLOYMENT_ID
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.INSTITUTION_LOCATION_ID
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.INSTITUTION_SIZE_ID
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.SPECIAL_SERVICES_ID
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.SPECIAL_INTEREST_ID
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.UNIT_SET_ID
IGS_IN_ENQUIRY_APPL_ALL	IGS_AD_CODE_CLASSES	IGS_IN_ENQUIRY_APPL_ALL.EDU_GOAL_ID
IGS_IN_ENQUIRY_APPL_ALL	IGS_AD_CODE_CLASSES	IGS_IN_ENQUIRY_APPL_ALL.HOW_KNOWUS_ID
IGS_IN_ENQUIRY_APPL_ALL	IGS_AD_CODE_CLASSES	IGS_IN_ENQUIRY_APPL_ALL.WHO_INFLUENCED_ID
IGS_AD_RECRUIT_PI	IGS_AD_CODE_CLASSES	IGS_AD_RECRUIT_PI.PROBABILITY_TYPE_CODE_ID
IGS_AD_RECRUIT_PI	IGS_AD_CODE_CLASSES	IGS_AD_RECRUIT_PI.PROBABILITY_SOURCE_CODE_ID
IGS_AD_APPQUAL_CODE	IGS_AD_CODE_CLASSES	IGS_AD_APPQUAL_CODE.QUALIFYING_CODE_ID
IGS_AD_DFLT_OUDTLS	IGS_AD_CODE_CLASSES	IGS_AD_DFLT_OUDTLS.DECISION_REASON_ID
IGS_AD_DFLT_OUDTLS	IGS_AD_CODE_CLASSES	IGS_AD_DFLT_OUDTLS.PENDING_REASON_ID
IGS_AD_PANEL_DTLS	IGS_AD_CODE_CLASSES	IGS_AD_PANEL_DTLS.FINAL_DECISION_CODE IGS_AD_PANEL_DTLS.FINAL_DECISION_TYPE
IGS_AD_PNL_HIS_DTLS	IGS_AD_CODE_CLASSES	IGS_AD_PNL_HIS_DTLS.FINAL_DECISION_CODE IGS_AD_PNL_HIS_DTLS.FINAL_DECISION_TYPE
IGS_AD_PNMEMBR_DTLS	IGS_AD_CODE_CLASSES	IGS_AD_PNMEMBR_DTLS.MEMBER_DECISION_CODE IGS_AD_PNMEMBR_DTLS.MEMBER_DECISION_TYPE
IGS_AD_RECRUITMENTS	IGS_AD_CODE_CLASSES	IGS_AD_RECRUITMENTS.SEC_SCHOOL_LOCATION_ID
IGS_AD_RECRUIT_INT	IGS_AD_CODE_CLASSES	IGS_AD_RECRUIT_INT.EMPLOYMENT_ID
IGS_AD_RECRUIT_INT	IGS_AD_CODE_CLASSES	IGS_AD_RECRUIT_INT.INSTITUTION_LOCATION_ID
IGS_AD_RECRUIT_INT	IGS_AD_CODE_CLASSES	IGS_AD_RECRUIT_INT.PROGRAM_INTEREST_ID
IGS_AD_RECRUIT_INT	IGS_AD_CODE_CLASSES	IGS_AD_RECRUIT_INT.SEC_SCHOOL_LOCATION_ID
IGS_AD_RECRUIT_INT	IGS_AD_CODE_CLASSES	IGS_AD_RECRUIT_INT.SPECIAL_INTEREST_ID
IGS_RC_I_APPL_ALL	IGS_AD_CODE_CLASSES	IGS_RC_I_APPL_ALL.EDU_GOAL_ID
IGS_RC_I_APPL_ALL	IGS_AD_CODE_CLASSES	IGS_RC_I_APPL_ALL.HOW_KNOWUS_ID
IGS_RC_I_APPL_ALL	IGS_AD_CODE_CLASSES	IGS_RC_I_APPL_ALL.WHO_INFLUENCED_ID
IGS_SS_ADM_APPL_STG	IGS_AD_CODE_CLASSES	IGS_SS_ADM_APPL_STG.ENTRY_STATUS
IGS_SS_ADM_APPL_STG	IGS_AD_CODE_CLASSES	IGS_SS_ADM_APPL_STG.ENTRY_LEVEL
IGS_SS_ADM_APPL_STG	IGS_AD_CODE_CLASSES	IGS_SS_ADM_APPL_STG.SPCL_GRP_1
IGS_SS_ADM_APPL_STG	IGS_AD_CODE_CLASSES	IGS_SS_ADM_APPL_STG.SPCL_GRP_2
IGS_SS_ADM_APPL_STG	IGS_AD_CODE_CLASSES	IGS_SS_ADM_APPL_STG.APP_SOURCE_ID
IGS_SS_AD_APPINT_STG	IGS_AD_CODE_CLASSES	IGS_SS_AD_APPINT_STG.INTENT_TYPE_ID
IGS_SS_AD_EDUGOA_STG	IGS_AD_CODE_CLASSES	IGS_SS_AD_EDUGOA_STG.EDU_GOAL_ID
IGS_SS_AD_SPLINT_STG	IGS_AD_CODE_CLASSES	IGS_SS_AD_SPLINT_STG.SPECIAL_INTEREST_TYPE_ID
IGS_SS_AD_SPLTAL_STG	IGS_AD_CODE_CLASSES	IGS_SS_AD_SPLTAL_STG.SPECIAL_TALENT_TYPE_ID
IGS_SS_APP_PGM_STG	IGS_AD_CODE_CLASSES	IGS_SS_APP_PGM_STG.EDU_GOAL_PRIOR_ENROLL
IGS_PE_HZ_PARTIES	IGS_AD_CODE_CLASSES	IGS_PE_HZ_PARTIES.SEC_SCHOOL_LOCATION_ID
IGS_OR_INST_STATS	IGS_AD_CODE_CLASSES	IGS_OR_INST_STATS.STAT_TYPE_ID
IGS_PE_ATHLETIC_DTL	IGS_AD_CODE_CLASSES	IGS_PE_ATHLETIC_DTL.ELIGIBILITY_STATUS_ID
IGS_PE_ATHLETIC_PRG	IGS_AD_CODE_CLASSES	IGS_PE_ATHLETIC_PRG.ATHLETIC_PRG_CD
IGS_PE_CREDENTIALS	IGS_AD_CODE_CLASSES	IGS_PE_CREDENTIALS.RATING
IGS_AD_SPL_ADM_CAT	IGS_AD_CODE_CLASSES	IGS_AD_SPL_ADM_CAT.SPL_ADM_CAT
IGS_UC_DEFAULTS	IGS_AD_CODE_CLASSES	IGS_UC_DEFAULTS.DECISION_REASON_ID