0.003/23/99 DIANE LIVELY 1.0 PROGRAM NARRATIVE: THIS ONLINE PROGRAM IS USED BY THE BUSINESS OFFICE TO DISPLAY AND UPDATE CEU CHARGE CARD RECORDS FOR VISA, MASTER CARD, OR DISCOVER. THIS IS THE SAME DATA THAT STUDENTS GIVE BY PHONE VIA A VOICE-RESPONSE UNIT (VRU) THAT USES THE CEU TOUCH-TONE REGISTRATION PROGRAM, TTR050. THE CHARGE CARD SEGMENT CONTAINS A CARD-TYPE INDICATOR ('M', 'V', OR 'D'), THE CARD NUMBER, EXPIRATION DATE, ADDRESS VERIFICATION FIELDS FOR THE BILLING ADDRESS OF THE CARD, TERM, A DATE AND TIME STAMP, AND THE CLASS FOR WHICH THE CARD IS PAYING. IT RESIDES IN THE CEU STUDENT DATA BASE (CSTCCARD). THERE IS AN OPTION TO SPECIFY WHETHER AVS FIELDS ARE TO BE ENTERED. THE ADDRESS CODE CONTAINS THE NUMBERS RESIDING WITHIN THE BILLING ADDRESS, WHICH CAN BE FROM ZERO TO FIVE NUMBERS. INITIAL INPUT INCLUDES THE STUDENT'S SOCIAL SECURITY NUMBER AND TERM. THE TERM WILL DEFAULT FROM THE MAIN MENU. THE PROGRAM WILL THEN DISPLAY THE STUDENT'S NAME AND ADDRESS, AND UP TO 12 CHARGE CARD RECORDS FOR THE TERM. A CHARGE CARD RECORD EXISTS FOR EACH CLASS FOR WHICH THE STUDENT WANTS TO PAY BY CHARGE CARD. THE TUITION WILL BE SHOWN IF THE STUDENT IS CURRENTLY ENROLLED, WHICH IS COMPUTED BY ADDING THE TUITION RATE, MISCELLANEOUS FEE, AND LAB FEE STORED IN THE CEU REGISTRATION SEGMENT. 'NOT ENR' IS SHOWN FOR THE TUITION FOR CLASSES THAT HAVE BEEN DROPPED. TO ADD, UPDATE, OR DELETE A RECORD, ENTER A TRANSACTION CODE OF 'A', 'U', OR 'D' WITH THE CLASS ID FOR WHICH THE CARD IS ASSOCIATED. TO ADD OR UPDATE, ENTER THE CHARGE CARD NUMBER (MAXIMUM OF 16 CHARACTERS), AND AN EXPIRATION DATE IN THE FORMAT OF MONTH AND YEAR. IT IS NOT NECESSARY TO ENTER THE CARD DATA WHEN DELETING. WHEN ADDING OR UPDATING, THE EXPIRATION DATE CANNOT BE PRIOR TO THE CURRENT MONTH AND YEAR AND THE STUDENT MUST BE ENROLLED IN THE CLASS. THE CHARGE CARD NUMBER WILL BE EDITED TO ENSURE THAT EITHER 13 OR 16 CHARACTERS ARE INPUT. THE FIRST DIGIT MUST BE A '4' FOR VISA, '5' FOR MASTERCARD, OR '6' FOR DISCOVER. THE NUMBER WILL ALSO BE EDITED USING A MODULAR 10 CHECK DIGIT ROUTINE FOR VISA AND MASTERCARD TO DETERMINE THAT THE NUMBER IS 'REASONABLE'. AS OF APRIL 1996, TWO OTHER FIELDS MAY BE REQUIRED TO BE ENTERED. THESE FIELDS ARE ADDRESS CODE, WHICH CONTAINS UP TO FIVE NUMBERS RESIDING WITHIN THE BILLING ADDRESS FOR THE CARD, AND ZIPCODE. THERE IS A PROGRAM OPTION TO DETERMINE WHETHER THE FIELDS ARE REQUIRED. IF THERE ARE NO NUMBERS IN THE BILLING ADDRESS, THE ADDRESS CODE WILL BE SPACES. 2.0 USER OPERATING INSTRUCTIONS: 1. KEY IN THE STUDENT'S SOCIAL SECURITY NUMBER AND TERM. PRESS ENTER. 2. THE PROGRAM WILL READ THE CEU STUDENT DATA BASE FOR THE SOCIAL SECURITY NUMBER ENTERED AND DISPLAY THE CHARGE CARD DATA FOR THE TERM (IF FOUND). 3. ENTER A TRANSACTION CODE OF 'A' TO ADD, 'U' TO UPDATE, OR 'D' TO DELETE. KEY THE CLASS ID. WHEN ADDING OR UPDATING, KEY THE CARD NUMBER AND EXPIRATION DATE. PRESS ENTER. 4. THE PROGRAM WILL EDIT THE DATA ON THE SCREEN FOR VALIDITY. FIELDS IN ERROR WILL BE HIGHLIGHTED WITH THE CURSOR POSITIONED AT THE FIRST ERROR. AN ERROR MESSAGE WILL BE DISPLAYED AT THE BOTTOM OF THE SCREEN. 5. IF DATA IS CORRECT, THE UPDATE WILL OCCUR. 6. RETURN TO STEP 1 TO PROCESS ANOTHER STUDENT OR KEY IN A VALID TRANSACTION NUMBER OR 'REC ' IN THE TRANSACTION NUMBER FIELD TO EXIT THE SCREEN. 3.0 SCREEN LAYOUT: --------------------------------------------------------------------- TRANS. NO. REC110 LT: :::::::: ::::::::::::::::::::::::: CEU CHARGE CARD UPDATE KEY SOCIAL SECURITY AND PRESS ENTER. KEY TRANSACTION OR ENTER NEW TRAN NO TO END. SOCIAL SECURITY TERM YR ___ - __ - ____ ______ __ ::::::::::::NAME:::::::::: ::::::::::ADDR::::::::: :::::::CITY:::::: :: ::::: TRN -------CLASS ID------ EXPIR ADDR ZIP CDE DEPT CRS SEC CMP LAB CARD NUMBER MO/YR CODE CODE TUITION _ ____ ___ __ _ _ ________________ ____ _____ _____ :::: ::: :: : :::::::::::::::: :::: ::::: ::::: ::::.:: :::: ::: :: : :::::::::::::::: :::: ::::: ::::: ::::.:: :::: ::: :: : :::::::::::::::: :::: ::::: ::::: ::::.:: :::: ::: :: : :::::::::::::::: :::: ::::: ::::: ::::.:: :::: ::: :: : :::::::::::::::: :::: ::::: ::::: ::::.:: :::: ::: :: : :::::::::::::::: :::: ::::: ::::: ::::.:: :::: ::: :: : :::::::::::::::: :::: ::::: ::::: ::::.:: :::: ::: :: : :::::::::::::::: :::: ::::: ::::: ::::.:: :::: ::: :: : :::::::::::::::: :::: ::::: ::::: ::::.:: :::: ::: :: : :::::::::::::::: :::: ::::: ::::: ::::.:: :::: ::: :: : :::::::::::::::: :::: ::::: ::::: ::::.:: :::: ::: :: : :::::::::::::::: :::: ::::: ::::: ::::.:: ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: -------------------------------------------------------------------- 4.0 FILES: 4.1 DATA BASES USED: CONTROL DATA BASE 1. TERM CONTROL SEGMENT 2. CAMPUS SEGMENT CEU STUDENT DATA BASE 1. CEU STUDENT MASTER SEGMENT 2. CEU STUDENT REGISTRATION SEGMENT 3. CEU CHARGE CARD SEGMENT --UPDATE-- CEU COURSE DATA BASE 1. CEU COURSE SEGMENT 4.2 ADDITIONAL FILES USED: NONE 4.3 INPUT/OUTPUT RECORD LAYOUTS: N/A 5.0 SPECIAL FEATURES: 5.1 CALLING PROGRAMS: MST000 5.2 SUBPROGRAMS CALLED: UTL100 5.3 MESSAGE SEGMENT CODES: NONE 5.4 SPECIAL MESSAGES: 1. "SOCIAL SECURITY MUST BE NUMERIC...CORRECT AND RE-ENTER" 2. "SOCIAL SECURITY CANNOT BE BLANK...CORRECT AND RE-ENTER" 3. "SOCIAL SECURITY NOT FOUND IN DATA BASE...CORRECT AND RE-ENTER" 4. "TERM MUST BE FALL, SPRING, OR SUMMER...CORRECT AND RE- ENTER" 5. "YEAR MUST BE NUMERIC" 6. "INVALID TERM...CORRECT AND RE-ENTER" THE TERM ENTERED WAS NOT FOUND IN THE CONTROL DATA BASE. 7. "DATA SHOWN...ENTER UPDATE TRANSACTION" 8. "NO DATA FOUND FOR TERM...ENTER TRANSACTION TO ADD" 9. "DEPARTMENT CANNOT BE SPACES...CORRECT AND RE-ENTER" A VALID CLASS ID MUST BE ENTERED. 10. "COURSE NUM CANNOT BE SPACES...CORRECT AND RE-ENTER" A VALID CLASS ID MUST BE ENTERED. 11. "COURSE NOT ON MASTER FILE...CORRECT AND RE-ENTER" A VALID CLASS ID MUST BE ENTERED. 12. "LAB IS INVALID...CORRECT AND RE-ENTER" A VALID CLASS ID MUST BE ENTERED. LAB MUST BE 'L' OR SPACE. 13. "CAMPUS IS INVALID...CORRECT AND RE-ENTER" A VALID CAMPUS MUST BE ENTERED OR LET IT DEFAULT. 14. "NO CHANGES DETECTED" 15. "CREDIT CARD NUMBER MUST BE NUMERIC" 16. "THE CARD NUMBER ENTERED IS NOT VALID" THE CHARGE CARD NUMBER DID NOT BEGIN WITH '4', '5' OR '6' OR DID NOT PASS THE STANDARD MODULAR 10 CHECK DIGIT ROUTINE. 17. "CARD NUMBER ENTERED DOES NOT CONTAIN THE CORRECT NUMBER OF DIGITS' THE CREDIT CARD WAS NOT 13 OR 16 DIGITS IN LENGTH. 18. "CREDIT CARD EXPIRATION DATE MUST BE NUMERIC" 19. "INVALID EXPIRATION MONTH...CORRECT AND RE-ENTER" THE MONTH WAS NOT IN THE RANGE OF '01' - '12'. 20. "CREDIT CARD HAS EXPIRED" THE EXPIRATION MONTH AND YEAR IS PRIOR TO THE CURRENT MONTH AND YEAR. 21. "MUST BE NUMERIC OR BLANK WITH NO EMBEDDED SPACES" THE ADDRESS CODE IS INVALID. 22. "PLEASE ENTER "A" TO ADD, "U" TO UPDATE, OR "D" TO DELETE" A CHARACTER OTHER THAN 'A', 'U' OR 'D' WAS ENTERED FOR THE TRANSACTION CODE. 23. "CREDIT CARD DATA ALREADY ON FILE...CANNOT ADD" A TRAN CODE OF 'A' WAS ENTERED, BUT A RECORD ALREADY EXISTS FOR THAT CLASS. 24. "INVALID TRAN CODE...CARD DATA NOT ON FILE FOR THIS CLASS" A TRAN CODE OF 'U' OR 'D' WAS ENTERED, BUT NO RECORD EXISTS FOR THAT CLASS. 25. "NOT REGISTERED FOR CLASS...CANNOT ADD/UPDATE" A TRAN CODE OF 'A' OR 'U' WAS ENTERED, BUT THE STUDENT DOES NOT OWE FOR THIS CLASS. 26. "CARD WAS ADDED BY ANOTHER USER WHILE YOU WERE ENTERING DATA" 27. "VISA CARD # XXXXXXXXXXXXXXXX SUCCESSFULLY DELETED" "MASTER CARD # XXXXXXXXXXXXXXXX SUCCESSFULLY DELETED" "DISCOVER CARD # XXXXXXXXXXXXXXXX SUCCESSFULLY DELETED" 28. "VISA CARD # XXXXXXXXXXXXXXXX SUCCESSFULLY ADDED" "MASTER CARD # XXXXXXXXXXXXXXXX SUCCESSFULLY ADDED" "DISCOVER CARD # XXXXXXXXXXXXXXXX SUCCESSFULLY ADDED" 28. "VISA CARD # XXXXXXXXXXXXXXXX SUCCESSFULLY UPDATED" "MASTER CARD # XXXXXXXXXXXXXXXX SUCCESSFULLY UPDATED" "DISCOVER CARD # XXXXXXXXXXXXXXXXX SUCCESSFULLY UPDATED" 6.0 PROGRAM OPTIONS: REC110 - 01 --------------- FIELD POS ] FIELD DESCRIPTION ]VALUE] PROCESSING DESCRIPTION ______]___________________]_____]________________________________ 01 ] REQUIRE AVS FIELDS] Y ] REQUIRE THE USER TO ENTER ] ] ] ADDRESS VERIFICATION FIELDS. ] ] ] ] ]NOT Y] DO NOT REQUIRE AVS FIELDS, BUT ] ]DEFAULT EDIT IF ENTERED TO BE NUMERIC. ] ] ] 02 ] MAXIMUM EXP YEAR ]1-9 ] MAXIMUM NUMBER OF YEARS IN THE ] ] ] FUTURE FOR EDITING CHARGE CARD ] ] ] EXPIRATION DATE. 5 IS DEFAULT. 7.0 PROGRAM CHANGE HISTORY: 7.1 VERSION : V5.20 CHANGE DATE : 01/15/95 PROGRAMMER : DIANE LIVELY CHANGE REQUEST #: 00015087 DESCRIPTION : NEW PROGRAM. 7.2 VERSION : V6.03 CHANGE DATE : 04/30/96 PROGRAMMER : DIANE LIVELY CHANGE REQUEST #: 00016769 (PARENT 16761) DESCRIPTION : CHANGED MAP AND PROGRAM TO ADD AVS-ADDRESS- CODE AND AVS-ZIP-CODE TO SCREEN FOR UPDATE. ADDED A NEW PROGRAM OPTION SEGMENT TO SPECIFY WHETHER AVS FIELDS ARE REQUIRED. 7.3 VERSION : V7.00 CHANGE DATE : 12/19/97 PROGRAMMER : DIANE LIVELY CHANGE REQUEST #: 00017886 DESCRIPTION : CHANGED THE PROGRAM TO WORK FOR CREDIT CARD EXPIRATION DATES IN THE NEXT CENTURY. 7.4 VERSION : V7.02 CHANGE DATE : 03/23/99 PROGRAMMER : DIANE LIVELY CHANGE REQUEST #: NONE DESCRIPTION CHANGED PROGRAM FOR Y2K AND NEW COMPILER. PROGRAM NOW CALLS UTL100S FOR CURRENT DATE. CHANGED EDIT ON EXPIRATION DATE TO ALLOW USER TO SPECIFY NUMBER OF YEARS IN THE FUTURE.