TEFM

JOB NAME: TEFM

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

***** 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

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.

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

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

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

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

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

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

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

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

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

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

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

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.

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

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)

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

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.

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

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

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