Electronic Transcripts Recipe for Success USM Oracle/PeopleSoft Regional gathering Coppin State University June 2007 Frederick Community CollegeSlide 2
Presenter Beth Miles Enterprise Application Analyst/Programmer PeopleSoft, Student Records since 2001 Frederick Community CollegeSlide 3
Frederick Community College Celebrating 50th commemoration Frederick Community CollegeSlide 4
Overview How we changed our transcript procedure to better serve our students Included all elements for achievement Frederick Community CollegeSlide 5
FCC PeopleSoft History Financials Went live with variant 7 in 1999 Upgraded to form 7.5 in 2001 Upgraded to rendition 8.8 in 2005 Student Records/HR Went live with adaptation 7.6 in 2001 Upgraded to rendition 8.0 in 2003 Upgraded to form 8.9 in October 2006 Currently on PeopleTools form 8.47 Frederick Community CollegeSlide 6
Transcripts at FCC 1957 Grade records were written on with carbon paper utilized for numerous duplicates 1970s "Hard Cards" were photocopied for transcript Punch cards were written & stacked to deliver stickers Computerized stickers were put onto "hard cards" 1975 Legacy framework acquainted Ability with print transcripts 2001 PeopleSoft went live Customized transcript procedure to print official transcripts 2005/2006 conveyed 8509 UGRD official transcripts Also send CNED transcripts Jan 2007 ran live with electronic transcripts Frederick Community CollegeSlide 7
Facts about FCC UGRD understudies in Fall 2006 4825 understudies selected 38% full time 62% low maintenance 63% exchange majors UGRD understudies in Spring 2007 4778 understudies enlisted 35% full time 65% low maintenance 61% exchange majors Continuing Education for 2006 13707 understudies selected Frederick Community CollegeSlide 8
Our main 5 schools for students from another school Fall 2006 University of Maryland Hood Mount St Mary\'s University Towson University Salisbury University Frederick Community CollegeSlide 9
Allegany College of Maryland Anne Arundel Community College Baltimore City Community College Bowie State University Carroll Community College CC Baltimore County – Catonsville CC Baltimore County – Dundalk CC Baltimore County – Essex Cecil Community College of Southern Maryland Coppin State University Frederick Community College Frostburg State University Hagerstown Community College Harford Community College Howard Community College Johns Hopkins U - Professional Std Montgomery College – Germantown Montgomery College – Rockville Montgomery College - Takoma Park Prince Georges Community College Salisbury University Towson University U of MD - Baltimore County U of MD - Baltimore Cty Grad Sch U of MD - College Park U of MD - College Park Grad School U of MD - Eastern Shore U of MD - Univ College Grad School U of MD - University College U of MD Baltimore – Nursing U of MD Baltimore - Records Office University of Baltimore Washington College Wor-Wic Community College 35 Colleges & Universities in Maryland are collectors 167 schools in nation are beneficiaries Frederick Community CollegeSlide 10
Goals of new process Reduce staff time to send transcript Wanted easy to use interface Wanted snappy and simple clump interface Wanted information to reflect our tweaked transcript Reduce asset costs Frederick Community CollegeSlide 11
Advantages of ET Secure, information exchanged through SSL or Secure FTP Quick, enter the understudy\'s demand and the transcript is sent today Easy, simply enter the understudy\'s ID# and school Cheap, reserve funds in assets Each sheet of transcript paper costs practically $1.00 Postage on every transcript Toner costs Frederick Community CollegeSlide 12
Technical Specs Frederick Community CollegeSlide 13
1 st page – Import Schools Download the partaking schools into a content document, utilize the ET framework – List senders Import the record into PS Frederick Community CollegeSlide 14
1 st SQR – Import the schools This SQR will import the downloaded content document into the PS table PS_FCC_ET_SCHOOL Frederick Community CollegeSlide 15
2 nd page – School Maintenance Can include new schools here or do support on existing schools Frederick Community CollegeSlide 16
3 rd page – Transcript section Enter the getting school code, regard for and understudy\'s id#. Frederick Community CollegeSlide 17
4 th page – Export Transcripts Exports the chose understudies transcripts into a content document Use the ET framework – Upload Transcripts to send Frederick Community CollegeSlide 18
2 nd SQR – Create trade document This SQR will trade the transcript information from PS_FCC_ET_STUDENTS into a content document Frederick Community CollegeSlide 19
Audit Report The SQR produces a PDF report Shows the understudies & transcript goal Frederick Community CollegeSlide 20
Text document The SQR produces the content record Frederick Community CollegeSlide 21
Header Record "00" General demographics for understudy Name \ Address CUM GPA Total taken advance & earned & review focuses Program & Hegis code Frederick Community CollegeSlide 22
Term Record "01" Each term the understudy is selected in classes Frederick Community CollegeSlide 23
Course record "02" Each class the understudy was enlisted in Frederick Community CollegeSlide 24
Degree record "03" All degrees the understudy earned Frederick Community CollegeSlide 25
Cumulative Summary "12" Totals for understudy, credits & GPA Frederick Community CollegeSlide 26
Transfer Credit "13" Transfer credit for understudy Frederick Community CollegeSlide 27
Sent to record "07" The school code and division where the transcript is being sent Frederick Community CollegeSlide 28
Totals "99" Total number of records for this understudy Frederick Community CollegeSlide 29
PS Custom records Participating Schools Record Student Record Frederick Community CollegeSlide 30
PS Custom records cont\' Run Control Record Frederick Community CollegeSlide 31
PS Custom Fields FCC_ET_ATTN_TO 2 roast - decipher FCC_ET_CODE_TYPE 2 singe - interpret FCC_ET_INST_TYPE 8 scorch Frederick Community CollegeSlide 32
Challenges Two terms start in same month; Jan term and spring term start in January ARTSYS cleanup Grading legend Missing courses GEN ED\'s Hegis Codes – not present on "latent" majors Frederick Community CollegeSlide 33
Success Staff cherishes it Saves time to prepare every transcript ask for Saves transcript paper & postage Easy to utilize Frederick Community CollegeSlide 34
Questions ? Frederick Community CollegeSlide 35
Contact Beth Miles Email address: firstname.lastname@example.org SQRs accessible upon demand Frederick Community College
tiger i An Aide for New Understudies What is tiger i ? tiger i is a Reddish understudy's hotspot ...
CWMA Cookbook: A Formula for Achievement An Orderly Guide On the most proficient method to Add t ...
Partner Professor, Social Studies Education. College of Florida ... stay aware of the primary in ...
Formulas that are composed well will give particular data rundown of fixings and ... sort, stove ...
Expense of obtained sustenance Total dinner reciprocals = Food cost ... Sustenance Cost Percenta ...
Objects and Word Clues. Diversions Reinforce Memory. Bore and Practice ... New Story Workbook. 1 ...
Southwest has made majority rules system in the aircraft business. Legislative issues is the mat ...
WIC Recipe Contest. Exciting Flavors of the New Food Package Sponsored by Dairy Council of A ...
Development of the maps. Drafting Phase. Process Mapping Methodology . Stage 1: Drafting ph ...
Friday, July 30 Morning General Introduction ---of ‘Narrative Methods’ in Cross-Cultur ...
Mother Sauces Espagnole & Tomato. Quiz Review Key Concepts Master Recipes Recipe Resea ...
Cytoplasm. Nuclear pores. AAAAAA. AAAAAA. DNA. Transcription. RNA. RNA Processing. ...
Plant Family Holiday Recipe Brassicaceae, Solanaceae, Capparidaceae, Rutaceae, Oleaceae, Apiacea ...
Signapay: The Recipe for Success. Established in 1995Over 200 administration arranged employeesS ...
Part Learning Objectives. Clarify why an institutionalized formula is critical for expense contr ...