Office 365 and SharePoint – Sales Contract Lifecycle Management (CLM) – Taxonomy with Content Types and Site Columns

The next steps in Office 365 and SharePoint are to create the Site Content Types and Site Columns needed to define the structure of soon-to-be-created lists and libraries. This helps define a reusable classification and taxonomy framework through which the organization can structure documents and list items. Though this process does require elevated privileges in SharePoint Online, it can (should) be delegated to business teams to manage on their own when possible.

Policies such as these, which control how business management process are implemented in O365 and SharePoint, should be part of a SharePoint governance plan. Subject matter around best-practices for Term Store management, Site Column and Site Content Type creation, document management, list management, etc. fall under their Information Governance mandates which are based on Microsoft’s Governance Guidance documentation found here:

I have found few documents more useful in defining ways to consider how to effectively control and implement business management policy in SharePoint than those listed above. Couple those with the thousands of SharePoint blogs, and take advantage of all the free training at (for example) Microsoft Virtual Academy.

Review the Content Type and Site Column Basic Structure

You previously saw the screenshot below to describe an outline for creating site columns and content types. For reference:

Check out the training at Microsoft Virtual Academy, to help you choose whether to create site columns and content types at the site collection level or the site level. At least start with two basic questions:

  1. Will somebody likely want to reuse a site column and/or content type across multiple sites?
  2. Will somebody likely want to create a site column and/or content type with the exact same name outside of a specific site’s scope?

For this system, the answer to 1 is: yes, customers and sales contracts are types of content that will be used outside of the CLM site.

To question 2: no, the build will reuse the existing column and content type, and if they are to be overwritten, that will be inside a specific site’s scope. Therefore, create the site columns and content types at the Site Collection level.

Adding the SharePoint Site Columns

Navigate to the top level Intranet site, and select “Site settings” from the Control Gear. Start by building site columns which you will assemble later into site content types.

Choose “Site columns” from the “Web Designer Galleries” section of the top-level site’s Site Settings page:

Briefly a bit more about the “site collection level” or “site level” questions above. Site columns and content types can be made available to all the sites in a site collection or they can be scoped to just a specific site. The fallout of this decision will be covered in more detail in following-posts when we actually use the content types. But, for now…to visualize this, if you don’t go to the top level site in the Intranet before creating the site column or content type, it would be scoped to the specific sub site you were currently on instead.

Using the “Contract Lifecycle Management” site as the example, if you create a site column called “Test” in that sub site, it would look as follows (versus creating the same column in the Intranet top level site):

  • Columns such as Business Department, Category Picture, and Description (which happen to be OOTB) exist in the top-level site, so all of the sub sites inherit and can reuse those columns.
  • However, by creating a column “Test” in the CLM sub site, you can see it is scoped specifically to “Contract Lifecycle Management“.
  • You can even create an identically named column (i.e. “Test”) in the top-level Intranet site that is completely separate and will be available to all other sub sites but, as just noted, is superseded in the CLM sub site.

After clicking “Site columns” from the “Web Designer Galleries”, you’re presented with the following UI. Click “Create” to get to the Create Column form:

The following tables identifies all of the columns and values to specify while repeating the Create Column steps.

Note that, with Site Columns and Site Content Types in the table below you’ll read “n/a” for description fields. In real practice, governance would suggest you absolutely specify description values. Do not skip setting “Description” values in production.

Also, please note that I’ve specified customer names below, they are completely fictitious.

CLM – Sales Contract Related Site Columns


CLM – Customer Related Site Columns

*The Customer Name also applies to Customers but is already created above

Office 365 SharePoint Business Management Customer Fields.

Office 365 SharePoint Business Management Customer Fields.

Reviewing the SharePoint Site Columns

Review your work and confirm that all site columns are created:


And, with the column framework built, now move to creating the content types: Sales Contract and Customer.

Creating the SharePoint Site Content Types and Adding Site Columns for CLM

Starting at the top level Intranet site – Control Gear > Site Settings > Web Designer Galleries > Site content types > Create.

From the Create UI, create the Sales Contract content type:

Business Management – Sales Contract

After saving the settings, you’ll be brought to the edit page for the Site Content Type. Use “Add from existing site columns” to build out the content types:

There, use the “Select columns from” to filter down columns and then specify those columns which apply to the Sales Contract. Press OK when done.

*Don’t worry about the Hidden field shown below for “Title” or the Calculated column “Sales Contract Title”…that’s covered later. Yours will read “Required” for “Title” and you won’t have the “Sales Contract Title” field. This should be very close to what you see:



Now, do the same for Customer.

Business Management – Customer

*Same as above, your “Title” field will read, “Required”, and you’ll see how/why to set it to “Hidden” later:



And finally, review the Site Content Types list to ensure you see the two new content types correctly grouped under WMC Business Management:

You’ve created site columns, and after creating the site columns you created content types from those site columns. In the next post we’ll start seeing the libraries and lists come together and how to make further progress on facilitating CLM through Office 365 and SharePoint.

Categories: Business, Business Management, Contract Lifecycle Management, Office 365 and O365, SharePoint

Tags: , , ,

4 replies


  1. Office 365 and SharePoint – Sales Contract Lifecycle Management (CLM) – Get Sales Contract Title into Search with SharePoint Deisgner Workflow – Westmorr Consulting
  2. Office 365 and SharePoint – Human Resources (HR) – Performance Reviews using Document Sets and Content Organizer with Send to Connections – Westmorr Consulting
  3. Personal Trainer Assessment Forms in Office 365 SharePoint with Document Libraries – Westmorr Fitness
  4. Personal Trainer Software – Prep Work for the Final Clients List in Office 365 SharePoint – Westmorr Fitness

Leave a Reply