Follow PFE on Facebook
We've gone through quite a bit of details covering crawled properties including an overview, deep dive into what makes up crawled properties, and detail on the Basic and Mail categories. This post will cover the Crawled Property Category called "Office".
The Office category includes gathering metadata from Microsoft Word documents, Microsoft Excel spreadsheets, Microsoft PowerPoint slides, etc.
The following table provides details about each of the crawled properties in the Basic category based on a test environment. The table is sorted by Property Set ID, or GUID, then by Name and includes the following columns:
Name – The name of the crawled property
Represented in Crawled Properties View – The name of the crawled property in the Crawled Properties View
Property Name – A description of what the property is
PROPSET – The GUID or Property Set ID
Property Set Description – A description of the property set for which this is a member
Variant Type – The variant type of the property
Variant Type Description – A description of the variant type
Mapped To – A listing of which managed property(ies) this crawled property is mapped to
Indexed – Indicates whether this property is included in the index from an “out of the box” installation.
NOTE: Your environment may have more or less crawled properties based on the content being crawled.
NAME: Represented in Crawled Properties View Property Name PROPSET Property Set Description Variant Type Variant Type Description Mapped To Index 2 Office:2(Text) Category (i.e. memo, proposal, etc) d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 31 Text Yes 3 n/a Document Presentation Format (i.e. 35mm, printer, video, etc) d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 31 Text 5 Office:5(Integer) Document Line Count d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 20 Integer 6 Office:6(Integer) Document Paragraph Count d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 20 Integer 7 n/a Slide Count d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 20 Integer 8 n/a Document Note Count d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 20 Integer 9 n/a Hidden Slide Count d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 20 Integer 10 n/a Multimedia Clip Count d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 20 Integer 11 Office:11(Yes/No) Scale (set to True (-1) when scaling of thumbnail) d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 11 Yes/No 12 Office:12(Binary Data) Heading Pair (internal property indicating the grouping of different document parts and the number of items in each group) d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 4108 Binary Data 13 Office:13(Text) partTitles (DocParts) (names of document parts) d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 31 Text 14 Office:14(Text) Document Manager d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 31 Text Yes 15 Office:15(Text) Company or Publisher d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 31 Text Yes 16 Office:16(Yes/No) Links Dirty d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 11 Yes/No 17 Office:17(Integer) CCH with Spaces (number of characters including spaces) d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 20 Integer 18 Office:18(Text) GUID (no longer used) d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 0 Text Yes 19 Office:19(Yes/No) Shared Doc d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 11 Yes/No 22 Office:22(Yes/No) Hyperlinks Changed d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 11 Yes/No 23 Office:23(Integer) Version d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 20 Integer 26 Office:26(Text) Content Type d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 31 Text Yes 27 Office:27(Text) Content Status d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 0 Text 28 Office:28(Text) Language d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 0 Text 29 Office:29(Text) Document Version d5cdd502-2e9c-101b-9397-08002b2cf9ae Document Summary Information 0 Text 2 Office:2(Text) d5cdd505-2e9c-101b-9397-08002b2cf9ae User Defined Properties 31 Text Yes 3 Office:3(Text) d5cdd505-2e9c-101b-9397-08002b2cf9ae User Defined Properties 31 Text Yes 4 Office:4(Text) d5cdd505-2e9c-101b-9397-08002b2cf9ae User Defined Properties 31 Text Yes _PID_HLINKS _PID_HLINKS(Binary Data) Document hyperlink references d5cdd505-2e9c-101b-9397-08002b2cf9ae User Defined Properties 65 Binary Data _SharedFileIndex _SharedFileIndex(Text) Site ID of the document workspace d5cdd505-2e9c-101b-9397-08002b2cf9ae User Defined Properties 31 Text Yes _SourceUrl _SourceUrl(Text) Address of the Source Workspace Library d5cdd505-2e9c-101b-9397-08002b2cf9ae User Defined Properties 31 Text Yes ContentType ContentType(Text) Content Type d5cdd505-2e9c-101b-9397-08002b2cf9ae User Defined Properties 31 Text Yes ContentTypeId ContentTypeId(Text) Content Type ID d5cdd505-2e9c-101b-9397-08002b2cf9ae User Defined Properties 31 Text Yes PROP_MULTVAL_PP PROP_MULTVAL_PP(Text) d5cdd505-2e9c-101b-9397-08002b2cf9ae User Defined Properties 31 Text Yes PROP_MULTVAL_QQ PROP_MULTVAL_QQ(Text) d5cdd505-2e9c-101b-9397-08002b2cf9ae User Defined Properties 31 Text Yes 2 Office:2(Text) Title f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 31 Text 3 Office:3(Text) Subject f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 31 Text DocSubject(Text) Yes 4 Office:4(Text) Author f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 31 Text Author(Text) 5 Office:5(Text) Keywords f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 31 Text DocKeywords(Text) 6 Office:6(Text) Description (or Comments) f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 31 Text Description(Text), DocKeywords(Text) Yes 7 Office:7(Text) Template f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 31 Text Yes 8 Office:8(Text) Last Author f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 31 Text Yes 9 Office:9(Text) Doc Revision Number f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 31 Text Yes 9 n/a Doc Revision Number (variant) f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 0 Text 10 Office:10(Date and Time) Edit Time Date/Time f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 64 Date and Time 11 Office:11(Date and Time) Last Printed f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 0 Text 12 Office:12(Date and Time) Content Created Date/Time f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 64 Date and Time Created(Date and Time) 13 Office:13(Date and Time) Last Saved Date/Time f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 64 Date and Time 14 Office:14(Integer) Page Count f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 20 Integer 15 Office:15(Integer) Word Count f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 20 Integer 16 Office:16(Integer) Character Count f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 20 Integer 18 Office:18(Text) Application Name f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 31 Text 19 Office:19(Integer) Document Security f29f85e0-4ff9-1068-ab91-08002b27b3d9 Summary Information 20 Integer
NAME:
Represented in Crawled Properties View
Property Name
PROPSET
Property Set Description
Variant Type
Variant Type Description
Mapped To
Index
2
Office:2(Text)
Category (i.e. memo, proposal, etc)
d5cdd502-2e9c-101b-9397-08002b2cf9ae
Document Summary Information
31
Text
Yes
3
n/a
Document Presentation Format (i.e. 35mm, printer, video, etc)
5
Office:5(Integer)
Document Line Count
20
Integer
6
Office:6(Integer)
Document Paragraph Count
7
Slide Count
8
Document Note Count
9
Hidden Slide Count
10
Multimedia Clip Count
11
Office:11(Yes/No)
Scale (set to True (-1) when scaling of thumbnail)
Yes/No
12
Office:12(Binary Data)
Heading Pair (internal property indicating the grouping of different document parts and the number of items in each group)
4108
Binary Data
13
Office:13(Text)
partTitles (DocParts) (names of document parts)
14
Office:14(Text)
Document Manager
15
Office:15(Text)
Company or Publisher
16
Office:16(Yes/No)
Links Dirty
17
Office:17(Integer)
CCH with Spaces (number of characters including spaces)
18
Office:18(Text)
GUID (no longer used)
0
19
Office:19(Yes/No)
Shared Doc
22
Office:22(Yes/No)
Hyperlinks Changed
23
Office:23(Integer)
Version
26
Office:26(Text)
Content Type
27
Office:27(Text)
Content Status
28
Office:28(Text)
Language
29
Office:29(Text)
Document Version
d5cdd505-2e9c-101b-9397-08002b2cf9ae
User Defined Properties
Office:3(Text)
4
Office:4(Text)
_PID_HLINKS
_PID_HLINKS(Binary Data)
Document hyperlink references
65
_SharedFileIndex
_SharedFileIndex(Text)
Site ID of the document workspace
_SourceUrl
_SourceUrl(Text)
Address of the Source Workspace Library
ContentType
ContentType(Text)
ContentTypeId
ContentTypeId(Text)
Content Type ID
PROP_MULTVAL_PP
PROP_MULTVAL_PP(Text)
PROP_MULTVAL_QQ
PROP_MULTVAL_QQ(Text)
Title
f29f85e0-4ff9-1068-ab91-08002b27b3d9
Summary Information
Subject
DocSubject(Text)
Author
Author(Text)
Office:5(Text)
Keywords
DocKeywords(Text)
Office:6(Text)
Description (or Comments)
Description(Text), DocKeywords(Text)
Office:7(Text)
Template
Office:8(Text)
Last Author
Office:9(Text)
Doc Revision Number
Doc Revision Number (variant)
Office:10(Date and Time)
Edit Time Date/Time
64
Date and Time
Office:11(Date and Time)
Last Printed
Office:12(Date and Time)
Content Created Date/Time
Created(Date and Time)
Office:13(Date and Time)
Last Saved Date/Time
Office:14(Integer)
Page Count
Office:15(Integer)
Word Count
Office:16(Integer)
Character Count
Application Name
Office:19(Integer)
Document Security