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 breaks down all assets into their smallest units with matching values. For example, a four-year annual vesting award displays as four entries, while a three-year monthly vesting schedule with a one-year cliff shows as 37 separate entries.
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.
Related articles
- Eldison Glossary
- Understanding vesting
- Award process
- Process Schemas
- Calculating Phantom Plan Portfolio Value
