JOB TITLE: SIS TRANSACTION STRIP
DESCRIPTION:
This job reads and
extracts SIS/BRS transaction recors that have been created by Admissions job
TMUD$. The extracted records are then batched and fed into the BRS batch
update (TEMA$). The records that are extracted are then erased from the
database.
INPUT:
SIS
database
CONTROL PARAMETERS:
Title: Transaction Strip control record (SIPR118)
Example:
SIPR118,UPDATE
SIS?=Y,AU=B1,BATCHID=DEB100,BATCHDT=999999 12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR118' |
08 08 | DELIMITER | Comma (,) or space |
09 20 | FIELD LABEL | UPDATE SIS?= |
21 21 | UPDATE OPTION | Option specifying if the SIS database will be
updated. Valid: Y=yes, update the database N=no, do not update the database |
22 22 | DELIMITER | Spaces or comma (,). |
23 25 | FIELD LABEL | 'AU=' |
26 27 | ACADEMIC UNIT | Academic unit to be assigned to transactions. |
28 28 | DELIMITER | Spaces or comma (,). |
29 36 | FIELD LABEL | BATCHID= |
37 42 | BATCH ID | Batch identifier for transaction batch.
Standard batch id is DEB100. Format: AAA999 |
43 43 | DELIMITER | Spaces or comma (,). |
44 51 | FIELD LABEL | BATCHDT= |
52 57 | BATCH DATE | Date to be assigned to the transaction
batch. Format: MMDDYY Entry of 999999 will cause the system date to be used.. |
REPORT
INFO:
Transaction batching report
OTHER
OUTPUT:
Enrollment Deposit transactions (SIS.BRS.DE.TRANS)
input into TEMA$
Enrollment Deposit transaction backup file
(SIS.BRS.BK.DE.TRANS)
Transaction strip file (SIS.BRS.STRIP.APND)
Transaction strip file backup (SIS.BRS.BK.STRIP.APND)