JOB TITLE: BATCH UPDATE TO DELETE FLAG ON ACH RECORD
DESCRIPTION:
This job updates the delete flag on the SIRE083-ACH record.
An input file of SIDs is supplied by the user. The job TETA creates a report
and a file that the user can review and edit, then the file may be used
as input into TEVF$. The SIDs processed by TEVF$ will have the delete indicator
in the ACH record set to 'deleted'.
INPUT:
SIS database
SID file from TETA
or other SID file set-up by user (SIS.TETA.ACHSID&INST&IDENT)
CONTROL PARAMETERS:
Title: ACH Delete Flag Update Finder file
Example:
B1
111111111
B1L222222222 12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 02 | ACADEMIC UNIT | Academic unit of student
having the delete flag set on an ACH record. Required.
Valid = B1, B2, B3, C1, C2, C3, D1, D2, D3, H1, H2, H3 |
03 03 | EXTERNAL | External indicator of student having the ACH delete flag set. Required. |
04 12 | SID | Identifier for student having the ACH delete flag set. Required. |
Title: ACH Delete Flag Update control record (SIPR811)
Example:
SIPR811
,INST=BD,AU=B1,EXT= ,UPDT=Y,ACTION=DELETED,NAME=BOULDER CAMPUS
12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 08 | PROGRAM ID | 'SIPR811 ' Required. |
09 09 | DELIMITER | Space or comma (,) |
10 14 | FIELD LABEL | 'INST=' |
15 16 | INSTITUTION | Institution having ACH delete flags set. Required.
Must be a valid SIS institution. Valid='BD', 'CS', 'DN', 'HS' |
17 17 | DELIMITER | Space or comma (,) |
18 20 | FIELD LABEL | 'AU' |
21 22 | AU | Academic unit having ACH delete flags set. Required. |
23 23 | DELIMTER | Space or comma (,) |
24 27 | FIELD LABEL | 'EXT=' |
28 28 | EXTERNAL | External indicator of students having ACH delete flags set. Space is a valid external indicator. |
29 29 | DELIMITER | Space or comma (,) |
30 34 | FIELD LABEL | 'UPDT=' |
35 35 | UPDATE OPTION | Option specifying whether to update the SIS database.
Required.
Y=Yes, update the database N=No, do not update the database |
36 36 | DELIMITER | Space or comma (,) |
37 43 | FIELD LABEL | 'ACTION=' |
44 50 | ACTION | The value that will be moved into the ACH record. Required.
Valid = DELETED |
51 51 | DELIMITER | Space or comma (,) |
52 56 | FIELD LABEL | 'NAME=' |
57 80 | CAMPUS NAME | Name of campus as it is to appear in the
report headings. Required.
e.g., 'BOULDER CAMPUS', 'DENVER CAMPUS' |
REPORT INFO:
ACH Set Delete Flag Report (SIPR811)
OTHER OUTPUT:
SIS Database Records - Updates
SIRE083-ACH Delete Indicator