2
1/8/03Using the Unusual Action Code Dataset.ppt Unusual Action Codes are used to tell you something about the student which is not easily available elsewhere in the SM database. For example, we use UA Codes to identify –Financial aid recipients –VA funded students –Agency sponsored students –Students who don’t want any information released –Those with outstanding library fines

5
1/8/03Using the Unusual Action Code Dataset.ppt As long as you are looking for students who HAVE a particular unusual action code, the Data Express procedure to accomplish this is very straightforward.

9
1/8/03Using the Unusual Action Code Dataset.ppt Suppose you want to use the same procedure to list all students who DO NOT HAVE unusual action code of F2. They could have no unusual action code records or records with other unusual action codes. The following slide shows 2 listings side by side, one from the procedure run with no selection, and one selecting UA <> F2.

11
1/8/03Using the Unusual Action Code Dataset.ppt You will have a record in your record set for every UNUSUAL-ACTN-D record <> “F2” matching a selected SID from STU-D. (i.e. Some students will have multiple records.) Selecting on the secondary file (UNUSUAL-ACTN-D) eliminates from the record set STU-D records with no matching unusual action code record. (i.e. Students with no unusual action code will not appear on the list.)

30
1/8/03Using the Unusual Action Code Dataset.ppt IS THERE A DEFINED PATH BETWEEN DATA SETS (Y/n)? N DataExpressCenter Linking from data set STU-YRQ-XREF-D to data set STU-D :*SID 2:*STU-QTR 3:*YRQ SELECT THE LINK FIELD from STU-YRQ-XREF-D 1 Linking from data set STU-YRQ-XREF-D to data set STU-D :*ABBR-LAST-NAME 2:*SID SELECT THE KEY FIELD from STU-D 2