Selection Criteria
1.Only looks at a student whose external and SID are on the input finder file that was created for the pre-purge billing run. (Controlled by an I in ACCTSEL in control card.)
2.Checks to see if a student is in collections. A student is in collections:
a.If he has a blank external and STUDENT COLLECTIONS AGENY (404) is not spaces
b.If he has a non-blank external and EXTERNAL COLLECTIONS AGENCY (404) is not spaces.
3.Reads
all the detail records for a student.Detail
records that qualify initially are:
a.Detail
external matches external on SID file.
b.Term
>= Control Card TERM1 and <= Control Card TERM2
c.All
AUs because AU is ** on our Control Cards.
4.Further
qualifies detail records as follows:
a.Balance
forward all records qualify
b.Charges
(C/P on 415) = C qualify if
(1.)(Bill
date not = spaces or zeroes) or (Bill date is spaces or zeros but the BILL
PRINT field on 404 = S).
(2.)The
AMOUNT field (415) = (PAID/APPLIED from 415: CASH + NON-CASH + WAIVER)
(3.)The
amount sent to accounting (not visible on a screen but visible on a snapshot)
= (PAID/APPLIED from 415: CASH + NON-CASH + WAIVER)
(4.)The
P/S FEEDFLAG (415) is 2.
c.Payments
(C/P on 415) = P qualify if
(1.)(Bill
date not = spaces or zeroes) or (Bill date is spaces or zeros but the BILL
PRINT field on 404 = S).
(2.)The
AMOUNT field (415) = (PAID/APPLIED from 415: CASH + NON-CASH + WAIVER)
(3.)The
amount sent to accounting (not visible on a screen but visible on a snapshot)
= zero.
(4.)The
P/S FEEDFLAG (415) is 2.
5.Detail
records that are not purged are handled as follows:
a.Move
PAID/APPLIED (415) amounts to PURGED (415) amounts as follows:
PAID/APPLIED
CASH to PURGED CASH
PAID/APPLIED
NON-CASH TO PURGED NON-CASH
PAID/APPLIED
WAIVER TO PURGED WAIVER
b.IfBILL
DT (415) = BILLDT on Control Card, move zero to BILL DT (415) and move
spaces to DUE DT (415).
6.Detail
records that are purged are handled as follows:
a.If
the AMOUNT (415) < zero PAID/APPLIED (415) values are added to credit
summary fields as follows:
PAID/APPLIED
CASH to BF-CREDIT-CASH
PAID/APPLIED
NON-CASH to BF-CREDIT-NCSH
PAID/APPLIED
WAIVER to BF-CREDIT-WAIVER
b.If
AMOUNT (415) >= zero values are stored in a table by term and effective
date as follows:
EFF/DT
(415) to BF-CDATE-TAB
TERM
(415) to BF-TERM-TAB
PAID/APPLIED
CASH (415) to BF-TAB-CASH
PAID/APPLIED
NON-CASH (415) to BF-TAB-NCSH
PAID/APPLIED
WAIVER (415) to BF-TAB-WAIVER
7.After
all the detail records are read, the credits are applied to the debits
in the table starting with the earliest term and effective date and working
forward until all have been applied.If
there is still credits left after all the debits have been applied, they
are added as an entry in the table.
8.When
the above table processing is completed, balance forward records are created
for any term and effective date whose cash, non-cash, and waiver fields
are not zero.These records are created
as follows:
00101
to SUBCODE (415)
BALANCE
FORWARD to DESC (415)
BBT380
to REF (415) and ORGIN (415)
BF-TERM-TAB
to TERM (415) if there is only a credit balance forward record left,
the term of the last charge or balance forward record processed is moved
to TERM (415)
BF-CDATE-TAB
to EFF/DT (415), BILL DT (415), DUE DT (415) if there is only a credit
balance forward record, run date goes to EFF/DT (415), BILL DT (415), and
DUE DT (415)
2
TO P/S FEED FLAG (415)
BF-TAB-CASH
to PAID/APPLIED CASH (415) and PURGED CASH (415)
BF-TAB-NCSH
to PAID/APPLIED NON-CASH (415) and PURGED NON-CASH (415)
BF-TAB-WAIVER
to PAID/APPLIED WAIVER (415) and PURGED WAIVER (415)
(PAID/APPLIED
(415): CASH + NON-CASH + WAIVER) to BD-TR-PURGE-AMT (total purged amount
- not visible on a screen) and BD-TR-ACCT-AMT (amount sent to accounting
- not visible on a screen)
run
date to CREATE DT (415) and TRAN/DT (415) and PAID/APPLIED DATE (415)
spaces
to PeopleSoft account numbers
9.Even
if the detail is purged, the records necessary to do tuition calcs for
prior terms (IABRCBD) will be left out on the database if detail term >=
Control Card TERM3. (Only IABRCTR records (415) will be purged)
5/7/02