Introduction
This article outlines the process for exporting data representing asset ownership. It includes a detailed description of the data columns present in the export.
Data structure
The export presents a detailed breakdown of all assets, divided into the smallest units with identical values. For instance, an award with a four-year annual vesting schedule will appear as four separate entries. If the same award has a monthly frequency (vesting schedule over three years with a one-year cliff), it will be represented by 37 entries—one for the cliff and 36 for the monthly vesting.
Data columns
Asset Information
Asset Type: Identifies the asset type (e.g., Phantom Share, Option, Share).
Plan Name: The name of the ESOP plan.
Pool Name: The name of the pool associated with the plan.
Asset Issued At: The issuance date of the asset. New assets are issued due to various reasons, such as investments.
Asset Count: The number of assets in this segment.
Asset Value at Grant: The value of a single asset at the grant date.
Asset Initial Value / Exercise Price: For Phantom plans, the initial value; for others, the exercise price of one asset.
Asset Number From: The starting number of assets in this segment, if applicable.
Asset Number To: The ending number of assets in this segment, if applicable.
Processes (Ownership) Information
Ownership Start Date: The date when ownership begins for the participant, often aligning with the vesting start date.
Ownership Start Process: Indicates the process initiating ownership (AW for award or EX for exercise).
Ownership Start Schema Name: The schema name used at the start of ownership.
Last Signature Date: The date when the last signature was obtained.
Note: Any notes added by the operator for custom awards.
Vesting Start Date: The commencement date of time-based vesting.
Vesting End Date: The conclusion of the vesting period, at the end of the day (23:59:59).
Entitlement Date: The date when full rights to asset ownership are acquired, typically the day after vesting ends.
Ownership End Date: The date when the participant's ownership ends, if applicable.
Ownership End Process: The process ending asset ownership (TE for termination, BU for buyback, or EX for exercise).
Ownership End Schema Name: The schema name used at the end of ownership.
Participant Information
Full Name: The participant's full name.
Work Email: The participant's primary work email.
Personal Email: The participant's secondary email, used for communication post-termination.
Birth Date: The participant's date of birth.
Address: The full address of the participant.
Custom Fields: Additional custom fields related to the participant, appearing after the address in separate columns.