MRAG

JOB NAME: MRAG

JOB TITLE: CORE CASH PROCESSING

DESCRIPTION:
This job uses a file transferred to the mainframe from the CORE cash machines. CORE updates the student records on the SIS database directly... however, MRAG revalidates all BR records against the SIS database searching for errors and discrepancies. If the CORE operator is unable to find a student on the SIS database, the operator may build CREATE records to be transferred along with the cash transactions. Only the CREATE records and their associated data records are sent to BRS (via TEAY). A PeopleSoft file is also produced that reflects the dollar total of all transactions. An error report is created listing all transactions that could not be validated.

INPUT:
File transferred from the CORE cash machines (CASH.CORE99.BDB1.Y&year ,
    CASH.CORE99.BDB2.Y&year,
    CASH.CORE99.DNVR.Y&year,
    CASH.CORE99.HSC.Y&year,
    CASH.CORE99.UCCS.Y&year)
SIS database

CONTROL PARAMETERS:

Title: CORE Edit control record
Note: This control record is not maintained by the campus offices. UMS will modify this record as needed.

Example:

BD BOULDER CONT ED 19950 19951 OFFSETPGM=02255
12345678901234567890123456789012345678901234567890123456789012345678901234567890

BD BOULDER CONT ED 19950 19951 OFFSETPGM=02255 12345678901234567890123456789012345678901234567890123456789012345678901234567890

Format:

POSITION FIELD VALUE

01 02 INSTITUTION SIS institution having its cash transactions validated.
Required.

03 03 DELIMITER Space or comma (,)

04 19 CAMPUS LABEL Label of campus to be placed on reports.
Valid:
BOULDER
BOULDER CE
DENVER
HEALTH SCIENCE
COLORADO SPRINGS

20 20 DELIMITER Space or comma (,)

21 25 ENROLLMENT DEPOSIT SUBCODE 1 First enrollment deposit subcode to have effective date set to 999999 for reporting and created records. Valid: 19950, 19951, or spaces.

26 26 DELIMITER Space or comma (,)

27 31 ENROLLMENT DEPOSIT SUBCODE 2 Second enrollment deposit subcode to have effective date set to 999999 for reporting and created records. Valid: 19950, 19951, or spaces.

32 32 DELIMITER Space or comma (,)

33 37 ENROLLMENT DEPOSIT SUBCODE 3 Third enrollment deposit subcode to have effective date set to 999999 for reporting and created records. Valid: 19950, 19951, or spaces.

38 38 DELIMITER Space or comma (,)

39 43 ENROLLMENT DEPOSIT SUBCODE 4 Fourth enrollment deposit subcode to have effective date set to 999999 for reporting and created records. Valid: 19950, 19951, or spaces.

44 44 DELIMITER Space or comma (,)

45 54 FIELD LABEL OFFSETPGM=

55 59 OFFSET PROGRAM Program code for the general ledger cash depository account for the campus.

POSITION	FIELD	VALUE
01 02	INSTITUTION	SIS institution having its cash transactions validated. Required.
03 03	DELIMITER	Space or comma (,)
04 19	CAMPUS LABEL	Label of campus to be placed on reports. Valid: BOULDER BOULDER CE DENVER HEALTH SCIENCE COLORADO SPRINGS
20 20	DELIMITER	Space or comma (,)
21 25	ENROLLMENT DEPOSIT SUBCODE 1	First enrollment deposit subcode to have effective date set to 999999 for reporting and created records. Valid: 19950, 19951, or spaces.
26 26	DELIMITER	Space or comma (,)
27 31	ENROLLMENT DEPOSIT SUBCODE 2	Second enrollment deposit subcode to have effective date set to 999999 for reporting and created records. Valid: 19950, 19951, or spaces.
32 32	DELIMITER	Space or comma (,)
33 37	ENROLLMENT DEPOSIT SUBCODE 3	Third enrollment deposit subcode to have effective date set to 999999 for reporting and created records. Valid: 19950, 19951, or spaces.
38 38	DELIMITER	Space or comma (,)
39 43	ENROLLMENT DEPOSIT SUBCODE 4	Fourth enrollment deposit subcode to have effective date set to 999999 for reporting and created records. Valid: 19950, 19951, or spaces.
44 44	DELIMITER	Space or comma (,)
45 54	FIELD LABEL	OFFSETPGM=
55 59	OFFSET PROGRAM	Program code for the general ledger cash depository account for the campus.

REPORT INFO:
SIPR728    Daily Batching
SIPR730     PeopleSoft Transaction report
SIPR731    BR Records for Batch Update report
SIPR732    Error report
SIPR735    Over/Under Receipts - All report
SIPR736    Over/Under Receipts report

OTHER OUTPUT:
Create transactions to update BRS (CASH.CORE99.&campus.BRS.TRANS) - input into TEMA$ via TEAY
PeopleSoft journal transactions (CASH.CORE99.&campus.JOURNALS.Y&year) - input into MRAG
Reinitialized CORE cash file (CASH.CORE99.&campus.Y&year)
Backup of CORE cash file (CASH.CORE99.&campus.BACKUP.Y&year)
Backup of BRS transaction file (CASH.CORE99.&campus.BACKUP.BRS.TRANS)
Backup of PeopleSoft journal transactions (CASH.CORE99.&campus.BACKUP.JOURNALS.Y&year)