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
FAQ
School CRM
DAT Functional Operator
DAT Functional Operator
DAT Functional Operator is a version of
DAT Operator
that uses system-calculated values for conditions as opposed to user-specified values as in the case with simple
DAT Operator
s. When you select one of the DAT Functional Operators, you won’t need to specify the operator values directly, as these are calculated by the system. The list of available DAT Functional Operators may change depending on the chosen table, field and data type.
- Academic Year calculates the academic year based on the current School Year in
School Info
.
- Academic Year (Admissions) calculates the academic year based on the Admissions Year in
School Info
.
- Fiscal Year (Finance) calculates the fiscal year based on the fiscal years set up in Finance.
- Fiscal Year (Development) calculates the fiscal year based on Security > Maintenance >
Application Setup
page’s Development Fiscal Date field.
-
School Division
calculates the school id to use based on your current school division. This allows the same
DAT Query
to be used in multiple divisions, but still only show division specific information. You would generally only use this for fields involving a school id such as course school id or department school id.
- Is Blank (Date) checks if no value is
specified.
- The Next (Date) checks if the specified date field’s value occurs in the next
minutes /
hours
/
days
/
months
/
quarters
/ years
as specified by you.
Note
: Date comparisons are based on school timezone information if it is specified in the application settings, otherwise server time is used.
- The Last (Date) checks if the specified date field’s value occurs in the previous
minutes /
hours
/
days
/
months
/
quarters
/ years
as specified by you.
Note
: Date comparisons are based on school timezone information if it is specified in the application settings, otherwise server time is used.
- Today always uses today’s date when you access the query.
Note
: Date comparisons are based on school timezone information if it is specified in the application settings, otherwise server time is used.
-
Other
Field allows you to do a comparison with a field appearing in the current table, or with a previous table further up the join conditions.
See also
Application Setup
School Division
DAT Operator
School Info
DAT Query
User
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
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