0.008/24/87 CAROL WILLIS 1.0 INTRODUCTION: ------------ THE EMPLOYMENT APPLICATION SUBSYSTEM IS DESIGNED TO STORE DATA FROM EACH APPLICATION RECEIVED BY THE PERSONNEL DEPARTMENT. THE DATA IS USED TO GENERATE LISTS AND MAILING LABELS OF PERSONS WHO HAVE APPLIED FOR EMPLOYMENT AT THE COLLEGE. 2.0 SYSTEM NARRATIVE ---------------- THE MAIN DATA ENTRY SCREEN OF THE EMPLOYMENT APPLICATION SUBSYSTEM IS USED TO CAPTURE DATA FROM THE EMPLOYMENT APPLICATION. EACH RECORD CREATED BY THE DATA ENTRY SCREEN CONTAINS UP TO THREE POSITION CODES WITH THEIR CORRESPONDING DATES OF ENTRY, DATES RECEIVED AND DATES REVIEWED. EACH RECORD ALSO CONTAINS SPACE FOR UP TO SEVEN DISCIPLINE CODES. A LIST OF THESE DISCIPLINE CODES AND THEIR DESCRIPTION IS KEPT ON THE SIS CONTROL DATA BASE. A LIST OF EDUCATION LEVELS , A - J, AND THEIR DESCRIPTION IS ALSO KEPT ON THE SIS CONTROL DATA BASE. THESE TWO FILES MAY BE UPDATED BY ONLINE TRANSACTIONS AND LISTED BY BATCH PROGRAMS. 2.1 SYSTEM FLOWCHART ---------------- _____________ _____________ ! EMP. APPL.! ! SIS CTL ! ! DATA ! ! DATA ! ! BASE ! ! BASE ! !___________! !___________! ! ! ! ! !________________________! ! ! ______!______ ! PROCESS ! ! TRANS- ! ! ACTIONS ! !___________! ! ______________________!____________________________.....> ! ! ! ! ! ! ! ! ______!______ ______!______ ______!______ ______!______ !___APP010__! !___APP020__! !___APP030__! !___APP040__! ! EMP. APPL.! ! EMP. APPL.! ! UPDATE ! ! UPDATE ! ! DATA ENTRY! ! INQUIRY ! ! DISCIPLINE! ! EDUCATION ! !__SCREEN___! !__SCREEN___! !___CODES___! !___LEVEL___! >.....___________________________________________________.....> ! ! ! ! ! ! ! ! ______!______ ______!______ ______!______ ______!______ !___APP050__! !___APP500__! !___APP510__! !___APP520__! ! CHANGE ! ! EMP. APPL.! ! EMP. APPL.! ! ACTIVE/ ! ! SSN ! ! BY ! ! BY ! ! INACTIVE ! !___________! !_DISCIPLINE! !_POSITION__! !_EMP. APPL.! >.....__________________ ! ! ! ! ______!______ ______!______ !___APP530__! !___APP540__! ! DISCIPLINE! ! EDUCATION ! ! CODE ! ! LEVEL ! !__LISTING__! !__LISTING__! 3.0 DATA BASE DESIGN: ---------------- --------- --------- ] APPM ]- ] CTL DB]- ---------] ---------] --------- --------- 3.1 SEGMENT LAYOUT: -------------- APPLICM SEQUENCED AND UNIQUE ONE ENTRY FOR EACH PERSON APPLYING KEY IS SOCIAL-SECURITY 05 SOCIAL-SECURITY PIC 9(9). 05 ADDRESS-1 PIC X(26). 05 ADDRESS-2 PIC X(26). 05 CITY PIC X(20). 05 DATE-BIRTH PIC X(6). 05 DATE-ENTERED OCCURS 3 TIMES PIC X(6). 05 DATE-RECEIVED OCCURS 3 TIMES PIC X(6). 05 DATE-REVIEW OCCURS 3 TIMES PIC X(6). 05 DISC OCCURS 7 TIMES PIC X(4). 05 EDUCATION-LEVEL PIC X. 05 FTPT-CODE. 10 FT PIC X. 10 PT PIC X. 05 NAME-LAST PIC X(17). 05 NAME-FIRST PIC X(11). 05 NAME-INITIAL PIC X. 05 NAME-SUFFIX PIC XXX. 05 POSITION-NUMBER OCCURS 3 TIMES PIC X(5). 05 STATE PIC X(5). 05 STATUS-APPL PIC X(2). 05 ZIP PIC X(9). 05 FILLER PIC X(20). CTLDISC SEQUENCED AND UNIQUE ONE ENTRY FOR EACH DISCIPLINE CODE KEY IS SEGMENT-TYPE/DISC-CODE 05 LL-SEGMENT-INDICATOR PIC S9(4) COMP VALUE +65 05 DISC-SEGMENT-KEY. 10 SEGMENT-TYPE PIC XX VALUE '81' 10 DISC-CODE PIC X(4). 10 FILLER PIC X(4). 05 DISCIPLINE-NAME PIC X(24). 05 FILLER PIC X(26) CTLEDUC SEQUENCED AND UNIQUE ONE ENTRY FOR EACH EDUCATION LEVEL KEY IS SEGMENT-TYPE/EDUC-CODE 05 LL-SEGMENT-INDICATOR PIC S9(4) COMP VALUE +65 05 DISC-SEGMENT-KEY. 10 SEGMENT-TYPE PIC XX VALUE '82' 10 EDUC-CODE PIC X. 10 FILLER PIC X(7). 05 EDUCATION-LEVEL-NAME PIC X(20). 05 FILLER PIC X(30) 3.2 DATA DICTIONARY: --------------- ADDRESS-1 FIRST ADDRESS LINE (APPLICM) ADDRESS-2 SECOND ADDRESS LINE (APPLICM) CITY CITY OF APPLICANT (APPLICM) DATE-BIRTH BIRTHDAY OF APPLICANT (APPLICM) DATE-ENTERED DATE APPLICATION FOR A POSITION (APPLICM) WAS ENTERED DATE-RECEIVED DATE APPLICATION FOR A POSITION (APPLICM) WAS RECEIVED DATE-REVEIWED DATE APPLICATION FOR A POSITION (APPLICM) WAS REVIEWED DISC DISCIPLINE CODE (UP TO SEVEN (APPLICM) POSSIBLE) DISC-CODE 4-BYTE DISCIPLINE CODE (CTLDISC) DISCIPLINE-NAME NAME OF DISCIPLINE (CTLDISC) EDUC-CODE EDUCATION CODE (A-J) (CTLEDUC) EDUCATION-LEVEL COMPLETED SCHOOLING (APPLICM) (A-J) EDUCATION-LEVEL-NAME EDUCATION LEVEL NAME (CTLEDUC) FTPT-CODE 2-BYTE FLAG FOR FULL TIME/ (APPLICM) PART TIME EMPLOYMENT FIRST BYTE = 'F' OR SPACE SECOND BYTE = 'P' OR SPACE NAME-LAST LAST NAME OF APPLICANT (APPLICM) NAME-FIRST FIRST NAME OF APPLICANT (APPLICM) NAME-INITIAL INITIAL OF APPLICANT (APPLICM) NAME-SUFFIX SUFFIX OF APPLICANT (APPLICM) POSITION-NUMBER NUMBER OF POSITION FOR WHICH (APPLICM) PERSON IS APPLYING (UP TO 3 PER PERSON) SOCIAL-SECURITY SOCIAL SECURITY NUMBER (APPLICM) STATE STATE OF APPLICANT (APPLICM) STATUS-APPL STATUS OF APPLICATION (APPLICM) 'A' = ACTIVE 'I' = INACTIVE ZIP ZIPCODE OF APPLICANT (APPLICM) 4.0 PROGRAM DOCUMENTATION: --------------------- THE FOLLOWING SUMMARIZES THE PROGRAMS WHICH COMPRISE THE EMPLOYMENT APPLICATION SUBSYSTEM. SCREENS ------- APP010 EMPLOYMENT APPLICATION DATA ENTRY APP020 EMPLOYMENT APPLICATION INQUIRY APP030 POSITION CODE UPDATE APP040 EDUCATION LEVEL UPDATE APP050 CHANGE SOCIAL-SECURITY NUMBER REPORTS ------- APP500 PRINT A LIST OF APPLICANTS BY DISCIPLINE CODE AND DATE ENTERED OR DATE RECEIVED (LABELS OPTIONAL) APP510 PRINT A LIST OF APPLICANTS BY POSITION NUMBER AND DATE ENTERED OR DATE RECEIVED (LABEL OPTIONAL) APP520 LIST OF ACTIVE/INACTIVE APPLICANTS APP530 LIST OF DISCIPLINE CODES AND DESCRIPTION APP540 LIST OF EDUCATION LEVELS AND DESCRIPTION 5.0 IMPLEMENTATION PROCEDURE: ------------------------ THE FOLLOWING PROCEDURES SHOULD BE PERFORMED TO PREPARE FOR THE USE OF THE EMPLOYMENT APPLICATION SUBSYSTEM. 1. LOAD THE EMPLOYMENT APPLICATION DATA BASE, IF THE FILES ARE AVAILABLE. 2. ADD THE DISCIPLINE CODES AND NAMES USING APP030. ADD THE EDUCATION LEVELS AND NAMES USING APP040. DO NOT ATTEMPT TO ADD OR UPDATE ANY EMPLOYMENT APPLICATIONS UNTIL THIS IS ACCOMPLISHED. 3. USE MST010 TO ADD APP000, PASSWORD TRANSACTION. USE MST020 TO ASSIGN A 'DELETE' PASSWORD TO APP000. THE SYSTEM USES THIS AS A SECURITY CHECK FOR THE APP010 EMPLOYMENT APPLICATION DATA ENTRY SCREEN.