[else]
[/if]
~(last_name), ~(first_name)
~[text]psx.html.teachers_mobile.student.gr,param:~(student_number),param:~(decode;~(grade_level);-2;PK3;-1;PK4;0;K;~(grade_level))[/text]
~[text]psx.html.teachers_mobile.student.dob,param:~(DOB)[/text]
~(age)
~[enrollmentstatus]
~[text]psx.html.teachers_mobile.student.demographics[/text]
~[text]psx.html.teachers_mobile.student.family[/text]
~[tlist_sql;SELECT
s.last_name, s.first_name,
CASE s.grade_level
WHEN -2 THEN 'PK3'
WHEN -1 THEN 'PK4'
WHEN 0 THEN 'K'
WHEN 99 THEN 'GR'
ELSE TO_CHAR(s.grade_level) END grade,
CASE s.enroll_status
WHEN 0 THEN ' '
WHEN -1 THEN 'Pre-reg'
WHEN 2 THEN 'Transferred'
WHEN 3 THEN 'Grad ' || TO_CHAR(s.sched_yearofgraduation)
ELSE 'Other' END status
FROM
relationship rel
INNER JOIN students s ON
s.person_id = rel.person_id
WHERE rel.relatedperson_id = ~(person_id)
ORDER BY s.grade_level desc;;nonemessage=- ~[text]psx.html.teachers_mobile.student.no_other_students_linked[/text]
]
- ~(last_name;t), ~(first_name;t) (~(grade;t)) ~(status;t)
[/tlist_sql]
~[text]psx.html.teachers_mobile.student.parentsguardian[/text]
~[if.~(guardianemail;keep_ascii=48-57,65-90,97-122)#]
[/if]
~[if#1.~(mother;keep_ascii=48-57,65-90,97-122)#][/if#1]
~[if#1.~(father;keep_ascii=48-57,65-90,97-122)#][/if#1]
~[if#1.~(emerg_phone_1;keep_ascii=48-57,65-90,97-122)#]~[text]psx.html.teachers_mobile.student.emergency_contact_[/text]
[/if#1]
~[if#1.~(emerg_phone_2;keep_ascii=48-57,65-90,97-122)#]~[text]psx.html.teachers_mobile.student.emergency_contact_1[/text]
[/if#1]
~[if#1.~(emerg_3_phone;keep_ascii=48-57,65-90,97-122)#]~[text]psx.html.teachers_mobile.student.emergency_contact_2[/text]
[/if#1]