Data Access Tag - Ohio Specific

On this page:

The following describes the use of Ohio-specific Data Access Tags (DAT) specifically related to Graduation Pathways and Ohio House Bill 410 (HB410) Truancy and Chronic Absenteeism reporting on custom pages and object reports. The values will be calculated in real-time when the DAT tag is used. Entering values outside the listed information will cause one of two things to happen, either an error message will be displayed in lieu of the data with information as to what needs to be altered on the DAT to allow it to display properly, or nothing will be displayed. If nothing is displayed check the PSLog as it may have information regarding what went wrong in the display of this DAT.

This functionality is only available to users with PowerSchool 12.0 (and above) installed.

HB410 Truancy and Chronic Absenteeism Data Access Tag

Use	Base Code
Object Reports	^(*compliance;dat.name=DAT_usa_oh_studentTruancy)
Custom Pages	~(*compliance;dat.name=DAT_usa_oh_studentTruancy)

Parameters	Purpose	Options	Default
dat.studentID	Defines the student.	student ID	Currently selected student or group of students. For object reports, this parameter is required or results are not always valid. This is case sensitive. Verify you are using dat.studentId
dat.term	Defines a term to use as a date range.	A valid term abbreviation for the given school in the current year i.e. Q3 Any full-year term that contains a dash (20-21) will cause the code to break.	Not used by default. Will override supplied dat.start_date and dat.end_date if supplied.
dat.school	Defines which school to be used for the term lookup.	A valid school IRN in your district i.e. 037945	Not used by default. Required if using dat.term
dat.start_date	Define the start date for data.	Any date formatted string i.e. 07/01/2018	07/01 of the current school year
dat.end_date	Define the end date for data.	Any date formatted string i.e. 06/30/2019	06/30 of the current school year
dat.type	Define what type of data to display.	total or days (See dat.columns for a list of columns that display based on dat.type selection.)	total
dat.headers	Define if headers should be included.	on, off	on
dat.display_type	Define how to display hours.	decimal, hours	hours
dat.render_type	Define the style of output to be text or HTML.	text, html	html
dat.out_of	Define if the out of value should be shown for approaching state limits; for example, 10 / 65.	on, off	on
dat.columns	Define what columns to show and their ordering.	dat.type = total the default is "total_month,total_year,unex_consecutive,unex_month,unex_year" but any combination of those columns in any order and with any omitted is considered valid or dat.type = days the default is "att_date,school,att_code,excused_status,hours_absent,hours_exempt" but any combination of those columns in any order and with any omitted is considered valid The order in which the columns display can be changed.	all columns display based on dat.type selection
dat.calc_type	Defines whether to use the standard HB410 calculations or the FS calculations for attendance	FS, HB410	HB410

Sample code

Code

Results

^(*compliance;dat.name=DAT_usa_oh_studentTruancy;

dat.studentId=^(id);

dat.display_type=decimal;

dat.type=days;

dat.headers=off)

Absences for each day of absence will display as decimals with no headers displayed.

^(*compliance;dat.name=DAT_usa_oh_studentTruancy;

dat.studentId=^(id);

dat.start_date=10/01/2018;

dat.end_date=10/31/2018;

dat.display_type=hours)

Absence totals from 10/1/2018 through 10/31/2018 will be displayed as hours and minutes in these columns:

Total Month

Total Year

Total Unexcused Consecutive

Total Unexcused Month

Total Unexcused Year

^(*compliance;dat.name=DAT_usa_oh_studentTruancy;

dat.studentId=^(id);

dat.start_date=10/01/2018;

dat.end_date=10/31/2018;

dat.display_type=hours;

dat.type=days;

dat.columns=att_date,excused_status,hours_absent)

Absences for each day will display with date of absence, an excused or unexcused status and the number of hours absent.

The school information will not display as it is omitted in the dat.columns list.

^(*compliance;dat.name=DAT_usa_oh_studentTruancy;

dat.studentId=^(id);

dat.term=Q3;

dat.school=037945;

dat.out_of=off;

dat.headers=off;

dat.render_type=text;

dat.columns=total_year)

Absence total from the start of Quarter 3 to the end of Quarter 3 will be displayed as hours and minutes without the out of / and rendered as text for easy inclusion into form letters and object reports.

Graduation Pathways Data Access Tag

Use	Base Code
Object Reports	^(*compliance;dat.name=DAT_usa_oh_gradPathways)
Custom Pages	~(*compliance;dat.name=DAT_usa_oh_gradPathways)

Parameters	Purpose	Options	Default
dat.studentID	Defines the student	student ID	Currently selected student or group of students. For object reports, this parameter is required or results are not always valid. This is case sensitive. Verify you are using dat.studentID.
dat.headers	Define if headers should be included.	on, off	on
dat.render_type	Define the style of output to be text or HTML.	text, html	html
dat.out_of	Define if the out of value should be shown for approaching state limits; for example, 10 / 12.	on, off	on Only affects the following columns: ohio_m_points ohio_e_points ohio_sc_points ohio_total_points transfer_req_points transfer_taken_points transfer_total_points industry_workkey_points industry_num1_points industry_num2_points industry_num3_points
dat.columns	Define what columns to show and their ordering.	stu_dcid, stu_id, stu_student_number, stu_lastfirst, stu_gradyear, stu_notesyes, stu_notes, ohio_m_ouf_of, ohio_m_points, ohio_e_out_of, ohio_e_points, ohio_sc_out_of, ohio_sc_points, ohio_total_out_of, ohio_total_points, ohio_progress, transfer_req_out_of, transfer_req_points, transfer_taken_out_of, transfer_taken_points, transfer_total_out_of, transfer_total_points, transfer_progress, college_ac_eng_points, college_ac_m_points, college_ac_r_points, college_sa_m_points, college_sa_w_points, college_sa_r_points, college_progress, industry_workkey_points, industry_workkey_out_of, industry_num1_out_of, industry_num1_points, industry_num1_category, industry_num2_out_of, industry_num2_points, industry_num2_category, industry_num3_out_of, industry_num3_points, industry_num3_category, industry_progress, override_progress, total_progress	All columns display in listed order by default. Columns such as stu_notes and transfer_req_points that can return no value will show N/A when it is not applicable.

Sample code

Code	Results
^(*compliance;dat.name=DAT_usa_oh_gradPathways; dat.studentId=^(id); dat.headers=off; dat.render_type=text; dat.columns=ohio_total_points, ohio_progress, transfer_total_points, transfer_progress, college_progress, industry_num1_points, industry_progress, total_progress)	Displays just the progress and total points columns from Graduation Pathways as text without headers.
^(*compliance;dat.name=DAT_usa_oh_gradPathways; dat.studentId=^(id); dat.out_of=off; dat.headers=off; dat.render_type=text; dat.columns=ohio_total_points, ohio_progress, transfer_total_points, transfer_progress, college_progress, industry_num1_points, industry_progress, total_progress)	Displays just the progress and total points columns from Graduation Pathways as text without headers and without the out of /.
^(*compliance;dat.name=DAT_usa_oh_gradPathways; dat.studentId=^(id))	Displays all Graduation Pathways columns as an HTML styled table.
^(*compliance;dat.name=DAT_usa_oh_gradPathways; dat.studentId=^(id); dat.headers=off; dat.render_type=text; dat.columns=ohio_total_points, ohio_progress, transfer_total_points, transfer_progress, college_progress, industry_num1_points, industry_progress, total_progress)	Displays just the progress and total points columns from Graduation Pathways as text without headers.
^(*compliance;dat.name=DAT_usa_oh_gradPathways; dat.studentId=^(id); dat.out_of=off; dat.headers=off; dat.render_type=text; dat.columns=ohio_total_points, ohio_progress, transfer_total_points, transfer_progress, college_progress, industry_num1_points, industry_progress, total_progress)	Displays just the progress and total points columns from Graduation Pathways as text without headers and without the out of /.
^(*compliance;dat.name=DAT_usa_oh_gradPathways; dat.studentId=^(id))	Displays all Graduation Pathways columns as an HTML styled table.