Using the unusual action code dataset unusual actn d
This presentation is the property of its rightful owner.
Sponsored Links
1 / 33

USING THE UNUSUAL ACTION CODE DATASET (UNUSUAL-ACTN-D) PowerPoint PPT Presentation


  • 285 Views
  • Uploaded on
  • Presentation posted in: General

USING THE UNUSUAL ACTION CODE DATASET (UNUSUAL-ACTN-D). Dorothy Walker, Columbia Basin. 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

Download Presentation

USING THE UNUSUAL ACTION CODE DATASET (UNUSUAL-ACTN-D)

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Using the unusual action code dataset unusual actn d

USING THE UNUSUAL ACTION CODE DATASET(UNUSUAL-ACTN-D)

Using the Unusual Action Code Dataset.ppt

Dorothy Walker, Columbia Basin


Using the unusual action code dataset unusual actn d

  • 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

Using the Unusual Action Code Dataset.ppt


The file looks like this

The file looks like this:

Data fields in DETAIL data set UNUSUAL-ACTN-D

-------------------------------------------------------------------------------

1:*SID 4: .SID-3 7: ACTN-ENTR-DATE

2: .SID-1 5: BAD-DEBT-AMT 8: ACTN-ORIG-ID

3: .SID-2 6: UNUSUAL-ACTN

-------------------------------------------------------------------------------

ENTER DATA FIELD SELECTION

Using the Unusual Action Code Dataset.ppt


Sample ua records showing only sid ua students can have zero one or multiple records

Sample UA RECORDS(showing only SID & UA. Students can have zero, one or multiple records)

SID UA

-------------------

999-99-0537 F2

GR Student with 3 records

BZ

999-99-0546 23

78

999-99-0547 F2

999-99-0552 26

43

25

999-99-0559 01

999-99-0593 78

999-99-0596 E3

F3

F2

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

  • 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.

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

Data Express Procedure to List STU-D (name & sid) & UA

(Seen in “review”)

DJUASMPL(GEN.P290) created by CEIPLUS on 03-SEP-2002

------------------------------------------------------

OUTPUT FILE FORMAT: procedure execution option

OUTPUT FILE LAYOUT:

SID X(9)

UNUSUAL-ACTN X(2)

STU-NAME X(22)

SORTED BY:

SID X(10)

UNUSUAL-ACTN X(2)

SELECTED BY:

SID X(10)

and UNUSUAL-ACTN X(2)

Using the Unusual Action Code Dataset.ppt


Linkage

Linkage

FILE ACCESS PATH:

STU-D(Image set of SM)

SID X(10) SID

STU-NAME X(22) STU-NAME

UNUSUAL-ACTN-D(Image set of SM), keyed by SID

UNUSUAL-ACTN X(2) UNUSUAL-ACTN

SID X(10) SID

Using the Unusual Action Code Dataset.ppt


Enter selection values for the following data fields unusual actn f2 e3

Run procedure selecting on UA.

ENTER SELECTION VALUES FOR THE FOLLOWING DATA FIELDS: UNUSUAL-ACTNF2,E3

Report Listing

SID UA NAME

-------------------------------------------

999-99-0537 F2 KINDA E Z

999-99-0547 F2 NOTSO FUN E

999-99-0596 E3 DWIT JUSTA

F2 DWIT JUSTA

  • SID UA

  • -------------------

  • 999-99-0537 F2

  • GR

  • BZ

  • 999-99-0546 23

  • 78

  • 999-99-0547 F2

  • 999-99-0552 26

  • 43

  • 25

  • 999-99-0559 01

  • 999-99-0593 78

  • 999-99-0596 E3

  • F3

  • F2

Using the Unusual Action Code Dataset.ppt

Reads STU-D, links to UNUSUAL-ACTN-D, selects records with UA code F2,E3


Using the unusual action code dataset unusual actn d

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 oneselecting UA <> F2.

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

Run procedure with:

No Selection

UA NE F2

SID UA NAME

-------------------------------------

999-99-0537 BZ KINDA E Z

GR KINDA E Z

999-99-0546 23 FIT BENNY

78 FIT BENNY

999-99-0552 25 RAIN MICHAEL

26 RAIN MICHAEL

43 RAIN MICHAEL

999-99-0559 01 GONE RUSSELL B

999-99-0593 78 OKAY LILU B

999-99-0596 E3 DWIT JUSTA

F3 DWIT JUSTA

SID UA NAME

---------------------------------------

999-99-0537 BZ KINDA E Z

F2 KINDA E Z

GR KINDA E Z

999-99-0539 ARNOT WILLIE

999-99-0540 AGAIN JOSE

999-99-0546 23 FIT BENNY

78 FIT BENNY

999-99-0547 F2 SNEAD SAM

999-99-0552 25 RAIN MICHAEL

26 RAIN MICHAEL

43 RAIN MICHAEL

999-99-0559 01 GONE RUSSELL B

999-99-0587 BATTER CASEY L

999-99-0593 78 OKAY LILU B

999-99-0595 WHILE TERRY A

999-99-0596 E3 DWIT JUSTA

F2 DWIT JUSTA

F3 DWIT JUSTA

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

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.)

Using the Unusual Action Code Dataset.ppt


What does work

WHAT DOES WORK?

Using the Unusual Action Code Dataset.ppt


Two passes

TWO PASSES:

  • PASS 1 – BUILD KSAM FILE OF SIDs SELECTING ON UA

  • PASS 2 – LINK TO KSAM FILE WITH “–” (SELECT IF MISSING)

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

Pass 1 – Create KSAM SD file – “Review”

  • CAUASID(GEN.P290) created by CEIPLUS on 05-JUL-2001 ----------------------------------------------------------------------OUTPUT FILE FORMAT: Binary (storage format),KSAM file, SD labelsOUTPUT FILE LAYOUT: Suppress detail records SID X(10)SORTED BY: SID X(10)SELECTED BY: UNUSUAL-ACTN X(2)

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

FILE ACCESS PATH: UNUSUAL-ACTN-D(Image set of SM) SID X(10) SID UNUSUAL-ACTN X(2) UNUSUAL-ACTNFIELD DEFINITIONS: SID X(9), X(10) UNUSUAL-ACTN-D picture edit: "^^^-^^-^^^^" UNUSUAL-ACTN X(2) UNUSUAL-ACTN-D heading: "UA"FILE DEFINITIONS: UNUSUAL-ACTN-D Image set of SM HP Dictionary DICT.PUB.PLIB

Using the Unusual Action Code Dataset.ppt


Sample output selecting ua f2

Sample Output selecting UA = F2:

SID

----------------

999000048

999000062

999000088

999000091

999000105

999000131

999000279

999000289

999000330

999000352

999000366

999000391

Save in a KSAM SD file with key of SID.(File named $UASIDS)

Using the Unusual Action Code Dataset.ppt


Write procedure for pass 2

Write Procedure for Pass 2 –

MAIN MENU

-----------------------------------------------------

1: DISPLAY procedure catalog

2: RUN an existing procedure

3: CREATE a new procedure

4: MAINTAIN an existing procedure

8: EXIT

-----------------------------------------------------

Reflection W1 (7.00)

ENTER AN OPTION NUMBER 3

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

CREATE a new procedure

-------------------------------------------------------

1: Use HP DICTIONARY definitions

2: Use HP IMAGE root file definitions

3: Use HP Allbase SQL definitions

  4: Use FILE definitions

7: RETURN

-------------------------------------------------------

ENTER AN OPTION NUMBER 4

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

Use FILE definitions

--------------------------------------------------------

1: ENTER your own file definitions

2: Use File-Definition (FD) file

3: Use Self-Describing (SD) file

5: Use DataExpress subfile

--------------------------------------------------------

ENTER AN OPTION NUMBER 3

DataExpressCenter

Use Self-Describing (SD) file

--------------------------------------------------------

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

SD file name $UASIDS

File in local file group (Y/n)?

Data fields in KSAM SD file $UASIDS

------------------------------------------------------

1:*SID

------------------------------------------------------

 ENTER DATA FIELD SELECTION 1

Define output specifications

------------------------------------------------------

1: SID

------------------------------------------------------

ADD ANY MORE FIELDS OR FILES (N/y)? Y

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

Existing files in procedure

-------------------------------------------------

1: $UASIDS

------------------------------------------------

  Press <Enter> key to select a new file

SELECT AN EXISTING FILE

Existing definition files in procedure

-------------------------------------------------

1: $UASIDS

-------------------------------------------------

  Press <Enter> key to select a new definition source

SELECT AN EXISTING DEFINITION FILE

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

-----------------------------------------------

1: Use HP DICTIONARY definitions

2: Use HP IMAGE root file definitions

4: Use FILE definitions

7: RETURN

----------------------------------------------

ENTER AN OPTION NUMBER 1

DataExpressCenter

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

Use HP DICTIONARY definitions

---------------------------------------------------------

2: Use HP IMAGE data base definitions

3: Use KSAM/MPE file definitions

---------------------------------------------------------

ENTER AN OPTION NUMBER 2

DataExpressCenter

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

Use HP IMAGE data base definitions

---------------------------------------------------------

1: Display IMAGE data base names

2: Select a specific IMAGE data base

3: Select a specific IMAGE data set

---------------------------------------------------------

ENTER AN OPTION NUMBER 2

DataExpressCenter

Select a specific IMAGE data base

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

  • IMAGE data base name SM DataExpressCenterData sets in data base SM 1 of 3------------------------------------------------------------------------------- 1: ADMIN-UNIT-M 17: COURSE-ASSGN-D 33: STU-D 2: ADMIN-UNIT-D 18: COURSE-CLASS-D 34: STU-M 3: ADV-A 19: COURSE-CONSTR-D 35: STU-NAME-A 4: ADV-D 20: COURSE-D 36: STU-OPT-D 5: ALT-ADDR-M 21: COURSE-DESC-D 37: STU-YRQ-M 6: APPROVE-PRG-M 22: DEPT-DIV-M 38: STU-TYP-M 7: APPT-A 23: EDUC-PRG-M 39: STU-YRQ-XREF-D 8: APPT-D 24: FOOTNOTE-M 40: TEST-SCORE-D 9: CLASS-A 25: HIST-ARCHV-M 41: UNUSUAL-ACTN-D 10: CLASS-CLUSTER-M 26: INSTR-A 42: UNUSUAL-CD-M 11: CLASS-D 27: INSTR-ROOM-D 43: WLIST-D 12: CONSTR-A 28: MISC-STU-A 44: YRQ-A 13: CONSTR-CLUSTER-M 29: PREV-NAME-D 45: PRG-ALT-AYR-M 14: CONSTR-D 30: YRQ-M 46: COURSE-DESC2-D 15: CONSTR-ROOM-D 31: ROOM-LOC-A 47: COURSE-TITLE2-D 16: COURSE-A 32: STU-CLASS-D 48: STU-PROFILE-D------------------------------------------------------------------------------- ENTER DATA SET SELECTION 39,33

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

Data fields in DETAIL data set STU-YRQ-XREF-D

-------------------------------------------------------------

1:*SID 4: .SID-3 7: .SQ-YRQ

2: .SID-1 5:*STU-QTR 8:*YRQ

3: .SID-2 6: .SQ-SID

-------------------------------------------------------------

ENTER DATA FIELD SELECTION 8

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

Data fields in DETAIL data set STU-D 2 of 2

------------------------------------------------------

1:*SID 14: STU-NAME 27: STU-WORK-ATTND

2: .SID-1 15: STU-PRG-APPL 28: STU-PRIOR-EDUC

3: .SID-2 16: STU-TYP 29: CENSUS-RACE-CD

4: .SID-3 17: TIME-PREF 30: CENSUS-HISP-CD

5: STU-DAY-PHONE 18: TRNSFR-COL-CR 31: BAD-ADDR-CD

6: .DAY-AREA-CODE 19: VET-BENE 32: STU-INT

7: .DAY-PREFIX 20: YRQ-ACT-STRT 33: STU-PRG-ENR

8: .DAY-SUFFIX 21: YRQ-PLAN-STRT 34: HI-SCHL-GR-LVL

9: STU-ENR-STAT 22: CLVL-GR-PTS 35: CUM-HR-EARN

10: STU-EVE-PHONE 23: CUM-GR-PTS 36: CUM-GPA-HR

11: .EVE-AREA-CODE 24: STU-ORIG-CD 37: TRNSFR-COL-HR

12: .EVE-PREFIX 25: STU-FAM-STAT

13: .EVE-SUFFIX 26: STU-PLAN-ATTND

-------------------------------------------------------

ENTER DATA FIELD SELECTION 1,14

SID FIELD HAS ALREADY BEEN SELECTED

DELETE THIS DUPLICATE FIELD NAME (N/y)? N

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

Define output specifications

---------------------------------------------

1: SID 3: SID

2: YRQ 4: STU-NAME

---------------------------------------------

   ADD ANY MORE FIELDS OR FILES (N/y)?

  EDIT FIELD DEFINITIONS (N/y)?

  ADD ANY COMPUTATIONAL FIELDS (N/y)?

  INCLUDE IN OUTPUT 3,4

SORT BY 3

SUMMARIZE BY

  SUPPRESS DETAIL RECORDS (N/y)?

  SELECT BY 2

ARE THE SPECIFICATIONS CORRECT (Y/n)?

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

Multi-file access order

---------------------------------------

1: $UASIDS 3: STU-D

2: STU-YRQ-XREF-D

---------------------------------------

THE FOLLOWING FILE(S) ARE REQUIRED TO BE LINKED: 2 3

FILE ACCESS AND LINKAGE ORDER 2,3,-1

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

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

-----------------------------------------------

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

-----------------------------------------------

1:*ABBR-LAST-NAME 2:*SID

-----------------------------------------------------

SELECT THE KEY FIELD from STU-D 2

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

DataExpressCenter

Linking from data set STU-D to file $UASIDS 1 of 2

----------------------------------------------------------------------

1:*ABBR-LAST-NAME 17: ECON-DISAD-IND 33: OPT-2

2: ACAD-DISAD-IND 18: ETH-ORIG 34: PLAN-TO-GRAD

3: ADM-NUM 19: FEE-PAY-STAT 35: PREV-COL-1

4: ADM-STAT 20: HI-SCHL 36: PREV-COL-GRAD-1

5: ADV-ID 21: HI-SCHL-GRAD 37: PREV-COL-TRAN-1

6: APP-RCPT-DATE 22: HI-SCHL-LAST-YR 38: PREV-COL-YR-1

7: BA-GRAD 23: HI-SCHL-TRAN 39: PREV-COL-2

8: BRANCH 24: HEALTH-LIM 40: PREV-COL-GRAD-2

9: BIRTH-DATE 25: HNDCP-STAT 41: PREV-COL-TRAN-2

10: CITZ-STAT 26: LAST-YRQ-ATTND 42: PREV-COL-YR-2

11: CLVL-CR-EARN 27: LIM-ENGL-IND 43: REC-FEE-IND

12: CLVL-GPA 28: STU-CITY 44: REG-DEPOSIT-IND

13: CLVL-GPA-CR 29: STU-ST 45: RES-STAT

14: CUM-CR-EARN 30: STU-STREET 46: SEX

15: CUM-GPA 31: STU-ZIP 47:*SID

16: CUM-GPA-CR 32: OPT-1 48: STU-DAY-PHONE

-------------------------------------------------------------------------

SELECT THE LINK FIELD from STU-D 47

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

Report Listingof $UASIDSSID

----------------

999000048

999000062

999000088

999000091

999000105

999000131

999000279

999000289

999000330

999000352

999000366

999000391

Report Listing page 1 of 303

  SID NAME

-----------------------------------------------

999-00-0007 YXXXX EXXXXX L

999-00-0050 NXXXXXXXX XXM

999-00-0059 PXXXXX XXXXXXS A

999-00-0083 GXXXXXX-XXXL XXXXXXA C

999-00-0114 BXXXXXXX XXXXXXXIE

999-00-0133 JXXXXX XXXXXA E

999-00-0134 JXXXXXX MXXXXXXE E

999-00-0158 TXXXXXXXXX NXXXXXXXX R

999-00-0211 GXXXXXXXXXX KKKKKKKIE S

999-00-0331 CXXXXX JXXXXXXX K

999-00-0344 GXXXX MXXXX N

999-00-0360 XXXXXX XXXXXXX X

999-00-0398 XXXX XXXXXX X

999-00-0425 XXXXXX XXXXXXXX

999-00-0454 XXXXXX XXXXXXX X

999-00-0505 XXXXX XXXXXXXXX

Using the Unusual Action Code Dataset.ppt


Using the unusual action code dataset unusual actn d

?

Using the Unusual Action Code Dataset.ppt


  • Login