Skip to page content

United States Department of Transportation

Notice JO 7210.752 - Comprehensive Electronic Data Analysis and Reporting (CEDAR) (Cancelled)

Document Information

Type

Notice

Number

JO 7210.752

Title

Comprehensive Electronic Data Analysis and Reporting (CEDAR)

Date issued

2010-07-08

Date cancelled

2010-08-09

Cancelled by

JO 7210.755

Office of Primary Responsibility

AJE-3

Access restriction

Public

Content

N JO 7210.752 (PDF)

For more information, contact 9-awa-ait-directives@faa.gov.

Debugging Information

ColdFusion Server Enterprise	2023,0,15,330825
Template	/regulations_policies/orders_notices/index.cfm
Time Stamp	18-Dec-25 05:48 AM
Locale	English (US)
User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; Amazonbot/0.1; +https://developer.amazon.com/support/amazonbot) Chrome/119.0.6045.214 Safari/537.36
Remote IP	10.27.195.251
Host Name	10.27.195.251

Execution Time

Total Time	Avg Time	Count	Template
226 ms	226 ms	1	\\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\regulations_policies\orders_notices\index.cfm
225 ms	225 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fusebox5.cfm
215 ms	215 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| onRequest(/regulations_policies/orders_notices/index.cfm) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
214 ms	214 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/parsed/document.information.cfm
185 ms	185 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/view/dspDocumentInformation.cfm
43 ms	43 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc \| callObjectGatewayMethod(objectType = document, stuArgumentCollection = [complex value], method = getObjects) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
43 ms	43 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc \| getDocuments(cancelledByDocumentID = 308560) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
42 ms	42 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc \| callObjectGatewayMethod(objectType = document, stuArgumentCollection = [complex value], method = getDocumentChanges) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
42 ms	42 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc \| getDocumentChanges(documentID = 308560) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
41 ms	41 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc \| getDocumentChanges(DOCUMENTID = 308560) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
41 ms	41 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc \| getObjects(CHANGENUMBER = 0, DOCUMENTNUMBER = , GETGENOTSONLY = 0, SEARCHCRITERIA = , DIVISIONAREA = , FORMATTEDDOCUMENTTITLE = 0, OBJECTID = 0, SUBJECTCLASS = , CANCELLEDBYDOCUMENTID = 308560, SORTORDER = ASC, RESTRICTIONCODEID = 0, DOCUMENT = , OFFICENUMBER = , STARTROW = 0, GETCOUNTONLY = false, OFFICEID = 0, SORTCOLUMN = documentID, SEQUENCENUMBER = 0, DOCUMENTTYPEID = 0, DOCUMENTTYPEIDLIST = , SUBJECTCLASSPREFIX = , STATUSIDLIST = , VERSIONTYPEID = 0, ALPHASUFFIX = , MAXROWS = 0, SIGNIFICANTDOCUMENTSONLY = 0, ENDROW = 0, DOCUMENTIDLIST = ) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
36 ms	36 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc \| callObjectGatewayMethod(objectType = directive, stuArgumentCollection = [complex value], method = getObjects) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
36 ms	36 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc \| getOrdersAndNotices(documentID = 308560) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
24 ms	24 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/view/layouts/template.cfm
22 ms	22 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc \| getObjects(DOCUMENTTYPEID = 0, DOCUMENTTYPEIDLIST = , GETGENOTSONLY = 0, SEARCHCRITERIA = , REGIONID = 0, FORMATTEDDOCUMENTTITLE = true, DISTRIBUTIONFIELDID = 0, OBJECTID = 308560, GETNATIONALDIRECTIVES = 0, STATUSIDLIST = , SORTORDER = DESC, DOCUMENTIDLIST = , SORTCOLUMN = dateIssued) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
22 ms	22 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc \| getDirectiveSupplements(documentID = 308560) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
21 ms	11 ms	2	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc \| init() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
21 ms	21 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc \| callObjectGatewayMethod(objectType = directive, stuArgumentCollection = [complex value], method = getDirectiveSupplements) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
21 ms	21 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/template.cfm
21 ms	21 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/template.cfm
14 ms	14 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc \| callObjectGatewayMethod(objectType = resource, stuArgumentCollection = [complex value], method = getObjectResources) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
14 ms	14 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc \| getDocumentResources(documentID = 308560) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
13 ms	13 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc \| getRelatedDrafts(documentID = 308560) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
12 ms	12 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc \| callObjectGatewayMethod(objectType = document, stuArgumentCollection = [complex value], method = getRelatedDocuments) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
12 ms	12 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc \| callObjectGatewayMethod(objectType = document, stuArgumentCollection = [complex value], method = getRelatedDrafts) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
12 ms	12 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc \| getObjectResources(OBJECTID = 308560, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
12 ms	12 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc \| getRelatedDocuments(relationTypeID = 3, childDocumentID = 308560) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
11 ms	11 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc \| getRelatedDocuments(PARENTDOCUMENTID = 0, RELATIONTYPE = , STATUSID = 2, DOCUMENTIDLIST = , RELATIONTYPEID = 3, CHILDDOCUMENTID = 308560) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
11 ms	11 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc \| getRelatedDrafts(DOCUMENTID = 308560) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
10 ms	10 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc \| getDirectiveSupplements(DOCUMENTID = 308560) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
6 ms	6 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actLastUpdated.cfm
6 ms	6 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actMenu.cfm
5 ms	5 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| onRequestStart(/regulations_policies/orders_notices/index.cfm) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
5 ms	5 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspTemplate.cfm
4 ms	4 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/Application.cfm
4 ms	4 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/applicationCode.cfm
2 ms	2 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspBody.cfm
2 ms	2 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfGlobal.cfm
1 ms	0 ms	4	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc \| init() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
1 ms	1 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc \| compileRequest(document.information, CFC: aeronavfiles.www.faa.gov.Webcont.fusebox.myFusebox) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc
1 ms	1 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/plugins/globalVariables.cfm
1 ms	1 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/model/actParamVars.cfm
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc \| init() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| bleed([complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| onRequestEnd(/regulations_policies/orders_notices/index.cfm) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(ADDURIQUERYKEY, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(ASSETQUERYSTRING, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(ATTRIBUTES, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(DETECTTIER, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(DOCUMENTVIEWER, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(EMAILFORM, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(FORMATFILESIZE, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(FUSEBOX_APPLICATION_KEY, Public_Orders_Notices) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(FUSEBOX_APPLICATION_PATH, ) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(FUSEBOX_CALLER_PATH, //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(FUSEBOX_PARAMETERS, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(GETFILESIZE, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(GETFILETYPE, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(GETPAGEURI, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(IMAGEFORMAT, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(KILLXSSINSTRING, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(MATCHER, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(MATCHERNOCASE, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(MATCHURI, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(PAGEREDIRECT, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(PARSEURI, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(REMATCHER, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(REMATCHERNOCASE, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(REMOVEURIQUERYKEY, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(REPLACEURIQUERYKEY, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(STRIPHTML, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(THROWERROR, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(__FUSEBOXAPPCFC, CFC: aeronavfiles.www.faa.gov.Webcont.fusebox.Application) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| override(_item, replaceUriQueryKey) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxAction.cfc \| getAccess() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxAction.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc \| expandFuseboxPath(parsed/) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc
0 ms	0 ms	2	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc \| getCoreToAppRootPath() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc \| getVersion() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxEvent.cfc \| init([complex value], [complex value], CFC: aeronavfiles.www.faa.gov.Webcont.fusebox.myFusebox) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxEvent.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/myFusebox.cfc \| init(Public_Orders_Notices, [complex value], [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/myFusebox.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/myFusebox.cfc \| trace(Fusebox, Request completed) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/myFusebox.cfc
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/functions/udfQueryToCSV.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/view/dspRightSidebar.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/model/actCheckLegacyMode.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actChatbot.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actEnableColumns.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actExternalLinks.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/menu/actBuildMenu.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspDrupal_cms_footer.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspDrupal_cms_head.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspDrupal_cms_header.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspFooter.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspHeader.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspPageTools.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfAssetQueryString.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfDetectTier.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfDocumentViewer.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfEmailForm.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfExpressionManager.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfImageFormat.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfPageRedirect.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfUriManager.cfm
2 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
232 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

Exceptions

05:48:27.027 - MissingInclude Exception - in //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc : line 167

	    Could not find the included template ../regulations_policies/orders_notices/fusebox.init.cfm.

SQL Queries

qGetDocumentTypeData (Datasource=developersdb, Time=10ms, Records=10) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 05:48:27.027

SELECT
				documentTypeID,
				documentType
			FROM
				dlDocumentType

qryGetObjects (Datasource=developersdb, Time=11ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 05:48:27.027

SELECT resources.resourceID,
					resources.resourceNumber,
					resources.resourceURI,
					resources.resourceTitle1,
					resources.resourceTitle2,
					objectResources.isPrimaryFile,
					objectResources.isPrimaryWeb,
					resources.dateEffective,
					resources.comments,
					resources.dateCreated,
					resources.dateModified
				FROM dlDocumentResource objectResources
				INNER JOIN dlResource resources ON objectResources.resourceID = resources.resourceID
				WHERE 1=1
				
					AND objectResources.documentID = 308560 
				ORDER BY resources.resourceNumber ASC

qGetColumns (Datasource=developersdb, Time=19ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 05:48:27.027

SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0

qGetObjects (Datasource=developersdb, Time=12ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 05:48:27.027

SELECT

			
				docs.documentID,
				docs.officeID,
				docs.statusID,
				docs.cancelledByDocumentID,
				
					docs.documentTitle,
				
				docs.documentTypeID,
				docs.documentNumber,
				docs.divisionArea,
				UPPER(TRIM(docs.subjectClass)) AS subjectClass,
				docs.sequenceNumber,
				docs.alphaSuffix,
				docs.changeNumber,
				docs.dateIssued,
				docs.dateCancelled,
				docs.cancelNotes,
				docs.description,
				docs.createdByUserID,
				docs.modifiedByUserID,
				docs.contactFirstName,
				docs.contactLastName,
				docs.contactEmail,
				docs.contactPhone,
				docs.govDeliveryCode,
				docs.restrictionCodeID,
				docs.versionTypeID,
				docs.commentsDeadlineDate,
				docs.newRevisedComments,
				docs.orderPurposeStatement,
				docs.dateCreated,
				docs.dateModified,
				(SELECT MAX(revisionDate) FROM dlDocumentRevision WHERE documentID = docs.documentID) AS maxRevisionDate,
				offices.officeNumber, offices.officeName, offices.officeURL,
				docTypes.documentType,
				cancelDoc.documentNumber AS cancelledByDocumentNumber,
				statuses.status,
				versionTypes.versionType
				

			FROM
				dlDocument docs

			

			INNER JOIN dlDocumentType docTypes ON docs.documentTypeID = docTypes.documentTypeID
			LEFT OUTER JOIN dlOffice offices ON docs.officeID = offices.officeID
			LEFT OUTER JOIN dlDocumentStatus statuses ON docs.statusID = statuses.statusID
			LEFT OUTER JOIN dlDocument cancelDoc ON docs.cancelledByDocumentID = cancelDoc.documentID
			LEFT OUTER JOIN dlVersionType versionTypes ON docs.versionTypeID = versionTypes.versionTypeID
			WHERE 1 = 1

			
				AND docs.documentID = 308560 
							ORDER BY docs.dateIssued DESC, docs.subjectClass DESC, docs.sequenceNumber DESC, docs.alphaSuffix DESC, docs.divisionArea DESC

qGetObjects (Datasource=developersdb, Time=10ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 05:48:27.027

SELECT changes.changeID, changes.documentID, changes.changeNumber, changes.changeTitle AS documentTitle, changes.changeDescription AS description, changes.dateIssued, changes.statusID,
			statuses.status
			FROM dlChange changes
			LEFT OUTER JOIN dlDocumentStatus statuses ON changes.statusID = statuses.statusID
			WHERE documentID = ?
			ORDER BY changeNumber ASC

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_numeric) = 308560

qGetColumns (Datasource=developersdb, Time=19ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 05:48:27.027

SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0

qGetObjects (Datasource=developersdb, Time=21ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 05:48:27.027

SELECT

			
				docs.documentID,
				docs.officeID,
				docs.statusID,
				docs.cancelledByDocumentID,
				
					docs.documentTitle,
				
				docs.documentTypeID,
				docs.documentNumber,
				docs.divisionArea,
				UPPER(TRIM(docs.subjectClass)) AS subjectClass,
				docs.sequenceNumber,
				docs.alphaSuffix,
				docs.changeNumber,
				docs.dateIssued,
				docs.dateCancelled,
				docs.cancelNotes,
				docs.description,
				docs.createdByUserID,
				docs.modifiedByUserID,
				docs.contactFirstName,
				docs.contactLastName,
				docs.contactEmail,
				docs.contactPhone,
				docs.govDeliveryCode,
				docs.restrictionCodeID,
				docs.versionTypeID,
				docs.commentsDeadlineDate,
				docs.newRevisedComments,
				docs.orderPurposeStatement,
				docs.dateCreated,
				docs.dateModified,
				(SELECT MAX(revisionDate) FROM dlDocumentRevision WHERE documentID = docs.documentID) AS maxRevisionDate,
				offices.officeNumber, offices.officeName, offices.officeURL,
				docTypes.documentType,
				cancelDoc.documentNumber AS cancelledByDocumentNumber,
				statuses.status,
				versionTypes.versionType
				

			FROM
				dlDocument docs

			

			INNER JOIN dlDocumentType docTypes ON docs.documentTypeID = docTypes.documentTypeID
			LEFT OUTER JOIN dlOffice offices ON docs.officeID = offices.officeID
			LEFT OUTER JOIN dlDocumentStatus statuses ON docs.statusID = statuses.statusID
			LEFT OUTER JOIN dlDocument cancelDoc ON docs.cancelledByDocumentID = cancelDoc.documentID
			LEFT OUTER JOIN dlVersionType versionTypes ON docs.versionTypeID = versionTypes.versionTypeID
			WHERE 1 = 1

			
				AND docs.cancelledByDocumentID = 308560 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC

qGetObjects (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 05:48:27.027

SELECT docs.documentID,
				docs.officeID,
				docs.statusID,
				docs.cancelledByDocumentID,
				REGEXP_REPLACE(docs.documentTitle, '^[^a-zA-Z0-9""'']+(.*)', '\1') AS documentTitle,
				docs.documentTypeID,
				docs.documentNumber,
				docs.divisionArea,
				docs.subjectClass,
				docs.sequenceNumber,
				docs.alphaSuffix,
				docs.changeNumber,
				docs.dateEffective,
				docs.dateIssued,
				docs.dateCancelled,
				docs.cancelNotes,
				docs.description,
				docs.createdByUserID,
				docs.modifiedByUserID,
				docs.contactFirstName,
				docs.contactLastName,
				docs.contactEmail,
				docs.contactPhone,
				docs.govDeliveryCode,
				docs.restrictionCodeID,
				docs.versionTypeID,
				docs.commentsDeadlineDate,
				docs.dateCreated,
				docs.dateModified,
				docs.newRevisedComments,
				docs.orderPurposeStatement,
				(SELECT MAX(revisionDate) FROM dlDocumentRevision WHERE documentID = docs.documentID) AS maxRevisionDate,
				offices.officeNumber, offices.officeName, offices.officeURL,
				docTypes.documentType,
				cancelDoc.documentNumber AS cancelledByDocumentNumber,
				statuses.status,
				versionTypes.versionType
				FROM dlDocument docs
				INNER JOIN dlDocumentType docTypes ON docs.documentTypeID = docTypes.documentTypeID
				INNER JOIN dlVersionType versionTypes ON docs.versionTypeID = versionTypes.versionTypeID
				LEFT OUTER JOIN dlOffice offices ON docs.officeID = offices.officeID
				LEFT OUTER JOIN dlDocumentStatus statuses ON docs.statusID = statuses.statusID
				LEFT OUTER JOIN dlDocument cancelDoc ON docs.cancelledByDocumentID = cancelDoc.documentID
			
			WHERE
			docs.documentID IN (
				SELECT childDocumentID
				FROM dlDocumentRelation
				WHERE parentDocumentID = ?
				AND relationTypeID = ?
			)
			AND docs.statusID = ?
			ORDER BY changeNumber ASC

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_numeric) = 308560

			    
			        Parameter #2(cf_sql_numeric) = 5

			    
			        Parameter #3(cf_sql_numeric) = 2

qGetDocumentTypeData (Datasource=developersdb, Time=10ms, Records=10) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 05:48:27.027

SELECT
				documentTypeID,
				documentType
			FROM
				dlDocumentType

qGetSupplements (Datasource=developersdb, Time=10ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 05:48:27.027

SELECT supplementID, documentID, regionID, suppNum, suppDate, suppURL, isArchived, isNationalSupplement
			FROM dlDirectiveSupplement
			WHERE parentDocumentID = ?
			ORDER BY suppNum ASC

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_numeric) = 308560

qGetObjects (Datasource=developersdb, Time=10ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 05:48:27.027

SELECT
				relatedDocs.documentRelationID,
				relatedDocs.childDocumentID,
				relatedDocs.parentDocumentID,
				relatedDocs.relationTypeID,
				relationTypes.relationType,
				childDocInfo.documentNumber,
				childDocInfo.documentTitle,
				childDocInfo.dateIssued,
				childDocInfo.dateCancelled,
				childDocInfo.cancelNotes,
				childDocInfo.statusID,
				childDocInfo.cancelledByDocumentID,
				childDocInfo.restrictionCodeID,
				childDocInfo.subjectClass,
				childDocInfo.divisionArea,
				childDocInfo.sequenceNumber,
				childDocInfo.alphaSuffix,
				childDocInfo.description,
				childDocInfo.changeNumber,
				parentDocInfo.documentNumber AS parentDocumentNumber,
				parentDocInfo.documentTitle AS parentDocumentTitle,
				parentDocInfo.dateIssued AS parentDateIssued,
				parentDocInfo.dateCancelled AS parentDateCancelled,
				parentDocInfo.cancelNotes AS parentCancelNotes,
				parentDocInfo.statusID AS parentStatusID,
				parentDocInfo.restrictionCodeID AS parentRestrictionCodeID,
				parentOffice.officeNumber AS parentOfficeNumber,
				docStatuses.status,
				childOffice.officeNumber,
				cancelDocument.documentNumber AS cancelledByDocumentNumber
			FROM
				dlDocumentRelation relatedDocs
				INNER JOIN dlDocument parentDocInfo ON relatedDocs.parentDocumentID = parentDocInfo.documentID
				INNER JOIN dlDocument childDocInfo ON relatedDocs.childDocumentID = childDocInfo.documentID
				INNER JOIN dlRelationType relationTypes ON relatedDocs.relationTypeID = relationTypes.relationTypeID
				INNER JOIN dlDocumentStatus docStatuses ON childDocInfo.statusID = docStatuses.statusID
				LEFT OUTER JOIN dlOffice childOffice ON childOffice.officeID = childDocInfo.officeID
				LEFT OUTER JOIN dlOffice parentOffice ON parentOffice.officeID = parentDocInfo.officeID
				LEFT OUTER JOIN dlDocument cancelDocument ON childDocInfo.cancelledByDocumentID = cancelDocument.documentID
			WHERE
				1 = 1
				AND childDocInfo.statusID <> ? 
					AND childDocInfo.statusID = ? 
						AND relatedDocs.childDocumentID = ? 
					AND relatedDocs.relationTypeID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_numeric) = 1

			    
			        Parameter #2(cf_sql_numeric) = 2

			    
			        Parameter #3(cf_sql_numeric) = 308560

			    
			        Parameter #4(cf_sql_numeric) = 3

Stored Procedures

pkg_docLib_directives_temp.spGetDirectives_temp (Datasource=developersdb, Time=21ms) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 05:48:27.027

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`cf_sql_varchar`	`NULL`
`IN`	`cf_sql_varchar`	`NULL`
`IN`	`cf_sql_varchar`	`NULL`
`IN`	`cf_sql_numeric`	`308560`
`IN`	`cf_sql_varchar`	`NULL`
`IN`	`cf_sql_numeric`	`0`
`IN`	`cf_sql_varchar`	`NULL`
`IN`	`cf_sql_numeric`	`0`
`IN`	`cf_sql_numeric`	`1`
`IN`	`cf_sql_numeric`	`0`
`IN`	`cf_sql_numeric`	`0`
`IN`	`cf_sql_numeric`	`0`
`IN`	`cf_sql_varchar`	`NULL`
`IN`	`cf_sql_numeric`	`0`
`IN`	`cf_sql_numeric`	`0`
`IN`	`cf_sql_numeric`	`0`
`IN`	`cf_sql_varchar`	`NULL`
`IN`	`cf_sql_varchar`	`NULL`
`IN`	`cf_sql_numeric`	`0`
`IN`	`cf_sql_varchar`	`NULL`
`IN`	`cf_sql_varchar`	`dateIssued`
`IN`	`cf_sql_varchar`	`DESC`
`IN`	`cf_sql_numeric`	`0`
`IN`	`cf_sql_varchar`	`NULL`
`IN`	`cf_sql_varchar`	`NULL`

resultsets
`name`	`resultset`
`qGetObjects`	`1`

Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=DigiCert Inc, CN=DigiCert Global G2 TLS RSA SHA256 2020 CA1
CERT_SERVER_SUBJECT=C=US, S=District of Columbia, L=Washington, O=Federal Aviation Administration, CN=www.faa.gov
CERT_SUBJECT=
CF_TEMPLATE_PATH=\\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\regulations_policies\orders_notices\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=DigiCert Inc, CN=DigiCert Global G2 TLS RSA SHA256 2020 CA1
HTTPS_SERVER_SUBJECT=C=US, S=District of Columbia, L=Washington, O=Federal Aviation Administration, CN=www.faa.gov
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www.faa.gov
HTTP_REFERER=
HTTP_URL=/regulations_policies/orders_notices/index.cfm/go/document.information/documentID/308560
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; Amazonbot/0.1; +https://developer.amazon.com/support/amazonbot) Chrome/119.0.6045.214 Safari/537.36
LOCAL_ADDR=10.27.229.24
PATH_INFO=/go/document.information/documentID/308560
PATH_TRANSLATED=\\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\regulations_policies\orders_notices\index.cfm
QUERY_STRING=
REMOTE_ADDR=10.27.195.251
REMOTE_HOST=10.27.195.251
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/regulations_policies/orders_notices/index.cfm
SERVER_NAME=www.faa.gov
SERVER_PORT=8085
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CFID=296009
CFTOKEN=c77a449a7d3cd62a-EAC0E9B5-A480-17D5-6E5CC62B2D6E7511

Session Variables:
sessionid=AAE43D6CDE31B93936EE15297956ED37.www
urltoken=CFID=296009&CFTOKEN=c77a449a7d3cd62a-EAC0E9B5-A480-17D5-6E5CC62B2D6E7511&jsessionid=AAE43D6CDE31B93936EE15297956ED37.www

Debug Rendering Time: 19 ms

USA Banner

Notice JO 7210.752 - Comprehensive Electronic Data Analysis and Reporting (CEDAR) (Cancelled)

Document Information

U.S. Department of Transportation