TEFG

JOB NAME: TEFG

JOB TITLE: SUBCODE SELECT ID FILE EXTRACT

DESCRIPTION:
This job is a subcode driven extract that creates two output files: one file contains student IDs only, and the other file contains institution, external indicator, and student ID. IDs are selected if the student has a transaction that matches specified subcodes. Additional selection parameters include institution, term, academic unit, bill code and bill date. This job was designed for use with job TEUP$ (Calculate Short Term Student Loan Interest), but it can be used anywhere TEFF (ID File Create) finder files are used.

INPUT:
SIS database
Parm files
Subcode file

CONTROL PARAMETERS:

Title: Subcode Select ID File Create control record (SIPR724)

Example:

SIPR724;INST=BD;EXTERNALS= L***;TERM=*****;AU=B1;BDATE=********;
12345678901234567890123456789012345678901234567890123456789012345678901234567890

SIPR724;INST=BD;EXTERNALS= L*;TERM=*;AU=B1;BDATE=******; 12345678901234567890123456789012345678901234567890123456789012345678901234567890

Format:

POSITION FIELD VALUE

01 07 PROGRAM ID 'SIPR724'

08 08 DELIMITER Space or semi-colon(;)

09 13 FIELD LABEL 'INST='

14 15 INSTITUTION Institution to be selected.
Valid values:
BD - Boulder
CS - Colorado Springs
DN- Denver
HS - Health Sciences
** - all institutions

16 16 DELIMITER Space or semi-colon(;)

17 26 FIELD LABEL 'EXTERNALS='

27 31 EXTERNAL INDICATOR Up tp 5 external indicators may be entered for selection. The external indicator list is delimited by '*'. If '*****' is entered, then all externals are selected.

32 32 DELIMITER Space or semi-colon(;)

33 37 FIELD LABEL 'TERM='

38 42 TERM Term to be selected.
Format: CCYYT
If '*****' is entered,then all terms are selected.

43 43 DELIMITER Space or semi-colon(;)

44 46 FIELD LABEL 'AU='

47 48 ACADEMIC UNIT Academic unit to be selected. If '** 'is entered, then all AUs are selected.

49 49 DELIMITER Space or semi-colon(;)

50 54 FIELD LABEL 'BDATE'

55 55 COMPARISON OPERATOR Operator indicating how to compare the transaction bill date with the control record billing date.
Valid:
'>' - Greater than
'<' - Less than
'=' - Equal to

56 63 BILLING DATE Billing date to be used as a comparator to determine if a student is to be selected. Used with the comparison operator specified in column 55.
If '********' is entered, then all billing dates are used.

POSITION	FIELD	VALUE
01 07	PROGRAM ID	'SIPR724'
08 08	DELIMITER	Space or semi-colon(;)
09 13	FIELD LABEL	'INST='
14 15	INSTITUTION	Institution to be selected. Valid values: BD - Boulder CS - Colorado Springs DN- Denver HS - Health Sciences ** - all institutions
16 16	DELIMITER	Space or semi-colon(;)
17 26	FIELD LABEL	'EXTERNALS='
27 31	EXTERNAL INDICATOR	Up tp 5 external indicators may be entered for selection. The external indicator list is delimited by ''. If '****' is entered, then all externals are selected.
32 32	DELIMITER	Space or semi-colon(;)
33 37	FIELD LABEL	'TERM='
38 42	TERM	Term to be selected. Format: CCYYT If '*****' is entered,then all terms are selected.
43 43	DELIMITER	Space or semi-colon(;)
44 46	FIELD LABEL	'AU='
47 48	ACADEMIC UNIT	Academic unit to be selected. If '** 'is entered, then all AUs are selected.
49 49	DELIMITER	Space or semi-colon(;)
50 54	FIELD LABEL	'BDATE'
55 55	COMPARISON OPERATOR	Operator indicating how to compare the transaction bill date with the control record billing date. Valid: '>' - Greater than '<' - Less than '=' - Equal to
56 63	BILLING DATE	Billing date to be used as a comparator to determine if a student is to be selected. Used with the comparison operator specified in column 55. If '********' is entered, then all billing dates are used.

Title: Subcode Select ID File Create INCL/EXCL control record (SIPR724)
Note: This is an optional control record. A maximum of 500 bill codes may be specified.

Example:

SIPR724;INCL=BD,FB,UW,**
12345678901234567890123456789012345678901234567890123456789012345678901234567890

SIPR724;INCL=BD,FB,UW,** 12345678901234567890123456789012345678901234567890123456789012345678901234567890

     Format:

POSITION FIELD VALUE

1    7 PROGRAM ID 'SIPR724'     Required.

8    8 DELIMITER Space or semi-colon(;)

9 13 SELECT ACTION INCL= include the bill codes in the selection
EXCL= exclude the bill codes from the selection.

14 80 BILL CODES Bill codes to be included or excluded. Up to 23 bill codes may be specified.   End the list of bill codes with an '**' entry.

      14   15 BILL CODE 1 1st bill code.

      16   16 DELIMITER Space or comma(,)

      17   18 BILL CODE 2 2nd bill code.

      19   19 DELIMITER Space or comma(,)

      20   21 BILL CODE 3 3rd bill code.

      22   22 DELIMITER Space or comma(,)

      23 24 BILL CODE 4 4th bill code.

      25 25 DELIMITER Space or comma(,)

      26 27 BILL CODE 5 5th bill code.

      28 28 DELIMITER Space or comma(,)

      29 30 BILL CODE 6 6th bill code.

      31 31 DELIMITER Space or comma(,)

      32 33 BILL CODE 7 7th bill code.

      34 34 DELIMITER Space or comma(,)

      35 36 BILL CODE 8 8th bill code.

      37 37 DELIMITER Space or comma(,)

      38 39 BILL CODE 9 9th bill code.

      40 40 DELIMITER Space or comma(,)

      41 42 BILL CODE 10 10th bill code.

       43 43 DELIMITER Space or comma(,)

       44 45 BILL CODE 11 11th bill code.

       46 46 DELIMITER Space or comma(,)

       47 48 BILL CODE 12 12th bill code.

       49 49 DELIMITER Space or comma(,)

       50 51 BILL CODE 13 13th bill code.

       52 52 DELIMITER Space or comma(,)

       53 54 BILL CODE 14 14th bill code.

       55 55 DELIMITER Space or comma(,)

       56 57 BILL CODE 15 15th bill code.

       58 58 DELIMITER Space or comma(,)

       59 60 BILL CODE 16 16th bill code.

       61 61 DELIMITER Space or comma(,)

       62 63 BILL CODE 17 17th bill code.

       64 64 DELIMITER Space or comma(,)

       65 66 BILL CODE 18 18th bill code.

       67 67 DELIMITER Space or comma(,)

       68 69 BILL CODE 19 19th bill code.

       70 70 DELIMITER Space or comma(,)

       71 72 BILL CODE 20 20th bill code.

       73 73 DELIMITER Space or comma(,)

       74 75 BILL CODE 21 21st bill code.

       76 76 DELIMITER Space or comma(,)

       77 78 BILL CODE 22 22nd bill code.

POSITION	FIELD	VALUE
1 7	PROGRAM ID	'SIPR724' Required.
8 8	DELIMITER	Space or semi-colon(;)
9 13	SELECT ACTION	INCL= include the bill codes in the selection EXCL= exclude the bill codes from the selection.
14 80	BILL CODES	Bill codes to be included or excluded. Up to 23 bill codes may be specified. End the list of bill codes with an '**' entry.
14 15	BILL CODE 1	1st bill code.
16 16	DELIMITER	Space or comma(,)
17 18	BILL CODE 2	2nd bill code.
19 19	DELIMITER	Space or comma(,)
20 21	BILL CODE 3	3rd bill code.
22 22	DELIMITER	Space or comma(,)
23 24	BILL CODE 4	4th bill code.
25 25	DELIMITER	Space or comma(,)
26 27	BILL CODE 5	5th bill code.
28 28	DELIMITER	Space or comma(,)
29 30	BILL CODE 6	6th bill code.
31 31	DELIMITER	Space or comma(,)
32 33	BILL CODE 7	7th bill code.
34 34	DELIMITER	Space or comma(,)
35 36	BILL CODE 8	8th bill code.
37 37	DELIMITER	Space or comma(,)
38 39	BILL CODE 9	9th bill code.
40 40	DELIMITER	Space or comma(,)
41 42	BILL CODE 10	10th bill code.
43 43	DELIMITER	Space or comma(,)
44 45	BILL CODE 11	11th bill code.
46 46	DELIMITER	Space or comma(,)
47 48	BILL CODE 12	12th bill code.
49 49	DELIMITER	Space or comma(,)
50 51	BILL CODE 13	13th bill code.
52 52	DELIMITER	Space or comma(,)
53 54	BILL CODE 14	14th bill code.
55 55	DELIMITER	Space or comma(,)
56 57	BILL CODE 15	15th bill code.
58 58	DELIMITER	Space or comma(,)
59 60	BILL CODE 16	16th bill code.
61 61	DELIMITER	Space or comma(,)
62 63	BILL CODE 17	17th bill code.
64 64	DELIMITER	Space or comma(,)
65 66	BILL CODE 18	18th bill code.
67 67	DELIMITER	Space or comma(,)
68 69	BILL CODE 19	19th bill code.
70 70	DELIMITER	Space or comma(,)
71 72	BILL CODE 20	20th bill code.
73 73	DELIMITER	Space or comma(,)
74 75	BILL CODE 21	21st bill code.
76 76	DELIMITER	Space or comma(,)
77 78	BILL CODE 22	22nd bill code.

Title:    Subcode Select File record
              Note: If the extract file created by this job is going to be used as input to job TEUP$ (Short Term Student Loan Interest Calculation), the subcode select file that will be used in TEUP$ should also be used here. If the extract file will be used in processing other than TEUP$, then the LOAN SUBCODE field and/or the INTEREST SUBCODE field may be used to specify subcodes for selection. The PERCENT field will be ignored.
            If you wish to select ALL SUBCODES, enter at least one subcode with the value '*****'.

Example:

17409 16409 0100
12345678901234567890123456789012345678901234567890123456789012345678901234567890

17409 16409 0100 12345678901234567890123456789012345678901234567890123456789012345678901234567890

   Format:

POSITION FIELD VALUE

1     5 LOAN SUBCODE Subcode of the short term loan if using a file for TEUP$, otherwise, enter a numeric value of the subcode to be selected.    If '*****' is entered, all subcodes will be selected. Other non-numeric values will be ignored.

6    6 DELIMITER Space or comma(,)

7   11 INTEREST SUBCODE Subcode of the loan interest if using a file for TEUP$, otherwise, enter a numeric value of the subcode to be selected.    If '*****' is entered, all subcodes will be selected. Other non-numeric values will be ignored.

12 12 DELIMITER Space or comma(,)

13 16 PERCENT This field is used only by TEUP$. Percentage of the unpaid loan balance to be calculated as interest. Must be numeric. This field contains an implied decimal point two positions from the right. There are two degits to the left fo the decimal and 2 digits to the right of the decimal.
1% = 0100

POSITION	FIELD	VALUE
1 5	LOAN SUBCODE	Subcode of the short term loan if using a file for TEUP$, otherwise, enter a numeric value of the subcode to be selected. If '*****' is entered, all subcodes will be selected. Other non-numeric values will be ignored.
6 6	DELIMITER	Space or comma(,)
7 11	INTEREST SUBCODE	Subcode of the loan interest if using a file for TEUP$, otherwise, enter a numeric value of the subcode to be selected. If '*****' is entered, all subcodes will be selected. Other non-numeric values will be ignored.
12 12	DELIMITER	Space or comma(,)
13 16	PERCENT	This field is used only by TEUP$. Percentage of the unpaid loan balance to be calculated as interest. Must be numeric. This field contains an implied decimal point two positions from the right. There are two degits to the left fo the decimal and 2 digits to the right of the decimal. 1% = 0100

OTHER OUTPUT:
Institution/external/id finder file (SIS.TEFG.&APP..FINDER.V&YT&AU)
ID only finder file (SIS.TEFG.&APP.ID.V&YT&AU),