0.002/01/98 ANDREW HASLETT 1.0 INTRODUCTION: THE STUDENTS ACCOUNTS RECEIVABLE SUBSYSTEM IS DESIGNED TO PRO- CESS STUDENTS THROUGH THE SCHOOL'S BUSINESS OFFICE. THIS SYS- TEM WILL USE EXISTING SEGMENTS ON THE STUDENT DATA BASE, THE REGISTRATION DETAIL, ACCOUNT DETAIL, AND OBLIGATION DETAIL; AS WELL AS THE ACCOUNTS RECEIVABLE DATA BASE. THE CLASS MASTER SEGMENT OF THE CLASS DATA BASE, AND THE QUARTER SEGMENT OF THE CONTROL DATA BASE ALSO CONTAIN NECESSARY INFORMATION FOR USING THE ACCOUNTS RECEIVABLE SUBSYSTEM (I.E., LAB FEES AND TUITION RATES, RESPECTIVELY). THE ACCOUNT DETAIL SEGMENT HAS CLASS-ID-FLAG AND CLASS-ID-DE- SCRIPTION FIELDS WHICH ARE USED TO FURTHER DESCRIBE THE ACCOUNT DETAIL. THE CLASS-ID-FLAG WILL BE CODED AS "C" WHEN THE DATA IN THE CLASS-ID-DESCRIPTION IS A CLASS-ID, AND A "D" WHEN THE DATA IN THE CLASS-ID-DESCRIPTION IS A DESCRIPTION. THE SITUA- TIONS THAT WILL BE ENCOUNTERED TO USE THE "D" CODE ARE PAYMENTS MADE FOR FEES AND WHEN AN OBLIGATION IS PAID. THE FEE NAME AS FOUND ON THE REVENUE CODE SEGMENT CORRESPONDING TO THE FEE FOR THE TERM IS PLACED IN THE CLASS-ID-DESCRIPTION FIELD FOR FEES. THE OBLIGATION CODE, INVOICE DATE AND INVOICE NUMBER IS PLACED IN THIS FIELD FOR OBLIGATION PAYMENTS. FOR ALL CLASS PAYMENTS, THE CLASS-ID-DESCRIPTION CONTAINS THE CLASS-ID OF THE CLASS BEING PAID. THE OBJECTIVE OF THE NEW SYSTEM IS TO PERFORM THE FOLLOWING FUNCTIONS AS FAST, EFFECTIVELY AND EFFICIENTLY AS POSSIBLE: 1. PRODUCE R&I FORMS FROM THE CRT 2. DETERMINE AMOUNT OWED (BILL AND REFUND) 3. ACCEPT PARTIAL PAYMENT FOR CLASSES 4. PROVIDE TOTALS FOR BUSINESS OFFICE, CASH REGISTER TOTALS FOR DEPOSIT 5. BILL A THIRD PARTY BY CLASS 6. BACKOUT STUDENTS BY CLASS 7. PRODUCE REFUND REPORTS FOR THE STATE 8. PROCESS STUDENT OBLIGATIONS, BILLING & COLLECTIONS 9. ONLINE UPDATE AND INQUIRY BY ACCOUNT CODE * 2.0 SYSTEM NARRATIVE: WHEN A STUDENT REGISTERS FOR A CLASS, A RECORD IS CREATED IN THE REGISTRATION SEGMENT. WHEN A STUDENT PAYS FOR A CLASS, AN ACCOUNT DETAIL SEGMENT IS CREATED WITH REGISTER NUMBER, VALIDATION NUMBER AND OTHER NECESSARY FIELDS TO MAINTAIN AN AUDIT TRAIL FOR EACH PAYMENT A STUDENT MAKES. ALL NON-BILLABLE PAYMENTS ARE DESIGNATED WITH A "P" IN THE DEBIT-CREDIT FIELD OF THE ACCOUNT DETAIL AND ALL CLASSES CHARGED TO A THIRD PARTY ARE DESIGNATED WITH A "C" IN THE DE- BIT-CREDIT FIELD. THE ACCOUNT STUDENT SEGMENT IS CREATED FOR EACH STUDENT UNDER THAT PARTICULAR ACCOUNT CODE. THE ABILITY TO REAPPLY FUNDS FROM DROPPED CLASSES TO UNPAID REGISTERED CLASSES IS PROVIDED, AS WELL AS THE ABILITY TO ISSUE REFUNDS TO THE PAYING PARTY FOR DROPPED CLASSES. WHEN THE ACCOUNTS ARE BILLED, THE ACCOUNT MASTER IS READ, AND IF THERE ARE ACCOUNT STUDENT SEGMENTS FOR THAT TERM THAT ARE NOT PAID FOR, INDICATED BY THE PAID CODE, THE SOCIAL SECURITY NUMBER OF THE STUDENT IS USED AS A KEY TO RETRIEVE THE REGIS- TRATION SEGMENTS SO THE ACCOUNT MAY BE BILLED INDICATING THE CLASSES CHARGED TO THAT ACCOUNT. * 2.1 SYSTEM FLOW THE PROGRAMS IN THE ACCOUNTS RECEIVABLE SUBSYSTEM DO NOT NECES- SARILY FLOW FROM ONE TO THE OTHER BUT THE TIMES DURING THE QUARTER AT WHICH EACH ARE USED CAN BEST BE DESCRIBED BY THE TIME LINE BELOW. THESE ARE GENERAL GUIDLINES AND THE SYSTEM IS FLEXIBLE ENOUGH TO ALLOW SOME ALTERATIONS IN THE SCHEDULE LISTED WITH THE EXCEPTION OF THE PROGRAMS MARKED WITH "*"'S WHICH SHOULD BE RUN AT THE TIMES STATED. TIME LINE ] BEFORE] EARLY ] REG. ] ADD/ ] TERM] ] E. REG] REGIS ] REGIS ] DROP ] END] PROGRAM ]-------]--------]-------]-------]--------]----- ------- ] ] ] ] ] ] REC010 ]<----->] ] ] ] ] **REC011 ] SEE NOTE BELOW ] ] ] ] REC020 ] ] ] ] <---+--------+-----> REC025 ] ] ] ] * ] REC030 ] ]<-------+-------+-------+--------+-----> REC031 <--------+--------+-------+-------+--------+-----> REC040 ] ]<-------+-------+------>] ] REC060 <--------+--------+-------+-------+--------+-----> REC061 <--------+--------+-------+-------+--------+-----> REC300 ] ] ] ] ] ]<----> REC301 ] ] ] ] ] ]<----> REC310 ] ] ]<------+-------+-> ] REC320 ] ] ]<------+-------+-> ] REC321 ] ] ] ] ]<--> ] REC340 ] ] ] ] ]<-------+-----> REC350 ] ] ] ] ] ] REC360 ] ] ] ] ] ] REC380 ] ]<-------+-------+-------+--------+-----> REC500 * ] ] ] ] ] REC510 ] ] ] ] ]<-------+-----> REC540 ] ] * ] ] ] REC590 ] ]<-------+-------+------>] ] REC595 ] ] ] ] ]<-------+-----> REC710 ] ] ] ] ]<-------+-----> REC740 ] ]<-------+-------+------>] ] REC750 ] ] ] ] ]<-------+-----> REC760 ] ] ] ] ] ]* REC780 ]<------+--------+-------+-------+--------+-----> REC790 ] ] ] ] ]<-------+-----> REC810 ] ]<-------+-------+-------+--------+-----> REC815 ] ] ] ] ] ] REC820 ]<------+--------+-------+-------+--------+-----> REC830 ] ]<-------+-------+-------+--------+-----> REC850 ]<------+--------+-------+-------+--------+-----> REC860 ] ] ] ] ] ] **REC011 - THIS PROGRAM UPDATES THE ACCOUNT FISCAL SEGMENT AND IS NOT 'TIMED' BY ACADEMIC TERM BUT RATHER BY FISCAL QUARTER. THIS PROGRAM IS MOST LIKELY TO BE USED AFTER THE END OF ANY FISCAL QUARTER. FISCAL QUARTERS ARE DEFINED AS: FIRST QUARTER - JULY 1 THRU SEPT. 30 SECOND QUARTER - OCT. 1 THRU DEC. 31 THIRD QUARTER - JAN. 1 THRU MARCH 31 FOURTH QUARTER - APRIL 1 THRU JUNE 30 * INDICATES SPECIFIC TIME(S) WITHIN TERM THAT PROGRAM IS MOST LIKELY TO BE RUN. * 3.0 DATA BASE DESIGN: ---------------- A C C O U N T S R E C E I V A B L E D A T A B A S E - - - - - - - - - - - - - - - - - - - - - - - - - - +---------+ ] ACCOUNT ] ] MASTER ] +----+----+ ] ] +-------------------+--------------------+ ] ] ] ] ] ] +----+----+ +---------+ +----+----+ ] ACCOUNT ] ] ACCOUNT ] ] ACCOUNT ] ] STUDENT ] ] FISCAL ] ] FEES ] +---------+ +---------+ +---------+ ACCOUNT MASTER SEGMENT ---------------------- ****************************************************************** * * * CREATED 04/02/84 AT JSRCC (V1.5) * * ONE ENTRY PER ACCOUNT * * INCLUDE THIS MEMBER (ACCTMSTR) AFTER YOUR 01 DATA NAME * * * * REVISED 04/28/87 AT ASC (V2.16) * * ADDED BILLING-TYPE PIC X(1). * * * * REVISED 01/11/89 AT ASC (V4.0) * * ADDED ACTIVE-INACTIVE PIC X(1). * * ADDED SIS-PAY-FLAG PIC X(1). * * ADDED CEU-PAY-FLAG PIC X(1). * * ADDED NST-PAY-FLAG PIC X(1). * * * * REVISED 08/15/89 AT ASC (V4.05) * * ADDED ACT-DEL-FLAG PIC X(1). * * * * REVISED 06/18/91 AT ASC (V4.27) * * EXPANDED SEGMENT LENGTH FROM 126 TO 143 BYTES * * DELETED ACTIVE-INACTIVE PIC X(1). * * ADDED FED-TAX-ID PIC X(10). * * ADDED ATB-CATEGORY PIC X(1). * * ADDED TERM-LAST-ACTIVE PIC X(3). * * INCREASED DBD FILLER TO 8 BYTES. * * * * REVISED 09/15/97 AT ASC (V6.13) * * ADDED STANDARD-INDUSTRY-CODE * * PIC X(04). * * ADDED OWNERSHIP-CODE PIC X(02). * * ADJUSTED FILLER PIC X(02). * * * ******* KEY FIELD ID: ACCOUNT-CODE ******* ******* SEGMENT KEY: ACCTCODE ******* ******* SEGMENT LENGTH: 143 BYTES ******* ******* COPY MEMBER LENGTH: 153 BYTES ******* ****************************************************************** * 05 ACCOUNT-CODE PIC X(4). 05 ACCOUNT-BALANCE PIC S9(7)V99 COMP-3. 05 ACCOUNT-GROUP PIC XX. 05 ACCOUNT-NAME PIC X(28). 05 ACCOUNT-NAME-ABBR PIC X(4). 05 ATTN-DEPT PIC X(22). 05 CITY PIC X(16). 05 PERCENT PIC XX. 05 STATE PIC XX. 05 STREET-ADDRESS PIC X(22). 05 ZIPCODE PIC X(9). 05 BILLING-TYPE PIC X(1). 05 ATB-CATEGORY PIC X(1). 05 SIS-PAY-FLAG PIC X(1). 05 CEU-PAY-FLAG PIC X(1). 05 NST-PAY-FLAG PIC X(1). 05 ACCT-DEL-FLAG PIC X(1). 05 FED-TAX-ID PIC X(10). 05 TERM-LAST-ACTIVE. 10 TERM-LSTACT-YY PIC X(2). 10 TERM-LSTACT-CD PIC X(1). 05 STANDARD-INDUSTRY-CLASS-CODE PIC X(4). 05 OWNERSHIP-CODE PIC X(2). 05 ACCTMSTR-DBD-FILLER PIC X(2). 05 ACCTMSTR-COPY-FILLER PIC X(10). * ACCOUNT STUDENT SEGMENT ----------------------- ****************************************************************** * * * CREATED 04/02/84 AT JSRCC (V1.5) * * ONE ENTRY PER STUDENT PER ACCOUNT CODE PER QUARTER * * INCLUDE THIS MEMBER (ACCTSTUD) AFTER YOUR 01 DATA NAME * * * * REVISED 01/11/89 AT ASC (V4.0) * * ADDED SIS-PAY-FLAG PIC X. * * ADDED CEU-PAY-FLAG PIC X. * * ADDED NST-PAY-FLAG PIC X. * * DELETED PAID-CODE PIC X. * * * ******* KEY FIELD ID: QTR-SSN-KEY ******* ******* SEGMENT KEY: QTRSSN ******* ******* SEGMENT LENGTH: 23 BYTES ******* ******* COPY MEMBER LENGTH: 23 BYTES ******* ****************************************************************** * 05 QTR-SSN-KEY. 10 QUARTER-ID. 15 QTR-YR PIC XX. 15 QTR-CODE PIC X. 10 SOCIAL-SECURITY PIC 9(9). 05 SIS-PAY-FLAG PIC X(1). 05 CEU-PAY-FLAG PIC X(1). 05 NST-PAY-FLAG PIC X(1). 05 ACCTSTUD-DBD-FILLER PIC X(8). ACCOUNT FISCAL SEGMENT ---------------------- ****************************************************************** * * * CREATED 06/18/91 AT ASC (V4.27) * * ONE ENTRY PER FISCAL YEAR PER ACCOUNT CODE * * INCLUDE THIS MEMBER (ACCTFSCL) AFTER YOUR 01 DATA NAME * * * ******* KEY FIELD ID: FISCAL-YR ******* ******* SEGMENT KEY: FISCALYR ******* ******* SEGMENT LENGTH: 125 BYTES ******* ******* COPY MEMBER LENGTH: 135 BYTES ******* ****************************************************************** * 05 FISCAL-YR. 10 BEGIN-YR PIC 99. 10 END-YR PIC 99. 05 QUARTER-BALANCE OCCURS 4 TIMES. 10 FISCAL-QTR PIC 9. 10 QTR-BALANCE PIC S9(7)V99 COMP-3. 10 WRITE-OFF-AMOUNT PIC S9(7)V99 COMP-3. 10 ALLOWANCE-AMOUNT PIC S9(7)V99 COMP-3. 10 FILLER PIC X(9). 05 DATE-CHANGED PIC 9(5) COMP-3. 05 PROGRAM-CODE PIC X(8). 05 ACCTFSCL-DBD-FILLER PIC X(10). 05 ACCTFSCL-COPY-FILLER PIC X(10). ACCOUNT FEES SEGMENT -------------------- ****************************************************************** * * * CREATED 02/97 AT ASC (V7.00) * * ONE ENTRY PER FEES REVENUE CODE THAT ACCOUNT WILL NOT * * PAY 100% FOR. PERCENT OF '00' INDICATES THAT ACCOUNT * * WILL NOT PAY ANY OF THIS TYPE OF FEE. * * * * INCLUDE THIS MEMBER (ACCTFEE) AFTER YOUR 01 DATA NAME * * * ******* KEY FIELD ID: ACCT-FEE-KEY ******* ******* SEGMENT KEY: FEEREVCD ******* ******* SEGMENT LENGTH: 20 BYTES ******* ******* COPY MEMBER LENGTH: 30 BYTES ******* ****************************************************************** * 05 ACCT-FEE-KEY. 10 ACCT-FEE-TERM. 15 ACCT-FEE-YR PIC X(02). 15 ACCT-FEE-CD PIC X(01). 10 FEE-REVENUE PIC X(03). 05 FEE-PERCENT PIC V99. 88 ACCT-DENIES-FEE-PAYMENT VALUE .00. 05 ACCTFEE-DBD-FILLER PIC X(12). 05 ACCTFEE-COPY-FILLER PIC X(10). * S T U D E N T D A T A B A S E - - - - - - - - - - - - - - - +---------+ ] STUDENT ] ] MASTER ] +----+----+ ] ] +-----------+--------------+------------+---------------ETC. ] ] ] ] ] ] ] ] +---+---+ +---+----+ +-----+----+ +----+----+ ] REGIS ] ] ACCOUNT] ]OBLIGATION] ] QUARTER ] ] DTL ] ] DTL ] ] DTL ] ] ] +-------+ +--------+ +----------+ +---------+ REGISTRATION SEGMENT -------------------- ***************************************************************** * * * REVISED 10/05/82 * * ONE ENTRY PER COURSE FOR WHICH STUDENT IS REGISTERED - * * USE THIS COPY MEMBER FOR STUREGIS AND STUHREGI SEGMENTS. * * * * * * N O T E N O T E * * * * ANY CHANGES MADE TO THIS COPY MEMBER SHOULD ALSO BE * * * * * * MADE TO 'STUDRPRG' AND 'DYLREGS'. * * * * * * * * INCLUDE THIS MEMBER(STUREGIS) AFTER YOUR 01 DATA NAME * * * * REVISED 1/6/84 AT TNCC * * ADDED SR-CIT-LATE-ADD AND DECREASED FILLER BY 1 * * * * REVISED 04/03/84 AT JSRCC (V1.5) * * ADDED ACCOUNT-CODE AND DECREASED FILLER BY 4 * * * * REVISED 11/29/84 AT JSRCC (V2.0) * * ADDED REPEATED-CLASS-FLAG AND DECREASED FILLER BY 1 * * * * REVISED 03/23/87 AT JSRCC (V2.15) * * ADDED TUITION-CODE AND DECREASED FILLER BY 1 * * ADDED GRADE-RECALCULATION AND DECREASED FILLER BY 1 * * * * REVISED 6/25/87 AT ASC (V3.0) * * CHANGED CREDITS FROM S9(2)V9 TO S9(2)V99 * * * * REVISED 8/16/88 AT ASC (V3.13) * * ADDED PASS-FAIL-CODE AND CROSS-REGISTRATION-FLAG * * AND DECREASED DBD-FILLER BY 2. * * * * REVISED 01/11/89 AT ASC (V4.0) * * EXPANDED SEGMENT FROM 43 TO 48 BYTES * * ADDED CREATION-DATE PIC 9(5) COMP-3 JULIAN * * * * REVISED 05/11/89 AT ASC (V4.2) * * ADDED MID-TERM-GRADE PIC X(1) * * AND DECREASED DBD-FILLER BY 1. * * * * REVISED 04/15/93 AT ASC (V5.0) * * EXPANDED SEGMENT FROM 48 TO 60 BYTES * * ADDED DOCUMENT-NUMBER GROUP ITEM 7 BYTES * * ADDED SEARCH FIELD NAMES TO COPY MEMBER (IN COMMENT FORM) * * SEARCH FIELDS ARE ONLY VALID FOR BATCH APPLICATIONS. * * * * REVISED 10/21/94 AT ASC (V5.18) * * ADDED GPA-REPEAT-FLAG, DECREASED DBD-FILLER BY 1. * * * * REVISED 06/16/95 AT ASC (V6.00) * * EXPANDED SEGMENT FROM 60 TO 90 BYTES * * CHANGED CREATION-DATE TO STUREGIS-DBD-FILL01 X(3) * * ADDED UPDATE-DATE 9(7) C-3 (CCYYDDD) * * ADDED TIME-STAMP 9(6) C-3 (HHMMSS) * * ADDED LTERM-ID X(8) * * ADDED PROGRAM-CODE X(8) * * ADDED USER-ID X(8) * * CHANGED STUREGIS-DBD-FILLER TO STUREGIS-DBD-FILL02 X(06) * * * * REVISED 05/01/96 AT ASC (V6.05) * * CHANGED STUREGIS-DBD-FILL01 TO GPA-REPEAT-TERM X(03) * * CHANGED GPA-REPAT-FLAG TO STUREGIS-DBD-FILL01 X(01) * * * * REVISED 12/06/96 AT ASC (V7.00) * * COMMENTED OUT ACCOUNT-CODE, FIELD IS BEING REMOVED; * * REPLACED WITH STUREGIS-DBD-FILL03 X(04). * * * ******* KEY FIELD ID: CLASS-ID ******* ******* SEGMENT KEY: CLASSID ******* ******* SEGMENT LENGTH: 90 BYTES ******* ******* COPY MEMBER LENGTH: 100 BYTES ******* ***************************************************************** * 05 CLASS-ID. * KEY FIELD: CLASSID 10 QUARTER-ID. * SEARCH FIELD: TERMID 15 QTR-YR PIC X(2). * SEARCH FIELD: TERMYR 15 QTR-CODE PIC X(1). * SEARCH FIELD: TERMCODE 10 CAMPUS PIC X(1). * SEARCH FIELD: CAMPUS * 'COURSEID' IS SEARCH FIELD NAME FOR NEXT 7 BYTES 10 DEPARTMENT PIC X(4). * SEARCH FIELD: DEPT 10 COURSE-NUM PIC X(3). * SEARCH FIELD: CRSE 10 SECTION-NO PIC X(2). * SEARCH FIELD: SECT 10 LEC-LAB PIC X(1). * SEARCH FIELD: LECLAB 05 AID-AUTHORIZED-CODE PIC X(1). * SEARCH FIELD: AIDAUTH 05 CREDITS PIC S9(2)V99 COMP-3. * SEARCH FIELD: CREDITS 05 DATE-LAST-ATTEND. * SEARCH FIELD: LSTATTDT 10 DATE-LAST-MO PIC X(2). * SEARCH FIELD: LSTATTMO 10 DATE-LAST-DAY PIC X(2). * SEARCH FIELD: LSTATTDA 05 DATE-WITHDREW. * SEARCH FIELD: WITHDRDT 10 WITHDREW-MO PIC X(2). * SEARCH FIELD: WITHDRMO 10 WITHDREW-DAY PIC X(2). * SEARCH FIELD: WITHDRDA 05 GRADE PIC X(1). * SEARCH FIELD: GRADE 05 SESSION PIC X(1). * SEARCH FIELD: SESSION 05 WITHDRAW-TYPE PIC X(1). * SEARCH FIELD: WTHDRTYP 05 WITHDRAW-NOTIFY-FLAG PIC X(1). * SEARCH FIELD: WTHDRFLG 05 SR-CIT-LATE-ADD PIC X(1). * SEARCH FIELD: SRCTLTAD 05 STUREGIS-DBD-FILL03 PIC X(4). * 05 ACCOUNT-CODE PIC X(4). * SEARCH FIELD: ACCTCODE 05 REPEATED-CLASS-FLAG PIC X(1). * SEARCH FIELD: REPCLSFL 05 TUITION-CODE PIC X(1). * SEARCH FIELD: TUITCODE 05 GRADE-RECALCULATION PIC X(1). * SEARCH FIELD: GRDRECAL 05 PASS-FAIL-CODE PIC X(1). * SEARCH FIELD: PASSFAIL 05 CROSS-REGISTRATION-FLAG PIC X(1). * SEARCH FIELD: CROSSREG 05 GPA-REPEAT-TERM. * SEARCH FIELD: GPARPTTM 10 GPA-REPEAT-YEAR PIC X(2). * SEARCH FIELD: GPARPTYR 10 GPA-REPEAT-TCODE PIC X(1). * SEARCH FIELD: GPARPTTC 05 MID-TERM-GRADE PIC X(1). * SEARCH FIELD: MIDTRMGR 05 DOCUMENT-NUMBER. * SEARCH FIELD: DOCNUMBR 10 DOCUMENT-NO-PREFIX PIC X(2). * SEARCH FIELD: DOCNUMPF 10 DOCUMENT-NO-SUFFIX PIC X(5). * SEARCH FIELD: DOCNUMSF 05 STUREGIS-DBD-FILL01 PIC X(1). * SEARCH FIELD: FILLER01 05 UPDATE-DATE PIC 9(7) COMP-3. * SEARCH FIELD: DATEUPDT 05 TIME-STAMP PIC 9(6) COMP-3. * SEARCH FIELD: TIMESTMP 05 LTERM-ID PIC X(8). * SEARCH FIELD: LTERMID 05 PROGRAM-CODE PIC X(8). * SEARCH FIELD: PGMID 05 USER-ID PIC X(8). * SEARCH FIELD: USERID 05 STUREGIS-DBD-FILL02 PIC X(6). * SEARCH FIELD: FILLER02 05 STUREGIS-COPY-FILLER PIC X(10). STUDENT ACCOUNT DETAIL SEGMENT ------------------------------ ***************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER FINANCIAL TRANSACTION PER STUDENT - USE THIS * * COPY MEMBER FOR STUACCTD, NSTACCTD, AND CSTACCTD SEGMENTS. * * * * INCLUDE THIS MEMBER(STUACCTD) AFTER YOUR 01 DATA NAME * * * * REVISED 04/03/84 AT JSRCC (V1.5) * * 3 BYTE JURISDICTION CHANGED TO 1 BYTE INSTATE-OUTSTATE. * * CLASS-ID-DESCRIPTIONS IS ADDED FOR CLASS-IDS IN THE * * EVENT THERE WILL BE PARTIAL PAYMENTS OR MORE THAN ONE * * ACCOUNT PAYING FOR A CLASS, OR A DESCRIPTION FOR * * OBLIGATIONS. THE FILLER WAS CHANGED TO 7 BYTES TO * * REFLECT ADDITIONS AND DECREASE OF JURISDICTION * * * * REVISED 03/23/87 AT ASC V2.15 * * ADDED 3 BYTE CREATION-DATE PIC 9(5) COMP-3. * * ADDED 3 BYTE VOID-DATE PIC 9(5) COMP-3. * * ADDED 1 BYTE PROGRAM-CODE PIC X(1) * * * * REVISED 6/25/87 AT ASC (V3.0) * * CHANGED CREDITS FROM S9(2)V9 TO S9(2)V99 * * * * REVISED 01/11/89 AT ASC (V4.0) * * EXPANDED SEGMENT FROM 60 TO 72 BYTES * * DELETED CREDITS FIELD FROM SEGMENT * * CHANGED PROGRAM-CODE FROM PIC X(1) TO PIC X(8) * * * * REVISED 06/18/91 AT ASC (V4.27) * * MODIFIED BILL-PAY-DATE FROM PIC X(6) YYMMDD FORMAT * * TO PIC 9(7) COMP-3 CCYYDDD FORMAT (CENTURY/JULIAN DATE) * * INCREASED DBD FILLER BY 2 BYTES DUE TO ABOVE CHANGE * * ADDED ATB-CATEGORY PIC X(1) TO FILLER AREA LEFTOVER * * FROM 4.0 CHANGE WHICH DELETED CREDITS * * * * REVISED 04/13/93 AT ASC (V5.0) * * ADDED SEARCH FIELD NAMES TO COPY MEMBER (IN COMMENT FORM) * * SEARCH FIELDS ARE ONLY VALID FOR BATCH APPLICATIONS. * * * * REVISED 06/16/95 AT ASC (V6.00) * * EXPANDED SEGMENT FROM 72 TO 100 BYTES * * CHANGED FILLER TO STUACCTD-DBD-FILL01 X(2) * * CHANGED CREATION-DATE TO STUACCTD-DBD-FILL02 X(3) * * ADDED FINAID-PGM-ID GROUP LEVEL 5 BYTES * * ADDED UPDATE-DATE 9(7) C-3 (CCYYDDD) * * ADDED TIME-STAMP 9(6) C-3 (HHMMSS) * * ADDED LTERM-ID X(8) * * ADDED USER-ID X(8) * * CHANGED STUACCTD-DBD-FILLER TO STUACCTD-DBD-FILL03 X(05) * * * * REVISED 12/06/96 AT ASC (V7.00) * * COMMENTED OUT INSTATE-OUTSTATE, FIELD IS BEING REMOVED; * * REPLACED WITH STUACCTD-DBD-FILL04. * * ADDED RECAUD-REG-ID PIC X(02) IN PLACE OF DBD-FILL01. * * ADDED RECAUD-REG-SEQ PIC 9(5) COMP-3 IN PLACE OF DBD-FILL02 * * ******* KEY FIELD ID: ACCOUNT-KEY ******* ******* SEGMENT KEY: ACCTQTID ******* ******* SEGMENT LENGTH: 100 BYTES ******* ******* COPY MEMBER LENGTH: 110 BYTES ******* ***************************************************************** * 05 ACCOUNT-KEY. * KEY FIELD: ACCTQTID =C 10 QUARTER-ID. * SEARCH FIELD: TERMID 15 QTR-YR PIC X(2). * SEARCH FIELD: TERMYR 15 QTR-CODE PIC X(1). * SEARCH FIELD: TERMCODE 10 ACCOUNT-CODE PIC X(4). * SEARCH FIELD: ACCTCODE 05 ACCOUNT-AMOUNT PIC S9(4)V99 COMP-3. * SEARCH FIELD: ACCTAMT 05 ATB-CATEGORY PIC X(1). * SEARCH FIELD: ATBCATGY 05 RECAUD-REG-ID. 10 RECAUD-REG-CAMP PIC X(1). 10 RECAUD-REG-NUM PIC X(1). * SEARCH FIELD: FILLER01 05 DEBIT-CREDIT. * SEARCH FIELD: DEBCREDT 10 DEB-CR-VOID PIC X(1). * SEARCH FIELD: DEBCRVD 10 DEB-CR-VOID-TYPE PIC X(1). * SEARCH FIELD: DEBCRTYP 05 STUACCTD-DBD-FILL04 PIC X(1). * 05 INSTATE-OUTSTATE PIC X(1). * SEARCH FIELD: INOUTSTE 05 VALIDATION-CODE. * SEARCH FIELD: VALIDCDE 10 VALID-CAMPUS PIC X(1). * SEARCH FIELD: VALIDCAM 10 VALID-DATE. * SEARCH FIELD: VALIDDAT 15 VALID-YR PIC X(2). * SEARCH FIELD: VALIDYR 15 VALID-MO PIC X(2). * SEARCH FIELD: VALIDMO 15 VALID-DAY PIC X(2). * SEARCH FIELD: VALIDDA 10 VALID-NUMBER PIC X(5). * SEARCH FIELD: VALIDNUM 10 VALID-REGISTER PIC X(1). * SEARCH FIELD: VALIDREG 10 REVENUE-CODE PIC X(3). * SEARCH FIELD: REVCODE 05 CLASS-ID-FLAG PIC X(1). * SEARCH FIELD: CLSIDFLG 05 CLASS-ID-DESCRIPTION PIC X(14). * SEARCH FIELD: CLSIDDSC 05 RECAUD-REG-SEQ PIC 9(5) COMP-3. 05 RECAUD-REG-SEQ-X REDEFINES RECAUD-REG-SEQ PIC X(3). * SEARCH FIELD: FILLER02 05 VOID-DATE PIC 9(5) COMP-3. * SEARCH FIELD: VOIDDATE 05 PROGRAM-CODE PIC X(8). * SEARCH FIELD: PGMID 05 BILL-PAY-DATE PIC 9(7) COMP-3. * SEARCH FIELD: BILPAYDT 05 FINAID-PGM-ID. * SEARCH FIELD: FAPGMID 10 FINAID-PGM-TYPE PIC X(4). * SEARCH FIELD: FAPGMTP 10 FINAID-PGM-CONTROL PIC X(1). * SEARCH FIELD: FAPGMCT 05 UPDATE-DATE PIC 9(7) COMP-3. * SEARCH FIELD: DATEUPDT 05 TIME-STAMP PIC 9(6) COMP-3. * SEARCH FIELD: TIMESTMP 05 LTERM-ID PIC X(8). * SEARCH FIELD: LTERMID 05 USER-ID PIC X(8). * SEARCH FIELD: USERID 05 STUACCTD-DBD-FILL03 PIC X(5). * SEARCH FIELD: FILLER03 05 STUACCTD-COPY-FILLER PIC X(10). * STUDENT OBLIGATION SEGMENT -------------------------- ***************************************************************** * * * REVISED 04/03/84 * * ONE ENTRY PER OBLIG PLACED UPON STUDENT - USE THIS SAME * * COPY FOR STUOBLIG, NSTOBLIG, AND CSTOBLIG SEGMENTS * * * * ANY CHANGES MADE TO THIS COPY MEMBER SHOULD ALSO BE MADE * * TO MEMBER 'STUOBAUD'. * * * * INCLUDE THIS MEMBER(STUOBLIG ) AFTER YOUR 01 DATA NAME * * * * REVISED 04/03/84 AT JSRCC (V1.5) * * ADDED INVOICE NUMBER AND DESCRIPTION, REMOVED REVENUE CODE * * AND FILLER AT THE END OF THE SEGMENT * * RENAMED DATE-OBLIG-PLACED TO INVOICE-DATE * * RENAMED OBLIG-AMOUNT TO INVOICE-AMOUNT * * * * REVISED 02/12/85 * * INCREASED FILLER AT END OF DESCRIPTION FROM 3 TO 5 * * * * REVISED 01/11/89 AT ASC (V4.0) * * EXPANDED SEGMENT FROM 37 TO 56 BYTES * * MOVED INVOICE-NUMBER AFTER INVOICE-DATE * * CHANGED KEY TO OBLIG-CODE, INVOICE-DATE, AND INVOICE- * * NUMBER, REQUIRED TO BE UNIQUE * * ADDED INVOICE-REMAIN-BALANCE PIC S9(5)V99 COMP-3 * * ADDED CREATION-DATE PIC 9(5) COMP-3 (JULIAN) * * ADDED TIME-STAMP PIC 9(6) COMP-3 (HHMMSS) * * ADDED LTERM-ID PIC X(8) * * * * REVISED 05/12/92, FOR REQUEST #9673 (V4.34): * * - ADDED WRITEOFF-CODE PIC X(1). * * - CHANGED STUOBLIG-DBD-FILLER FROM PIC X(5) TO PIC X(4). * * * ******* KEY FIELD ID: OBLIG-KEY-ID ******* ******* SEGMENT KEY: OBLKEY ******* ******* SEGMENT LENGTH: 56 BYTES ******* ******* COPY MEMBER LENGTH: 66 BYTES ******* ***************************************************************** * 05 OBLIG-KEY-ID. 10 OBLIG-CODE PIC X(3). 10 INVOICE-DATE. 15 INVOICE-YR PIC X(2). 15 INVOICE-MO PIC X(2). 15 INVOICE-DAY PIC X(2). 10 INVOICE-NUMBER PIC X(5). 05 INVOICE-AMOUNT PIC S9(5)V99 COMP-3. 05 DESCRIPTION PIC X(14). 05 INVOICE-REMAIN-BALANCE PIC S9(5)V99 COMP-3. 05 CREATION-DATE PIC 9(5) COMP-3. 05 TIME-STAMP PIC 9(6) COMP-3. 05 LTERM-ID PIC X(8). 05 WRITEOFF-CODE PIC X(1). 05 STUOBLIG-DBD-FILLER PIC X(4). 05 STUOBLIG-COPY-FILLER PIC X(10). * 4.0 PROGRAM SUMMARIES: ------------------ 1. REC010 - ACCOUNT MASTER UPDATE ------ THIS PROGRAM IS USED TO UPDATE THE ACCOUNT MAS- TER FILE. THE ACCOUNT MASTER SEGMENT IS CREA- TED FOR THE PURPOSE OF BILLING ACCOUNTS. SEG- MENTS MAY BE ADDED OR UPDATED, BUT DELETED ONLY IF THERE ARE NO SEGMENTS UNDER THE ACCOUNT MAS- TER (ROOT) SEGMENT. 2. REC011 - ACCOUNT FISCAL UPDATE ------ THIS PROGRAM IS USED TO UPDATE THE ACCOUNT FIS- CAL FILE. THE ACCOUNT FISCAL SEGMENT IS CREA- TED FOR THE PURPOSE OF TRACKING BALANCES BY FISCAL QUARTER. SEGMENTS ARE KEYED BY FISCAL YEAR, AND THREE TOTALS MAINTAINED BY FISCAL QUARTER: BALANCE, WRITE-OFF AMT, ALLOWANCE AMT. ONLY THE WRITE-OFF AND ALLOWANCE AMOUNTS MAY BE UPDATED. SEGMENTS CAN NOT BE CREATED NOR DELETED BY THIS PROGRAM. 3. REC015 - REGISTER SIGN-ON/SIGN-OFF ------ THIS PROGRAM IS USED TO SIGN-ON/SIGN-OFF REGISTER FOR REC020, REC030 AND REC040 PROCESSING. 4. REC020 - ACCOUNTS RECEIVABLE PAYMENT UPDATE ------ THIS PROGRAM IS USED TO POST PAYMENTS ON AC- COUNTS, UPDATING THE ACCOUNT DETAIL SEGMENT. 5. REC025 - ACCOUNTS RECEIVABLE BILLING PROGRAM CRITERIA ------ THIS PROGRAM IS USED TO MAINTAIN THE BILLING CRITERIA TO BE USED FOR PRINTING BILLS AFTER THE ADD/DROP PERIOD HAS ENDED. 6. REC030 - ACCOUNTS RECEIVABLE DETAIL UPDATE ------ THIS PROGRAM IS USED TO UPDATE STUDENT ACCOUNT DETAIL RECORDS, RECORDING ADJUSTMENTS, CHARGES, PAYMENTS AND REFUNDS FOR A GIVEN STUDENT AND ACCOUNT CODE. 7. REC031 - ACCOUNTS RECEIVABLE DETAIL INQUIRY ------ THIS PROGRAM IS USED TO INQUIRE ON STUDENT AC- COUNT DETAIL RECORDS, SHOWING THE VALIDATION INFORMATION, AND AMOUNTS FOR A GIVEN STUDENT AND ACCOUNT CODE. 8. REC040 - REGISTRATION IDENTIFICATION SCREEN & FORMS ------ THIS PROGRAM IS USED TO PREPARE THE REGISTRA- TION FORM FOR PRINTING. MONIES COLLECTED AND CHARGES TO THIRD PARTIES ARE USED TO UPDATE THE STUDENT'S RECORD. THE PROGRAM CREATES AND MAINTAINS AN AUDIT TRAIL (FOR ACCOUNTING PUR- POSES) OF ALL PAYMENTS AND CHARGES MADE BY THE STUDENT. IT ALSO PRINTS THE STUDENT'S R & I FORM. 9. REC060/ - STUDENT OBLIGATION UPDATE REC140 THIS PROGRAM IS USED TO MAINTAIN THE STUDENT'S ------- OBLIGATIONS TO THE COLLEGE. THESE OBLIGATIONS (LIBRARY FINES, BAD DEBTS, TRAFFIC FINES, ETC.) MAY BE ADDED, UPDATED OR DELETED VIA THIS PRO- GRAM. ONLY NON-FINANCIAL OBLIGATIONS MAY BE PROCESSED USING THE REC140 TRANSACTION. 10. REC061 - STUDENT OBLIGATION INQUIRY ------ THIS PROGRAM IS USED TO INQUIRE INTO THE OBLI- GATIONS A STUDENT HAS. EACH OBLIGATION FOR THE STUDENT IS DISPLAYED WITH A TOTAL AMOUNT FOR ALL OBLIGATIONS SHOWN. 11. REC300 - CLEAR ACCOUNT DETAIL FILE BY TERM ------ THIS PROGRAM SELECTS AND DELETES STUDENT AC- DETAIL RECORDS FOR A SELECTED TERM. THESE RECORDS ARE WRITTEN TO A TAPE. ANY ACCOUNT STUDENT RECORDS ARE ALSO WRITTEN TO THE TAPE AND DELETED FROM THE DATABASE. 12. REC301 - RESTORE ACCOUNT DETAIL FILE BY TERM ------ THIS PROGRAM READS THE TAPE CREATED BY REC300 AND INSERTS THE STUDENT ACCOUNT DETAIL RECORDS AND ACCOUNT STUDENT DETAIL RECORDS BACK INTO THEIR PROPER PLACE IN THE DATABASE. 13. REC310 - BACKOUT OF UNPAID REGISTRATIONS ------ THIS PROGRAM DELETES STUDENT REGISTRATION DE- TAIL RECORDS FOR WHICH THE STUDENT HAS NOT PAID AND OPTIONALLY PRODUCES REPORTS, LETTERS TO THE STUDENTS, AND MAILING LABELS. THE REPORTS MAY BE RUN WITHOUT ACTUALLY UPDATING THE DATABASE. 14. REC320 - TUITION REFUND REPORT ------ THIS PROGRAM PREPARES THE TUITION REFUND AND ADJUSTMENT REPORT. THE AMOUNT OF TUITION PAID IS COMPARED TO THE AMOUNT OWED AND REFUND AND/ OR ADJUSTMENT ACCOUNT DETAIL RECORDS ARE CRE- ATED WHEN THERE IS A DISCREPANCY. THE REPORT MAY BE RUN WITHOUT CREATING THE REFUND/ADJUST- MENT RECORDS. REFUND RECORDS THAT ARE CREATED CONTAIN 'RC' IN THE DEBIT-CREDIT CODE INDICAT- ING THAT THE REFUND IS COMPUTER GENTERATED AND HAS NOT ACTUALLY BEEN PAID. 15. REC321 - TUITION REFUND TRANSMITTAL REPORT ------ THIS PROGRAM PREPARES TWO LISTS OF STUDENTS WHO ARE ELIGIBLE FOR A REFUND (ONE FOR THE CENTRAL BUSINESS OFFICE AND ONE FOR THE VCCS). SEPARATE TRANSMITTAL LISTINGS FOR INSTATE AND OUT OF STATE STUDENTS ARE CREATED. OPTIONALLY, THE PROGRAM CHANGES THE 'RC' IN THE DEBIT-CREDIT FIELD OF THE STUDENT ACCOUNT RECORD TO AN 'R ' INDICATING THAT THE REFUND HAS BEEN PROCESSED. 16. REC330 - MARKED OBSOLETE 1/15/96. 17. REC332S - CONTROL FEES UPDATE SUBPROGRAM ------- THIS SUBPROGRAM IS USED TO RETRIEVE/UPDATE/DELETE CONTROL FEES FOR A GIVEN TERM. IN THE CASE OF MAINTENANCE, THE CALLER CAN PROVIDE A SPAN OF TERMS. 18. REC340 - ACCOUNTS RECEIVABLE BATCH POSTING PROGRAM ------ THIS PROGRAM 'POSTS' PAYMENTS TO A BILLABLE ACCOUNT IN A 'BATCH' ENVIRONMENT. A POSTING REPORT IS GENERATED LISTING ACCOUNT DETAIL IN- FORMATION FROM PAYMENTS THAT ARE GENERATED. 19. REC345 - MERGE DUPLICATE ACCOUNT CODES ------ THIS PROGRAM WILL MERGE PERFORM THE FOLLOWING TYPES OF CHANGES TO ACCOUNT DETAILS: 1. MERGE DUPLICATE ACCOUNT RECEIVABLE RECORDS 2. COMBINE TWO ACCOUNT CODES FOR THE SAME SPONSOR 3. VOID ACCOUNT DETAILS FOR A SPECIFIC ACCOUNT/TERM 4. PURGE VOIDED RECORDS FOR A RANGE OF FISCAL YEARS 5. TRANSFER THE ACCOUNT DETAILS FOR A SPECIFIC STUDENT TO ANOTHER ACCOUNT FOR A GIVEN TERM. 20. REC350 - DELETE ACCOUNT CODE MASTER ------ THIS BATCH PROGRAM WILL READ THE WORK DATA BASE TO RETREIVE ANY RECORDS PLACED IN THE WORK DATA BASE BY REC010 TO HAVE ACCOUNT CODES DELETED FROM THE ACCOUNT CODE MASTER DATA BASE. 21. REC360 - ACCOUNTS RECEIVABLE BILLING LIST & INVOICES ------ THIS BATCH BMP/UPDATE PROGRAM IS A VERSION OF REC360. THIS PROGRAM PRINTS AN ACCOUNTS RECEIVABLE BILLING LIST CONTAINING FOR EACH ACCOUNT THE STUDENT, HIS CLASSES, AND AMOUNT OWED FOR THAT STUDENT. 22. REC380 - ACCOUNTS RECEIVABLE UPDATE TRANSACTION LOG ------ THIS PROGRAM PRINTS THE LOG OF TRANSACTIONS EN- TERED THROUGH REC020 AND REC030. 23. REC390 - SETS THE ATB-CATEGORY IN THE ACCOUNT DETAIL ------ THIS PROGRAM SETS THE ATB-CATEGORY IN THE ACCT. DETAIL SEGMENTS TO MATCH THE VALUE IN ACCT. MASTER. 24. REC391 - SETS USE-SPECIAL-TUITION-RATE FLAG ------ THIS PROGRAM READS THE STUDENT DATBASE AND SETS THE USE-SPECIAL-TUIT-RATE FALG MASTER. 25. REC500 - ACCOUNTS RECEIVABLE MASTER ACCOUNT CODE LIST ------ THIS PROGRAM PRINTS AN ACCOUNTS RECEIVABLE MAS- TER REPORT SHOWING THE FIELDS OF THE ACCOUNT MASTER SEGMENT. 26. REC505 - ACCOUNT BALANCES REPORT ------ THIS PROGRAM PRINTS AN ACCOUNTS RECEIVABLE BALANCE REPORT. IT SHOWS ACCOUNT CODE, NAME, AND CURRENT BALANCE. SORT AND SELECTION OPTIONS ARE AVAILABLE. 27. REC510 - ACCOUNTS RECEIVABLE LIST BY STUDENT NAME ------ THIS PROGRAM PRINTS A REPORT OF ALL ACCOUNT DETAILS BY STUDENT OR ACCOUNT NAME CONTAINING VALIDATION NUMBER, STUDENT NAME AND SOCIAL SEC- URITY, ACCOUNT CODE AND NAME, AND AMOUNT PAID. THE REPORT MAY BE RUN FOR AN ENTIRE TERM OR FOR A SPECIFIC DAY WITHIN A TERM. 28. REC515S - REGISTER FORMATTING SUBPROGRAM ------- THIS SUBPROGRAM IS USED TO FORMAT THE CONTENTS OF THE REGISTER SEGMENT FOR DISPLAY AND/OR PRINT. 29. REC525S - DETERMINE PAID STATUS SUBPROGRAM ------- THIS SUBPROGRAM IS USED TO DETERMINE IF CLASS HAS PAYMENTS MADE FOR IT OR NOT. 30. REC535S - RETRIEVE STUACCTD SUBPROGRAM ------- THIS SUBPROGRAM IS USED TO RETRIEVE ACCOUNT DETAILS FOR A STUDENT FOR A SPECIFIED TERM, AND CLASS IF DESIRED. 31. REC530 - ACCOUNTS RECEIVABLE BILLS ------ THIS PROGRAM PRINTS THE ACCOUNTS RECEIVABLE BILLING LIST. 32. REC531S - TUITION CALCULATION SUBPROGRAM ------- THIS SUBPROGRAM IS USED TO CALCULATE THE AMOUNT OF TUITION, ACTIVITY FEE, AND LAB FEE DUE BY A STUDENT BASED ON HIS REGISTRATION RECORDS, TUITION RATES, ACTIVITY FEE CALCULATION SPECI- FICATION, AND LAB FEES (FROM THE CLASS MASTER SEGMENT). 33. REC540 - TUITION STATEMENTS ------ THIS PROGRAM PRINTS TUITION STATEMENTS FOR STU- DENTS WHO HAVE UNPAID BALANCES FOR TUITION AND ACTIVITY FEE. 34. REC560 - STUDENT OBLIGATION REPORT ------ THIS PROGRAM PRODUCES A REPORT OF THE STUDENTS' OBLIGATIONS TO THE COLLEGE. 35. REC590 - CASH REGISTER RECONCILIATION REPORT ------ THIS PROGRAM PRINTS A CASH REGISTER RECONCILIA- TION REPORT SHOWING THE TUITION TOTALS FOR EACH CAMPUS BUSINESS OFFICE BY CASH REGISTER NUMBER WITHIN DATE. 36. REC595 - ACCOUNTS RECEIVABLE REVENUE COLLECTIONS REPORT ------ THIS PROGRAM PRINTS A REPORT THAT WILL LIST ALL ACCOUNTS FOR WHICH REVENUE HAS BEEN GENERATED FOR THE TERM SELECTED. 37. REC700 - SELECT STUDENTS BY TERM ------ THIS PROGRAM CREATES A TEMPORARY DISK FILE OF SELECTED STUDENTS TO BE USED BY OTHER 'REC' PROGRAMS. 38. REC710 - UNMATCHING TUITION PAYMENT REPORT ------ THIS PROGRAM PREPARES A REPORT LISTING ALL STU- DENTS WHOSE TUITION THAT SHOULD HAVE BEEN PAID DOES NOT MATCH THE TUITION THAT HAS ACTUALLY BEEN PAID. IT USES THE TEMPORARY DISK FILE CREATED BY REC700. 39. REC740 - VALIDATION NUMBER REPORT ------ THIS PROGRAM PREPARES A REPORT OF ALL VALIDA- TION NUMBERS SORTED IN ONE OF THE FOLLOWING WAYS: (A) BY CAMPUS, STUDENT, DEBIT/CREDIT CODE; (B) BY CAMPUS, VALIDATION NUBMER, REGIS- TER NUMBER; (C) BY CAMPUS, ACCOUNT NAME, STU- DENT NAME; OR (D) BY CAMPUS, REVENUE CODE, VALIDATION NUMBER. 40. REC750 - UNPAID STUDENT REPORT ------ THIS PROGRAM PREPARES A REPORT LISTING ALL STU- DENTS WHO ARE TAKING CLASSES FOR A SPECIFIED TERM BUT HAVE PAID NO TUITION. 41. REC760 - GRADES FOR TUITION ASSISTANCE STUDENTS ------ THIS PROGRAM PREPARES A REPORT OF STUDENTS WITH THEIR GRADES, STATUS, TERM AND CUMMULATIVE GPA FOR SELECTED ACCOUNT CODES OR GROUP. 42. REC780 - STUDENT OBLIGATION STATEMENTS ------ THIS PROGRAM PREPARES A REPORT OF STUDENTS WHO HAVE UNPAID OBLIGATIONS TO THE COLLEGE. 43. REC790 - CONTRACT CLASS STUDENT LIST ------ THIS PROGRAM CREATES A LISTING OF STUDENTS WHO REGISTERED FOR A CLASS AS A CONTRACT STUDENT. 44. REC810 - DAILY TUITION CHARGE REPORT ------ THIS PROGRAM CREATES A REPORT OF TUITION/CHARGE PAYMENTS BASED ON INPUT PARAMETERS. 45. REC815 - PAYMENTS AND REFUNDS REPORT ------ THIS BATCH PROGRAM SELECTS STUDENTS BASED ON INPUT PARAMETERS AND SORTED BY CAMPUS, STUDENT NAME, VALIDATION DATE, SPONSOR CODE AND CLASSID. REPORT BREAKS OCCUR AT NAME AND CAMPUS ONLY. 46. REC820 - AGE STUDENT OBLIGATIONS ------ THIS PROGRAM PRODUCES A REPORT TO AGE THE OBLI- GATIONS OF STUDENTSAND TOTAL THE OBLIGATIONS BY STATE CODES, STATE TOTALS, FEDERAL CODES, FED- RAL TOTALS AND GRAND TOTALS. THE OBLIGATIONS ARE AGED FOR 1-30 DAYS, 31-60 DAYS, 61-90 DAYS, 91-120 DAYS, 121 DAYS TO 1 YEAR, AND OVER ONE YEAR. 47. REC830 - ACCOUNTS RECEIVABLE REVENUE REPORT ------ THIS PROGRAM PRODUCES A DETAILED AND SUMMARY REPORT OF THREE TYPES OF ACCOUNT GROUPS, MIL- ITARY, CONTRACT AND GENERAL SPONSORS. 48. REC850 - OUT-OF-STATE STUDENT TUITION REVIEW TERM REPORT ------ THIS PROGRAM PRODUCES A LISTING OF OUT-OF-STATE STUDENTS WHOSE TUITION REVIEW TERM IS NON-BLANK INDICATING THOSE WHOSE REVIEW TERM HAS EXPIRED. 49. REC860 - ACCOUNTS RECEIVABLE AGING REPORTS. ------ THIS PROGRAM PRODUCES A LISTING OF ACCOUNTS RECEIVABLE AGING REPORT. 8.0 CHANGE HISTORY -------------- 8.1 VERSION NO: V4.09 CHANGE DATE: 01/10/90 PROGRAMMER NAME: S. EDMONDS PROGRAM CHANGE REQUEST NO: 00004497 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION BY ADDING THE PROGRAMS REC350 AND REC815 TO THE 4.0 PROGRAM SUMMARIES SECTION. 8.2 VERSION NO: V4.27 CHANGE DATE: 09/15/91 PROGRAMMER NAME: RH.CLARK PROGRAM CHANGE REQUEST NO: 00004497 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION BY ADDING THE PROGRAM REC025 TO APPROPRIATE SECTIONS. PROGRAMMER NAME: RH.CLARK PROGRAM CHANGE REQUEST NO: 00008311 DESCRIPTION OF CHANGE: -REVISED DOCUMENTATION BY ADDING PROGRAM REC011 TO APPROPRIATE SECTIONS. -REVISED ACCDBD DATA BASE FLOWCHART TO INCLUDE ACCTFSCL SEGMENT AND REMOVE ACCTPAY AND ACCTCHRG SEGMENTS. -REVISED SEGMENT LAYOUT SECTION TO INCLUDE CURRENT FORMAT - CHANGED TO USE COPYLIB DESCRIPTION FOR EASE OF MAINTENANCE. 8.3 VERSION NO: V4.35 CHANGE DATE: 06/11/92 PROGRAMMER NAME: EUGENE WALLO PROGRAM CHANGE REQUEST NO: 00010184 DESCRIPTION OF CHANGE: - CHANGED SECTION 3.0 OF THIS DOCUMENTATION TO CONTAIN THE LATEST TEXT (VERSION 4.34) OF THE STUDENT OBLIGATION (STUOBLIG) COPYLIB MEMBER. 8.4 VERSION NO: V6.01 CHANGE DATE: 01/15/96 PROGRAMMER NAME: RH.CLARK PROGRAM CHANGE REQUEST NO: 00016065 DESCRIPTION OF CHANGE: - DOCUMENTATION CHANGED TO SHOW REC330 AS OBSOLETE. 8.5 VERSION NO: V6.13 CHANGE DATE: 09/15/97 PROGRAMMER NAME: ANDREW HASLETT CHANGE REQUEST NO: 00012953 DESCRIPTION OF CHANGE: REC010 CHANGED TO UPDATE THE ACCOUNT MASTER WITH THE STANDARD INDUSTRY CLASSIFICATION AND OWNERSHIP CODES TO FACILITATE REPORTING FOR THE VIRGINIA WORKS PROJECT. THE CHANGE INCLUDES A REVISION TO THE MAP AND THE ADDITION OF EDITS FOR THE CODES. THE LOGIC WILL REQUIRE ENTERING THE NEW FIELDS EXCEPT: 00142100 - IF THE ACCOUNT-GROUP EQUALS 'NB' *00142300 THE SIC AND OWNERSHIP CODES ARE INITIALIZED TO *00142400 ZEROES; *00142500 - IF THE ACCOUNT-GROUP EQUALS 'NC', THE SIC CODE IS *00142600 INITIALIZED TO ZEROES AND THE OWNERSHIP CODE IS *00142700 '20'. *00142800 THE STANDARD INDUSTRY CLASSIFICATION AND OWNERSHIP CODES WERE ADDED TO THE ACCTMSTR COPY MEMBER. 8.6 VERSION NO: V7.00 CHANGE DATE: 01/15/98 PROGRAMMER NAME: RH.CLARK, K. HARCUM CHANGE REQUEST NO: 00015442 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION BY ADDING THE FOLLOWING PROGRAMS: REC015, REC332S, REC515S, REC525S, REC535S. REMOVED OBSOLETE PROGRAM REC050.