student admissions introduction to reporting instructors: linda atkinson and linda herron the bars...

Student Admissions Introduction to Reporting

Instructors: Linda Atkinson and Linda HerronThe BARS Support Team

Data Files OverviewData Files Overview - - SPRIDEN – Person Identification tableSPRIDEN – Person Identification table

SPRIDEN_PIDM – Internal identification number of the SPRIDEN_PIDM – Internal identification number of the person.person.

SPRIDEN_ID – The NEW Banner ID or SocialSPRIDEN_ID – The NEW Banner ID or Social SPRIDEN_CHANGE_IND – Identifies if the type of SPRIDEN_CHANGE_IND – Identifies if the type of

change made to the record was an id (Null, I, N)change made to the record was an id (Null, I, N) SPRIDEN_LAST_NAME – Defines the last name of SPRIDEN_LAST_NAME – Defines the last name of

personperson SPRIDEN_FIRST_NAME – Defines the first name of SPRIDEN_FIRST_NAME – Defines the first name of

personperson SPRIDEN_MI – Defines the middle name of personSPRIDEN_MI – Defines the middle name of person

DATA FILES OVERVIEW (ContDATA FILES OVERVIEW (Cont))

- - STVSTYP – Student type validation tableSTVSTYP – Student type validation table

STVSTYP_CODE - Student Type Code – Student type STVSTYP_CODE - Student Type Code – Student type referenced in admissions, Gen tablesreferenced in admissions, Gen tables

STVSTYP_DESC - Student Type Description – Specifies STVSTYP_DESC - Student Type Description – Specifies student type. (freshman, returning, masters, ect)student type. (freshman, returning, masters, ect)

DATA FILES OVERVIEW (Cont)DATA FILES OVERVIEW (Cont) SARADAP – Admissions Applications Repeating TableSARADAP – Admissions Applications Repeating Table

SARADAP_PIDM – This identifies the applicant internal SARADAP_PIDM – This identifies the applicant internal identification numberidentification number

SARADAP_TERM_CODE_ENTRY – Identifies the term associated SARADAP_TERM_CODE_ENTRY – Identifies the term associated with the information on the applicant recordwith the information on the applicant record

SARADAP_APPL_NO – Identifies the application number of the SARADAP_APPL_NO – Identifies the application number of the admissions record for a specific termadmissions record for a specific term

SARADAP_LEVL_CODE – identifies the level to which the applicant SARADAP_LEVL_CODE – identifies the level to which the applicant is applying ( undergraduate, graduate, ect)is applying ( undergraduate, graduate, ect)

SARADAP_APST_CODE – identifies the status of the application SARADAP_APST_CODE – identifies the status of the application (complete, decision made, incomplete, ect)(complete, decision made, incomplete, ect)

SARADAP_STYP_CODE – Identifies the type of student the SARADAP_STYP_CODE – Identifies the type of student the applicant will become if admitted (freshman, transfer, master applicant will become if admitted (freshman, transfer, master candidate, ect)candidate, ect)

DATA FILES OVERVIEW (Cont)DATA FILES OVERVIEW (Cont)

ASU_ADMISSIONS_DECISION_PERSONASU_ADMISSIONS_DECISION_PERSON NameName Academic year and descriptionAcademic year and description Decision and descriptionDecision and description Academic Period and descriptionAcademic Period and description

JOINSJOINS JOIN JOIN - is a temporary connection between two or - is a temporary connection between two or

more data sources that share at least one common more data sources that share at least one common field. Once you join two data sources, each time field. Once you join two data sources, each time WebFOCUS retrieves a record from the first data WebFOCUS retrieves a record from the first data source (host file), it also retrieves the matching source (host file), it also retrieves the matching records from the second data source (target file). records from the second data source (target file).

Inner Join.Inner Join. Left Outer Join.Left Outer Join. Multiple Instance.Multiple Instance. Single Instance.Single Instance.

STUDENT

Create A Simple Extract of Create A Simple Extract of SPRIDENSPRIDEN

Go to My ReportsGo to My Reports

Create a New Folder called “Training Create a New Folder called “Training Class”Class”

Create a New ReportCreate a New Report

Field: Name_LFMFormat: A100Formula:J001.SPRIDEN.SPRIDEN_LAST_NAME || (‘,’ | J001.SPRIDEN.SPRIDEN_FIRST_NAME || (‘ ‘ | J001.SPRIDEN.SPRIDEN_MI))

Field: Name_LFM_SortFormat: A30Formula: EDIT(Name_LFM,(’999999999999999999999999999999’)

Field: APST_CODEFormat: A30Formula:IF SARADAP_APST_CODE EQ ‘C’ THEN ‘C-Complete ready for review’ ELSEIF SARADAP_APST_CODE EQ ‘D’ THEN ‘D-Decision Made’ ELSEIF SARADAP_APST_CODE EQ ‘I’ THEN ‘I-Incomplete items outstanding’ ELSE SARADAP_APST_CODE

Reporting from the ODSReporting from the ODS

AdvantagesAdvantages FasterFaster No joinsNo joins Descriptions in one placeDescriptions in one place