Total Time	Avg Time	Count	Template
93 ms	93 ms	1	/opt/filestore/coldfusion/CF2023/eras/erasstats/Application.cfm
38 ms	38 ms	1	/opt/filestore/coldfusion/CF2023/eras/erasstats/par/index.cfm
33 ms	33 ms	1	/opt/coldfusion2023/cfusion/CustomTags/aamc_cfapplication/aamc_cfapplication.cfm
9 ms	9 ms	1	/opt/filestore/coldfusion/CF2023/eras/erasstats/par/top.cfm
0 ms	0 ms	1	/opt/filestore/coldfusion/CF2023/eras/erasstats/includes/css.cfm
0 ms	0 ms	1	/opt/filestore/coldfusion/CF2023/eras/erasstats/par/bottom.cfm
12 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
143 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SELECT var_value, var_name FROM eam_parameter
    WHERE var_name IN ('ES_MAINT_FLAG','ERAS_ACTIVE_SEASON_4_ERASSTATS')

SELECT var_value FROM eam_parameter

SELECT var_value, var_name FROM eam_parameter
    WHERE var_name IN ('ES_MAINT_FLAG','ERAS_ACTIVE_SEASON_4_ERASSTATS')

SELECT var_value FROM eam_parameter
    WHERE var_name IN ('ES_MAINT_MSG')

SELECT var_value FROM eam_parameter
    WHERE var_name IN ('ES_MAINT_PASSWORD')

SELECT 
					CASE 
						WHEN s.spec_grp_cd IS NULL THEN s.spec_name
						WHEN s.spec_grp_cd IS NOT NULL AND s.spec_merge_ind = 'Y' THEN sg.spec_grp_name
						ELSE s.spec_name 
					END AS spec_name,
					LISTAGG(s.spec_cd, ',') WITHIN GROUP (ORDER BY s.spec_cd) AS spec_cd,
					MAX(s.spec_timeline_cd) AS spec_timeline_cd,
					MAX(s.spec_nrmp_participate_ind) AS spec_nrmp_participate_ind,
					MAX(s.spec_start_yr) AS spec_start_yr,
					MAX(s.spec_msg) AS spec_msg,
					MAX(s.spec_merge_ind) AS spec_merge_ind
				FROM eras_ref.ref_specialty s
				LEFT JOIN eras_ref.ref_specialty_group sg ON s.spec_grp_cd = sg.spec_grp_cd
				WHERE s.spec_type_cd = 'F'
				AND s.spec_active_ind = 'Y'
				AND s.spec_timeline_cd = '04'
				AND s.spec_cd NOT IN ('DIO', 'O60')
				
					AND (
							(s.spec_merge_ind = 'Y' AND sg.spec_grp_name LIKE ?)
							OR (s.spec_merge_ind != 'Y' AND s.spec_name LIKE ?)
							OR (s.spec_merge_ind IS NULL AND s.spec_name LIKE ?)
						)
				
				
				
				GROUP BY 
					CASE 
						WHEN s.spec_grp_cd IS NULL THEN s.spec_name
						WHEN s.spec_grp_cd IS NOT NULL AND s.spec_merge_ind = 'Y' THEN sg.spec_grp_name
						ELSE s.spec_name 
					END
				ORDER BY spec_name

SELECT *
				FROM MDFellowshipJuly
				WHERE spec_start_yr = '2026'

SELECT 
					CASE 
						WHEN s.spec_grp_cd IS NULL THEN s.spec_name
						WHEN s.spec_grp_cd IS NOT NULL AND s.spec_merge_ind = 'Y' THEN sg.spec_grp_name
						ELSE s.spec_name 
					END AS spec_name,
					LISTAGG(s.spec_cd, ',') WITHIN GROUP (ORDER BY s.spec_cd) AS spec_cd,
					MAX(s.spec_timeline_cd) AS spec_timeline_cd,
					MAX(s.spec_nrmp_participate_ind) AS spec_nrmp_participate_ind,
					MAX(s.spec_start_yr) AS spec_start_yr,
					MAX(s.spec_msg) AS spec_msg,
					MAX(s.spec_merge_ind) AS spec_merge_ind
				FROM eras_ref.ref_specialty s
				LEFT JOIN eras_ref.ref_specialty_group sg ON s.spec_grp_cd = sg.spec_grp_cd
				WHERE s.spec_active_ind = 'Y'
				AND s.spec_type_cd = 'R'
				AND s.spec_cd NOT IN ('DIO', 'O60')
				
					AND (
							(s.spec_merge_ind = 'Y' AND sg.spec_grp_name LIKE ?)
							OR (s.spec_merge_ind != 'Y' AND s.spec_name LIKE ?)
							OR (s.spec_merge_ind IS NULL AND s.spec_name LIKE ?)
						)
				
				
				
				GROUP BY 
					CASE 
						WHEN s.spec_grp_cd IS NULL THEN s.spec_name
						WHEN s.spec_grp_cd IS NOT NULL AND s.spec_merge_ind = 'Y' THEN sg.spec_grp_name
						ELSE s.spec_name 
					END
				ORDER BY spec_name

SELECT *
				FROM ResidencyPgms
				WHERE spec_start_yr = '2026'

SELECT 
					CASE 
						WHEN s.spec_grp_cd IS NULL THEN s.spec_name
						WHEN s.spec_grp_cd IS NOT NULL AND s.spec_merge_ind = 'Y' THEN sg.spec_grp_name
						ELSE s.spec_name 
					END AS spec_name,
					LISTAGG(s.spec_cd, ',') WITHIN GROUP (ORDER BY s.spec_cd) AS spec_cd,
					MAX(s.spec_timeline_cd) AS spec_timeline_cd,
					MAX(s.spec_nrmp_participate_ind) AS spec_nrmp_participate_ind,
					MAX(s.spec_start_yr) AS spec_start_yr,
					MAX(s.spec_msg) AS spec_msg,
					MAX(s.spec_merge_ind) AS spec_merge_ind
				FROM eras_ref.ref_specialty s
				LEFT JOIN eras_ref.ref_specialty_group sg ON s.spec_grp_cd = sg.spec_grp_cd
				WHERE s.spec_type_cd = 'F'
				AND s.spec_active_ind = 'Y'
				AND s.spec_timeline_cd = '02'
				AND s.spec_cd NOT IN ('DIO', 'O60')
				
					AND (
							(s.spec_merge_ind = 'Y' AND sg.spec_grp_name LIKE ?)
							OR (s.spec_merge_ind != 'Y' AND s.spec_name LIKE ?)
							OR (s.spec_merge_ind IS NULL AND s.spec_name LIKE ?)
						)
				
				
				
				GROUP BY 
					CASE 
						WHEN s.spec_grp_cd IS NULL THEN s.spec_name
						WHEN s.spec_grp_cd IS NOT NULL AND s.spec_merge_ind = 'Y' THEN sg.spec_grp_name
						ELSE s.spec_name 
					END
				ORDER BY spec_name

SELECT *
				FROM MDFellowshipDec
				WHERE spec_start_yr = '2026'

Application Variables:
applicationname=ERASSTATS
encoder=Complex type
eras_open=Y
esapi=Complex type
stats__07dat=ERAS_EAM_DSN

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/filestore/coldfusion/CF2023/eras/erasstats/par/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=CrossSiteReturnURL=https://aamccomm.connectedcommunity.org/home; amlbcookie=01; datadome=qwD5s8_bRP1wzhbxIZ_mS5C55WAp69UtASdL9SQz4m7adO2qLZXvfe0EkN~LkKmJVIXFlDpRMRChuHHz9ck6YpkUxdkhIkN8ODlO9noBoPrB2PlNAB7YacQq3Ob9dccr
HTTP_HOST=systems.development.aamc.org
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Amazon CloudFront
LOCAL_ADDR=10.26.56.176
PATH_INFO=
PATH_TRANSLATED=/opt/filestore/coldfusion/CF2023/eras/erasstats/par/index.cfm
QUERY_STRING=
REMOTE_ADDR=10.26.196.106
REMOTE_HOST=10.26.196.106
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/eras/erasstats/par/index.cfm
SERVER_NAME=systems.development.aamc.org
SERVER_PORT=8500
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=
WEB_SERVER_API=

Client Variables:
cfid=1
cftoken=85F200C4-AABE-7205-A0FEF5C425F1DB59
cookie_check=TESTING
hitcount=1
lastvisit={ts '2025-09-17 20:20:37'}
timecreated={ts '2025-09-17 20:20:37'}
urltoken=CFID=1&CFTOKEN=85F200C4-AABE-7205-A0FEF5C425F1DB59

Cookie Variables:
AAMC_TIMEOUT_ERASSTATS={ts '2025-09-17 21:20:37'}
AAMC_TOKEN_ERASSTATS=85F200C4-AABE-7205-A0FEF5C425F1DB59
CrossSiteReturnURL=https
amlbcookie=01
datadome=qwD5s8_bRP1wzhbxIZ_mS5C55WAp69UtASdL9SQz4m7adO2qLZXvfe0EkN~LkKmJVIXFlDpRMRChuHHz9ck6YpkUxdkhIkN8ODlO9noBoPrB2PlNAB7YacQq3Ob9dccr

Request Parameters:
eras_active_season_4_erasstats=2026
es_maint_flag=N
samesite_value=
serverroot=/eras/erasstats

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

URL Parameters:
CFID=1
CFTOKEN=85F200C4-AABE-7205-A0FEF5C425F1DB59