New Student Admissions/Registration by Campus (SYS001A) This database is linked to the student database on the AIS Data Warehouse and produces a report of new admits for the specified semester. The report identifies the type of admission, the new student's current registration status, and the number of late drop credits accumulated. Start by selecting the QUERIES TAB, highlighting the query qrySYS001A and select DESIGN.   Once you select Design you will see the query in Design View.  Here you will see the first two fields that you need to enter specific information into.  These fields are code_stua_samx_stat and code_stua_samx_camp.  They are highlighted below.  For code_stua_samx_stat, you need to enter one of the following 2 criteria: PDACC = Paid Accept (use when requesting a list of undergraduate or Capital students) GRPRM = Graduate Permanent Admit (use when requesting a list of graduate students) For code_stua_samx_camp, you need to enter a campus code, for example: BD = Behrend (Erie) Campus OZ = Abington Campus UP = University Park Campus Once you have entered this information, scroll to the right until you see the fields shown below.  These are the next set of fields that require you to enter criteria. These fields are code_stud_lvl and code_stua_samx_type.  They are highlighted below.     For code_stud_lvl, you need to enter one of the following 2 criteria: UG = Undergraduates GR = Graduates For code_stua_samx_type, you need to enter: Between "01" And "11" = Undergraduates Between "30" And "38" = Capital Students Between "50" And "53" = Graduates Once you have entered this information, scroll to the right until you see the fields shown below.  These are the next set of fields that require you to enter criteria. These fields are code_stua_samx_yrtm and date_stua_samx_stat.  They are highlighted below.    For code_stua_samx_yrtm, you need to enter the admit semester, for example: 200001FA = Students admitted to the University for Fall 2000 200001SP = Students admitted to the University for Spring 2001 200001SU = Students admitted to the University for Summer 2001 For date_stua_samx_stat, you need to enter an admit date that you want to begin searching from, for example: >#9/1/99# = Students admitted to the University from September 1st to the current date >#12/11/99# = Students admitted to the University from December 11th to the current date Now that you have entered all of your criteria, close down the query and return to the query tab.  Highlight the query and select the OPEN button to the right.  This will run the query with the criteria you entered and produce a table, tblSYS001A.  Once Access indicated it has finished running the query, select the REPORTS tab and highlight rptSYS001A.  Select the open button to the right, and you will have your report (like seen below) SAMPLE REPORT: This database is the following: Campus Specific Admit Semester Specific Level Specific Click on Download here to download this MS Access Database.

Printer friendly view