Skip to main content

Personnel Security


Personnel Security: Managing Clearances, Investigations, and Access in Government

The Personnel Security module provides a comprehensive data model for managing the people, processes, and events that make up a federal agency’s security program. In government, safeguarding facilities, information, and systems depends on far more than issuing badges—it requires a coordinated set of checks, investigations, clearances, and ongoing monitoring. This module captures those activities in a consistent, auditable structure that can be used on its own or integrated with other government data models.

The foundation of the module is the Person table, which represents employees, contractors, visitors, or other individuals subject to security vetting. People can be linked to Organization Units and Location records, establishing where they work, what office they belong to, and where they need access. From there, the model branches into the many security processes that agencies manage.

Personnel Background Investigation and Personnel Adjudication tables record the investigative work and subsequent determinations that form the basis for trust. Personnel Clearance tracks clearance levels over time, including adjudication dates, granting authority, and expiration. These records can be tied to specific duties or systems, enabling agencies to enforce access rules and reporting requirements.

The module also supports the operational side of security access. Personnel Badge Request and Personnel Physical Credential track requests for, and issuance of, physical access devices such as ID cards or smart credentials, including status and return history. Personnel Visitor Request extends that capability to one-time or recurring visitors, recording the details needed for pre-approval and site access coordination.

Security risk monitoring is embedded into the model through event tracking. Personnel Reportable Life Event provides a structured way to capture significant changes—such as financial distress, arrests, or foreign associations—that may require re-evaluation of a person’s eligibility for clearance. Personnel Foreign Contact and Personnel Foreign Travel go deeper into counterintelligence concerns, allowing agencies to log declared contacts and trips that might present a security risk. Personnel CV Trigger acts as a catch-all mechanism to flag any condition or notification that should prompt a case review, investigation, or administrative action.

Finally, Personnel Passport keeps records of passports issued, controlled, or monitored by the agency, a necessity in organizations that sponsor official travel or manage sensitive assignments abroad.

In practice, this module brings together all of these elements into a unified view of an individual’s security profile. For example, in an insider threat program, an analyst could see at a glance a person’s clearance status, most recent adjudication, badge activity, foreign travel history, and any recent reportable life events. In visitor management, a security office could approve access based on active badge requests, linked organization units, and clearance verification.

By consolidating personnel security data into a single, extensible model, agencies can improve situational awareness, ensure compliance with federal security directives, and streamline the administrative burden of managing clearances and access. The Personnel Security module is not just a repository of records—it is an operational tool for protecting people, facilities, and the mission.

Entity Relationship Diagram

graph TD
  Contact(Person)
  govcdm_Location(Location)
  govcdm_organizationunit(Organization Unit)
  govcdm_PersonnelAdjudication(Personnel Adjudication)
  govcdm_PersonnelBackgroundInvestigation(Personnel Background Investigation)
  govcdm_PersonnelBadgeRequest(Personnel Badge Request)
  govcdm_PersonnelForeignContact(Personnel Foreign Contact)
  govcdm_PersonnelForeignTravel(Personnel Foreign Travel)
  govcdm_PersonnelPassport(Personnel Passport)
  govcdm_PersonnelPhysicalCredential(Personnel Physical Credential)
  govcdm_PersonnelReportableLifeEvent(Personnel Reportable Life Event)
  govcdm_PersonnelVisitorRequest(Personnel Visitor Request)
  govcdm_PersonnelAdjudication --> Contact
  govcdm_PersonnelBackgroundInvestigation --> Contact
  govcdm_PersonnelForeignContact --> Contact
  govcdm_PersonnelForeignTravel --> Contact
  govcdm_PersonnelPhysicalCredential --> Contact
  govcdm_PersonnelPhysicalCredential --> Contact
  govcdm_PersonnelPhysicalCredential --> Contact
  govcdm_PersonnelPhysicalCredential --> Contact
  govcdm_PersonnelReportableLifeEvent --> Contact
  govcdm_PersonnelVisitorRequest --> Contact
  govcdm_PersonnelPhysicalCredential --> govcdm_Location
  govcdm_PersonnelPhysicalCredential --> govcdm_organizationunit
  govcdm_PersonnelBackgroundInvestigation --> govcdm_PersonnelAdjudication

Requirements

Install the latest managed version of Government Data Models - Core first.

Next, install the latest managed version of Government Data Models - Process and Tasking.

Person

Metadata

  • Schema: Contact

Custom Fields

Location

Metadata

  • Schema: govcdm_Location

Custom Fields

Organization Unit

Metadata

  • Schema: govcdm_organizationunit

Custom Fields

Personnel Adjudication

Metadata

  • Schema: govcdm_PersonnelAdjudication

Custom Fields

  • Name
    • Type: Nvarchar
    • Schema: govcdm_Name
  • Personnel Adjudication Type
    • Type: Picklist
    • Schema: govcdm_PersonnelAdjudicationType
  • Subject
    • Type: Lookup
    • Schema: govcdm_Subject

Personnel Background Investigation

Metadata

  • Schema: govcdm_PersonnelBackgroundInvestigation

Custom Fields

  • Name
    • Type: Nvarchar
    • Schema: govcdm_Name
  • Person
    • Type: Lookup
    • Schema: govcdm_Person
  • Personnel Adjudication
    • Type: Lookup
    • Schema: govcdm_PersonnelAdjudication

Personnel Badge Request

Metadata

  • Schema: govcdm_PersonnelBadgeRequest

Custom Fields

  • Name
    • Type: Nvarchar
    • Schema: govcdm_Name

Personnel Foreign Contact

Metadata

  • Schema: govcdm_PersonnelForeignContact

Custom Fields

  • Name
    • Type: Nvarchar
    • Schema: govcdm_Name
  • Person
    • Type: Lookup
    • Schema: govcdm_Person

Personnel Foreign Travel

Metadata

  • Schema: govcdm_PersonnelForeignTravel

Custom Fields

  • Name
    • Type: Nvarchar
    • Schema: govcdm_Name
  • Person
    • Type: Lookup
    • Schema: govcdm_Person

Personnel Passport

Metadata

  • Schema: govcdm_PersonnelPassport

Custom Fields

  • Name
    • Type: Nvarchar
    • Schema: govcdm_Name
  • Passport Type
    • Type: Picklist
    • Schema: govcdm_PassportType

Personnel Physical Credential

Metadata

  • Schema: govcdm_PersonnelPhysicalCredential

Custom Fields

  • Actual Return Date
    • Type: Datetime
    • Schema: govcdm_ActualReturnDate
  • Approved Date
    • Type: Datetime
    • Schema: govcdm_ApprovedDate
  • Expected Return Date
    • Type: Datetime
    • Schema: govcdm_ExpectedReturnDate
  • Expiration Date
    • Type: Datetime
    • Schema: govcdm_ExpirationDate
  • Issued By Organization Unit
    • Type: Lookup
    • Schema: govcdm_IssuedByOrganizationUnit
  • Issued By Person
    • Type: Lookup
    • Schema: govcdm_IssuedByPerson
  • Issued Date
    • Type: Datetime
    • Schema: govcdm_IssuedDate
  • Justification
    • Type: Ntext
    • Schema: govcdm_Justification
  • Location Issued
    • Type: Lookup
    • Schema: govcdm_LocationIssued
  • Name
    • Type: Nvarchar
    • Schema: govcdm_Name
  • Person
    • Type: Lookup
    • Schema: govcdm_Person
  • Physical Credential Type
    • Type: Picklist
    • Schema: govcdm_PhysicalCredentialType
  • Request Date
    • Type: Datetime
    • Schema: govcdm_RequestDate
  • Requested By
    • Type: Lookup
    • Schema: govcdm_RequestedBy
  • Returned To
    • Type: Lookup
    • Schema: govcdm_ReturnedTo

Personnel Reportable Life Event

Metadata

  • Schema: govcdm_PersonnelReportableLifeEvent

Custom Fields

  • Name
    • Type: Nvarchar
    • Schema: govcdm_Name
  • Person
    • Type: Lookup
    • Schema: govcdm_Person

Personnel Visitor Request

Metadata

  • Schema: govcdm_PersonnelVisitorRequest

Custom Fields

  • Name
    • Type: Nvarchar
    • Schema: govcdm_Name
  • Person
    • Type: Lookup
    • Schema: govcdm_Person
We highly recommend using the managed versions, which will allow you to easily update and uninstall the solution from your environment. If you need to modify or enhance the managed solution, you can can create a new solution, add the components to that solution and make changes as needed.

Gov Personnel Security Data Model v1.0.0.2

Adds Expected Return Date, Actual Return Date, and a 'Returned To' lookup to Person on the Personnel Physical Credentials

Download Latest Release

Requires data models

Related use cases

Personas

Related app starter kits

This is an open-source project maintained by Microsoft. It is not an official U.S. government website. The site uses the U.S. Web Design System (USWDS) to help agencies and partners create app catalog documentation sites of their own. Open Source at Microsoft