Loader Index

Participant Templates:

Template Number	Old Tplt Num	Template Name	Associated Text File Name	Abstract
P1	1	Participant (Add Only)	Newparts.txt	Used to add new participants to the system – NOT USED to modify existing participants
P2	33	Participant Update - Company Info (Officer, etc.)	pptcompanyinfo.txt	Used to modify participant information related to the company such as Section 16 Insider, Officer, etc. as of an effective date
P3	34	Participant Update - Address (Residence and Work)	pptaddress.txt	Used to modify participant information related to the individual such as mailing addresses as of an effective date
P4	28	Terminations	terminations.txt	Used to load a termination for one or more participants
P5	13	YTD Supplemental Comp	Ytdsupcomp.txt	Used to load the year-to-date supplemental compensation for one or more participants Data is assumed to be year-to-date and will override the current system values.
P6	11	Load Tax Withholding	Loadtxwthg.txt	Used to load the year-to-date tax withholding for one or more participants Data is assumed to be year-to-date and will override the current system values.
P7	25	YTD Total Comp	ytdtotalcomp.txt	Used to load the year-to-fate total compensation for one or more participants Data is assumed to be year-to-date and will override the current system values.
P8	21	Participant User Codes	eqhcodes.txt	Used to add custom codes to participants that will display in the download of certain accounting reports. User codes serve no active function in the system.
P9	16	Experience Group	Expgroup.txt	Used to bulk assign participants to an experience group as of an effective date
P10	22	Participant Tax Entity	taxentity.txt	Used to bulk assign participants to a tax entity as of an effective date
P11	27	Broker Assignment	broker.txt	Used to assign a broker to a participant

Transaction Templates:

Template Number	Old Tplt Num	Template Name	Associated Text File Name	Abstract
T1	2	Option Grants	Newawards.txt	Used to add new option-based grants to the system – limited ability to modify existing grants
T2	3	Option Exercise	Newtxns.txt	Used to enter exercises for option-based grants – Limited ability to modify existing Exercises
T3	4	Option Exercise Taxes	Optextax.txt	Used to override the taxes calculated by the system on an option exercise
T4	8	Award Overrides	Newawdovr.txt	Used to modify many provisions of pption-based awards, such as the number of days to exercise once the participant has terminated, expiration date, and whether early exercise is allowed
T5	5	RS Awards	Newrsawards.txt	Used to add new restricted stock awards to the system– limited ability to modify existing awards
T6	26	RS Taxes	rstax.txt	Used to override the taxes calculated by the system on a tax event for a restricted stock award.
T7	30	RS Tax Elections	rstaxpaymethod.txt	Used to load or override the tax payment elections (Withhold to Cover, Sell to Cover, etc.) on restricted stock awards
T8	10	Warrants	Warrants.txt	Used to load warrants
T9	9	Fair Value Details	Newfvdetails.txt	Used to override the fair value (FV) calculated by the system – can be used to load either the entire FV or to override one or more of the parameters and the system will pick up the other parameters as normal. All entries are "as of" an effective date.
T10	12	Vesting Templates	Vstemplate.txt	Used to bulk create generic vesting schedules
T11	14	Vesting Tranche	Splvesting.txt	Used to enter vesting dates on a tranche-by-tranche basis – also used for vesting accelerations
T12	31	Termination Parameters	grantstermpara.txt	Used to set termination parameters for both options and restricted stock award types. It is similar to newawdovr, but includes restricted stock awards and deals only with termination parameters.
T13	32	Award Exchange	awardexchange.txt	Used to bulk enter award exchanges such as option repricings
T14	19	Service Period Overrides	Newsvcovr.txt	Used to override the service period of an option or restricted stock award – Once loaded, the compensation expense will be applied in a straight-line fashion with true-ups for vesting.
T15	35	EVF/EPF	evfepf.txt	Used to enter the expected vest factor (EVF) and the expected performance factor (EPF) for performance-based resticted awards
T16		Historical Tax Event	historicaltaxevent.txt	Used to load restricted award tax events where all information is known and the system is to calculate nothing. The design assumes that an RSTaxes template will be used afterwards to upload the tax items.
T17		Grant Acceptance	grantacceptinfo.txt	Used to upload grant package information and acceptance status for awards already in the system.
T18		Award Labels	awardlabels.txt	Used to add award labels to existing option and restricted stock awards
T19		Expense Override	expenseoverride.txt	Used to load historical expense "as of" a certain date. Certent recommends discussing the use of this template with a support representative if you are unsure as to its proper use. Data loaded from this template is available only in reports and cannot be seen via the user interface
T20		Forfeiture Override	forfeitureoverride.txt	Used to load forfeiture rates at the grant/award level with an as-of date

Other Templates:

Template Number	Old Tplt Num	Template Name	Associated Text File Name	Abstract
M1	6	Security Transactions	Sectrans.txt	Used to add direct security sales into the system. These transactions are recorded for share-tracking purposes only. There is no compensation expense associated with security transactions.
M2	7	Security Market Prices	Newmkprc.txt	Used to bulk enter the fair market value(s) of the company security on given dates – overrides prices already in the table
M3	15	Plan	Planinfo.txt	Used to enter basic plan parameters
M4	17	ISO DD	Isodd.txt	Used to enter ISO Disqualifying Dispositions to be displayed on the ISO DD report
M5	18	Security Issue	Securityinfo.txt	Used to create one or more company securites
M6	23	Security Repurchase	Secrepurchase.txt	Used to enter the repurchase of stock shares by the company from a participant
M7	24	Fiscal Period Setup	fiscalperiod.txt	Used to set up company fiscal periods, which must be set up in order to see expense in future periods
M8	29	Plan FMV Details	planfmvrules.txt	Used to upload the fair market value parameters for a stock incentive plan.
M9		Tax Items	taxitems.txt	Used to load tax items to be used in the taxation of items such as option exercises and restricted award lapses
M10		Participant Financial Account Info	partsfinac.txt	Used by Brokers/Advisors to load Participant Account info (TO BE USED BY THE ADVISOR ROLE ONLY)

ESPP Templates:

Template Number	Template Name	Associated Text File Name	Abstract
E1	ESPP Eligibility	esppelig.txt	Used to load eligibility records
E2	ESPP Enrollment	esppenroll.txt	Used to load new enrollments or to import mid-cycle elections
E3	ESPP Contribution	esppcontrib.txt	Used to load contribution records
E4	ESPP Payroll	espppayroll.txt	Used to upload payroll records
E5	ESPP Disposition	esppdisp.txt	Used to load dispositions
E6	ESPP Historical Purchase	espphistpur.txt	Used to import purchase transactions into the system for historical purchases processed in a client’s former administration system