JOB TITLE: EXTRACT SUBCODE DATA FOR SPREADSHEETS
DESCRIPTION:
This job extracts
subcode data and creates a downloadable semicolon delimited file for
spreadsheets.
INPUT:
SIS
database
CONTROL PARAMETERS:
Title: Extract control record (SIPR936)
Example:
PGM=SIPR936,HS 12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 04 | FIELD LABEL | 'PGM=' |
05 11 | PROGRAM ID | 'SIPR936' |
12 12 | DELIMITER | Spaces or comma (,). |
13 14 | INSTITUTION | Institution to be used for subcode
selection Valid: BD, CS, DN, HS |
REPORT
INFO:
Record counts (SIPR936)
OTHER
OUTPUT:
Subcode Extract file which gets transferred to the FTP server
(SIS.TEEZ.&INST)