Accela Functions

ASI
dbo.FN_GET_APP_SPEC_INFO("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2","B1PERMIT"."B1_PER_ID3",'ASI NAME'')

Parcel Number
dbo.FN_GET_PARCEL_NBR ("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3")

Full Address
dbo.FN_GET_PRI_ADDRESS_FULL ("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3")

Another Address
dbo.FN_GET_ADDRESS_PARTIAL_ALL ("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3",'lall','')

Unit Street Address
dbo.FN_GET_ADDRESS_INFO(a.SERV_PROV_CODE, a.B1_PER_ID1, a.B1_PER_ID2, a.B1_PER_ID3,'Y','UNIT_STREETINFO')

Number of Units (parcel)
dbo.FN_GET_PARCEL_NBR_ATTRIBUTE("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3",dbo.FN_GET_PARCEL_NBR ("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3"),'Living Units')

Property Description
dbo.FN_GET_PARCEL_INFO("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3",'Legal Description')

Inspection Result Comment
dbo.FN_GET_INSP_LATEST("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3", '', 'Comment', '', '', '', '', '','Inspection Result Comment')

Latest resulted inspection
dbo.FN_GET_INSP_LATEST("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2","B1PERMIT"."B1_PER_ID3",
'', 'Result', '', '', 'RESULTED', '', '','')

Latest Inspector
dbo.FN_GET_INSP_LATEST("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3", '', 'Inspector', '', '', '', '', '', '')

Next Scheduled Inspection
dbo.FN_GET_INSP_LATEST("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2","B1PERMIT"."B1_PER_ID3",
'', 'Insp Date', '', '', 'SCHEDULED', '', '','')

Building Commissioner's Name
dbo.FN_GET_STDCHOICE_VALUEDESC('COS','BLD Commissioners Name','BLD Commissioner Name')

Housing Director's Name
,dbo.FN_GET_STDCHOICE_VALUEDESC('COS','HSG Deputy Dir Name','HSG Director Name')

Housing Director's Title
,dbo.FN_GET_STDCHOICE_VALUEDESC('COS','HSG Deputy Dir Name','HSG Director Title')

Owner Address Full
dbo.FN_GET_OWNER_INFO ("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3", '', 'MFullAddr_Block', '', 'U' )

Contact Address
dbo.FN_GET_CONTACT_INFO ("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3", 'TENANT', '', 'N', 'FullAddr_Line','','U' )

Contact Name
dbo.FN_GET_CONTACT_INFO ("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3", 'TENANT', '', 'N', 'FullName','','U' )

Licensed Professional Name
dbo.FN_GET_LICPROF_INFO("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3",'FULLNAME', 'FML','','PLUMBING')

Licensed Professional Full Address
dbo.FN_GET_LICPROF_INFO("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3",'FULLADDR_BLOCK', 'FML','','PLUMBING')

contact or owner address
case
when isnull(dbo.[FN_GET_CONTACT_INFO]("B1PERMIT"."SERV_PROV_CODE","B1PERMIT"."B1_PER_ID1","B1PERMIT"."B1_PER_ID2","B1PERMIT"."B1_PER_ID3",
'Contact', '', '', 'FullAddr_Block', '', ''),'') = '' then dbo.FN_GET_OWNER_INFO ("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3", '', 'MFullAddr_Block', '', 'U' )
else
dbo.[FN_GET_CONTACT_INFO]("B1PERMIT"."SERV_PROV_CODE","B1PERMIT"."B1_PER_ID1","B1PERMIT"."B1_PER_ID2","B1PERMIT"."B1_PER_ID3",
'Contact', '', '', 'FullAddr_Block', '', '')
end

contact or owner
case
when isnull(dbo.[FN_GET_CONTACT_INFO]("B1PERMIT"."SERV_PROV_CODE","B1PERMIT"."B1_PER_ID1","B1PERMIT"."B1_PER_ID2","B1PERMIT"."B1_PER_ID3",
'Contact', '', '', 'FullName', '', ''),'') = ' ' then dbo.FN_GET_OWNER_INFO ("B1PERMIT"."SERV_PROV_CODE", "B1PERMIT"."B1_PER_ID1", "B1PERMIT"."B1_PER_ID2", "B1PERMIT"."B1_PER_ID3", '', '', '', 'U' )
else dbo.[FN_GET_CONTACT_INFO]("B1PERMIT"."SERV_PROV_CODE","B1PERMIT"."B1_PER_ID1","B1PERMIT"."B1_PER_ID2","B1PERMIT"."B1_PER_ID3",
'Contact', '', '', 'FullName', '', '')
end