<?xml version="1.0" encoding="UTF-8" ?>
<!-- This is a WordPress eXtended RSS file generated by WordPress as an export of your site. -->
<!-- It contains information about your site's posts, pages, comments, categories, and other content. -->
<!-- You may use this file to transfer that content from one site to another. -->
<!-- This file is not intended to serve as a complete backup of your site. -->

<!-- To import this information into a WordPress site follow these steps: -->
<!-- 1. Log in to that site as an administrator. -->
<!-- 2. Go to Tools: Import in the WordPress admin panel. -->
<!-- 3. Install the "WordPress" importer from the list. -->
<!-- 4. Activate & Run Importer. -->
<!-- 5. Upload this file using the form provided on that page. -->
<!-- 6. You will first be asked to map the authors in this export file to users -->
<!--    on the site. For each author, you may choose to map to an -->
<!--    existing user on the site or to create a new user. -->
<!-- 7. WordPress will then import each of the posts, pages, comments, categories, etc. -->
<!--    contained in this file into your site. -->

<!-- generator="WordPress/4.9.6" created="2018-05-29 18:40" -->
<rss version="2.0"
	xmlns:excerpt="http://wordpress.org/export/1.2/excerpt/"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:wp="http://wordpress.org/export/1.2/"
>

<channel>
	<title>CUNY Enrollment Reporting</title>
	<link>https://cunyenrollmentreporting.commons.gc.cuny.edu</link>
	<description></description>
	<pubDate>Tue, 29 May 2018 18:40:46 +0000</pubDate>
	<language>en-US</language>
	<wp:wxr_version>1.2</wp:wxr_version>
	<wp:base_site_url>https://commons.gc.cuny.edu</wp:base_site_url>
	<wp:base_blog_url>https://cunyenrollmentreporting.commons.gc.cuny.edu</wp:base_blog_url>



	<generator>https://wordpress.org/?v=4.9.6</generator>

	<item>
		<title>Academic Load</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/academic-load/</link>
		<pubDate>Tue, 29 May 2018 18:39:19 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/academic-load/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Definition</em></u><br>
See <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/full-part-time/">Full Part Time</a>.<br>
<br>
<u><em>Codes and Descriptions`</em></u> <br>


<table class="wiki_table">
    <tr>
        <td>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>CF_ACADEMIC_LOAD</strong><br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>F<br>
</td>
        <td>Full-time<br>
</td>
    </tr>
    <tr>
        <td>H<br>
</td>
        <td>Half-time<br>
</td>
    </tr>
    <tr>
        <td>L<br>
</td>
        <td>Less than half-time<br>
</td>
    </tr>
    <tr>
        <td>T<br>
</td>
        <td>Three-quarters-time<br>
</td>
    </tr>
    <tr>
        <td>N<br>
</td>
        <td>No units<br>
</td>
    </tr>
</table>


    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>2</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:19]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:19]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[academic-load]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>Admission Type</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/admission-type/</link>
		<pubDate>Tue, 29 May 2018 18:39:20 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/admission-type/</guid>
		<description></description>
		<content:encoded><![CDATA[
<em><u>Definitions</u></em><br>
<br>
<strong>First-time Freshmen ('01'):</strong> Students who have not previously earned college credit at any college or university and who are enrolled at a CUNY institution as first-time matriculated freshmen: Included students enrolled as first-time freshmen during the past summer term. Students attending high school during the current term but also enrolled in enrichment courses at the college are to be coded as nondegree students, <em>not</em> as first-time freshmen. (See <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/new-student/">New Student</a> for mapping from CUNYfirst.)<br>
<br>
<strong>Readmit ('74','86','96):</strong> Degree-seeking students who have interrupted their attendance as a matriculant at an institution for a period of at least one full fall or spring term and are readmitted in the current term. Also include students who have interrupted their attendance as matriculants, had become nonmatriculants, and now seek reinstatement with matriculant status. (See <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/readmit/">Readmit</a> for mapping from CUNYfirst.)<br>
<br>
<u><em>Caveats</em></u><br>
<br>
Because of the relative reliability of data elements in CUNYfirst used to calculate Admission Type and because of the challenges involved in filtering out the appropriate program reason from the program plan stack, some students may appear to belong to more than one admission category. For example, it can be difficult to determine whether a student has been readmitted to a degree program after a hiatus or has transferred back after attending another institution. In the script that populates the table CBIL_HISTORY_FACTS, status as a transfer based on program reasons takes precedence over status as a readmit based on program reasons, and status as a readmit based on program reasons takes precedence over status as a transfer based on admit type in the admission record. The order of operations for evaluating Admission Type can be found in the SQL code at the bottom of this page.<br>
<br>
Sources for undergraduate advanced standing transfers (11-26) have not yet been calculated in CBIL. For example, '11' = Undergraduate Transfer from CUNY CC with Degree.<br>
<br>
Upper/lower division transfers (41-43) have not yet been calculated in CBIL. For example, '41' = Internal Transfer from AA to BA with Degree.<br>
<br>
Also see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/new-student/">New Student</a>, <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/readmit/">Readmit</a>, and <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/unclassified-new-undergraduates-or-graduates/">Unclassified New Undergraduates or Graduates</a><br>
<br>
<u><em>Codes and Descriptions</em></u><br>


<table class="wiki_table">
    <tr>
        <th>CBIL_HISTORY_FACTS.<br>
IR_ADMISSION_TYPE_CODE<br>
</th>
        <th>CBIL_HISTORY_FACTS.<br>
IR_ADMISSION_TYPE_DESC<br>
</th>
        <th>CBIL_HISTORY_FACTS.<br>
IR_NEW_STUDENT_CODE<br>
</th>
        <th>CBIL_HISTORY_FACTS.<br>
IR_NEW_STUDENT_DESC<br>
</th>
    </tr>
    <tr>
        <td style="text-align: center;">01<br>
</td>
        <td>First-Time Freshman<br>
</td>
        <td style="text-align: center;">1<br>
</td>
        <td>First-time Freshmen<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">27<br>
</td>
        <td>Undergraduate Transfer from Unknown Sources<br>
</td>
        <td style="text-align: center;">2<br>
</td>
        <td>Advanced Standing Transfers<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">70<br>
</td>
        <td>Internal Transfer from Undergraduate Nondegree<br>
to Degree<br>
</td>
        <td style="text-align: center;">
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">74<br>
</td>
        <td>Undergraduate Readmit<br>
</td>
        <td style="text-align: center;">
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">80<br>
</td>
        <td>First-time Graduate Matriculant<br>
</td>
        <td style="text-align: center;">3<br>
</td>
        <td>First-time Graduate Matriculant<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">84<br>
</td>
        <td>Internal Transfer from Graduate Nondegree to Degree<br>
</td>
        <td style="text-align: center;">
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">86<br>
</td>
        <td>Graduate Readmit<br>
</td>
        <td style="text-align: center;">
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">87<br>
</td>
        <td>Graduate Transfer<br>
</td>
        <td style="text-align: center;">3<br>
</td>
        <td>First-time Graduate Matriculant<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">92<br>
</td>
        <td>College Now<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">93<br>
</td>
        <td>Early College Initiative<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">94<br>
</td>
        <td>Other High School Program<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">95<br>
</td>
        <td>Permit-In<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">96<br>
</td>
        <td>Nondegree Readmit<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">97<br>
</td>
        <td>First-time Nondegree<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">98<br>
</td>
        <td>Continuing Nondegree<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">99<br>
</td>
        <td>Continuing Degree<br>
</td>
        <td style="text-align: center;">
<br>
</td>
        <td>
<br>
</td>
    </tr>
</table>

<br>
<u><em>SQL for Order of Evaluation</em></u><br>
<br>
case when substr(MAIN.STDNT_GROUP_PERMIT_IN_CODE,1,2) = 'PI'<br>
then '95'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('CBUIS','UGRD')<br>
and PROG_REASON_ADMIT_TYPE_6_CODE = '2'<br>
and MAIN.IR_FIRST_STRM_AS_DEGREE = MAIN.CF_STRM<br>
then '01'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('CBUIS','UGRD')<br>
and PROG_REASON_ADMIT_TYPE_6_CODE = '3'<br>
then '27'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('CBUIS','UGRD')<br>
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')<br>
and substr(CF_STRM,4,1) = '2'<br>
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_DEGREE)) &gt; 3<br>
then '74'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('CBUIS','UGRD')<br>
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')<br>
and substr(CF_STRM,4,1) = '9'<br>
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_DEGREE)) &gt; 7<br>
then '74'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('CBUIS','UGRD')<br>
and MAIN.PROG_REASON_INTERN_TRANS_CODE in ('0','8')<br>
and MAIN.IR_FIRST_STRM_AS_DEGREE = MAIN.CF_STRM<br>
then '70'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('CBUIS','UGRD')<br>
and MAIN.ADMIT_TYPE = '2'<br>
and MAIN.IR_FIRST_STRM_AS_DEGREE = MAIN.CF_STRM<br>
then '01'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('CBUIS','UGRD')<br>
and MAIN.ADMIT_TYPE = '3'<br>
then '27'<br>
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')<br>
and PROG_REASON_ADMIT_TYPE_6_CODE = '2'<br>
then '80'<br>
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')<br>
and PROG_REASON_ADMIT_TYPE_6_CODE = '3'<br>
then '87'<br>
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')<br>
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')<br>
and substr(CF_STRM,4,1) = '2'<br>
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_DEGREE)) &gt; 3<br>
then '86'<br>
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')<br>
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')<br>
and substr(CF_STRM,4,1) = '9'<br>
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_DEGREE)) &gt; 7<br>
then '86'<br>
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')<br>
and MAIN.PROG_REASON_INTERN_TRANS_CODE in ('0','8')<br>
and MAIN.IR_FIRST_STRM_AS_DEGREE = MAIN.CF_STRM<br>
then '84'<br>
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')<br>
and MAIN.ADMIT_TYPE = '2'<br>
then '80'<br>
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')<br>
and MAIN.ADMIT_TYPE = '3'<br>
then '87'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('ADVCT','ADVDP','CBUIS','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP','UGRD')<br>
and MAIN.CF_STRM &lt;&gt; MAIN.IR_FIRST_STRM_AS_DEGREE<br>
then '99'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('NDEG','NDEGU')<br>
and MAIN.STDNT_GROUP_HIGH_SCHOOL_CODE<br>
in ('CNOW')<br>
then '92'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('NDEG','NDEGU')<br>
and MAIN.STDNT_GROUP_HIGH_SCHOOL_CODE<br>
in ('ECI','HSCP','HSE','HSEC','HSPT')<br>
then '93'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('NDEG','NDEGU')<br>
and MAIN.STDNT_GROUP_HIGH_SCHOOL_CODE<br>
in ('CP','HIGH','HSAM','HSMD','HSS','JUMP','TWHS')<br>
then '94'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG','DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('NDEGG','NDEG','NDEGU')<br>
and MAIN.IR_FIRST_STRM_AS_NONDEGREE = MAIN.CF_STRM<br>
then '97'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG','DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('NDEGG','NDEG','NDEGU')<br>
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')<br>
and substr(CF_STRM,4,1) = '2'<br>
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_NONDEGREE)) &gt; 3<br>
then '96'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG','DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('NDEGG','NDEG','NDEGU')<br>
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')<br>
and substr(CF_STRM,4,1) = '9'<br>
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_NONDEGREE)) &gt; 7<br>
then '96'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG','DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('NDEGG','NDEG','NDEGU')<br>
and MAIN.IR_FIRST_STRM_AS_NONDEGREE &lt;&gt; MAIN.CF_STRM<br>
then '98'<br>
else '00'<br>
end as IR_ADMISSION_TYPE_CODE,<br>
.
    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>3</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:20]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:20]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[admission-type]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>CBIL Accounts</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/cbil-accounts/</link>
		<pubDate>Tue, 29 May 2018 18:39:22 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/cbil-accounts/</guid>
		<description></description>
		<content:encoded><![CDATA[
College IR offices are the first line of support for new campus users to access and learn to use CBIL.<br>
<br>
Access requires:<br>
<br>
<ol>
<li>A Citrix account provided by CUNY CIS (submit ticket to <a class="wiki_link_ext" href="mailto:Service.Desk@cuny.edu" rel="nofollow">Service.Desk@cuny.edu</a>)</li>
<li>A Citrix web plug-in installed by campus IT</li>
<li>A CBIL account in IRDBPROD2 provided by OIRA<ul>
<li>Campus users should request CBIL accounts through their IR Director</li>
<li>IR Directors should email requests to <a class="wiki_link_ext" href="mailto:Ariel.Cohen@cuny.edu" rel="nofollow">Ariel.Cohen@cuny.edu</a>
</li>
<li>Requests should include new user's name, email address, telephone number, title, and department</li>
</ul>
</li>
</ol>
<br>
Accounts for staff at CUNYfirst Wave 4 schools can be requested between crossover and the beginning of Fall 2014 registration.<br>
<br>
Passwords for Citrix accounts can be reset by calling the CIS Service Desk at <span style="white-space: nowrap;" class="baec5a81-e4d6-4674-97f3-e9220f0136c1">212-541-0981</span><br>
<br>
Passwords for CBIL/IRDB accounts can be reset by calling Albert Moy (OIRA DBA) at <span style="white-space: nowrap;" class="baec5a81-e4d6-4674-97f3-e9220f0136c1">212-541-1007</span><br>
<br>
<span style="white-space: nowrap;" class="baec5a81-e4d6-4674-97f3-e9220f0136c1">Also see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/quick-start-guide/">Quick Start Guide</a></span>
    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>4</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:22]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:22]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[cbil-accounts]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>Course Type</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/course-type/</link>
		<pubDate>Tue, 29 May 2018 18:39:23 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/course-type/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Definitions</em></u><br>
<br>
<strong>Regular Courses</strong>: All non-remedial credit-bearing courses which have no compensatory excess hours attached. These courses should have the value of 'R' coded for the item "IR Course Type Code" and data for the items "IR Credits" and "IR Contact Hours" in the table "CBIL History Course Facts".<br>
<br>
<strong>Compensatory Courses</strong>: All non-remedial credit-bearing courses which have compensatory excess hours attached. These courses should have the value 'C' coded for the item "IR Course Type Code" and data for the items "IR Credits", "IR Equated Credits", and "IR Contact Hours" in the table "CBIL History Course Facts".<br>
<br>
<strong>Developmental Courses</strong>: All remedial credit-bearing courses with or without any additional contact hours, where additional contact hours are all hours in excess of credits, whether compensatory or non-compensatory in nature.These courses should have the value 'D' coded for the item "IR Course Type Code" and data for the items "IR Credits", "IR Equated Credits", and "IR Contact Hours" in the table "CBIL History Course Facts".<br>
<br>
<strong>Non-Credit, Remedial Courses</strong>: All remedial non-credit-bearing courses.These courses should have the value 'N' coded for the item "IR Course Type Code" and data for the items "IR Equated Credits" and "IR Contact Hours" in the table "CBIL History Course Facts".<br>
<br>
<strong>Graduate Courses</strong>: All courses offered in the graduate division.These courses should have the value of 'G' coded for the item "IR Course Type Code" and data for the items "IR Credits" and "IR Contact Hours" in the table "CBIL History Course Facts".<br>
<br>
<strong>Laboratory/Studio Course/Sections</strong>: Course/Sections which meet at a regularly scheduled time and make use of specialized equipment.These courses should have the value of 'L' coded for the item "IR Course Type Code" and data for the items "IR Credits" and "IR Contact Hours" in the table "CBIL History Course Facts".<br>
<br>
<strong>Message Courses</strong>: Courses used to report hours which determine the item "IR Full Part Time Code" in the table "CBIL History Facts" even though the student is not actually sitting in a classroom at the home college. For example, students taking courses at another CUNY college on permit or students on maintenance of matriculation.These courses should have the value of 'M' coded for the item "IR Course Type Code" and data for the items "IR Credits" and "IR Contact Hours" in the table "CBIL History Course Facts".<br>
<br>
<u><em>Caveats</em></u><br>
<br>
In CUNYfirst, the course type is embedded in the requirement designation and may be assigned a default value when the requirement designation is missing.<br>
<br>
<ul>
<li>"IR Course Type Code" = 'R'</li>
<li>where "CF Requirement Designation" = null and "CF Academic Career" in ('UGRD', 'UKCC', 'ULAG') and "CF Units Taken" &gt; 0</li>
</ul>
<br>
<ul>
<li>"IR Course Type Code" = 'N'</li>
<li>where "CF Requirement Designation" = null and "CF Academic Career" in ('UGRD', 'UKCC', 'ULAG') and "CF Units Taken" = 0</li>
</ul>
<br>
<ul>
<li>"IR Course Type Code" = 'G'</li>
<li>where "CF Requirement Designation" = null and "CF Academic Career" in ('GRAD','LAW','DOCT') and "CF Units Taken" &gt; 0</li>
</ul>
<br>
<br>
<u><em>Mapping from CUNYfirst</em></u><br>


<table class="wiki_table">
    <tr>
        <td>
<strong>CF_CRSE_CATALOG CTLG.</strong><br>
<strong>RQMNT_DESIGNTN</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_COURSE_FACTS.</strong><br>
I<strong>R_COURSE_TYPE_CODE</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_COURSE_FACTS.</strong><br>
<strong>COURSE_TYPE_DESC</strong><br>
</td>
    </tr>
    <tr>
        <td>CLA<br>
</td>
        <td>C<br>
</td>
        <td>Compensatory<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
</table>


    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>5</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:23]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:23]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[course-type]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>Credits and Hours</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/credits-and-hours/</link>
		<pubDate>Tue, 29 May 2018 18:39:25 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/credits-and-hours/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Definition</em></u><br>
<br>
The data point "<strong>IR Credits+Hours Sum</strong>" in the CBIL Enrollment Report and CBIL Flash Dataset includes both degree credits and remedial hours and is calculated by summing all of the values in the item "IR Crd Hrs Sem Total" for a given term. The item "<strong>IR Crd Hrs Sem Total</strong>" in the table CBIL_HISTORY_FACTS is calculated by aggregating the items "IR Credits" and "IR Equated Credits" from the table CBIL_HISTORY_COURSE_FACTS.<br>
<br>
The item "<strong>IR Credits</strong>" in the table CBIL_HISTORY_COURSE_FACTS includes the total number of credits applicable towards a degree for the course/section of regular, compensatory, developmental, graduate, and laboratory courses.<br>
<br>
<ul>
<li>IR Credits = CF Units Taken</li>
<li>where IR Course Type is 'R' (regular), 'C' (compensatory), 'D' (developmental), 'G' (graduate), or 'L' (laboratory).</li>
</ul>
<br>
The item "<strong>IR Equated Credits</strong>" in the table CBIL_HISTORY_COURSE_FACTS includes the total number of remedial hours per week for course/section of compensatory, developmental, and noncredit remedial courses.<br>
<br>
<ul>
<li>IR Equated Credits = CF Units Progress - CF Units Taken</li>
<li>where IR Course Type is 'C' (compensatory), 'D' (developmental), or 'N' (noncredit)</li>
</ul>
<br>
<u><em>Caveats</em></u><br>
<br>
While in OIRA terminology, "equated credits" have traditionally referred to the remedial portion of a course load, in the SIMS system "equated credits" included both degree credits and remedial hours, i.e., total billable credits. Units progress in CUNYfirst are similar to equated credits in SIMS.<br>
<br>
Because not all units progress from CUNYfirst are included the in item "IR Crd Hrs Sem Total" in the table CBIL_HISTORY_FACTS, it may be less than the field UNT_TAKEN_PRGRSS in the table CF_STDNT_CAR_TERM.<br>
<br>
Units progress in message courses (including those for permits-out) are not included in the item "IR Crd Hrs Sem Total". While permits are included in the <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/headcount/">Headcount</a> of the home college, their credits and hours are included in the <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/fte/">FTE</a> of the host college.<br>
<br>
When units progress exceed units taken in regular, graduate, or laboratory courses, the excess units are not included the item "IR Crd Hrs Sem Total". It is not unusual for nursing and medical technology courses to have more contact hours than billable credits and more billable credits than credits that count towards FTEs.<br>
<br>
The item "IR Crd Hrs Sem Total" cannot be evaluated for courses missing a Requirement Designation because it is used to determine the "IR Course Type".<br>
<br>
Official enrollment reports are produced from Show-Registration files generated from I-184a extracts scheduled in CUNYfirst after the last day students are eligible for a 25% tuition refund ("cutoff date" or "census date"). For the community colleges, courses with WN grades are excluded from the credits and hours used to compute FTEs in official enrollment reports because students receiving WN grades had not participated in any classes prior to the cutoff date. In CBIL, however, such logic has not yet been applied to the item "IR Crd Hrs Sem Total" because the CBIL Enrollment Report and the Flash Dataset are used primarily before the cutoff date comes.<br>
<br>
Also see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/headcount/">Headcount</a> and <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/fte/">FTE</a><br>
<br>
<u><em>Sample Mapping from CUNYfirst</em></u><br>


<table class="wiki_table">
    <tr>
        <td>
<strong>CF_STDNT_ENRL.</strong><br>
<strong>UNT_PRGRSS</strong><br>
</td>
        <td>
<strong>CF_STDNT_ENRL.</strong><br>
<strong>UNT_TAKEN</strong><br>
</td>
        <td>
<strong>CF_CRSE_CATALOG_CTLG.</strong><br>
<strong>RQMNT_DESIGNTN</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_COURSE_FACTS.</strong><br>
<strong>IR_COURSE_TYPE_CODE</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_COURSE_FACTS.</strong><br>
<strong>IR_CREDITS</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_COURSE_FACTS.</strong><br>
<strong>IR_EQUATED_CREDITS</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>IR_CRD_HRS_SEM_TOTAL</strong><br>
</td>
    </tr>
    <tr>
        <td>3.00<br>
</td>
        <td>3.00<br>
</td>
        <td>FCER<br>
</td>
        <td>R<br>
</td>
        <td>3.0<br>
</td>
        <td>0.0<br>
</td>
        <td>3.0<br>
</td>
    </tr>
    <tr>
        <td>4.00<br>
</td>
        <td>3.00<br>
</td>
        <td>RECC<br>
</td>
        <td>C<br>
</td>
        <td>3.0<br>
</td>
        <td>1.0<br>
</td>
        <td>4.0<br>
</td>
    </tr>
    <tr>
        <td>5.00<br>
</td>
        <td>3.00<br>
</td>
        <td>COPD<br>
</td>
        <td>D<br>
</td>
        <td>3.0<br>
</td>
        <td>2.0<br>
</td>
        <td>5.0<br>
</td>
    </tr>
    <tr>
        <td>0.00<br>
</td>
        <td>3.00<br>
</td>
        <td>NNL<br>
</td>
        <td>N<br>
</td>
        <td>0.0<br>
</td>
        <td>3.0<br>
</td>
        <td>3.0<br>
</td>
    </tr>
    <tr>
        <td>3.00<br>
</td>
        <td>3.00<br>
</td>
        <td>GLA<br>
</td>
        <td>G<br>
</td>
        <td>3.0<br>
</td>
        <td>0.0<br>
</td>
        <td>3.0<br>
</td>
    </tr>
    <tr>
        <td>1.00<br>
</td>
        <td>1.00<br>
</td>
        <td>LNL<br>
</td>
        <td>L<br>
</td>
        <td>1.0<br>
</td>
        <td>0.0<br>
</td>
        <td>1.0<br>
</td>
    </tr>
    <tr>
        <td>3.00<br>
</td>
        <td>3.00<br>
</td>
        <td>MNL<br>
</td>
        <td>M<br>
</td>
        <td>0.0<br>
</td>
        <td>0.0<br>
</td>
        <td>0.0<br>
</td>
    </tr>
</table>


    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>6</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:25]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:25]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[credits-and-hours]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>Degree Status</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/degree-status/</link>
		<pubDate>Tue, 29 May 2018 18:39:26 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/degree-status/</guid>
		<description></description>
		<content:encoded><![CDATA[
<em><u>Definition</u></em><br>
<strong>Degree students</strong> are matriculated in degree-seeking programs. <strong>Nondegree students</strong> are enrolled in degree-credit courses, but not matriculated in degree-seeking programs.<br>
<br>
<u><em>Caveats</em></u><br>
The primary driver in CUNYfirst for Degree Status is the field ACAD_PROG_PRIMARY in the table CF_STDNT_CAR_TERM, but if the field ACAD_PROG_PRIMARY is inconsistent with the field ACAD_CAREER, the student is defined as nondegree. Students for whom the field ACAD_PROG_PRIMARY is missing or unmapped are also defaulted to nondegree.<br>
<br>
<em><u>Codes and Descriptions</u></em><br>


<table class="wiki_table">
    <tr>
        <td>
<strong>IR_DEGREE_STATUS_CODE</strong><br>
</td>
        <td>
<strong>IR_DEGREE_STATUS_DESC</strong><br>
</td>
    </tr>
    <tr>
        <td>D<br>
</td>
        <td>DEGREE<br>
</td>
    </tr>
    <tr>
        <td>N<br>
</td>
        <td>NONDEGREE<br>
</td>
    </tr>
</table>

<u><em>Sample Mapping from CUNYfirst</em></u><br>


<table class="wiki_table">
    <tr>
        <td>
<strong>CF_STDNT_CAR_TERM.</strong><br>
<strong>INSTITUTION</strong><br>
</td>
        <td>
<strong>CF_STDNT_CAR_TERM.</strong><br>
<strong>ACAD_CAREER</strong><br>
</td>
        <td>
<strong>CF_STDNT_CAR_TERM.</strong><br>
<strong>ACAD_PROG_PRIMARY</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>IR_DEGREE_STATUS_CODE</strong><br>
</td>
    </tr>
    <tr>
        <td>QNS01<br>
</td>
        <td>UGRD<br>
</td>
        <td>UGRD<br>
</td>
        <td>D<br>
</td>
    </tr>
    <tr>
        <td>QNS01<br>
</td>
        <td>UGRD<br>
</td>
        <td>CBIS<br>
</td>
        <td>D<br>
</td>
    </tr>
    <tr>
        <td>KCC01<br>
</td>
        <td>UKCC<br>
</td>
        <td>UGRD<br>
</td>
        <td>D<br>
</td>
    </tr>
    <tr>
        <td>QNS01<br>
</td>
        <td>GRAD<br>
</td>
        <td>MA<br>
</td>
        <td>D<br>
</td>
    </tr>
    <tr>
        <td>HTR01<br>
</td>
        <td>DOCT<br>
</td>
        <td>DNP<br>
</td>
        <td>D<br>
</td>
    </tr>
    <tr>
        <td>QCC01<br>
</td>
        <td>UGRD<br>
</td>
        <td>NDEG<br>
</td>
        <td>N<br>
</td>
    </tr>
    <tr>
        <td>QNS01`<br>
</td>
        <td>UGRD<br>
</td>
        <td>NDEGU<br>
</td>
        <td>N<br>
</td>
    </tr>
    <tr>
        <td>QNS01<br>
</td>
        <td>GRAD<br>
</td>
        <td>NDEGG<br>
</td>
        <td>N<br>
</td>
    </tr>
    <tr>
        <td>QNS01<br>
</td>
        <td>
<span style="background-color: #ffff00;">GRAD</span><br>
</td>
        <td>
<span style="background-color: #ffff00;">UGRD</span><br>
</td>
        <td>N<br>
</td>
    </tr>
    <tr>
        <td>QNS01<br>
</td>
        <td>
<span style="background-color: #ffff00;">GRAD</span><br>
</td>
        <td>
<br>
</td>
        <td>N<br>
</td>
    </tr>
</table>


    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>7</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:26]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:26]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[degree-status]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>FTE</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/fte/</link>
		<pubDate>Tue, 29 May 2018 18:39:28 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/fte/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Definition and Caveats</em></u><br>
<br>
An <strong>FTE</strong> is a hypothetical <strong>Full-Time Equivalent</strong> student enrolled in 30 credits or equivalent hours in an undergraduate-level course of study during an academic year (summer, fall, and spring). Because of the higher work load, a graduate FTE is defined as 24 credits in a graduate-level course of study during an academic year.<br>
<br>
When calculating FTEs for a fall or spring semester by itself, an undergraduate FTE is defined as 15 credits plus hours and a graduate FTE is defined as 12 credits. (When calculating FTEs for a summer or winter semester by itself, however, an undergraduate FTE is still defined as 30 credits plus hours and a graduate FTE is defined as 24 credits. For a fall or spring semester by itself, FTEs can be "annualized" because 15 credits would be an average load for an undergraduate student, but annualized FTEs cannot be defined for summer and winter semesters by themselves.)<br>
<br>
<ul>
<li>
<strong>IR FTE Semester Undergraduate SUM</strong> = (IR_CRD_SEM_UGRD_LEVEL + IR_HRS_SEM_UGRD_LEVEL) / 15</li>
<li>where IR_SEMESTER_ENROLLED_CODE in ('02,'09)</li>
</ul>
<br>
<ul>
<li>
<strong>IR FTE Semester Graduate SUM</strong> = IR_CRD_SEM_GRAD_LEVEL / 12</li>
<li>where IR_SEMESTER_ENROLLED_CODE in ('02,'09)</li>
</ul>
<br>
<ul><li>
<strong>IR FTE Semester Total SUM</strong> = IR FTE Semester Undergraduate SUM + IR FTE Semester Graduate SUM</li></ul>
<br>
Please note that undergraduate and graduate FTEs are calculated separately from <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/credits-and-hours/">Credits and Hours</a> aggregated from the course-level as defined by course type before being added together. However, the data points <strong>"IR Credits+Hours"</strong> and <strong>"</strong><strong>IR Semester FTEs"</strong> are distributed across student-level categories in the CBIL Enrollment Report. Usually the number of undergraduate-level students taking graduate-level courses (and vice versa) is small and tends to be cancelled out by the number of graduate-level students taking undergraduate-level courses (and vice versa).<br>
<br>
FTEs for doctoral students are included in the data point for graduate FTEs, but should be calculated from both course-level and student-level data:.<br>
<br>
<ul>
<li>Level 1 Doctoral FTE = IR_CRD_SEM_GRAD_LEVEL / 12</li>
<li>where CF_ACAD_CAREER = 'DOCT' and CF_ACAD_LEVEL_BOT = 'P1'</li>
</ul>
<br>
<ul>
<li>Level 2 Doctoral FTE = IR_HEADCOUNT</li>
<li>where CF_ACAD_CAREER = ' DOCT' and CF_ACAD_LEVEL_BOT = 'P2'</li>
</ul>
<br>
<ul>
<li>Level 3 Doctoral FTE = IR_HEADCOUNT * .6954625</li>
<li>where CF_ACAD_CAREER = ' DOCT' and CF_ACAD_LEVEL_BOT = 'P3'</li>
</ul>
<br>
When Show-Registration files are loaded into the IRDB, FTEs for doctoral students are calculated appropriately during the load process. The CBIL Flash Dataset has columns for "IR Headcount" and "IR Credits+Hours" but not "IR Semester FTEs". In the Preliminary Enrollment Report, FTEs are calculated after flash data have downloaded into an Access database. <span style="color: #ff0000;">In the CBIL Enrollment Report, however, there is a column for "IR Semester FTEs", but it does not yet reflect an appropriate calculation for doctoral students. </span><br>
<br>
As with data points for <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/credits-and-hours/">Credits and Hours</a>, all data points for FTEs exclude message courses (such as those used for permits-out and CUNYStart participants), senior citizens auditing courses at the senor colleges, and courses with WN grades at the community college. Please remember permit students are included in the <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/headcount/">Headcount</a> of the home college and the FTEs of the host college.<br>
<br>
<span style="color: #000000;">Also see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/credits-and-hours/">Credits and Hours</a> and <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/headcount/">Headcount</a></span>
    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>8</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:28]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:28]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[fte]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>First STRM as Degree</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/first-strm-as-degree/</link>
		<pubDate>Tue, 29 May 2018 18:39:29 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/first-strm-as-degree/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Definition</em></u><br>
<br>
The item "<strong>IR First STRM as Degree</strong>" in the folder "CBIL History Facts" is the earliest fall or spring term in which a student was enrolled for courses in a degree-seeking program within an academic career in a particular institution.<br>
<br>
Also see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/degree-status/">Degree Status</a> and <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/new-student/">New Student</a><br>
<br>
<em><u>SQL Code</u></em><br>
<br>
drop table IR.CBIL_CF_STDNT_CAR_TERM_THIN purge;<br>
create table IR.CBIL_CF_STDNT_CAR_TERM_THIN<br>
tablespace CBIL_DATA<br>
as select EMPLID,<br>
ACAD_CAREER,<br>
INSTITUTION,<br>
STRM,<br>
ACAD_PROG_PRIMARY<br>
from ERP.CF_STDNT_CAR_TERM;<br>
<br>
drop table IR.CBIL_CF_STDNT_ENRL_DISTINCT purge;<br>
create table IR.CBIL_CF_STDNT_ENRL_DISTINCT<br>
tablespace CBIL_DATA<br>
as select distinct EMPLID,<br>
ACAD_CAREER,<br>
INSTITUTION,<br>
STRM<br>
from ERP.CF_STDNT_ENRL<br>
where STDNT_ENRL_STATUS = 'E';<br>
<br>
drop table IR.CBIL_CF_FTDS purge;<br>
create table IR.CBIL_CF_FTDS<br>
tablespace CBIL_DATA<br>
as select<br>
distinct SUBQ.EMPLID,<br>
SUBQ.ACAD_CAREER,<br>
SUBQ.INSTITUTION,<br>
SUBQ.IR_FIRST_STRM_AS_DEGREE<br>
from (select CART.EMPLID, CART.ACAD_CAREER, CART.INSTITUTION,<br>
CART.STRM as IR_FIRST_STRM_AS_DEGREE,<br>
rank() over (partition by CART.EMPLID, CART.ACAD_CAREER, CART.INSTITUTION<br>
order by CART.STRM asc) as MAX_RANK<br>
from IR.CBIL_CF_STDNT_CAR_TERM_THIN CART,<br>
IR.CBIL_CF_STDNT_ENRL_DISTINCT ENRL<br>
where substr(CART.ACAD_PROG_PRIMARY,1,4) not in ('NDEG')<br>
and substr(CART.STRM,4,1) &lt;&gt; '6'<br>
and substr(ENRL.STRM,4,1) &lt;&gt; '6'<br>
and ENRL.EMPLID = CART.EMPLID<br>
and ENRL.ACAD_CAREER = CART.ACAD_CAREER<br>
and ENRL.INSTITUTION = CART.INSTITUTION<br>
and ENRL.STRM = CART.STRM) SUBQ<br>
where MAX_RANK = 1;
    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>9</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:29]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:29]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[first-strm-as-degree]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>Full Part Time</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/full-part-time/</link>
		<pubDate>Tue, 29 May 2018 18:39:30 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/full-part-time/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Definition</em></u><br>
<br>
<strong>Full-time</strong> students are enrolled in 12 or more units progress in CUNYfirst.<br>
<br>
<strong>Certified full-time</strong> students are currently undefined in CUNYfirst.<br>
<br>
<strong>Part-time</strong> students are enrolled in less than 12 units progress.<br>
<br>
<u><em>Caveats</em></u><br>
<br>
The item "IR Full-time/Part-time" in the CBIL Enrollment Report is calculated from all units progress, but the data point "IR Credits+Hours" in the excludes units progress in message courses and units progress in course with WN grades at the community colleges. In other words, full/part-time status is based on the billable credits rather than the credits that count towards FTEs. Therefore, the item "IR Full-time/Part-time" and the data point "IR Credits+Hours" may appear inconsistent when drilling down to student-level data.<br>
<br>
In CUNYfirst, the field ACADEMIC_LOAD in the table CF_STDNT_CAR_TERM is comparable to the item "IR Full-time/Part-time" but excludes courses with withdrawals. Therefore, ACADEMIC_LOAD and "IR Full-time/Part-time" should have similar values at the beginning of the term, but may diverge as withdrawal grades accumulate.<br>
<br>
See also <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/credits-and-hours/">Credits and Hours</a> and <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/academic-load/">Academic Load</a><br>
<br>
<u><em>Codes and Descriptions</em></u><br>
<br>


<table class="wiki_table">
    <tr>
        <td>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>IR_FULL_PART_TIME_CODE</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>IR_FULL_PART_TIME_DESC</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>IR_FULL_PART_TYPE_CODE</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>IR_FULL_PART_TYPE_DESC</strong><br>
</td>
    </tr>
    <tr>
        <td>1<br>
</td>
        <td>FULL-TIME<br>
</td>
        <td>1<br>
</td>
        <td>FULL-TIME<br>
</td>
    </tr>
    <tr>
        <td>2<br>
</td>
        <td>CERTIFIED FULL-TIME<br>
</td>
        <td>1<br>
</td>
        <td>FULL-TIME<br>
</td>
    </tr>
    <tr>
        <td>3<br>
</td>
        <td>PART-TIME<br>
</td>
        <td>2<br>
</td>
        <td>PART-TIME<br>
</td>
    </tr>
</table>


    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>10</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:30]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:30]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[full-part-time]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>Headcount</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/headcount/</link>
		<pubDate>Tue, 29 May 2018 18:39:32 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/headcount/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Definition</em></u><br>
While any student enrolled in at least one course is included in the dataset upon which the CBIL Enrollment Report is based, certain populations should be excluded from being counted in official enrollment reports. The populations currently excluded from the item "IR Headcount" are permits-in at all colleges and senior citizens auditing at the senior colleges, which are both based on active membership in certain student groups.<br>
<br>
The item "IR Headcount" in the CBIL Enrollment Report and the CBIL Flash Dataset is calculated using the aggregate function SUM on the field IR_HEADCOUNT in the table CBIL_HISTORY_FACTS. Records in which the field IR_HEADCOUNT = 1 are counted in the item "IR Headcount" but records in which the field IR_HEADCOUNT are null are not counted from the item "IR Headcount".<br>
<br>
<u><em>Caveats</em></u><br>
In the Show-Registration files produced by OIRA from the I-184a interface, community college students receiving WN grades in all non-message courses and students enrolled only in CUNYStart sections are also exluced from headcount in official enrollment reports. <span style="color: #ff0000;">Logic excluding X-flagged and CUNYStart students is not yet reflected in the CBIL "IR Headcount".</span><br>
<br>
Also see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/record-count/">Record Count</a><br>
<br>
<u><em>Mapping from CUNYfirst</em></u><br>


<table class="wiki_table">
    <tr>
        <td>
<strong>CF_STDNT_GRPS_HIST.</strong><br>
<strong>STDNT_GROUP</strong><br>
</td>
        <td>
<strong>CF_CRSE_ATTRIBUTES.</strong><br>
<strong>ATTR</strong><br>
</td>
        <td>
<strong>CF_STDNT_ENRL_ENRL.</strong> <strong>CRSE_GRADE_OFF</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>IR_SPECIAL_INDICATOR_CODE</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>IR_OTHER_SPECIAL_PROG_CODE</strong><br>
</td>
        <td>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>IR_HEADCOUNT</strong><br>
</td>
    </tr>
    <tr>
        <td>where group = 'SCIT'<br>
and INSTITUTION in ('BKL01','CSI01','HTR01',<br>
'LAW01','LEH01','NYT01',<br>
'QNS01','YRK01')<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>'N'<br>
</td>
        <td>
<br>
</td>
        <td>null<br>
</td>
    </tr>
    <tr>
        <td>where group in<br>
('PI01','PI02',...)<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>'P'<br>
</td>
        <td>
<br>
</td>
        <td>null<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>where all attributes = 'STRT'<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>'48'<br>
</td>
        <td>1<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>where all grades = 'WN'<br>
and INSTITUTION in<br>
('BCC01','BMC01','HOS01',<br>
KCC01','LAG01','NCC01',<br>
QCC01')<br>
</td>
        <td>'X'<br>
</td>
        <td>
<br>
</td>
        <td>1<br>
</td>
    </tr>
</table>


    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>11</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:32]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:32]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[headcount]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>New Student</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/new-student/</link>
		<pubDate>Tue, 29 May 2018 18:39:33 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/new-student/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Overview and Caveats</em></u><br>
<br>
<strong>New Students</strong> should be identified primarily by the field PROG_REASON in the table CF_ACAD_PROG where the field ADMIT_TERM is equal to the field STRM in the table CF_STDNT_CAR_TERM. (When the ADMIT_TERM is a summer term, it is recoded to the following fall term. For example, '1136' --&gt; '1139'). New Students can be classified by <strong>Admission Type, Class Level, and Degree Status</strong>.<br>
<br>
<a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/admission-type/">Admission Type</a>: Whether a student should be classified as a first-time matriculant at an institution or a transfer from another institution is determined by the field PROG_REASON in the table CF_ACAD_PROG. For example, the program reason '2' indicates a first-time student and the program reason '3' indicates a transfer student.<br>
<br>
<strong>Class Level</strong>: Whether a student should be classified as a new undergraduate student or a new graduate student is determined by the field ACAD_CAREER in the table CF_STDNT_CAR_TERM. For example, the academic career 'UGRD indicates an undergraduate student and the academic career 'GRAD' indicators a graduate student.<br>
<br>
<a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/degree-status/">Degree Status</a>: Whether a student should be classified as a new degree student or a new nondegree student is determined by the field ACAD_PROG_PRIMARY in the table CF_STDNT_CAR_TERM. For example, the academic program 'UGRD' indicates a degree student and the academic program 'NDEGU' indicates a nondegree student.<br>
<br>
<strong>Missing or inconsistent data:</strong> In order to be classified as a new student--especially a first-time freshmen or transfer--the academic career and academic program must be consistent, and an appropriate program reason must be found in the program plan stack where the admit term is the same as the current term of enrollment. When the academic career and academic program are inconsistent, the academic career takes precedence over the academic program (see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/degree-status/">Degree Status</a>). When an appropriate program reason is missing, the field ADMIT_TYPE in the table CF_ADM_APPL_DATA may be used instead. However, because a student may have multiple admission events in the same institution and multiple admission terms may exist in the program plan stack, it is not always clear which one should be linked the admit type in the admissions record. Therefore, when ADMIT_TYPE is used instead of PROG_REASON or a match with the CAS or ASTA file is used instead of PROG_REASON, the current term must also be the first fall or spring term enrolled in courses as a degree-seeking student (see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/first-strm-as-degree/">First STRM as Degree</a>).<br>
<br>
<strong>Additional program reasons:</strong> When the admission module is implemented in CUNYfirst, information about the Class Level and <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/degree-status/">Degree Status</a> will be embedded into the admit type and the admit type will be pushed into the program reason when the applicant matriculates and is moved into student records. For example, 'GDS' for first-time graduate matriculant. When reconciling inconsistencies, the academic career in the current term record will still take precedence over the primary academic program, and both will take precedence over any program reasons where the admission term is the same as current term of enrollment.<br>
<br>
Also see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/admission-type/">Admission Type</a> and <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/unclassified-new-undergraduates-or-graduates/">Unclassified New Undergraduates or Graduates</a>.<br>
<br>
<u><em>Definitions</em></u><br>
<br>
<strong>First-time Freshman ('01'):</strong> A student in an undergraduate academic career and a degree-seeking academic program who has a program reason of '2' where the admit term equals both the current term and the first fall or spring term enrolled in courses as a degree-seeking student within the same institution and academic career. If no program reason can be found in the program plan stack, but the current term is the first fall or spring term enrolled in courses as a degree student, then the admit type in the admission record or a match with a CAS file can be used to classify a student as a first-time freshman. Summer admit terms are recoded to fall admit terms for the purpose of identifying new students.<br>
<br>
<ul>
<li>CF_STDNT_CAR_TERM.STRM in (Fall or Spring) and</li>
<li>CF_STDNT_CAR_TERM.ACAD_CAREER in ('UGRD','UKCC','ULAG) and</li>
<li>CF_STDNT_CAR_TERM.ACAD_PROG_PRIMARY in ('UGRD','CBUIS) and</li>
<li>CF_ACAD_PROG.PROG_REASON = '2'</li>
<li>or</li>
<li>CF_ADM_APPL_DATA.ADMIT_TYPE = '2'</li>
<li>or</li>
<li>CBIL_CAS_FILE.FILETERM = CF_STDNT_CAR_TERM.STRM</li>
<li>where</li>
<li>CF_ACAD_PROG.ADMIT_TERM = CF_STDNT_CAR_TERM.STRM and</li>
<li>CF_ACAD_PROG.INSTITUTION = CF_STDNT_CAR_TERM.INSTITUTION and</li>
<li>CF_ACAD_PROG.ACAD_CAREER = CF_STDNT_CAR_TERM.ACAD_CAREER and</li>
<li>CBIL_HISTORY_FACTS.IR_FIRST_STRM_AS_DEGREE = CF_STDNT_CAR_TERM.STRM</li>
</ul>
<br>
<u><em>Sample Mapping from CUNYfirst</em></u><br>
<br>


<table class="wiki_table">
    <tr>
        <th>CF_STDNT_CAR_TERM.<br>
STRM<br>
</th>
        <th>CF_STDNT_CAR_TERM.<br>
ACAD_CAREER<br>
</th>
        <th>CF_STDNT_CAR_TERM<br>
ACAD_PROG_PRIMARY<br>
</th>
        <th>CF_ACAD_PROG.<br>
ADMIT_TERM<br>
</th>
        <th>CF_ACAD_PROG.<br>
PROG_REASON<br>
</th>
        <th>CF_ADM_APPL_DATA.<br>
ADMIT_TYPE<br>
</th>
        <th>CBIL_CAS_FILE.<br>
FILETERM<br>
</th>
        <th>CBIL_ASTA_FILE.<br>
FILETERM<br>
</th>
        <th>CBIL_HISTORY_FACTS.<br>
IR_FIRST_TERM_AS_DEGREE<br>
</th>
        <th>CBIL_HISTORY_FACTS.<br>
IR_ADMISSION_TYPE_CODE<br>
</th>
        <th>CBIL_HISTORY_FACTS.<br>
IR_ADMISSION_TYPE_DESC<br>
</th>
    </tr>
    <tr>
        <td>1136<br>
</td>
        <td>UGRD<br>
</td>
        <td>UGRD<br>
</td>
        <td>1136<br>
</td>
        <td>2<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>1139<br>
</td>
        <td>00<br>
</td>
        <td>Unknown<br>
</td>
    </tr>
    <tr>
        <td>1139<br>
</td>
        <td>UGRD<br>
</td>
        <td>UGRD<br>
</td>
        <td>1136<br>
</td>
        <td>2<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>1139<br>
</td>
        <td>01<br>
</td>
        <td>First-time Freshman<br>
</td>
    </tr>
    <tr>
        <td>1139<br>
</td>
        <td>UKCC<br>
</td>
        <td>UGRD<br>
</td>
        <td>1139<br>
</td>
        <td>2<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>1139<br>
</td>
        <td>01<br>
</td>
        <td>First-time Freshman<br>
</td>
    </tr>
    <tr>
        <td>1139<br>
</td>
        <td>ULAG<br>
</td>
        <td>UGRD<br>
</td>
        <td>1139<br>
</td>
        <td>
<br>
</td>
        <td>2<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>1139<br>
</td>
        <td>01<br>
</td>
        <td>First-time Freshman<br>
</td>
    </tr>
    <tr>
        <td>1139<br>
</td>
        <td>UGRD<br>
</td>
        <td>CBUIS<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>201309<br>
</td>
        <td>
<br>
</td>
        <td>1139<br>
</td>
        <td>01<br>
</td>
        <td>First-time Freshman<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
</table>

<br>
<u><em>SQL for Finding Program Reasons for New Students</em></u><br>
<br>
create table IR.CBIL_CF_ADM6<br>
tablespace CBIL_DATA<br>
as<br>
select<br>
distinct SUBQ.CF_EMPLID,<br>
SUBQ.CF_ACAD_CAREER,<br>
SUBQ.CF_INSTITUTION,<br>
SUBQ.CF_STRM,<br>
SUBQ.IR_TERM_ENROLLED_DATE,<br>
SUBQ.EFFDT,<br>
SUBQ.EFFSEQ,<br>
SUBQ.PROG_ACTION,<br>
SUBQ.PROG_REASON<br>
from (select<br>
CART.CF_EMPLID,<br>
CART.CF_ACAD_CAREER,<br>
CART.CF_INSTITUTION,<br>
CART.CF_STRM,<br>
CART.IR_TERM_ENROLLED_DATE,<br>
CART.CF_STDNT_CAR_NBR,<br>
PROG.EFFDT,<br>
PROG.EFFSEQ,<br>
PROG.PROG_ACTION,<br>
PROG.PROG_REASON,<br>
PROG.PROG_STATUS,<br>
rank() over (partition by CART.CF_EMPLID, CART.CF_ACAD_CAREER, CART.CF_INSTITUTION, CART.CF_STRM<br>
order by PROG.EFFDT desc, PROG.EFFSEQ desc, PROG.PROG_ACTION asc) as MAX_RANK<br>
from IR.CBIL_CF_CAR_TERM CART,<br>
IR.CF_TERM_TBL TERM,<br>
IR.CF_ACAD_PROG PROG<br>
where TERM.INSTITUTION = CART.CF_INSTITUTION<br>
and TERM.ACAD_CAREER = CART.CF_ACAD_CAREER<br>
and TERM.STRM = CART.CF_STRM<br>
and PROG.EMPLID = CART.CF_EMPLID<br>
and PROG.ACAD_CAREER = CART.CF_ACAD_CAREER<br>
and PROG.INSTITUTION = CART.CF_INSTITUTION<br>
and substr(PROG.ADMIT_TERM,1,3)||decode(substr(PROG.ADMIT_TERM,4,1),'2','2','6','9','9','9') = CART.CF_STRM<br>
and PROG.PROG_REASON in ('2','3')) SUBQ<br>
where SUBQ.MAX_RANK = 1<br>
and SUBQ.PROG_STATUS = 'AC';<br>
.
    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>12</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:33]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:33]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[new-student]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>Prior STRM as Degree</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/prior-strm-as-degree/</link>
		<pubDate>Tue, 29 May 2018 18:39:35 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/prior-strm-as-degree/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Definition</em></u><br>
<br>
The item "<strong>IR Prior STRM as Degree</strong>" in the folder "CBIL History Facts" is the most recent fall or spring term prior to the current term in which a student was enrolled for courses in a degree-seeking academic program within an academic career in a particular institution.<br>
<br>
Also see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/degree-status/">Degree Status</a> and <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/readmit/">Readmit</a><br>
<br>
<u><em>SQL Code</em></u><br>
<br>
drop table IR.CBIL_CF_STDNT_CAR_TERM_THIN purge;<br>
create table IR.CBIL_CF_STDNT_CAR_TERM_THIN<br>
tablespace CBIL_DATA<br>
as select EMPLID,<br>
ACAD_CAREER,<br>
INSTITUTION,<br>
STRM,<br>
ACAD_PROG_PRIMARY<br>
from ERP.CF_STDNT_CAR_TERM;<br>
<br>
drop table IR.CBIL_CF_STDNT_ENRL_DISTINCT purge;<br>
create table IR.CBIL_CF_STDNT_ENRL_DISTINCT<br>
tablespace CBIL_DATA<br>
as select distinct EMPLID,<br>
ACAD_CAREER,<br>
INSTITUTION,<br>
STRM<br>
from ERP.CF_STDNT_ENRL<br>
where STDNT_ENRL_STATUS = 'E';<br>
<br>
drop table IR.CBIL_CF_PTDS_T1 purge;<br>
create table IR.CBIL_CF_PTDS_T1<br>
tablespace CBIL_DATA<br>
as select<br>
distinct CART.EMPLID, CART.ACAD_CAREER, CART.INSTITUTION, CART.STRM<br>
from IR.CBIL_CF_STDNT_CAR_TERM_THIN CART,<br>
IR.CBIL_CF_STDNT_ENRL_DISTINCT ENRL<br>
where substr(CART.ACAD_PROG_PRIMARY,1,4) not in ('NDEG')<br>
and substr(CART.STRM,4,1) &lt;&gt; '6'<br>
and substr(ENRL.STRM,4,1) &lt;&gt; '6'<br>
and ENRL.EMPLID = CART.EMPLID<br>
and ENRL.ACAD_CAREER = CART.ACAD_CAREER<br>
and ENRL.INSTITUTION = CART.INSTITUTION<br>
and ENRL.STRM = CART.STRM;<br>
<br>
drop table IR.CBIL_CF_PTDS purge;<br>
create table IR.CBIL_CF_PTDS<br>
tablespace CBIL_DATA<br>
as select<br>
distinct SUBQ.CF_EMPLID,<br>
SUBQ.CF_ACAD_CAREER,<br>
SUBQ.CF_INSTITUTION,<br>
SUBQ.CF_STRM,<br>
SUBQ.IR_TERM_ENROLLED_DATE,<br>
SUBQ.IR_PRIOR_STRM_AS_DEGREE<br>
from (select CART.CF_EMPLID, CART.CF_ACAD_CAREER, CART.CF_INSTITUTION, CART.CF_STRM, CART.IR_TERM_ENROLLED_DATE,<br>
ENRL.STRM as IR_PRIOR_STRM_AS_DEGREE,<br>
rank() over (partition by CART.CF_EMPLID, CART.CF_ACAD_CAREER, CART.CF_INSTITUTION, CART.CF_STRM, CART.IR_TERM_ENROLLED_DATE<br>
order by ENRL.STRM desc) as MAX_RANK<br>
from IR.CBIL_CF_CAR_TERM CART,<br>
IR.CBIL_CF_PTDS_T1 ENRL<br>
where ENRL.EMPLID = CART.CF_EMPLID<br>
and ENRL.ACAD_CAREER = CART.CF_ACAD_CAREER<br>
and ENRL.INSTITUTION = CART.CF_INSTITUTION<br>
and ENRL.STRM &lt; CART.CF_STRM) SUBQ<br>
where MAX_RANK = 1;<br>
<br>
.
    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>13</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:35]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:35]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[prior-strm-as-degree]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>Prior STRM as Nondegree</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/prior-strm-as-nondegree/</link>
		<pubDate>Tue, 29 May 2018 18:39:36 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/prior-strm-as-nondegree/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Definition</em></u><br>
<br>
The item "<strong>IR Prior STRM as Nondegree</strong>" in the folder "CBIL History Facts" is the most recent fall or spring term prior to the current term in which a student was enrolled for courses in a nondegree academic program within an academic career in a particular institution.<br>
<br>
Also see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/degree-status/">Degree Status</a> and <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/readmit/">Readmit</a><br>
<br>
<u><em>SQL Code</em></u><br>
drop table IR.CBIL_CF_STDNT_CAR_TERM_THIN purge;<br>
create table IR.CBIL_CF_STDNT_CAR_TERM_THIN<br>
tablespace CBIL_DATA<br>
as select EMPLID,<br>
ACAD_CAREER,<br>
INSTITUTION,<br>
STRM,<br>
ACAD_PROG_PRIMARY<br>
from ERP.CF_STDNT_CAR_TERM;<br>
<br>
drop table IR.CBIL_CF_STDNT_ENRL_DISTINCT purge;<br>
create table IR.CBIL_CF_STDNT_ENRL_DISTINCT<br>
tablespace CBIL_DATA<br>
as select distinct EMPLID,<br>
ACAD_CAREER,<br>
INSTITUTION,<br>
STRM<br>
from ERP.CF_STDNT_ENRL<br>
where STDNT_ENRL_STATUS = 'E';<br>
<br>
drop table IR.CBIL_CF_PTND_T1 purge;<br>
create table IR.CBIL_CF_PTND_T1<br>
tablespace CBIL_DATA<br>
as select<br>
distinct CART.EMPLID, CART.ACAD_CAREER, CART.INSTITUTION, CART.STRM<br>
from IR.CBIL_CF_STDNT_CAR_TERM_THIN CART,<br>
IR.CBIL_CF_STDNT_ENRL_DISTINCT ENRL<br>
where substr(CART.ACAD_PROG_PRIMARY,1,4) in ('NDEG')<br>
and substr(CART.STRM,4,1) &lt;&gt; '6'<br>
and substr(ENRL.STRM,4,1) &lt;&gt; '6'<br>
and ENRL.EMPLID = CART.EMPLID<br>
and ENRL.ACAD_CAREER = CART.ACAD_CAREER<br>
and ENRL.INSTITUTION = CART.INSTITUTION<br>
and ENRL.STRM = CART.STRM;<br>
<br>
drop table IR.CBIL_CF_PTND purge;<br>
create table IR.CBIL_CF_PTND<br>
tablespace CBIL_DATA<br>
as select<br>
distinct SUBQ.CF_EMPLID,<br>
SUBQ.CF_ACAD_CAREER,<br>
SUBQ.CF_INSTITUTION,<br>
SUBQ.CF_STRM,<br>
SUBQ.IR_TERM_ENROLLED_DATE,<br>
SUBQ.IR_PRIOR_STRM_AS_NONDEGREE<br>
from (select CART.CF_EMPLID, CART.CF_ACAD_CAREER, CART.CF_INSTITUTION, CART.CF_STRM, CART.IR_TERM_ENROLLED_DATE,<br>
ENRL.STRM as IR_PRIOR_STRM_AS_NONDEGREE,<br>
rank() over (partition by CART.CF_EMPLID, CART.CF_ACAD_CAREER, CART.CF_INSTITUTION, CART.CF_STRM, CART.IR_TERM_ENROLLED_DATE<br>
order by ENRL.STRM desc) as MAX_RANK<br>
from IR.CBIL_CF_CAR_TERM CART,<br>
IR.CBIL_CF_PTND_T1 ENRL<br>
where ENRL.EMPLID = CART.CF_EMPLID<br>
and ENRL.ACAD_CAREER = CART.CF_ACAD_CAREER<br>
and ENRL.INSTITUTION = CART.CF_INSTITUTION<br>
and ENRL.STRM &lt; CART.CF_STRM) SUBQ<br>
where MAX_RANK = 1;
    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>14</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:36]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:36]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[prior-strm-as-nondegree]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>Quick Start Guide</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/quick-start-guide/</link>
		<pubDate>Tue, 29 May 2018 18:39:37 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/quick-start-guide/</guid>
		<description></description>
		<content:encoded><![CDATA[
<a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/wp-content/static/cunyenrollmentreporting/files/CBIL_quick_start.pdf">CBIL_quick_start.pdf</a>
    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>15</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:37]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:37]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[quick-start-guide]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>Readmit</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/readmit/</link>
		<pubDate>Tue, 29 May 2018 18:39:39 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/readmit/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Overview and Caveats</em></u><br>
<br>
<strong>Readmits</strong> can be identified primarily by program reasons of '4' or '9'. Unlike a <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/new-student/">New Student</a> for whom the program reason '2' or '3' can be associated with the current term by the field for admit term, the program reasons indicating a readmit have be filtered by the effective date in the program plan stack. The range currently being used to calculate readmits in CBIL covers the period from five months prior to the begin date of the current term until the end date of the current term.<br>
<br>
Because such a wide range of dates could also include readmits who enrolled in the previous term, there must also be at least one fall or spring term between the current term and the most recent term enrolled as a degree-seeking student within the same academic career and institution Using.<a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/prior-strm-as-degree/">Prior STRM as Degree</a> or <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/prior-strm-as-nondegree/">Prior STRM as Nondegree</a> to compute the number of terms between the current term and the previous term cannot be used, however, without programs reasons to determine Admission Type for readmits because students taking hiatus from their studies for one or more semesters could be confused with students transferring back into the original institution after transferring out and matriculating at another institution.<br>
<br>
Academic career and primary academic program are used to distinguish among undergraduate readmits, graduate readmits, and nondegree reamits.<br>
<br>
Also see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/admission-type/">Admission Type</a>. <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/degree-status/">Degree Status</a>, <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/prior-strm-as-degree/">Prior STRM as Degree</a>, and <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/prior-strm-as-nondegree/">Prior STRM as Nondegree</a><br>
<br>
<em><u>Definitions</u></em><br>
<br>
<strong>Undergraduate Readmit ('74'):</strong> A student in an undergraduate academic career and a degree-seeking academic program who has a program reason of '4' or '9' where the program effective date ranges between five months prior to the begin date of the current term and the end date of the current term. Furthermore, the student could not be enrolled in any courses as a degree-seeking student for at least one fall or spring term prior to the current term.<br>
<br>
<strong>Graduate Readmit ('86'):</strong> A student in graduate academic career and a degree-seeking academic program who has a program reason of '4' or '9' where the program effective date ranges between five months prior to the begin date of the current term and the end date of the current term. Like an undergraduate readmit, the student could not be enrolled in any courses as a degree-seeking student for at least one fall or spring term prior to the current term.<br>
<br>
<strong>Nondegree Readmit ('96'):</strong> A student in either an undergraduate or graduate academic career but a nondegree academic program who has a program reason of '4' or '9' where the program effective date ranges between five months prior to the begin date of the current term and the end date of the current term. The student could not be enrolled in any courses as a nondegree student for at least one fall or spring term prior to the current term.<br>
<br>
<u><em>Sample Mapping from CUNYfirst</em></u><br>
<br>


<table class="wiki_table">
    <tr>
        <th>CF_STDNT_CAR_TERM.<br>
STRM<br>
</th>
        <th>CF_STDNT_CAR_TERM.<br>
ACAD_CAREER<br>
</th>
        <th>CF_STDNT_CAR_TERM.<br>
ACAD_PROG_PRIMARY<br>
</th>
        <th>CF_ACAD_PROG.<br>
PROG_REASON<br>
</th>
        <th>CF_ACAD_PROG.<br>
EFFDT<br>
</th>
        <th>CF_TERM_TBL.<br>
TERM_BEGIN_DT<br>
</th>
        <th>CF_TERM_TBL.<br>
TERM_END_DT<br>
</th>
        <th>CBIL_HISTORY_FACTS.<br>
IR_PRIOR_STRM_AS_DEGREE<br>
</th>
        <th>CBIL_HISTORY_FACTS.<br>
IR_PRIOR_STRM_AS_NONDEGREE<br>
</th>
        <th>CBIL_HISTORY_FACTS.<br>
IR_ADMISSION_TYPE_CODE<br>
</th>
        <th>CBIL_HISTORY_FACTS.<br>
IR_ADMISSION_TYPE_DESC<br>
</th>
    </tr>
    <tr>
        <td style="text-align: center;">1139<br>
</td>
        <td style="text-align: center;">UGRD<br>
</td>
        <td style="text-align: center;">UGRD<br>
</td>
        <td style="text-align: center;">4<br>
</td>
        <td style="text-align: center;">4/16/2013<br>
</td>
        <td style="text-align: center;">8/28/2013<br>
</td>
        <td style="text-align: center;">12/23/2013<br>
</td>
        <td style="text-align: center;">1112<br>
</td>
        <td>
<br>
</td>
        <td style="text-align: center;">74<br>
</td>
        <td style="text-align: center;">Undergraduate Readmit<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">1139<br>
</td>
        <td style="text-align: center;">UKCC<br>
</td>
        <td style="text-align: center;">UGRD<br>
</td>
        <td style="text-align: center;">9<br>
</td>
        <td style="text-align: center;">10/12/2013<br>
</td>
        <td style="text-align: center;">9/7/2013<br>
</td>
        <td style="text-align: center;">2/26/2014<br>
</td>
        <td style="text-align: center;">1119<br>
</td>
        <td>
<br>
</td>
        <td style="text-align: center;">74<br>
</td>
        <td style="text-align: center;">Undergraduate Readmit<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">1139<br>
</td>
        <td style="text-align: center;">GRAD<br>
</td>
        <td style="text-align: center;">MA<br>
</td>
        <td style="text-align: center;">4<br>
</td>
        <td style="text-align: center;">5/15/2013<br>
</td>
        <td style="text-align: center;">8/28/2013<br>
</td>
        <td style="text-align: center;">12/23/2013<br>
</td>
        <td style="text-align: center;">1122<br>
</td>
        <td>
<br>
</td>
        <td style="text-align: center;">86<br>
</td>
        <td style="text-align: center;">Graduate Readmit<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">1139<br>
</td>
        <td style="text-align: center;">LAW<br>
</td>
        <td style="text-align: center;">LAW<br>
</td>
        <td style="text-align: center;">9<br>
</td>
        <td style="text-align: center;">8/27/2013<br>
</td>
        <td style="text-align: center;">8/26/2013<br>
</td>
        <td style="text-align: center;">12/20/2013<br>
</td>
        <td style="text-align: center;">1129<br>
</td>
        <td>
<br>
</td>
        <td style="text-align: center;">86<br>
</td>
        <td style="text-align: center;">Graduate Readmit<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">1139<br>
</td>
        <td style="text-align: center;">UGRD<br>
</td>
        <td style="text-align: center;">NDEGU<br>
</td>
        <td style="text-align: center;">4<br>
</td>
        <td style="text-align: center;">6/21/2013<br>
</td>
        <td style="text-align: center;">8/28/2013<br>
</td>
        <td style="text-align: center;">12/23/2013<br>
</td>
        <td>
<br>
</td>
        <td style="text-align: center;">1129<br>
</td>
        <td style="text-align: center;">96<br>
</td>
        <td style="text-align: center;">Nondegree Readmit<br>
</td>
    </tr>
    <tr>
        <td style="text-align: center;">1139<br>
</td>
        <td style="text-align: center;">GRAD<br>
</td>
        <td style="text-align: center;">NDEGG<br>
</td>
        <td style="text-align: center;">9<br>
</td>
        <td style="text-align: center;">9/1/2013<br>
</td>
        <td style="text-align: center;">8/28/2013<br>
</td>
        <td style="text-align: center;">12/23/2013<br>
</td>
        <td>
<br>
</td>
        <td style="text-align: center;">1122<br>
</td>
        <td style="text-align: center;">96<br>
</td>
        <td style="text-align: center;">Nondegree Readmit<br>
</td>
    </tr>
</table>

<br>
<em><u>SQL Code for Finding Program Reasons for Readmits</u></em><br>
<br>
create table IR.CBIL_CF_ADM5<br>
tablespace CBIL_DATA<br>
as<br>
select<br>
distinct SUBQ.CF_EMPLID,<br>
SUBQ.CF_ACAD_CAREER,<br>
SUBQ.CF_INSTITUTION,<br>
SUBQ.CF_STRM,<br>
SUBQ.IR_TERM_ENROLLED_DATE,<br>
SUBQ.EFFDT,<br>
SUBQ.EFFSEQ,<br>
SUBQ.PROG_ACTION,<br>
SUBQ.PROG_REASON<br>
from (select<br>
CART.CF_EMPLID,<br>
CART.CF_ACAD_CAREER,<br>
CART.CF_INSTITUTION,<br>
CART.CF_STRM,<br>
CART.IR_TERM_ENROLLED_DATE,<br>
CART.CF_STDNT_CAR_NBR,<br>
PROG.EFFDT,<br>
PROG.EFFSEQ,<br>
PROG.PROG_ACTION,<br>
PROG.PROG_REASON,<br>
PROG.PROG_STATUS,<br>
rank() over (partition by CART.CF_EMPLID, CART.CF_ACAD_CAREER, CART.CF_INSTITUTION, CART.CF_STRM<br>
order by PROG.EFFDT desc, PROG.EFFSEQ desc, PROG.PROG_ACTION asc) as MAX_RANK<br>
from IR.CBIL_CF_CAR_TERM CART,<br>
IR.CF_TERM_TBL TERM,<br>
IR.CF_ACAD_PROG PROG<br>
where TERM.INSTITUTION = CART.CF_INSTITUTION<br>
and TERM.ACAD_CAREER = CART.CF_ACAD_CAREER<br>
and TERM.STRM = CART.CF_STRM<br>
and PROG.EMPLID = CART.CF_EMPLID<br>
and PROG.ACAD_CAREER = CART.CF_ACAD_CAREER<br>
and PROG.INSTITUTION = CART.CF_INSTITUTION<br>
and PROG.STDNT_CAR_NBR = CART.CF_STDNT_CAR_NBR<br>
and PROG.PROG_REASON in ('4','9')<br>
and PROG.EFFDT &gt;= ADD_MONTHS(TERM.TERM_BEGIN_DT,-5)<br>
and PROG.EFFDT &lt;= TERM.TERM_END_DT) SUBQ<br>
where SUBQ.MAX_RANK = 1<br>
and SUBQ.PROG_STATUS = 'AC';<br>
<br>
<u><em>SQL Code for Combining Readmit Program Reasons with Prior STRM as Degree</em></u><br>
<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('CBUIS','UGRD')<br>
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')<br>
and substr(CF_STRM,4,1) = '2'<br>
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_DEGREE)) &gt; 3<br>
then '74'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('CBUIS','UGRD')<br>
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')<br>
and substr(CF_STRM,4,1) = '9'<br>
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_DEGREE)) &gt; 7<br>
then '74'<br>
<br>
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')<br>
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')<br>
and substr(CF_STRM,4,1) = '2'<br>
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_DEGREE)) &gt; 3<br>
then '86'<br>
when MAIN.CF_ACAD_CAREER in ('DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('ADVCT','ADVDP','DNP','DPT','LAW','MA','MAT','MFA','MALS','MLS','MMUS','MPH','MS','MSMPA','MSMPH','MSED','MSW','MSWMS','MUP')<br>
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')<br>
and substr(CF_STRM,4,1) = '9'<br>
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_DEGREE)) &gt; 7<br>
then '86'<br>
<br>
<u><em>SQL Code for Combining Readmit Program Reasons with Prior STRM as Nondegree</em></u><br>
<br>
<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG','DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('NDEGG','NDEG','NDEGU')<br>
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')<br>
and substr(CF_STRM,4,1) = '2'<br>
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_NONDEGREE)) &gt; 3<br>
then '96'<br>
when MAIN.CF_ACAD_CAREER in ('UGRD','UKCC','ULAG','DOCT','GRAD','LAW')<br>
and MAIN.CF_ACAD_PROG_PRIMARY<br>
in ('NDEGG','NDEG','NDEGU')<br>
and MAIN.PROG_REASON_READMIT_CODE in ('4','9')<br>
and substr(CF_STRM,4,1) = '9'<br>
and (to_number(CF_STRM) - to_number(IR_PRIOR_STRM_AS_NONDEGREE)) &gt; 7<br>
then '96'
    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>16</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:39]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:39]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[readmit]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>Record Count</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/record-count/</link>
		<pubDate>Tue, 29 May 2018 18:39:40 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/record-count/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Definition</em></u><br>
<br>
Record Count is the raw number of records included in the CBIL Enrollment Report (or rows in the CBIL_HISTORY_FACTS table) for a given term. Record Count includes any student enrolled in at least one course in the table CF_STDNT_ENRL where the field STDNT_ENRL_STATUS = 'E', even if the student is only registered in message courses. The data point "IR Record Count" in the CBIL Enrollment Report is calculated using the aggregate function COUNT on the field CF_EMPLID in the table CBIL_HISTORY_FACTS.<br>
<br>
Also see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/headcount/">Headcount</a><br>
<br>
<u><em>SQL</em></u><br>
<br>
The following SQL code is used to detemine which students are included in the tables CBIL_HISTORY_FACTS and CBIL_HISTORY_COURSE_FACTS:<br>
<br>
<span style="font-family: 'Courier New',Courier,monospace;">create table IR.CBIL_CF_STDNT_ENRL</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">as select CART.EMPLID,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CART.INSTITUTION,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CART.ACAD_CAREER,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CART.STRM,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.SESSION_CODE,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">TERM.TERM_BEGIN_DT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">TERM.TERM_END_DT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">TERM.WEEKS_OF_INSTRUCT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.CLASS_NBR,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.SUBJECT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.CATALOG_NBR,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.CLASS_SECTION,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.SSR_COMPONENT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.DESCR as CLASS_DESCR, </span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.STDNT_ENRL_STATUS,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.STATUS_DT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.ENRL_ADD_DT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.ENRL_DROP_DT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.CRSE_COUNT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.UNT_TAKEN,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.UNT_PRGRSS,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.UNT_PRGRSS_FA,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.UNT_BILLING,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.UNT_EARNED,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.GRADING_BASIS_ENRL,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.CRSE_GRADE_OFF,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.GRADE_DT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.REPEAT_CODE,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.REPEAT_DT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.TSCRPT_NOTE_ID,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.EARN_CREDIT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.INCLUDE_IN_GPA,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.UNITS_ATTEMPTED,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.GRADE_POINTS,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.GRADE_POINTS_FA,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.GRD_PTS_PER_UNIT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.RQMNT_DESIGNTN as CF_ENRL_RQMNT_DESIGNTN,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.RQMNT_DESIGNTN_OPT as CF_ENRL_RQMNT_DESIGNTN_OPT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">ENRL.RQMNT_DESIGNTN_GRD as CF_ENRL_RQMNT_DESIGNTN_GRD,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CTLG.CRSE_ID,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CTLG.CRSE_CONTACT_HRS,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CTLG.RQMNT_DESIGNTN,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CTLG.COURSE_TITLE_LONG,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.INSTRUCTION_MODE,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.LOCATION,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.CAMPUS,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.ACAD_GROUP,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.ACAD_ORG,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.ENRL_CAP,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.WAIT_CAP,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.MIN_ENRL,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.ENRL_TOT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.WAIT_TOT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.START_DT as CF_CLASS_START_DT,</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">CLAS.END_DT as CF_CLASS_END_DT</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">from ERP.CF_STDNT_ENRL ENRL</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">inner join ERP.CF_STDNT_CAR_TERM CART</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">on CART.EMPLID = ENRL.EMPLID</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">and CART.INSTITUTION = ENRL.INSTITUTION</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">and CART.ACAD_CAREER = ENRL.ACAD_CAREER</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">and CART.STRM = ENRL.STRM</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">inner join ERP.CF_TERM_TBL TERM</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">on TERM.INSTITUTION = ENRL.INSTITUTION</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">and TERM.ACAD_CAREER = ENRL.ACAD_CAREER</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">and TERM.STRM = ENRL.STRM</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">inner join ERP.CF_CLASS_TBL CLAS</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">on CLAS.INSTITUTION = ENRL.INSTITUTION</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">and CLAS.STRM = ENRL.STRM</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">and CLAS.CLASS_NBR = ENRL.CLASS_NBR</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">inner join ERP.CF_CRSE_CATALOG CTLG</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">on CTLG.CRSE_ID = CLAS.CRSE_ID</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">and CTLG.EFFDT = (select max(X.EFFDT)</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">from IR.CF_CRSE_CATALOG X</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">where X.CRSE_ID = CTLG.CRSE_ID</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">and X.EFF_STATUS = 'A'</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">and X.EFFDT &lt; TERM.TERM_END_DT)</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">where ENRL.STDNT_ENRL_STATUS = 'E'</span><br>
<span style="font-family: 'Courier New',Courier,monospace;">and ENRL.STRM &gt; '1122';</span>
    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>17</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:40]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:40]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[record-count]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>Unclassified New Undergraduates or Graduates</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/unclassified-new-undergraduates-or-graduates/</link>
		<pubDate>Tue, 29 May 2018 18:39:42 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/unclassified-new-undergraduates-or-graduates/</guid>
		<description></description>
		<content:encoded><![CDATA[
<u><em>Definition</em></u><br>
<br>
The worksheet "Enrollment by Admission Category" in the Oracle Discoverer workbook 'IRABH.CBILEnrollment Report" may have rows for "Unclassified New Undergraduates" or "Unclassified New Graduates".<br>
<br>
<strong>Unclassified New Undergraduates</strong> are students in an undergraduate career for whom the current term is the first fall or spring term enrolled as a degree-seeking student but for whom there is no record in the ACAD_PROG table where the admission term equals the current term and the program reason has a value (e.g., '2' or '3') that would classify the student as a first-time freshman or an undergraduate advanced standing transfer.<br>
<br>
<strong>Unclassified New Graduates</strong> are students in a graduate career for whom the current term is the first fall or spring term enrolled as a degree-seeking student but for whom there is no record in the ACAD_PROG table where the admission term equals the current term and the program reasons has a value (e.g., '2' or '3') that would classified the student as a first-time graduate student or a graduate advanced standing transfer.<br>
<br>
<u><em>Caveats</em></u><br>
<br>
Students may fall into the categories of Unclassified New Undergraduates or Unclassified New Graduates because they deferred matriculation for a semester (e.g., CUNYStart participants), because they dropped all of their courses before the cutoff date of their original term of admission, or because they do not have program reasons that could be used to classify them as first-time students or transfers. <br>
<br>
A list of such students can be found in the worksheet "Unclassified New Degree Students" in the Oracle Discoverer workbook "IRABH.CBIL.Enrollment". The registrar may be able to resolve the type of admission of such students by updating the field ADMIT_TERM or the field PROG_REASON in the table ACAD_PROG. If unable to correct the problem in CUNYfirst, the registrar can send OIRA a list of EMPLID's with the proper codes for type of admission.<br>
<br>
Unclassified New Undergraduates are not included in the worksheet "New Undergraduate Students" in the Oracle Discoverer workbook "IRABH.CBIL Flash Dataset", but they are included in the degree headcount of the worksheet "Undergraduate Enrollment".<br>
<br>
Unclassified New Graduates are not included in the worksheet "New Graduate Students" in the Oracle Discoverer workbook "IRABH.CBIL Flash Dataset", but they are included in the degree headcount of the worksheet "Graduate (Non-Doctoral) Enrollment" or the worksheet "Doctoral Enrollment".<br>
<br>
When Unclassified New Undergraduates can be matched with records in the CAS file, their Admission Category in the CBIL Enrollment Report is reclassified as "<strong>New Undergraduates in CAS File</strong>" and they are included with "First-time Freshmen" in the CBIL Flash Dataset.<br>
<br>
When Unclassified New Undergraduates can be matched with records in the ASTA file, their Admission Category in the CBIL Enrollment Report is reclassified as "<strong>New Undergraduates in ASTA File</strong>" and they are included with "Advanced Standing Transfers" in the CBIL Flash Dataset.<br>
<br>
All summer admission terms in the table CF_ACAD_PROG are recoded to fall admission terms when comparing them to current terms of enrollment or first terms as a degree student.<br>
<br>
Also see <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/degree-status/">Degree Status</a>, <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/new-student/">New Student</a>, and <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/first-strm-as-degree/">First STRM as Degree</a><br>
<br>
<u><em>Sample Mapping from CUNYfirst</em></u><br>
<br>


<table class="wiki_table">
    <tr>
        <th>
<strong>CF_STDNT_CAR_TERM.</strong><br>
<strong>INSTITUTION</strong><br>
</th>
        <th>
<strong>CF_STDNT_CAR_TERM.</strong><br>
<strong>STRM</strong><br>
</th>
        <th>
<strong>CF_STDNT_CAR_TERM.</strong><br>
<strong>ACAD_CAREER</strong><br>
</th>
        <th>
<strong>CF_STDNT_CAR_TERM.</strong><br>
<strong>ACAD_PROG_PRIMARY</strong><br>
</th>
        <th>
<strong>CF_ACAD_PROG.</strong><br>
<strong>ADMIT_TERM</strong><br>
</th>
        <th>
<strong>CF_ACAD_PROG.</strong><br>
<strong>PROG_REASON</strong><br>
</th>
        <th>
<strong>CAS_FILE</strong><br>
</th>
        <th>
<strong>ASTA_FILE</strong><br>
</th>
        <th>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>IR_FIRST_STRM_AS_DEGREE</strong><br>
</th>
        <th>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>IR_ADMISSION_CATEGORY_CODE</strong><br>
</th>
        <th>
<strong>CBIL_HISTORY_FACTS.</strong><br>
<strong>IR_ADMISSION_CATEGORY_DESC</strong><br>
</th>
    </tr>
    <tr>
        <td>KCC01<br>
</td>
        <td>1139<br>
</td>
        <td>UKCC<br>
</td>
        <td>UGRD<br>
</td>
        <td>1136<br>
</td>
        <td>2<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>1139<br>
</td>
        <td>01<br>
</td>
        <td>First-time Freshmen<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
    </tr>
    <tr>
        <td>BKL01<br>
</td>
        <td>1139<br>
</td>
        <td>UGRD<br>
</td>
        <td>CBUIS<br>
</td>
        <td>1139<br>
</td>
        <td>3<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>1139<br>
</td>
        <td>02<br>
</td>
        <td>Undergraduate Advanced Standing Tranfers<br>
</td>
    </tr>
    <tr>
        <td>QCC01<br>
</td>
        <td>1139<br>
</td>
        <td>UGRD<br>
</td>
        <td>UGRD<br>
</td>
        <td>1139<br>
</td>
        <td>
<br>
</td>
        <td>201309<br>
</td>
        <td>
<br>
</td>
        <td>1139<br>
</td>
        <td>03<br>
</td>
        <td>New Undergraduates in CAS File<br>
</td>
    </tr>
    <tr>
        <td>QCC01<br>
</td>
        <td>1139<br>
</td>
        <td>UGRD<br>
</td>
        <td>UGRD<br>
</td>
        <td>1139<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>201309<br>
</td>
        <td>1139<br>
</td>
        <td>04<br>
</td>
        <td>New Undergraduates in ASTA File<br>
</td>
    </tr>
    <tr>
        <td>QCC01<br>
</td>
        <td>1139<br>
</td>
        <td>UGRD<br>
</td>
        <td>UGRD<br>
</td>
        <td>1139<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>1139<br>
</td>
        <td>06<br>
</td>
        <td>Unclassified New Undergraduates<br>
</td>
    </tr>
    <tr>
        <td>QCC01<br>
</td>
        <td>1142<br>
</td>
        <td>UGRD<br>
</td>
        <td>UGRD<br>
</td>
        <td>1139<br>
</td>
        <td>2<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>1142<br>
</td>
        <td>06<br>
</td>
        <td>Unclassified New Undergraduates<br>
</td>
    </tr>
    <tr>
        <td>QNS01<br>
</td>
        <td>1139<br>
</td>
        <td>GRAD<br>
</td>
        <td>MA<br>
</td>
        <td>1139<br>
</td>
        <td>2<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>1139<br>
</td>
        <td>10<br>
</td>
        <td>First-time Graduate Matriculants<br>
</td>
    </tr>
    <tr>
        <td>HTR01<br>
</td>
        <td>1139<br>
</td>
        <td>DOCT<br>
</td>
        <td>DNP<br>
</td>
        <td>1139<br>
</td>
        <td>3<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>1139<br>
</td>
        <td>11<br>
</td>
        <td>Graduate Advanced Standing Transfers<br>
</td>
    </tr>
    <tr>
        <td>QNS01<br>
</td>
        <td>1139<br>
</td>
        <td>GRAD<br>
</td>
        <td>MS<br>
</td>
        <td>1139<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>1139<br>
</td>
        <td>13<br>
</td>
        <td>Unclassified New Graduates<br>
</td>
    </tr>
    <tr>
        <td>QNS01<br>
</td>
        <td>1142<br>
</td>
        <td>GRAD<br>
</td>
        <td>MSW<br>
</td>
        <td>1139<br>
</td>
        <td>2<br>
</td>
        <td>
<br>
</td>
        <td>
<br>
</td>
        <td>1142<br>
</td>
        <td>13<br>
</td>
        <td>Unclassified New Graduates<br>
</td>
    </tr>
</table>


    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>18</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:42]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:42]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[unclassified-new-undergraduates-or-graduates]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
	<item>
		<title>home</title>
		<link>https://cunyenrollmentreporting.commons.gc.cuny.edu/home/</link>
		<pubDate>Tue, 29 May 2018 18:39:43 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
		<guid isPermaLink="false">https://cunyenrollmentreporting.commons.gc.cuny.edu/home/</guid>
		<description></description>
		<content:encoded><![CDATA[
<table class="captionBox">
<tr><td class="captionedImage"><img src="files/external-61e4ac35577c96912a635302e700b6a1.jpg" alt="OIRA + Policy" title="OIRA + Policy"></td></tr>
<tr><td class="imageCaption">OIRA + Policy</td></tr>
</table>
<br>
<h2 id="toc0"><a name="x-Welcome%20to%20the%20CUNY%20Enrollment%20Reporting%20Wiki"></a></h2>
 <h2 id="toc1"> </h2>
 <h2 id="toc2">
<a name="x-Welcome%20to%20the%20CUNY%20Enrollment%20Reporting%20Website"></a><strong><span style="color: #000080;">Welcome to the CUNY Enrollment Reporting Website</span></strong>
</h2>
 <h4 id="toc3">
<a name="x-Welcome%20to%20the%20CUNY%20Enrollment%20Reporting%20Website--This%20site%20contains%20documentation%20about%20CUNY's%20central%20enrollment%20reporting%20resources,%20particularly%20CUNY%20Business%20Intelligence%20Lite%20(CBIL)."></a>This site contains documentation about CUNY's central enrollment reporting resources, particularly CUNY Business Intelligence Lite (CBIL).</h4>
 <h4 id="toc4"> </h4>
 <h4 id="toc5">
<a name="x-Welcome%20to%20the%20CUNY%20Enrollment%20Reporting%20Website--This%20slide%20deck%20gives%20a%20general%20overview%20of%20OIRA%20reporting%20resources%20and%20introduction%20to%20CBIL."></a>This <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/wp-content/static/cunyenrollmentreporting/files/OIRA_reporting_reources_UCOR.pdf" target="_blank">slide deck </a>gives a general overview of OIRA reporting resources and introduction to CBIL.</h4>
 <br>
<em><span style="background-color: #ffffff;">College IR offices are the first line of support for new campus users to access and learn to use CBIL.</span></em><br>
<br>
<strong><span style="background-color: #ffffff;">CBIL access requires:</span></strong><br>
<br>
<ol>
<li>
<span style="background-color: #ffffff;">A Citrix account provided by CUNY CIS (submit ticket to <a class="wiki_link_ext" href="mailto:Service.Desk@cuny.edu" rel="nofollow">Service.Desk@cuny.edu</a> requesting access)</span><ol><li><span style="background-color: #ffffff;"><span style="line-height: 1.5;">Passwords for Citrix accounts can be reset by calling the CIS Service Desk at </span><span style="line-height: 1.5;" class="baec5a81-e4d6-4674-97f3-e9220f0136c1">212-541-0981</span></span></li></ol>
</li>
<li><span style="background-color: #ffffff;">A Citrix web plug-in (often installed by campus IT)</span></li>
<li>
<span style="background-color: #ffffff;">A CBIL account in IRDBPROD2 provided by OIRA</span><ul>
<li>Campus users should request CBIL accounts through their IR Director</li>
<li>IR Directors should email requests to Pauline Hua (<u><span style="color: #0066cc;"><a class="wiki_link_ext" href="mailto:Pauline.Hua@cuny.edu" rel="nofollow">Pauline.Hua@cuny.edu</a>)</span></u>
</li>
<li>Requests should include new user's name, email address, telephone number, title, and department</li>
<li>
<span style="background-color: #ffffff;"><span style="background-color: #ffffff;">Passwords for CBIL/IRDB accounts can be reset by emailing Pauline Hua (</span></span><u><span style="color: #0066cc;"><a class="wiki_link_ext" href="mailto:Pauline.Hua@cuny.edu" rel="nofollow">Pauline.Hua@cuny.edu</a>)</span></u>
</li>
</ul>
</li>
</ol>
<br>
<br>
<span style="background-color: #ffffff;" class="baec5a81-e4d6-4674-97f3-e9220f0136c1">Also see the CBIL <a href="https://cunyenrollmentreporting.commons.gc.cuny.edu/quick-start-guide/">Quick Start Guide</a></span>
    ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_id>19</wp:post_id>
		<wp:post_date><![CDATA[2018-05-29 18:39:43]]></wp:post_date>
		<wp:post_date_gmt><![CDATA[2018-05-29 18:39:43]]></wp:post_date_gmt>
		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
		<wp:post_name><![CDATA[home]]></wp:post_name>
		<wp:status><![CDATA[publish]]></wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type><![CDATA[page]]></wp:post_type>
		<wp:post_password><![CDATA[]]></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
	</item>
</channel>
</rss>
