JOB TITLE: BILL DATE BASED ID FILE CREATE
DESCRIPTION:
This job creates
two output files, one containing student id numbers only, and the other
containing institution, external identifier, and student id number.
Students are selected based on user specified subcodes, terms and bill
dates.
INPUT:
SIS
database
Finder file of subcodes
(optional)
CONTROL PARAMETERS:
Title: SIPR905
Example:
Parameter records may be specified in any order. A
parameter record with all asterisks in the program id field will be considered a
"comment" by the program.
******* CARDS CAN BE IN
ANY ORDER ******* ANY CARD WITH ******* IN COLUMNS 1-7 ARE IGNORED *******:BILL-DATE>=20051031:SUBCODE= ONLY LOOK AT THESE TRANSACTIONS SIPR905:BILL-DATE=>20060111,SUBCODE=10110,10111,10112,10113 SIPR905:BILL-DATE=>20051211,SUBCODE=10122,10123,10142,10143 *******:BILL-DATE>=20051131:SUBCODE=99999 SIPR905:TERM=20057 SIPR905:INCLUDE BILL-CODE=BD, ,** SIPR905:INCLUDE BILL-CODE=AV,MB,FB,** SIPR905:INST=BD SIPR905:AU=B1,B2,B3 SIPR905:EXT= **** SIPR905:FINDER******* CARDS CAN BE IN ANY ORDER SIPR905:REPORT AG=I *******:REPORT******* ANY CARD WITH ******* IN COLUMNS 1-7 ARE IGNORED |
SIPR905 BILL DATE control record
Example:
SIPR905:BILL-DATE=>20060111,SUBCODE=10110,10111,10112,10113
12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR905' |
08 08 | DELIMITER | Colon (:) or space |
09 20 | RECORD IDENTIFIER | 'BILL-DATE=>' |
21 27 | BILL DATE | Transaction bill date to be selected
Format: CCYYMMDD |
28 28 | DELIMITER | Spaces or comma (,). |
29 36 | FIELD LABEL | 'SUBCODE=' |
SUBCODES | Transaction subcodes to be selected if the bill date on the transaction matches the specified BILL-DATE. Up to seven (7) subcodes may be specified on each BILL-DATE record. | |
37 41 | SUBCODE 1 | First subcode to be selected. |
42 42 | DELIMITER | Spaces or comma (,). |
43 47 | SUBCODE 2 | Second subcode to be selected. |
48 48 | DELIMITER | Spaces or comma (,). |
49 53 | SUBCODE 3 | Third subcode to be selected. |
54 54 | DELIMITER | Spaces or comma (,). |
55 59 | SUBCODE 4 | Fourth subcode to be selected. |
60 60 | DELIMITER | Spaces or comma (,). |
61 65 | SUBCODE 5 | Fifth subcode to be selected. |
66 66 | DELIMITER | Spaces or comma (,). |
67 71 | SUBCODE 6 | Sixth subcode to be selected. |
72 72 | DELIMITER | Spaces or comma (,). |
73 77 | SUBCODE 7 | Seventh subcode to be selected. |
SIPR905 TERM control record
Example:
SIPR905:TERM=20057
12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR905' |
08 08 | DELIMITER | Space or colon (:) |
09 13 | RECORD LABEL | 'TERM=' |
14 18 | TERM | Term of transactions to be selected
Format: CCYYT |
SIPR905 INST control record
Example:
SIPR905:INST=BD 12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR905' |
08 08 | DELIMITER | Space or colon (:) |
09 13 | RECORD LABEL | 'INST=' |
14 18 | INSTITUTION | Institution of transactions to be selected |
SIPR905 AU control record
Example:
SIPR905:AU=B1,B2,B3
12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR905' |
08 08 | DELIMITER | Space or colon (:) |
09 11 | RECORD LABEL | 'AU=' |
ACADEMIC UNIT | Academic unit of transactions to be selected. Up to 3 academic units may be specified. | |
12 13 | AU 1 | First academic unit to be selected |
14 14 | DELIMITER | Space or comma (,) |
15 16 | AU 2 | Second academic unit to be selected |
17 17 | DELIMITER | Space or comma (,) |
18 19 | AU 3 | Third academic unit to be selected |
SIPR905 EXT control record
Example:
SIPR905:EXT= ****
12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR905' |
08 08 | DELIMITER | Space or colon (:) |
09 12 | RECORD LABEL | 'EXT=' |
EXTERNAL INDICATOR | External indicator of transactions to be selected. Up to five (5) external indicators may be specified. If fewer than five externals are being requested, fill the unused space with an asterisk (*) | |
13 13 | EXTERNAL 1 | First external indicator to be selected |
14 14 | EXTERNAL 2 | Second external indicator to be selected |
15 15 | EXTERNAL 3 | Third external indicator to be selected |
16 16 | EXTERNAL 4 | Fourth external indicator to be selected |
17 17 | EXTERNAL 5 | Fifth external indicator to be selected |
SIPR905 TERM control record
Example:
SIPR905:TERM=20057
12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR905' |
08 08 | DELIMITER | Space or colon (:) |
09 13 | RECORD LABEL | 'TERM=' |
14 18 | TERM | Term of transactions to be selected
Format: CCYYT |
INCL BILL-CODE control record
Example:
SIPR905:INCLUDE
BILL-CODE=AV,MB,FB,** 12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR905' |
08 08 | DELIMITER | Space or colon (:) |
09 26 | RECORD LABEL | 'INCLUDE BILL-CODE=' |
BILL CODES | Student bill codes to be selected. Up to eighteen bill codes may be specified. Delimit the string of bill codes with an asterisk (*) | |
27 28 | BILL CODE 1 | First bill code to be selected. |
29 29 | DELIMITER | Space or comma (,) |
30 31 | BILL CODE 2 | Second bill code to be selected. |
32 32 | DELIMITER | Space or comma (,) |
33 34 | BILL CODE 3 | Third bill code to be selected. |
35 35 | DELIMITER | Space or comma (,) |
36 37 | BILL CODE 4 | Fourth bill code to be selected. |
38 38 | DELIMITER | Space or comma (,) |
39 40 | BILL CODE 5 | Fifth bill code to be selected. |
41 41 | DELIMITER | Space or comma (,) |
42 43 | BILL CODE 6 | Sixth bill code to be selected. |
44 44 | DELIMITER | Space or comma (,) |
45 46 | BILL CODE 7 | Seventh bill code to be selected. |
47 47 | DELIMITER | Space or comma (,) |
48 49 | BILL CODE 8 | Eighth bill code to be selected. |
50 50 | DELIMITER | Space or comma (,) |
51 52 | BILL CODE 9 | Ninth bill code to be selected. |
53 53 | DELIMITER | Space or comma (,) |
54 55 | BILL CODE 10 | Tenth bill code to be selected. |
56 56 | DELIMITER | Space or comma (,) |
57 58 | BILL CODE 11 | Eleventh bill code to be selected. |
59 59 | DELIMITER | Space or comma (,) |
60 61 | BILL CODE 12 | Twelfth bill code to be selected. |
62 62 | DELIMITER | Space or comma (,) |
63 64 | BILL CODE 13 | Thirteenth bill code to be selected. |
65 65 | DELIMITER | Space or comma (,) |
66 67 | BILL CODE 14 | Fourteenth bill code to be selected. |
68 68 | DELIMITER | Space or comma (,) |
69 70 | BILL CODE 15 | Fifteenth bill code to be selected. |
71 71 | DELIMITER | Space or comma (,) |
72 73 | BILL CODE 16 | Sixteenth bill code to be selected. |
74 74 | DELIMITER | Space or comma (,) |
75 76 | BILL CODE 17 | Seventeenth bill code to be selected. |
77 77 | DELIMITER | Space or comma (,) |
78 79 | BILL CODE 18 | Eighteenth bill code to be selected. |
SIPR905 FINDER-FILE control record
Example:
SIPR905:FINDER-FILE=Y 12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR905' |
08 08 | DELIMITER | Space or colon (:) |
09 20 | RECORD LABEL | 'FINDER-FILE=' |
21 21 | FINDER FILE OPTION | Option specifying if the job will only process
student ids found on an id finder file. Value: Y - Yes, process using a finder file N - No, do not use a finder file (default) |
SIPR905 REPORT-FLAG control record
Example:
SIPR905:REPORT-FLAG=I 12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR905' |
08 08 | DELIMITER | Space or colon (:) |
09 20 | RECORD LABEL | 'REPORT-FLAG=' |
21 21 | REPORT FLAG | Option used to bypass students when their term report flag 7 (REGISTRATION GROUP(MULTI-VERSION) set on SIS screen 119) matches this value. |
SIPR905 Finder file format
Example:
BD 123456789 12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 02 | INSTITUTION | Institution for student to be processed |
03 03 | EXTERNAL INDICATOR | External indicator of student to be processed |
04 12 | STUDENT ID | Id number for student to be processed |
REPORT
INFO:
Processing counts
OTHER
OUTPUT:
Institution,external, SID finder file
(SIS.TEFM&app.FINDER.V&ytau) - for use as a finder file for other BR
processes
SID
finder file (SIS.TEFM&app.ID.V&ytau) - for use as a finder file for
other BR processes