dbo

3

8

8

The Color Configuration dimension provides color identity for the institution, used by SQL Server Reporting Services to determine color appearence.

9/5/2012 8:22 AM

dbo

3

8

8

The Image Configuration dimension provides image identity for the institution, used by SQL Server Reporting Services to determine the location of images. like a report banner

9/5/2012 8:27 AM

dbo

486199

148352

568

3/9/2017 10:43 AM

dbo

9

8

8

The source, origin, and type of applicant applying to the institution. There will be one row per source of application.

3/9/2017 10:43 AM

dbo

239594

107736

416

3/9/2017 10:43 AM

dbo

3

8

8

3/9/2017 10:43 AM

dbo

1991532

257728

968

Chart of Account information, one row per OrgUnit/GL Code combination per year.

8/28/2013 9:53 AM

dbo

739

128

24

3/9/2017 10:43 AM

dbo

17

8

8

3/9/2017 10:43 AM

dbo

109

16

16

3/9/2017 10:43 AM

dbo

223588

125264

3320

The Curriculum Dimension contains one row per 'class' held or administered by the institution, it is an occurance or instance of a Course.

8/28/2013 9:52 AM

dbo

49309

22528

64

The primary date dimension, allows the data warehouse to resolve dates and perform date functions. There is one row per 'day'.

8/28/2013 9:52 AM

dbo

17385

7704

48

3/9/2017 10:43 AM

dbo

704

80

24

1/28/2014 9:47 AM

dbo

5

8

8

The Full Time Equivalent Classifitions used for grouping when reporting FTE for the institution. There is one row per classifitation.

8/23/2012 3:40 PM

dbo

1611

376

16

Information regarding the GL Codes, will contain one row per GL code.

8/28/2013 9:53 AM

dbo

7688484

852512

3176

Journal Information including Journal Type and Budget Type. Will conain one row per GL-TRANS record.

8/28/2013 9:53 AM

dbo

317327

72720

288

The dimension will contain one row per credit student. The cohort will capture information about the student as they begin their

1/28/2014 9:47 AM

dbo

7687

2728

16

Information regarding the Org Units, one row per Org Unit.

8/28/2013 9:53 AM

dbo

1499496

303688

1144

1/28/2014 9:47 AM

dbo

964430

149960

576

1/28/2014 9:47 AM

dbo

17

8

8

1/28/2014 9:47 AM

dbo

7637

2744

24

3/9/2017 10:43 AM

dbo

77228

18816

88

The dimension will contain one row per student per primary program. Students will be added to cohorts based on their primary pr

1/28/2014 9:47 AM

dbo

120588

18480

88

1/28/2014 9:47 AM

dbo

14

8

8

1/28/2014 9:47 AM

dbo

220032

42776

112

Term Relative Day information including number of days from start of term. One row per Term for the period -365 days prior to the start date and +365 days after the start date for all terms.

5/29/2013 12:12 AM

dbo

6

8

8

Categories of time comparisons for purposes of Retention tracking and measurements.

1/28/2014 9:47 AM

dbo

918991

368720

19952

The Student demographic contains information about a student including the current name, ethnicity and gender. There is one row per student who is assigned a Student ID by the institution

8/28/2013 9:52 AM

dbo

1631585

382888

1440

The Student Objective Dimension contains objective and graduation information about the student. There will be one row per student per program per effective term per sequence number.

8/28/2013 9:53 AM

dbo

5042352

825568

3088

1/28/2014 9:47 AM

dbo

37385

7704

48

The dimension will contain one row per credit student. The Cohort will capture information about the student as they initiate their degree seeking path at the institution, including initial program objective, FT vs. PT status and initial prep status. The student will be added to the cohort for the first major term at the institution when enrolled in one credit class (after high school graduation) when seeking a degree.

1/28/2014 9:47 AM

dbo

4993017

1639296

6128

The Student Term Dimension contains academic and enrollment information about the student for a term. There will be one row per student and term combination where the student could potentially enroll at the the institution.

8/29/2012 1:19 PM

dbo

302

48

16

The Term Dimension contains information including title, start date and end date for session '1' for the term. There is one row per term

8/28/2013 9:53 AM

dbo

41

8

8

3/9/2017 10:43 AM

dbo

68

8

16

Dimension contains data regarding Users, one row per User.

8/28/2013 9:53 AM

dbo

41259

3200

24

1/28/2014 9:47 AM

dbo

221455

15712

8

The Active Enrollment Fact contains the record of the institutional enrollment for the active terms. The enrollment snapshote will be as of the day being processed. The fact will contain one row per student, per class where the student is enrolled (not dropped).

9/5/2012 10:56 AM

dbo

486198

31368

128

3/9/2017 10:43 AM

dbo

18358301

1080792

273512

2/10/2016 1:05 PM

dbo

954374

212224

14240

3/9/2017 10:43 AM

dbo

8613226

682240

2552

The Enrollment Activity Fact conains the record of all registration actions including Adds and Drops per student, per class, per term, per day for all registration actibity.

5/29/2013 12:12 AM

dbo

4718883

352816

1320

The Enrollment Snapshot Fact contains the enrollment for Active Terms and three years prior to each active term as of the Processing Day and for the seven days prior, The fact will contain one row per student, per class where the student is enrolled (not dropped).

5/29/2013 12:12 AM

dbo

3628181

273280

8

The End of Term Enrollment Fact contains the record of the institutional enrollment for the terms for which the institution has been using INTEGROW. The enrollment snapshote will always contains the most current enrollment for the term. The fact will contain one row per student, per class where the student is enrolled (not dropped).

9/10/2012 1:44 PM

dbo

25915

976

16

The record of a posted journal line, one record for each Journal Line. Will contain one row for each chart of account per year that had a roll-over balance.

8/28/2013 9:53 AM

dbo

1142916

42928

176

This is the Summary Balances for each Calendar Period. Will contain one row for each chart of account per calendar period that had transactions.

8/28/2013 9:53 AM

dbo

7688483

1338784

16

The record of a posted journal line, one record for each Journal Line. Will contain all the records for the General Ledger Transactions that have been posted. Data will be added daily.

8/28/2013 9:53 AM

dbo

2573750

98296

38384

3/9/2017 10:43 AM

dbo

1117765

47328

16672

3/9/2017 10:43 AM

dbo

618466

26936

9232

The fact will contain one row per student per term for each applicable tracking term for the retention cohorts. The information

1/28/2014 9:47 AM

dbo

130013

2528

8

This table will provide a bridge between Users and the Org Units to which they have access. Will contain one row per Org Unit per Use that has access to the Org Unit.

8/28/2013 9:53 AM

dbo

1499495

62920

8

1/28/2014 9:47 AM

dbo

104818

5416

1600

3/9/2017 10:43 AM

dbo

4905067

307224

73096

3/9/2017 10:43 AM

dbo

224340

16904

8

The Prior Enrollment Fact contains the record of the institutional enrollment for the terms one year prior to the active terms. The enrollment snapshote will be as of the day being processed. The fact will contain one row per student, per class where the student is enrolled (not dropped).

9/5/2012 10:56 AM

dbo

430497

18072

6432

The fact will contain one row per student per term for every term for 4 years from the cohort term. The information will be cap

1/28/2014 9:47 AM

dbo

120587

7856

8

1/28/2014 9:47 AM

dbo

20138181

927160

643352

1/28/2014 9:47 AM

dbo

3446585

424200

1584

The fact will contain one row per student per class that has received a grade and has been loaded into academic history. The population will be limited to the rows on the ST_ACDMC_HIST_A where the REF_NUM field is not NULL. On a full load all the academic history that meets the condition will be selected. On an incremental load only the rows on the table where the REF_NUM is not NULL and the RowUpdatedOn is within the incremental load dates will be processed.

8/28/2013 9:53 AM

dbo

129378

4864

16

The fact will contain one row per student objective that has been graduated. The population will be limited to the rows on the ST_STDNT_OBJ_AWD_A where the ACT_GRAD_TRM field is not NULL. This will be emptied and reloaded each time, there will be no incremental load.

8/28/2013 9:53 AM

dbo

5531636

209264

82424

1/28/2014 9:47 AM

dbo

5042351

355200

75144

1/28/2014 9:47 AM

dbo

29468

1816

16

The fact will contain one row per student in the Student Success Cohort and will be captured at the end of the term at the one year mark for the student. The fact captures the first year success measures for the degree seeking student. The students first year measures will be captured at the end of the term, one year from the cohort term.

1/28/2014 9:47 AM

dbo

206978

37640

152

The fact will contain one row per student per term for six years for students in the Student Success Cohort. The fact captures information about academic success at the end of each term; including CUM GPA, Term GPA, degree progress, graduation progress, SOAP and enrollment status. The term measures will be captured at the end of each term, whether the student is enrolled in the term or not.

1/28/2014 9:47 AM

dbo

1400064

92304

52128

1/28/2014 9:47 AM

dbo

3508613

245744

127792

1/28/2014 9:47 AM

dbo

1

8

8

The Load Date Time Dimension contains a record of the last load and processed date and time for objects in the data warehouse and cube.

9/4/2012 9:53 AM