CCCApply Using SAR189U

1. CCCApply Using SAR189U

2. What is CCCApply? • The California community colleges have been strongly encouraged by the Chancellor’s Office to use CCCApply • It is a single website where applicants can fill out applications to most of the California community colleges • CCCApply asks residency question then determines residency based on responses • There is an annual fee to use CCCApply, but the Chancellor’s Office offers grants to pay for the first few years of a school’s use

3. CCCApply Website Skip Navigation Skip Navigation • http://www.cccapply.org/

4. Loading the applications in Banner • The SAR189U process can be used to load most, but not all, of the data collected by CCCApply • Flat file is loaded to the same temporary tables used by Self Service: Admissions • Once records are in the temporary tables they can be reviewed on SAAEAPS and SAAETBL • Records can be loaded by running SARETMT or by manually pushing the applications on SAAEAPS

5. File Format • The XAP file follows the standard Postsecondary Electronic Standards Council (PESC) guidelines.

6. Elements That Will Load • The file will have a header record that includes the sender (CCCApply) and the recipient (the college) address information

7. Person Data Birth Name AlternateName Citizenship Gender EthnicityRace International Data FamilyMember Address Phone Residency Contact Information PermanentAddress TemporaryAddress OtherAddress PermanentPhone TemporaryPhone OtherPhone PrimaryEmail OtherEmail High School Information Prior College Information Elements That Will Load

8. Application ApplicationDetail School Address Phone ApplicationSession (Term) Major Elements That Will Load

9. Elements That Will NOT Load • Residency determination questions • Program • Educational Goal • Education Level • Student Type

10. Setting Up SAR189U

11. SAR189U - Implementation 1. Self Service Admissions Validation Forms Review values on this form: • Application Verification Steps (STVASTA) • Look for “IDVR” – ID Verification

12. SAR189U - Implementation 2. Self Service Admissions Validation Forms Create Application Types in: • Application Type Codes (STVWAPP) • Delivered values are: 00, W1 – W7 • Can add additional types

13. SAR189U –Implementation Steps 2. Self Service Admissions Validation Forms Review values in these forms: • EDI Rule Groups (STVEGRP) • ADMS, and RESD group codes are the two most used by SAR189U. • Delivered by SunGard Higher Education • EDI Verification Labels (STVXLBL) • Delivered by SunGard Higher Education

14. ApplicationType Attached Procedures Routines SAR189U - Implementation 3. Procedures and Routines - Concepts • To verify that applications are complete • To determine what is loaded • Attach procedures to application types • Attach routines to procedures

15. SAR189U - Implementation 3. Procedures and Routines - Concepts Procedures and Routines can be: • System required / not system required • Required / not required • Overridden / not overridden

16. SAR189U - Implementation 3. Procedures and Routines - implementing • Electronic Admissions Procedure / Routine Control Form (SAAECRL) • Create / copy procedures • review for each application type • listed on pages 459-467 of Chapter 10 of the Banner Student User’s Guide

17. SAR189U - Implementation • Self Service Admissions – Implementation • Always require these procedures; do not allow overrides! • P010 - ID Verification • P020 - Name Verification • P035 - Residency Verification • P040 - Address Verification • P070 - Phone Verification • P120 - Entry Curriculum Verification • P050 - Application Verification • P200 - Data Relationship Procedure • P900 – “PUSH” Verification

18. SAR189U - Implementation 3. Procedures and Routines - implementing Do not require these procedures!!! • P060 - Health Conditions (unless question uncommented in Bio page) • P090 - Language Record • P100 - Immunization Record • P135 - High School Subjects • P080 - Religion

19. SAR189U - Implementation 3. Procedures and Routines - implementing • P032 - International Information • P110 - Activities • P130 - High School • P150 - Test Scores • P140 - Previous College • P142 - Previous College Degrees • P145 - Previous College Majors Require or not as appropriate to application type; allow overrides!

20. SAR189U - Implementation 3. Procedures and Routines - implementing Example - International info (P032) • Application section will not be included for every application type • Do not require the procedure! • Information may not be provided even when the section is included • Allow the procedure to be overridden!

21. Routines: R0010 - Date of birth R0020 - Ethnicity R0040 - Legacy R0060 - Marital status R0080 - Gender R0090 - Citizenship R0091 - Nation of citizenship R0110 - Native language R0130 - Home language R0150 - Correspondence language R9001 - Edit results SAR189U - Implementation 3. Procedures and Routines - implementing

22. SAR189U - Implementation 3. Procedures and Routines - implementing Example: Bio info (P030) • Some items (home/correspondence language) are not collected on the Web • Do not require the routine! • Applicants may not supply all data which can be collected • Allow the routine to be overridden!

23. SAR189U - Implementation 3. Procedures and Routines - implementing “PUSH” Verification (P900) • Must be required/cannot be overridden • Routines may be not required if data is not collected for application type

24. SAR189U - Implementation 3. Procedures and Routines – implementing • Electronic Application Procedures/ Routines Form (SAAECRL) • Do not delete rules! • Set Required and Override flags as needed • All delivered values are System Required • # of Routines is information

25. SAR189U - Implementation 4. Electronic Admissions Application Rules (SAAERUL) • Control electronic admissions processing routines • Organized into groups • Modify ‘UPDATE ME’ rows to suit local needs • Rows are listed on pages 467-480 of Chapter 10 of the Banner Student User’s Guide

26. SAR189U - Implementation 5. EDI Cross Reference Rules Form (SOAXREF) • Controls availability of validation data • Must have values in EDI, description, and Banner value • Set up rows for address type, telephone type, major • Review values for nation, state, ethnicity, • Listed on pages 480-486 in Chapter 10 of the Banner Student User’s Guide

27. SAR189U - Implementation 6. Enter EDI identification numbers on SOACURR for majors. Use the CCCApply major codes defined on SOAXREF

28. SAR189U - Implementation 7. Set up a default curriculum on SAAWADF • SAR189U loads the major, but not the curriculum • Set up matching and processing rules on SAAWADF

29. SAR189U – Loading the Applications • Run the SAR189U Process • Parameter 01 File Name • The file must be loaded on the same server as Banner • The file and path name combined cannot exceed 30 characters • Parameter 02 Y to print debug messages • Parameter 03 Application Type from STVWAPP • Parameter 04 Term Code

30. SAR189U - Admissions Office Processing Applications • Initial Review (optional) • Electronic Application Process Form (SAAEAPS) • Match Verify and Load • Tape Interface Rules Form (GORCMRL) • Electronic Application Verify / Load (SARETMT)

31. SAR189U - Admissions Office • Process Suspended Records • Electronic Application Process Form (SAAEAPS) • Match Verify and Load • Checklists / decisions etc in baseline Banner

32. SAR189U - Managing Data Purging Electronic Applications Data • Electronic Application Purge Process (SARETPG) • purge by Application Source, Application Type, Term, Date, Status

33. Questions and Answers