ETL Load Sequence

In what order must I run dimension and fact jobs to implement the different Campus Solution Warehouse data marts?

The topic Using the PeopleSoft EPM Lineage Spreadsheets provides information about the ETL jobs that are delivered with the Campus Solutions Warehouse and links to the ETL lineage spreadsheet, which you can use like a reverse-engineering tool and identify the sequence of jobs to run for a specific data mart.

See Understanding the EPM Lineage Spreadsheets.

What is the loading sequence for Campus Solutions Warehouse fact jobs?

There are some aggregate facts in the Campus Solutions Warehouse that have a dependency on the other facts as lookup or source tables. For example, in Student Records, the Academic Plan Summary Fact is the source table for the Institution Summary Fact.

The required loading sequence for each module is provided below.

Admissions and Recruiting:

• SEQ_J_Fact_PS_F_ADM_APPL

• SEQ_J_Fact_PS_F_ADM_APPL_STAT

• SEQ_J_Fact_PS_F_EXT_ACAD_SUMM

• SEQ_J_Fact_PS_F_EXT_TESTSCORE

• SEQ_J_Fact_PS_F_STU_RECRT

Student Financials - Financial Aid:

• SEQ_J_Fact_PS_F_AWD_DISB

• SEQ_J_Fact_PS_F_AWD_SNPSHT

Student Financials - Student Financials:

• SEQ_J_Fact_PS_F_BIL_SNPSHT

• SEQ_J_Fact_PS_F_PYMNT_PENDING

• SEQ_J_Fact_PS_F_SF_TRAN

Student Records:

• SEQ_J_Fact_PS_F_ACAD_PROG_DTL

• SEQ_J_Fact_PS_F_ACADPLAN_SUMM

• SEQ_J_Fact_PS_F_CLASS_ENRLMT

• SEQ_J_Fact_PS_F_CLASS_INSTRCT

• SEQ_J_Fact_PS_F_TERM_ENRLMT

• SEQ_J_Fact_PS_F_INST_SUMM

CRM for Higher Education:

• SEQ_J_Fact_PS_F_CRM_FUNNEL

• SEQ_J_Fact_PS_F_CRM_FUNNEL_S

• SEQ_J_Fact_PS_F_MKT_CMPGN_D

• SEQ_J_Fact_PS_F_MKT_CMPGN_S

Institutional Research:

• SEQ_J_Fact_TF_ADM_FACTS

• SEQ_J_Fact_TF_DEG_COMPLTN

• SEQ_J_Fact_TF_ENRL_FACTS

• SEQ_J_Fact_TF_STDNT_COHORT

• SEQ_J_Fact_TF_STU_ENRL_AGG

• SEQ_J_Fact_TF_STU_TRM_ENRL

What aggregate and/or snapshot fact tables are delivered for Campus Solutions Warehouse?

The Campus Solutions Warehouse provides these aggregate and snapshot tables:

• Award Summary (F_AWD_SNPSHT): Student Financials data mart

• Bill Summary (F_BIL_SNPSHT): Student Financials data mart

• Academic Plan Summary (F_ACADPLAN_SUMM): Student Records data mart

• Institution Summary (F_INST_SUMM): Student Records data mart

For more information on these tables, please refer to the fact table documentation provided in the Understanding the Campus Solutions Warehouse topic.