Skip to page content

USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

United States Department of Transportation United States Department of Transportation

Archived Notices for FAAO JO 7110.65

Air Traffic Control

For comments about GENOTS/Notices, email 9-AWA-ATPUBS@faa.gov.

GENOT/Notices for Air Traffic Control
Notice (GENOTs) Effective Subject
  • Document Change Proposal(s)
 Cancellation/
Incorporation
N JO 7110.780 (PDF) 2021-05-21

Supervisory Notification of Suspicious UAS Activity

 JO 7110.65Z
Incorporated in Change 1
N JO 7110.779 (PDF)

(21/12)

 2021-03-04

Boeing 777X Wake Turbulence Categorization

 JO 7110.65Z
Information has been incorporated
N JO 7110.778 (PDF) 2020-12-31

Supervisory Notification of Suspicious UAS Activity

 JO 7110.780
Replaced by JO 7110.780
N JO 7110.777 (PDF) 2020-09-10

Emergency Autoland System

 JO 7110.65Y
Incorporated into Change 3
N JO 7110.776 (PDF) 2020-07-01

Supervisory Notification of Suspicious UAS Activity

 JO 7110.778
Guidance Extended via N JO 7110.778
N JO 7110.774 (PDF) 2020-04-20

Operational Priority for MEDEVAC Flights

 JO 7110.65Y
N JO 7110.773 (PDF) 2020-04-16

ATC Surveillance Source Use and Minima

 JO 7110.65Y
N JO 7110.772 (PDF)

(20/07)

 2020-01-24

Boeing 777X Wake Turbulence Categorization

 2022-01-24
N JO 7110.771 (PDF) 2019-12-16

ATC Surveillance Source Use and Minima

 JO 7110.773
N JO 7110.770 (PDF) 2020-01-02

Automatic Dependent Surveillance-Broadcast (ADS-B) Related Changes

 JO 7110.65Y
Incorporated in Change 1
N JO 7110.768 (PDF) 2020-01-08

Hazardous Inflight Weather Advisory Service (HIWAS)

 JO 7110.65Y
N JO 7110.767 (PDF) 2019-10-15

Separation Minima During Commercial Space Launch and Reentry Operations

 JO 7110.65Y
Incorp into Change 1
N JO 7110.766 (PDF) 2019-09-23

Landing Clearance (Wrong Surface Landings)

 JO 7110.65Y

Page last modified:

Debugging Information
ColdFusion Server Enterprise 2023,0,15,330825
Template /air_traffic/publications/at_notices/index.cfm
Time Stamp 17-Dec-25 04:48 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.27.195.229
Host Name 10.27.195.229

Execution Time

Total Time Avg Time Count Template
1506 ms 1506 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/publications/at_notices/index.cfm
1075 ms 1075 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/publications/at_notices/view/dspIndex.cfm
526 ms 40 ms 13 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
380 ms 15 ms 25 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
293 ms 37 ms 8 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocuments(documentID = 1036234) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
282 ms 282 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc | callObjectGatewayMethod(objectType = directive, stuArgumentCollection = [complex value], method = getRelatedDirectives) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
282 ms 282 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getRelatedNotices(status = cancelled, documentIDList = 1036234) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
279 ms 35 ms 8 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 = 1036234, SUBJECTCLASS = , CANCELLEDBYDOCUMENTID = 0, 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
269 ms 269 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc | getRelatedDirectives(PARENTDOCUMENTID = 0, STATUSID = 3, DOCUMENTIDLIST = 1036234, RELATIONTYPEID = 3) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
172 ms 13 ms 13 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc | callObjectGatewayMethod(objectType = document, stuArgumentCollection = [complex value], method = getDocumentChangeProposals) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
104 ms 15 ms 7 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1036234) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
94 ms 13 ms 7 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1036234, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
85 ms 85 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getTopicDocuments(documentTypeID = 2, topic = Air Traffic) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
84 ms 84 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc | callObjectGatewayMethod(objectType = topic, stuArgumentCollection = [complex value], method = getTopicDocuments) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
82 ms 82 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/topicGateway.cfc | getTopicDocuments(STARTDATEISSUED = 1/1/1900, DOCUMENTTYPEID = 2, DOCUMENTTYPEIDLIST = , STARTDATEMODIFIED = 1/1/1900, TOPICID = 0, SEARCHCRITERIA = , TOPIC = Air Traffic, SORTORDER = ASC, STATUSID = 0, VERSIONTYPEID = 2, ENDDATEMODIFIED = 1/1/1900, SORTBY = documentNumber, RESTRICTIONCODEID = 0, ENDDATEISSUED = 1/1/1900, DOCUMENTTYPELIST = ) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/topicGateway.cfc
73 ms 37 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocuments(documentID = 1039720) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
70 ms 35 ms 2 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 = 1039720, SUBJECTCLASS = , CANCELLEDBYDOCUMENTID = 0, 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
66 ms 66 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocuments(documentID = 1037295) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
63 ms 63 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 = 1037295, SUBJECTCLASS = , CANCELLEDBYDOCUMENTID = 0, 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
61 ms 61 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocuments(documentID = 1038638) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
59 ms 59 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 = 1038638, SUBJECTCLASS = , CANCELLEDBYDOCUMENTID = 0, 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
38 ms 38 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocuments(documentID = 1039498) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
36 ms 36 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 = 1039498, SUBJECTCLASS = , CANCELLEDBYDOCUMENTID = 0, 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
30 ms 15 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1038638) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
30 ms 15 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1039498) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
29 ms 15 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1037295) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
29 ms 15 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1039720) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
27 ms 14 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1037295, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
27 ms 14 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1038638, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
27 ms 14 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1039498, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
26 ms 13 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1039720, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
24 ms 24 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/template.cfm
22 ms 22 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/template.cfm
19 ms 19 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1037833) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
18 ms 18 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1037643) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
17 ms 17 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1037833, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
17 ms 17 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1036735) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
17 ms 17 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1036969) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
17 ms 17 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1037091) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
16 ms 16 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1037091, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
16 ms 16 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1037643, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
15 ms 15 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1036735, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
15 ms 15 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1036969, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
15 ms 15 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentChangeProposals(documentID = 1036528) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
15 ms 15 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1036528) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
15 ms 15 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1036951) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
15 ms 15 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1037314) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
15 ms 15 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1039179) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
14 ms 14 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentChangeProposals(documentID = 1036735) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
14 ms 14 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentChangeProposals(documentID = 1036951) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
14 ms 14 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentChangeProposals(documentID = 1037091) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
14 ms 14 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentChangeProposals(documentID = 1037643) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
14 ms 14 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentChangeProposals(documentID = 1038638) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
14 ms 14 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentChangeProposals(documentID = 1039498) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
14 ms 14 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1036928) ] 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/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1036528, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
13 ms 13 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1036928, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
13 ms 13 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1036951, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
13 ms 13 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1037314, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
13 ms 13 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1039179, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
13 ms 13 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentChangeProposals(documentID = 1036928) ] 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 | getDocumentChangeProposals(documentID = 1036969) ] 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 | getDocumentChangeProposals(documentID = 1037295) ] 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 | getDocumentChangeProposals(documentID = 1037314) ] 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 | getDocumentChangeProposals(documentID = 1037833) ] 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 | getDocumentChangeProposals(documentID = 1039179) ] 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/directiveGateway.cfc | init() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
12 ms 12 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getDocumentChangeProposals(DOCUMENTID = 1036528) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
12 ms 12 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getDocumentChangeProposals(DOCUMENTID = 1036969) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
12 ms 12 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getDocumentChangeProposals(DOCUMENTID = 1037091) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
12 ms 12 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getDocumentChangeProposals(DOCUMENTID = 1037314) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
12 ms 12 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getDocumentChangeProposals(DOCUMENTID = 1037833) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
12 ms 12 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getDocumentChangeProposals(DOCUMENTID = 1039179) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
12 ms 12 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getDocumentChangeProposals(DOCUMENTID = 1039498) ] 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 | getDocumentChangeProposals(DOCUMENTID = 1036735) ] 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 | getDocumentChangeProposals(DOCUMENTID = 1036928) ] 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 | getDocumentChangeProposals(DOCUMENTID = 1036951) ] 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 | getDocumentChangeProposals(DOCUMENTID = 1037295) ] 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 | getDocumentChangeProposals(DOCUMENTID = 1037643) ] 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 | getDocumentChangeProposals(DOCUMENTID = 1038638) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
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 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/Application.cfm
5 ms 5 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actLastUpdated.cfm
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/applicationCode.cfm
4 ms 4 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfGlobal.cfm
2 ms 2 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspBody.cfm
1 ms 0 ms 26 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 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/publications/at_notices/view/dspAtNoticesForm.cfm
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actExternalLinks.cfm
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actTopTasks.cfm
0 ms 0 ms 25 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/chh/employees/documentLibrary/model/dao/topicGateway.cfc | init() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/topicGateway.cfc
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/model/actParamVars.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/menu/actBuildMenu.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/top_tasks/dspAirTraffic.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
1513 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

qGetDocumentType (Datasource=developersdb, Time=11ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\topicGateway.cfc @ 16:48:32.032
SELECT documentTable
				FROM dlDocumentType
				WHERE documentTypeID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 2

qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\topicGateway.cfc @ 16:48:32.032
SELECT *
					FROM dlDirective
					WHERE 1=0
qGetTopic (Datasource=developersdb, Time=11ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\topicGateway.cfc @ 16:48:32.032
SELECT topicID
				FROM dlTopic
				WHERE UPPER(topic) = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = AIR TRAFFIC

qGetData (Datasource=developersdb, Time=37ms, Records=55) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\topicGateway.cfc @ 16:48:33.033
SELECT
				docs.documentID,
				REGEXP_REPLACE(docs.documentTitle, '^[^a-zA-Z0-9""'']+(.*)', '\1') AS documentTitle,
				docs.documentNumber,
				docs.documentTypeID,
				docs.dateIssued,
				docs.dateEffective,
				docs.dateCreated,
				docs.dateModified,
				SUBSTR(docs.documentNumber, INSTR(docs.documentNumber, ' ') + 1) AS reDocumentNumber,
				docs.subjectClass,
				docs.sequenceNumber,
				docs.alphaSuffix,
				docs.changeNumber,
				docs.divisionArea,
				docs.description,
				docs.statusID,
				docs.dateCancelled,
				docs.cancelledByDocumentID,
				docs.cancelNotes,
				cancelDoc.documentNumber AS cancelledByDocumentNumber,
				offices.officeNumber,
				offices.officeURL,
				offices.officeName,
				statuses.status

				
						, docTypeMetadata.ACTION 
						, docTypeMetadata.AMENDMENTNUMBER 
						, docTypeMetadata.CANCELLEDBY 
						, docTypeMetadata.CHANGEDATE 
						, docTypeMetadata.CONTACTADDRESS1 
						, docTypeMetadata.CONTACTADDRESS2 
						, docTypeMetadata.CONTACTCITY 
						, docTypeMetadata.CONTACTEMAIL 
						, docTypeMetadata.CONTACTFAX 
						, docTypeMetadata.CONTACTFIRSTNAME 
						, docTypeMetadata.CONTACTLASTNAME 
						, docTypeMetadata.CONTACTPHONE 
						, docTypeMetadata.CONTACTSTATE 
						, docTypeMetadata.CONTACTZIP 
						, docTypeMetadata.DATECANCELLED 
						, docTypeMetadata.DIRECTIVEID 
						, docTypeMetadata.DISPLAYDOCUMENTPARTS 
						, docTypeMetadata.DOCUMENTSUMMARY 
						, docTypeMetadata.DOCUMENTURL 
						, docTypeMetadata.EFFECTIVEDATE 
						, docTypeMetadata.ENTEREDBY 
						, docTypeMetadata.FEDERALREGISTERPUBLICATIONDATE 
						, docTypeMetadata.GENOTID 
						, docTypeMetadata.HQDISTE 
						, docTypeMetadata.HQDISTW 
						, docTypeMetadata.HQDISTX 
						, docTypeMetadata.HQDISTY 
						, docTypeMetadata.HQDISTZ 
						, docTypeMetadata.INSTRUCTIONS 
						, docTypeMetadata.ISCANCELLED 
						, docTypeMetadata.ISGENOT 
						, docTypeMetadata.ISINTERNAL 
						, docTypeMetadata.ISNATIONALDIRECTIVE 
						, docTypeMetadata.ISPUBLISHED 
						, docTypeMetadata.ISSUEDATE 
						, docTypeMetadata.OLDREGIONID 
						, docTypeMetadata.OMBCONTROLNUMBER 
						, docTypeMetadata.OPR 
						, docTypeMetadata.ORDERID 
						, docTypeMetadata.ORDERSKEY 
						, docTypeMetadata.OTHERDIST 
						, docTypeMetadata.REGIONID 
						, docTypeMetadata.RELATEDORDERID 
						, docTypeMetadata.RESTRICTIONCODEID 
						, docTypeMetadata.REVALDATE 
						, docTypeMetadata.SIGNEDBY 
						, docTypeMetadata.UPDATEDBY 
						, docTypeMetadata.ZLIST1 
						, docTypeMetadata.ZLIST2 
						, docTypeMetadata.ZLIST3 
			FROM
				dlDocument docs

			
				INNER JOIN dlDirective docTypeMetadata ON docs.documentID = docTypeMetadata.documentID
			

			INNER JOIN
				dlDocumentTopic docTopics ON docs.documentID = docTopics.documentID
			INNER JOIN
				dlDocumentStatus statuses ON docs.statusID = statuses.statusID
			LEFT OUTER JOIN
				dlOffice offices ON docs.officeID = offices.officeID
			LEFT OUTER JOIN
				dlDocument cancelDoc ON docs.cancelledByDocumentID = cancelDoc.documentID
			WHERE 1 = 1
			
				AND docTopics.topicID = 10 
				AND docs.versionTypeID = 2 
					ORDER BY
						docs.subjectClass ASC,
						docs.sequenceNumber ASC,
						docs.alphaSuffix ASC,
						docs.divisionArea ASC,
						reDocumentNumber ASC,
						changeNumber ASC
qGetColumns (Datasource=developersdb, Time=22ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetObjects (Datasource=developersdb, Time=13ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
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 = 1036234 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qGetDocumentTypeData (Datasource=developersdb, Time=11ms, Records=10) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 16:48:33.033
SELECT
				documentTypeID,
				documentType
			FROM
				dlDocumentType
qGetObjects (Datasource=developersdb, Time=268ms, Records=13) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 16:48:33.033
SELECT
				relatedDocs.documentRelationID,
				relatedDocs.childDocumentID,
				relatedDocs.parentDocumentID,
				relatedDocs.relationTypeID,
				relationTypes.relationType,
				childDocInfo.documentNumber,
				childDocInfo.documentTitle,
				childDocInfo.dateEffective,
				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.documentID AS parentDocumentID,
				parentDocInfo.documentNumber AS parentDocumentNumber,
				REGEXP_REPLACE(parentDocInfo.documentTitle, '^[^a-zA-Z0-9""'']+(.*)', '\1') AS parentDocumentTitle,
				parentDocInfo.dateIssued AS parentDateIssued,
				parentDocInfo.dateEffective AS parentDateEffective,
				parentDocInfo.dateCancelled AS parentDateCancelled,
				parentDocInfo.cancelNotes AS parentCancelNotes,
				parentDocInfo.statusID AS parentStatusID,
				parentDocInfo.restrictionCodeID AS parentRestrictionCodeID,
				parentOffice.officeNumber AS parentOfficeNumber,
				docStatuses.status,
				childOffice.officeNumber,
				childDirInfo.isGenot,
				childDirInfo.genotID,
				childDirInfo.revalDate,
				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 dlDirective parentDirInfo ON parentDocInfo.documentID = parentDirInfo.documentID
			INNER JOIN dlDirective childDirInfo ON childDocInfo.documentID = childDirInfo.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 (relatedDocs.childDocumentID IN (1036234) OR relatedDocs.parentDocumentID IN (1036234))
			
				AND relatedDocs.relationTypeID = ? 

			ORDER BY childDocInfo.subjectClass DESC, childDocInfo.sequenceNumber DESC, childDocInfo.dateIssued DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 3
Parameter #2(cf_sql_numeric) = 3

qGetObjects (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1039498
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=11ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1039498 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
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 @ 16:48:33.033
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 = 1039720 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qryGetObjects (Datasource=developersdb, Time=12ms, Records=6) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1039720 
				ORDER BY resources.resourceNumber ASC
qGetObjects (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1039179
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=12ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1039179 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=21ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
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 @ 16:48:33.033
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 = 1039720 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qryGetObjects (Datasource=developersdb, Time=12ms, Records=6) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1039720 
				ORDER BY resources.resourceNumber ASC
qGetObjects (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1038638
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=12ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1038638 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=22ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
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 @ 16:48:33.033
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 = 1039498 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qryGetObjects (Datasource=developersdb, Time=11ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1039498 
				ORDER BY resources.resourceNumber ASC
qGetObjects (Datasource=developersdb, Time=12ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1037833
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=16ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1037833 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetObjects (Datasource=developersdb, Time=13ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
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 = 1036234 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qryGetObjects (Datasource=developersdb, Time=13ms, Records=6) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1036234 
				ORDER BY resources.resourceNumber ASC
qGetObjects (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1037643
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=15ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1037643 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetObjects (Datasource=developersdb, Time=36ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
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 = 1038638 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qryGetObjects (Datasource=developersdb, Time=12ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1038638 
				ORDER BY resources.resourceNumber ASC
qGetObjects (Datasource=developersdb, Time=12ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1037314
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=12ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1037314 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=22ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
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 @ 16:48:33.033
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 = 1036234 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qryGetObjects (Datasource=developersdb, Time=12ms, Records=6) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1036234 
				ORDER BY resources.resourceNumber ASC
qGetObjects (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1037295
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=12ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1037295 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
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 @ 16:48:33.033
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 = 1036234 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qryGetObjects (Datasource=developersdb, Time=11ms, Records=6) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1036234 
				ORDER BY resources.resourceNumber ASC
qGetObjects (Datasource=developersdb, Time=12ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:33.033
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1037091
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=14ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:33.033
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 = 1037091 
				ORDER BY resources.resourceNumber ASC
qGetObjects (Datasource=developersdb, Time=12ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1036969
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=13ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:34.034
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 = 1036969 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=29ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetObjects (Datasource=developersdb, Time=34ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
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 = 1037295 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qryGetObjects (Datasource=developersdb, Time=12ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:34.034
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 = 1037295 
				ORDER BY resources.resourceNumber ASC
qGetObjects (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1036951
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=11ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:34.034
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 = 1036951 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=22ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
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 @ 16:48:34.034
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 = 1036234 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qryGetObjects (Datasource=developersdb, Time=12ms, Records=6) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:34.034
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 = 1036234 
				ORDER BY resources.resourceNumber ASC
qGetObjects (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1036928
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=12ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:34.034
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 = 1036928 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=22ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetObjects (Datasource=developersdb, Time=11ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
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 = 1036234 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qryGetObjects (Datasource=developersdb, Time=12ms, Records=6) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:34.034
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 = 1036234 
				ORDER BY resources.resourceNumber ASC
qGetObjects (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1036735
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=14ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:34.034
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 = 1036735 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=22ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
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 @ 16:48:34.034
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 = 1036234 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qryGetObjects (Datasource=developersdb, Time=12ms, Records=6) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:34.034
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 = 1036234 
				ORDER BY resources.resourceNumber ASC
qGetObjects (Datasource=developersdb, Time=12ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
SELECT docs.documentID, docs.documentTitle, docs.documentNumber, resources.resourceNumber, resources.resourceURI
			FROM dlDocument docs
			INNER JOIN dlDocumentRelation docRelations ON docs.documentID = docRelations.childDocumentID
			LEFT OUTER JOIN dlDocumentResource docResources ON docRelations.childDocumentID = docResources.documentID
			LEFT OUTER JOIN dlResource resources ON docResources.resourceID = resources.resourceID
			WHERE docRelations.parentDocumentID = ?
			AND docRelations.relationTypeID = ?
			ORDER BY docs.dateCreated ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1036528
Parameter #2(cf_sql_numeric) = 4

qryGetObjects (Datasource=developersdb, Time=12ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:34.034
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 = 1036528 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetObjects (Datasource=developersdb, Time=13ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 16:48:34.034
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 = 1036234 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qryGetObjects (Datasource=developersdb, Time=12ms, Records=6) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 16:48:34.034
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 = 1036234 
				ORDER BY resources.resourceNumber ASC

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\air_traffic\publications\at_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=/air_traffic/publications/at_notices/index.cfm?archive=true&documentID=1036234
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.27.229.24
PATH_INFO=
PATH_TRANSLATED=\\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\air_traffic\publications\at_notices\index.cfm
QUERY_STRING=archive=true&documentID=1036234
REMOTE_ADDR=10.27.195.229
REMOTE_HOST=10.27.195.229
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/air_traffic/publications/at_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=161756
CFTOKEN=10156b794eaee3e8-CEDCB9A8-954A-BDCC-DB1131E33BA37617

Session Variables:
sessionid=716A79A407F333468BA59924628AE265.www
urltoken=CFID=161756&CFTOKEN=10156b794eaee3e8-CEDCB9A8-954A-BDCC-DB1131E33BA37617&jsessionid=716A79A407F333468BA59924628AE265.www

URL Parameters:
archive=true
documentID=1036234
Debug Rendering Time: 28 ms