Domain > pac.piercecountywa.gov

More information on this domain is in AlienVault OTX

DNS Resolutions

Date	IP Address
2020-05-15	13.224.12.112 (ClassC)
2026-03-05	3.169.173.108 (ClassC)

HTTP/1.1 200 OKContent-Type: text/htmlContent-Length: 151262Connection: keep-aliveDate: Thu, 05 Mar 2026 14:14:28 GMTLast-Modified: Sat, 20 Nov 2021 00:45:09 GMTETag: 3b7beb5f4567f04fba6fb2ffb9edce27x-amz-server-side-encryption: AES256Accept-Ranges: bytesServer: AmazonS3X-Cache: Miss from cloudfrontVia: 1.1 11017c4db22106ac70e16ce75190a430.cloudfront.net (CloudFront)X-Amz-Cf-Pop: HIO52-P4X-Amz-Cf-Id: ZUWvWtVHH5ufPYdi1EKimxTrZW1O9ivA9JBnREXqdfwXE_ZG54wsug

!DOCTYPE html>html langen>head>meta charsetUTF-8>!--if IE>meta http-equivX-UA-Compatible contentIEedge>!endif-->meta nameviewport contentwidthdevice-width, initial-scale1.0>meta namegenerator contentAsciidoctor 1.5.8>meta nameauthor contentPierce County Developers>title>Pierce Application Core/title>link relstylesheet hrefhttps://fonts.googleapis.com/css?familyOpen+Sans:300,300italic,400,400italic,600,600italic%7CNoto+Serif:400,400italic,700,700italic%7CDroid+Sans+Mono:400,700>style>/* Asciidoctor default stylesheet | MIT License | http://asciidoctor.org *//* Uncomment @import statement below to use as custom stylesheet *//*@import https://fonts.googleapis.com/css?familyOpen+Sans:300,300italic,400,400italic,600,600italic%7CNoto+Serif:400,400italic,700,700italic%7CDroid+Sans+Mono:400,700;*/article,aside,details,figcaption,figure,footer,header,hgroup,main,nav,section,summary{display:block}audio,canvas,video{display:inline-block}audio:not(controls){display:none;height:0}script{display:none!important}html{font-family:sans-serif;-ms-text-size-adjust:100%;-webkit-text-size-adjust:100%}a{background:transparent}a:focus{outline:thin dotted}a:active,a:hover{outline:0}h1{font-size:2em;margin:.67em 0}abbrtitle{border-bottom:1px dotted}b,strong{font-weight:bold}dfn{font-style:italic}hr{-moz-box-sizing:content-box;box-sizing:content-box;height:0}mark{background:#ff0;color:#000}code,kbd,pre,samp{font-family:monospace;font-size:1em}pre{white-space:pre-wrap}q{quotes:\201C \201D \2018 \2019}small{font-size:80%}sub,sup{font-size:75%;line-height:0;position:relative;vertical-align:baseline}sup{top:-.5em}sub{bottom:-.25em}img{border:0}svg:not(:root){overflow:hidden}figure{margin:0}fieldset{border:1px solid silver;margin:0 2px;padding:.35em .625em .75em}legend{border:0;padding:0}button,input,select,textarea{font-family:inherit;font-size:100%;margin:0}button,input{line-height:normal}button,select{text-transform:none}button,html inputtypebutton,inputtypereset,inputtypesubmit{-webkit-appearance:button;cursor:pointer}buttondisabled,html inputdisabled{cursor:default}inputtypecheckbox,inputtyperadio{box-sizing:border-box;padding:0}button::-moz-focus-inner,input::-moz-focus-inner{border:0;padding:0}textarea{overflow:auto;vertical-align:top}table{border-collapse:collapse;border-spacing:0}*,*::before,*::after{-moz-box-sizing:border-box;-webkit-box-sizing:border-box;box-sizing:border-box}html,body{font-size:100%}body{background:#fff;color:rgba(0,0,0,.8);padding:0;margin:0;font-family:Noto Serif,DejaVu Serif,serif;font-weight:400;font-style:normal;line-height:1;position:relative;cursor:auto;tab-size:4;-moz-osx-font-smoothing:grayscale;-webkit-font-smoothing:antialiased}a:hover{cursor:pointer}img,object,embed{max-width:100%;height:auto}object,embed{height:100%}img{-ms-interpolation-mode:bicubic}.left{float:left!important}.right{float:right!important}.text-left{text-align:left!important}.text-right{text-align:right!important}.text-center{text-align:center!important}.text-justify{text-align:justify!important}.hide{display:none}img,object,svg{display:inline-block;vertical-align:middle}textarea{height:auto;min-height:50px}select{width:100%}.center{margin-left:auto;margin-right:auto}.stretch{width:100%}.subheader,.admonitionblock td.content>.title,.audioblock>.title,.exampleblock>.title,.imageblock>.title,.listingblock>.title,.literalblock>.title,.stemblock>.title,.openblock>.title,.paragraph>.title,.quoteblock>.title,table.tableblock>.title,.verseblock>.title,.videoblock>.title,.dlist>.title,.olist>.title,.ulist>.title,.qlist>.title,.hdlist>.title{line-height:1.45;color:#7a2518;font-weight:400;margin-top:0;margin-bottom:.25em}div,dl,dt,dd,ul,ol,li,h1,h2,h3,#toctitle,.sidebarblock>.content>.title,h4,h5,h6,pre,form,p,blockquote,th,td{margin:0;padding:0;direction:ltr}a{color:#2156a5;text-decoration:underline;line-height:inherit}a:hover,a:focus{color:#1d4b8f}a img{border:none}p{font-family:inherit;font-weight:400;font-size:1em;line-height:1.6;margin-bottom:1.25em;text-rendering:optimizeLegibility}p aside{font-size:.875em;line-height:1.35;font-style:italic}h1,h2,h3,#toctitle,.sidebarblock>.content>.title,h4,h5,h6{font-family:Open Sans,DejaVu Sans,sans-serif;font-weight:300;font-style:normal;color:#ba3925;text-rendering:optimizeLegibility;margin-top:1em;margin-bottom:.5em;line-height:1.0125em}h1 small,h2 small,h3 small,#toctitle small,.sidebarblock>.content>.title small,h4 small,h5 small,h6 small{font-size:60%;color:#e99b8f;line-height:0}h1{font-size:2.125em}h2{font-size:1.6875em}h3,#toctitle,.sidebarblock>.content>.title{font-size:1.375em}h4,h5{font-size:1.125em}h6{font-size:1em}hr{border:solid #dddddf;border-width:1px 0 0;clear:both;margin:1.25em 0 1.1875em;height:0}em,i{font-style:italic;line-height:inherit}strong,b{font-weight:bold;line-height:inherit}small{font-size:60%;line-height:inherit}code{font-family:Droid Sans Mono,DejaVu Sans Mono,monospace;font-weight:400;color:rgba(0,0,0,.9)}ul,ol,dl{font-size:1em;line-height:1.6;margin-bottom:1.25em;list-style-position:outside;font-family:inherit}ul,ol{margin-left:1.5em}ul li ul,ul li ol{margin-left:1.25em;margin-bottom:0;font-size:1em}ul.square li ul,ul.circle li ul,ul.disc li ul{list-style:inherit}ul.square{list-style-type:square}ul.circle{list-style-type:circle}ul.disc{list-style-type:disc}ol li ul,ol li ol{margin-left:1.25em;margin-bottom:0}dl dt{margin-bottom:.3125em;font-weight:bold}dl dd{margin-bottom:1.25em}abbr,acronym{text-transform:uppercase;font-size:90%;color:rgba(0,0,0,.8);border-bottom:1px dotted #ddd;cursor:help}abbr{text-transform:none}blockquote{margin:0 0 1.25em;padding:.5625em 1.25em 0 1.1875em;border-left:1px solid #ddd}blockquote cite{display:block;font-size:.9375em;color:rgba(0,0,0,.6)}blockquote cite::before{content:\2014 \0020}blockquote cite a,blockquote cite a:visited{color:rgba(0,0,0,.6)}blockquote,blockquote p{line-height:1.6;color:rgba(0,0,0,.85)}@media screen and (min-width:768px){h1,h2,h3,#toctitle,.sidebarblock>.content>.title,h4,h5,h6{line-height:1.2}h1{font-size:2.75em}h2{font-size:2.3125em}h3,#toctitle,.sidebarblock>.content>.title{font-size:1.6875em}h4{font-size:1.4375em}}table{background:#fff;margin-bottom:1.25em;border:solid 1px #dedede}table thead,table tfoot{background:#f7f8f7}table thead tr th,table thead tr td,table tfoot tr th,table tfoot tr td{padding:.5em .625em .625em;font-size:inherit;color:rgba(0,0,0,.8);text-align:left}table tr th,table tr td{padding:.5625em .625em;font-size:inherit;color:rgba(0,0,0,.8)}table tr.even,table tr.alt,table tr:nth-of-type(even){background:#f8f8f7}table thead tr th,table tfoot tr th,table tbody tr td,table tr td,table tfoot tr td{display:table-cell;line-height:1.6}h1,h2,h3,#toctitle,.sidebarblock>.content>.title,h4,h5,h6{line-height:1.2;word-spacing:-.05em}h1 strong,h2 strong,h3 strong,#toctitle strong,.sidebarblock>.content>.title strong,h4 strong,h5 strong,h6 strong{font-weight:400}.clearfix::before,.clearfix::after,.float-group::before,.float-group::after{content: ;display:table}.clearfix::after,.float-group::after{clear:both}*:not(pre)>code{font-size:.9375em;font-style:normal!important;letter-spacing:0;padding:.1em .5ex;word-spacing:-.15em;background-color:#f7f7f8;-webkit-border-radius:4px;border-radius:4px;line-height:1.45;text-rendering:optimizeSpeed;word-wrap:break-word}*:not(pre)>code.nobreak{word-wrap:normal}*:not(pre)>code.nowrap{white-space:nowrap}pre,pre>code{line-height:1.45;color:rgba(0,0,0,.9);font-family:Droid Sans Mono,DejaVu Sans Mono,monospace;font-weight:400;text-rendering:optimizeSpeed}em em{font-style:normal}strong strong{font-weight:400}.keyseq{color:rgba(51,51,51,.8)}kbd{font-family:Droid Sans Mono,DejaVu Sans Mono,monospace;display:inline-block;color:rgba(0,0,0,.8);font-size:.65em;line-height:1.45;background-color:#f7f7f7;border:1px solid #ccc;-webkit-border-radius:3px;border-radius:3px;-webkit-box-shadow:0 1px 0 rgba(0,0,0,.2),0 0 0 .1em white inset;box-shadow:0 1px 0 rgba(0,0,0,.2),0 0 0 .1em #fff inset;margin:0 .15em;padding:.2em .5em;vertical-align:middle;position:relative;top:-.1em;white-space:nowrap}.keyseq kbd:first-child{margin-left:0}.keyseq kbd:last-child{margin-right:0}.menuseq,.menuref{color:#000}.menuseq b:not(.caret),.menuref{font-weight:inherit}.menuseq{word-spacing:-.02em}.menuseq b.caret{font-size:1.25em;line-height:.8}.menuseq i.caret{font-weight:bold;text-align:center;width:.45em}b.button::before,b.button::after{position:relative;top:-1px;font-weight:400}b.button::before{content:;padding:0 3px 0 2px}b.button::after{content:;padding:0 2px 0 3px}p a>code:hover{color:rgba(0,0,0,.9)}#header,#content,#footnotes,#footer{width:100%;margin-left:auto;margin-right:auto;margin-top:0;margin-bottom:0;max-width:62.5em;*zoom:1;position:relative;padding-left:.9375em;padding-right:.9375em}#header::before,#header::after,#content::before,#content::after,#footnotes::before,#footnotes::after,#footer::before,#footer::after{content: ;display:table}#header::after,#content::after,#footnotes::after,#footer::after{clear:both}#content{margin-top:1.25em}#content::before{content:none}#header>h1:first-child{color:rgba(0,0,0,.85);margin-top:2.25rem;margin-bottom:0}#header>h1:first-child+#toc{margin-top:8px;border-top:1px solid #dddddf}#header>h1:only-child,body.toc2 #header>h1:nth-last-child(2){border-bottom:1px solid #dddddf;padding-bottom:8px}#header .details{border-bottom:1px solid #dddddf;line-height:1.45;padding-top:.25em;padding-bottom:.25em;padding-left:.25em;color:rgba(0,0,0,.6);display:-ms-flexbox;display:-webkit-flex;display:flex;-ms-flex-flow:row wrap;-webkit-flex-flow:row wrap;flex-flow:row wrap}#header .details span:first-child{margin-left:-.125em}#header .details span.email a{color:rgba(0,0,0,.85)}#header .details br{display:none}#header .details br+span::before{content:\00a0\2013\00a0}#header .details br+span.author::before{content:\00a0\22c5\00a0;color:rgba(0,0,0,.85)}#header .details br+span#revremark::before{content:\00a0|\00a0}#header #revnumber{text-transform:capitalize}#header #revnumber::after{content:\00a0}#content>h1:first-child:not(class){color:rgba(0,0,0,.85);border-bottom:1px solid #dddddf;padding-bottom:8px;margin-top:0;padding-top:1rem;margin-bottom:1.25rem}#toc{border-bottom:1px solid #e7e7e9;padding-bottom:.5em}#toc>ul{margin-left:.125em}#toc ul.sectlevel0>li>a{font-style:italic}#toc ul.sectlevel0 ul.sectlevel1{margin:.5em 0}#toc ul{font-family:Open Sans,DejaVu Sans,sans-serif;list-style-type:none}#toc li{line-height:1.3334;margin-top:.3334em}#toc a{text-decoration:none}#toc a:active{text-decoration:underline}#toctitle{color:#7a2518;font-size:1.2em}@media screen and (min-width:768px){#toctitle{font-size:1.375em}body.toc2{padding-left:15em;padding-right:0}#toc.toc2{margin-top:0!important;background-color:#f8f8f7;position:fixed;width:15em;left:0;top:0;border-right:1px solid #e7e7e9;border-top-width:0!important;border-bottom-width:0!important;z-index:1000;padding:1.25em 1em;height:100%;overflow:auto}#toc.toc2 #toctitle{margin-top:0;margin-bottom:.8rem;font-size:1.2em}#toc.toc2>ul{font-size:.9em;margin-bottom:0}#toc.toc2 ul ul{margin-left:0;padding-left:1em}#toc.toc2 ul.sectlevel0 ul.sectlevel1{padding-left:0;margin-top:.5em;margin-bottom:.5em}body.toc2.toc-right{padding-left:0;padding-right:15em}body.toc2.toc-right #toc.toc2{border-right-width:0;border-left:1px solid #e7e7e9;left:auto;right:0}}@media screen and (min-width:1280px){body.toc2{padding-left:20em;padding-right:0}#toc.toc2{width:20em}#toc.toc2 #toctitle{font-size:1.375em}#toc.toc2>ul{font-size:.95em}#toc.toc2 ul ul{padding-left:1.25em}body.toc2.toc-right{padding-left:0;padding-right:20em}}#content #toc{border-style:solid;border-width:1px;border-color:#e0e0dc;margin-bottom:1.25em;padding:1.25em;background:#f8f8f7;-webkit-border-radius:4px;border-radius:4px}#content #toc>:first-child{margin-top:0}#content #toc>:last-child{margin-bottom:0}#footer{max-width:100%;background-color:rgba(0,0,0,.8);padding:1.25em}#footer-text{color:rgba(255,255,255,.8);line-height:1.44}#content{margin-bottom:.625em}.sect1{padding-bottom:.625em}@media screen and (min-width:768px){#content{margin-bottom:1.25em}.sect1{padding-bottom:1.25em}}.sect1:last-child{padding-bottom:0}.sect1+.sect1{border-top:1px solid #e7e7e9}#content h1>a.anchor,h2>a.anchor,h3>a.anchor,#toctitle>a.anchor,.sidebarblock>.content>.title>a.anchor,h4>a.anchor,h5>a.anchor,h6>a.anchor{position:absolute;z-index:1001;width:1.5ex;margin-left:-1.5ex;display:block;text-decoration:none!important;visibility:hidden;text-align:center;font-weight:400}#content h1>a.anchor::before,h2>a.anchor::before,h3>a.anchor::before,#toctitle>a.anchor::before,.sidebarblock>.content>.title>a.anchor::before,h4>a.anchor::before,h5>a.anchor::before,h6>a.anchor::before{content:\00A7;font-size:.85em;display:block;padding-top:.1em}#content h1:hover>a.anchor,#content h1>a.anchor:hover,h2:hover>a.anchor,h2>a.anchor:hover,h3:hover>a.anchor,#toctitle:hover>a.anchor,.sidebarblock>.content>.title:hover>a.anchor,h3>a.anchor:hover,#toctitle>a.anchor:hover,.sidebarblock>.content>.title>a.anchor:hover,h4:hover>a.anchor,h4>a.anchor:hover,h5:hover>a.anchor,h5>a.anchor:hover,h6:hover>a.anchor,h6>a.anchor:hover{visibility:visible}#content h1>a.link,h2>a.link,h3>a.link,#toctitle>a.link,.sidebarblock>.content>.title>a.link,h4>a.link,h5>a.link,h6>a.link{color:#ba3925;text-decoration:none}#content h1>a.link:hover,h2>a.link:hover,h3>a.link:hover,#toctitle>a.link:hover,.sidebarblock>.content>.title>a.link:hover,h4>a.link:hover,h5>a.link:hover,h6>a.link:hover{color:#a53221}.audioblock,.imageblock,.literalblock,.listingblock,.stemblock,.videoblock{margin-bottom:1.25em}.admonitionblock td.content>.title,.audioblock>.title,.exampleblock>.title,.imageblock>.title,.listingblock>.title,.literalblock>.title,.stemblock>.title,.openblock>.title,.paragraph>.title,.quoteblock>.title,table.tableblock>.title,.verseblock>.title,.videoblock>.title,.dlist>.title,.olist>.title,.ulist>.title,.qlist>.title,.hdlist>.title{text-rendering:optimizeLegibility;text-align:left;font-family:Noto Serif,DejaVu Serif,serif;font-size:1rem;font-style:italic}table.tableblock.fit-content>caption.title{white-space:nowrap;width:0}.paragraph.lead>p,#preamble>.sectionbody>classparagraph:first-of-type p{font-size:1.21875em;line-height:1.6;color:rgba(0,0,0,.85)}table.tableblock #preamble>.sectionbody>classparagraph:first-of-type p{font-size:inherit}.admonitionblock>table{border-collapse:separate;border:0;background:none;width:100%}.admonitionblock>table td.icon{text-align:center;width:80px}.admonitionblock>table td.icon img{max-width:none}.admonitionblock>table td.icon .title{font-weight:bold;font-family:Open Sans,DejaVu Sans,sans-serif;text-transform:uppercase}.admonitionblock>table td.content{padding-left:1.125em;padding-right:1.25em;border-left:1px solid #dddddf;color:rgba(0,0,0,.6)}.admonitionblock>table td.content>:last-child>:last-child{margin-bottom:0}.exampleblock>.content{border-style:solid;border-width:1px;border-color:#e6e6e6;margin-bottom:1.25em;padding:1.25em;background:#fff;-webkit-border-radius:4px;border-radius:4px}.exampleblock>.content>:first-child{margin-top:0}.exampleblock>.content>:last-child{margin-bottom:0}.sidebarblock{border-style:solid;border-width:1px;border-color:#e0e0dc;margin-bottom:1.25em;padding:1.25em;background:#f8f8f7;-webkit-border-radius:4px;border-radius:4px}.sidebarblock>:first-child{margin-top:0}.sidebarblock>:last-child{margin-bottom:0}.sidebarblock>.content>.title{color:#7a2518;margin-top:0;text-align:center}.exampleblock>.content>:last-child>:last-child,.exampleblock>.content .olist>ol>li:last-child>:last-child,.exampleblock>.content .ulist>ul>li:last-child>:last-child,.exampleblock>.content .qlist>ol>li:last-child>:last-child,.sidebarblock>.content>:last-child>:last-child,.sidebarblock>.content .olist>ol>li:last-child>:last-child,.sidebarblock>.content .ulist>ul>li:last-child>:last-child,.sidebarblock>.content .qlist>ol>li:last-child>:last-child{margin-bottom:0}.literalblock pre,.listingblock pre:not(.highlight),.listingblock preclasshighlight,.listingblock preclass^highlight ,.listingblock pre.CodeRay,.listingblock pre.prettyprint{background:#f7f7f8}.sidebarblock .literalblock pre,.sidebarblock .listingblock pre:not(.highlight),.sidebarblock .listingblock preclasshighlight,.sidebarblock .listingblock preclass^highlight ,.sidebarblock .listingblock pre.CodeRay,.sidebarblock .listingblock pre.prettyprint{background:#f2f1f1}.literalblock pre,.literalblock preclass,.listingblock pre,.listingblock preclass{-webkit-border-radius:4px;border-radius:4px;word-wrap:break-word;overflow-x:auto;padding:1em;font-size:.8125em}@media screen and (min-width:768px){.literalblock pre,.literalblock preclass,.listingblock pre,.listingblock preclass{font-size:.90625em}}@media screen and (min-width:1280px){.literalblock pre,.literalblock preclass,.listingblock pre,.listingblock preclass{font-size:1em}}.literalblock pre.nowrap,.literalblock pre.nowrap pre,.listingblock pre.nowrap,.listingblock pre.nowrap pre{white-space:pre;word-wrap:normal}.literalblock.output pre{color:#f7f7f8;background-color:rgba(0,0,0,.9)}.listingblock pre.highlightjs{padding:0}.listingblock pre.highlightjs>code{padding:1em;-webkit-border-radius:4px;border-radius:4px}.listingblock pre.prettyprint{border-width:0}.listingblock>.content{position:relative}.listingblock codedata-lang::before{display:none;content:attr(data-lang);position:absolute;font-size:.75em;top:.425rem;right:.5rem;line-height:1;text-transform:uppercase;color:#999}.listingblock:hover codedata-lang::before{display:block}.listingblock.terminal pre .command::before{content:attr(data-prompt);padding-right:.5em;color:#999}.listingblock.terminal pre .command:not(data-prompt)::before{content:$}table.pyhltable{border-collapse:separate;border:0;margin-bottom:0;background:none}table.pyhltable td{vertical-align:top;padding-top:0;padding-bottom:0;line-height:1.45}table.pyhltable td.code{padding-left:.75em;padding-right:0}pre.pygments .lineno,table.pyhltable td:not(.code){color:#999;padding-left:0;padding-right:.5em;border-right:1px solid #dddddf}pre.pygments .lineno{display:inline-block;margin-right:.25em}table.pyhltable .linenodiv{background:none!important;padding-right:0!important}.quoteblock{margin:0 1em 1.25em 1.5em;display:table}.quoteblock>.title{margin-left:-1.5em;margin-bottom:.75em}.quoteblock blockquote,.quoteblock p{color:rgba(0,0,0,.85);font-size:1.15rem;line-height:1.75;word-spacing:.1em;letter-spacing:0;font-style:italic;text-align:justify}.quoteblock blockquote{margin:0;padding:0;border:0}.quoteblock blockquote::before{content:\201c;float:left;font-size:2.75em;font-weight:bold;line-height:.6em;margin-left:-.6em;color:#7a2518;text-shadow:0 1px 2px rgba(0,0,0,.1)}.quoteblock blockquote>.paragraph:last-child p{margin-bottom:0}.quoteblock .attribution{margin-top:.75em;margin-right:.5ex;text-align:right}.verseblock{margin:0 1em 1.25em}.verseblock pre{font-family:Open Sans,DejaVu Sans,sans;font-size:1.15rem;color:rgba(0,0,0,.85);font-weight:300;text-rendering:optimizeLegibility}.verseblock pre strong{font-weight:400}.verseblock .attribution{margin-top:1.25rem;margin-left:.5ex}.quoteblock .attribution,.verseblock .attribution{font-size:.9375em;line-height:1.45;font-style:italic}.quoteblock .attribution br,.verseblock .attribution br{display:none}.quoteblock .attribution cite,.verseblock .attribution cite{display:block;letter-spacing:-.025em;color:rgba(0,0,0,.6)}.quoteblock.abstract blockquote::before,.quoteblock.excerpt blockquote::before,.quoteblock .quoteblock blockquote::before{display:none}.quoteblock.abstract blockquote,.quoteblock.abstract p,.quoteblock.excerpt blockquote,.quoteblock.excerpt p,.quoteblock .quoteblock blockquote,.quoteblock .quoteblock p{line-height:1.6;word-spacing:0}.quoteblock.abstract{margin:0 1em 1.25em;display:block}.quoteblock.abstract>.title{margin:0 0 .375em;font-size:1.15em;text-align:center}.quoteblock.excerpt,.quoteblock .quoteblock{margin:0 0 1.25em;padding:0 0 .25em 1em;border-left:.25em solid #dddddf}.quoteblock.excerpt blockquote,.quoteblock.excerpt p,.quoteblock .quoteblock blockquote,.quoteblock .quoteblock p{color:inherit;font-size:1.0625rem}.quoteblock.excerpt .attribution,.quoteblock .quoteblock .attribution{color:inherit;text-align:left;margin-right:0}table.tableblock{max-width:100%;border-collapse:separate}p.tableblock:last-child{margin-bottom:0}td.tableblock>.content{margin-bottom:-1.25em}table.tableblock,th.tableblock,td.tableblock{border:0 solid #dedede}table.grid-all>thead>tr>.tableblock,table.grid-all>tbody>tr>.tableblock{border-width:0 1px 1px 0}table.grid-all>tfoot>tr>.tableblock{border-width:1px 1px 0 0}table.grid-cols>*>tr>.tableblock{border-width:0 1px 0 0}table.grid-rows>thead>tr>.tableblock,table.grid-rows>tbody>tr>.tableblock{border-width:0 0 1px}table.grid-rows>tfoot>tr>.tableblock{border-width:1px 0 0}table.grid-all>*>tr>.tableblock:last-child,table.grid-cols>*>tr>.tableblock:last-child{border-right-width:0}table.grid-all>tbody>tr:last-child>.tableblock,table.grid-all>thead:last-child>tr>.tableblock,table.grid-rows>tbody>tr:last-child>.tableblock,table.grid-rows>thead:last-child>tr>.tableblock{border-bottom-width:0}table.frame-all{border-width:1px}table.frame-sides{border-width:0 1px}table.frame-topbot,table.frame-ends{border-width:1px 0}table.stripes-all tr,table.stripes-odd tr:nth-of-type(odd){background:#f8f8f7}table.stripes-none tr,table.stripes-odd tr:nth-of-type(even){background:none}th.halign-left,td.halign-left{text-align:left}th.halign-right,td.halign-right{text-align:right}th.halign-center,td.halign-center{text-align:center}th.valign-top,td.valign-top{vertical-align:top}th.valign-bottom,td.valign-bottom{vertical-align:bottom}th.valign-middle,td.valign-middle{vertical-align:middle}table thead th,table tfoot th{font-weight:bold}tbody tr th{display:table-cell;line-height:1.6;background:#f7f8f7}tbody tr th,tbody tr th p,tfoot tr th,tfoot tr th p{color:rgba(0,0,0,.8);font-weight:bold}p.tableblock>code:only-child{background:none;padding:0}p.tableblock{font-size:1em}td>div.verse{white-space:pre}ol{margin-left:1.75em}ul li ol{margin-left:1.5em}dl dd{margin-left:1.125em}dl dd:last-child,dl dd:last-child>:last-child{margin-bottom:0}ol>li p,ul>li p,ul dd,ol dd,.olist .olist,.ulist .ulist,.ulist .olist,.olist .ulist{margin-bottom:.625em}ul.checklist,ul.none,ol.none,ul.no-bullet,ol.no-bullet,ol.unnumbered,ul.unstyled,ol.unstyled{list-style-type:none}ul.no-bullet,ol.no-bullet,ol.unnumbered{margin-left:.625em}ul.unstyled,ol.unstyled{margin-left:0}ul.checklist{margin-left:.625em}ul.checklist li>p:first-child>.fa-square-o:first-child,ul.checklist li>p:first-child>.fa-check-square-o:first-child{width:1.25em;font-size:.8em;position:relative;bottom:.125em}ul.checklist li>p:first-child>inputtypecheckbox:first-child{margin-right:.25em}ul.inline{display:-ms-flexbox;display:-webkit-box;display:flex;-ms-flex-flow:row wrap;-webkit-flex-flow:row wrap;flex-flow:row wrap;list-style:none;margin:0 0 .625em -1.25em}ul.inline>li{margin-left:1.25em}.unstyled dl dt{font-weight:400;font-style:normal}ol.arabic{list-style-type:decimal}ol.decimal{list-style-type:decimal-leading-zero}ol.loweralpha{list-style-type:lower-alpha}ol.upperalpha{list-style-type:upper-alpha}ol.lowerroman{list-style-type:lower-roman}ol.upperroman{list-style-type:upper-roman}ol.lowergreek{list-style-type:lower-greek}.hdlist>table,.colist>table{border:0;background:none}.hdlist>table>tbody>tr,.colist>table>tbody>tr{background:none}td.hdlist1,td.hdlist2{vertical-align:top;padding:0 .625em}td.hdlist1{font-weight:bold;padding-bottom:1.25em}.literalblock+.colist,.listingblock+.colist{margin-top:-.5em}.colist td:not(class):first-child{padding:.4em .75em 0;line-height:1;vertical-align:top}.colist td:not(class):first-child img{max-width:none}.colist td:not(class):last-child{padding:.25em 0}.thumb,.th{line-height:0;display:inline-block;border:solid 4px #fff;-webkit-box-shadow:0 0 0 1px #ddd;box-shadow:0 0 0 1px #ddd}.imageblock.left{margin:.25em .625em 1.25em 0}.imageblock.right{margin:.25em 0 1.25em .625em}.imageblock>.title{margin-bottom:0}.imageblock.thumb,.imageblock.th{border-width:6px}.imageblock.thumb>.title,.imageblock.th>.title{padding:0 .125em}.image.left,.image.right{margin-top:.25em;margin-bottom:.25em;display:inline-block;line-height:0}.image.left{margin-right:.625em}.image.right{margin-left:.625em}a.image{text-decoration:none;display:inline-block}a.image object{pointer-events:none}sup.footnote,sup.footnoteref{font-size:.875em;position:static;vertical-align:super}sup.footnote a,sup.footnoteref a{text-decoration:none}sup.footnote a:active,sup.footnoteref a:active{text-decoration:underline}#footnotes{padding-top:.75em;padding-bottom:.75em;margin-bottom:.625em}#footnotes hr{width:20%;min-width:6.25em;margin:-.25em 0 .75em;border-width:1px 0 0}#footnotes .footnote{padding:0 .375em 0 .225em;line-height:1.3334;font-size:.875em;margin-left:1.2em;margin-bottom:.2em}#footnotes .footnote a:first-of-type{font-weight:bold;text-decoration:none;margin-left:-1.05em}#footnotes .footnote:last-of-type{margin-bottom:0}#content #footnotes{margin-top:-.625em;margin-bottom:0;padding:.75em 0}.gist .file-data>table{border:0;background:#fff;width:100%;margin-bottom:0}.gist .file-data>table td.line-data{width:99%}div.unbreakable{page-break-inside:avoid}.big{font-size:larger}.small{font-size:smaller}.underline{text-decoration:underline}.overline{text-decoration:overline}.line-through{text-decoration:line-through}.aqua{color:#00bfbf}.aqua-background{background-color:#00fafa}.black{color:#000}.black-background{background-color:#000}.blue{color:#0000bf}.blue-background{background-color:#0000fa}.fuchsia{color:#bf00bf}.fuchsia-background{background-color:#fa00fa}.gray{color:#606060}.gray-background{background-color:#7d7d7d}.green{color:#006000}.green-background{background-color:#007d00}.lime{color:#00bf00}.lime-background{background-color:#00fa00}.maroon{color:#600000}.maroon-background{background-color:#7d0000}.navy{color:#000060}.navy-background{background-color:#00007d}.olive{color:#606000}.olive-background{background-color:#7d7d00}.purple{color:#600060}.purple-background{background-color:#7d007d}.red{color:#bf0000}.red-background{background-color:#fa0000}.silver{color:#909090}.silver-background{background-color:#bcbcbc}.teal{color:#006060}.teal-background{background-color:#007d7d}.white{color:#bfbfbf}.white-background{background-color:#fafafa}.yellow{color:#bfbf00}.yellow-background{background-color:#fafa00}span.icon>.fa{cursor:default}a span.icon>.fa{cursor:inherit}.admonitionblock td.icon class^fa icon-{font-size:2.5em;text-shadow:1px 1px 2px rgba(0,0,0,.5);cursor:default}.admonitionblock td.icon .icon-note::before{content:\f05a;color:#19407c}.admonitionblock td.icon .icon-tip::before{content:\f0eb;text-shadow:1px 1px 2px rgba(155,155,0,.8);color:#111}.admonitionblock td.icon .icon-warning::before{content:\f071;color:#bf6900}.admonitionblock td.icon .icon-caution::before{content:\f06d;color:#bf3400}.admonitionblock td.icon .icon-important::before{content:\f06a;color:#bf0000}.conumdata-value{display:inline-block;color:#fff!important;background-color:rgba(0,0,0,.8);-webkit-border-radius:100px;border-radius:100px;text-align:center;font-size:.75em;width:1.67em;height:1.67em;line-height:1.67em;font-family:Open Sans,DejaVu Sans,sans-serif;font-style:normal;font-weight:bold}.conumdata-value *{color:#fff!important}.conumdata-value+b{display:none}.conumdata-value::after{content:attr(data-value)}pre .conumdata-value{position:relative;top:-.125em}b.conum *{color:inherit!important}.conum:not(data-value):empty{display:none}dt,th.tableblock,td.content,div.footnote{text-rendering:optimizeLegibility}h1,h2,p,td.content,span.alt{letter-spacing:-.01em}p strong,td.content strong,div.footnote strong{letter-spacing:-.005em}p,blockquote,dt,td.content,span.alt{font-size:1.0625rem}p{margin-bottom:1.25rem}.sidebarblock p,.sidebarblock dt,.sidebarblock td.content,p.tableblock{font-size:1em}.exampleblock>.content{background-color:#fffef7;border-color:#e0e0dc;-webkit-box-shadow:0 1px 4px #e0e0dc;box-shadow:0 1px 4px #e0e0dc}.print-only{display:none!important}@page{margin:1.25cm .75cm}@media print{*{-webkit-box-shadow:none!important;box-shadow:none!important;text-shadow:none!important}html{font-size:80%}a{color:inherit!important;text-decoration:underline!important}a.bare,ahref^#,ahref^mailto:{text-decoration:none!important}ahref^http::not(.bare)::after,ahref^https::not(.bare)::after{content:( attr(href) );display:inline-block;font-size:.875em;padding-left:.25em}abbrtitle::after{content: ( attr(title) )}pre,blockquote,tr,img,object,svg{page-break-inside:avoid}thead{display:table-header-group}svg{max-width:100%}p,blockquote,dt,td.content{font-size:1em;orphans:3;widows:3}h2,h3,#toctitle,.sidebarblock>.content>.title{page-break-after:avoid}#toc,.sidebarblock,.exampleblock>.content{background:none!important}#toc{border-bottom:1px solid #dddddf!important;padding-bottom:0!important}body.book #header{text-align:center}body.book #header>h1:first-child{border:0!important;margin:2.5em 0 1em}body.book #header .details{border:0!important;display:block;padding:0!important}body.book #header .details span:first-child{margin-left:0!important}body.book #header .details br{display:block}body.book #header .details br+span::before{content:none!important}body.book #toc{border:0!important;text-align:left!important;padding:0!important;margin:0!important}body.book #toc,body.book #preamble,body.book h1.sect0,body.book .sect1>h2{page-break-before:always}.listingblock codedata-lang::before{display:block}#footer{padding:0 .9375em}.hide-on-print{display:none!important}.print-only{display:block!important}.hide-for-print{display:none!important}.show-for-print{display:inherit!important}}@media print,amzn-kf8{#header>h1:first-child{margin-top:1.25rem}.sect1{padding:0!important}.sect1+.sect1{border:0}#footer{background:none}#footer-text{color:rgba(0,0,0,.6);font-size:.9em}}@media amzn-kf8{#header,#content,#footnotes,#footer{padding:0}}/style>/head>body classbook toc2 toc-left>div idheader>h1>Pierce Application Core/h1>div classdetails>span idauthor classauthor>Pierce County Developers/span>br>span idrevnumber>version 7.26.0-SNAPSHOT/span>/div>div idtoc classtoc2>div idtoctitle>Table of Contents/div>ul classsectlevel1>li>a href#_introduction>Introduction/a>/li>li>a href#_pac_components>PAC Components/a>ul classsectlevel2>li>a href#_conditions>Conditions/a>/li>li>a href#_expressions>Expressions/a>ul classsectlevel3>li>a href#_supported_functions>Supported Functions/a>ul classsectlevel4>li>a href#_date_and_time>Date and Time/a>/li>li>a href#_general>General/a>/li>li>a href#_html>HTML/a>/li>li>a href#_logical>Logical/a>/li>li>a href#_number>Number/a>/li>li>a href#_text>Text/a>/li>/ul>/li>/ul>/li>li>a href#_constraints>Constraints/a>/li>li>a href#_security>Security/a>/li>li>a href#_reporting>Reporting/a>ul classsectlevel3>li>a href#_queries>Queries/a>/li>li>a href#_reports>Reports/a>/li>/ul>/li>li>a href#_workflow>Workflow/a>ul classsectlevel3>li>a href#_task_definitions>Task Definitions/a>/li>li>a href#_task_events>Task Events/a>/li>/ul>/li>li>a href#_forms>Forms/a>/li>li>a href#_tags>Tags/a>ul classsectlevel3>li>a href#_definition>Definition/a>/li>li>a href#_guidelines>Guidelines/a>ul classsectlevel4>li>a href#_industry_recommendations>Industry Recommendations/a>/li>li>a href#_pierce_county_requirements>Pierce County Requirements/a>/li>/ul>/li>/ul>/li>/ul>/li>/ul>/div>/div>div idcontent>div classsect1>h2 id_introduction>Introduction/h2>div classsectionbody>div classparagraph>p>The Pierce Application Core (PAC) is included in the County’s modern custom-developed applications includingLegal Information Network Exchange (LINX), PALS Plus, Forensic Death Information System (FDIS), Person,School Threat System (STS) and IDPPOP./p>/div>/div>/div>div classsect1>h2 id_pac_components>PAC Components/h2>div classsectionbody>div classparagraph>p>PAC includes the following powerful configuration components that enable a power user to tailor an application to meet the needs of the users./p>/div>div classsect2>h3 id_conditions>Conditions/h3>/div>div classsect2>h3 id_expressions>Expressions/h3>div classparagraph>p>strong>Definition/strong>/p>/div>div classparagraph>p>Expressions are made up of functions that use values, variables, or other functions./p>/div>div classparagraph>p>strong>Values/strong>/p>/div>div classparagraph>p>Values may be text or numbers./p>/div>div classliteralblock>div classcontent>pre>“Pierce County”987444.03There are two special text values./pre>/div>/div>div classliteralblock>div classcontent>pre>“true” in lower case letters may be used in place of the Boolean true.“false” in lower case letters may be used in place of the Boolean false./pre>/div>/div>div classparagraph>p>Example:/p>/div>div classliteralblock>div classcontent>pre>HTMLLINK(“Pierce County”, “http://www.piercecountywa.org/”, “_blank”)/pre>/div>/div>div classparagraph>p>strong>Variables/strong>/p>/div>div classparagraph>p>Variables are data source properties that have been included in a query./p>/div>div classliteralblock>div classcontent>pre>person.firstNameperson.lastName/pre>/div>/div>div classparagraph>p>Example:/p>/div>div classliteralblock>div classcontent>pre>CONCATENATE(person.firstName, person.lastName)/pre>/div>/div>div classparagraph>p>strong>Functions/strong>/p>/div>div classparagraph>p>Functions are a way to make a new value from existing values, variables, and/or function results./p>/div>div classparagraph>p>Example:/p>/div>div classliteralblock>div classcontent>pre>DAYOFYEAR(NOW())/pre>/div>/div>div classparagraph>p>strong>Combination/strong>/p>/div>div classparagraph>p>A mix of values, variables, and functions may be used./p>/div>div classparagraph>p>Example:/p>/div>div classliteralblock>div classcontent>pre>DATEFORMAT(NOW(), “dd/MM/YYYY”, “UTC”, “America/Los_Angeles”)/pre>/div>/div>div classparagraph>p>strong>Nesting/strong>/p>/div>div classparagraph>p>Expressions may be nested./p>/div>div classparagraph>p>Example: NOW function is nested in the DATEADD function which is nested in the DATEDIFF function./p>/div>div classliteralblock>div classcontent>pre>DATEDIFF(“Days”,NOW(),DATEADD(1,”YEAR”,NOW()))/pre>/div>/div>div classsect3>h4 id_supported_functions>Supported Functions/h4>div classsect4>h5 id_date_and_time>Date and Time/h5>table classtableblock frame-all grid-all stretch>colgroup>col stylewidth: 33.3333%;>col stylewidth: 33.3333%;>col stylewidth: 33.3334%;>/colgroup>thead>tr>th classtableblock halign-left valign-top>Function/th>th classtableblock halign-left valign-top>Description/th>th classtableblock halign-left valign-top>Example/th>/tr>/thead>tbody>tr>td classtableblock halign-left valign-top>p classtableblock>CURRENTTIMEMILLIS/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate the difference, measured in milliseconds, between the current time and midnight on January 1, 1970 UTC./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>CURRENTTIMEMILLIS()/p>/div>div classulist>ul>li>p>Takes no values, variables, or functions/p>/li>/ul>/div>div classparagraph>p>Say today was Jan 6th, 2017 at 21:21:55, strong>CURRENTTIMEMILLIS()/strong> would be 1483737715213/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DATEADD/p>/td>td classtableblock halign-left valign-top>p classtableblock>Create a new date by adding to an existing date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DATEADD(number, datepart, date)/p>/div>div classulist>ul>li>p>number: amount to add/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>positive or negative/p>/li>li>p>a whole number/p>/li>li>p>a variable that contains a whole number/p>/li>li>p>a function that gives a whole number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>datepart: part of the date to add to/p>div classulist>ul>li>p>should be in double quotes, is case insensitive, and may be/p>div classulist>ul>li>p>day/p>/li>li>p>month/p>/li>li>p>year/p>/li>li>p>hour/p>/li>li>p>minute/p>/li>li>p>second/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>date: date to add to/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Dec 25th, 2017, strong>DATEADD(1, “YEAR”, NOW())/strong> would be Dec 25th, 2018/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DATECREATE/p>/td>td classtableblock halign-left valign-top>p classtableblock>Create a date from a day, month, and year./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DATECREATE(day, month, year)/p>/div>div classulist>ul>li>p>day, month, and year/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole number/p>/li>li>p>a variable that contains a whole number/p>/li>li>p>a function that gives a whole number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>DATECREATE(22, 1, 1975)/strong> would be January 22nd, 1975/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DATEDIFF/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate the difference between two dates./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DATEDIFF(unit-of-measure, first-date, second-date)/p>/div>div classulist>ul>li>p>unit-of-measure: time unit of measure/p>div classulist>ul>li>p>should be in double quotes, is case insensitive, and may be/p>div classulist>ul>li>p>any of these common values/p>div classulist>ul>li>p>years/p>/li>li>p>days/p>/li>li>p>hours/p>/li>li>p>millis/p>/li>li>p>months/p>/li>li>p>seconds/p>/li>li>p>weeks/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>first-date and second-date: dates to determine the amount of time between/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Apr 4th 2012, strong>DATEDIFF(“Days”, NOW(), DATEADD(1, “year”, NOW()))/strong> would equal 365/p>/div>div classparagraph>p>Say today was Feb 1st 2012, strong>DATEDIFF(“days”, NOW(), DATEADD(1, “YEAR”, NOW()))/strong> would equal 366/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DATEFORMAT/p>/td>td classtableblock halign-left valign-top>p classtableblock>Format a date as text./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DATEFORMAT(date, format, optional-existing-time-zone, optional-convert-to-time-zone)/p>/div>div classulist>ul>li>p>date: date to format/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>format: the way the date should be displayed/p>div classulist>ul>li>p>should be in double quotes, IS case sensitive, and may be/p>div classulist>ul>li>p>any of these date time format symbols/p>/li>/ul>/div>/li>li>p>optional-existing-time-zone and optional-convert-to-time-zone:/p>div classulist>ul>li>p>does not have to be included/p>/li>li>p>should be in double quotes, is case insensitive, and may be/p>div classulist>ul>li>p>any of the Canonical IDs in the available time zones/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Apr 14th, 2007, strong>DATEFORMAT(NOW(), “dd/MM/YYYY”)/strong> would be 14/04/2007/p>/div>div classparagraph>p>Say today was Jul 9th, 2016, strong>DATEFORMAT(NOW(), “dd/MM/YYYY”, “UTC”, “America/Los_Angeles”)/strong> would change today’s UTC date appear as 09/07/2016 and be PDT time zone/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DATEPARSE/p>/td>td classtableblock halign-left valign-top>p classtableblock>Using a text format pattern, create a date from text./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DATEPARSE(format, text-date)/p>/div>div classulist>ul>li>p>format: the way the date should be displayed/p>div classulist>ul>li>p>should be in double quotes, IS case sensitive, and may be/p>div classulist>ul>li>p>any of these date time format symbols/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>text-date: text to convert to a date/p>div classulist>ul>li>p>date and time parts should match the order and separators in the format text/p>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>DATEPARSE(“MM/dd/yyyy”,”1/22/1975″)/strong> would create a date of Wed Jan 22 00:00:00 PST 1975/p>/div>div classparagraph>p>strong>DATEPARSE(“M/d/yy h:m”,”1/22/75 3:59″)/strong> would create a date of Wed Jan 22 03:59:00 PST 1975/p>/div>div classparagraph>p>strong>DATEPARSE(“h:m”, “3:59”)/strong> would create a date of Thu Jan 01 03:59:00 PST 1970/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DATEPART/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the year, month, or day from a date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DATEPART(date, datepart)/p>/div>div classulist>ul>li>p>date: date to get a part of/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>datepart: part of the date to get/p>div classulist>ul>li>p>should be in double quotes, is case insensitive, and may be/p>div classulist>ul>li>p>Year/p>/li>li>p>Month/p>/li>li>p>DayOfMonth/p>/li>li>p>DayOfYear/p>/li>li>p>DayOfWeek/p>/li>li>p>DayOfWeekInMonth/p>/li>li>p>Second/p>/li>li>p>Millisecond/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Dec 31st, 1999, strong>DATEPART(NOW(), “year”)/strong> would be 1999/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DAYNAME/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the day name (Monday, Tuesday, Wednesday, …) of a date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DAYNAME(date)/p>/div>div classulist>ul>li>p>date: date to get the name of the day in the week/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Apr 28th, 2014, strong>DAYNAME(NOW())/strong> would be Monday/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DAYOFMONTH/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the day (1 – 31) of the date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DAYOFMONTH(date)/p>/div>div classulist>ul>li>p>date: date to get the number of the day in the month/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Apr 28th, 2014, strong>DAYOFMONTH(NOW())/strong> would be 28/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DAYOFWEEK/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the day (1 – 7 Sunday being 1) of the week from a date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DAYOFWEEK(date)/p>/div>div classulist>ul>li>p>date: date to get the number of the day in the week/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Apr 28th, 2014, strong>DAYOFWEEK(NOW())/strong> would be 2/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DAYOFYEAR/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the day (1 – 356 or 366) of the year from a date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DAYOFYEAR(date)/p>/div>div classulist>ul>li>p>date: date to get the number of the day in the year/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Feb 13th, 1983, strong>DAYOFYEAR(NOW())/strong> would be 44/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>HOUR/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the hour (0 – 11) of the date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>HOUR(date)/p>/div>div classulist>ul>li>p>date: date to get the hour for a 12 hour clock/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say the time was 12:56 am, strong>HOUR(NOW())/strong> would be 0/p>/div>div classparagraph>p>Say the time was 2:56 pm, strong>HOUR(NOW())/strong> would be 2/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>HOUROFDAY/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the hour of the day (0 – 23) of the date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>HOUR(date)/p>/div>div classulist>ul>li>p>date: date to get the hour for a 24 hour clock/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say the time was 11:56 pm, strong>HOUROFDAY(NOW())/strong> would be 23/p>/div>div classparagraph>p>Say the time was 2:56 pm, strong>HOUROFDAY(NOW())/strong> would be 14/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>MINUTE/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the minute (0 – 59) of the date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>MINUTE(date)/p>/div>div classulist>ul>li>p>date: date to get the minute in the hour/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say the time was 11:56 pm, strong>MINUTE(NOW())/strong> would be 56/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>MONTH/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the month (1 – 12) of the date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>MONTH(date)/p>/div>div classulist>ul>li>p>date: date to get the number of the month/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Feb 13th, 1983, strong>MONTH(NOW())/strong> would be 2/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>MONTHNAME/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the month name from the date or from the month number (1 – 12)./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>MONTHNAME(date)/p>/div>div classulist>ul>li>p>date: date to get the name of the month/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole number (1 -12)/p>/li>li>p>a variable that contains a date or a whole number (1 – 12)/p>/li>li>p>a function that gives a date or a whole number (1 – 12) as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Feb 13th, 1983, strong>MONTHNAME(NOW())/strong> would be February/p>/div>div classparagraph>p>strong>MONTHNAME(2)/strong> would be February/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>NOW/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the current date/time./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>NOW()/p>/div>div classulist>ul>li>p>Takes no values, variables, or functions/p>/li>/ul>/div>div classparagraph>p>Say today was Jan 6th, 2017 at 21:21:55, strong>NOW()/strong> would be Jan 6th, 2017 at 21:21:55/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>QUARTER/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the quarter (1 – 4) of the date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>QUARTER(date)/p>/div>div classulist>ul>li>p>date: date to get the number of the quarter in the year/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Oct 31st, 2004, strong>QUARTER(NOW())/strong> would be 4/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>SECOND/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the second (0 – 59) of the date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>SECOND(date)/p>/div>div classulist>ul>li>p>date: date to get the second in the minute/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say the time was 11:56:09 pm, strong>SECOND(NOW())/strong> would be 9/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>WEEKOFMONTH/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the week (1 – 6) of the month from a date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>WEEKOFMONTH(date)/p>/div>div classulist>ul>li>p>date: date to get the number of the week in the month/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Jul 4th, 2011, strong>WEEKOFMONTH(NOW())/strong> would be 2/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>WEEKOFYEAR/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the week (1 – 53) of the year from a date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>WEEKOFYEAR(date)/p>/div>div classulist>ul>li>p>date: date to get the number of the week in the yearmay be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Jul 4th, 2011, strong>WEEKOFYEAR(NOW())/strong> would be 28/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>YEAR/p>/td>td classtableblock halign-left valign-top>p classtableblock>Get the year of the date./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>YEAR(date)/p>/div>div classulist>ul>li>p>date: date to get the year/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a date/p>/li>li>p>a function that gives a date as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say today was Oct 31st, 2004, strong>YEAR(NOW())/strong> would be 2004/p>/div>/div>/td>/tr>/tbody>/table>/div>div classsect4>h5 id_general>General/h5>table classtableblock frame-all grid-all stretch>colgroup>col stylewidth: 33.3333%;>col stylewidth: 33.3333%;>col stylewidth: 33.3334%;>/colgroup>thead>tr>th classtableblock halign-left valign-top>Function/th>th classtableblock halign-left valign-top>Description/th>th classtableblock halign-left valign-top>Example/th>/tr>/thead>tbody>tr>td classtableblock halign-left valign-top>p classtableblock>BOOLEAN/p>/td>td classtableblock halign-left valign-top>p classtableblock>Converts the value to a Boolean./p>p classtableblock>NOTE: “true” and “false” may be used in place of BOOLEAN(“true”) and BOOLEAN(“false”)./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>BOOLEAN(value)/p>/div>div classulist>ul>li>p>value: value to be converted/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>true or false text in double quotes/p>/li>li>p>a variable that contains true or false text/p>/li>li>p>a variable that contains a true or false Boolean/p>/li>li>p>a function that gives either true or false text as the result/p>/li>li>p>a function that gives either true or false Boolean as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>BOOLEAN(“true”)/strong> would be true as a Boolean/p>/div>div classparagraph>p>Say the school was a public school, strong>BOOLEAN(School.privateSchool)/strong> would be false as a Boolean/p>/div>div classparagraph>p>strong>BOOLEAN(“yes”)/strong> would be false as a Boolean since “yes” is not a valid value/p>/div>div classparagraph>p>strong>BOOLEAN(42)/strong> would be false as a Boolean since 42 is not a valid value/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>ENCODEASBASE64STRING/p>/td>td classtableblock halign-left valign-top>p classtableblock>Encodes an array of bytes as a Base64 encoded text./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>ENCODEASBASE64STRING(array-of-bytes, optional-type-prefix)/p>/div>div classulist>ul>li>p>array-of-bytes: array to be converted/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains an array of bytes/p>/li>li>p>a function that gives an array of bytes as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>optional-type-prefix:/p>div classulist>ul>li>p>any of these common shortcut values in double quotes/p>div classulist>ul>li>p>image/p>/li>li>p>jpeg/p>/li>li>p>jpg/p>/li>li>p>png/p>/li>/ul>/div>/li>li>p>or any properly formatted type prefix/p>div classulist>ul>li>p>Pattern/p>div classulist>ul>li>p>data:<MIME-type>;charset<encoding>;base64,/p>/li>/ul>/div>/li>li>p>Example/p>div classulist>ul>li>p>data:image/png;base64,/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>ENCODEASBASE64STRING(Photo.Data, “png”)/strong> would be the content of Photo.Data encoded to Base 64 text/p>/div>div classparagraph>p>strong>ENCODEASBASE64STRING(Photo.Data, “data:image/jpeg;base64,”)/strong> would be the content of Photo.Data encoded to Base 64 text/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>EXPRESSION/p>/td>td classtableblock halign-left valign-top>p classtableblock>Converts the value to an expression and evaluates it./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>EXPRESSION(value)/p>/div>div classulist>ul>li>p>value: value to be converted/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>text in double quotes that represents an expression/p>/li>li>p>a variable that contains text that represents an expression/p>/li>li>p>a function that gives text that represents an expression as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>EXPRESSION(“ADD(1, 2)”)/strong> would be 3/p>/div>div classparagraph>p>Say GREETING contained ‘strong>CONCATENATE(“Hello “, NAME)/strong>’ and NAME contained ‘Pierce County’, strong>EXPRESSION(GREETING)/strong> would be Hello Pierce County/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>JSONARRAY/p>/td>td classtableblock halign-left valign-top>p classtableblock>Creates a JSON array with the given values./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>JSONARRAY(value, optional-value)/p>/div>div classulist>ul>li>p>value: value to be converted/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>whole or decimal number/p>/li>li>p>text in double quotes/p>/li>li>p>a date/p>/li>li>p>a Boolean/p>/li>li>p>any variable/p>/li>li>p>any function/p>/li>li>p>any combination/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>JSONARRAY(3,”too”,1)/strong> would be an array that contained the number 3 in the first position, “too” in the second position, and 1 in the third position/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>JSONARRAYGET/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives back the item in a JSON array with a 0 based index./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>JSONARRAYGET(json-array, index)/p>/div>div classulist>ul>li>p>json-array: array to find an item in/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>JSON array/p>/li>li>p>a variable that contains a JSON array/p>/li>li>p>a function that gives a JSON array as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>index: location in the array to retrieve the item/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>whole number/p>/li>li>p>a variable that contains a whole number/p>/li>li>p>a function that gives a whole number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>JSONARRAYGET(JSONARRAY(3,”too”,1), 2)/strong> would be too/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>JSONARRAYLENGTH/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives the number of items in a JSON array./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>JSONARRAYLENGTH(json-array)/p>/div>div classulist>ul>li>p>json-array: array to get the number of items in it/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>JSON array/p>/li>li>p>a variable that contains a JSON array/p>/li>li>p>a function that gives a JSON array as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>JSONARRAYLENGTH(JSONARRAY(3,”too”,1)/strong> would be 3/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>JSONOBJECT/p>/td>td classtableblock halign-left valign-top>p classtableblock>Creates a JSON object with the given keys and values./p>p classtableblock>NOTE: The values must be in pairs. First value is the key to the value and the second value  is the value itself./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>JSONOBJECT(key, value, optional-key, optional-value)/p>/div>div classulist>ul>li>p>key: value to be the key to find the value in the object/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>whole or decimal number/p>/li>li>p>text in double quotes/p>/li>li>p>a date/p>/li>li>p>a Boolean/p>/li>li>p>a JSON array/p>/li>li>p>any variable/p>/li>li>p>any function/p>/li>li>p>any number of optional-keys as long as they are paired with an optional-value/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>value: value to be paired with a key/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>whole or decimal number/p>/li>li>p>text in double quotes/p>/li>li>p>a date/p>/li>li>p>a Boolean/p>/li>li>p>a JSON array/p>/li>li>p>any variable/p>/li>li>p>any function/p>/li>li>p>any number of optional-values as long as they are paired with an optional-key/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say FIRST contained ‘Emily’, strong>JSONOBJECT(“first-name”, FIRST, “age”, 42)/strong> would be/p>/div>div classparagraph>p>key first-name that has a value of Emily/p>/div>div classparagraph>p>key age that has a value of 42/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>JSONOBJECTGET/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives back the value in a JSON object with a given key./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>JSONOBJECTGET(json-array, key)/p>/div>div classulist>ul>li>p>json-array: array to find an item in/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>JSON array/p>/li>li>p>a variable that contains a JSON array/p>/li>li>p>a function that gives a JSON array as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>key: value that matches a key in the JSON object/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>whole or decimal number/p>/li>li>p>text in double quotes/p>/li>li>p>a date/p>/li>li>p>a Boolean/p>/li>li>p>a JSON array/p>/li>li>p>any variable/p>/li>li>p>any function/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>JSONOBJECTGET(JSONOBJECT(“first-name”, FIRST, “age”, 42), “age”)/strong> would be 42/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>JSONPATH/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives back the value in a JSON formatted text with a given path./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>JSONPATH(json-formatted-text, $.path)/p>/div>div classulist>ul>li>p>json-formatted-text: text to find an item in/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>JSON formatted text/p>/li>li>p>a variable that contains JSON formatted text/p>/li>li>p>a function that gives a JSON formatted text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>$.path: value that matches a text key in the JSON formatted text/p>div classulist>ul>li>p>may be “$.” plus/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>a variable that contains text/p>/li>li>p>a function that gives text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>JSONPATH(“age: 42”, “$.age”)/strong> would be 42/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>STRING/p>/td>td classtableblock halign-left valign-top>p classtableblock>Converts the value to text./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>STRING(value)/p>/div>div classulist>ul>li>p>value: value to be converted/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>text in double quotes/p>/li>li>p>a date/p>/li>li>p>a Boolean/p>/li>li>p>any variable/p>/li>li>p>any function/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>STRING(5493.07)/strong> would be 5493.07 as text instead of a decimal number/p>/div>div classparagraph>p>Say the school is a private school, strong>STRING(School.privateSchool)/strong> would be true as text instead of a Boolean/p>/div>div classparagraph>p>strong>STRING(DATECREATE(28,2,2017))/strong> would be Tue Feb 28 00:00:00 PST 2017 as text instead of a Date/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>UUID/p>/td>td classtableblock halign-left valign-top>p classtableblock>Creates a globally unique 36 character identifier./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>UUID()/p>/div>div classulist>ul>li>p>Takes no values, variables, or functions/p>/li>/ul>/div>div classparagraph>p>strong>UUID()/strong>’s identifiers look like:/p>/div>div classulist>ul>li>p>067e6162-3b6f-4ae2-a171-2470b63dff00/p>/li>li>p>54947df8-0e9e-4471-a2f9-9af509fb5889/p>/li>/ul>/div>/div>/td>/tr>/tbody>/table>/div>div classsect4>h5 id_html>HTML/h5>table classtableblock frame-all grid-all stretch>colgroup>col stylewidth: 33.3333%;>col stylewidth: 33.3333%;>col stylewidth: 33.3334%;>/colgroup>thead>tr>th classtableblock halign-left valign-top>Function/th>th classtableblock halign-left valign-top>Description/th>th classtableblock halign-left valign-top>Example/th>/tr>/thead>tbody>tr>td classtableblock halign-left valign-top>p classtableblock>HTML/p>/td>td classtableblock halign-left valign-top>p classtableblock>Creates a simple HTML tag./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>HTML(tag, text)/p>/div>div classulist>ul>li>p>tag: name of element/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>any of the following in double quotes/p>/li>li>p>h1 h2 h3 h4 h5 h6/p>/li>li>p>p/p>/li>li>p>em/p>/li>li>p>strong/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>text: content of tag/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>a variable that contains text/p>/li>li>p>a function that gives text or an HTML element as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say Person.Last Name was Smith, HTML(“h2”, Person.Last Name) would be <h2>Smith</h2>/p>/div>div classparagraph>p>strong>HTML(“p”, HTMLIMAGE(“http://www.piercecountywa.org/images/layout/design21/ClicktoHomeHP.jpg”))/strong> would be <p><img src’http://www.piercecountywa.org/images/layout/design21/ClicktoHomeHP.jpg’ ></p>/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>HTMLIMAGE/p>/td>td classtableblock halign-left valign-top>p classtableblock>Creates an HTML image tag./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>HTMLIMAGE(url, alternate-text)/p>/div>div classulist>ul>li>p>url: path to resource/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a path as text in double quotes/p>/li>li>p>a variable that contains a path in text/p>/li>li>p>a function that gives a path in text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>alternate-text: a description of the image/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>a variable that contains text/p>/li>li>p>a function that gives text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>HTMLIMAGE(“http://www.piercecountywa.org/images/layout/design21/ClicktoHomeHP.jpg”)/strong> would be <img src’http://www.piercecountywa.org/images/layout/design21/ClicktoHomeHP.jpg’ alt’Pierce County Logo – a white mountain on a blue background’>/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>HTMLLINK/p>/td>td classtableblock halign-left valign-top>p classtableblock>Creates an HTML link tag./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>HTMLLINK(text, url, optional-open-location)/p>/div>div classulist>ul>li>p>text: text to display for link/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>text in double quotes/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>url: path to resource/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>text in double quotes/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>optional-open-location: how the browser should open the resource/p>div classulist>ul>li>p>does not have to be included/p>div classulist>ul>li>p>if not included, resource will open in current tab/p>/li>/ul>/div>/li>li>p>may be/p>div classulist>ul>li>p>any of these common values in double quotes/p>div classulist>ul>li>p>_blank/p>div classulist>ul>li>p>opens in a new tab/window/p>/li>/ul>/div>/li>li>p>_self/p>div classulist>ul>li>p>opens in current tab/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>or any from the target keyword complete list in double quotes/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>HTMLLINK(“Pierce County”, “http://www.piercecountywa.org/”, “_self”)/strong> would be <a href’http://www.piercecountywa.org/’ target’_self’>Pierce County</a>/p>/div>/div>/td>/tr>/tbody>/table>/div>div classsect4>h5 id_logical>Logical/h5>table classtableblock frame-all grid-all stretch>colgroup>col stylewidth: 33.3333%;>col stylewidth: 33.3333%;>col stylewidth: 33.3334%;>/colgroup>thead>tr>th classtableblock halign-left valign-top>Function/th>th classtableblock halign-left valign-top>Description/th>th classtableblock halign-left valign-top>Example/th>/tr>/thead>tbody>tr>td classtableblock halign-left valign-top>p classtableblock>AND/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when all of the values are true./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>AND(value1, value2, optional-value)/p>/div>div classulist>ul>li>p>value1, value2, optional-value: values on which to perform an ‘and’/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a boolean (true or false) value/p>/li>li>p>a function that gives a boolean (true or false) as the result/p>/li>li>p>any number of optional-values/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say a person’s phone number is published on the Pierce County intranet and they do want to recieve snow alerts, strong>AND(PhoneType.personPhones.intranetInd, PhoneType.personPhones.pcwarnInd)/strong> would be true/p>/div>div classparagraph>p>Say a person’s phone number is not published on the Pierce County intranet and they do want to recieve snow alerts,  strong>AND(PhoneType.personPhones.intranetInd, PhoneType.personPhones.pcwarnInd)/strong> would be false/p>/div>div classparagraph>p>Say a person’s phone number is not published on the Pierce County intranet and they do not want to recieve snow alerts,  strong>AND(PhoneType.personPhones.intranetInd, PhoneType.personPhones.pcwarnInd)/strong> would be false/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>BETWEEN/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when the first value is inclusively between the second and third values./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>BETWEEN(between, first, last)/p>/div>div classulist>ul>li>p>between: value to determine if it’s between or the same as either of the other two values/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>text in double quotes/p>/li>li>p>any variable/p>/li>li>p>any function/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>first: “smallest” value/p>div classulist>ul>li>p>must be same kind of value as between/p>/li>/ul>/div>/li>li>p>last: “largest” value/p>div classulist>ul>li>p>must be same kind of value as between/p>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>BETWEEN(5, 1, 10)/strong> would be true/p>/div>div classparagraph>p>strong>BETWEEN(-3, -1, 5)/strong> would be false/p>/div>div classparagraph>p>Say the person was hired on Apr 4th, 2004, strong>BETWEEN(Person.regularHireDt, DATECREATE(4,4,2004), DATECREATE4,4,2014)/strong> would be true/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>EQUALS/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when the two values are equal. Text comparison is case sensitive./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>EQUALS(value1, value2)/p>/div>div classulist>ul>li>p>value1 and value2: values to determine if they are equal/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>text in double quotes – case sensitive/p>/li>li>p>any variable/p>/li>li>p>any function/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>EQUALS(2, 2)/strong> would be true/p>/div>div classparagraph>p>strong>EQUALS(“squirrel”, “SQUIRREL”)/strong> would be false/p>/div>div classparagraph>p>strong>EQUALS(DATECREATE(22, 1, 1975), NOW())/strong> would be false/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>EQUALSIGNORECASE/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when the two strings are equals regardless of case./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>EQUALSIGNORECASE(value1, value2)/p>/div>div classulist>ul>li>p>value1 and value2: values to determine if they are equal/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>text in double quotes – case insensitive/p>/li>li>p>any variable/p>/li>li>p>any function/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>EQUALSIGNORECASE(2, 2)/strong> would be true/p>/div>div classparagraph>p>strong>EQUALSIGNORECASE(“squirrel”, “SQUIRREL”)/strong> would be true/p>/div>div classparagraph>p>strong>EQUALSIGNORECASE(DATECREATE(22, 1, 1975), NOW())/strong> would be false/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>GREATERTHAN/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when the first value is greater than the second value./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>GREATERTHAN(value1, value2)/p>/div>div classulist>ul>li>p>value1: value to determine if it’s greater than the second value/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>text in double quotes – case insensitive/p>/li>li>p>any variable/p>/li>li>p>any function/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>value2: value to determine if it’s less than the first value/p>div classulist>ul>li>p>must be same kind of value as value1/p>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>GREATERTHAN(10, 2)/strong> would be true/p>/div>div classparagraph>p>strong>GREATERTHAN(2, 2)/strong> would be false/p>/div>div classparagraph>p>strong>GREATERTHAN(“dog”, “dog”)/strong> would be false/p>/div>div classparagraph>p>strong>GREATERTHAN(“Dog”, “dog”)/strong> would be false because of the capital letter/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>GREATERTHANOREQUAL/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when the first value is greater than or equal to the second value./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>GREATERTHANOREQUAL(value1, value2)/p>/div>div classulist>ul>li>p>value1: value to determine if it’s greater than or equal to the second value/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>text in double quotes – case insensitive/p>/li>li>p>any variable/p>/li>li>p>any function/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>value2: value to determine if it’s less than the first value/p>div classulist>ul>li>p>must be same kind of value as value1/p>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>GREATERTHANOREQUAL(10, 2)/strong> would be true/p>/div>div classparagraph>p>strong>GREATERTHANOREQUAL(2, 2)/strong> would be true/p>/div>div classparagraph>p>strong>GREATERTHANOREQUAL(“dog”, “dog”)/strong> would be true/p>/div>div classparagraph>p>strong>GREATERTHANOREQUAL(“Dog”, “dog”)/strong> would be false because of the capital letter/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>IF/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives the second or third value depending on whether the first value is true./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>IF(examined-value, true-value, false-value)/p>/div>div classulist>ul>li>p>examined-value: value on which to determine if true or false/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a Boolean (true or false) value/p>/li>li>p>a function that gives a Boolean (true or false) as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>true-value: value to return if examined-value evaluates to true/p>div classulist>ul>li>p>may be any type of value/p>/li>/ul>/div>/li>li>p>false-value: value to return if examined-value evaluates to false/p>div classulist>ul>li>p>may be any type of value/p>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say a question on a form does not have an answer, strong>IF(ISNULL(Form Answer.Answer), 0, 10)/strong> would be 0/p>/div>div classparagraph>p>Say a question on a form does have an answer, strong>IF(ISNULL(Form Answer.Answer), 0, 10)/strong> would be 10/p>/div>div classparagraph>p>Say today was Jan 18, 2017 and the address was updated Sep 18, 2016, strong>IF(GREATERTHAN(Address.lastUpdated, DATEADD(-1, “year”, NOW())), “Address was updated in the last year”, “Address was not updated in the last year”)/strong> would be Address was updated in the last year/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>IN/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when the first value is found in any of the other provided values./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>IN(find-value, value, optional-value)/p>/div>div classulist>ul>li>p>find-value: value to match to the other provided values/p>/li>li>p>value: value to compare to the value being found/p>/li>li>p>optional-value: other values to compare to the value being found/p>/li>li>p>all must be of the same kind of value/p>/li>li>p>all may be/p>div classulist>ul>li>p>whole or decimal number/p>/li>li>p>text in double quotes/p>/li>li>p>a variable that contains a whole or decimal number or text/p>/li>li>p>a function that gives a whole or decimal number or text as the result/p>/li>li>p>any number of optional-values/p>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>IN(42, 57)/strong> would be false/p>/div>div classparagraph>p>strong>IN(42, 57, 42, 13, 999, 13, 0)/strong> would be true/p>/div>div classparagraph>p>Say the person’s last name was Black, strong>IN(Person.Last Name, “Smith”, “Blackstone”, “Jones”)/strong> would be false/p>/div>div classparagraph>p>Say the person’s last name was Black, strong>IN(Person.Last Name, “Smith”, “Black”, “Jones”)/strong> would be true/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>ISNULL/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when the value is null./p>p classtableblock>(Null is not a value.)/p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>ISNULL(variable-or-function)/p>/div>div classulist>ul>li>p>variable-or-function: value to evaluate if it’s been set to something/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable/p>/li>li>p>a function/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say a decedent’s social security number is not set, strong>ISNULL(Decedent.SSN)/strong> is true/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>LESSTHAN/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when the first value is less than the second value./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>LESSTHAN(value1, value2)/p>/div>div classulist>ul>li>p>value1: value to determine if it’s less than the second value/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>text in double quotes – case insensitive/p>/li>li>p>any variable/p>/li>li>p>any function/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>value2: value to determine if it’s greater than the first value/p>div classulist>ul>li>p>must be same kind of value as value1/p>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>LESSTHAN(10, 2)/strong> would be false/p>/div>div classparagraph>p>strong>LESSTHAN(2, 2)/strong> would be false/p>/div>div classparagraph>p>strong>LESSTHAN(“dog”, “dog”)/strong> would be false/p>/div>div classparagraph>p>strong>LESSTHAN(“Dog”, “dog”)/strong> would be true because of the capital letter/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>LESSTHANOREQUAL/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when the first value is less than or equal to the second value./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>LESSTHANOREQUAL(value1, value2)/p>/div>div classulist>ul>li>p>value1: value to determine if it’s less than or equal to the second value/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>text in double quotes – case insensitive/p>/li>li>p>any variable/p>/li>li>p>any function/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>value2: value to determine if it’s greater than the first value/p>div classulist>ul>li>p>must be same kind of value as value1/p>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>LESSTHANOREQUAL(10, 2)/strong> would be false/p>/div>div classparagraph>p>strong>LESSTHANOREQUAL(2, 2)/strong> would be true/p>/div>div classparagraph>p>strong>LESSTHANOREQUAL(“dog”, “dog”)/strong> would be true/p>/div>div classparagraph>p>strong>LESSTHANOREQUAL(“Dog”, “dog”)/strong> would be true because of the capital letter/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>NOT/p>/td>td classtableblock halign-left valign-top>p classtableblock>Turn true to false and false to true./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>NOT(value)/p>/div>div classulist>ul>li>p>value: value to reverse/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a boolean (true or false) value/p>/li>li>p>a function that gives a boolean (true or false) as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say an adoption docket number is not set, strong>NOT(ISNULL(Adoption.docketNum))/strong> would be false/p>/div>div classparagraph>p>Say an adoption docket number is set, strong>NOT(ISNULL(Adoption.docketNum))/strong> would be true/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>OR/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when any of the values are true./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>OR(value1, value2, optional-value)/p>/div>div classulist>ul>li>p>value1, value2, optional-value: values on which to perform an ‘or’/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains a boolean (true or false) value/p>/li>li>p>a function that gives a boolean (true or false) as the result/p>/li>li>p>any number of optional-values/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say a person’s phone number is published on the Pierce County intranet and they do want to recieve snow alerts, strong>OR(PhoneType.personPhones.intranetInd, PhoneType.personPhones.pcwarnInd)/strong> would be true/p>/div>div classparagraph>p>Say a person’s phone number is not published on the Pierce County intranet and they do want to recieve snow alerts,  strong>OR(PhoneType.personPhones.intranetInd, PhoneType.personPhones.pcwarnInd)/strong> would be true/p>/div>div classparagraph>p>Say a person’s phone number is not published on the Pierce County intranet and they do not want to recieve snow alerts,  strong>OR(PhoneType.personPhones.intranetInd, PhoneType.personPhones.pcwarnInd)/strong> would be false/p>/div>/div>/td>/tr>/tbody>/table>/div>div classsect4>h5 id_number>Number/h5>table classtableblock frame-all grid-all stretch>colgroup>col stylewidth: 33.3333%;>col stylewidth: 33.3333%;>col stylewidth: 33.3334%;>/colgroup>thead>tr>th classtableblock halign-left valign-top>Function/th>th classtableblock halign-left valign-top>Description/th>th classtableblock halign-left valign-top>Example/th>/tr>/thead>tbody>tr>td classtableblock halign-left valign-top>p classtableblock>ABS/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate the absolute value of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>ABS(value)/p>/div>div classulist>ul>li>p>value: value to get the absolute value of/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>ABS(-12)/strong> would be 12/p>/div>div classparagraph>p>strong>ABS(9.5)/strong> would be 9.5/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>ACOS/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate the arccosine of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>ACOS(value)/p>/div>div classulist>ul>li>p>value: value to get the arccosine of/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number between -1 and 1 inclusive/p>/li>li>p>a variable that contains a whole or decimal number between -1 and 1 inclusive/p>/li>li>p>a function that gives a whole or decimal number between -1 and 1 inclusive as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>ACOS(-1)/strong> would be 3.141592653589793/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>ADD/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculates the sum of the numbers./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>ADD(value1, value2, optional-value)/p>/div>div classulist>ul>li>p>value1, value2, optional-value: values to add together/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>li>p>any number of optional-values/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>ADD(1, 2)/strong> would be 3/p>/div>div classparagraph>p>strong>ADD(3, 4.5, 6, 7, 8.9)/strong> would be 30.3/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>ASIN/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate the arcsine of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>ASIN(value)/p>/div>div classulist>ul>li>p>value: value to get the arcsine of/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number between -1 and 1 inclusive/p>/li>li>p>a variable that contains a whole or decimal number between -1 and 1 inclusive/p>/li>li>p>a function that gives a whole or decimal number between -1 and 1 inclusive as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>ASIN(-1)/strong> would be -1.5707963267948966/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>ATAN/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate arctangent of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>ATAN(value)/p>/div>div classulist>ul>li>p>value: value to get the arctangent of/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>ATAN(1)/strong> would be 0.7853981633974483/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>CEIL/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate the ceiling of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>CEIL(value)/p>/div>div classulist>ul>li>p>value: value to round up to the nearest whole number/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>CEIL(12.67)/strong> would be 13.0/p>/div>div classparagraph>p>strong>CEIL(-1.1)/strong> would be -1.0/p>/div>div classparagraph>p>strong>CEIL(4.3)/strong> would be 5.0/p>/div>div classparagraph>p>strong>CEIL(4)/strong> would be 4.0/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>COS/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate cosine of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>COS(value)/p>/div>div classulist>ul>li>p>value: value to get the cosine of/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>COS(1)/strong> would be 0.5403023058681398/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>COT/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate cotangent of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>COT(value)/p>/div>div classulist>ul>li>p>value: value to get the cotangent of/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>COT(1)/strong> would be 0.642092615934331/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DEGREES/p>/td>td classtableblock halign-left valign-top>p classtableblock>Convert radians to degrees./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DEGREES(value)/p>/div>div classulist>ul>li>p>value: value to convert/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>DEGREES(1)/strong> would be 57.29577951308232/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DIVIDE/p>/td>td classtableblock halign-left valign-top>p classtableblock>Divide each number by the next number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DIVIDE(dividend, divisor, optional-divisor)/p>/div>div classulist>ul>li>p>dividend: value to be divided/p>/li>li>p>divisor: value to divide by/p>/li>li>p>oprional-divisor: any number of additional values to divid by/p>div classulist>ul>li>p>any may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>DIVIDE(10, 2)/strong> would be 5.0/p>/div>div classparagraph>p>strong>DIVIDE(6.4, 8)/strong> would be 0.8/p>/div>div classparagraph>p>strong>DIVIDE(1.2, 2.3, 3.4, 4.5)/strong> would be 0.03410059676044331/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DOUBLE/p>/td>td classtableblock halign-left valign-top>p classtableblock>Convert the value to a double./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DOUBLE(value)/p>/div>div classulist>ul>li>p>value: value to convert/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number or a text number in double quotes/p>/li>li>p>a variable that contains a whole or decimal number a text number in double quotes/p>/li>li>p>a function that gives a whole or decimal number a text number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>DOUBLE(“1.23”)/strong> would be 1.23/p>/div>div classparagraph>p>strong>DOUBLE(“3”)/strong> would be 3.0/p>/div>div classparagraph>p>strong>DOUBLE(3)/strong> would be 3.0/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>EXP/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate the value of e to the x./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>EXP(power)/p>/div>div classulist>ul>li>p>e: base value that is a mathematical irrational constant (similar to π) and approximately equal to 2.718281828459045/p>/li>li>p>power: value to raise the base by/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>EXP(0)/strong> would be 1.0/p>/div>div classparagraph>p>strong>EXP(1)/strong> would be approximately 2.718281828459045/p>/div>div classparagraph>p>strong>EXP(-1)/strong> would be approximately 0.36787944117144233/p>/div>div classparagraph>p>strong>EXP(2)/strong> would be approximately 7.38905609893065/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>FLOOR/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate the floor of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>FLOOR(value)/p>/div>div classulist>ul>li>p>value: value to round down to the nearest whole number/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>FLOOR(12.67)/strong> would be 12.0/p>/div>div classparagraph>p>strong>FLOOR(-1.1)/strong> would be -2.0/p>/div>div classparagraph>p>strong>FLOOR(4.3)/strong> would be 4.0/p>/div>div classparagraph>p>strong>FLOOR(4)/strong> would be 4.0/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>LOG/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate natural (e) logarithm of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>LOG(result)/p>/div>div classulist>ul>li>p>e: base value that is a mathematical irrational constant (similar to π) and approximately equal to 2.718281828459045/p>/li>li>p>result: value to find the raised exponent of/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>LOG(0)/strong> would be infinity/p>/div>div classparagraph>p>strong>LOG(2.718281828459045)/strong> would be 1.0/p>/div>div classparagraph>p>strong>LOG(0.367879441171442)/strong> would be approximately -1.0/p>/div>div classparagraph>p>strong>LOG(7.389056098930649)/strong> would be approximately 2.0/p>/div>div classparagraph>p>strong>LOG(10)/strong> would be approximately 2.302585092994046/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>MAX/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives the largest number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>MAX(value1, value2, optional-value)/p>/div>div classulist>ul>li>p>value1, value2, optional-value: values to compare/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>li>p>any number of optional-values/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>MAX(10, 5)/strong> would be 10/p>/div>div classparagraph>p>strong>MAX(5.2, 10)/strong> would be 10/p>/div>div classparagraph>p>strong>MAX(1.1, 3.3, 2.2, 0)/strong> would be 3.3/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>MIN/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives the smallest number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>MIN(value1, value2, optional-value)/p>/div>div classulist>ul>li>p>value1, value2, optional-value: values to compare/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>li>p>any number of optional-values/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>MIN(10.2, 5)/strong> would be 5/p>/div>div classparagraph>p>strong>MIN(5, 10)/strong> would be 5/p>/div>div classparagraph>p>strong>MIN(1.1, 3.3, 2.2, 0)/strong> would be 0.0/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>MOD/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate the remainder after one number is divided by the other number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>MOD(dividend, divisor)/p>/div>div classulist>ul>li>p>dividend: value to be divided/p>/li>li>p>divisor: value to divide by/p>div classulist>ul>li>p>either may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>MOD(14, 5)/strong> would be 4/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>MULTIPLY/p>/td>td classtableblock halign-left valign-top>p classtableblock>Multiply each number with the next number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>MULTIPLY(value1, value2, optional-value)/p>/div>div classulist>ul>li>p>value1, value2, optional-value: values to multiply together/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>li>p>any number of optional-values/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>MULTIPLY(10, 2)/strong> would be 20.0/p>/div>div classparagraph>p>strong>MULTIPLY(6.4, 8)/strong> would be 51.2/p>/div>div classparagraph>p>strong>MULTIPLY(1.2, 2.3, 3.4, 4.5)/strong> would be 42.227999999999994/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>NUMBERFORMAT/p>/td>td classtableblock halign-left valign-top>p classtableblock>Format a number as a string./p>p classtableblock>If format does not accommodate the provided precision, value will be rounded up./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>NUMBERFORMAT(number, format)/p>/div>div classulist>ul>li>p>number: number to format/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>format: the pattern to use for formatting/p>div classulist>ul>li>p>should be in quotes, IS case sensitive/p>/li>li>p>may be/p>div classulist>ul>li>p>any of these common values/p>/li>li>p>0: if no corresponding digit will show a 0/p>/li>li>p>#: if no corresponding digit will ignore/p>/li>li>p>./p>/li>li>p>,/p>/li>li>p>–/p>/li>li>p>or any from the a hrefhttps://docs.oracle.com/javase/tutorial/i18n/format/decimalFormat.html#numberpattern>Number Format Pattern Syntax/a>/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>NUMBERFORMAT(4.241234, “mark>./mark>”)/strong> would be 4.24/p>/div>div classparagraph>p>strong>NUMBERFORMAT(4.241234, “00.##”)/strong> would be 04.24/p>/div>div classparagraph>p>strong>NUMBERFORMAT(4.241234, “00.00”)/strong> would be 04.24/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>PI/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives the number for π./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>PI()/p>/div>div classparagraph>p>Takes no values, variables, or functions/p>/div>div classparagraph>p>strong>PI()/strong> would be approximately 3.141592653589793/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>POW/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate the base to the exponent power./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>POW(base, power)/p>/div>div classulist>ul>li>p>base: value to be raised/p>/li>li>p>power: value to raise the base by/p>div classulist>ul>li>p>either may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>POW(7, 2)/strong> would be 49/p>/div>div classparagraph>p>strong>POW(7, -2)/strong> would be 0.02040816326530612/p>/div>div classparagraph>p>strong>POW(-7, 2)/strong> would be 49/p>/div>div classparagraph>p>strong>POW(-7, -2)/strong> would be 0.02040816326530612/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>RADIANS/p>/td>td classtableblock halign-left valign-top>p classtableblock>Convert degrees to radians./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>RADIANS(value)/p>/div>div classulist>ul>li>p>value: value to convert/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>RADIANS(45)/strong> would be 0.7853981633974483/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>RANDOM/p>/td>td classtableblock halign-left valign-top>p classtableblock>Pick a random number inclusively between two numbers./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>RANDOM(first, last)/p>/div>div classulist>ul>li>p>first: smallest value/p>/li>li>p>last: largest value/p>div classulist>ul>li>p>either may be/p>div classulist>ul>li>p>a whole positive number/p>/li>li>p>a variable that contains a whole positive number/p>/li>li>p>a function that gives a whole positive number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>RANDOM(0, 10)/strong> would be a whole number between 0 and 10 inclusive/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>ROUND/p>/td>td classtableblock halign-left valign-top>p classtableblock>Round the number./p>p classtableblock>If there is a tie (5), value will be rounded up./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>ROUND(value)/p>/div>div classulist>ul>li>p>value: value to round to the nearest whole number, 5 rounds up./p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>ROUND(12.67)/strong> would be 13/p>/div>div classparagraph>p>strong>ROUND(-1.1)/strong> would be -1/p>/div>div classparagraph>p>strong>ROUND(4.3)/strong> would be 4/p>/div>div classparagraph>p>strong>ROUND(4)/strong> would be 4/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>ROUNDTODECIMAL/p>/td>td classtableblock halign-left valign-top>p classtableblock>Round the number to a specific number of decimal places. Optionally choose to round up or round down – if not specified and there is a tie (5), value will be rounded up./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>ROUNDTODECIMAL(value, number-decimal-places, optional-rounding-direction)/p>/div>div classulist>ul>li>p>value: value to round to a specific number of decimal places./p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>number-decimal-places: number of decimal places to round to./p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole number/p>/li>li>p>a variable that contains a whole number/p>/li>li>p>a function that gives a whole number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>optional-rounding-direction: indicates to round up or round down. True rounds up and false rounds down. If not specified and there is a tie (5), value will be rounded up./p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a Boolean/p>/li>li>p>a variable that contains a Boolean/p>/li>li>p>a function that gives a Boolean as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>ROUNDTODECIMAL(12.675, 2)/strong> would be 12.68/p>/div>div classparagraph>p>strong>ROUNDTODECIMAL(12.675, 2, true)/strong> would be 12.68/p>/div>div classparagraph>p>strong>ROUNDTODECIMAL(12.675, 2, false)/strong> would be 12.67/p>/div>div classparagraph>p>strong>ROUNDTODECIMAL(-1.15, 1)/strong> would be -1.2/p>/div>div classparagraph>p>strong>ROUNDTODECIMAL(4.398215, 1)/strong> would be 4.4/p>/div>div classparagraph>p>strong>ROUNDTODECIMAL(4.398215, 3)/strong> would be 4.398/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>SIN/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate sine of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>SIN(value)/p>/div>div classulist>ul>li>p>value: value to get the sine of/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>SIN(1)/strong> would be 0.8414709848078965/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>SQRT/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate the square root of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>SQRT(value)/p>/div>div classulist>ul>li>p>value: value to get the square root of/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>SQRT(9)/strong> would be 3.0/p>/div>div classparagraph>p>strong>SQRT(163.84)/strong> would be 12.8/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>SUBTRACT/p>/td>td classtableblock halign-left valign-top>p classtableblock>Subtract one number from next number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>SUBTRACT(value1, value2, optional-value)/p>/div>div classulist>ul>li>p>value1, value2, optional-value: values to subtract from each other/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>SUBTRACT(10, 3)/strong> would be 7.0/p>/div>div classparagraph>p>strong>SUBTRACT(3, 10)/strong> would be -7.0/p>/div>div classparagraph>p>strong>SUBTRACT(3, 10.5, 9)/strong> would be -16.5/p>/div>div classparagraph>p>strong>SUBTRACT(10.5, 9, 3)/strong> would be -1.5/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>TAN/p>/td>td classtableblock halign-left valign-top>p classtableblock>Calculate tangent of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>TAN(value)/p>/div>div classulist>ul>li>p>value: value to get the tangent of/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>TAN(1)/strong> would be 1.5574077246549023/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>TRUNC/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives the whole part of a number./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>TRUNC(value)/p>/div>div classulist>ul>li>p>value: value to truncate/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>a variable that contains a whole or decimal number/p>/li>li>p>a function that gives a whole or decimal number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>TRUNC(9.78)/strong> would be 9/p>/div>div classparagraph>p>strong>TRUNC(9)/strong> would be 9/p>/div>div classparagraph>p>strong>TRUNC(-9.78)/strong> would be -9/p>/div>div classparagraph>p>strong>TRUNC(0.0004)/strong> would be 0/p>/div>div classparagraph>p>strong>TRUNC(-0.0004)/strong> would be -0/p>/div>/div>/td>/tr>/tbody>/table>/div>div classsect4>h5 id_text>Text/h5>table classtableblock frame-all grid-all stretch>colgroup>col stylewidth: 33.3333%;>col stylewidth: 33.3333%;>col stylewidth: 33.3334%;>/colgroup>thead>tr>th classtableblock halign-left valign-top>Function/th>th classtableblock halign-left valign-top>Description/th>th classtableblock halign-left valign-top>Example/th>/tr>/thead>tbody>tr>td classtableblock halign-left valign-top>p classtableblock>CONCATENATE/p>/td>td classtableblock halign-left valign-top>p classtableblock>Combines multiple text values./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>CONCATENATE(value1, value2, optional-other-values)/p>/div>div classulist>ul>li>p>value1, value2, and optional-other-values: values to combine/p>div classulist>ul>li>p>all may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>a variable that contains text/p>/li>li>p>a function that gives text as the result/p>/li>li>p>add as many optional-other-values as desired/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say NAME contained ‘Pierce County’, strong>CONCATENATE(“Hello “, NAME)/strong> would be Hello Pierce County/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>DECODEBASE64STRING/p>/td>td classtableblock halign-left valign-top>p classtableblock>Decode a base 64 encoded text to an array of bytes./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>DECODEBASE64STRING(value)/p>/div>div classulist>ul>li>p>value: value to be converted/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>a variable that contains text that contains a base 64 representation of an image/p>/li>li>p>a function that gives a base 64 representation of an image as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say Base64Text containted a base 64 text value, strong>DECODEBASE64STRING(Base64Text)/strong> would be a byte array of that text/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>ENDSWITH/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when the value ends with the other value./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>ENDSWITH(whole, part)/p>/div>div classulist>ul>li>p>whole: value to check if it ends with another value/p>/li>li>p>part: ending value/p>/li>li>p>either may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>any variable that contains text/p>/li>li>p>any function that gives text as the result/p>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>Say the person’s first name was Betty, strong>ENDSWITH(person.First Name, “ett”)/strong> would be false/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>INDEXOF/p>/td>td classtableblock halign-left valign-top>p classtableblock>Find the index (starting with 0) of the first instance of the second value in the first value./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>INDEXOF(whole, part)/p>/div>div classulist>ul>li>p>whole: value to check where the part starts/p>/li>li>p>part: value to find where it starts in the whole/p>div classulist>ul>li>p>either may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>any variable that contains text/p>/li>li>p>any function that gives text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>INDEXOF(“hello world”, “w”)/strong> would be 6/p>/div>div classparagraph>p>strong>INDEXOF(“hello world”, “world”)/strong> would be 6/p>/div>div classparagraph>p>strong>INDEXOF(“hello world of worlds”, “world”)/strong> would be 6/p>/div>div classparagraph>p>strong>INDEXOF(“hello world”, “worlds”)/strong> would be -1/p>/div>div classparagraph>p>strong>INDEXOF(“hello world”,”h”)/strong> would be 0/p>/div>div classparagraph>p>strong>INDEXOF(“hello world”,”H”)/strong> would be -1 because of the capital letter/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>INTEGER/p>/td>td classtableblock halign-left valign-top>p classtableblock>Convert the value to an integer./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>INTEGER(value)/p>/div>div classulist>ul>li>p>value: value to convert/p>div classulist>ul>li>p>may be any/p>div classulist>ul>li>p>a whole or decimal number/p>/li>li>p>text in double quotes/p>/li>li>p>any variable that contains whole or decimal number or text/p>/li>li>p>any function gives whole or decimal number or text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>INTEGER(“6”)/strong> would be 6/p>/div>div classparagraph>p>strong>INTEGER(6.4)/strong> would be 6/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>LASTINDEXOF/p>/td>td classtableblock halign-left valign-top>p classtableblock>Find the index (starting with 0) of the last occurrence of the second string in the first string./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>LASTINDEXOF(whole, part)/p>/div>div classulist>ul>li>p>whole: value to check where the last matching part starts/p>/li>li>p>part: value to find the last matching in the whole/p>div classulist>ul>li>p>either may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>any variable that contains text/p>/li>li>p>any function that gives text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>LASTINDEXOF(“hello world”, “l”)/strong> would be 9/p>/div>div classparagraph>p>strong>LASTINDEXOF(“hello world”, “lo”)/strong> would be 3/p>/div>div classparagraph>p>strong>LASTINDEXOF(“hello world of worlds”, “world”)/strong> would be 15/p>/div>div classparagraph>p>strong>LASTINDEXOF(“hello world”, “worlds”)/strong> would be -1/p>/div>div classparagraph>p>strong>LASTINDEXOF(“hello world”, “h”)/strong> would be 0/p>/div>div classparagraph>p>strong>LASTINDEXOF(“hello world”,”H”)/strong> would be -1 because of the capital letter/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>LENGTH/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives the count of letters, numbers, and symbols contained in the text./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>LENGTH(value)/p>/div>div classulist>ul>li>p>value: value to count/p>div classulist>ul>li>p>either may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>any variable that contains text/p>/li>li>p>any function that gives text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>LENGTH(“hello”)/strong> would 5/p>/div>div classparagraph>p>strong>LENGTH(“4.321”)/strong> would be 5/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>LOWERCASE/p>/td>td classtableblock halign-left valign-top>p classtableblock>Convert text to all small letters./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>LOWERCASE(value)/p>/div>div classulist>ul>li>p>value: value to change small letters/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>any variable that contains text/p>/li>li>p>any function that gives text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>LOWERCASE(“Hello”)/strong> would be hello/p>/div>div classparagraph>p>strong>LOWERCASE(“HELLO”)/strong> would be hello/p>/div>div classparagraph>p>strong>LOWERCASE(“9:30 PM”)/strong> would be 9:30 pm/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>REPLACE/p>/td>td classtableblock halign-left valign-top>p classtableblock>In the first value, replace all occurrences of what’s in the second value with what’s in the third value./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>REPLACE(whole, part-to-replace, replace-with)/p>/div>div classulist>ul>li>p>whole: value to have part of replaced/p>/li>li>p>part-to-replace: value to find the first occurrence in the whole to be replaced/p>/li>li>p>replace-with: value to put in place of the original value/p>div classulist>ul>li>p>all may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>any variable that contains text/p>/li>li>p>any function gives text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>REPLACE(“hello world”, “hello”, “hi”)/strong> would be hi world/p>/div>div classparagraph>p>strong>REPLACE(“1234.12”, “12”, “99”)/strong> would be 9934.99/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>STARTSWITH/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives true when the first value starts with the second value./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>STARTSWITH(whole, part)/p>/div>div classulist>ul>li>p>whole: value to check if it starts with another value/p>/li>li>p>part: starting value/p>div classulist>ul>li>p>all may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>any variable that contains text/p>/li>li>p>any function gives text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>STARTSWITH(“Hello there”, “Hello”)/strong> would be true/p>/div>div classparagraph>p>strong>STARTSWITH(“Hello there”, “hello”)/strong> would be false because of the small letter/p>/div>div classparagraph>p>strong>STARTSWITH(“123456”, “1234”)/strong> would be true/p>/div>div classparagraph>p>strong>STARTSWITH(“1234xyz”, “1234”)/strong> would be true/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>SUBSTRING/p>/td>td classtableblock halign-left valign-top>p classtableblock>Gives the letters, numbers, and symbols found between and including the start and finish numbers. Beginning of value would be the number 0./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>SUBSTRING(whole, start-location, optional-end-location)/p>/div>div classulist>ul>li>p>whole: value to copy letters, number, and symbols from/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>any variable that contains text/p>/li>li>p>any function that gives text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>start-location: where to start in the whole to begin copying/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>whole number/p>/li>li>p>any variable that contains a whole number/p>/li>li>p>any function that gives a whole number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>optional-end-location: where to stop in the whole to end copying/p>div classulist>ul>li>p>does not have to be included (if not included, will copy to the end of the text)/p>/li>li>p>may be/p>div classulist>ul>li>p>whole number/p>/li>li>p>any variable that contains a whole number/p>/li>li>p>any function that gives a whole number as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>SUBSTRING(“ABCDEFG”,  2,  5)/strong> would be CDE/p>/div>div classparagraph>p>strong>SUBSTRING(“ABCDEFG”,  0,  5)/strong> would be ABCDE/p>/div>div classparagraph>p>strong>SUBSTRING(“ABCDEFG”,  4)/strong> would be EFG/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>TEMPLATE/p>/td>td classtableblock halign-left valign-top>p classtableblock>Use a pattern to build text./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>TEMPLATE(pattern, %value1, optional-%values)/p>/div>div classulist>ul>li>p>pattern: sequence of %specifiers, letters, numbers, and symbols./p>div classulist>ul>li>p>%specifiers will be replaced in order with the %values/p>/li>li>p>there must be the same number of %specifiers as %values in the pattern/p>/li>li>p>%specifiers may be/p>div classulist>ul>li>p>any of these common format specifiers/p>div classulist>ul>li>p>%d/p>div classulist>ul>li>p>specifier for a whole number/p>/li>/ul>/div>/li>li>p>%f/p>div classulist>ul>li>p>specifier for a decimal number/p>/li>li>p>if format has less precision than the number provided it will be rounded up/p>/li>/ul>/div>/li>li>p>%s/p>div classulist>ul>li>p>specifier for text/p>/li>/ul>/div>/li>li>p>%%/p>div classulist>ul>li>p>show the percent sign/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>or any from the format specifiers in the ‘FORMATTED OUTPUT WITH printf‘ section/p>/li>/ul>/div>/li>/ul>/div>/li>li>p>%value1: value to put in place of the first %element/p>/li>li>p>optional-%values: value to put in place of the other %specifiers in the order they appear/p>/li>li>p>%values may be any kind of value/p>/li>/ul>/div>div classparagraph>p>strong>TEMPLATE(“My %s %s!”, “Pierce”, “County”)/strong> would be My Pierce County!/p>/div>div classparagraph>p>Say a person’s name was John Q. Public, strong>TEMPLATE(“%s %s %s”, Person.Last Name, Person.Middle Name, Person.First Name)/strong> would be Public Q. John/p>/div>div classparagraph>p>strong>TEMPLATE(“PC!”,”Pierce”,”County”)/strong> would be PC! as no %s was provided/p>/div>div classparagraph>p>Say today was Oct 24th, 1991, strong>TEMPLATE(“Today is: %s”, DATEFORMAT(NOW(), “YY MMMM 13”))/strong> would be Today is: 24 October 91/p>/div>div classparagraph>p>strong>TEMPLATE(“%d days to go!”, 99)/strong> would be 99 days to go!/p>/div>div classparagraph>p>strong>TEMPLATE(“%d %s”, 99, ” days to go!”)/strong> would be 99 days to go!/p>/div>div classparagraph>p>strong>TEMPLATE(“%f”, 13)/strong> would be 13.000000/p>/div>div classparagraph>p>strong>TEMPLATE(“%.2f”, 13)/strong> would be 13.00/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>TRIM/p>/td>td classtableblock halign-left valign-top>p classtableblock>Remove spaces found at the very beginning and very end of text./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>TRIM(value)/p>/div>div classulist>ul>li>p>value: value to remove extra spaces from/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>a variable that contains text/p>/li>li>p>a function that gives text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>TRIM(”   hello sunshine!  “)/strong> would be hello sunshine!/p>/div>div classparagraph>p>strong>TRIM(”   hello     sunshine!  “)/strong> would be hello     sunshine!/p>/div>/div>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>UPPERCASE/p>/td>td classtableblock halign-left valign-top>p classtableblock>Convert text to all capital letters./p>/td>td classtableblock halign-left valign-top>div classcontent>div classparagraph>p>UPPERCASE(value)/p>/div>div classulist>ul>li>p>value: value to change to capital letters/p>div classulist>ul>li>p>may be/p>div classulist>ul>li>p>text in double quotes/p>/li>li>p>any variable that contains text/p>/li>li>p>any function that gives text as the result/p>/li>/ul>/div>/li>/ul>/div>/li>/ul>/div>div classparagraph>p>strong>UPPERCASE(“Hello”)/strong> would be HELLO/p>/div>div classparagraph>p>strong>UPPERCASE(“heLLO”)/strong> would be HELLO/p>/div>div classparagraph>p>strong>UPPERCASE(“9:30 pm”)/strong> would be 9:30 PM/p>/div>/div>/td>/tr>/tbody>/table>/div>/div>/div>div classsect2>h3 id_constraints>Constraints/h3>/div>div classsect2>h3 id_security>Security/h3>/div>div classsect2>h3 id_reporting>Reporting/h3>div classsect3>h4 id_queries>Queries/h4>div classparagraph>p>strong>Introducing Dynamic Queries/strong>/p>/div>div classvideoblock>div classcontent>video srchttps://pac.piercecountywa.gov/FDIS-Query-Intro-Video-Final-for-Review.mp4 width600 controls>Your browser does not support the video tag./video>/div>/div>/div>div classsect3>h4 id_reports>Reports/h4>div classparagraph>p>strong>How to Create a Simple Jasper Report/strong>/p>/div>div classparagraph>p>Prerequisites: 1) Create a query that does not contain subqueries and 2) download and install Jaspersoft® Studio./p>/div>div classparagraph>p>Run your query and export the result as an “XML (Report)”. Save the downloaded XML file to MyReports in your Jaspersoft work space. The default location is C:\Users\$USERNAME\JaspersoftWorkspace\MyReports.  (Replace $USERNAME with your login name.)/p>/div>div classparagraph>p>In Jaspersoft Studio, create a data adapter as follows:/p>/div>div classulist>ul>li>p>Select File / New / Data Adapter./p>/li>li>p>Select “XML document” as the type of data adapter./p>/li>li>p>Enter the query name as the name of the data adapter./p>/li>li>p>Select the XML file from the C:\Users\$USERNAME\JaspersoftWorkspace\My Reports. (Replace $USERNAME with your login name.)/p>/li>li>p>Choose “Use the report Xpath expression when filling the report”/p>/li>li>p>Press the Finish button./p>/li>li>p>Set the XPath to /root/queries/query/results/DataObject./p>/li>/ul>/div>div classparagraph>p>Set the REPORT_PATH defaultValueExpression to C:/Users/$USERNAME/JaspersoftWorkspace/MyReports. (Replace $USERNAME with your login name.)/p>/div>div classparagraph>p>To be continued…/p>/div>/div>/div>div classsect2>h3 id_workflow>Workflow/h3>div classsect3>h4 id_task_definitions>Task Definitions/h4>/div>div classsect3>h4 id_task_events>Task Events/h4>/div>/div>div classsect2>h3 id_forms>Forms/h3>/div>div classsect2>h3 id_tags>Tags/h3>div classsect3>h4 id_definition>Definition/h4>div classparagraph>p>Tags are a means to associate components, such as queries and reports, to multiple categories./p>/div>/div>div classsect3>h4 id_guidelines>Guidelines/h4>div classsect4>h5 id_industry_recommendations>Industry Recommendations/h5>div classulist>ul>li>p>Establish a tagging system/p>/li>li>p>Make tags consistent/p>div classulist>ul>li>p>Singular vs. plural/p>/li>li>p>Nouns vs. verbs/p>/li>li>p>Capitalization/p>/li>li>p>Usage of spaces/p>/li>li>p>Usage of special characters/p>/li>/ul>/div>/li>li>p>Keep tag names short/p>/li>li>p>Err on the side of using too many tags rather than too few tags/p>/li>li>p>Don’t replicate terms/p>/li>li>p>Limit usage of abbreviations/p>/li>li>p>Use words that identify what is recognizable about the item you are tagging/p>/li>li>p>Revisit tag selection from time to time/p>/li>/ul>/div>/div>div classsect4>h5 id_pierce_county_requirements>Pierce County Requirements/h5>div classulist>ul>li>p>Make tags consistent/p>div classulist>ul>li>p>Use mixed case for better readability/p>/li>li>p>Use spaces for better readability/p>/li>li>p>Do not use anything other than letters, numbers, or spaces to avoid duplicates where the only difference might be a hyphen/p>/li>/ul>/div>/li>li>p>Err on the side of using too many tags rather than too few tags/p>div classulist>ul>li>p>Say you needed to tag queries with the following values: Blue, Red, Yellow, Blue Red, Blue Yellow, Red Yellow, Blue Red Yellow/p>/li>li>p>If short tag names were used, you would only have to create 3 tags/p>/li>li>p>If long tag names were used, you would have to create 7 tags/p>/li>/ul>/div>/li>/ul>/div>table classtableblock frame-all grid-all stretch>colgroup>col stylewidth: 20%;>col stylewidth: 20%;>col stylewidth: 20%;>col stylewidth: 20%;>col stylewidth: 20%;>/colgroup>thead>tr>th classtableblock halign-left valign-top>Query Tag Values Needed/th>th classtableblock halign-left valign-top>Short Names/th>th classtableblock halign-left valign-top>Short Name Usage/th>th classtableblock halign-left valign-top>Long Names/th>th classtableblock halign-left valign-top>Long Name Usage/th>/tr>/thead>tbody>tr>td classtableblock halign-left valign-top>p classtableblock>Blue/p>/td>td classtableblock halign-left valign-top>p classtableblock>Blue/p>/td>td classtableblock halign-left valign-top>p classtableblock>Blue/p>/td>td classtableblock halign-left valign-top>p classtableblock>Blue/p>/td>td classtableblock halign-left valign-top>p classtableblock>Blue/p>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>Red/p>/td>td classtableblock halign-left valign-top>p classtableblock>Red/p>/td>td classtableblock halign-left valign-top>p classtableblock>Red/p>/td>td classtableblock halign-left valign-top>p classtableblock>Red/p>/td>td classtableblock halign-left valign-top>p classtableblock>Red/p>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>Yellow/p>/td>td classtableblock halign-left valign-top>p classtableblock>Yellow/p>/td>td classtableblock halign-left valign-top>p classtableblock>Yellow/p>/td>td classtableblock halign-left valign-top>p classtableblock>Yellow/p>/td>td classtableblock halign-left valign-top>p classtableblock>Yellow/p>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>Blue Red/p>/td>td classtableblock halign-left valign-top>/td>td classtableblock halign-left valign-top>p classtableblock>Blue + Red/p>/td>td classtableblock halign-left valign-top>p classtableblock>Blue Red/p>/td>td classtableblock halign-left valign-top>p classtableblock>Blue Red/p>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>Blue Yellow/p>/td>td classtableblock halign-left valign-top>/td>td classtableblock halign-left valign-top>p classtableblock>Blue + Yellow/p>/td>td classtableblock halign-left valign-top>p classtableblock>Blue Yellow/p>/td>td classtableblock halign-left valign-top>p classtableblock>Blue Yellow/p>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>Red Yellow/p>/td>td classtableblock halign-left valign-top>/td>td classtableblock halign-left valign-top>p classtableblock>Red + Yellow/p>/td>td classtableblock halign-left valign-top>p classtableblock>Red Yellow/p>/td>td classtableblock halign-left valign-top>p classtableblock>Red Yellow/p>/td>/tr>tr>td classtableblock halign-left valign-top>p classtableblock>Blue Red Yellow/p>/td>td classtableblock halign-left valign-top>/td>td classtableblock halign-left valign-top>p classtableblock>Blue + Red + Yellow/p>/td>td classtableblock halign-left valign-top>p classtableblock>Blue Red Yellow/p>/td>td classtableblock halign-left valign-top>p classtableblock>Blue Red Yellow/p>/td>/tr>/tbody>/table>/div>/div>/div>/div>/div>/div>div idfooter>div idfooter-text>Version 7.26.0-SNAPSHOTbr>Last updated 2021-04-13 18:13:21 UTC/div>/div>/body>/html>

View on OTX | View on ThreatMiner

Data with thanks to AlienVault OTX, VirusTotal, Malwr and others. [Sitemap]

Domain > pac.piercecountywa.gov

Is this malicious?

DNS Resolutions

Port 80

Port 443