Staff Directory - Flinders University Staff

SELECT users.userid,users.lastname,(nvl(preffirstname,firstname)) AS firstname1,users.title,(nvl(telephonenumber,'-')) AS telephonenumber1,(nvl(position,'-')) AS position1,users.oustructlevel1,users.oustructlevel2,users.oustructlevel3,users.oustructlevel4,users.oustructlevel5,( CASE WHEN staffnumber IS NOT NULL AND empstatuscode IS NOT NULL THEN TRIM(LOWER(SUBSTR(email, 0, INSTR(email, '@')-1))) ELSE '-' END ) AS staffprofile FROM users WHERE (nvl2(flinderspersonnotpublish,upper(flinderspersonnotpublish),'FALSE')) != ? AND (nvl(location,'-')) != ? AND users.FIRSTNAME NOT LIKE ? AND users.LASTNAME NOT LIKE ? AND ( ( users.STAFFNUMBER IS NOT NULL AND users.EMPSTATUSCODE IS NOT NULL AND ( users.EMPSTATUSCODE NOT IN (?,?,?,?,?,?,?,?,?,?,?) OR ( users.EMPSTATUSCODE IN (?,?) AND users.TELEPHONENUMBER IS NOT NULL ) ) ) OR ( users.PERSONTYPE = ? AND users.TELEPHONENUMBER IS NOT NULL ) ) AND (upper(regexp_replace(oustructlevel3,'[^a-zA-Z0-9]',''))) = ? AND (upper(regexp_replace(oustructlevel4,'[^a-zA-Z0-9]',''))) = ? AND (upper(regexp_replace(oustructlevel5,'[^a-zA-Z0-9]',''))) = ? ORDER BY (upper(lastname)) ASC,(upper(nvl(preffirstname,firstname))) ASC

SELECT users.oustructlevel1,users.oustructlevel2,users.oustructlevel3,users.oustructlevel4,users.oustructlevel5 FROM users WHERE (nvl2(flinderspersonnotpublish,upper(flinderspersonnotpublish),'FALSE')) != ? AND (nvl(location,'-')) != ? AND users.FIRSTNAME NOT LIKE ? AND users.LASTNAME NOT LIKE ? AND ( ( users.STAFFNUMBER IS NOT NULL AND users.EMPSTATUSCODE IS NOT NULL AND ( users.EMPSTATUSCODE NOT IN (?,?,?,?,?,?,?,?,?,?,?) OR ( users.EMPSTATUSCODE IN (?,?) AND users.TELEPHONENUMBER IS NOT NULL ) ) ) OR ( users.PERSONTYPE = ? AND users.TELEPHONENUMBER IS NOT NULL ) ) AND (upper(regexp_replace(oustructlevel3,'[^a-zA-Z0-9]',''))) = ? ORDER BY (upper(lastname)) ASC,(upper(nvl(preffirstname,firstname))) ASC

CGI Variables: AUTH_PASSWORD= AUTH_TYPE= AUTH_USER= CERT_COOKIE= CERT_FLAGS= CERT_ISSUER= CERT_KEYSIZE= CERT_SECRETKEYSIZE= CERT_SERIALNUMBER= CERT_SERVER_ISSUER= CERT_SERVER_SUBJECT= CERT_SUBJECT= CF_TEMPLATE_PATH=/opt/www/cfapps.flinders/directory/index.cfm CONTENT_LENGTH=0 CONTENT_TYPE= CONTEXT_PATH= GATEWAY_INTERFACE= HTTPS=on HTTPS_KEYSIZE= HTTPS_SECRETKEYSIZE= HTTPS_SERVER_ISSUER= HTTPS_SERVER_SUBJECT= HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_ACCEPT_ENCODING=gzip HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5 HTTP_CONNECTION=Keep-Alive HTTP_COOKIE= HTTP_HOST=www.flinders.edu.au HTTP_REFERER= HTTP_URL= HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/) LOCAL_ADDR=10.224.64.41 PATH_INFO=/search/structure PATH_TRANSLATED=/opt/www/cfapps.flinders/directory/index.cfm QUERY_STRING=oustructlevel=INFORMATIONANDDIGITALSERVICES&oulevel=3 REMOTE_ADDR=10.225.240.11 REMOTE_HOST=10.225.240.11 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/directory/index.cfm SERVER_NAME=www.flinders.edu.au SERVER_PORT=443 SERVER_PORT_SECURE=1 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips mod_jk/1.2.41 WEB_SERVER_API=

Session Variables: cfid=1958269 cftoken=1b985838a948b62-824A141E-F44E-75DE-C3A0CE974B68D552 flash=Struct (0) sessionid=6F417EA936F2CF04E4238AF94687606E_1958269_1b985838a948b62-824A141E-F44E-75DE-C3A0CE974B68D552 urltoken=CFID=1958269&CFTOKEN=1b985838a948b62-824A141E-F44E-75DE-C3A0CE974B68D552

Staff search results

Follow Flinders

This website uses cookies