Sunday, August 5, 2012

Record Management capabilities of SharePoint 2010

Last year I was part of an initiative to assess SharePoint 2010 capabilities around records / document management. Spend few weeks to compare business requirements and found the following info...

Functionality
Description
Customizations Required to address majority of enterprises' need
Rating out of 5
Declare record  in-place manually 
Option to mark a sharepoint document as record manually to prevent further changes   and deletion
NA 

5
Declare records by manually moving it to record center
The “send to Record Center” option to manually declare records and send them to the RecordCenter is   located in Compliance Details overlay. It would be better if its available in the ribbon / pull down menu to make it more usable.
Custom command in ribbon to trigger "send to record center" action

4.5
Declare records automatically based on rule 
Process to define rules that mark a sharepoint document as record  to prevent further changes and deletion
NA 

5
Retain records and their associated metadata for   their retention time period
Whenever user changes the metadata of a record in Record Center,   system is not synchronizing the metadata changes to the record link which is located in the document center.
Custom component to
                        i.      Prevent metadata updation of a record link
                      ii.      Propagate metadata changes to record links in document center, whenever metadata values of the linked record has been changed

4
Ensure Record integrity throughout their retention time period
Only Selected metadata fields should be editable. metadata column edit   permissions should be based on the user role   / state of record matrix
Custom feature to restrict updation of critical metadata / record content by applying field level locking based on the following parameters
                        i.      Permission Level of the user
                      ii.      Stage of document (record, hold)

0
Dispose records in accordance with the Records Retention Schedule
Retention and disposition process of out-of-the-box SharePoint 2010 executes on individual items. The high volume of records for disposition will cause a critical usability issue of managing disposition of individual items. It is recommended to have a batch disposition option.

Out-of-the-box SharePoint terminates the expiration process whenever user cancels disposition approval request. It is recommended to have a “Cancelled Records Repository” to restart “disposition of rejected records” / put them on hold / assign a different content type.



A workflow to redirect records to record library / document library on an event of cancelled item metadata updation is recommended. 
Custom disposition process with the following high level functionalities
                        i.      Disposition schedules should run on scheduled intervals (monthly, quarterly, yearly)
                      ii.      Records/documents of sub site (project or dept) should be batched together and send for disposition approval
                    iii.      Record Stewards should be able to pick and choose items from the list and approve disposition.
                    iv.      Record Stewards should also able to apply hold, and change metadata to items by specifying valid remarks. These disposition cancelled records will be sent to Record Administrator for approval
                      v.      The Record Administrator should be able to review the disposition of cancelled records and apply the changes suggested by the Record Steward / himself.
When Record Administrator approves the changes obtained through disposition cancellation, record should move to Record Center or document center.

1.5
Discover Records for hold and apply hold in batch
The following changes in eDiscovery for Hold are recommended:
                        i.      Search refinement with advanced search feature to find actual record set for hold
                      ii.      Pick and choose option from the search results

Every legal hold search should find the documents and links to records. On applying hold to record links, it should apply hold to the linked records.

The following advanced options to streamline the hold process in batch are recommended:
                        i.      Apply hold to multiple records after selecting them from a list.
                      ii.      Applying hold to a library / folder
Advanced Search functionality to search records to apply hold.
Custom solution to apply hold only for those records chosen from the search results.
Custom solution to Select multiple records from a library and apply hold.
Provision to apply hold on all records/documents of a specific library or folder
The eDiscovery search in Document Center should find   documents and links to record along with in-place records.

3
Apply legal Hold to a Record manually
Option to hold a record from further processing and change
NA 

5
Release legal Hold from a Record manually
Option to release hold a record to allow  further processing and change
Component to apply hold to the linked record on applying hold in record link.

1.5
Release legal Hold from set of Records
“Search and Release Hold” option should be available which would enable user to release hold by selecting records from search result 
Advanced Search functionality to search records on hold.
Custom solution to release hold only for those items chosen from the hold search results.
Component to Select multiple records from a library and release hold.
Component to release hold from the linked record on releasing hold from a record link

1.5
Delete an in place record / record in record center   / record link/ record on hold
Since SharePoint considers a link to a record as an independent entity, users with “contribute” access can delete record links. This action should be restricted to Administrators to ensure accessibility.
Custom feature to prevent record link deletion

3.5
Move an in place record / record in record center / record link/ record on hold
Since SharePoint considers a link to a record as an independent entity, users with “contribute access” can move / edit a record link. This action should be limited to Record Administrators (to make it consistent with Record Center). Also, the system should prevent metadata changes of record link in Document Center.

The ability to move documents on hold should be restricted to Record Administrators.
Custom feature to restrict record link and hold records movement.

1
Create a new   version of an in place record / record in record center / record link/ record on hold
SharePoint allows users with “contribute access” to edit all metadata fields. However, only selected metadata fields should be editable based on the logged-in user’s role and status of the record.

Updation of metadata (like dates) should recalculate the information management processing dates.
Custom feature to restrict updation of critical metadata / record content by applying field level locking based on the following parameters
                        i.      Permission Level of the user
                      ii.      Stage of document (record, hold)

0
Upload a new   version of an in place record / record in record center / record link/ record on hold
SharePoint allows users with “contribute access” to replace both in-place records and record links with a new version. This should not be allowed.
Custom feature to prevent in place, record link updation with a new version of document.
Custom component to
                        i.      Prevent metadata updation of a record link
Propagate metadata changes to record links in document center, whenever metadata values of the linked record have been changed.

0
Modify an in place record / record in record center   / record link/ record on hold metadata
SharePoint allows users with “contribute access” to edit all metadata fields. However, only selected metadata fields should be editable based on the logged-in user’s role and status of the record.

Updation of metadata (like dates) should recalculate the information management processing dates.
Custom feature to restrict updation of critical metadata / record content by applying field level locking based on the following parameters
                        i.      Permission Level of the user
Stage of document (record, hold)

0
Email an in place record / record in record center / record link/ record on hold
When we send link to record by attaching it with an email, it should attach the actual record, not the link file.
Custom feature that attaches record with an e-mail when user tries to send a link to record from document center.

4
Apply information management policies
Allow information management policies to process metadata and perform associated actions including record declaration
NA

5
Apply information security by setting up permissions for the library
For certain record types, System must ensure item level permission setting on upload 
Custom code component to apply item level permission while uploading a document.

4.5
Generate File   Plan Report
SharePoint 2010s out-of-the-box file plan report is not sufficient to address user needs. A custom implementation to display hierarchical report of taxonomy with record retention details is recommended. 
Custom Hierarchical file plan report that displays:
                        i.      Site information organization (Site Collections>Sites>Libraries>Folders>Content Type)
                      ii.      Record retention details (Libraries>Content Types)

1
Generate Records Audit Report
Out of the box report neither satisfy specify user requirements nor compliant with data sensitivity guideline.  Requires custom code components on top of the log data to make it usable.
Custom audit log report that can perform search SharePoint audit log data and present info related to:
                        i.      User actions
                      ii.      Action during a period
                    iii.      Specific actions (like delete)
                    iv.      Failed attempts [optional]"

1
Find a record  
It is recommended to use FAST 2010 for search   integration.
Custom options to distinguish records, information on hold within search results.

3.5
Find an in place record / record in record center / record link/ record on hold
Search results do not distinguish in-place records from documents. There should be some mechanism to distinguish type of documents and records.
Option to filter search results based on the type of item (document / in-place record / hold / record link).

3.5
Bottomline:  SharePoint 2010 records management policies would be suited for a small enterprise with a limited number of record types and less repositories and have a straight forward business process to manage info.

No comments:

Post a Comment