CONTENTSTART
EXCLUDESTART EXCLUDEEND

Nondiscrimination & Anti-Harassment Policy

NWTC is committed to taking all appropriate measures to maintain an environment free from discrimination and harassment. For that reason, the College will not tolerate unlawful discrimination, harassment of any kind, or retaliation against a person who files a complaint relating to discrimination or harassment by an employee, student, customer, or vendor or participates in the investigation of a complaint. Discriminating, harassing and retaliatory behavior may be grounds for corrective and disciplinary action, up to and including termination or expulsion from the College.

Any online postings or other electronic communication occurring outside of NWTC’s control will only be subjected to this policy when those online behaviors can be shown to cause a substantial on-campus disruption, which includes the substantial effects on-campus or off-campus harassment.

College Policy on Nondiscrimination

NWTC adheres to all federal and state civil rights laws banning discrimination in public institutions of higher education. NWTC does not discriminate on the basis of political affiliation, age, race, creed, marital status, color, sex, including sexual orientation and gender identity, national origin, disability, veteran status, genetic testing or other applicable legislated categories, in its services, employment programs, and/or its educational programs and activities, including but not limited to admissions, treatment and access. Moreover, NWTC provides assurances that lack of English reading/speaking skills will not be a barrier to admittance and participation in the College.


NWTC adhiere a todas las leyes de derechos civiles federales y estatales que prohíben la discriminación en las instituciones públicas de educación superior . NWTC no discrimina sobre la base de su afiliación política , edad, raza , credo , estado civil , color, sexo , incluida la orientación sexual e identidad de género , origen nacional , discapacidad , condición de veterano , las pruebas genéticas u otras categorías legislados aplicables , en sus servicios , programas de empleo , y / o sus programas y actividades educativas, incluyendo pero no limitado a las admisiones , tratamiento y acceso . Por otra parte, NWTC ofrece garantías de que carecen de la lectura Inglés / habilidades de habla no serán un obstáculo.


NWTC adheres rau tag nrho cov tsoom fwv teb chaws thiab lub xeev txoj cai civil kev cai banning muaj kev ntxub ntxaug nyob rau hauv pej xeem cov tsev kawm ntawv qib siab . NWTC tsis ciav-cais nyob rau hauv lub hauv paus ntawm kev nom kev tswv ntseeg, hnub nyoog , haiv neeg , kev ntseeg , muaj txij nkawm , nqaij daim tawv, pw ua ke, xws li kev sib deev orientation thiab yog txivneej los pojniam yog leejtwg, lub tebchaws twg tuaj , kev tsis taus , qub tub rog li cas , tshuaj ntsuam genetic testing los yog lwm cov legislated pawg , nyob rau hauv nws cov kev pab cuam , kev ua hauj lwm cov kev pab cuam , thiab / los yog nws kev kawm ntawv thiab kev ua, nrog rau tiam sis tsis yog tas rau li, kev kho mob thiab kev siv . Ntxiv mus, NWTC muab tseeb uas tsis muaj lus Askiv nyeem ntawv / hais lus yuav tsis muaj ib tug teeb meem rau kev yuav thiab.

Key Definitions

Discrimination is a difference in treatment in any service, program, activity or employment at NWTC on the basis of the protected classes referenced above or any others protected under state and federal laws.

Examples of discrimination include unreasonably interfering with an individual’s employment or admission, benefits or promotions opportunity, subjecting an individual to different academic or employment standards or denial of use of facilities or equipment based on an individual’s protected status.

Harassment is unwelcomed or unsolicited behavior directed at an individual or group of people because of a protected class where the behavior adversely affects the person’s employment, academic or working environment.

Harassment is not: 

  • Feedback regarding unsatisfactory work/grades or a poor performance conversation that is reasonable and constructive
  • Discussions on controversial topics
  • Polite requests for a date from a peer, comments on clothing or compliments about appearance

While the above behavior is not harassing behavior in and of itself, similar behavior done to retaliate against someone or that creates a hostile environment may be considered harassing.

Hostile Environment includes any situation in which there is harassing conduct based on a protected class that is sufficiently severe, persistent or pervasive such that it alters the conditions of employment or limits, interferes with or denies educational benefits or opportunities, from both a subjective (the alleged victim’s) and an objective (reasonable person’s) viewpoint.

The determination of whether an environment is “hostile” must be based on all of the circumstances. These circumstances may include, but are not limited to:

  • The frequency of the conduct
  • The nature and severity of the conduct
  • Whether the conduct was physically threatening
  • Whether the conduct was humiliating
  • The effect of the conduct on the alleged victim’s mental or emotional state
  • Whether the conduct was directed at more than one person
  • Whether the conduct arose in the context of other discriminatory conduct
  • Whether the conduct unreasonably interfered with the alleged victim’s educational or work performance

Sexual Harassment is defined as unwelcome, gender-based verbal or physical conduct that is sufficiently severe, persistent or pervasive that is used as the basis for unlawful discriminatory practice or such conduct has the purpose or effect of creating an intimidating, hostile, or offensive environment for employees and students. Sexual harassment includes:

  • Unwelcome sexual advances or requests for sexual favors
  • Making submission to, or rejection of, such conduct as a factor in employment decisions
  • Permitting such conduct to unreasonably interfere with a student's academic work
  • Unwelcome sexual advances, requests for sexual favors or other verbal or physical conduct of a sexual nature or submission to or rejection of such conduct results in the creation of a hostile environment or retaliation
  • A supervisor and/or other management personnel who regularly solicits sexual favors from subordinate employees and offers job opportunities to those who comply (Quid pro quo)

Sexual Misconduct is a broad term encompassing any non-consensual behavior of a sexual nature that is committed by force or intimidation, or that is otherwise unwelcome. It may vary in its severity and consist of a range of behaviors or attempted behaviors. To read more on the College’s zero tolerance stance on sexual misconduct, click here: NWTC Gender Discrimination and Sexual Misconduct Policy.

Retaliation

Retaliating directly or indirectly against a person who has, in good faith, filed, supported, or participated in an investigation of a complaint, as defined above, is prohibited. Retaliation includes, but is not limited to, ostracizing the person, pressuring the person to drop or not support the complaint, or to provide false or misleading information, or engaging in conduct that may reasonably be perceived to affect adversely that person's educational, living, or work environment. Retaliation also includes similar conduct engaged in by a third party at the complainant’s or respondent’s request. Depending on the circumstances, retaliation may be unlawful and may constitute a violation of this policy, whether or not the complaint is ultimately found to have merit.

Grievance Procedure

In accordance with the Nondiscrimination and Anti-Harassment Policy, the College will investigate and respond to any formal or informal complaint or notice of potential violation of the policy that is received by the Director of Diversity & Inclusion/Title IX Coordinator; Dean of Student Development/Title IX Student Deputy Coordinator; Human Resources staff or other managers or supervisors representing the College. Any employee or student who believes they have been the subject of prohibited discrimination, harassment or retaliation have the option of pursing the complaint on an informal or formal basis. In either case, the complaint should be made as soon after the alleged act as possible so as to assist with a prompt and equitable investigation.

Step 1 – Informal Discussion

Employees and students who feel they are being discriminated against or harassed are encouraged to ask the individual to cease the behavior and to be specific regarding the behavior or incident that is objectionable, how you feel about the issue, and what changes you would like to see.  Employees may seek assistance from their supervisor; department head; their HR Partner; Director of Talent Management or Director of Diversity & Inclusion/Title IX Coordinator. Students may seek assistance from their instructors; counselor; associate dean; dean, Director of Diversity & Inclusion/Title IX Coordinator, or the Dean of Student Development/Title IX Student Deputy Coordinator.

When informally addressing an act of unwanted behavior, you should document the behaviors, when the individual was asked to cease the behavior, and any witnesses that were present when the behavior took place and when the individual was asked to cease the behavior.

Throughout the preliminary investigation the complainant will be provided appropriate support and consultation for the complainant. Complainants will be informed about campus and community resources, state and federal laws and will be notified of their right to file a formal discrimination complaint with Northeast Wisconsin Technical College.

If this action does not resolve the problem, you may wish to continue with a formal or complaint, which may be made with the individuals named at the conclusion of this policy in care of the following offices:

​​Campus Contacts for Discrimination Complaints

Green Bay Campus

  • HR Partners/Employee Discrimination and Harassment (920) 498-6286 or 800-422-6982, ext. 6286
  • Director of Diversity & Inclusion/Title IX Coordinator (920) 498-6826
  • Dean of Student Development/Title IX Student Deputy Coordinator (920) 498-6984
  • Director of Talent Management/Title IX Employee Coordinator (920) 498-6828
  • Manager of Accommodation Services/Title IX Student Deputy Coordinator (920) 498-6390

Marinette Campus

  • Main office (715) 735-9361

Sturgeon Bay Campus

  • Main office (920) 746-4900

Campus Safety and Security (920) 498-5454

Regional Learning Centers and Ancillary locations should contact the Green Bay campus

 

Step 2 – Formal Procedure

Employees and students are encouraged to submit a complaint to the Director of Diversity and Inclusion/Title IX Coordinator or at https://publicdocs.maxient.com/reportingform.php?NortheastWisconsinTC&layout_id=10, as soon as possible to assist in the investigation. Complaints may be initiated in writing or made verbal, but should include:

  • The date(s) time(s), place(s), pertinent facts and circumstances of the alleged discrimination/harassment/retaliation
  • Any witnesses 

For students, any NWTC staff member can assist you with filling out the incident report or direct you to trained resources to assist you. It is preferred that the complaint be submitted via an electronic incident report. Incident reports can be found at: https://publicdocs.maxient.com/reportingform.php?NortheastWisconsinTC&layout_id=10. If, due to a disability, accommodations are needed to assist the student with filing a complaint, please contact: Accommodation Services at (920) 498-6904. The complainant is encouraged to file the complaint as soon as possible after the incident to ensure a prompt and effective due process for all the parties involved in the situation.

The Director of Diversity & Inclusion/Title IX Coordinator or Dean of Student Development/Title IX Student Deputy Coordinator may assign a trained Investigator to promptly and equitably investigate the allegation(s).

The assigned Investigator will conduct an interview with the employee or student registering the complaint and upon receiving consent from the complainant to begin an investigation. The intent of the interview is to determine a factual and complete account of the complaint. The following information will be sought during the interview process:

  • The facts and circumstances of the alleged misconduct and proposed resolution
  • The severity of the conduct
  • The number and frequency of acts of alleged discrimination or harassment
  • The apparent intent of the person alleged to have engaged in the conduct
  • The relationship of the parties
  • The response of the complainant at the time of the incident(s)
  • The relevant work environment

To the extent practicable, the investigator will interview all other individuals who witnessed or may have witnessed the incident or who may have knowledge of the incident. Periodic updates to the complainant and the alleged offender will be provided.

The investigator will interview the person alleged to have engaged in discrimination or harassment and inform the individual that a complaint has been made against him or her, and allow the person to respond to the complaint. The person alleged to have engaged in the act will be informed that the incident is not to be discussed with coworkers or students and that retaliatory action against the complainant will not be tolerated.

To the extent practicable, the investigator will review any other relevant information or evidence and/or interview any other relevant witnesses. The preponderance of the evidence standard (i.e., it is more likely than not that discrimination occurred) will be applied when investigating allegations of discrimination, harassment or retaliation.

A written record of the investigation will be made, inclusive of all notes made of interviews, conversations, or verbal responses to questions posed by the investigator to the complainant, witnesses or respondent, and any other aspects of the investigation. The entire written record and report, including a written summary of the findings of the investigation, will be provided to the Director of Diversity & Inclusion/Title IX Coordinator; Dean of Student Development/Title IX Student Deputy Coordinator or designee. Where appropriate, the written report will include any recommendations for discipline.

The Director of Diversity & Inclusion/Title IX Coordinator; Dean of Student Development/Title IX Student Deputy Coordinator or designee will review the investigative report, evidence and all known circumstances from the investigator and make a final determination. This outcome may include a verbal reprimand up to and including termination of employment, expulsion from school, or any other appropriate remedial action for a person found to have violated these policies.

The complaint process, from the filing of a complaint through a final determination, will be completed within sixty (60) days, unless the timeline is extended for good cause (such as unavailable witnesses or academic breaks).​​​

Appeal Process

The complainant may choose to file an appeal of the outcome of the incident. An appeal from an employee must be delivered to the Director of Diversity & Inclusion/Title IX Coordinator and Vice President of Human Resources for employees. An appeal from a student must be delivered to the Dean of Student Development/Title IX Student Deputy Coordinator and Vice President of Student Services. Appeals must be received within five business days after receipt of written notification of the decision or sanction.

The Vice President of Human Resources or Vice President of Student Services shall review all materials pertaining to the investigation and materials that the complainant may feel relevant to the appeal. The bases of appeals include: (1) denial of a fair hearing, (2) insufficient evidence to establish responsibility, and (3) new information available that was not available at the time of the hearing which affects the disciplinary decision. The appeal must specify any alleged factual or procedural errors, new information or any alleged issues concerning interpretation of the College’s policy. The Vice President of Human Resources or Vice President of Student Services will issue a final written decision for the College within seven business days of receiving the notice of an appeal.

Agency Reporting

At any time or if there is disagreement with the final written decision, the complainant may file directly with the Wisconsin Department of Workforce Development, Equal Employment Opportunities Commission, Office for Civil Rights or pursue avenues of resolution for complaints filed on the basis of a  protected status.

State of Wisconsin Department of Workforce Development -

Equal Rights Division Contact Information

Madison Office
201 E. Washington Avenue
Room A100
PO Box 8928
Madison, WI 53708

(608) 266-6860

erinfo@dwd.wisconsin.gov

Milwaukee Office
819 N. 6th Street
Room 723
Milwaukee, WI 53203

(414) 227-4384

erinfo@dwd.wisconsin.gov

U.S. Equal Employment Opportunity Commission Contact Information

Milwaukee Area Office
Reuss Federal Plaza
310 W. Wisconsin Avenue
Suite 500
Milwaukee, WI 53203

(800) 669-4000

U.S. Department of Education - Office of Civil Rights Contact Information

Chicago Office
Citigroup Center
500 W. Madison Street, Suite 1475
Chicago, IL 60661

(312) 730-1560

OCR.Chicago@ed.gov

 

EXCLUDESTART
EXCLUDESTART EXCLUDEEND
EXCLUDEEND
CONTENTEND
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/App_Data/Persistent/Cache/NWTC/outputdata/00AF/m1406927446.cache Local SimpleHandler`2.StartEvent
2 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx Local DbPathProvider.GetFileHash
3 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx.cs Local
4 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
5 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|nwtc|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|en-us|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|true
template|24105
nodeid|2242
nodeid|1314
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|nwtc|https://wwwdev.nwtc.edu/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|en-us||true|true
template|24105
nodeid|2242
nodeid|1314
SimpleHandler`2.StartEvent
3 ADD currentdocument|nwtc|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|en-us
nodes|nwtc|cms.menuitem|all
node|nwtc|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy
SimpleHandler`2.StartEvent
4 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
5 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
6 ADD pageinfo|nwtc|/about-nwtc/departments/human-resources|en-us||false
template|24108
nodeid|177
PageContext.CurrentPage_InitComplete
7 GET pageinfo|nwtc|/about-nwtc/departments|en-us||false PageContext.CurrentPage_InitComplete
8 GET pageinfo|nwtc|/about-nwtc|en-us||false
9 GET pageinfo|nwtc|/|en-us||false
10 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
11 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
12 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|1312
partial
template|24098
13 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
14 GET cmsdatasource||en-us|nwtc|/master-items/mega-menus/%|en-us|false|nwtc.megamenu||nodeorder asc|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false|| CMSWebPartZone.CachedWebPart_Init
15 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|/|googletranslator
CMSWebPartZone.CachedWebPart_Init
16 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
17 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|/|mobilemenubutton
18 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
19 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|/|newmobilemenu
20 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|/|mobilemenu
21 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
22 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|1312
partial
template|24098
23 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|1312
partial
template|24098
24 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|1312
partial
template|24098
25 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
26 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
27 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|1312
partial
template|24098
28 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|1312
partial
template|24098
29 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
30 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
31 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
32 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
PageContext.CurrentPage_InitComplete
33 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|1312
partial
template|24098
34 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
35 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|/|googletranslator
36 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
37 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|/|mobilemenubutton
38 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
39 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|/|newmobilemenu
40 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|/|mobilemenu
41 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
42 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|1312
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
43 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|1312
partial
template|24098
44 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|1312
partial
template|24098
45 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
PageContext.CurrentPage_InitComplete
46 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
47 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|1312
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
48 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|1312
partial
template|24098
49 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
PageContext.CurrentPage_InitComplete
50 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
51 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
52 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|1312
partial
template|24098
53 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|1312
partial
template|24098
54 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|1312
partial
template|24098
55 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|1312
partial
template|24098
56 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|1312
partial
template|24098
57 GET onlinemarketingcpvariantsbytemplateid|24105 PageContext.CurrentPage_InitComplete
58 GET onlinemarketingcpvariantsbytemplateid|24105
59 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24105
CMSWebPartZone.CachedWebPart_Init
60 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24105
61 ADD Partial cache (MainImage)
webpartinstance|19f96105-92a8-4331-9a25-178b17ac5a9f
documentid|1312
partial
template|24105
62 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|1312
partial
template|24105
63 ADD Partial cache (NewLeftMenu)
webpartinstance|07769954-cbf0-4d4f-be40-7f5c973d5ac4
partial
template|24105
64 ADD Partial cache (LeftMenu)
webpartinstance|752c82b4-5689-4f18-b6f4-ffb101f89bd4
partial
template|24105
65 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24105
PageContext.CurrentPage_InitComplete
66 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24105
67 ADD Partial cache (MainImage)
webpartinstance|19f96105-92a8-4331-9a25-178b17ac5a9f
documentid|1312
partial
template|24105
68 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|1312
partial
template|24105
69 ADD Partial cache (NewLeftMenu)
webpartinstance|07769954-cbf0-4d4f-be40-7f5c973d5ac4
partial
template|24105
70 ADD Partial cache (LeftMenu)
webpartinstance|752c82b4-5689-4f18-b6f4-ffb101f89bd4
partial
template|24105
71 GET cmsdatasource||en-us|nwtc|/master-items/alerts/%|en-us|false|nwtc.alert||nodeorder|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|1||false|| BasicRepeater.OnLoad
72 GET pageinfo|nwtc|/master-items/mega-menus/admissions|en-us||false CMSAbstractWebPart.OnLoad
73 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
74 GET inlinewidgetcontrol|528|1572
75 GET pageinfo|nwtc|/master-items/mega-menus/programs|en-us||false CMSAbstractWebPart.OnLoad
76 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
77 GET inlinewidgetcontrol|528|1572
78 GET pageinfo|nwtc|/master-items/mega-menus/student-experience|en-us||false CMSAbstractWebPart.OnLoad
79 GET cmsdatasource||en-us|nwtc|/events/%|en-us|false|nwtc.event|((eventallday = 0 and datediff(minute,getdate(),eventdate)>=0) or (eventallday = 1 and datediff(day, getdate(), eventdate)>=0) or (eventenddate is not null and ((eventallday = 1 and datediff(day,eventenddate,getdate())<=0) or (eventallday = 0 and datediff(minute,eventenddate,getdate())<=0)))) and ( documentid in (select documentid from cms_documentcategory where categoryid in (select categoryid from cms_category where categoryname in('academiccalendar_1','studentlife_1') )) ) and ( documentid in (select documentid from cms_documentcategory where categoryid in (select categoryid from cms_category where categoryname in('greenbaycampus') )) ) |eventdate asc, nodelevel, nodeorder|-1|true|00000000-0000-0000-0000-000000000000||false|2||false|| BasicRepeater.OnLoad
80 GET pageinfo|nwtc|/master-items/mega-menus/corporate-training|en-us||false CMSAbstractWebPart.OnLoad
81 GET pageinfo|nwtc|/master-items/mega-menus/about-nwtc|en-us||false
82 GET cmsdatasource||en-us|nwtc|/resources/shared-page-content/satisfaction|en-us|false|custom.shareablecontent|||-1|true|00000000-0000-0000-0000-000000000000||false|0||false|| BasicRepeater.OnLoad
83 GET pageinfo|nwtc|/resources/shared-page-content/satisfaction|en-us||false CMSAbstractWebPart.OnLoad
84 ADD breadcrumbs|nwtc|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy|en-us|false|cms.menuitem;nwtc.programcluster||true|
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
node|nwtc|/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy
node|nwtc|/about-nwtc/departments/human-resources
node|nwtc|/about-nwtc/departments
node|nwtc|/about-nwtc
node|nwtc|/
CMSAbstractMenuProperties.OnLoad
85 GET inlinewidgetcontrol|526|1571 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
86 GET favicon|nwtc CMSPages_PortalTemplate.OnPreRender
87 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy';
DECLARE @NodeAliasPath nvarchar(max) = N'/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)))
) AS SubData
ORDER BY CMS_P DESC
@NodeSiteID (1)
@DocumentUrlPath ("/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy")
@NodeAliasPath ("/about-nwtc/departments/human-resources/non-discrimination-anti-harassment-policy")
@DocumentCulture ("en-US")
3.8 kB
 
Table (1 [65], 26 kB)
 
SimpleHandler`2.StartEvent 0.021
 
2
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] IN (N'/About-NWTC/Departments/Human-Resources', N'/About-NWTC/Departments', N'/About-NWTC', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
451 B
 
Table (4 [157], 66 kB)
 
SimpleHandler`2.StartEvent 0.032
 
3 This same query was called more than once within this request.
(om.contact.generalselect)
DECLARE @VisitorToContactVisitorGUID uniqueidentifier = '00000000-0000-0000-0000-000000000000';

SELECT TOP 1 *
FROM OM_Contact
WHERE [ContactID] IN (
SELECT TOP 1 [VisitorToContactContactID]
FROM OM_VisitorToContact
WHERE [VisitorToContactVisitorGUID] = @VisitorToContactVisitorGUID
)
@VisitorToContactVisitorGUID (00000000-0000-0000-0000-000000000000)
333 B
 
SimpleHandler`2.StartEvent 0.002
 
4
(cms.menuitem.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (NodeID = 2242) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
396 B
 
Table (1 [166], 26 kB)
 
SimpleHandler`2.StartEvent 0.024
 
5
(cms.class.selectrequiredroles)
DECLARE @ClassID int = 4608;
DECLARE @PermissionName nvarchar(max) = N'read';
DECLARE @SiteID int = 1;

SELECT * FROM CMS_Role WHERE RoleID IN (SELECT RoleID FROM CMS_RolePermission WHERE PermissionID IN (SELECT PermissionID FROM CMS_Permission WHERE ClassID=@ClassID AND PermissionName=@PermissionName)) AND (SiteID=@SiteID OR SiteID IS NULL)
@ClassID (4608)
@PermissionName ("read")
@SiteID (1)
359 B
 
Table (2 [10], 193 B)
 
SimpleHandler`2.StartEvent 0.003
 
6
(cms.acl.generalselect)
DECLARE @ACLID int = 41;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
@ACLID (41)
78 B
 
Table (1 [5], 54 B)
 
SimpleHandler`2.StartEvent 0.003
 
7
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 1;
DECLARE @Date datetime2 = '1/16/2018 1:40:57 AM';

SELECT DISTINCT X.Allowed,X.Denied,X.ValidTo,X.ACLID
FROM (
SELECT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, null AS 'ValidTo',CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
WHERE
--User
(CMS_ACLItem.UserID IN (SELECT CMS_User.UserID FROM CMS_User JOIN CMS_UserSite ON CMS_User.UserID = CMS_UserSite.UserID
WHERE CMS_User.UserID = @UserID AND CMS_UserSite.SiteID = @SiteID )
-- Specific roles
OR CMS_ACLItem.RoleID IN (SELECT RoleID FROM CMS_Role WHERE RoleName IN ('_everyone_','_notauthenticated_'))
)
-- Membership
UNION ALL
SELECT DISTINCT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, UserRole.ValidTo, CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
INNER JOIN [View_CMS_UserRoleMembershipRole] AS UserRole ON UserRole.RoleID = CMS_ACLItem.RoleID
WHERE (UserRole.ValidTo > @Date OR UserRole.ValidTo IS NULL)
AND (UserRole.SiteID = @SiteID OR UserRole.SiteID IS NULL)
AND UserRole.UserID = @UserID
) AS X
WHERE ACLID IN (12,41)

@UserID (65)
@SiteID (1)
@Date (1/16/2018 1:40:57 AM)
1.3 kB
 
SimpleHandler`2.StartEvent 0.006
 
8 This same query was called more than once within this request.
(om.contact.generalselect)
DECLARE @VisitorToContactVisitorGUID uniqueidentifier = '00000000-0000-0000-0000-000000000000';

SELECT TOP 1 *
FROM OM_Contact
WHERE [ContactID] IN (
SELECT TOP 1 [VisitorToContactContactID]
FROM OM_VisitorToContact
WHERE [VisitorToContactVisitorGUID] = @VisitorToContactVisitorGUID
)
@VisitorToContactVisitorGUID (00000000-0000-0000-0000-000000000000)
333 B
 
SimpleHandler`2.StartEvent 0.003
 
9
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 177;

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([DocumentCulture] = @DocumentCulture AND [NodeID] = @NodeID)
) AS SubData
ORDER BY CMS_P DESC
@DocumentCulture ("en-US")
@NodeID (177)
3.1 kB
 
Table (1 [65], 36 kB)
 
PageContext.CurrentPage_InitComplete 0.004
 
10
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] IN (N'/About-NWTC/Departments', N'/About-NWTC', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
407 B
 
Table (3 [157], 30 kB)
 
PageContext.CurrentPage_InitComplete 0.012
 
11
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN NWTC_ProgramPage ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = NWTC_ProgramPage.ProgramPageID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramPage' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_ProgramCluster ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_ProgramCluster.ProgramClusterID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_Blog ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_Blog.BlogID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.Blog' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE (((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/%')) AND (NodeLevel < 3)) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
3.4 kB
 
Table (74 [19], 12.7 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.030
 
12
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN NWTC_ProgramPage ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = NWTC_ProgramPage.ProgramPageID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramPage' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_ProgramCluster ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_ProgramCluster.ProgramClusterID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_Blog ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_Blog.BlogID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.Blog' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE ((((((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/%')) AND (NodeLevel < 3)) AND (Published = 1)) AND (NodeAliasPath like '/%')) AND (NodeLevel < 3)) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
3.5 kB
 
Table (74 [19], 12.7 kB)
 
PageContext.CurrentPage_InitComplete 0.019
 
13
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 1312
PageContext.CurrentPage_InitComplete 0.005
 
14
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN NWTC_ProgramPage ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = NWTC_ProgramPage.ProgramPageID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramPage' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_ProgramCluster ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_ProgramCluster.ProgramClusterID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE ((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/About-NWTC/Departments/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
Table (85 [19], 22 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.035
 
15
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN NWTC_ProgramPage ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = NWTC_ProgramPage.ProgramPageID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramPage' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_ProgramCluster ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_ProgramCluster.ProgramClusterID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE ((((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/About-NWTC/Departments/%')) AND (Published = 1)) AND (NodeAliasPath like '/About-NWTC/Departments/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.9 kB
 
Table (85 [19], 22 kB)
 
PageContext.CurrentPage_InitComplete 0.024
 
16
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/16/2018 1:40:59 AM';
DECLARE @NodeLevel int = 4;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [NodeSiteID], [NodeACLID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND ([NodeAliasPath] IN (N'/About-NWTC/Departments/Human-Resources/Non-discrimination-Anti-Harassment-Policy', N'/About-NWTC/Departments/Human-Resources', N'/About-NWTC/Departments', N'/About-NWTC', N'/'))) AND ([ClassName] IN (N'CMS.MenuItem', N'NWTC.ProgramCluster')) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeAliasPath DESC
@NodeSiteID (1)
@Now (1/16/2018 1:40:59 AM)
@NodeLevel (4)
@DocumentCulture ("en-US")
1.7 kB
 
Table (4 [36], 966 B)
 
CMSAbstractMenuProperties.OnLoad 0.028
 
  16 queries, 25 kB write, 255 kB read   0.251