Using College Work Study Interface
Contents
1. _ lt lt m EE Authorizations Fund FwksTY 7 Be Authorization Placement ACAVP Position ooooo3 v Start Date 18 JUL 2006 El Suffix oo End Date 30 JUN 2007 El Status AUTH 7 Payroll Pay Rate 3d Start Date 18 JUL 2006 S Authorized Hours 275 End Date 30 2UL 2007 5 Authorized Earnings 1 416 25 Stipend Amount Activity Date l 18 JUL 2007 Georgia Enhancements 8 0 User Documentation College Work Study Interface March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology VI Verifying Reports CWSI Remaining The CWSI Remaining Balance Report ZRRWSTD indicates the Balance Report amount the student has remaining for payment from the work study program This remaining balance is calculated based on the amount paid for the current pay period and all previous pay periods as well as the award amount 1 Generate the ZRRWSTD provides the user with a list of the remaining award amount Remaining for each student The remaining balance is calculated based on the Balance amount paid to the student for the pay period and all previously posted pay periods Following is information about each of the parameters to use when running this process ZRRWSTD Parameters No Name Req Description Instructions Values 01 Aid Year Yes Enter the appropriate Aid Year for the YYYY Code te2. 0809 Aid Year Authorization Start Date 20 AUG 2008 E Authorization End Date Starting Pay Date Ending Pay Date Authorization Status j12 DEC 2008 E 20 auc 2008 E 12 DEC 2008 E AUTH Authorized To Work Georgia Enhancements 8 0 User Documentation College Work Study Interface Page 10 March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology Il Creating and Awarding Employment Authorizations Employment Authorizations 1 Create Awards for CWS RPAAWRD 2 Create Employment Authorizations RJASEAR Page 11 A student must have an award for college work study in the Award form RPAAWRD and a student employment record must exist in the Student Employment Authorization form RJASEAR Both of these forms are updated with payroll information by the completed CWSI processes Create awards for college work study on the Award form RPAAWRD A student must meet all eligibility requirements to receive an award for the College Work Study pee za ward Maintenance RPASWRD 8 5 2 Aid Year o910 7 ID 100100100 7 Cafe Tester Award Maintenance Fund Awards by Term Disbursement Schedule Fund Awards Overrides Locks Indicators Declined or Memoed or fal Description ia Offered Accepted Cancelled Authorized Paid Reschedule aa Federal Pell Grant 4600 00 4600 00 O FSUB Subsidized S
3. College Work Study Interface Georgia Enhanced Banner Student and Financial Aid Systems User Documentation Version 8 0 Office of Information and Instructional Technology March 2010 This page left blank to facilitate front back printing College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology Table of Contents UU OCU CU ON aac cca chee acts cece eee EEEE sect 1 PUDO SG ss E E a E 1 TAROT PANS e S E 1 Purpose and Scope Of Document cccccceeeesseeeeseeenseeeseeeenseeeseoeanseeseeoeasseeeeooessseeesooesneeessooenneees 1 GraNi E e EE E E E E E E 1 PEN ING CS aonan EAEE E EOE EEEE 2 PPO en E E A E E E 2 College Work Study Interface Menu and Forms Reference sscssseeeseeeeeees 3 WW a A A 3 CWSI Process FLOW cacsicsiivecisecicenivcubusebunnbunnscesbuwsbswunswesiinssenbswusuvusseusseusuwusssubweudueusweuteeiwes 4 DIESCHIDUION of CWS Piris a EE A E EE Ai 4 HEN AE ea o E E E 4 Overview of CWSI Process FIOW ssnnnnnnnnnnunnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn nnmnnn nnnm nnmnnn nnnm nnnm nnne 5 CONCOE Work SIUIGY MGM ACE icc ccccescensncesncescseaseecarsecneavecsesesnseseeesasesesauuseansonasesusannwescsets 7 I Establishing CWSI Codes and Rules 111 ccssscccssscnenencnenensnenenseenessenenssenanens 7 Preliminary ReguiremeNtS ai vccczicece satevessececscs ss ncewsdisetocceseecessinccessacevesaeviecstceaecetseseiecscepeeseaveescsesiauae 7 CWSI Co
4. Student and Financial Aid College Work Study Interface CWSI process inserts College Work Study payroll information from ADP into Banner eliminating manual entry Users maintain CWSI through Banner baseline and Georgia Enhancements Target Audience Target audience includes the following e Financial Aid Officers e Payroll Officers e Business Officers Purpose and Scope This document explains how to use the Georgia Enhanced version of of Document College Work Study Interface that accommodates University System of Georgia needs and requirements This chapter includes the following topics e Introduction to CWSI e CWSI Menu Reference e CWSI Process Flow e CWSI O Establishing CWSI Codes and Rules O Awarding and Creating Employment Authorizations O Creating the ADP Load File O Verifying and Correcting CWSI Error Results O Loading CWSI Data into Banner O Verifying CWSI Results Graphics Graphic cues used in this document assist with labeling of steps and items that are particularly important Steps for recovery or support For additional information see references Exercise caution a Dengar Warning an error here is critical Georgia Enhancements 8 0 User Documentation College Work Study Interface Page 1 March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology References Support Page 2 For information about the baseline produ
5. individuals to be loaded into Banner that are missing specific required data The records must be corrected manually before you run the update process Following is a list of errors that you may see on the error report Error Description of Error No SPRIDEN Record This error appears when a payroll record for a student exists that has no SPRIDEN record No Employment This error appears when the student is missing a Authorization Record record in the Student Employment Authorization form RJASEAR No Award Record This error appears when the student does not have a record in the Award form RPAAWRD No SGBSTN Record Exists This error appears when the student does not have a record in the General Student form SGASTDN Following is a sample of a zrpwst1 lis file with no errors produced when the CWSI Load process is executed wW Fe He WH w FPRPWSTL Y Y eH Ww WH HW OH wersion 8 0 Run began on 4 Mar 10 at 09 00 17 HHH AA AA A A AY RUF parameters HHH HAA A A File Name cws030410 txt Aid Year oo1oa Term Code 200908 Fund code FWRKSTY work Study Records without ERRORS 1 work Study Records with ERRORS G Total work Study Records a Total of work Study Payroll including errors 300 00 Run ended on OG4 Mar LO at 09 00 18 Georgia Enhancements 8 0 User Documentation College Work Study Interface Page 14 March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructiona
6. R student 4 lll Creating the ADP Load File 1 Create the CWS txt file in ADP to be loaded into Banner Move the file to a location where it can be processed by Banner IV Loading the ADP File into Banner 1 Execute the CWSI Load process ZRPWST1 Review the error report zrpwst1 lis Make necessary corrections according to the error message received in the output file Georgia Enhancements 8 0 User Documentation College Work Study Interface Page 5 March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology V Updating Records in Banner 1 Execute the CWSI Update process ZRPWST2 2 Verify the report output files lis amp log 3 Verify records are updated in Banner RPAAWRD and RJASEAR VI Verifying Reports 1 Generate the CWSI Remaining Balance ZRRWSTD Report 2 Review the Balance Report output lis amp log Georgia Enhancements 8 0 User Documentation College Work Study Interface Page 6 March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology College Work Study Interface I Establishing CWSI Codes and Rules Preliminary Requirements CWSI Codes and Rules Page 7 Specific required information must exist for each student in the following forms before CWSI Descriptive Title Name Identification Form SPAIDEN Award Form RPAAWRD Student Emplo
7. ST1 again Repeat this process until you receive no error messages on the report output Georgia Enhancements 8 0 User Documentation College Work Study Interface March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology V Updating Records in Banner CWSI Update The CWSI Update process ZRPWST2 loads the payroll data into the Process Award form RPAAWRD and the Student Employment Authorization form RJASEAR The paid amount is updated in both forms The remaining amount is updated in the RJASEAR form 1 Execute CWSI Run the CWSI Update process ZRPWST72 process from job Update Process submission GJAPCTL to update RPRAAWRD and RJASEAR Following is information about each of the parameters to use when running this process ZRPWST2 Parameters No Name Req Description Instructions Values 01 Aid Year Yes Enter the appropriate Aid Year forthe YYYY Code term you are processing payroll data 02 Process Yes Enter the process code to audit the A audit Code records that will be updated or to mode or update the student records U update mode 03 Override Yes Enter Y to override errors YorN Errors o Always set Parameter 3 to N unless you have verified with the Payroll pine Office that a correction is scheduled for the next payroll Georgia Enhancements 8 0 User Documentation College Work Study Interface Page 16 March 2010 College Work Study Interface Georg
8. ct see SGHE Banner Financial Aid User Manual Chapter 16 Student Employment For additional OIIT resources and support contact the ONT Helpdesk e Web support request self service http www usg edu customer_services e E mail Helpdesk usg edu For emergency business interruptions or production down situations call the OITT Helpdesk immediately e 706 583 2001 Toll free within Georgia 1 888 875 3697 Georgia Enhancements 8 0 User Documentation College Work Study Interface March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology College Work Study Interface Menu and Forms Reference es Use the following Banner baseline forms to establish and maintain College Work Study Descriptive Title Name Employment Authorization Status Validation Form RTVAUST Job Title Requirements Form RJRJREQ Job Title Base Data Form RJRJOBT Placement Base Data Form RJAPLBD Placement Rules Form RJRPLRL Student Employment Default Rules Form RJRSEDR Award Form RPAAWRD Student Employment Authorizations Form RJASEAR Use the following Georgia Enhancement processes to load and update student records for College Work Study Descriptive Title Name CWSI Load Process ZRPWST1 CWSI Update Process ZRPWST2 CWSI Remaining Balance Report ZRRWSTD Georgia Enhancements 8 0 User Documentation College Work Study Interface Page 3 March 2010 College Work Study Interface Office of Information Geor
9. de 200608 End Term Code 200702 Fund Code FWKSTY Total records PRINTED 12 Amount Georgia Enhancements 8 0 User Documentation College Work Study Interface 4 eK OM adaadadaaKadK Work Lock Dept Ind ACSACE N N N ACAVP N N N N N ACAVP N N ACAVP N ACAVP N March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology Appendix A Document History This section details the history of the document and updates made for each modification Release and Date Form Process Update Description Georgia Enhancements 7 0 NA All Original February 2006 Georgia Enhancements 7 14 ZRPWST1 15 Added screen shot of lis file with errors July 2008 Georgia Enhancements 8 0 ALL ALL Updated screen shots from version 7x to 8x March 31 2010 Added Overview flow Georgia Enhancements 8 0 User Documentation College Work Study Interface Page A 1 March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology Appendix B Process Flow College Work Study Overview Process Flay Student is awarded Work Study and Assigned a job Student geis paid Amount paid is recorded in ADF and ADP prepares file for Banner load Banner takes ADP file and loads into Banner Amount Faid to student is updated on Student s award Georgia Enhancements 8 0 U
10. des and FS obino seine cmece sees aa AE ENE ONNEA 7 Il Creating and Awarding Employment Authorizations 11 ccssscccensesennnesennnees 11 Employment AUthorizatioh S sssini a a a aE Es 11 Ii Creag Me ADF a T Oireina rnr EErEE aineena 12 ADP Flat File ccccccsssssssssssssessesscessesssessnesseesseesseessoessaessanesaneaseeuseessuessaessaneaaneaeessnessneasnenseens 12 IV Loading the ADP File into Bannet 11cc1sccesscensccnnccennsennscnsesensenssensesennsenssenes 13 CWSI Load Process gt ne eee ree ener ee ee 13 V Updating Records in Bannet ssssssasannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 16 CWSI Update Pro COS ocisinicinmiurinan ni i a a a i 16 VI Verifying Repotts sioe ners carson esc nteetn amet aren ansaegeunusd acenawedansesnccassesnscexsnsnneadenensseciaess 19 CWSI Remaining Balance Repoltt cssecccsssssssseeeeeeeeseeeeseneeeeeeeeeeeenseseeeeeeeeoeesnseeeeessseooennns 19 Appendix A DOCUMENT History siiccesivcsiscaticcsiccntinontecetenutusecumecseueuenbussuventventventwcutseutveuts A 1 Appendix B Process i OW asnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn nnnm B 1 Georgia Enhancements 8 0 User Documentation College Work Study Interface Page iii March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology Georgia Enhanced College Work Study Interface Introduction Purpose The Georgia Banner Enhanced
11. e 3 Address Line 4 o City Milledgeville State or Province ca 7 Zip or Postal Code Bios Nation US hd United States of America Country Code Telephone 12 E mail P Activity Date 02 MAR 2000 Georgia Enhancements 8 0 User Documentation College Work Study Interface Page 9 March 2010 College Work Study Interface Georgia Enhancements 8 0 Office of Information and Instructional Technology 5 Build Job Build Job Placement Rules on the Placement Rules form RJRPLRL Placement Rules Positions and the associated allocation for positions are established and RJRPLRL ed j maintained in this form for each student employment location Aid Year 0708 Placement Code ACAVP VP ACADEMIC AFFAIRS 7 Position oooo01 7 Z Allocation 50000 00 Employee Class st STUDENT Chart of Accounts Code a D Organization Code acayp 7 Position 000002 Allocation 0 00 Employee Class ST STUDENT Chart of Accounts Code Organization Code ACAYP 7 Position 000003 7 Allocation 0 00 Employee Class ST STUDENT Chart of Accounts Code Organization Code ACAYP m 6 Build Build the employment default files in the Student Employment Default Employment Rules form RJRSEDR The employment default rules define the PPETI SS authorization dates and pay dates for a specific aid year RJRSEDR par p JOAL ta Student Employment Default Rules RIRSEDR 8 0 Aid Year 0809
12. gia Enhancements 8 0 and Instructional Technology CWSI Process Flow Description of CWSI The College Work Study Interface updates Banner with student college work study payroll information from ADP Tasks are grouped into the following steps e Establishing CWSI Codes and Rules e Awarding and Creating Employment Authorizations e Creating the ADP Load File e Verifying and Correcting CWSI Error Results e Loading CWSI Data into Banner e Verifying CWSI Results Timeframe Schools must load and update Banner with College Work Study payroll information from ADP at the end of each pay period Georgia Enhancements 8 0 User Documentation College Work Study Interface Page 4 March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology Overview of CWSI Complete the following steps to load and update College Work Study Process Flow payroll information in Banner I Establishing CWSI Codes and Rules 1 Create Authorization Status codes RTVAUST Establish job skills RJRJREQ Associate job titles and descriptions with valid RJRJOBT pay rates Establish name and address information for RJAPLBD student employment locations Build the job placement rules RJRPLRL Build the employment default rules RJRSEDR ll Awarding and Creating Employment Authorizations 1 Create the award for the students entitled to RPAAWRD receive CWS Create the employment authorization foreach RJASEA
13. hancements 8 0 and Instructional Technology Iii Creating the ADP Flat File ADP Flat File 1 Create the ADPCWSHHHHHH txt Flat File ADPCWS txt File Layout Page 12 At the end of the pay period a payroll officer creates the ADPCW S txt file in ADP This file contains only college work study payroll data The ADPCWS txt file is moved from the c temp directory to the DATA_HOME tapedata finaid directory for the load process to read the file In ADP create the ADPCWS txt flat file where is the run ID in ADP that is used to post the student payroll dollars to RPAAWRD and RJASEAR Board of Regents gt BOR Payroll gt Interfaces gt GL Interface The flat file is created and stored in the c temp directory unless otherwise designated by the user Foa Poston Length Format Comments Expense Amount 71 79 Sign 7 2 999999 99 negative sign 99999 99 Encumbered 80 88 Sign 7 2 999999 99 negative Amount sign 99999 99 Pay Run 190 219 30 Char Description Georgia Enhancements 8 0 User Documentation College Work Study Interface March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology 2 Move the Flat File Move the flat file ADPCWS txt from the c temp directory to the DATA_HOME tapedata finaid directory Users need to remove ADP from the naming convention so that the file is name CW SHHHHHH tx
14. ia Enhancements 8 0 2 Verify Output Files Page 17 Office of Information and Instructional Technology Verify that ZRPWST2 has completed successfully and that there are no errors Sample output files follow Sample output for the audit lis file Page 1 work Study Report of Students Processed Term Amt Pay Semester Total ID Name code DATE Paid Rate Hours Balance Remaining 100100111 Tester cafe 200908 20100224 300 00 5 15 58 25 160 00 1500 00 Hw WW WW WH PRpPWwST2 YY WWE WW Ww version 8 0 Run began on 04 Mar 10 at 09 01 31 OHO ie ee Run parameters HOR te te te Aid Year 0910 Process Code u override N Total Amount Processed 300 Total Records Processed 1 Run ended on 04 Mar 10 at 09 01 32 Sample output for the update lis file Page i Work Study Report of Students Processed Term Amt Pay Semester Total ID Name Code DATE Paid Rate Hours Balance Remaining Fund 444555555 Beans Porkan 200608 20081015 213 10 19 41 38 446 90 1786 90 FWKSTY 741741741 Run Chicken 200608 20081015 192 73 ee Bs 37 42 660 22 89 78 FWKSTY ZRPWST2 amp version 8 0 Run began on 05 Nov 09 at 11 36 52 eee eee Run parameters eeeee Aid Year 0607 Process Code U Override gt N Total Amount Processed 405 83 Total Records Processed 2 Run ended on 05 Nov 09 at 11 36 53Content type text plain charset IS0 8859 1 Georgia Enhancements 8 0 User Documentation College Work Study I
15. l Technology 3 Make Corrections Page 15 The following sample displays errors that must be corrected before continuing to process work study Fage Ll work study Report of Students in ERROR Empl ID Payroll Name SSN Banner Name Amount Paid Fund Date Paid oo6o0011 Jo Jittery 248 90 FWKSTY 24 JAN 2010 21221221 PPR REAR PRR EEE SEES SEES AO MATCHING SSN IN SPBPERS RECORD Oo267O1 Mama Mia Hoochee 248 90 FWkKSTY 24 JAN 2010 Tffl ele PPR RAE E AES SEES S ESSE WO MATCHING SSN IN SPBPERS RECORD O061140 williams Stan 248 90 FWKSTY 4 J4N 2010 253532222 williams stan No EMPLOYMENT AUTHORIZATION RECORD O61 15 Jensen Toni 248 90 FWKSTY 4 J4N 2010 2604 5442 PPP PPLE PLP LLLP TATAA NO MATCHING SSN IN SPBPERS RECORD W wW FH WOW WH FPAPWOTL 4 Y WF OW WH HW Version 8 0 Run began on 03 Mar 10 at 04 07 07 HH AA AHA A Run parameters HHH AAA AAA File Name cws030310 txt Aid Year oo1o Term Code 200908 Fund code FWKSTY work Study Records without ERRORS 1 work Study Records with ERRORS 4 Total work Study Records 7 4 Total of Work Study Payroll including errors 1 195 60 Run ended on O3 Mar LO at 04 0711 Correct errors manually after reviewing the zrpwstl lis file you receive when you execute the CWSI Load process Create records in Banner to correct the No SPRIDEN Record error No Employment Authorization Record error No Award Record error and No SGBSTDN Record error Execute ZRPW
16. nterface Fund FWKSTY March 2010 College Work Study Interface Georgia Enhancements 8 0 3 Verify Update Page 18 Office of Information and Instructional Technology Verify that the records updated by the process are displayed correctly on RPAAWRD and RJASEAR The Paid column in both records is updated each time the student is paid RPAAWRD should display the amount the student was paid for the pay period zg Award Maintenance RPAAWRD 8 5 2 Aid Year o910 7 ID 100100100 7 Cafe Tester Award Maintenance Fund Awards by Term Disbursement Schedule Fund Awards Amounts Overrides Locks Indicators Declined or Fund Description Status Cancelled Paid Reschedule vv J FPELL Federal Pell Grant sacr FSUB Subsidized Stafford Loan SOFD FUNSUB Unsubsidized Stafford Loan SoFD FWKSTY Federal Work Study sacr GHOPBK HOPE Book Award SACP 0 0ogr0000 JU TUTTE Total Packaging Group Pell and Loan Budget 17 400 00 Group UGINON EFC Gross Need Resource 00 Pell EFC 3 087 FM 3 087 00 14 313 00 Offered 17 400 00 Aid Period FULL IM Unmet Need C a RJASEAR should display the amount paid and the remaining award balance for the student va Student Employment Authorization RIASEAR 8 4 Aid Year 0607 ID 741741741 7 Chicken Run Awards Fund Status Offered Accepted Paid Remaining FWKSTY SACP 1 500 00 1 500 00 1 410 22 89 78
17. rk Study Interface March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology 3 Associate Jobs On the Job Title Base Data form RJRJOBT associate job titles with with Pay Rates lid RURJOBT valid pay ranges Job Title Base Data RIRIOBT 8 0 Job Title Hourly Pay Pay Range Pay Range Pay Code Description Indicator Low Hig Default ANIMAL CARETAKER ASSISTANT AUDIO VISUAL ASSISTANT CHILD CARE ASSISTANT COMPUTER LAB ASSISTANT 0302 0401 DESK CLERK 0402 FACILITIES USE ASSISTANT 0701 GREENHOUSE ASSISTANT LAB ASSISTANT LIBRARY ASSISTANT 1201 MAINTENANCE ASSISTANT 1302 MUSEUM ASSISTANT OFFICE ASSISTANT PARKING ENFORCEMENT ASSISTANT PUBLIC SAFETY DISPATCHER RECEPTIONIST RESEARCH ASSISTANT RESIDENT ASSISTANT 1901 SALES CLERK iui aaaea aaalllt J J sh dlelelel dal ove DABAN ae ae ee ee ee alalalal al oatl oto ni onl on ol ol ol oo a lelek n Jelleke ngan elelel ell BPiRP RP BP BI BIL BP BP BP BP BBB BBB BRR a lalal al anlonl ot nf om ol ol ol oo oo 4 Establish Name On the Placement Base Data form RJAPLBD create and maintain and Address name and address information for student employment locations RJAPLBD poy 25 Placement Base Data RJAPLBD 8 5 Placement lacave VP ACADEMIC AFFAIRS Supervisor NEIL JONES Building Number oo Address Line 1 210 PARKS HALL Address Line 2 CPO BOX 024 Address Lin
18. rm you are processing payroll data 02 Begin Term Yes Enter the beginning term code for the Code Aid Year selected 03 End Term Yes Enter the ending term code for the Aid Code Year selected 04 Fund Code Yes Enter the valid fund code for the College Work Study Program 05 Choose Yes Enter the order the report will print 1 1 Order for alphabetical 2 for SSN 06 Choose Yes Enter the report to print 1 for error 3 Report table listing 2 for account balances 3 for both 2 Review Report Review the report output to determine if a student will exceed the award Output amount within the next pay period Sample output follows on the next page Georgia Enhancements 8 0 User Documentation College Work Study Interface Page 19 March 2010 College Work Study Interface Georgia Enhancements 8 0 Page 20 Sample output for the lis file Page 1 Office of Information and Instructional Technology Work Study Report of Students Fund Code Students with have balances of 100 444555555 Beans Porkan 899234321 Bellly Jelly 222333333 Brown Charlie 753753753 Bubba Hubba 955955955 Cablegquy Larry 001140824 Je Mecielia 001140827 Jensen Amanda 881881881 Klump Sherman 741741741 Run Chicken 777111111 Tester Plus 00010103 Vu Jensen Abbey N 654654654 Web charlotte ZRRWSTD version 8 0 Run began on 05 Nov 09 at 11 40 01 eee ee ee ee Run parameters eee ee ee ee Aid Year 0607 Begin Term Co
19. ser Documentation College Work Study Interface Page B 1 March 2010
20. steps that follow to establish CWSI codes and rules Georgia Enhancements 8 0 User Documentation College Work Study Interface March 2010 College Work Study Interface Georgia Enhancements 8 0 1 Create Authorization Status Codes RTVAUST 2 Establish Job Skills RJRJREQ Page 8 Office of Information and Instructional Technology Create student employment authorization status codes on the Employment Authorization Status Validation form RTVAUST The status code defines an authorization code that is used in conjunction with the student s employment 111 Eea Description Moved to Different Position Resigned From Job Terminated From Job Active Indicator 000000 8 8a Activity Date 25 Mar 2009 25 MAR 2009 25 Mar 2009 gt C Establish job skills on the Job Title Requirements form RJRJREQ The requirements to fill a position are associated with a specific job title Job Title Requirements Job Title Job Title Requirements Search 0102 ANIMAL CARETAKER ASSISTANT Requirements Cleans feeds and cares for animals Assists with upkeep of ithe area Performs related tasks as assigned 0103 AUDIO VISUAL ASSISTANT Requirements Issues equipment enforces rules and regulations for use De jobs as assigned Performs related tasks as assigned Requirements Keyword Georgia Enhancements 8 0 User Documentation College Wo
21. t The file must be in this location for the CWSI load process to read it IV Loading the ADP File into Banner CWSI Load Process 1 Execute the CWSI Load Process ZRPWST1 Page 13 The College Work Study Load process ZRPWST1 generates an error report to use to make corrections before you run the next process in the College Work Study Interface Use the CWSI Load process to load and report flat file data in the temporary table used for processing CWSI Execute the process through Job Submission GJAPCTL in Banner Following is information about each of the four parameters to use when running this process Note The CWS txt file must be located in the DATA_HOME tapedata finaid directory for the process to read the file ZRPWST1 Parameters No Name Req Description Instructions Values 01 FileName Yes Enter the name of the flat file CWS created in ADP HHH txt 02 Aid Year Yes Enter the appropriate Aid Year YYYY Code for the term you are processing payroll data 03 Term Yes Enter the term code to be used Code for posting the payroll data in Banner 04 Fund Yes Enter the fund code used for Code the College Work Study Program Georgia Enhancements 8 0 User Documentation College Work Study Interface March 2010 College Work Study Interface Office of Information Georgia Enhancements 8 0 and Instructional Technology 2 Review the Error The CWSI Load process generates an error report that lists Report students
22. tafford Loan SOFD 1663 00 O FunsuB Unsubsidized Stafford Loan SOFD 3087 00 oO FWKSTY Federal Work Study SACP 2000 00 2000 00 o GHOPBK HOPE Book Award SACP 300 00 300 00 O EE HOPE Scholarship sacp Lan ian E E Me 2 ee ee C J CH J OU O J O J LC jJ mo C A CO O J COO O J OO J O J LC Je z Total 17400 00 12650 00 f soooa Packaging Group Pell and Loan Budget 17 400 00 Group UGINON EFC Gross Need Unmet Need Resource 00 Pell EFC 3 087 FM 3 087 00 14 313 00 00 Offered 17 400 00 Aid Period FULL IM On the Student Employment Authorization form RJASEAR create the employment authorization for each student a a a aid hi as Student Employment Authorization RIASEAR 8 4 Aid Year 0910 7 ID 100100100 v Cafe Tester Awards Fund Status Offered Accepted Paid Remaining FWKSTY SACP 2 000 00 2 000 00 az LT L JE Authorizations Fund TEN 7 sa Authorization Placement acave X Position 000001 Start Date 03 MAR 2010 Suffix oo End Date 05 APR 2010 E Job Title 0101 Ed SS Status aur 7 Payroll Pay Rate Zis Start Date 03 mAR 2010 E Authorized Hours 100 End Date fo1 apr 2010 E Authorized Earnings 515 00 Stipend Amount Activity Date 03 MAR 2010 Georgia Enhancements 8 0 User Documentation College Work Study Interface March 2010 College Work Study Interface Office of Information Georgia En
23. yment Authorization Form RJASEAR You must establish CWSI codes and rules before the CWSI process Create a student employment authorization the Authorization Status Code Validation form RTV AUST Define and maintain the requirements to fill a position in the Job Title Requirements form RJRJREQ Job titles are associated with valid pay rates in the Job Title Base Data form RJRJOBT valid pay rates are used in the calculation with number of hours to work to determine the pay amount This information helps prevent over awards for the college work study program Each department office that employs a college work study recipient requires a placement record Establish this record in the Placement Base Data form RJAPLBD that stores the placement code supervisor and address information Each placement record is associated with job placement rules that are established in the Placement Rules form RJRPLRL The position allocation employment class and origination codes are entered in this form Build employment default rules for each aid year in Student Employment Default Rules form RJRSEDR The authorization start and end dates define the period of time the student is authorized for employment in a department The starting and ending pay dates define the first and last date of payment to the student The authorization status code declares a student authorized to work under the work study program for the defined aid year Complete the
Download Pdf Manuals
Related Search