0.002/15/92 SUE DOTSON 1.0 INTRODUCTION: ------------- THE LEAVE ACCOUNTING SUBSYSTEM IS DESIGNED TO PROVIDE THE PERSONNEL OFFICE WITH THE ABILITY TO INPUT AND MAINTAIN COLLEGE EMPLOYEE LEAVE DATA. THE MAJOR OBJECTIVES OF THE SUBSYSTEM ARE: 1. MAINTAIN EMPLOYEE LEAVE BALANCES BY AUTOMATIC LEAVE ACCRUAL, AND REDUCTION BY POSTING ENTRIES FOR LEAVE TAKEN. 2. PROVIDE PERSONNEL WITH TIMELY AND INFORMATIVE REPORTS. 2.0 SYSTEM NARRATIVE ---------------- THE LEAVE ACCOUNTING SUBSYSTEM UTILIZES THE PERSONNEL DATA BASE TO OBTAIN EMPLOYEE DEMOGRAPHIC DATA AND FOR STORAGE OF THE LEAVE ENTRIES. ALTHOUGH THE PERSONNEL SUBSYSTEM IS A SEPARATE SUBSYSTEM, THE PERSONNEL DATA IS VITAL TO THE LEAVE ACCOUNTING FUNCTIONS. AN EMPLOYEE'S CLASSIFICATION CODE DETERMINES THE TYPE OF LEAVE PROCESSING REQUIRED. A CLASSIFICATION CODE LESS THAN '10000' IS INDICATIVE OF A FACULTY MEMBER, AND CODES ABOVE DENOTE THE EMPLOYEE IS CLASSIFIED STAFF. ADDITIONALLY, THE YEARS OF STATE SERVICE CONTROL THE AMOUNT OF LEAVE ACCRUAL AND THE STATE SERVICE DATE, THE POINT AT WHICH THE INCREASED ACCRUAL RATE BECOMES EFFECTIVE. THE SUBSYSTEM PROCESSES LEAVE FOR TWO BASIC TYPES OF EMPLOYEES, FACULTY AND CLASSIFIED STAFF. THE EXCEPTION BEING FACULTY ADMIN- ISTRATORS WHO HAVE A FACULTY CLASSIFICATION CODE BUT RECEIVE LEAVE THE SAME AS A CLASSIFIED EMPLOYEE. THERE ARE FIVE KINDS OF LEAVE ENTRIES. TYPE 'T' REPRESENTS LEAVE TAKEN. LEAVE TYPE 'E' REPRESENTS LEAVE EARNED. TYPE 'B' STORES THE BEGINNING BALANCE FOR THE YEAR. RECORDS WHICH RECORD THE CONVERSION OF FACULTY PERSONAL LEAVE TO SICK ARE LEAVE TYPE 'C'. RECORDS DOCUMENTING LEAVE FORFEITED ARE TYPE 'F'. LVE010 IS AN ONLINE PROGRAM FOR ENTERING LEAVE ENTRIES. THE FOLLOWING IS A LIST OF LEAVE CODES ACCEPTED BY LVE010. LVE APPLICABLE CODE DESCRIPTION LEAVE TYPES 'A ' ANNUAL LEAVE B, E, F, T 'C ' COMPENSATORY TIME B, E, F, T 'AD' ADMINISTRATIVE LEAVE T 'FS' FAMILY SICK T 'L ' LEAVE WITHOUT PAY T 'M ' MILITARY LEAVE WITH PAY B, T 'ML' MILITARY LEAVE WITHOUT PAY T 'O ' OVERTIME B, E, T 'P ' PERSONAL LEAVE B, C, E, T 'S ' SICK LEAVE B, E, T 'SP' SUSPENSION T 'W ' WORKMAN'S COMP T LVE300 IS A DAILY BATCH UPDATE, WHICH APPLIES LEAVE ENTRIES TO THE BALANCES FOR ANNUAL, SICK, FAMILY SICK, PERSONAL (CONTINGENCY), COMPENSATORY, OVERTIME, AND MILITARY LEAVE TO MAINTAIN A 'CURRENT' BALANCE. CURRENT BALANCES ARE ADJUSTED BY LVE010 WHEN LEAVE ENTRIES ARE PROCESSED IF THE LEAVE ENTRY IS PRIOR TO THE DATE THE BALANCES WERE UPDATED BY LVE300. IN ADDITION, IF THE LEAVE ENTRY IS FOR A PRIOR YEAR, THE BEGINNING BALANCE RECORDS UP TO THE CURRENT YEAR ARE ADJUSTED. COLLEGE FACULTY ARE GIVEN 24 HOURS OF PERSONAL CONTINGENCY LEAVE AT THE START OF THE ACADEMIC YEAR. FACULTY ALSO RECEIVE 36 HOURS OF SICK LEAVE FOR EACH TERM OF THE ACADEMIC YEAR. LEAVE EARNED RECORDS ARE GENERATED FOR EACH TERM IN WHICH A FACULTY MEMBER ACCRUES SICK OR PERSONAL LEAVE. PERSONAL LEAVE THAT HAS NOT BEEN TAKEN BY THE END OF THE SUMMER TERM IS AUTOMATICALLY CONVERTED TO SICK LEAVE, AND A LEAVE CONVERTED RECORD WILL BE GENERATED CONTAINING THE HOURS THAT WERE ADDED TO SICK LEAVE. REMAINING SICK LEAVE IS CARRIED FORWARD INDEFINITELY. THE ADDITION OF FACULTY CONTINGENCY AND SICK LEAVE IS CONTROLLED BY THE PROGRAM OPTION SEGMENT 'LVES0201' (COPY MEMBER LVEDATES) WHICH CONTAINS THE TERM DATES, ACADEMIC YEAR, AND BEGINNING AND ENDING TERM FLAGS. LVE300 WILL ADD THE LEAVE BY CHECKING THE DATES AND FLAGS WHEN IT IS RUN AFTER THE BEGINNING OF EACH TERM. IT IS IMPORTANT THAT THE DATES ARE CODED CORRECTLY TO AVOID LEAVE BEING INCREMENTED AT THE WRONG TIME. ACCRUAL OCCURS BI-MONTHLY FOR CLASSIFIED EMPLOYEES. THE BATCH UPDATE PROGRAM, WHEN RUN ON OR AFTER THE FIRST (1ST) AND THE SIXTEENTH (16TH) OF EACH MONTH ADDS THE LEAVE AMOUNTS TO EACH ELIGIBLE EMPLOYEE BALANCE. ADDITIONALLY, THE PROGRAM WILL GEN- ERATE LEAVE EARNED RECORDS TO REFLECT THE HOURS OF ANNUAL AND SICK LEAVE ACCRUED. AT THE BEGINNING OF JANUARY, A BALANCE RECORD IS CREATED FOR EACH LEAVE ACCOUNT FOR WHICH AN EMPLOYEE IS ELIGIBLE TO STORE THE BEGINNING YEAR BALANCE. ALL CLASSIFIED STAFF ARE GIVEN FIVE (5) HOURS OF SICK LEAVE PER PAY PERIOD. CLASSIFIED STAFF ANNUAL ACCRUAL IS BASED ON THE NUMBER OF YEARS OF STATE SERVICE AS FOLLOWS: LESS THAN FIVE (5) YEARS - FOUR (4) HOURS ANNUAL UP TO A MAXIMUM OF 192 HRS CAN BE CARRIED OVER. FIVE (5) TO NINE (9) YEARS - FIVE (5) HOURS ANNUAL TO A MAXIMUM OF 240 HRS CAN BE CARRIED OVER. TEN (10) TO NINETEEN (19) YEARS - SIX (6) HOURS ANNUAL TO A MAXIMUM OF 288 HRS CAN BE CARRIED OVER. MORE THAN TWENTY (20) YEARS - SEVEN (7) HOURS ANNUAL TO A MAXIMUM OF 336 HRS CAN BE CARRIED OVER. EXCESS ANNUAL LEAVE CAN BE USED THROUGH THE END OF JUNE. AT THE FIRST OF JULY, LVE300 WILL DETERMINE WHETHER THE EMPLOYEE'S LEAVE EXCEEDED THE MAXIMUM AND WHETHER THE EXCESS HAS BEEN USED. IF IT HAS NOT BEEN USED, A FORFEIT LEAVE RECORD IS CREATED CONTAINING THE HOURS LOST, AND THE LOST HOURS ARE SUBTRACTED FROM THE CURRENT BALANCE. CARE SHOULD BE TAKEN TO POST ALL OUTSTANDING ENTRIES FOR LEAVE TAKEN PRIOR TO EXECUTING LVE300. IN ORDER FOR THE PERSONNEL OFFICE TO BE SURE THE BALANCES ARE BEING PROPERLY MAINTAINED, LVE305 CAN BE RUN BI-MONTHLY TO PRINT THE LEAVE FOR EACH EMPLOYEE. ADDITIONALLY, THE PROGRAM UPDATES THE FLAGS ON PROGRAM OPTION LVES01YY (WHERE YY IS THE CURRENT YEAR) INDICATING LEAVE HAS BEEN BALANCED FOR THE PERIOD. IF PERSONNEL CHOOSES NOT TO RUN LVE305, THE FLAGS MUST BE UPDATED ONLINE VIA REF070. LVE300 EXAMINES THE FLAGS AT THE BEGINNING OF IT'S RUN AND WILL STOP IF THE FLAG IS NOT SET FOR THE PREVIOUS PERIOD. THE FLAGS MAY BE USED TO INTENTIONALLY PREVENT THE DAILY UPDATE FROM EXECUTING WHEN THE PERSONNEL OFFICE WISHES TO COMPLETE WORK PRIOR TO UPDATING THE BALANCES. THE LEAVE ACCOUNTING SUBSYSTEM PROVIDES A VARIETY OF INFORMATIVE REPORTS TO ASSIST THE PERSONNEL OFFICE IN MAINTAINING CORRECT LEAVE BALANCES AND TO PROVIDE EMPLOYEES WITH RECORDS OF THEIR ACCRUED LEAVE. 3.0 DATA BASE DESIGN ---------------- PERDBD ------ THE PERSONNEL DATA BASE, PERDBD, IS USED BY THE LEAVE ACCOUNTING SUB- SYSTEM TO PROVIDE ACCESS TO THE PERSONNEL DEMOGRAPHIC DATA AND STORAGE FOR THE LEAVE ENTRIES. --------------- ] ] ] PERSONLM ] ] ] ] (SOCSECNO) ] --------------- ] ] -----------------------------------------------------------------...... ] ] ] ] ] ] --------------- --------------- --------------- ] ] ] ] ] ] ] PERLEAVE ] ] PERFACUL ] ] PEREDUCN ] ] ] ] ] ] ] ] (LEAVKEY) ] ] (NO KEY) ] ] (SCHOOLID) ] --------------- --------------- --------------- ....-------------------------------- ] ] ] ] --------------- --------------- ] ] ] ] ] PERCONT ] ] PERPAYRL ] ] ] ] ] ] (CLASSID) ] ] (PAYRLKEY) ] --------------- --------------- 3.1 PERSONLM SEGMENT: ***************************************************************** * * * PERSONLM * * * * ONE ENTRY PER STAFF/FACULTY MEMBER * * * ******* KEY FIELD ID: SOCIAL-SECURITY ******* ******* SEGMENT KEY: SOCSECNO ******* ******* SEGMENT LENGTH: 383 BYTES ******* ******* COPY MEMBER LENGTH: 403 BYTES ******* ***************************************************************** 05 SOCIAL-SECURITY PIC 9(9). 05 LAST-NAME PIC X(20). 05 FIRST-NAME PIC X(12). 05 INITAL PIC X(1). 05 ADRESS PIC X(20). 05 CITY PIC X(20). 05 STATE PIC X(2). 05 ZIPCODE PIC X(9). 05 PHONE-HOME. 10 PHONE-HOME-AREA PIC X(3). 10 PHONE-HOME-EXCH PIC X(3). 10 PHONE-HOME-EXTEN PIC X(4). 05 PHONE-OFFICE. 10 PHONE-EXCH-OFC PIC X(3). 10 PHONE-NUM-OFC PIC X(4). 05 BIRTH-DATE. 10 BIRTH-YR PIC X(2). 10 BIRTH-MO PIC X(2). 10 BIRTH-DAY PIC X(2). 05 CITIZEN PIC X(1). 05 HANDICAP PIC 9(3). 05 RACE PIC X(1). 05 SEX PIC X(1). 05 ANNUAL-SALARY PIC S9(6)V99 COMP-3. 05 REC-SALARY PIC S9(6)V99 COMP-3. 05 PART-TIME-RATE PIC S9(4)V99 COMP-3. 05 CLASS-CODE. 10 CLAS1. 15 CLS1 PIC X(3). 15 CLS2 PIC X(1). 10 CLAS2 PIC X(1). 05 NEW-CLASS-CODE PIC X(5). 05 COLLEGE-TITLE PIC X(40). 05 OBJECT-CODE PIC X(4). 05 POSITION-NO PIC X(5). 05 POSITION-DATE. 10 POSITION-YR PIC X(2). 10 POSITION-MO PIC X(2). 10 POSITION-DAY PIC X(2). 05 POSITION-STAT PIC X(1). 05 MERIT-DATE. 10 MERIT-YR PIC X(2). 10 MER-YR REDEFINES MERIT-YR PIC 9(2). 10 MERIT-MO PIC X(2). 10 MERIT-DAY PIC X(2). 05 EMPLOYMENT-DATE. 10 EMPLOYMENT-YR PIC X(2). 10 EMPLOYMENT-MO PIC X(2). 10 EMPLOYMENT-DAY PIC X(2). 05 CAMPUS-DEPT. 10 CAMPUS-DEPT-CAMP PIC X(1). 10 CAMPUS-DEPT-NO PIC X(3). 05 COST-CENTER-ID. 10 COST-CENTER-CAMP PIC X(1). 10 COST-CENTER-NO PIC X(2). 05 YRS-SERVICE PIC 9(2). 05 COLLEGE-SERVICE PIC 9(2). 05 PCT-ANN-SALARY PIC V9(3) COMP-3. 05 GRANT-EXP-DATE. 10 GRANT-EXP-YR PIC X(2). 10 GRANT-EXP-MO PIC X(2). 10 GRANT-EXP-DAY PIC X(2). 05 ROOM-NUMBER. 10 BUILDING PIC X(3). 10 ROOM-NO PIC X(4). 05 ANNUAL-LEAVE PIC S9(3)V99 COMP-3. 05 SICK-LEAVE PIC S9(4)V99 COMP-3. 05 FAM-SICK-LEAVE PIC S9(2)V99 COMP-3. 05 COMPENSATORY-TIME PIC S9(3)V99 COMP-3. 05 CONTIG-LEAVE PIC S9(2)V99 COMP-3. 05 MILITARY-LEAVE PIC S9(3)V99 COMP-3. 05 INCREASE-DATE. 10 INCREASE-YR PIC X(2). 10 INC-YR REDEFINES INCREASE-YR PIC 9(2). 10 INCREASE-MO PIC X(2). 10 INCREASE-DAY PIC X(2). 05 SERVICE-DATE. 10 SERVICE-YR PIC X(2). 10 SERV-YR REDEFINES SERVICE-YR PIC 9(2). 10 SERVICE-MO PIC X(2). 10 SERVICE-DAY PIC X(2). 05 TRANSFER-DATE. 10 TRANSFER-YR PIC X(2). 10 TRANSFER-MO PIC X(2). 10 TRANSFER-DAY PIC X(2). 05 AGENCY-CODE PIC X(3). 05 TIMESHEET-DATE. 10 TIMESHEET-YR PIC X(2). 10 TIMESHEET-MO PIC X(2). 10 TIMESHEET-DAY PIC X(2). 05 PAY-DOCK-HOURS PIC S9(2)V99 COMP-3. 05 TERMINATION-DATE. 10 TERMINATION-YR PIC X(2). 10 TERMINATION-MO PIC X(2). 10 TERMINATION-DAY PIC X(2). 05 ADMIN-CODE PIC X(2). 05 COLLEGE-SER-DATE. 10 COLLEGE-SER-YR PIC X(2). 10 COLL-SER-YR REDEFINES COLLEGE-SER-YR PIC 9(2). 10 COLLEGE-SER-MO PIC X(2). 10 COLLEGE-SER-DAY PIC X(2). 05 ANNUAL-HRS-AUTH PIC S9(4) COMP-3. 05 HOURLY-RATE-AUTH PIC S9(2)V99 COMP-3. 05 EFFECTIVE-DATE. 10 EFFECTIVE-YR PIC X(2). 10 EFF-YR REDEFINES EFFECTIVE-YR PIC 9(2). 10 EFFECTIVE-MO PIC X(2). 10 EFFECTIVE-DAY PIC X(2). 05 HEALTH-CARE-PREMIUM PIC S9(4)V99 COMP-3. 05 RETIREMENT-PLAN PIC X. 05 FILLER PIC X. 05 SPOUSE-FIRST-NAME PIC X(12). 05 REC-ADMIN-CODE PIC X(2). 05 TOTAL-STATE-SERVICE PIC 9(2). 05 TOTAL-SERVICE-DATE. 10 TOTAL-SERV-YR PIC X(2). 10 TOTAL-SERV-MO PIC X(2). 10 TOTAL-SERV-DAY PIC X(2). 05 OVERTIME-LEAVE PIC S9(2)V99 COMP-3. 05 OVERTIME-LVE-ELIG PIC X(1). 05 SCHOOL-ASSIST-LEAVE PIC S9(2)V99 COMP-3. 05 HEALTH-CARE-TYPE. 10 HEALTH-CARE-ENROL PIC X(1). 10 HEALTH-CARE-PLAN PIC X(2). 05 PERSONLM-DBD-FILLER PIC X(30). 05 PERSONLM-COPY-FILLER PIC X(20). 3.2 PERLEAVE SEGMENT: 05 LEAVE-KEY. 10 LEAVE-DATE. 15 LEAVE-YR PIC X(2). 15 LEAVE-MO PIC X(2). 15 LEAVE-DAY PIC X(2). 10 LEAVE-TYPE PIC X. 05 LEAVE-HOURS PIC S9(2)V99 COMP-3. 05 LEAVE-CODE PIC X(2). 05 PERLEAVE-DBD-FILLER PIC X(19). 05 PERLEAVE-COPY-FILLER PIC X(20). 3.3 PERFACUL SEGMENT: 05 ASST-INST-DATE. 10 ASST-INST-YR PIC X(2). 10 ASST-INST-MO PIC X(2). 05 INSTRUCTOR-DATE. 10 INSTRUCTOR-YR PIC X(2). 10 INSTRUCTOR-MO PIC X(2). 05 ASST-PROF-DATE. 10 ASST-PROF-YR PIC X(2). 10 ASST-PROF-MO PIC X(2). 05 ASSOC-PROF-DATE. 10 ASSOC-PROF-YR PIC X(2). 10 ASSOC-PROF-MO PIC X(2). 05 PROFESSOR-DATE. 10 PROFESSOR-YR PIC X(2). 10 PROFESSOR-MO PIC X(2). 05 BEGIN-RANK PIC X. 05 COL-NO-HIRED PIC X. 05 CUR-COL-NO PIC X. 05 CUR-CON-DATE. 10 CUR-CON-YR PIC X(2). 10 CUR-CON-MO PIC X(2). 10 CUR-CON-DAY PIC X(2). 05 CUR-CON-TYPE PIC X. 05 CUR-CON-YEAR PIC X. 05 CUR-EVAL-DATE. 10 CUR-EVAL-YR PIC X(2). 10 CUR-EVAL-MO PIC X(2). 10 CUR-EVAL-DAY PIC X(2). 05 CUR-EVALUATION PIC X. 05 EVALUATION1 PIC X. 05 EVALUATION2 PIC X. 05 EVALUATION3 PIC X. 05 CURR-TYPE PIC X(4). 05 TEACH-FIELD1 PIC X(6). 05 TEACH-FIELD2 PIC X(6). 05 TEACH-FIELD3 PIC X(6). 05 CON-COLL-TEACH PIC S9(2)V99 COMP-3. 05 OTHER-COLL-EXP PIC S9(2)V99 COMP-3. 05 VCCS-TEACH-EXP PIC S9(2)V99 COMP-3. 05 FOUR-YR-TCH-EXP PIC S9(2)V99 COMP-3. 05 TWO-YR-TCH-EXP PIC S9(2)V99 COMP-3. 05 REL-OCCUPATION PIC S9(2)V99 COMP-3. 05 NON-SALARY PIC X. 05 REC-COL-NO PIC X. 05 REC-CON-TYPE PIC X. 05 SAL-INCREASE PIC X. 05 MERIT-DOLLAR PIC S9(4) COMP-3. 05 MERIT-PERCENT PIC SV9999 COMP-3. 05 SALARY-ADJUST PIC S9(4) COMP-3. 05 HIGH-SCH-TCH-EXP PIC S9(2)V99 COMP-3. 05 BONUS-DOLLAR PIC S9(4) COMP-3. 05 FAC-FALL-CREDIT-HRS PIC S9(2)V99 COMP-3. 05 FAC-FALL-CONT-HRS PIC S9(2)V99 COMP-3. 05 FAC-SPRING-CREDIT-HRS PIC S9(2)V99 COMP-3. 05 FAC-SPRING-CONT-HRS PIC S9(2)V99 COMP-3. 05 REC-BONUS-DOLLAR PIC S9(4) COMP-3. 05 REC-MERIT-DOLLAR PIC S9(4) COMP-3. 05 REC-MERIT-PERCENT PIC SV9999 COMP-3. 05 PERFACUL-DBD-FILLER PIC X(19). 05 PERFACUL-COPY-FILLER PIC X(20). 3.4 PEREDUCN SEGMENT: 05 TRANSFER-COLLEGE-FICE PIC X(6). 05 DEGREE-NAME PIC X(10). 05 DEGREE-DATE. 10 DEGREE-YR PIC X(2). 10 DEGREE-MO PIC X(2). 05 DEGREE-EARN PIC X. 05 MAJOR-CODE PIC X(6). 05 MINOR-CODE PIC X(6). 05 INCLUSIVE-DATE. 10 INCLUSIVE-BEG-YR PIC X(2). 10 INCLUSIVE-END-YR PIC X(2). 05 TEACH-FLD-HOURS PIC S9(3)V9 COMP-3. 05 MAJOR-HOURS PIC S9(3)V9 COMP-3. 05 PLAN-PROG-HRS PIC S9(3)V9 COMP-3. 05 TOTAL-HOURS PIC S9(3)V9 COMP-3. 05 PEREDUCN-DBD-FILLER PIC X(20). 05 PEREDUCN-COPY-FILLER PIC X(20). 3.5 PERCONT SEGMENT 05 CLASS-ID. 10 TERM-ID. 15 TERM-YR PIC X(2). 15 TERM-CODE PIC X(1). 10 CAMPUS PIC X(1). 10 DEPARTMENT PIC X(4). 10 COURSE-NUM PIC X(3). 10 SECTION-NO PIC X(2). 10 LEC-LAB PIC X(1). 05 FLAT-CONTRACT-AMT PIC S9(6)V99 COMP-3. 05 MULTI-MEET-INCLUSION PIC X. 05 FILLER PIC X(19). 3.6 PERPAYRL SEGMENT NOTE: THE DATA ELEMENTS INDICATED AS 'CIPPS' ARE FOR FUTURE ENHANCEMENT BY TCC. 05 PAYROLL-KEY. 10 BUDGET-YEAR. 15 BEG-BUDGET-YEAR PIC X(2). 15 END-BUDGET-YEAR PIC X(2). 10 PAY-PERIOD-DATE. 15 PAY-PERIOD-YEAR PIC X(2). 15 PAY-PERIOD-MONTH PIC X(2). 15 PAY-PERIOD-DAY PIC X(2). 10 CAMPUS-DEPT. 15 CAMPUS-DEPT-CAMP PIC X(1). 15 CAMPUS-DEPT-NO PIC X(3). 10 PAYROLL-TYPE PIC X(1). 05 HOURS-WORKED PIC S9(3)V99 COMP-3. 05 HOURLY-RATE-AUTH PIC S9(3)V99 COMP-3. 05 END-PERIOD-DATE. 10 END-PERIOD-YEAR PIC X(2). 10 END-PERIOD-MONTH PIC X(2). 10 END-PERIOD-DAY PIC X(2). 05 CIPPS-EQUIV-DATA. 10 CIPPS-PAYROLL PIC X(3). 10 CIPPS-DISTRIBUTION. 15 CIPPS-PERCENT PIC S9V99 COMP-3. 15 CIPPS-GRO-PAY PIC S9(5)V99 COMP-3. 15 CIPPS-RETIRE. 20 CIPPS-PEN-CODE PIC X(2). 20 CIPPS-RETIRE16-AMT PIC S9(5)V99 COMP-3. 15 CIPPS-PAY-TYPE PIC X(2). 15 CIPPS-SOC-SEC-AMT PIC S9(5)V99 COMP-3. 15 CIPPS-GROUP-INS-AMT PIC S9(5)V99 COMP-3. 15 CIPPS-HEALTH-INS-AMT PIC S9(5)V99 COMP-3. 15 CIPPS-COST-CODE PIC X(3). 15 CIPPS-FUND PIC X(4). 15 CIPPS-PROG PIC X(3). 15 CIPPS-SUBPGM PIC X(2). 15 CIPPS-ELEMENT PIC X(2). 15 CIPPS-PROJECT PIC X(5). 15 CIPPS-OBJECT PIC X(4). 10 CIPPS-VOUCHER-NO PIC X(8). 10 CIPPS-PAY-PERIOD-ENDING. 15 CIPPS-END-MO PIC X(2). 15 CIPPS-END-DAY PIC X(2). 15 CIPPS-END-YR PIC X(2). 10 CIPPS-AGY-USE. 15 CIPPS-AGY-USE-APPRO PIC X(2). 15 CIPPS-AGY-USE-CAMPUS PIC X(1). 15 CIPPS-AGY-USE-DEPT PIC X(3). 10 CIPPS-NEGATIVE-FLAG PIC X(1). 10 CIPPS-CUR-PAYTYPE-FICA PIC X(1). 10 CIPPS-RETIRE14-AMT PIC S9(5)V99 COMP-3. 10 CIPPS-RETIRE15-AMT PIC S9(5)V99 COMP-3. 05 PERPAYRL-DBD-FILLER PIC X(24). 05 PERPAYRL-COPY-FILLER PIC X(20). 4.0 PROGRAM ABSTRACTS ----------------- ONLINE PROGRAMS ---------------------- LVE010 - PERSONNEL LEAVE UPDATE LVE020 - UPDATE TERM DATES FOR CONTINGENCY LEAVE LVE030 - FUTURE LEAVE REQUESTED LVE110 - PERSONNEL LEAVE INQUIRY BATCH UPDATE PROGRAMS --------------------- LVE300 - PERSONNEL DAILY UPDATE LVE305 - BI-MONTHLY LEAVE RECORD REPORT LVE310 - PERSONNEL LEAVE DELETION BATCH REPORT PROGRAMS --------------------- LVE500 - ANNUAL LEAVE FORFEIT SUMMARY LVE510 - QUARTERLY LEAVE MEMO LVE515 - EXCESS ANNUAL LEAVE MEMO LVE520 - LEAVE SUMMARY REPORT LVE525 - COMP-TIME SEMI-MONTHLY REPORT. LVE530 - COMP. TIME LEAVE MEMO LVE535 - LEAVE BALANCE DETAIL REPORT AND ERROR REPORT LVE540 - PERCENTAGE HOURS NOT WORKED LVE550 - LEAVE LIABILITY REPORT LVE560 - EMPLOYEE LEAVE STATUS REPORT LVE565 - LEAVE TAKEN SUMMARY REPORT LVE810 - EMPLOYEE LEAVE SUMMARIES 5.0 IMPLEMENTATION PROCEDURES ------------------------- THE FOLLOWING PROCEDURES MAY BE USED AS A GUIDELINE FOR PREPARING TO IMPLEMENT THE LEAVE ACCOUNTING SUBSYSTEM. THE DOCUMENTATION FOR THE PERSONNEL SUBSYSTEM SHOULD BE CONSULTED AND THOSE STEPS COMPLETED, PRIOR TO ATTEMPTING TO USE THE LEAVE ACCOUNTING SYSTEM. 1. INPUT THE SUBSYSTEM PROGRAM OPTION SEGMENTS VIA REF070. THESE RECORDS ARE VITAL TO THE CORRECT OPERATION OF THE PROGRAMS. THEY ARE OUTLINED IN DETAIL BELOW. ADDITIONALLY, CONSULT EACH PROGRAM DOCUMENTATION FOR THE REQUIRED OPTIONS, BEFORE ATTEMPTING TO RUN THEM. 2. REVIEW THE PERSONNEL DATA TO ENSURE THE CLASS CODES, COLLEGE AND STATE DATES, AND YEARS ARE CORRECT. 5.1 CONTENTS OF SYSTEM PROGRAM OPTION(S) ------------------------------------ LVES01 RECORD YY (WHERE YY IS THE CURRENT YEAR) ---------------- FIELD FIELD POS. CONTENTS ------------------------------------------------------------------ ] 01 - 24 ] BI-MONTHLY LEAVE FLAGS ] ] ] INITIALLY SET TO 0, LVE305 UPDATES TO 1 TO ] ] ] INDICATE LEAVE HAS BEEN BALANCED FOR PERIOD ] ]---------------]------------------------------------------------] ] 25 - 30 ] DATE LAST UPDATED - LVE300 UPDATES EACH RUN TO ] ] ] CURRENT DATE ] ]---------------]------------------------------------------------] ] 31 - 31 ] MILITARY FLAG - LVE300 UPDATES FROM 0 TO 1 ] ] ] IN SEPTEMBER ] ]---------------]------------------------------------------------] ] 32 - 35 ] HOLIDAY #1 FOR CURRENT YEAR IN MMDD FORMAT ] ]---------------]------------------------------------------------] ] 36 - 39 ] HOLIDAY #2 FOR CURRENT YEAR IN MMDD FORMAT ] ]---------------]------------------------------------------------] ] 40 - 43 ] HOLIDAY #3 FOR CURRENT YEAR IN MMDD FORMAT ] ]---------------]------------------------------------------------] ] 44 - 47 ] HOLIDAY #4 FOR CURRENT YEAR IN MMDD FORMAT ] ]---------------]------------------------------------------------] ] 48 - 51 ] HOLIDAY #5 FOR CURRENT YEAR IN MMDD FORMAT ] ]---------------]------------------------------------------------] ] 52 - 55 ] HOLIDAY #6 FOR CURRENT YEAR IN MMDD FORMAT ] ]---------------]------------------------------------------------] ] 56 - 59 ] HOLIDAY #7 FOR CURRENT YEAR IN MMDD FORMAT ] ]---------------]------------------------------------------------] ] 60 - 63 ] HOLIDAY #8 FOR CURRENT YEAR IN MMDD FORMAT ] ]---------------]------------------------------------------------] ] 64 - 67 ] HOLIDAY #9 FOR CURRENT YEAR IN MMDD FORMAT ] ]---------------]------------------------------------------------] ] 68 - 71 ] HOLIDAY #10 FOR CURRENT YEAR IN MMDD FORMAT ] ]---------------]------------------------------------------------] ] 72 - 75 ] HOLIDAY #11 FOR CURRENT YEAR IN MMDD FORMAT ] ]---------------]------------------------------------------------] ] 76 - 79 ] HOLIDAY #12 FOR CURRENT YEAR IN MMDD FORMAT ] ]---------------]------------------------------------------------] ] 80 ] DELETE-EXCESS-LVE-FLAG ] ]---------------]------------------------------------------------] LVES02 RECORD 01 ---------------- FIELD FIELD POS. CONTENTS ------------------------------------------------------------------ ] 01 - 06 ] CURRENT YEAR FALL TERM BEGIN DATE YYMMDD FORMAT] ]---------------]------------------------------------------------] ] 07 - 12 ] CURRENT YEAR FALL TERM END DATE YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 13 - 18 ] CURRENT YEAR SUMMER BEGIN DATE YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 19 - 24 ] CURRENT YEAR SUMMER END DATE YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 25 - 30 ] CURRENT YEAR SPRING BEGIN DATE YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 31 - 36 ] CURRENT YEAR SPRING END DATE YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 37 - 37 ] FALL BEGIN FLAG - CONTROLS ADDITION OF FACULTY ] ] ] SICK LEAVE FOR FALL TERM. SHOULD BE SET TO 0 ] ] ] IF TERM HAS NOT STARTED. LVE300 WILL UPDATE TO] ] ] 1 WHEN RUN AFTER DATE IN FALL BEGIN DATE. ] ]---------------]------------------------------------------------] ] 38 - 38 ] FALL END FLAG - INDICATES COMPLETED TERM. IT ] ] ] SHOULD BE SET TO 0 WHEN TERM HAS NOT ENDED. ] ] ] LVE300 WILL UPDATE TO 1 WHEN RUN AFTER THE ] ] ] DATE IN FALL END DATE. ] ]---------------]------------------------------------------------] ] 39 - 39 ] SUMMER BEGIN FLAG- CONTROLS ADDITION OF FACULTY] ] ] SICK LEAVE FOR THE TERM. SHOULD BE SET TO 0 ] ] ] IF TERM HAS NOT STARTED. LVE300 WILL UPDATE TO] ] ] 1 WHEN RUN AFTER DATE IN SUMMER BEGIN DATE. ] ]---------------]------------------------------------------------] ] 40 - 40 ] SUMMER END FLAG - INDICATES COMPLETED TERM. IT ] ] ] SHOULD BE SET TO 0 WHEN TERM HAS NOT ENDED. ] ] ] LVE300 WILL UPDATE TO 1 WHEN RUN AFTER THE ] ] ] DATE IN SUMMER END DATE. ] ]---------------]------------------------------------------------] ] 41 - 41 ] SPRING BEGIN FLAG- CONTROLS ADDITION OF FACULTY] ] ] SICK LEAVE FOR THE TERM. SHOULD BE SET TO 0 ] ] ] IF TERM HAS NOT STARTED. LVE300 WILL UPDATE TO] ] ] 1 WHEN RUN AFTER DATE IN SPRING BEGIN DATE. ] ]---------------]------------------------------------------------] ] 42 - 42 ] SPRING END FLAG - INDICATES COMPLETED TERM. IT ] ] ] SHOULD BE SET TO 0 WHEN TERM HAS NOT ENDED. ] ] ] LVE300 WILL UPDATE TO 1 WHEN RUN AFTER THE ] ] ] DATE IN SPRING END DATE. ] ]---------------]------------------------------------------------] ] 43 - 46 ] ACADEMIC YEARS (E.G. 8788) ] ]---------------]------------------------------------------------] ] 47 - 52 ] PREVIOUS YEAR FALL BEGIN DATE IN YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 53 - 58 ] PREVIOUS YEAR FALL END DATE IN YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 59 - 64 ] PREVIOUS YEAR SUMMER BEGIN DATE YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 65 - 70 ] PREVIOUS YEAR SUMMER END DATE YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 71 - 76 ] PREVIOUS YEAR SPRING BEGIN DATE YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 77 - 82 ] PREVIOUS YEAR SPRING END DATE YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 83 - 86 ] PREVIOUS ACADEMIC YEAR (E.G. 8687) ] ------------------------------------------------------------------ LVES03 RECORD 01 ---------------- FIELD FIELD POS. CONTENTS ------------------------------------------------------------------ ] 01 - 06 ] BEGINNING TIMESHEET DATE IN YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 07 - 12 ] ENDING TIMESHEET DATE IN YYMMDD FORMAT ] ]---------------]------------------------------------------------] ] 13 - 16 ] MAXIMUM OVERTIME LEAVE (E.G. 4200 = 42.00) ] ------------------------------------------------------------------ 8.0 DOCUMENTATION CHANGE HISTORY: ----------------------------- 8.1 VERSION NO: V3.10 CHANGE DATE: 5/88 PROGRAMMER NAME: SUE DOTSON PROGRAM CHANGE REQUEST NO: N/A DESCRIPTION OF CHANGE: RELEASE VERSION 8.2 VERSION NO: V4.1 CHANGE DATE: 3/89 PROGRAMMER NAME: DIANE LIVELY PROGRAM CHANGE REQUEST NO: 00002092 DESCRIPTION OF CHANGE: DOCUMENTED LATEST ENHANCEMENTS AND DATA BASE CHANGE. 8.3 VERSION NO: V4.9 CHANGE DATE: 12/89 PROGRAMMER NAME: S. EDMONDS PROGRAM CHANGE REQUEST NO: 00004497 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION BY ADDING THE PROGRAM LVE560 TO THE 4.0 PROGRAM ABSTRACTS SECTION. 8.4 VERSION NO: V4.12 CHANGE DATE: 04/90 PROGRAMMER NAME: DIANE LVELY PROGRAM CHANGE REQUEST NO: 00004625 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION BY ADDING A LIST OF LEAVE CODES WITH A DESCRIPTION AND APPLICABLE TYPES. 8.5 VERSION NO: V4.23 CHANGE DATE: 05/91 PROGRAMMER NAME: SUE DOTSON PROGRAM CHANGE REQUEST NO: 00007206 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION TO CORRECT DESCRIPTION OF LVES02 01 RECORD. ALSO UPDATED THE DATA BASE DES- CRIPTION AND PROGRAM ABSTRACTS. 8.6 VERSION NO: V4.28 CHANGE DATE: 11/15/91 PROGRAMMER NAME: DANA BRYANT PROGRAM CHANGE REQUEST NO: 8409 DESCRIPTION OF CHANGE: ADDED LVE565 AND LVE525 TO THE LIST OF BATCH REPORT PROGRAMS. 8.7 VERSION NO: V4.31 CHANGE DATE: 02/15/92 PROGRAMMER NAME: DANA BRYANT PROGRAM CHANGE REQUEST NO: 9393 DESCRIPTION OF CHANGE: CORRECTED THE FORMAT OF THE LVES01 YY RECORD. .