Populating Tables for Recruiting and Admissions and Campus Community Data

Aside from address and other information, there are some tables that are precursors to all application conversions in Campus Solutions. These tables represent the minimum to be converted.

Academic Organization Tables

Populate these tables in this order for academic organizations:

• INSTITUTION_TBL

• CAMPUS_TBL

• ACAD_CAR_TBL

• ACAD_ORG_TBL

• SUBJECT_TBL

• ACAD_PROG_TBL

• ACAD_PLAN_TBL

• ACAD_SUBPLAN_TBL

Level and Load and Term and Session Tables

Populate these tables in this order for level and load and term and sessions:

• LEVEL_LD_RULE_TBL

• ACAD_LEVEL_TBL

• ACAD_LOAD_TBL

• TERM_TBL

• TERM_VAL_TBL

• SESSION_TBL

• ACAD_CAL_TBL

• ACAD_CALTRM_TBL

• ACAD_CALSES_TBL

In addition to these tables, you must convert these tables as early in the process as possible in the sequence. Use the name and address load routines delivered with the system, to load data:

• PERSON.

• PERS_DATA_EFFDT.

• PER_POI_TYPE.

• PERSONAL_DATA.

• DISABILITY: required for PERS_DATA_EFFDT and PERSONAL_DATA to function properly.

• DIVERSITY: required for PERS_DATA_EFFDT and PERSONAL_DATA to function properly.

• NAMES.

• ADDRESSES: to display and convert any address information, including those on PERSONAL_DATA.

• ADM_PRSPCT_CAR.

• STDNT_CAREER.

• ADM_APPL_DATA.

• ADM_APPL_PROG.

• GENL_MATERIALS: to track materials already received for applications.

• EXT_ORG_TBL.