Address data in SIS is stored in a file called SIS-ADDRESSES. There are ten possible addresses for each student and each address may have up to five address usage codes. For example, a student may have a local address, a permanent address, and a next of kin address. If the permanent and next of kin addresses are the same, it is stored once in the file and assigned two address usage codes (P and N). This storage configuration makes it difficult to extract specific addresses from the address file for inclusion on a Super Natural report.
MIS has developed a user exit program to process addresses. A user exit is a subprogram that you can call from within the transaction, which is run when the transaction is run.
Including SIS addresses in a Super Natural transaction is a 5 step process.
To define a new field in a transaction, move the cursor to any of the blank lines on the Worksheet and type a name for the new field. Press Enter and the Define User Field window appears.
The first field necessary for processing address information is one to hold the address preference types. You must name the field ADR-TYPE, and specify the format as A, and the length as 5.
SNADDR - Worksheet - SN3011
Ref DB Field Name ***************** Define User Field ******************
AC 1S TERM-COLLEGE .. * Field: ADR-TYPE *
AI 1 2 RT010-SID ..... * *
DE LK 3 AA-SID ........ * Name or value .. ADR-TYPE________________________ *
DF L 3 AA-ST-FULL-NAME * Format ......... a *
DG _______________ * Length ......... 5__ *
DH _______________ * Dec. places .... _ *
DI adr-type_______ * Subfield of .... ________________________________ *
DJ _______________ * Offset ......... ___ *
DK _______________ * Dynamic input .. _ *
DL _______________ * *
DM _______________ ******************************************************
DN ________________________________ ___ ___ __ __ __ __
DO ________________________________ ___ ___ __ __ __ __
DP ________________________________ ___ ___ __ __ __ __
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Flip Canc
Repeat the field definition process for eight (8) more fields for a total
of nine (9) fields. Use the following
names, format, and length. You will get an error when running your
transaction with the user exit if you do
not have these fields defined with the specific format and length.
Name or value: Format Length STREET1 A 32 STREET2 A 32 CITY A 20 STATE A 2 ZIP A 9 COUNTRY A 2 PHONE N 10 Decimal Positions: 0 ADR-TYPE-RETURNED A 1
The resulting list of fields will look something like this:
10:15 ***** SUPER NATURAL ***** 96-11-12
SNADDR - Worksheet - SN3011
More: +
Ref DB Field Name Seq S/C Func Def Info Del
AC 1S TERM-COLLEGE ................... ___ ___ __ __ __ __
AI 1 2 RT010-SID ...................... ___ ___ __ __ __ __
DE LK 3 AA-SID ......................... ___ ___ __ __ __ __
DF L 3 AA-ST-FULL-NAME ................ ___ ___ __ __ __ __
DG U ADR-TYPE ....................... ___ ___ __ __ __ __
DH U STREET1 ........................ ___ ___ __ __ __ __
DI U STREET2 ........................ ___ ___ __ __ __ __
DJ U CITY ........................... ___ ___ __ __ __ __
DK U STATE .......................... ___ ___ __ __ __ __
DL U ZIP ............................ ___ ___ __ __ __ __
DM U COUNTRY ........................ ___ ___ __ __ __ __
DN U PHONE .......................... ___ ___ __ __ __ __
DO U ADR-TYPE-RETURNED .............. ___ ___ __ __ __ __
DP ________________________________ ___ ___ __ __ __ __
Fill in required definitions
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Next Exit Field Incl Flip - + Sel Run Canc
Return to Index
At the Command prompt, type CALC and press ENTER to invoke the calculation editor.
Command ===> calc
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Next Exit Field Incl Flip - + Sel Run Canc
The Calculation Editor looks like this and works very similarly to the Selection Editor:
14:01 ***** SUPER NATURAL ***** 96-11-12
SNADDR - Calculation Editor - SNZUL-C
1 < > 1
2 < > 2
3 < > 3
4 < > 4
5 < > 5
6 < > 6
7 < > 7
8 < > 8
9 < > 9
10 < > 10
11 < > 11
12 < > 12
13 < > 13
14 < > 14
15 < > 15
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Next Exit Field Check Flip - + Cont Run Canc
The ADR-TYPE field which is 5 alphanumeric characters long, is assigned the values that will be passed to the user exit to define the order in which addresses are to be selected from each student's address record. Many address usage codes are defined in SIS (on SIS screen 003, position the cursor on one of the lines under Usage, and press PF2 to see the complete list). The most common codes used to select addresses for labels are L for local, P for Permanent, N for next of Kin, B for Billing and G for Grading (the address where a student's grade report is sent). However, any of the defined usage codes may be used.
Up to five usage codes can be specified. For example, LPN, LP, and LBGPN are valid values to assign to ADR-TYPE. All give priority to the local address. The program will look in the address file for each student to determine if that student has a local address (the left most address usage code specified in the calc line). If the student has a local address the user exit will return that address to the new fields in the Super Natural transaction. If the student does not have a local address, the user exit searches for the second address usage code and continues until an address is found.
Specify the address usage code as Local, Permanent, and Next of Kin, in that order by entering the following calc statement:
SNADDR - Calculation Editor - SNZUL-C
1 < ADR-TYPE='LPN' > 1
2 < > 2
Return to Index
Command ===> userexit
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Next Exit Field Incl Flip - + Sel Run Canc
Use the Exit Specification screen to identify the name of the
program that retrieves addresses for
students. Also indicate at what point the program is to run. For
example, if you want to sort by ZIPCODE,
you need to place the program name on line 5 (see screen below).
This tells Super Natural to run the user exit
program before sorting. You must also specify that the program requires
parameters by typing a Y in the
Parameter column. The program name for retrieving addresses from
the SIS address file is SIUADDR.
14:42 ***** SUPER NATURAL ***** 96-11-12
SNADDR - Exit Specification - SN3500
Exit Exit NATURAL Parameter Exit Location
No. Program Object List
1 ________ _ _ At start
2 ________ _ _ Before primary file read
3 ________ _ _ Before secondary file read
4 ________ _ _ Before lookup, logic & calculations
5 SIUADDR_ S y Before external/buffer sort
6 ________ _ _ After external/buffer sort
7 ________ _ _ Before work/PC-write & add/update
8 ________ _ _ Before report output
9 ________ _ _ Before end of read loop(s)
10 ________ _ _ At end
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Next Exit Flip Sel Run Canc
Return to Index
************ Exit Parameter ****************
* Mark required parameters with a number *
* between 1 and 40 *
* __ RTKEY-TERM-SID *
* __ TERM-COLLEGE *
* __ TERM-DEGREE *
* __ TERM-MAJOR *
* __ TERM-ACAD-ACT *
* __ RT005-TERM-CODE *
* 1_ RT010-SID *
* __ RT020-CUR-RHRS *
* __ RT025-CUR-EHRS *
* __ RT030-CUR-QHRS *
* __ RT035-CUR-QPTS *
* __ RT040-CUR-GPA *
* *
*** More: + ******************************
Press PF8 to advance to the next screen of fields until you see the
ADR-TYPE and address fields on the screen. Type numbers 2 through 10 on
these fields.
************ Exit Parameter ****************
* Mark required parameters with a number *
* between 1 and 40 *
* __ RT26L-PGM1-CUM-AHRS *
* __ RT26G-PGM1-CUM-EHRS *
* __ RT26H-PGM1-CUM-QHRS *
* __ RT26I-PGM1-CUM-QPTS *
* __ RT26J-PGM1-CUM-GPA *
* __ RT26K-PGM1-CUM-DEF-PTS *
* __ RT296-SPE-SEGM-CNT *
* __ RT299-STF-MAINT-DAT *
* __ AA-SID *
* __ AA-ST-FULL-NAME *
* 2_ ADR-TYPE *
* 3_ STREET1 *
* *
*** More: - + ******************************
********** Exit Parameter ******************
* Mark required parameters with a number *
* between 1 and 40 *
* 4_ STREET2 *
* 5_ CITY *
* 6_ STATE *
* 7_ ZIP *
* 8_ COUNTRY *
* 9_ PHONE *
* 10 ADR-TYPE-RETURNED *
* __ *
* __ *
* __ *
* __ *
* *
*** More: - ******************************
Press ENTER after all fields have been numbered, and then press PF3 to return to the worksheet.
SNADDR - Worksheet - SN3011
More: +
Ref DB Field Name Seq S/C Func Def Info Del
AC 1S TERM-COLLEGE ................... ___ ___ __ __ __ __
AI 1 2 RT010-SID ...................... ___ ___ __ __ __ __
DE LK 3 AA-SID ......................... ___ ___ __ __ __ __
DF L 3 AA-ST-FULL-NAME ................ 1__ ___ __ __ __ __
DG U ADR-TYPE ....................... ___ ___ __ __ __ __
DH U STREET1 ........................ 2A_ ___ __ __ __ __
DI U STREET2 ........................ 2B_ ___ __ __ __ __
DJ U CITY ........................... 2C_ ___ __ __ __ __
DK U STATE .......................... 2D_ ___ __ __ __ __
DL U ZIP ............................ 2E_ ___ __ __ __ __
DM U COUNTRY ........................ ___ ___ __ __ __ __
DN U PHONE .......................... 3__ ___ __ __ __ __
DO U ADR-TYPE-RETURNED .............. 4__ ___ __ __ __ __
15:38:37 AC = '96FAS' 96-11-12
ISNADDR 2
NAME STREET1 PHONE A
----------------------- ------------------------- ------------ -
Gibson, Mel 10 Star Court 901-555-0100 L
Los Angeles
CA
91701-
Blowfish, Hootie N. 100 Rock Lane 302-555-1437 P
Rockwood
Newark
DE
19713-
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Print Exit Flip + Posi < > Canc
Return to Index
Command ===> modes
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Next Exit Field Incl Flip - + Sel Run Canc
The following window appears:
**** Transaction Modes Reporting *****
* *
* Data Selection .. F Full-screen *
* *
* Data Change ..... N None *
* *
* Report Type ..... L List *
* Report Level .... D Detailed *
* *
* Destination ..... S Screen *
* *
* Run Mode ........ O Online *
* *
* Batch printer ... 0 (0 - 31) *
* RJE available ... Y (Y/N) *
* *
**************************************
Change the Destination to W if you are creating a mainframe workfile for address labels. Change
Destination to F, if you are writing data to a PC file. You must have the software package,"Entire
Connection" on your PC to use the F destination.
For address labels, the Run Mode must be B for batch, and the Batch Printer number set to 1. For a PC file, the RUN MODE must be O for online. Change the Run Mode to meet your needs and press ENTER.
Number the fields you want to extract in the SEQ column just as you do for reporting, except that the vertical display convention is not allowed for extracting data. The data will be extracted as a single line of data for each student. Spaces will appear between the fields only if the field is not completely filled with data. For example, the SSN field is completely filled with data (9 characters in a field of length 9), but the name field is rarely filled since name has a field length of 32.
When you run or save the transaction the following window appears. Press ENTER when you see this message to continue to save or run your transaction.
***** Work-/PC File Information *****
* *
* Destination ......... W *
* Output Record Size .. 138 *
* *
* _ Continue *
* _ Write Headers and Continue *
* _ Modify Transaction *
* *
*************************************
Forward to : Address Labels
Back to: Super Natural Home Page