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:
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