04/19/06 - Tetteh Pecku - *******************************************---> #cfhttp.fileContent# Select alcase.*, alclm.go_lname cname, alemp.go_lname ename from alcase, alclm, alemp where alcase.ca_clmgoid = alclm.go_goid and alcase.ca_empgoid = alemp.go_goid and alcase.ca_caid = #url.caseId# Select ev_issuedt, ev_text, ev_evid, isnull(ev_court,'ALJ') ev_court from alevents where ev_caid = #Url.CaseId# order by ev_issuedt desc

Case Number: #Get_case.ca_no#

Claimant Name: #Get_Case.cname#

Employer Name: #Get_case.ename#

Decision Date: #DateFormat(Get_case.ca_dec,"mm/dd/yyyy")#

Events Associated

#DateFormat(Get_Events.ev_issuedt,"mm/dd/yyyy")# #ListGetAt(Get_Events.ev_text,2,"^")# #Get_Events.ev_text#

Documents:
Select * from alservices where al_evid = #Get_Events.ev_evid# and al_stat = 'P' order by al_issue_date desc No document available #variables.pdfname#

#variables.htmlname# Select * from Alattach where aatransid = #get_files.altransid# AND aa_status = 'P' order by aaordnum

#Left(get_attch.aafnlname,Len(get_attch.aafnlname)-4)#.PDF

#Left(get_attch.aafnlname,Len(get_attch.aafnlname)-4)#.HTM

#cfhttp.fileContent#