NYU School of Medicine Human Resources © 2002 New York University Ethics and Disclaimer

GetCategoryName (Records=1, Time=0ms)
SQL = 
SELECT 	description
			  FROM  	HR_JOB_CATEGORY		
			WHERE 
				hr_job_category_id =
				8

GetSubCategoryName (Records=1, Time=15ms)
SQL = 
SELECT 	description					
			 FROM  	HR_FACULTY_SPECIALTY      
			 WHERE 
				HR_FACULTY_SPECIALTY_id=
				4

GetJobTypeName (Records=0, Time=0ms)
SQL = 
SELECT 	description
			  FROM  	HR_JOB_TYPE	
			WHERE 
				hr_job_type_id =
				
					-99

FindJobs (Records=0, Time=0ms)
SQL = 
SELECT 	P.hr_position_id,
					P.title,
					substr(P.Description,1,200) as description,
					to_char(P.receipt_dt,'MM/DD/YYYY') as receipt_date
			 FROM  	NYUSOM_HR_Position P,hr_job_status JS	
			WHERE 
				
				JS.job_status = 'Publish' AND 
				JS.hr_job_status_id = 	P.hr_job_status_id
				
					AND P.hr_job_category_id =8
				
					AND P.hr_faculty_specialty_id =4
					
			ORDER BY receipt_dt desc

47 milliseconds

URL Parameters:

CATEGORY=8
CFID=844267
CFTOKEN=60734883
FUSEACTION=joblistings.PerformSearch
JOBTYPE=
SUBCATEGORY=4
TEXTFIELD=

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=D:\inetpub\wwwroot\Findadocajob\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_ACCEPT=text/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET=ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CACHE_CONTROL=no-cache
HTTP_CONNECTION=close
HTTP_COOKIE=SESS1c32fc8a852537752513334be25e834c=fflgs7nbm4fifbu45r01uc49j7; SESS10a32a1aa3dce7aa19b05ea481d37e73=emt2mn746pfq3hnlotejg20484; SESS9c3f22a23a28a383cb5aa8ef2ce4d154=am8k33t7mrhlq9nfoqarj03ms0; CFID=844267; CFTOKEN=60734883
HTTP_HOST=tools.med.nyu.edu
HTTP_PRAGMA=no-cache
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID=ccc04-02
HTTP_X_FORWARDED_FOR=38.107.191.115
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/Findadocajob/index.cfm
PATH_TRANSLATED=D:\inetpub\wwwroot\Findadocajob\index.cfm
QUERY_STRING=fuseaction=joblistings.PerformSearch&Category=8&SubCategory=4&jobtype=&textfield=&CFID=844267&CFTOKEN=60734883
REMOTE_ADDR=10.128.180.22
REMOTE_HOST=10.128.180.22
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Findadocajob/index.cfm
SERVER_NAME=tools.med.nyu.edu
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI