Employee Stock Plans Interface

Recommendation, 2007 April 15

Editors:

Bill Kerr, Oracle Corporation

Authors:

Daniela Goerke, SAP AG

Andreas Bold, SAP AG

Bill Kerr, Oracle Corporation

Nancy Mesereau, Transcentive

Dave Griffin, Transcentive

Evelyn Fuchs, Authoria

Peter Howells, Howells Associates

Martin Blaschek, Commerzbank

Contributors:

Members of Employee Stock Plans workgroup

 

Copyright © 2007 HR-XML Consortium, Inc.

 

Abstract

The HR-XML Employee Share Plans Workgroup has produced a simple, flexible definition of the elements required to exchange data related to the administration of employee share plans.  This document describes those elements, their expect usage, and the business processes meant to be supported.

 

 

Table of Contents

1      Overview.. 4

1.1       Objective. 4

1.1.1     Domain Issues. 4

1.1.2     Business Reasons. 4

1.2       Design Requirements. 4

1.3       Scope. 4

1.3.1     Major Components. 4

1.3.2     Items Within the Design Scope. 6

1.3.3     Items Outside of Design Scope. 6

1.4       Definition of Roles. 6

1.5       Example Plan Types in Detail 7

1.5.1     US-Style Stock Option and Stock Purchase Plans. 7

1.5.2     UK Share Scheme types. 9

1.5.3     German Share Plans. 9

1.6       Common Employee Stock Plan Terminology. 10

2      Process Flow – Stock Options. 13

2.1       Introduction. 13

2.1.1     Overview Activity Diagram.. 13

2.2       Processes: Implement / Maintain Plan – Setup Plan – Setup Plan Reserves. 16

2.2.1     Users. 16

2.2.2     Business Goal and Process. 16

Blackout periods are also commonly defined in stock plans during which the exercise of options is not allowed.  While the blackout period may apply to all Participants, it may also only apply based on a Participant’s position in or relationship to the Company.   For example, Participants such as the owner, officers or directors of the Company with inside, non-public knowledge of the Company may be restricted from exercising options during certain periods, while other Participants may not. 16

2.3       Processes: Define / Maintain Participant Masterdata – Maintain Participant – Create Participant Account 17

2.3.1     Users. 17

2.3.2     Business Goal and Process. 17

2.3.3     Example. 17

2.4       Processes: Setup / Maintain Grants – Administer Grants – Register Grant 18

2.4.1     Users. 18

2.4.2     Business Goal and Process. 18

2.4.3     Example. 18

2.5       Process: Posting Participant Life Events Changes. 18

2.5.1     Users. 18

2.5.2     Business Goal and Process. 18

2.5.3     Example. 19

2.6       Processes:  Exercise. 19

2.6.1     Users. 19

2.6.2     Business Goals and Process. 19

2.6.3     Exercise. 19

3      Process Flow – Employee Stock Purchase Plans. 20

3.1       Processes: Implement / Maintain Stock Purchase Plan. 22

3.1.1     Users. 22

3.1.2     Business Goal and Process. 22

3.2       Processes: Define / Maintain Participant Masterdata – Maintain Participant – Create Participant Account 22

3.3       Processes: Employee Contributions, specifying and collecting. 23

3.3.1     Users. 23

3.3.2     Business Goal and Process. 23

3.4       Processes: Stock Purchase. 24

3.4.1     Users. 24

3.4.2     Business Goal and Process. 24

3.5       Processes: Employee Stock Sale. 25

3.5.1     Users. 25

3.5.2     Business Goal and Process. 25

4      Schema and Field Descriptions. 26

4.1       Schema: StockPlan. 26

4.1.1     Schema Diagram.. 27

4.1.2     Schema Elements Explained. 28

4.2       Schema:  StockPlanParticipant 32

4.2.1     Schema Diagram.. 32

4.2.2     Schema Elements Explained. 34

4.3       Schema:  Grant 37

4.3.1     Schema Diagram.. 38

4.3.2     Schema Elements Explained. 38

4.4       Schema: Exercise Request 42

4.4.1     Schema Diagram.. 42

4.4.2     Schema Elements Explained. 43

4.5       Schema: Exercise Confirmation. 45

4.5.1     Schema Diagram.. 45

4.5.2     Schema Elements Explained. 47

4.6       Schema: Stock Deposit 50

4.6.1     Schema Diagram.. 50

4.6.2     Schema Elements Explained. 50

4.7       Schema: Stock Sale Confirmation. 53

4.7.1     Schema Diagram.. 53

4.7.2     Schema Elements Explained. 53

4.8       Schema: RemoveStockPlans. 56

4.8.1     Schema Diagram.. 56

4.8.2     Schema Elements Explained. 56

4.9       Schema: RemoveStockPlanParticipants. 57

4.9.1     Schema Diagram.. 57

4.9.2     Schema Elements Explained. 57

4.10     Schema: RemoveGrants. 57

4.10.1       Schema Diagram.. 58

4.10.2       Schema Elements Explained. 58

4.11     Schema: RemoveExerciseRequests. 58

4.11.1       Schema Diagram.. 58

4.11.2       Schema Elements Explained. 58

4.12     Schema: RemoveExerciseConfirmations. 59

4.12.1       Schema Diagram.. 59

4.12.2       Schema Elements Explained. 59

4.13     Schema: RemoveStockDeposits. 59

4.13.1       Schema Diagram.. 59

4.13.2       Schema Elements Explained. 59

4.14     Schema: RemoveStockSaleConfirmations. 60

4.14.1       Schema Diagram.. 60

4.14.2       Schema Elements Explained. 60

5      Implementation Considerations. 60

6      Issues List 60

7      Appendix A - Document Version History. 61

8      Appendix B – Related Documents. 61

9      Appendix C – Reference Examples. 62

9.1       German Example. 62

9.1.1     Example for StockPlan. 62

9.1.2     Example for StockPlanParticipant 63

9.1.3     Example for Grant 64

9.1.4     Example for ExerciseRequest 65

9.1.5     Example for ExerciseConfirmation. 65

9.1.6     Example for RemoveStockPlans. 66

9.1.7     Example for RemoveStockPlanParticipants. 66

9.1.8     Example for RemoveGrants. 66

9.1.9     Example for RemoveExerciseRequests. 67

9.1.10       Example for RemoveExerciseConfirmations. 67

9.2       US Examples. 67

9.2.1     Example for Stock Plan. 67

9.2.2     Example for StockPlanParticipant 68

9.2.3     Example for Grant 69

9.2.4     Example for ExerciseRequest 69

9.2.5     Example for ExerciseConfirmation. 70

9.3       Stock Purchase Examples. 71

9.3.1     Stock Plan Plan. 71

9.3.2     Stock Plan Participant 72

9.3.3     Stock Deposit 73

9.3.4     Employee Stock SaleConfirmation. 73

 


1         Overview

1.1        Objective

This specification is intended to support data interchange for Stock Option programs and Employee Stock Purchase Plans (ESPP).  Extensive use is made of other schema defined by the Payroll work group to enable the transfer of deduction instructions and a record of the actual values deducted from payroll.  The enrollment schema has also been extended into order to contain ESPP enrollments.  The standard is defined as global in scope and incorporates the ability to include country specific extensions.

1.1.1        Domain Issues

The use of equity compensation plans, also known as stock plans, has grown widely around the world in recent years, with stock plans growing in number and complexity.  Differing jurisdictional compliance requirements—tax, legal, accounting—pose special challenges for global plans.  At the same time, advances in web technology permit access to and transfer of stock plan data by employees, stock plan administrators, brokers, bankers, transfer agents, and many other players involved in stock plan management.  This widespread need for movement of and access to stock plan data has driven a need for technology standards for defining stock plan data.

1.1.2        Business Reasons

An industry standard vocabulary to describe employee share plan transactions provides the means for all stakeholders to send and receive such transmissions to/from multiple sources without having to establish, engineer, and implement many separate translation mechanisms.  The ability to quickly and cost effectively accept data from new sources allows the efficiencies promised by the Internet and its applications to be realized. [examples – speed with regard to volatility of stock price, real time modeling and transactions]

1.2        Design Requirements

The final design will be flexible enough to exchange employee stock plan data in a manner suitable for use by all the involved parties.  The design will be broad enough to be used globally, and will contain the elements required to express a wide variety of share plan transactions.

 

1.3        Scope

The scope of the project is to define an interface that can be used between an employer, the plan administrator and a broker to exchange stock option and ESPP data. To attract and retain employees, many employers offer employee stock plans.  These plans reward their employees with stock options and offer employees the opportunity to purchase stock at a favorable price through an ESPP.

1.3.1        Major Components

Seven major schemas to describe the data exchange between all players involved in the process have been defined.  In addition the Enrollment schema has been updated to pass information about participant enrolled into an ESPP scheme.  The schema and their indicated usage for Stock Options and ESPP are as follows:

 

Schema

Stock Option

ESPP

Stock Workgroup Schema

Stock Plan

Yes

Yes

Yes

StockPlanParticipant

Yes

Yes

Yes

Grant

Yes

No

Yes

ExerciseRequest

Yes

No

Yes

ExerciseConfirmation

Yes

No

Yes

StockDeposit

No

Yes

Yes

StockSaleConfirmation

No

Yes

Yes

Enrollment

No

Yes

No

PayrollInstructions

No

Yes

No

PayrollBenefit Contributions

No

Yes

No

 

In addition schemas to delete data, which has already been sent, have also been defined. The schemas are:

 

Schema

Stock Option

Stock Purchase

RemoveStockPlan

Yes

Yes

RemoveStockPlanParticipant

Yes

Yes

RemoveGrant

Yes

No

RemoveExerciseRequest

Yes

No

RemoveExerciseConfirmation

Yes

No

RemoveStockDeposit

No

Yes

StockSaleConfirmation

No

Yes

 

1.3.2        Items Within the Design Scope

The scope of this document includes only elements and attributes for data exchanged in the administration of and transactions associated with employee stock option plans.  (Please see section 3.2 for a complete description of elements and attributes) and Employee Stock Purchase Plans

1.3.3        Items Outside of Design Scope

1)       Communication of plan rules (eligibility, status changes)
Rules can be very complex and may vary considerably from plan to plan and within different legal and tax jurisdictions. Therefore the schema described here do not contain the rules themselves but simply the data.  It is assumed that the stakeholders in the stock plan administration process will apply and act upon the appropriate rules as needed following the exchange of data. However some simple rules such as blackout information are included.

2)       Exchange of Company data
A separate workgroup within the HR-XML Consortium has been initiated to define a common schema for company data. We would like to make use of this schema once it is completed. Therefore we decided not to define a Company schema within the stock workgroup.

3)       Support of plans containing different underlying stock
Currently, plans with more than one underlying stock, e.g. a company issues in a year the same number of options for ordinary shares and preferred shares, are not able to be supported.  When exercising, the participant must also exercise the equal number of ordinary shares and preferred shares.

1.4        Definition of Roles

The roles related to the operation of employee stock plans are:

Company: The organization responsible for sponsoring the employee stock plan and whose shares are offered through the plan.  Each individual company’s plan has its own rules for the issuance and administration of stock options. 

Administrator: The organization responsible for maintaining plan data, facilitating transactions, and enforcing plan rules.  The role of the Administrator can be held by the Company, the Broker, or a third-party.

Participant:  An individual, usually an employee of the Company but sometimes possibly an outside consultant, board member, independent contractor or a beneficiary - who stands to become an equity owner or otherwise benefit financially through plan participation. 

Payroll: The organization responsible for process the payroll of the company

Broker: A company that buys or sells securities on behalf of the Participant or Company

Transfer Agent:  An institution selected by the Company to issue and transfer share certificates that represent ownership in the company. 

Trustee: An institution selected by the Company to hold the shares reserved for issuance through the stock plan.

In many cases one business entity represents several roles, e.g. Administrator and Broker are very often combined and performed by a Bank.

1.5        Example Plan Types in Detail

1.5.1        US-Style Stock Option and Stock Purchase Plans

Stock Options

§         Incentive Stock Option (ISO) - Qualified grant type typically used in broad-based plans by US-based companies.  Qualified stock options can only be awarded to employees of the company.  Stock options that meet US Internal Revenue Code Section 422(b) requirements qualify for preferential tax treatment (per US Internal Revenue Code Section 421).  Employees are not taxed at the time of grant or exercise.  Taxation occurs at disposition and varies based on holding period.  Preferential tax treatment is available if shares are not disposed of prior to the required holding periods (one year from date of exercise and two years from date of grant) being satisfied.  If holding periods are met, all gain over exercise price is taxed at the more favorable capital gains rate.  If shares are disposed of prior to the end of the required holding period, a “disqualifying disposition” occurs and the gain is taxed at the less favorable ordinary income tax rate.  Subsequent gains (losses) are taxed as capital gains (losses).  Employer may take a deduction equal to the amount of the disqualifying disposition.  Employer is not required to withhold income taxes on ISOs, even in the event of a disqualifying disposition. (Proposed changes to the withholding requirements on ISOs are being debated; the discussion is ongoing).   ISO $100K rule:  No more than $100,000 (valued at grant) of ISO shares becoming exercisable in a single calendar year may receive preferential tax treatment.  ISO shares exceeding this limit will be taxed as NQSO shares (see below).

 

§         Non-Qualified Stock Option (NQ or NQSO) - Typically used in broad-based plans.  Generic stock option with no preferential tax treatment or limits on grant.  May be issued to employees and non-employees (consultants, directors and other service providers). No taxation at the time of grant.  The spread between exercise price and fair market value on the date of exercise is taxed as ordinary income.  Employer must withhold taxes. Subsequent gains (losses) are treated as capital gains (losses). Employer may be able to take tax deduction on the spread.

 

§         Restricted Stock Option - A stock option for shares whereby upon exercise, the participant receives unvested shares and is restricted from transferring or selling the shares until the shares vest (usually according to a time-based vesting schedule). Taxation occurs at vesting (when restrictions “lapse”) on the spread between option price and fair market value on the date of vesting or on the spread at exercise if an 83b election (per Section 83b of the IRS code) is filed within 30 days of exercise.  “Early exercise” programs (common in high-tech industries) in the US typically permit immediate exercise of unvested ISO or NQSO shares, enabling participants to file an 83b election and fix the tax on the spread at exercise rather than the spread at the time the shares vest.  Participant forfeits unvested shares at the time employment is terminated.  Shares are held in escrow until they vest.

 

§         Restricted Stock Award - An outright issuance to the participant of restricted shares, usually at zero price or at a significant discount to fair market value.  Shares are held in escrow until they vest.  The vesting event is often performance-related—a certain share price or other performance trigger is reached.  Taxation is the same as for restricted options—on the spread between exercise price and fair market value at the time the restrictions lapse or at the time of exercise if an 83b election is filed.  In the past, restricted stock awards were typically limited to executives, but many US-based companies are broadening their use of restricted awards and options, as they are seen as being more of a true performance-based incentive than other types of equity compensation.

 

An award paid in cash or shares that gives the employee the appreciation on the stock from the time of award to the exercise date. When granted in tandem with options, the exercise of the stock-appreciation right cancels the option.  Stock appreciation rights are similar to phantom stock options.  Types of SAR plans are:

§         Phantom Stock/Performance Units - Similar to SARs in that they provide deferred or incentive compensation to employees.  A share or unit of phantom stock is equal to the fair market value of a share of the company’s common stock or to a value derived using a valuation method.  Payments of phantom stock are usually made at termination of employment, attainment of a certain age by the participant, or after a fixed term of years.  Payment to the participant may be the full value of the phantom stock or the amount of appreciation that occurs after the employee receives the phantom stock right.  Phantom stocks plans vary widely in their terms.

 

Stock Purchase Plans

ESPP $25K rule:  No more than $25,000 (valued at the beginning of the offering period) of shares may be purchased by a single employee for each calendar year in which the option to purchase is outstanding. 

 

1.5.2        UK Share Scheme types

 

Approved - In the UK a number of plans – if approved by the Inland Revenue as meeting strict legislated conditions – enjoy tax relief.

 

Unapproved - Frequently schemes are set up for executives which are not approved by the Revenue and thus carry no income tax relief. The Approved/Unapproved distinction is a similar concept in some ways to the ISO and NQ status in the US. (Occasionally, but rarely, there are unapproved all employee schemes).

§         ESOS. Typically a more generous grant of options than under the approved version, or with options granted to non-UK residents.

 

1.5.3        German Share Plans

Stock Option Plans:

o        Current option plans often involve performance hurdles that have to be met, in order for the participant to exercise options. Performance hurdles can be a rise in share price, the out performance of indices or other shares, internal scores or any combination. Before exercising options, the participant has to hold the options for at least two years. The typical runtime for options plans is 6-8 years.  The necessary shares are either bought back by the emitting company or are created through what is called a “conditional raise of capital” (bedingte Kapitalerhöhung). In the later case, options cannot be sold immediately but must be paid for by the participant before they are sold. A cashless exercise is often impossible since most stock option plans use the conditional capital raise as an instrument for generating shares. Sometimes, the participant has to make an investment in company shares in order to receive company shares. Some companies allow Cash Settlement where the participant receives money instead of shares.

o        Convertible Bonds are a special type of option plans. The difference is that convertible bonds can be can be traded. However the share price (grant price) must be reduced.

Phantom Stock Plans

Employee Shares (Belegschaftsaktien)

o        Employee Shares are typical offered to a wider group of employees. The employee buys a certain number of shares at a discount rate or receives shares for free when buying company stock. For taxation reasons, employee shares are usually blocked for a certain time.

Employee Shares + Quarterly Fonds-Plan:

o        The employee buys a certain number of shares once a year. Some high level employees might be allowed to invest quarterly in special fonds. If the investment exceed a certain amount, the participant receives a specified number of shares.

1.6        Common Employee Stock Plan Terminology

The following terms are typical for the US and the UK.  Specific terms to a country will be identified accordingly.

Capital Gain (Loss):  Profit (or loss) from the sale of a capital asset, such as a share of stock. In the US, capital gains may be short-term (held 12 months or less) or long-term (held more than 12 months). Capital losses are used to offset capital gains to establish a net position for tax purposes.

Cashless Exercise:  Generally the same as a same-day sale. A transaction in which an optionee exercises a stock option and simultaneously sells the shares, with all or a portion of the sale proceeds delivered to the Company by a broker to pay the exercise price. The balance goes to the optionee.  See also “Same-Day Sale.”

Commission:  A broker’s fee for handling securities transactions for a client in an agency capacity.

Common Stock:  Securities which represent an ownership interest in the Company.

Confirmation of Exercise:  A statement containing details relating to the exercise of a stock option. The Administrator gives this statement to the optionee at the time of exercise. The optionee should retain it for tax purposes.

Cost to Exercise:  The amount a participant or option holder must pay to exercise a stock option.  

Disqualifying Disposition:  (Incentive Stock Option) A sale or disposition of ISO shares prior to the required holding period of two years from the grant date or one year from the exercise date, thereby disqualifying the resulting gain from special tax treatment under US law. Upon a disqualifying disposition, the employee recognizes taxable income and the Company is entitled to claim a deduction equal to the difference between the option price and the fair market value on the exercise date or sale price, whichever is lower. See Incentive Stock Option below.

ESPP:  Employee Stock Purchase Plans.  See terminology for Stock Purchase Plans. 

Exercise:  A transaction in which the participant or optionee exercises the option to purchase Company stock. 

Exercise Date:  The date on which the option is excercised

Expiration Date:  In the context of stock options, the last date on which the participant may exercise the option to purchase shares.

Employee Share:  (Germany “Belegschaftsaktie”) Stock given to the employee at a discounted price. Employee shares are used to allow employees to participate on their employer’s profit or loss. Employee Shares are typically locked for a certain number of years before they can be sold.

Fair Market Value(FMV):  The price at which the stock would change hands between a willing buyer and a willing seller.  For purposes of an employee stock plan, this is usually the closing price if the stock is traded on a major exchange, or the average of the bid and ask price if the stock is traded over-the-counter.  For privately held corporations, FMV is typically based upon an independent appraisal.

Gain:  The excess of the proceeds received over the amount originally paid for securities.  In the context of an employee stock option, it is the difference between the option price and the fair market value or sale price of shares of stock of the company acquired upon exercise of a stock option on the date of exercise. 

Grant:  The award to an individual of an option to purchase Company stock.

Grant Date:  The date on which a stock option is granted.

Incentive Stock Option (ISO):  Mainly used in the US.  An option that meets the IRS Section 422 requirements and qualifies for preferential tax treatment under Section 421.  An ISO does not give rise to US Federal income tax consequences for the employee either at the time of grant or at exercise.  Instead, the employee is subject to taxation at the time the shares acquired through exercise are subsequently disposed.  If the shares exercised are held for one year from the date of exercise and two years from the date of grant, they qualify for special tax treatment. If the shares are sold before the required holding periods a disqualifying disposition occurs and the special tax treatment will not apply.

Insider:  A person who, by virtue of his or her position within a company, has access to confidential information.  The term “insider” is often used to denote officers, directors or principal stockholders of a publicly owned company and members of their immediate family. In the US, the term is also used to describe persons subject to Section 16 of the Securities Exchange Act of 1934.

NASD:  National Association of Securities Dealers – A US organization comprised of brokers and dealers engaged in over-the-counter securities trading.  The NASD is subject to the Securities Exchange Act of 1934.

NASDAQ:  National Association of Securities Dealers Automated Quotations System – The world’s largest computerized quotations network by which NASD members can communicate their bids and offers. Today, NASDAQ lists the securities of nearly 4,100 of the world's leading companies.

Non-Qualified Stock Option NSO):  ( Mainly used in the US.  Unlike an ISO, an NSO option does not qualify for special tax treatment and triggers a federal income tax liability on the date of exercise.  With these options, the Company requires the withholding of taxes based on the difference between the option price and the FMV on the date of exercise (actual sales price instead of the FMV for same-day sales). The Company reports the gain and the taxes withheld on the employee's W-2.

Option Agreement:  The document signed by the optionee and an officer of the Company which specifies the terms and conditions under which an option is granted.

Option Exercise Notice:  Form completed by the optionee to notify the Company of the optionee’s desire to exercise his/her right to purchase a specified number of securities at the exercise price set by the Company.

Option Price:  The price at which the shares of stock subject to an employee stock plan may be purchased, pursuant to the terms of an employee stock option agreement.  Also called “exercise price” or “grant price.”   The option price is typically expressed on a per-share basis. 

Optionee:  The individual granted a right to purchase shares of the Company’s Common Stock.  See also “Participant.”

Participant:  A participant in the employee stock plan.  Often referred to as an “optionee.”

Phantom Stock:  Also called “Shadow Stock”.  Under a typical Phantom Stock arrangement, a plan participant would receive a benefit equal to the value of a designated number of company shares on a certain date, not just the appreciation over a specified period.  In all other regards, Phantom Stock is treated the same as SARs.

Proceeds, Net:  (US) The amount of money remitted to the optionee following payment of all costs associated with a transaction.  Costs might include the price to purchase shares, taxes paid, and fees and commissions.

Registration Statement:  (US) A disclosure document filed with the SEC to register shares of stock for sale to the public.

Same-Day Sale:  Refers to a same-day exercise and sale transaction, which an optionee would execute with the assistance of a broker. In a same-day exercise and sale, the exercise of the option and sale of the underlying shares take place simultaneously. The broker uses the proceeds of the sale to pay to the company the exercise price and any tax withholding and the optionee the net cash (less any brokerage commission / fees). See also “Cashless Exercise.”

SEC:  Securities and Exchange Commission - The US government agency responsible for the supervision and regulation of the securities industry and markets, as well as public securities offerings and the ongoing public disclosure obligations of public companies.

Stock Appreciation Rights:  Commonly called "SARs." Represents a right granted to an employee to receive a benefit equal to the appreciation in the value of a given number of shares over a specified period.  If the value of the stock declines below the issue/grant price of the SARs, the employee receives nothing.

Stock Option:  A contractual right granted by the Company, generally under a stock option plan, to purchase a specified number of shares of the Company’s stock at a specified price (the option or exercise price) for a specified period of time.

Stock Purchase Plan:  Stock purchase plans are plans whereby employees use their own funds to purchase employer stock at market price or a modest discount.  Employees usually (but not always) receive unrestricted rights to the stock at the time of payment.  In the US, these plans typically involve regular payroll deductions for employees electing to participate.  These funds are used to purchase shares either on the open market (using a broker) or directly from the issuing company.  The shares are held by the broker or other agent until withdrawn by the employee.  These plans often include provisions for reinvestment of dividends

in company stock. 

Stock Split:  A change in the capitalization of a company that increases or decreases (a decrease is also known as a reverse stock split)  the number of shares outstanding or shares subject to options, and adjusts the value of the shares and options accordingly.  For example, if an employee has options to purchase 50 shares at $10 per share and the Company has a 2 for 1 stock split, the employee thereafter has the option to purchase 100 shares at $5 per share.

Swap Exercise (or Stock Swap):  Also known as a "stock-for-stock" exercise.  A form of cashless exercise transaction in which shares of company stock already owned are delivered, either physically or by "attestation," in lieu of cash to pay for the exercise of stock options.

Transfer Agent:  An entity, often a division of a banking or other financial institution, that serves as the agent of a company responsible for keeping the official register of stockholders' names and the proper re-registration of new owners when a transfer of stock occurs. Most private and some public companies act as their own transfer agent.

Trustee:  An institution selected by the Company to hold the shares reserved for issuance through the stock plan.

Vesting:  The process of earning shares of stock granted under an employee stock plan; the process by which rights under an option become non-transferable or are no longer subject to a substantial risk of forfeiture.  Typically, shares vest when the participant satisfies one or more length-of-service or performance-based conditions.  In some option plans at private companies, participants may exercise unvested options subject to the company’s right to repurchase those shares.

Vesting Schedule:  Schedule of dates setting forth over what periods of time, and to what extent, options vest and become eligible for exercise or when restricted shares are released to the optionee.  A typical four-period vesting schedule might be 25% over four years.

2         Process Flow – Stock Options

2.1        Introduction

The Employee Share Plans Interface schemas support the exchange of employee stock option plan  and employee stock purchase plan data between the Company, Administrator, Participant, Broker, Transfer Agent and Trustee. Uses of the schema are described in detail separated into significant employee stock option transactions that occur regularly.  The process flow for employee stock purchase is described in the next chapter.

2.1.1        Overview Activity Diagram

The process diagrams below depict an overview of the employee stock option plan data exchange. 


Stock Option Setup

The diagrams show the interactions between the parties involved (Company, Administrator, Participant, Broker, Trustee, Transfer, Agent) to set up a stock option plan.


Stock Option Exercise or Sale

The diagram shows the interactions during the exercise process.

Please note that the broker and administrator may be one in the same and are broken out in separate schemas below to facilitate the transactions of those companies whose administrative and brokerage services are performed by two separate entities. It may also be the case that some other roles are being represented by one and the same person / entity or may not be represented at all.

 

 


 

2.2        Processes: Implement / Maintain Plan – Setup Plan – Setup Plan Reserves

This process is used to set up and maintain plan design data for stock options. Plan design information is sent as an initial one-time setup file for the plan and then on an as needed basis in order to maintain and update plan design changes.   Although stock purchase utilizes the same schema this is described in a separate process flow elsewhere in this document.

2.2.1        Users

The Company will most likely be the source of this information. The recipients of this information will be the Administrator, Broker, Transfer Agent and / or Broker.  The information might be received directly or be forwarded by the Administrator.

2.2.2        Business Goal and Process

The Company sends the Administrator and/or Broker all plan design information needed to set up and administer the plan correctly.  Transmitted Plan data must adhere to the Plan details defined and approved by the shareholders of the Company. The foundation of employee stock plan design is based on plan design below.

1.       All Plans have a formal, legal name under which they have been defined, e.g. Software Company LTI Plan 2002.  The Plan name may or may not include the name of the Company sponsoring the Plan.

  1. All Plans have an inception date, the date the Plan was established, and a Plan end date, the date on which the plan may be terminated. Plan Years generally span over one year although not necessarily a calendar year.
  2. Stock option plans are defined as a certain type such as an Incentive Stock Option Plan (ISO), a Nonqualified Stock Option Plan (NQSL), a Restricted Stock Plan, Stock Appreciation Rights Plan (SAR), etc.  The plan type determines, among other things, exercise restrictions and tax rules that apply to Participants and the sponsoring Company

Stock plan design includes many more variables that make each plan unique.  Very often, waiting periods apply before Participants can exercise their stock options. These waiting periods may begin on the date of the grant, or the Participant’s date of hire.  In addition, vesting rules are defined which determine the length of time the Participant must hold the options for a certain percentage to be vested.   Vesting also may vary based on the goal of the shares being granted – to serve as a long-term or a performance-based incentive.  Long-term incentives generally vest on an annual basis and often require the Participant to satisfy a waiting period before vesting begins.  Once the waiting period ends, options typically vest ratably.  Performance-based incentives vest when the underlying stock price reaches a specified price, although vesting based on other financial triggers are becoming much more common.  Vesting always occurs over months or years and as a percentage of shares granted.

Blackout periods are also commonly defined in stock plans during which the exercise of options is not allowed.  While the blackout period may apply to all Participants, it may also only apply based on a Participant’s position in or relationship to the Company.   For example, Participants such as the owner, officers or directors of the Company with inside, non-public knowledge of the Company may be restricted from exercising options during certain periods, while other Participants may not.

2.3        Processes: Define / Maintain Participant Masterdata – Maintain Participant – Create Participant Account

This process is used to create and maintain records of Participants of any Company stock plan.  Participant information is sent as an initial one-time setup file for the Participant and then on an as on-going or as needed basis to maintain and update Participant information. 

StockPlanParticipant is used for both Stock Option and Stock Purchase Plans.

Stock Option Specifics

In the event that a beneficiary inherits the stock options of a participant, a new account record will be set up and the beneficiary will be considered  a new participant.

2.3.1        Users

The Company will most likely be the source of this information.  The recipients of this information will be the Administrator, Broker and / or Trustee (stock options).

The information might be received directly or might be forwarded.

2.3.2        Business Goal and Process

Companies that maintain detailed stock plan data in their own Human Resources Information System including plan eligibility criteria, Plan design, and Participant information and grant data may interface directly with a broker.  Companies working with Brokers who provide full-service stock plan administration do not need to retain the services of a third-party stock Administrator.  Companies who use an administrator to maintain stock plan data notify the administrator of all Participant enrollments.  The administrator will then extract and transmit the Participant enrollment information to the broker.  In both instances, the broker will then set up stock accounts for each enrolled Participant. 

Data that uniquely identifies each Participant such as Participant name, Social Security Number or other identifier, residential address, date of hire or adjusted service date, and employment status must be sent.  The Participant’s taxation location and available tax rates may also be transmitted to assist with the calculation of tax liabilities upon the exercise of options.

The assumption is made that a company always sends only data of such persons who are eligible and / or have elected to participate.

2.3.3        Example

An example of this process would be the regular exchange of employee data between the Company and the Administrator.  This data is commonly sent each night and serves to update employee address, termination codes, or coding of officers, insiders, etc.

2.4        Processes: Setup / Maintain Grants – Administer Grants – Register Grant

2.4.1        Users

The Company is the likely source of this information.  Recipients include Administrators, Broker and / or Trustee.  The Participant will also be notified of any new or corrected grants issued and may be required to accept or reject the grant. 

2.4.2        Business Goal and Process

Outside of initial enrollment into the plan, the broker will most likely have already established stock accounts for each Participant enrolled in the stock plan by the time the Participant receives a grant of options.  If the Company and Broker have different arrangements, master Participant account information may be transmitted at the same time as new grant information to the Broker.

As existing Participants are granted additional options, the Company sends the grant information along with identifying Participant data to be posted to the Participant’s stock account maintained by the Administrator and/or Broker.  Some of the information that must be sent is a grant identifier, Participant identifier, grant id, grant date, and the number of options granted. Corrections to previously issued grants should be transmitted in the same way with any new information replacing existing information for the specified grant.

2.4.3        Example

An example of this process would be the regular granting of new stock options, typically done on an annual, semi-annual, quarterly, or monthly basis.  The data would flow from the Company to the Administrator and would describe the terms of the grant, such as vesting and expiration, and also

provide the identifier for each individual receiving a grant and the number of options granted.  For existing grants, grant maintenance would likely involve changes to the grant brought about by changes in the employee's status, such as a termination, or a result of a corporate event, such as a repricing or stock split.

2.5        Process: Posting Participant Life Events Changes

Life events will have an impact on Participant, Grant or Plan data which has already been sent. E.g. a company event might lead to the fact that a plan is being cancelled. In that case, updated Plan data needs to be sent. Participant events might trigger an update of Participant or Grant data.

2.5.1        Users

The source of the information would most likely be the company. The recipient can be the Administrator.

2.5.2        Business Goal and Process

A Participant who experiences a personal life event such as a change of address, marriage, divorce, disability, etc. notifies the Company who in turn notifies the Administrator and/or Broker of the change.  Employment-related events such as termination of employment, change of insider status, or change in tax rates will be transmitted directly from the Company to the Administrator and/or Broker. 

A partial Participant record will indicate a change of account information only.  Information that already exists in a Participant’s Administrative or Brokerage account will be replaced by the newest information transmitted by the Company.

Life event changes may be transmitted as frequently as the Company, Administrator and Broker have agreed upon or as needed to ensure accurate stock account information.

2.5.3        Example

An example of participant life event changes is the regular exchange of employee data that would effect the terms of the grant.  A common example would be an employee who terminates with some vested, and some unvested options.  Often the unvested options will need to be cancelled and the term of the vested options will need to change from the original expiration date to a date following the termination date, commonly either 30 or 90 days.

 

2.6        Processes:  Exercise

The ExerciseRequest schema is used to transmit all exercise instructions to the Broker so the Broker knows when and how to exercise the options. After the exercise the ExerciseConfirmation is sent back to the Administrator and / or Company.

2.6.1        Users

For the ExerciseRequest, the Participant or the Administrator would be the source of this information.  The Broker or Company will be the recipient.  Participants frequently give instructions to exercise options to the Administrator who then forwards them to the Broker, rather than to the Broker directly.

For the ExerciseConfirmation, the Broker would be the source of this information. The Administrator or Company would be the recipient.

2.6.2        Business Goals and Process

Participants deciding to exercise options notify the Administrator or Broker, depending on the Company’s arrangements.   If the Administrator takes the exercise instructions, they will forward those on to the Broker to carry out the transaction or to the Company for information purposes. 

After exercising the shares on behalf of the Participant, the Broker will notify the Company and/or Administrator of the gross proceeds of the trade in order to calculate the taxes to withhold.  Depending on the type of exercise – cash, cashless, swap, etc. – the proceeding transactions may vary.  Ultimately, the following information may pass between the Participant, Administrator, Broker, and Trustee:  number of shares to exercise/exercised, exercise price, fair market value (FMV) on the date of exercise, sales price (may differ from the FMV), taxes due/withheld, number of shares used to pay the taxes, and the amount of the taxable gain. 

2.6.3        Exercise

An example of the exercise process would be if the Company keeps the equity plan database and the Broker needs to report the exercises that occurred during a recent period.  This is a process that is commonly sent each night from the Broker and picked up at the Company in the morning.  The data

describes the type of exercise, detail of the grants involved, and the proceeds and applicable amount for processing of taxes.


3         Process Flow – Employee Stock Purchase Plans

Stock Purchase Setup

The diagrams show the interactions between the parties involved (Company, Payroll, Administrator, Participant and Broker) to set up an employee stock purchase plan (ESPP).

 

 

 

 

 


Stock Purchase Plan – Stock Purchase

The diagram shows the interactions during the purchase of stock associated to a stock purchase plan.

 

 

 

 

 

 

 

 

 

 

 

 

 


Stock Purchase Plan – Stock Sale

The diagram shows the interactions during the sale of stock acquired from a stock purchase plan.

 

 

 

 

 

 

 

 

 

 

 

 



3.1        Processes: Implement / Maintain Stock Purchase Plan

This process is used to set up and maintain plan design data for employee stock purchase plans.  The process is similar to that of stock option plans and utilizes the same schema.

3.1.1        Users

The Company will most likely be the source of this information. The recipients of this information will be the Administrator, Broker and possibly participant.  

3.1.2        Business Goal and Process

The Company sends the Administrator all plan design information needed to set up and administer the stock purchase plan correctly.   The Administrator may choose to pass this information to the Broker.

1.       All Plans have a formal, legal name under which they have been defined, e.g. Software Company ESPP Plan 2002.  The Plan name may or may not include the name of the Company sponsoring the Plan.

  1. All Plans have an inception date, the date the Plan was established, and details of the offering periods of the plan.   Multiple offering periods may be held.
  2. Due to the large number of variables in specifying ESPP the detail of rules for both contributions and stock purchase have not been defined.  Such rules can still be passed in the schema as text strings in two elements that have been provided for this, ContributionRulesDescription and PurchaseRulesDescription.

An ESPP allows the employee to purchase stock in their Company at a discounted price or if not at a discounted price then on a regular basis via payroll.  Typically, an employee enrolls into a plan prior to an offering period, makes regular contributions during the offering period (6 months being typical) at the end of which shares are purchased on behalf of the employee at a favorable rate.  For example, the rate can be based on the fair market value at the start or end of an offering period whichever s the lessor or can be based on the average price on selected trade date or dates.  Some plans permit concurrent enrollment in multiple, overlapping periods.  There are a number of rules relating to the taxable benefit, maximum contributions, rules on disposition, that can vary between jurisdictions.  Specific jurisdictional details are not covered within this specification.

The StockPlan schema contains an element, StockPurchaseInfo, which contains information specific to ESPP.  All other information regarding ESPP are held in the generic StockPlan elements.

Full ESPP data such as ability to exit the plan, discounts, rules on weak stock price are not held in detail on the plan except as free text format.  It would be impractical to try defining elements that can model every different type of plan that may be desired.  It is expected that such detail will be communicated to the plan administrator as a manual step.

3.2        Processes: Define / Maintain Participant Masterdata – Maintain Participant – Create Participant Account

This process is similar to that in for stock options, please review previous section for full details.

An additional element EmploymentInfo has been added which can be used to determine eligibility to a stock purchase plan.  This element holds data such as the FTE (Full Time Equivalence) of the person and the work time info which shows the normal amount of time worked in any given period.  Sometimes a person must either be full time or work more than a certain number of hours per week/period in order to participate in the Company ESPP.

It is possible that the company will send details of all employees to the administrator.  The information held about the participant enables the administrator to determine if an employee is eligible to participate in the Company ESPP.

When an employee enrolls into the plan the participant data may be sent to the broker at the point in time that the event occurred.    It is more likely however that the participants will be sent as a batch at an agreed point in time.  This is required to occur before submission of the stock purchase request as only participant identifiers are held within the purchase schema.

3.3        Processes: Employee Contributions, specifying and collecting

It is usual that the employee makes regular contributions from their salary when participating in ESPP.  The Administrator informs the payroll department the frequency, size and duration of such contributions.  Existing HR-XML Consortium schemas will be used for this purpose and are described below.

3.3.1        Users

This process for collecting and communicating collected amounts is usually between Payroll and the Administrator.  The participant may in addition request a change in contributions or withdrawal from the scheme.  This will either trigger a change in contributions or a refund. 

3.3.2        Business Goal and Process

Normally the administration of an ESPP requires that regular contributions are made by an employee, for example 10 % of earnings per pay period for 6 months, perhaps subject to certain limits.  The Administrator would use the Payroll Instructions schema to transmit the deduction information to the ESSP Company’s payroll provider.

This deduction information may be communicated to the Payroll prior to the start of the offering period or made be made prior to each payroll run.  Such implementation details are between the Administrator and the Payroll.  The Payroll Instructions schema 1_0 is used for this purpose.

This specification states “PayrollInstructions version 1.0 is intended to enable the submission of certain pre-payroll instructions for deductions and credit or benefits”.  Please review the Payroll Instructions schema documentation for implementation details.

Each time a payroll deduction is made the Payroll may communicate the value of the deduction back to the Administrator.  The reason for doing this is that if the contribution rule is 10% gross/net salary the Administrator will not know exactly much money was deducted from the payroll, yet may need to present this information on an ongoing basis to a participant via some form of self service portal.  The Payroll Benefit Contributions schema is used to communicate the amount of the deduction that the Payroll has made.  The total deductions made over a period of time (the offering period) may also be communicated to the Administrator from the Payroll using the same schema.   Please review the Payroll Benefit Contributions schema documentation for further implementation details.

Participant request change in ESPP Contributions

Depending upon the ESPP rules the participant  may be allowed to make occasional changes to the contributions amounts.   The participant makes a request to the Administrator possibly via some form of self service system.  This communication is outside the scope of this document.  The Administrator will use the Payroll Instructions schema to send the details to Payroll and in addition may communicate the change to the company via the enrolment schema.

Participant request withdrawal from ESPP

The ability for a participant to withdraw from a ESPP during an offering period and prior to an exercise date depends upon the specific rules of the plan.  These rule are not discussed within this document.  However, the likely effect is that the employee will be refunded his deductions paid to date for the current offering period.  The PayrollInstructions schema can be used to instruct the payroll administrator to refund the deductions back to the employee.  Such implementation details falls outside the scope of this document. 

Participant ceases employment

If the participant ceases to be employed this fact will be communicated to the Administrator using the StockPlanParticipant schema.  The ESPP rules will determine the action to be taken in this event.  If a refund of contribution is required the PayrollInstructions schema can be used to communicate this to the Payroll.  In some instances it will be too late to refund the contributions and the stock purchase will occur as normal.

Company elects not to purchase

In some instances (if the stock price is falling, for example) the Company may elect not to make a scheduled purchase for a given offering period.  Accrued contributions may be rolled forward or refunded, depending upon the rules of the plan.

3.4        Processes: Stock Purchase

At the end of the offering period stock is purchased on behalf of the participants.  Such a purchase is subject to the ESPP rules.

3.4.1        Users

The process flow is from the Administrator to the Broker.  There may be an additional flow from Payroll to the Administrator to indicated funds available for purchase.  Also the Administrator may advise the Company of the purchases made on its behalf.

3.4.2        Business Goal and Process

At the end of the offering period the total of the contributions will be added up for each employee to determine the funds available for stock purchase.  As described in Employee Contributions process the value of the available funds may be determined using the PayrollBenefitContributions schema. 

Once the total available funds for purchase is known the Administrator will apply the ESPP rules to determine the price and the amount of money that is available to purchase the shares.  There may be adjustments in the available amount due to surplus from previous offering periods or reduction in the amount used for purchase because it exceeds the plan threshold.  Such rules and polices fall outside the scope of this document.

The stock purchase is communicated to the broker via the StockDeposit schema.

The broker will usually inform the participant of the number of shares deposited on their behalf.  This flow is not subject to an hr-xml schema.  The broker will not normally communicate anything back to the company except for an acknowledgment to the StockDeposit request.

The Administrator may aggregate details of the stock purchase and send this to the Company via the StockDeposit schema.  This flow is not mandated and would be an implementation specific event.

In the event that less stock is purchased than the contributions would indicate the participant may be refunded the excess contributions.  Such a refund will be communicated to the Payroll via the PayrollInstructions schema and would depend upon the ESPP rules.

This specification does not determine how Payroll balances should be adjusted or the maintenance of rollover balances should the value of the stock purchased be different to the contribution amount.

3.5        Processes: Employee Stock Sale

The participant is free to deal in their stock direct with the Broker.  Such interaction is outside the scope of this document.  In certain legislations the Administrator may be informed of certain dispositions that take place.

3.5.1        Users

The participant deals direct with the broker in regards of any stock purchased from an ESPP.  The broker may inform the Administrator if a sale takes place within a holding period.

3.5.2        Business Goal and Process

In certain legislations, depending upon the ESPP plan type, if a participant makes a stock disposition within the holding period attributed to the original stock purchase, the broker may be obliged to inform the Administrator that a disqualifying deposition has taken place.  The broker can do this by implementing the StockSaleConfirmation schema.  Details of the participant, sale date, amount of stock sold, its price, a link to the original purchase identifier can be passed using this schema.

The Administrator may then inform the payroll administrator using the same schema.  The payroll administrator can then make an appropriate report, depending upon legislation, of such disqualifying dispositions.

It is possible in some instances for the plan administrator to offer a ESPP sales facility via an employee portal.  This issuance of such a stock sale instruction is outside the scope of this document.  It is likely that standards will be developed within the industry for typical stock sale instructions.

4         Schema and Field Descriptions

4.1        Schema: StockPlan

Used to create/maintain plan records for Stock Option/Stock Purchase Plans/Stock Awards.    Plan information would be sent as a one-time set-up file for the record and then as an on-going maintenance file to update plan information when appropriate.  The Company is the most likely source of this information.  Recipients include Plan Administrators, Brokers, and for stock options, Transfer Agents and Trustees.  

There is a generic part of the schema which is used for both stock options and stock purchase plans.  Specific detail to either are held in the element StockOptionInfo and StockPurchaseInfo.  These two elements can not appear together.

4.1.1        Schema Diagram

4.1.2        Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
StockPlan

StockPlanType - (1/1)

validFrom - LocalDateType - required
validTo - LocalDateType - required
Id - EntityIdType - S (1/1)
CompanyId - EntityIdType - S (1/1)
PlanType - StockPlanExtensionType - S (1/1)
Name - xsd:string - S (0/*)
Description - xsd:string - S (0/*)
Stock - [complexType] - S (1/1)
BlackOutInformation - [complexType] - S (0/1)
StockOptionInfo - StockOptionPlanExtensionType - C (1/1)
StockPurchaseInfo - StockPurchasePlanExtensionType - C (1/1)
UserArea - [see include/import] - S (0/1)

Used to create/maintain plan records for Stock Option/Stock Purchase Plans/Stock Awards.

/ StockPlan/
Id

- EntityIdType - S (1/1)

A unique identifier used to reference the entity. The Id is associated with the higher level element.

/ StockPlan/
CompanyId

- EntityIdType - S (1/1)

[Definition Deprecated: Unique ID that identifies the company that is designated as the sponsor of the plan. ][Synonym(s): OrganizationId ]

/ StockPlan/
PlanType

- StockPlanExtensionType - S (1/1)

Specifies the type of plan.

/ StockPlan/
Name

xsd:extension base: xsd:string
xml:lang - - required

A descriptive identifier within the given context.

/ StockPlan/
Description

xsd:extension base: xsd:string
xml:lang - - required

Describes the contextual information relating to a specific element.

/ StockPlan/
Stock

Id - EntityIdType - S (1/1)
Symbol - xsd:string - S (0/1)
Exchange - xsd:string - S (0/1)

A unique identifier for the stock for a company.

/ StockPlan/ Stock/
Id

- EntityIdType - S (1/1)

A unique identifier used to reference the entity. The Id is associated with the higher level element.

/ StockPlan/ Stock/
Symbol

- xsd:string - S (0/1)

A system of letters used to uniquely identify a stock or mutual fund. The ticker symbol for the stock.

/ StockPlan/ Stock/
Exchange

- xsd:string - S (0/1)

The exchange on which the shares of stock and stock equivalents are bought and sold.

/ StockPlan/
BlackOutInformation

Period - [complexType] - S (1/*)

Contains information about the timeframe in which exercising shares is not allowed.

/ StockPlan/ BlackOutInformation/
Period

validFrom - LocalDateType - required
validTo - LocalDateType - required

[Definition Deprecated: The period, as determined by a company, during which the stock of the company cannot be sold by certain designated persons, typically the company's insiders. ][Synonym(s): PeriodOfRestriction ]

/ StockPlan/ BlackOutInformation/ Period/
validFrom

- LocalDateType -

The date the event begins, is active or valid.

/ StockPlan/ BlackOutInformation/ Period/
validTo

- LocalDateType -

The date through which the event is active or valid.  

/ StockPlan/
StockOptionInfo

StockOptionType - StockOptionPlanExtensionType - S (0/*)
Ratio - xsd:integer - S (1/1)
QualifiedGrantsAllowed - xsd:boolean - S (1/1)
NonQualifiedGrantsAllowed - xsd:boolean - S (1/1)
QualifiedGrantDefault - xsd:string - S (1/1)
StockAppreciationRights - xsd:string - S (1/1)
MaximumNumberOfShares - xsd:positiveInteger - S (1/1)
MinimumNumberToExercise - xsd:positiveInteger - S (1/1)
MaximumNumberToExercise - xsd:positiveInteger - S (1/1)
BlocksToExercise - xsd:positiveInteger - S (1/1)

Information pertaining to grant types allowed to be issued from the plan.

/ StockPlan/ StockOptionInfo/
StockOptionType

xsd:extension base: StockOptionPlanExtensionType
country - CountryCodeType -

Specifies the type of stock option.

/ StockPlan/ StockOptionInfo/ StockOptionType/
country

- CountryCodeType -

[Definition Deprecated: Describes the country. ][Synonym(s): countryCode ]

/ StockPlan/ StockOptionInfo/
Ratio

- xsd:integer - S (1/1)

Used to determine the number of shares the participant is going to receive for each stock option.

/ StockPlan/ StockOptionInfo/
QualifiedGrantsAllowed

- xsd:boolean - S (1/1)

Flag to specify if qualified grants are eligible to be issued under the plan.

/ StockPlan/ StockOptionInfo/
NonQualifiedGrantsAllowed

- xsd:boolean - S (1/1)

Flag to specify if non-qualified grants are eligible to be issued under the plan.

/ StockPlan/ StockOptionInfo/
QualifiedGrantDefault

xsd:restriction base: xsd:string [Enumerations]: Qualified, NonQualified

Flag to specify that the default value for all grants issued under the plan will be a Qualified Grant.

/ StockPlan/ StockOptionInfo/
StockAppreciationRights

xsd:restriction base: xsd:string [Enumerations]: standalone, tandem, additive, notApplicable

Flag to specify if stock appreciation rights are eligible to be issued under the plan.

/ StockPlan/ StockOptionInfo/
MaximumNumberOfShares

- xsd:positiveInteger - S (1/1)

Number of shares eligible to be issued under the plan.

/ StockPlan/ StockOptionInfo/
MinimumNumberToExercise

- xsd:positiveInteger - S (1/1)

Minimum number of shares that can be exercised in a single transaction.

/ StockPlan/ StockOptionInfo/
MaximumNumberToExercise

- xsd:positiveInteger - S (1/1)

Maximum number of shares that can be exercised in a single transaction.

/ StockPlan/ StockOptionInfo/
BlocksToExercise

- xsd:positiveInteger - S (1/1)

Number of shares or multiples of that number that must be exercised in a single transaction.

/ StockPlan/
StockPurchaseInfo

StockPurchaseType - StockPurchasePlanExtensionType - S (0/*)
OfferingPeriod - [complexType] - S (1/*)
ContributionRulesDescription - xsd:string - S (0/*)
PurchaseRulesDescription - xsd:string - S (0/*)

Contains details of Stock Purchase if the plan type is "Stock Purchase". Details of the plan type are held as well as the ability to store the dates of multiple offering periods.

/ StockPlan/ StockPurchaseInfo/
StockPurchaseType

xsd:extension base: StockPurchasePlanExtensionType
country - CountryCodeType -

Defines if the Employee Stock Purchase Plan (ESPP) is Qualified or Non Qualified.

/ StockPlan/ StockPurchaseInfo/ StockPurchaseType/
country

- CountryCodeType -

[Definition Deprecated: Describes the country. ][Synonym(s): countryCode ]

/ StockPlan/ StockPurchaseInfo/
OfferingPeriod

validFrom - LocalDateType - required
validTo - LocalDateType - required

A period of time in which an offering is valid.

/ StockPlan/ StockPurchaseInfo/ OfferingPeriod/
validFrom

- LocalDateType -

The date the event begins, is active or valid.

/ StockPlan/ StockPurchaseInfo/ OfferingPeriod/
validTo

- LocalDateType -

The date through which the event is active or valid.  

/ StockPlan/ StockPurchaseInfo/
ContributionRulesDescription

xsd:extension base: xsd:string
xml:lang - - required

The rules for the contribution to an Employee Stock Purchase Plan (ESPP).

/ StockPlan/ StockPurchaseInfo/ ContributionRulesDescription/

 

Globally scoped data type. See element or attribute declaration for definition.

/ StockPlan/ StockPurchaseInfo/
PurchaseRulesDescription

xsd:extension base: xsd:string
xml:lang - - required

The rules for the purchase of an Employee Stock Purchase Plan (ESPP).

/ StockPlan/ StockPurchaseInfo/ PurchaseRulesDescription/

 

Globally scoped data type. See element or attribute declaration for definition.

 

Global types
(alphabetically listed)

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
[StockOptionPlanExtensionType]

- [Union]: StockOptionPlanType,xStringPatternExtensionType

Globally scoped data type. See element or attribute declaration for definition.

/
[StockOptionPlanType]

xsd:restriction base: xsd:string [Enumerations]: Qualified, Non Qualified, Stock Appreciation Rights

Globally scoped data type. See element or attribute declaration for definition.

/
[StockPlanExtensionType]

- [Union]: StockPlanTypeEnumeration,xStringPatternExtensionType

Globally scoped data type. See element or attribute declaration for definition.

/
[StockPlanTypeEnumeration]

xsd:restriction base: xsd:string [Enumerations]: Stock Options, Stock Purchase

Globally scoped data type. See element or attribute declaration for definition.

/
[StockPurchasePlanExtensionType]

- [Union]: StockPurchasePlanType,xStringPatternExtensionType

Globally scoped data type. See element or attribute declaration for definition.

/
[StockPurchasePlanType]

xsd:restriction base: xsd:string [Enumerations]: Qualified, Non Qualified

Globally scoped data type. See element or attribute declaration for definition.

 

4.2        Schema:  StockPlanParticipant

Used to create/maintain records for participants in the Stock Option/Stock Purchase Plans/Stock Awards.    Participant information would be sent as a one-time set-up file for the record and then as an on-going maintenance file to update participant information when appropriate.  The Company is the most likely source of this information.  Recipients include Plan Administrators, Brokers, Transfer Agents and Trustees.  The Participant can also be a source and/or recipient of this data.

4.2.1        Schema Diagram

 

 

4.2.2        Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
StockPlanParticipant

StockPlanParticipantType - (1/1)

Id - EntityIdType - S (1/1)
Account - EntityIdType - S (0/1)
CompanyId - EntityIdType - S (1/1)
Name - PersonNameType - S (1/1)
ContactInfo - ContactMethodType - S (1/1)
AdditionalInfo - xsd:boolean - S (0/1)
UserArea - [see include/import] - S (0/1)

Used to create/maintain records for participants in the Stock Option/Stock Purchase Plans/Stock Awards.

/ StockPlanParticipant/
Id

- EntityIdType - S (1/1)

A unique identifier used to reference the entity. The Id is associated with the higher level element.

/ StockPlanParticipant/
Account

- EntityIdType - S (0/1)

[Definition Deprecated: Number used to identify the participant's account at either a bank or broker. ][Synonym(s): BankAccountNumber, AccountIdentifier ]

/ StockPlanParticipant/
CompanyId

- EntityIdType - S (1/1)

[Definition Deprecated: Unique ID that identifies the company that is designated as the sponsor of the plan. ][Synonym(s): OrganizationId ]

/ StockPlanParticipant/
Name

- PersonNameType - S (1/1)

A descriptive identifier within the given context.

/ StockPlanParticipant/
ContactInfo

- ContactMethodType - S (1/1)

Contains information to contact a person or entity.

/ StockPlanParticipant/
AdditionalInfo

DateOfBirth - LocalDateType - S (0/1)
Nationality - CountryCodeType - S (0/*)
HireDate - LocalDateType - S (0/1)
EmploymentInfo - [complexType] - S (0/1)
Termination - [complexType] - S (0/1)
Employee - xsd:boolean - S (0/*)
Director - xsd:boolean - S (0/*)
Insider - xsd:boolean - S (0/*)
PercentOwner - xsd:decimal - S (0/*)
WorkLocation - [complexType] - S (0/*)
TaxInfo - [complexType] - S (0/*)

A container of additional information relating to the associated element. [Synonym(s): AdditionalData, Comments ]

/ StockPlanParticipant/ AdditionalInfo/
DateOfBirth

- LocalDateType - S (0/1)

A person's birth date.

/ StockPlanParticipant/ AdditionalInfo/
Nationality

- CountryCodeType - S (0/*)

The person's status for belonging to a particular nation by origin, birth, or naturalization.

/ StockPlanParticipant/ AdditionalInfo/
HireDate

- LocalDateType - S (0/1)

Date the person was originally hired by the organization.

/ StockPlanParticipant/ AdditionalInfo/
EmploymentInfo

FullTimeEquivalence - xsd:decimal - C (1/1)
WorktimeInfo - [complexType] - C (1/*)

A collection of information about a current or former employment engagement of the person.

/ StockPlanParticipant/ AdditionalInfo/ EmploymentInfo/
FullTimeEquivalence

- xsd:decimal - C (1/1)

If this participant is a full time employee then the FTE is 1.0 , part time staff will show a FTE according to their equivalence to a full time employee.

/ StockPlanParticipant/ AdditionalInfo/ EmploymentInfo/
WorktimeInfo

Duration - xsd:duration - S (1/1)
Period - xsd:duration - S (1/1)

Eligibility to ESPP may depend upon the amount of time that the participant is employed at the company.

/ StockPlanParticipant/ AdditionalInfo/ EmploymentInfo/ WorktimeInfo/
Duration

- xsd:duration - S (1/1)

Specifies the duration of the reported workContext definition: The amount of time during a period that a person works. Used for eligibility purposes to decide if a participant is eligible to enroll in the Employee Stock Purchase Plan (ESPP).

/ StockPlanParticipant/ AdditionalInfo/ EmploymentInfo/ WorktimeInfo/
Period

- xsd:duration - S (1/1)

[Definition Deprecated: The period, as determined by a company, during which the stock of the company cannot be sold by certain designated persons, typically the company's insiders. ][Synonym(s): PeriodOfRestriction ]

/ StockPlanParticipant/ AdditionalInfo/
Termination

Date - LocalDateType - S (1/1)
Reason - xsd:string - S (1/1)

Container for information about the termination of the participant within a stock plan.

/ StockPlanParticipant/ AdditionalInfo/ Termination/
Date

- LocalDateType - S (1/1)

Date that the participant ceases to be an employee of the company. [Synonym(s): TerminationDate ]

/ StockPlanParticipant/ AdditionalInfo/ Termination/
Reason

- xsd:string - S (1/1)

[Definition Deprecated: Reason for the termination. ][Synonym(s): ReasonForLeaving ]

/ StockPlanParticipant/ AdditionalInfo/
Employee

xsd:extension base: xsd:boolean
validFrom - LocalDateType -
validTo - LocalDateType -

[Definition Deprecated: Flag to designate if the participant is an employee of the company. ][Synonym(s): EmployeeIndicator ]

/ StockPlanParticipant/ AdditionalInfo/ Employee/
validFrom

- LocalDateType -

The date the event begins, is active or valid.

/ StockPlanParticipant/ AdditionalInfo/ Employee/
validTo

- LocalDateType -

The date through which the event is active or valid.  

/ StockPlanParticipant/ AdditionalInfo/
Director

xsd:extension base: xsd:boolean
validFrom - LocalDateType -
validTo - LocalDateType -

Allows the participant to be flagged as a director of the company - A Director can either be an "Inside" or "Outside" Director who is elected by the shareholders to serve on the company's board of directors. An Inside Director is usually a high level employee of the corporation or has a significant economic relationship to the corporation. An Outside Director does not have an employment or other significant economic relationship with the company. Today, boards of almost all publicly held corporations consist primarily of outside directors.

/ StockPlanParticipant/ AdditionalInfo/
Insider

xsd:extension base: xsd:boolean
validFrom - LocalDateType -
validTo - LocalDateType -

Allows the participant to be flagged as an insider of the company - an insider is a general term referring to persons who, by virtue of their positions within a company, have access to confidential information about the company.

/ StockPlanParticipant/ AdditionalInfo/
PercentOwner

xsd:extension base: xsd:decimal
validFrom - LocalDateType -
validTo - LocalDateType -

Allows the participant to be flagged as a percent owner of total combined voting power of all classes of stock of the company or of its parents or subsidiaries that the participant controls.

/ StockPlanParticipant/ AdditionalInfo/
WorkLocation

validFrom - LocalDateType -
validTo - LocalDateType -
CountryCode - CountryCodeType - S (0/1)
Region - xsd:string - S (0/1)
Municipality - xsd:string - S (0/1)
PostalCode - xsd:string - S (0/1)

The address in which the participant is currently working.

/ StockPlanParticipant/ AdditionalInfo/ WorkLocation/
CountryCode

- CountryCodeType - S (0/1)

Contains the ISO 3166-1 two-character country code.

/ StockPlanParticipant/ AdditionalInfo/ WorkLocation/
Region

- xsd:string - S (0/1)

Represents the State, Province, and/or County.

/ StockPlanParticipant/ AdditionalInfo/ WorkLocation/
Municipality

- xsd:string - S (0/1)

Represents the city, town, village, or hamlet.

/ StockPlanParticipant/ AdditionalInfo/ WorkLocation/
PostalCode

- xsd:string - S (0/1)

Codes established by postal authorities for purposes of sorting and delivering mail. See PostalAddress Recommendation.

/ StockPlanParticipant/ AdditionalInfo/
TaxInfo

validFrom - LocalDateType -
validTo - LocalDateType -
TaxType - xsd:string - S (1/1)
TaxationLocation - [complexType] - S (1/1)
Percentage - xsd:decimal - S (1/1)

Details on the tax types and rates and dates that are applicable to a participant. [Synonym(s): ParticipantTaxInfo ]

/ StockPlanParticipant/ AdditionalInfo/ TaxInfo/
TaxType

- xsd:string - S (1/1)

The classification or name of the tax or the taxing entity.

/ StockPlanParticipant/ AdditionalInfo/ TaxInfo/
TaxationLocation

CountryCode - CountryCodeType - S (0/1)
Region - xsd:string - S (0/1)
Municipality - xsd:string - S (0/1)
PostalCode - xsd:string - S (0/1)

The address in which the participant is held liable for taxes. The Postal Address element contains the following data fields: Country Code, Postal Code, Region, Municipality, Delivery Address and Recipient

/ StockPlanParticipant/ AdditionalInfo/ TaxInfo/ TaxationLocation/
CountryCode

- CountryCodeType - S (0/1)

Contains the ISO 3166-1 two-character country code.

/ StockPlanParticipant/ AdditionalInfo/ TaxInfo/ TaxationLocation/
Region

- xsd:string - S (0/1)

Represents the State, Province, and/or County.

/ StockPlanParticipant/ AdditionalInfo/ TaxInfo/ TaxationLocation/
Municipality

- xsd:string - S (0/1)

Represents the city, town, village, or hamlet.

/ StockPlanParticipant/ AdditionalInfo/ TaxInfo/ TaxationLocation/
PostalCode

- xsd:string - S (0/1)

Codes established by postal authorities for purposes of sorting and delivering mail. See PostalAddress Recommendation.

/ StockPlanParticipant/ AdditionalInfo/ TaxInfo/
Percentage

- xsd:decimal - S (1/1)

A percentage. Context definition: Percentage that the participant will be taxed on the sale of the shares.

 

4.3        Schema:  Grant

Used to create/maintain grants issued to participants in a Stock Option Plan. Grant information would be sent as a one-time set-up file for the record and then as an on-going maintenance file to update grant information when appropriate.  The Company is the most likely source of this information.  Recipients include Plan Administrators and Brokers.  The Participant will be notified of any grant issuance and may be required to either accept or reject the grant. 

4.3.1        Schema Diagram

 

4.3.2        Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
Grant

GrantType - (1/1)

validTo - LocalDateType - required
grantDate - LocalDateType - required
grantCurrency - CurrencyCodeType -
Id - EntityIdType - S (1/1)
ParticipantId - EntityIdType - S (1/1)
PlanId - EntityIdType - S (1/1)
GrantType - StockOptionPlanExtensionType - S (0/*)
Restricted - xsd:boolean - S (1/1)
Repurchasable - xsd:boolean - S (1/1)
SharesGranted - xsd:decimal - S (1/1)
SharesAccepted - xsd:decimal - S (1/1)
GrantPrice - xsd:double - S (0/1)
FairMarketValue - xsd:double - S (0/1)
BlackOutInformation - [complexType] - S (0/1)
VestingInfo - [complexType] - S (0/1)
ExercisabilityInfo - [complexType] - S (0/1)
Comment - xsd:string - S (0/*)
UserArea - [see include/import] - S (0/1)

Used to create/maintain grants issued to participants in a Stock Option Plan. Grant information would be sent as a one-time set-up file for the record and then as an on-going maintenance file to update grant information when appropriate.

/ Grant/
Id

- EntityIdType - S (1/1)

A unique identifier used to reference the entity. The Id is associated with the higher level element.

/ Grant/
ParticipantId

- EntityIdType - S (1/1)

Unique ID that identifies the participant to whom the grant is being issued.

/ Grant/
PlanId

- EntityIdType - S (1/1)

PlanId specifies which plan the sibling elements relate to.

/ Grant/
GrantType

xsd:extension base: StockOptionPlanExtensionType
country - CountryCodeType -

Specifies the type of grant being issued to the participant. Ex. Qualified, Non-Qualified, SAR. Should be seen as an addition to the plan type.

/ Grant/ GrantType/
country

- CountryCodeType -

[Definition Deprecated: Describes the country. ][Synonym(s): countryCode ]

/ Grant/
Restricted

- xsd:boolean - S (1/1)

Flag to specify the grant is being issued with certain restrictions attached to it.

/ Grant/
Repurchasable

- xsd:boolean - S (1/1)

Flag to specify the shares issued as a result of exercise of the grant as being repurchasable by the issuing company. Usually, a company has the right to repurchase shares that were acquired by the participant prior to vesting requirements being satisfied. Shares in privately held companies are frequently repurchasable regardless of whether the shares are vested or unvested.

/ Grant/
SharesGranted

- xsd:decimal - S (1/1)

Number of shares the participant has the right to acquire pursuant to the terms of the grant/plan.

/ Grant/
SharesAccepted

- xsd:decimal - S (1/1)

Number of shares accepted by the participant for the grant.

/ Grant/
GrantPrice

- xsd:double - S (0/1)

The price at which the shares of stock subject to a stock option plan may be purchased. Typically expressed on a per share basis. Also referred to as Exercise Price.

/ Grant/
FairMarketValue

- xsd:double - S (0/1)

For public companies it is typically the price at which the company's stock is traded on the date of the grant. In the case of a privately held company, this value is typically based upon an independent appraisal conducted by one or more third parties or determined by the board of directors based upon all of the relevant facts and circumstances.

/ Grant/
BlackOutInformation

Period - [complexType] - S (1/*)

Contains information about the timeframe in which exercising shares is not allowed.

/ Grant/ BlackOutInformation/
Period

validFrom - LocalDateType - required
validTo - LocalDateType - required

[Definition Deprecated: The period, as determined by a company, during which the stock of the company cannot be sold by certain designated persons, typically the company's insiders. ][Synonym(s): PeriodOfRestriction ]

/ Grant/ BlackOutInformation/ Period/
validFrom

- LocalDateType -

The date the event begins, is active or valid.

/ Grant/ BlackOutInformation/ Period/
validTo

- LocalDateType -

The date through which the event is active or valid.  

/ Grant/
VestingInfo

Shares - [complexType] - C (1/*)
Rule - xsd:string - C (1/*)

Information detailing the vesting schedule, shares and dates for the grant.

/ Grant/ VestingInfo/
Shares

Quantity - xsd:decimal - S (1/1)
VestingDate - LocalDateType - S (1/1)

Any of the equal interests of rights into which the entire capital stock of a corporation is divided. Context definition: Number of shares that are/will vest on the date specified. Typical vesting scenarios contain multiple vesting increments or share amounts on different dates. Shares cannot be sold until they are vested.

/ Grant/ VestingInfo/ Shares/
Quantity

- xsd:decimal - S (1/1)

The use of this element may vary based on the business need. HR business process examples include: the number of shares to be vested, number of produced pieces, number of benefit Id cards, or number of positions to be filled.

/ Grant/ VestingInfo/ Shares/
VestingDate

- LocalDateType - S (1/1)

Date when the options become vested.

/ Grant/ VestingInfo/
Rule

- xsd:string - C (1/*)

Defines the guidelines or directives related to the associated element. Context definition: Used to define a more complex or extensive vesting rule than the elements 'Quantity' and 'VestingDate' allow. For example, company does not want to enter all vesting dates and quantities.

/ Grant/
ExercisabilityInfo

Shares - [complexType] - C (1/*)
Rule - xsd:string - C (1/*)

Information detailing the exercisability schedule, shares and dates for the grant.

/ Grant/ ExercisabilityInfo/
Shares

Quantity - xsd:decimal - S (1/1)
ExerciseDate - LocalDateType - S (1/1)

Any of the equal interests of rights into which the entire capital stock of a corporation is divided. Context definition: Number of shares that are/will be exercisable on the date specified.Typical exercisability scenarios contain multiple increments or share amounts on different dates. Shares can routinely be exercised prior to being vested.

/ Grant/ ExercisabilityInfo/ Shares/
Quantity

- xsd:decimal - S (1/1)

The use of this element may vary based on the business need. HR business process examples include: the number of shares to be vested, number of produced pieces, number of benefit Id cards, or number of positions to be filled.

/ Grant/ ExercisabilityInfo/ Shares/
ExerciseDate

- LocalDateType - S (1/1)

Date when the options become exercisable.

/ Grant/ ExercisabilityInfo/
Rule

- xsd:string - C (1/*)

Defines the guidelines or directives related to the associated element. Context definition: Used to define a more complex or extensive exercise rule than the elements 'Quantity' and 'ExerciseDate' allow. For example, company has weekly exercisability but does not want to enter all exercise dates and quantities.

/ Grant/
Comment

xsd:extension base: xsd:string
xml:lang - -

[Synonym(s): Comments]

 

 

 

4.4        Schema: Exercise Request

Used to pass option exercise transaction information for a participant of a stock option plan.  Exercise information would be sent as transactions occur – there can be many exercise transaction for one grant over a period of time.  The Participant and/or the Administrator are the most likely source of this information.  Recipient would be the Broker. 

4.4.1        Schema Diagram

 

 

 

4.4.2        Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
ExerciseRequest

ExerciseRequestType - (1/1)

Id - EntityIdType - S (1/1)
ParticipantId - EntityIdType - S (1/1)
RequestDate - LocalDateType - S (1/1)
ExerciseDate - LocalDateType - S (1/1)
ExerciseInfo - xsd:decimal - S (1/1)
ExerciseInstructions - xsd:decimal - S (0/1)
UserArea - [see include/import] - S (0/1)

Used to pass option exercise transaction information for a participant of a stock option plan.

/ ExerciseRequest/
Id

- EntityIdType - S (1/1)

A unique identifier used to reference the entity. The Id is associated with the higher level element.

/ ExerciseRequest/
ParticipantId

- EntityIdType - S (1/1)

Unique ID that identifies the participant to whom the grant is being issued.

/ ExerciseRequest/
RequestDate

- LocalDateType - S (1/1)

The date the Exercise Request is sent to either the Administrator or Broker.

/ ExerciseRequest/
ExerciseDate

- LocalDateType - S (1/1)

Date when the options become exercisable.

/ ExerciseRequest/
ExerciseInfo

GrantId - EntityIdType - S (1/1)
OptionsToBeExercised - xsd:decimal - S (1/1)
GrantPrice - xsd:decimal - S (0/1)
SharesToBeSold - xsd:decimal - S (1/1)
SARPercentCashRequested - xsd:decimal - S (1/1)

Information pertaining to an requested exercise transaction.

/ ExerciseRequest/ ExerciseInfo/
GrantId

- EntityIdType - S (1/1)

A unique identifier for the grant.

/ ExerciseRequest/ ExerciseInfo/
OptionsToBeExercised

- xsd:decimal - S (1/1)

Number of options to be exercised for the grant in the transaction.

/ ExerciseRequest/ ExerciseInfo/
GrantPrice

xsd:extension base: xsd:decimal
currency - CurrencyCodeType - required

The price at which the shares of stock subject to a stock option plan may be purchased. Typically expressed on a per share basis. Also referred to as Exercise Price.

/ ExerciseRequest/ ExerciseInfo/ GrantPrice/
currency

- CurrencyCodeType -

[Definition Deprecated: Currency in which the grant price is expressed.][Synonym(s): CurrencyCode]

/ ExerciseRequest/ ExerciseInfo/
SharesToBeSold

- xsd:decimal - S (1/1)

Number of shares that will be immediately sold by the broker upon exercise of the grant.

/ ExerciseRequest/ ExerciseInfo/
SARPercentCashRequested

- xsd:decimal - S (1/1)

Percent of the proceeds from the Stock Appreciation Right exercise transaction that is to be paid to the participant in cash. The percentage not paid in cash is then paid out in shares to the participant.

/ ExerciseRequest/
ExerciseInstructions

SellToCoverOptions - xsd:boolean - S (1/1)
SellToCoverTaxes - xsd:boolean - S (1/1)
SellToCoverFees - xsd:boolean - S (1/1)
UseSharesForTaxes - xsd:boolean - S (1/1)
UseSharesFirst - xsd:boolean - S (1/1)
SharesSwapped - xsd:decimal - S (1/1)
TaxRelevantPrice - xsd:decimal - S (0/1)
SaleType - [complexType] - S (1/1)

Details on the instructions that were sent to the broker for the execution of an exercise order.

/ ExerciseRequest/ ExerciseInstructions/
SellToCoverOptions

- xsd:boolean - S (1/1)

Flag to specify if shares were sold to cover the cost of the options for the exercise transaction.

/ ExerciseRequest/ ExerciseInstructions/
SellToCoverTaxes

- xsd:boolean - S (1/1)

Flag to specify if shares were sold to cover the tax liability of the exercise transaction.

/ ExerciseRequest/ ExerciseInstructions/
SellToCoverFees

- xsd:boolean - S (1/1)

Flag to specify if shares were sold to cover the fees associated with the exercise transaction.

/ ExerciseRequest/ ExerciseInstructions/
UseSharesForTaxes

- xsd:boolean - S (1/1)

Flag to specify if shares were used to cover the tax liability of the exercise transaction.

/ ExerciseRequest/ ExerciseInstructions/
UseSharesFirst

- xsd:boolean - S (1/1)

Flag to specify that shares tendered were used before any shares are sold to cover the cost of the options for the exercise transaction.

/ ExerciseRequest/ ExerciseInstructions/
SharesSwapped

- xsd:decimal - S (1/1)

Shares exchanged to cover the cost of options.

/ ExerciseRequest/ ExerciseInstructions/
TaxRelevantPrice

xsd:extension base: xsd:decimal
currency - CurrencyCodeType - required

The price used in the calculation of taxable compensation for a taxable transaction (exercise/disposition).

/ ExerciseRequest/ ExerciseInstructions/ TaxRelevantPrice/
currency

- CurrencyCodeType -

[Definition Deprecated: Currency in which the tax relevant price is represented.][Synonym(s): CurrencyCode]

/ ExerciseRequest/ ExerciseInstructions/
SaleType

MarketOrder - xsd:boolean - C (1/1)
LimitOrder - [complexType] - C (1/1)
GoodTillCancelled - xsd:boolean - C (1/1)

Defines the behavior requested by a participant to a broker to execute an exercise order.

/ ExerciseRequest/ ExerciseInstructions/ SaleType/
MarketOrder

- xsd:boolean - C (1/1)

Flag to specify if the exercise is a market order. A market is one in which the order is executed immediately at the best prices available when the order reaches the marketplace. This type of order is almost always filled, since no prices is specified as a condition of execution.

/ ExerciseRequest/ ExerciseInstructions/ SaleType/
LimitOrder

LimitPrice - xsd:decimal - S (1/1)
ExpiryDate - LocalDateType - S (1/1)

Flag to specify if the exercise is a limit order. A limit order is an order to execute a transaction only at a specific price (limit) or better.

/ ExerciseRequest/ ExerciseInstructions/ SaleType/ LimitOrder/
LimitPrice

- xsd:decimal - S (1/1)

Price at which the order will be executed in a limit order.

/ ExerciseRequest/ ExerciseInstructions/ SaleType/ LimitOrder/
ExpiryDate

- LocalDateType - S (1/1)

Defines a period of time for a limit order that if the limit price has not been reached, the order will expire and will not be executed.

/ ExerciseRequest/ ExerciseInstructions/ SaleType/
GoodTillCancelled

- xsd:boolean - C (1/1)

Flag to specify that the exercise order to purchase will remain valid until executed or cancelled by the customer.

 

4.5        Schema: Exercise Confirmation

Used to pass option exercise confirmation information for a participant of a stock option plan. Exercise confirmation information would be sent as the broker executes transactions. The Broker is the most likely source of this information. Recipient would be the Participant and/or Plan Administrator.

 

 

 

 

 

 

 

4.5.1        Schema Diagram


4.5.2        Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
ExerciseConfirmation

ExerciseConfirmationType - (1/1)

Id - EntityIdType - S (1/1)
ParticipantId - EntityIdType - S (1/1)
ExerciseDate - LocalDateType - S (1/1)
ExerciseInfo - xsd:decimal - S (1/1)
FairMarketValueOnExerciseDate - xsd:decimal - S (1/1)
ExerciseInstructions - xsd:decimal - S (0/1)
TaxInfo - xsd:decimal - S (0/*)
UserArea - [see include/import] - S (0/1)

Used to pass option exercise confirmation information for a participant of a stock option plan.

/ ExerciseConfirmation/
Id

- EntityIdType - S (1/1)

A unique identifier used to reference the entity. The Id is associated with the higher level element.

/ ExerciseConfirmation/
ParticipantId

- EntityIdType - S (1/1)

Unique ID that identifies the participant to whom the grant is being issued.

/ ExerciseConfirmation/
ExerciseDate

- LocalDateType - S (1/1)

Date when the options become exercisable.

/ ExerciseConfirmation/
ExerciseInfo

GrantId - EntityIdType - S (1/1)
OptionsExercised - xsd:decimal - S (1/1)
GrantPrice - xsd:decimal - S (0/1)
SharesTradedForTax - xsd:decimal - S (1/1)
SharesSwapped - xsd:decimal - S (1/1)
SharesSold - xsd:decimal - S (1/1)
SARPercentCashRequested - xsd:decimal - S (1/1)

Information pertaining to an requested exercise transaction.

/ ExerciseConfirmation/ ExerciseInfo/
GrantId

- EntityIdType - S (1/1)

A unique identifier for the grant.

/ ExerciseConfirmation/ ExerciseInfo/
OptionsExercised

- xsd:decimal - S (1/1)

Number of options being exercised in the transaction.

/ ExerciseConfirmation/ ExerciseInfo/
GrantPrice

xsd:extension base: xsd:decimal
currency - CurrencyCodeType - required

The price at which the shares of stock subject to a stock option plan may be purchased. Typically expressed on a per share basis. Also referred to as Exercise Price.

/ ExerciseConfirmation/ ExerciseInfo/ GrantPrice/
currency

- CurrencyCodeType -

[Definition Deprecated: Currency in which the grant price is expressed.][Synonym(s): CurrencyCode]

/ ExerciseConfirmation/ ExerciseInfo/
SharesTradedForTax

- xsd:decimal - S (1/1)

Number of shares traded to cover all/partial tax liability for the transaction.

/ ExerciseConfirmation/ ExerciseInfo/
SharesSwapped

- xsd:decimal - S (1/1)

Shares exchanged to cover the cost of options.

/ ExerciseConfirmation/ ExerciseInfo/
SharesSold

- xsd:decimal - S (1/1)

Number of shares that were sold.

/ ExerciseConfirmation/ ExerciseInfo/
SARPercentCashRequested

- xsd:decimal - S (1/1)

Percent of the proceeds from the Stock Appreciation Right exercise transaction that is to be paid to the participant in cash. The percentage not paid in cash is then paid out in shares to the participant.

/ ExerciseConfirmation/
FairMarketValueOnExerciseDate

xsd:extension base: xsd:decimal
currency - CurrencyCodeType - required

Fair market value of the shares on the exercise date.

/ ExerciseConfirmation/ FairMarketValueOnExerciseDate/
currency

- CurrencyCodeType -

[Definition Deprecated: [3] Currency in which the FMV is expressed.][Synonym(s): CurrencyCode]

/ ExerciseConfirmation/
ExerciseInstructions

SellToCoverOptions - xsd:boolean - S (1/1)
SellToCoverTaxes - xsd:boolean - S (1/1)
SellToCoverFees - xsd:boolean - S (1/1)
UseSharesForTaxes - xsd:boolean - S (1/1)
UseSharesFirst - xsd:boolean - S (1/1)
TaxRelevantPrice - xsd:decimal - S (1/1)

Details on the instructions that were sent to the broker for the execution of an exercise order.

/ ExerciseConfirmation/ ExerciseInstructions/
SellToCoverOptions

- xsd:boolean - S (1/1)

Flag to specify if shares were sold to cover the cost of the options for the exercise transaction.

/ ExerciseConfirmation/ ExerciseInstructions/
SellToCoverTaxes

- xsd:boolean - S (1/1)

Flag to specify if shares were sold to cover the tax liability of the exercise transaction.

/ ExerciseConfirmation/ ExerciseInstructions/
SellToCoverFees

- xsd:boolean - S (1/1)

Flag to specify if shares were sold to cover the fees associated with the exercise transaction.

/ ExerciseConfirmation/ ExerciseInstructions/
UseSharesForTaxes

- xsd:boolean - S (1/1)

Flag to specify if shares were used to cover the tax liability of the exercise transaction.

/ ExerciseConfirmation/ ExerciseInstructions/
UseSharesFirst

- xsd:boolean - S (1/1)

Flag to specify that shares tendered were used before any shares are sold to cover the cost of the options for the exercise transaction.

/ ExerciseConfirmation/ ExerciseInstructions/
TaxRelevantPrice

xsd:extension base: xsd:decimal
currency - CurrencyCodeType - required

The price used in the calculation of taxable compensation for a taxable transaction (exercise/disposition).

/ ExerciseConfirmation/ ExerciseInstructions/ TaxRelevantPrice/
currency

- CurrencyCodeType -

[Definition Deprecated: Currency in which the tax relevant price is represented.][Synonym(s): CurrencyCode]

/ ExerciseConfirmation/
TaxInfo

TaxDate - LocalDateType - S (1/1)
TaxType - xsd:string - S (1/1)
TaxationLocation - [complexType] - S (1/1)
TaxAmount - xsd:decimal - S (1/1)

Details on the tax liability incurred as a result of the exercise transaction. [2] Details on the tax types and rates and dates that are applicable to a participant. [Synonym(s): ParticipantTaxInfo ]

/ ExerciseConfirmation/ TaxInfo/
TaxDate

- LocalDateType - S (1/1)

The date as it pertains to the calculation of taxes.

/ ExerciseConfirmation/ TaxInfo/
TaxType

- xsd:string - S (1/1)

The classification or name of the tax or the taxing entity.

/ ExerciseConfirmation/ TaxInfo/
TaxationLocation

CountryCode - CountryCodeType - S (0/1)
Region - xsd:string - S (0/1)
Municipality - xsd:string - S (0/1)
PostalCode - xsd:string - S (0/1)

The address in which the participant is held liable for taxes. The Postal Address element contains the following data fields: Country Code, Postal Code, Region, Municipality, Delivery Address and Recipient

/ ExerciseConfirmation/ TaxInfo/ TaxationLocation/
CountryCode

- CountryCodeType - S (0/1)

Contains the ISO 3166-1 two-character country code.

/ ExerciseConfirmation/ TaxInfo/ TaxationLocation/
Region

- xsd:string - S (0/1)

Represents the State, Province, and/or County.

/ ExerciseConfirmation/ TaxInfo/ TaxationLocation/
Municipality

- xsd:string - S (0/1)

Represents the city, town, village, or hamlet.

/ ExerciseConfirmation/ TaxInfo/ TaxationLocation/
PostalCode

- xsd:string - S (0/1)

Codes established by postal authorities for purposes of sorting and delivering mail. See PostalAddress Recommendation.

/ ExerciseConfirmation/ TaxInfo/
TaxAmount

xsd:extension base: xsd:decimal
currency - CurrencyCodeType - required

Tax liability incurred as a result of the exercise transaction.

/ ExerciseConfirmation/ TaxInfo/ TaxAmount/
currency

- CurrencyCodeType -

[Definition Deprecated: Currency in which the tax amount is represented.][Synonym(s): CurrencyCode]

 

 

4.6        Schema: Stock Deposit

This schema is the instruction for the broker to distribute stock to a given set of participants.  The broker will/have receive(d) a stock transfer by the ESPP sponsor companies transfer agent and therefore needs this instruction before distribution can take place.  This schema can be extended in future releases to enable distribution of restricted stock awards and other similar compensation instruments.

4.6.1        Schema Diagram

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


4.6.2        Schema Elements Explained

In the context of this schema where the explanatory text states ESPP it can equally apply to any stock award that a Participant may receive.  It is simply referred to ESPP for convenience sake.

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
StockDeposit

StockDepositType - (1/1)

Id - EntityIdType - S (1/1)
DepositAction - xsd:string - S (1/1)
Participant - [complexType] - S (1/1)
PlanId - EntityIdType - S (1/1)
Date - LocalDateTimeType - S (1/1)
Quantity - xsd:decimal - S (1/1)
StockPrice - xsd:decimal - S (0/1)
RestrictionPeriod - [complexType] - S (0/*)
UserArea - [see include/import] - S (0/1)

Records the stock deposited on behalf of a Employee Stock Purchase Plan (ESPP) participant.

/ StockDeposit/
Id

- EntityIdType - S (1/1)

A unique identifier used to reference the entity. The Id is associated with the higher level element.

/ StockDeposit/
DepositAction

type xsd:restriction base: xsd:string [Enumerations]: Deposit, SellOnDeposit
- - required

The action to take on deposit of the stock.

/ StockDeposit/ DepositAction/
type

xsd:restriction base: xsd:string [Enumerations]: Deposit, SellOnDeposit

Further defines the associated element in the context provided.

/ StockDeposit/
Participant

Id - EntityIdType - S (1/1)
Name - PersonNameType - S (0/1)

Contains all the information related to the person (employee) and the information gathered for that employee. [Synonym(s): ParticipantInfo ]

/ StockDeposit/ Participant/
Id

- EntityIdType - S (1/1)

A unique identifier used to reference the entity. The Id is associated with the higher level element.

/ StockDeposit/ Participant/
Name

- PersonNameType - S (0/1)

A descriptive identifier within the given context.

/ StockDeposit/
PlanId

- EntityIdType - S (1/1)

PlanId specifies which plan the sibling elements relate to.

/ StockDeposit/
Date

- LocalDateTimeType - S (1/1)

A date.

/ StockDeposit/
Quantity

- xsd:decimal - S (1/1)

The use of this element may vary based on the business need. HR business process examples include: the number of shares to be vested, number of produced pieces, number of benefit Id cards, or number of positions to be filled.

/ StockDeposit/
StockPrice

xsd:extension base: xsd:decimal
currency - CurrencyCodeType - required

The stock price to be associated to the shares deposited.

/ StockDeposit/ StockPrice/
currency

- CurrencyCodeType -

[Definition Deprecated: Company or stock class base currency. ][ Synonym(s): CurrencyCode]

/ StockDeposit/
RestrictionPeriod

validFrom - AnyDateTimeNkNaType - required
validTo - AnyDateTimeNkNaType - required
type - RestrictionPeriodType - required

Specifies restrictions on when a participant is free to dispose of stock purchased under the Employee Stock Purchase Plan (ESPP).

/ StockDeposit/ RestrictionPeriod/
validFrom

- AnyDateTimeNkNaType -

The date the event begins, is active or valid.

/ StockDeposit/ RestrictionPeriod/
validTo

- AnyDateTimeNkNaType -

The date through which the event is active or valid.  

/ StockDeposit/ RestrictionPeriod/
type

- RestrictionPeriodType -

Further defines the associated element in the context provided. [2] The type attribute of Amount specifies the calculation method. [Synonym(s): calculationMethodType ]

 

Global types
(alphabetically listed)

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
[RestrictionPeriodType]

[Union]: RestrictionPeriodTypeEnumeration,

xStringPatternExtensionType

Globally scoped data type. See element or attribute declaration for definition.

/
[RestrictionPeriodTypeEnumeration]

xsd:restriction base: xsd:string [Enumerations]: ProhibitedSale, ProhibitedTransfer

Globally scoped data type. See element or attribute declaration for definition.

 


 

4.7        Schema: Stock Sale Confirmation

When a participant sells some of his ESPP stock holding the broker may communicate this back to the Administrator.  This can be required for US ESPP plans because there may be a disqualifying disposition to which the company is obliged to be informed about.

4.7.1        Schema Diagram

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


4.7.2        Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
StockSaleConfirmation

StockSaleConfirmationType - (1/1)

Id - EntityIdType - S (1/1)
ParticipantId - EntityIdType - S (1/1)
SaleDate - LocalDateTimeType - S (1/1)
StockSalePosition - [complexType] - S (1/*)
SharesSoldTotal - xsd:decimal - S (1/1)
SalesPricePerShare - AmountType - S (0/1)
TotalSalesValue - AmountType - S (0/1)
TaxInfoTotal - TaxInfoType - S (0/*)
UserArea - [see include/import] - S (0/1)

Confirmation details of stock disposed by an Employee Stock Purchase Plan (ESPP) participant.

/ StockSaleConfirmation/
Id

- EntityIdType - S (1/1)

A unique identifier used to reference the entity. The Id is associated with the higher level element.

/ StockSaleConfirmation/
ParticipantId

- EntityIdType - S (1/1)

Unique ID that identifies the participant to whom the grant is being issued.

/ StockSaleConfirmation/
SaleDate

- LocalDateTimeType - S (1/1)

The date that the disposition or sale was made.

/ StockSaleConfirmation/
StockSalePosition

StockPurchaseId - EntityIdType - S (1/1)
SharesSold - xsd:decimal - S (1/1)
TaxInfo - TaxInfoType - S (0/*)

The participant may choose to dispose a number of shares accumulated from one or more purchases. Each original stock purchase is listed with the quantity disposed or sold.

/ StockSaleConfirmation/ StockSalePosition/
StockPurchaseId

- EntityIdType - S (1/1)

Unique identifier for a stock deposit or purchase transaction.

/ StockSaleConfirmation/ StockSalePosition/
SharesSold

- xsd:decimal - S (1/1)

Number of shares that were sold.

/ StockSaleConfirmation/ StockSalePosition/
TaxInfo

- TaxInfoType - S (0/*)

Details on the tax liability incurred as a result of the exercise transaction. [2] Details on the tax types and rates and dates that are applicable to a participant. [Synonym(s): ParticipantTaxInfo ]

/ StockSaleConfirmation/ StockSalePosition/ TaxInfo/
TaxDate

- LocalDateType - S (1/1)

The date as it pertains to the calculation of taxes.

/ StockSaleConfirmation/ StockSalePosition/ TaxInfo/
TaxType

- xsd:string - S (1/1)

The classification or name of the tax or the taxing entity.

/ StockSaleConfirmation/ StockSalePosition/ TaxInfo/
TaxationLocation

CountryCode - CountryCodeType - S (0/1)
Region - xsd:string - S (0/1)
Municipality - xsd:string - S (0/1)
PostalCode - xsd:string - S (0/1)

The address in which the participant is held liable for taxes. The Postal Address element contains the following data fields: Country Code, Postal Code, Region, Municipality, Delivery Address and Recipient

/ StockSaleConfirmation/ StockSalePosition/ TaxInfo/ TaxationLocation/
CountryCode

- CountryCodeType - S (0/1)

Contains the ISO 3166-1 two-character country code.

/ StockSaleConfirmation/ StockSalePosition/ TaxInfo/ TaxationLocation/
Region

- xsd:string - S (0/1)

Represents the State, Province, and/or County.

/ StockSaleConfirmation/ StockSalePosition/ TaxInfo/ TaxationLocation/
Municipality

- xsd:string - S (0/1)

Represents the city, town, village, or hamlet.

/ StockSaleConfirmation/ StockSalePosition/ TaxInfo/ TaxationLocation/
PostalCode

- xsd:string - S (0/1)

Codes established by postal authorities for purposes of sorting and delivering mail. See PostalAddress Recommendation.

/ StockSaleConfirmation/ StockSalePosition/ TaxInfo/
TaxAmount

- AmountType - S (1/1)

Tax liability incurred as a result of the exercise transaction.

/ StockSaleConfirmation/
SharesSoldTotal

- xsd:decimal - S (1/1)

The total number of shares disposed or sold.

/ StockSaleConfirmation/
SalesPricePerShare

- AmountType - S (0/1)

The price at which the disposition or sale was made in the indicated currency.

/ StockSaleConfirmation/
TotalSalesValue

- AmountType - S (0/1)

The total value of the sale in the indicated currency.

/ StockSaleConfirmation/
TaxInfoTotal

TaxInfoType - S (0/*)

TaxDate - LocalDateType - S (1/1)
TaxType - xsd:string - S (1/1)
TaxationLocation - [complexType] - S (1/1)
TaxAmount - AmountType - S (1/1)

Summary information of the tax info detailed for each stock sale position.

/ StockSaleConfirmation/ TaxInfoTotal/
TaxDate

- LocalDateType - S (1/1)

The date as it pertains to the calculation of taxes.

/ StockSaleConfirmation/ TaxInfoTotal/
TaxType

- xsd:string - S (1/1)

The classification or name of the tax or the taxing entity.

/ StockSaleConfirmation/ TaxInfoTotal/
TaxationLocation

CountryCode - CountryCodeType - S (0/1)
Region - xsd:string - S (0/1)
Municipality - xsd:string - S (0/1)
PostalCode - xsd:string - S (0/1)

The address in which the participant is held liable for taxes. The Postal Address element contains the following data fields: Country Code, Postal Code, Region, Municipality, Delivery Address and Recipient

/ StockSaleConfirmation/ TaxInfoTotal/ TaxationLocation/
CountryCode

- CountryCodeType - S (0/1)

Contains the ISO 3166-1 two-character country code.

/ StockSaleConfirmation/ TaxInfoTotal/ TaxationLocation/
Region

- xsd:string - S (0/1)

Represents the State, Province, and/or County.

/ StockSaleConfirmation/ TaxInfoTotal/ TaxationLocation/
Municipality

- xsd:string - S (0/1)

Represents the city, town, village, or hamlet.

/ StockSaleConfirmation/ TaxInfoTotal/ TaxationLocation/
PostalCode

- xsd:string - S (0/1)

Codes established by postal authorities for purposes of sorting and delivering mail. See PostalAddress Recommendation.

/ StockSaleConfirmation/ TaxInfoTotal/
TaxAmount

- AmountType - S (1/1)

Tax liability incurred as a result of the exercise transaction.

 

Global types
(alphabetically listed)

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
[AmountType]

xsd:extension base: xsd:decimal
currency - CurrencyCodeType - required

Globally scoped data type. See element or attribute declaration for definition.

/ [AmountType] /
currency

- CurrencyCodeType -

[Definition Deprecated: Currency in which the tax amount is represented.][Synonym(s): CurrencyCode]

4.8        Schema: RemoveStockPlans

There are cases where data, which has already been sent, needs to be deleted. The following schema enables the deletion of Stock Plan data.

4.8.1        Schema Diagram

4.8.2        Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
RemoveStockPlans

RemoveStockPlansType - (1/1)

PlanId - EntityIdType - S (1/*)

Used to remove plan records for Stock Option/Stock Purchase Plans/Stock Awards.

/ RemoveStockPlans/
PlanId

- EntityIdType - S (1/*)

PlanId specifies which plan the sibling elements relate to.

 

4.9        Schema: RemoveStockPlanParticipants

There are cases where data, which has already been sent, needs to be deleted. The following schema enables Plan Participant data to be deleted.

4.9.1        Schema Diagram

4.9.2        Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
RemoveStockPlanParticipants

RemoveStockPlanParticipantsType - (1/1)

ParticipantId - EntityIdType - S (1/*)

Used to remove records for participants in the Stock Option/Stock Purchase Plans/Stock Awards.

/ RemoveStockPlanParticipants/
ParticipantId

- EntityIdType - S (1/*)

Unique ID that identifies the participant to whom the grant is being issued.

 

 

4.10    Schema: RemoveGrants

There are cases where data which has already been sent needs to be deleted. The following schema enables Grant data to be deleted.

4.10.1    Schema Diagram

4.10.2    Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
RemoveGrants

RemoveGrantsType - (1/1)

GrantId - EntityIdType - S (1/*)

Used to remove grants issued to participants in a Stock Option Plan.

/ RemoveGrants/
GrantId

- EntityIdType - S (1/*)

A unique identifier for the grant.

 

 

4.11    Schema: RemoveExerciseRequests

There are cases where data, which has already been sent, needs to be deleted. The following schema enables the deletion of Exercise Request data.

4.11.1    Schema Diagram

4.11.2    Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
RemoveExerciseRequests

RemoveExerciseRequestsType - (1/1)

ExerciseRequestId - EntityIdType - S (1/*)

Used to remove option exercise transaction information for a participant of a stock option plan.

/ RemoveExerciseRequests/
ExerciseRequestId

- EntityIdType - S (1/*)

A unique identifier for the exercise request.

 

 

4.12    Schema: RemoveExerciseConfirmations

There are cases where data which has already been sent needs to be deleted. The following schema allows to delete Exercise Confirmation data.

4.12.1    Schema Diagram

4.12.2    Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
RemoveExerciseConfirmations

RemoveExerciseConfirmationsType - (1/1)

ExerciseConfirmationId - EntityIdType - S (1/*)

Used to remove option exercise confirmation information for a participant of a stock option plan.

/ RemoveExerciseConfirmations/
ExerciseConfirmationId

- EntityIdType - S (1/*)

A unique identifier for the exercise confirmation.

4.13    Schema: RemoveStockDeposits

There are cases where data, which has already been sent, needs to be deleted. The following schema enables the deletion of Stock Deposit data.

4.13.1    Schema Diagram

4.13.2    Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
RemoveStockDeposits

RemoveStockDepositsType - (1/1)

StockDepositId - EntityIdType - S (1/*)

Used to remove records for stock deposit data.

/ RemoveStockDeposits/
StockDepositId

- EntityIdType - S (1/*)

Unique identifier for a stock deposit transaction.

 

4.14    Schema: RemoveStockSaleConfirmations

There are cases where data which has already been sent needs to be deleted. The following schema allows to delete Stock Sale Confirmations data.

4.14.1    Schema Diagram

4.14.2    Schema Elements Explained

Elements and Attributes

[Global types listed alphabetically in following table.]

ContentModel*
Data type
Occurrence:
Sequence | Choice | All
(minOccurs/maxOccurs)
Attributes

Definition

/
RemoveStockSaleConfirmations

RemoveStockSaleConfirmationsType - (1/1)

StockSaleConfirmationId - EntityIdType - S (1/*)

Used to remove stock sale confirmation data.

/ RemoveStockSaleConfirmations/
StockSaleConfirmationId

- EntityIdType - S (1/*)

Unique identifier to confirm the sale of the stock transaction.

 

5         Implementation Considerations

6         Issues List

Issue

Anticipated

Resolution

See chapter 1.3.3. (Items Outside of Design Scope)

 

StockPlan Schema: the elements within StockOptionInfo are currently all of type Integer.

It might make sense in a future version to check if some of them should also allow decimals, e.g. BlocksToExercise

We currently don’t support plans with more than one underlying stock

 

If exercising an option it is possible that the stock you receive could be of more than one type. We currently don’t allow this

 

 

We don’t keep track of a reason code for a life event

Use comment element for any description of the life event

Country specific information: We allow to keep track of country specific information for different stock option types. However there might be other cases where information varies by country.

For future version it should be verified that there are no other places where an attribute country is being needed. If it would be needed, it should be added to the relevant schemas.

7         Appendix A - Document Version History

 

Date

Description

20.08.2002

Version 1.0

01-Oct-2002

Recommendation

06-Jun-2003

Updated for ESPP and update to stock option schema

19-Jun-2003

Update table for StockSaleConf + TSC suggestions

27-Aug-03

Updated all schema tables and diagrams for ‘remove’ schemas. Updated related doc section to include schema links.

2004-Aug-02

Approved by membership

2006-Feb-28

Approved by Consortium

2007-Apr-15

Approved by Consortium

8         Appendix B – Related Documents

Reference

Link

ExerciseConfirmation schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/ExerciseConfirmation.xsd

RemoveExerciseConfirmations schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/RemoveExerciseConfirmations.xsd

ExercisesRequest schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/ExerciseRequest.xsd

RemoveExerciseRequests schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/RemoveExerciseRequests.xsd

Grant schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/Grant.xsd

RemoveGrants schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/RemoveGrants.xsd

StockDeposit schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/StockDeposit.xsd

RemoveStockDeposits schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/RemoveStockDeposits.xsd

StockPlan schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/StockPlan.xsd

RemoveStockPlans schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/RemoveStockPlans.xsd

StockPlanParticipant schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/StockPlanParticipant.xsd

RemoveStockPlanParticipants schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/RemoveStockPlanParticipants.xsd

StockSaleConfirmation schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/StockSaleConfirmation.xsd

RemoveStockSaleConfirmations schema

http://ns.hr-xml.org/2_5/HR-XML-2_5/Stock/RemoveStockSaleConfirmations.xsd

Effective Dating

http://ns.hr-xml.org/2_5/HR-XML-2_5/CPO/EffectiveDating.html

EntityId

http://ns.hr-xml.org/2_5/HR-XML-2_5/CPO/EntityIdentifiers.html

PersonName

http://ns.hr-xml.org/2_5/HR-XML-2_5/CPO/PersonName.html

ContactMethod

http://ns.hr-xml.org/2_5/HR-XML-2_5/CPO/ContactMethod.html

HR-XML-Extension

http://ns.hr-xml.org/2_5/HR-XML-2_5/CPO/HRXMLExtension.html

PayrollBenefitContributions

http://ns.hr-xml.org/2_5/HR-XML-2_5/Payroll/PayrollBenefitContributions.html

PayrollInstructions

http://ns.hr-xml.org/2_5/HR-XML-2_5/Payroll/PayrollInstructions.html

                                               

 

9         Appendix C – Reference Examples

9.1        German Example

9.1.1        Example for StockPlan

<StockPlan validFrom="2001-01-01" validTo="2010-12-31">

<Id>

  <IdValue>PL-1</IdValue>

</Id>

<CompanyId>

  <IdValue>C-1</IdValue>

</CompanyId>

<PlanType>Stock Options</PlanType>

<Name xml:lang="en">Stock Option Plan 2001</Name>

<Description xml:lang="en">Stock Option Plan 2001 for all employees</Description>

<Stock>

<Id>

<IdValue name="ISIN">US0007164600</IdValue>

</Id>

</Stock>

<BlackOutInformation>

  <Period validFrom="2001-03-15" validTo="2001-03-31" />

  <Period validFrom="2001-09-15" validTo="2001-09-30" />

  <Period validFrom="2002-03-15" validTo="2002-03-31" />

  <Period validFrom="2002-09-15" validTo="2002-09-30" />

  <Period validFrom="2003-03-15" validTo="2003-03-31" />

  <Period validFrom="2003-09-15" validTo="2003-09-30" />

  <Period validFrom="2004-03-15" validTo="2004-03-31" />

  <Period validFrom="2004-09-15" validTo="2004-09-30" />

</BlackOutInformation>

<StockOptionInfo>

      <Ratio>2</Ratio>

  <QualifiedGrantsAllowed>true</QualifiedGrantsAllowed>

  <NonQualifiedGrantsAllowed>true</NonQualifiedGrantsAllowed>

  <QualifiedGrantDefault>Qualified</QualifiedGrantDefault>

  <StockAppreciationRights>notApplicable</StockAppreciationRights>

  <MaximumNumberOfShares>2000000</MaximumNumberOfShares>

  <MinimumNumberToExercise>100</MinimumNumberToExercise>

  <MaximumNumberToExercise>1000</MaximumNumberToExercise>

  <BlocksToExercise>50</BlocksToExercise>

</StockOptionInfo>

</StockPlan>

 

9.1.2        Example for StockPlanParticipant

<StockPlanParticipant>

<Id>

  <IdValue>P-1</IdValue>

</Id>

<Account>

  <IdValue name="Bankleitzahl">67292200</IdValue>

  <IdValue name="Kontonummer">43589456</IdValue>

</Account>

<CompanyId>

  <IdValue>C-1</IdValue>

</CompanyId>

<Name>

  <LegalName>Hans Müller</LegalName>

</Name>

<ContactInfo>

<Telephone>

  <FormattedNumber>+49 6222 4711</FormattedNumber>

</Telephone>

  <InternetEmailAddress>Hans.Müller@firma.de</InternetEmailAddress>

  </ContactInfo>

<AdditionalInfo>

  <DateOfBirth>1966-04-18</DateOfBirth>

  <Nationality>DE</Nationality>

  <HireDate>2000-01-01</HireDate>

  <Employee>true</Employee>

  <Director>false</Director>

  <Insider>true</Insider>

  <PercentOwner>7</PercentOwner>

<WorkLocation validFrom="2000-01-01" validTo="2002-09-30">

  <CountryCode>DE</CountryCode>

  <Region>Hamburg</Region>

  <Municipality>Hamburg</Municipality>

</WorkLocation>

<WorkLocation validFrom="2002-10-01" validTo="9999-12-31">

  <CountryCode>DE</CountryCode>

  <Region>Bayern</Region>

 </WorkLocation>

  <TaxInfo validFrom="2000-01-01" validTo="9999-12-31">

  <TaxType>Einkommenssteuer</TaxType>

  <TaxationLocation>

  <CountryCode>DE</CountryCode>

  </TaxationLocation>

  <Percentage>40</Percentage>

  </TaxInfo>

  </AdditionalInfo>

  <UserArea />

</StockPlanParticipant>

 

9.1.3        Example for Grant

<Grant validTo="2011-02-14" grantDate="2001-02-15" grantCurrency="EUR">

<Id>

  <IdValue>G-1</IdValue>

</Id>

<ParticipantId>

  <IdValue>P-1</IdValue>

</ParticipantId>

<PlanId>

  <IdValue>PL-1</IdValue>

</PlanId>

<Restricted>false</Restricted>

<Repurchasable>false</Repurchasable>

<SharesGranted>500</SharesGranted>

<SharesAccepted>500</SharesAccepted>

<GrantPrice>101</GrantPrice>

<FairMarketValue>123</FairMarketValue>

<VestingInfo>

<Shares>

  <Quantity>250</Quantity>

  <VestingDate>2002-02-15</VestingDate>

  </Shares>

   <Shares>

  <Quantity>250</Quantity>

  <VestingDate>2003-02-15</VestingDate>

  </Shares>

 </VestingInfo>

 </Grant>

 

9.1.4        Example for ExerciseRequest

<ExerciseRequest>

<Id>

  <IdValue>ER-1</IdValue>

</Id>

<ParticipantId>

  <IdValue>P-1</IdValue>

</ParticipantId>

<RequestDate>2002-07-13</RequestDate>

<ExerciseDate>2002-07-14</ExerciseDate>

<ExerciseInfo>

<GrantId>

  <IdValue>G-1</IdValue>

</GrantId>

<OptionsToBeExercised>200</OptionsToBeExercised>

<SharesToBeSold>0</SharesToBeSold>

<SARPercentCashRequested>0</SARPercentCashRequested>

 </ExerciseInfo>

 <ExerciseInstructions>

  <SellToCoverOptions>true</SellToCoverOptions>

  <SellToCoverTaxes>false</SellToCoverTaxes>

  <SellToCoverFees>false</SellToCoverFees>

  <UseSharesForTaxes>false</UseSharesForTaxes>

  <UseSharesFirst>false</UseSharesFirst>

  <SharesSwapped>0</SharesSwapped>

<SaleType>

  <MarketOrder>true</MarketOrder>

</SaleType>

  </ExerciseInstructions>

  </ExerciseRequest>

 

9.1.5        Example for ExerciseConfirmation

<ExerciseConfirmation>

<Id>

  <IdValue>EC-1</IdValue>

  </Id>

<ParticipantId>