JOB NAME:   TETH

JOB TITLE:       OUTSTANDING CHARGES REPORT FROM THE DATABASE

DESCRIPTION:
This job reads the SIS database and produces a report of outstanding charges for tuition, fees, and housing for each of three terms.  A report of fiscal year totals is also produced.

INPUT:
SIS database

CONTROL PARAMETERS:

    Title:   Outstanding Charges Control Record (SIPR824)

    Example:
 
PGM=SIPR824,INST=BD,TERM1=20034,TERM2=20037,TERM3=20041,ASOF=07/31/04
12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:
 
POSITION FIELD VALUE
 1     4 FIELD LABEL 'PGM='
 5   11 PROGRAM ID 'SIPR824'     Required.
12  12 DELIMITER Space or comma(,)
13  17 FIELD LABEL 'FILE='
18  19 INSTITUTION Institution to be reported.  Required.
Valid=BD, CS, CU, DN, HS
20  20 DELIMITER Space or comma(,)
21  26 FIELD LABEL 'TERM1='
27  31 YEAR/TERM 1 First year and term to be selected for reporting. Required. Format CCYYT.  
32  32 DELIMITER Space or comma(,)
33  38 FIELD LABEL 'TERM2='
39  43 YEAR/TERM 2 Second year and term to be selected for reporting.  Format CCYYT.   
44  44 DELIMITER Space or comma(,)
45  50 FIELD LABEL 'TERM3='
51  55 YEAR/TERM 3 Third year and term to be selected for reporting.  Format CCYYT.   
56  56 DELIMITER Space or comma(,)
57  61 FIELD LABEL 'ASOF='
62  69  REPORT DATE 'As of' date to be printed on the report.
Format - MM/DD/YY

    Title:   Initial Term Values Record

    Example:
 
RESGRAD1ADJU0017564767-0035656102-0029517742-
NONUNDG1BILL0604193685+6144721508+5241995932+
DEF    1ADJU0000000000+0427762103-0361073245-
FEEHINS1COLL0000000000+0337321600+0304384310+
HOU    1COLL0098846773-1638181770+1475890918+
12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:
 
POSITION FIELD VALUE
 1    3 REPORT CATEGORY Primary category for reporting.  Required.
Values:
RES=resident tuition
NON=non-resident tuition
DEF=deferred tuition
FEE=student fees
HOU=student housing
 4    7 TUITION/FEE TYPE Sub-category of the reporting categories.   Required.  Space is a valid value.  Values:
UNDG=under-graduate
GRAD=graduate
LAW=law 
ENVD=environmental design 
MAND=mandatory UCSU fees
VOL=voluntary UCSU fees 
COUR =course fees
ADMN=administrative fees 
HINS=student health insurance 
 8    8 RECORD TYPE Record identifier. Required.
Value=1
 9   12 COLUMN HEADINGS Column headings for the report
Value:
BILL=total billed
ADJU=adjusted
COLL=total collected
13   22 BALANCE TERM1 Purged TERM1 balance.  Refer to NOTE.
Two (2) decimal places are assumed.
$100=0000010000
23   23 SIGN 1 Sign associated with the purged TERM1 balance.  Value '+' or '-'
24  33 BALANCE TERM2 Purged TERM2 balance.  Refer to NOTE.
Two (2) decimal places are assumed.
$100=0000010000
34   34 SIGN 2 Sign associated with the purged TERM2 balance.  Value '+' or '-'
35   44 BALANCE TERM3 Purged TERM3 balance. Refer to NOTE.
Two (2) decimal places are assumed.
$100=0000010000
45   45 SIGN 3 Sign associated with the purged TERM3 balance.  Value '+' or '-'

NOTE:  Balance amount considerations:

  1. The balance amount for each term will be spaces until the term purge for the term has been run.  That means that all of the balance fields will be spaces until after the summer term purge.
  2. The balance amount for each term will be spaces for the first run following the term purge for the term.
    The balance amount for a term that has been purged is the difference between the balance for this category on the run just prior to the purge and the balance for this category on the first run following the purge.  In other words, the balance amount is the calculated balance that was removed by  the term purge.


    Title:   Subcode Range Record (SIPR824)

    Example:
 
RESENVD210142-10142,10144-10144,10146-10146,10148-10148,10150-10150,10152-10152,
RESENVD210230-10230,10232-10232,10234-10234,10236-10236,10238-10238,10240-10240
NONUNDG210111-10111,10115-10115,10119-10119,10129-10129,10201-10201,10205-10205,
NONUNDG210209-10209
NONGRAD210113-10113,10117-10117,10121-10121,10155-10155,10180-10182,10203-10203,
12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:
 
POSITION FIELD VALUE
 1    3 RECORD CATEGORY IPrimary category for reporting.  Required.
Values:
RES=resident tuition
NON=non-resident tuition
DEF=differed tuition
FEE=student fees
HOU=student housing
 4    7 SECOND TYPE Sub-category of the reporting categories.   Required.  Space is a valid value.  Values:
UNDG=under-graduate
GRAD=graduate
LAW=law 
ENVD=environmental design 
MAND=mandatory UCSU fees
VOL=voluntary UCSU fees 
COUR =course fees
ADMN=administrative fees 
HINS=student health insurance
 8    8 RECORD TYPE Record identifier. Required.
Value=2
 9   80 SUBCODE RANGES Charge and refund subcodes associated with the record category and fee type.  Up to 6 ranges may be entered per record.
9    13  LOW SUBCODE 1 Low subcode for first range
14  14 SEPARATOR Dash (-)
15  19 HIGH SUBCODE 1 High subcode for first range
20   20 DELIMITER Space or comma(,)
21   25 LOW SUBCODE 2 Low subcode for second range
26   26 SEPARATOR Dash (-)
27   31 HIGH SUBCODE 2 High subcode for second range
32   32 DELIMITER Space or comma(,)
33   37 LOW SUBCODE 3 Low subcode for third range
38   38 SEPARATOR Dash (-)
39   43 HIGH SUBCODE 3 High subcode for third range
44   44 DELIMITER Space or comma(,)
45   49 LOW SUBCODE 4 Low subcode for fourth range
50   50 SEPARATOR Dash (-)
51   55  HIGH SUBCODE 4 High subcode for fourth range
56   56 DELIMITER Space or comma(,)
57   61 LOW SUBCODE 5 Low subcode for fifth range
62   62 SEPARATOR Dash (-)
63   67 HIGH SUBCODE 5 High subcode for fifth range
68   68 DELIMITER Space or comma(,)
69   73 LOW SUBCODE 6 Low subcode for sixth range
74   74 SEPARATOR Dash (-)
75   79 HIGH SUBCODE 6 High subcode for sixth range

REPORT INFO:
SIPR824 - Outstanding Charges Report

OTHER OUTPUT:
None