PCR independent school management solution and website
Customer Portal
School Portal
Request Demo
SOLUTION
FAQ
PRICING
EMPLOYMENT
BLOG
SUPPORT
KNOWLEDGE BASE
Admissions
CMS Website
Community Connect
Finance & Student Billing
Fundraising / Development
Student Information
Cafeteria POS
Summer Camp & School
301-947-7380
sales@pcreducator.com
School Information Management System & Website Software
Blog
DAT Query - Step 1 - Connecting Tables
DAT Query - Step 1 - Connecting Tables
A
DAT Query
allows you to pull data from multiple tables. The Connecting Tables mechanism allows you to connect (join) different tables in your
DAT Query
. To connect one of the tables in your
DAT Query
to a new table, navigate to
DAT Query - Step 1
(
DAT
> Queries > Query).
1. Click the [+] icon next to the table you are connecting to.
2. Choose whether you will connect “with” or “with or without”.
- If you choose “with”, the newly connected table must have data for the original table's record to show up.
- If you choose “with or without”, the original table's records will always show; however, the newly connected table might not have any data for a particular record - and those columns are empty.
Example
: Your initial table is students, and you choose to join to actions. For the actions, you are going to include
DAT Field Condition
s only for Enrolled actions in 2014/2015. If you choose “with”, only students who have such an action appear in the result set. If you choose “with or without”, then all students appear in the result set, but action fields are empty for students who do not have an Enrolled action for 2014/2015.
Note
: If you link to a table “with or without”, and additional tables connected to that table will also be linked as “with or without”.
Note
: Tables that are connected as “with or without” show as italicized.
Note
: It is entirely possible to add the same table multiple times. Suppose you want to see all your applicants for the 2014/2015 school year. You also want to see their inquiry action date, apply online date, and copied date. Many of your inquiry records for the year may or may not have apply online or copied dates. So, you connect Inquiry
Action
s to your inquiries three times: Once for action types of Inquiry for academic year 2014/2015; once for action types of Applicant; once for action types of Copied. Each of these links would be made with the “with or without” option.
See also
DAT Field Condition
DAT Query - Step 1
DAT Query
Action
DAT
PCR Educator K-12 School Information System is an online database engineered for independent and private schools to deliver the highest level of flexibility, unique experience, transparent communication and customized design. Being a complete cloud-based solution, PCR Educator system guarantees convenient access anytime, anywhere.
Facebook
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - CFO
Finance - Business Manager
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User