Content Comparison

...

The CCCApply “inin_progress_applications” applications table has been added to the Data Warehouse to make it easier for researchers to perform quick queries without having to include the joins manually for every query. 

...

Here is a screenshot of the “inin_progress_applications” applications table in the Data Warehouse folders.

...

Accessing the

...

dw_applied_

...

other Field

1. Log in to the Data Warehouse (DW) via direct access.

2. Open “views” From the schema, open views and then open the “inin_progress_applications” applications table.  Scroll down toward the bottom of the list of fields to see “dwdw_applied_other”other:

...

3. This is a “boolean” boolean field and will show either true or false based on whether the applicant has applied to another school.  

4. You can also access it as you normally would via SQL:

...

6. The logic behind this field is as follows:

   1. The app has NOT been submitted (tstmp_submit is null)

   2. If there is another application to another college during this same term, then true

   3. The term is determined based on the month of the term start date:

      1. Spring = January - May

      2. Summer = June and July

      3. Fall = August - October

      4. Winter = November and December