rules and stuff linda wirgau data specialist. what are the mnemonics
TRANSCRIPT
![Page 1: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/1.jpg)
Rules and StuffLinda Wirgau
Data Specialist
![Page 2: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/2.jpg)
What are the mnemonics
![Page 3: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/3.jpg)
RFEI – File Element Inquiry
![Page 4: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/4.jpg)
RFEI – File Element Inquiry
D Data – single valued field (example: First Name) L List – multi-valued (example: address.lines; house
number and street on one line then apt number on another)
Q pointer – multi-valued pointer (example: parent child relationships)
X pointer – single valued pointer (points to one and only one record in another file…example: Citizenship and countries
A Associated – multi-valued in a file that relates to one or more fields in that file (example: app.career.goals and app.career.goal.change.dates)
T Text – its text
![Page 5: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/5.jpg)
Work from the top down
◦Big bucket first All applicants is probably too big we have 126K
applicant records◦Try instead applicants with a Start term of 2013FA,
2013WI or 2013SP◦Then try Freshman and not Transfers ◦Do you want international in this rule ?
![Page 6: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/6.jpg)
RLDE – Rules Definition
![Page 7: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/7.jpg)
Connectors – what?! Why?!
With – use with to start a grouped set of conditions and connect it to the previous set
And – use to connect the previous line with the current line (note: the record must pass both sets of criteria for a true to result)
Every – use to check every value within a multi-valued field (note: each value in the list must meet the criteria for a true to result)
Or – use to connect with the previous line (note: only one needs to result true for the record to pass)
Or Every – use when you want to connect the previous line of criteria with the current line and want a record to pass one or the other. (note: remember what “every” does? It also applies here)
Or With – use to start a new grouped set of conditions and to connect to the previous set where you want one set or the other to pass
Or With Every - use to start a new grouped set of conditions and to connect to the previous set where you want one set or the other to pass but now add “every”
With Every – use to start a grouped set of conditions and to also check every value within a multi-valued field
![Page 8: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/8.jpg)
RLDE – Rules Definition
![Page 9: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/9.jpg)
RLDT – rules definition detail
![Page 10: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/10.jpg)
RLDE – Rules Definition
![Page 11: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/11.jpg)
Easy right?!
Work from the top downChoose the big bucket firstTry and stick to the easy connectors
![Page 12: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/12.jpg)
RLTD - Test and Debug
When testing◦Find a few id’s that pass and fail your rule!
![Page 13: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/13.jpg)
RLTD – Rules Test (should fail)
![Page 14: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/14.jpg)
RLTD – page 2
![Page 15: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/15.jpg)
RLTD – Rules Test (should pass)
![Page 16: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/16.jpg)
RLTD – Rules Test (whew! It passed!)
![Page 17: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/17.jpg)
Assign a territory rule to a counselor!
Rules sit unless you use them somewhereTo assign a counselor using the rule you
just wrote you’ll need to use form ARAR
![Page 18: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/18.jpg)
ARAR – Adm Rep assignment rules
![Page 19: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/19.jpg)
ARAR – list of rules
![Page 20: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/20.jpg)
RLPC – Rules Processing Form
Just because I think its cool!
![Page 21: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/21.jpg)
RLPC – Rules Savelist Processing
![Page 22: Rules and Stuff Linda Wirgau Data Specialist. What are the mnemonics](https://reader031.vdocuments.us/reader031/viewer/2022032722/56649f465503460f94c68052/html5/thumbnails/22.jpg)
Rules processing results