2 All cash values are either Gross or Net. A copy of the Best Practices document reflecting this Technical Correction is available from The SPARK Institute at: http://www.sparkinstitute.org/comments-and-materials.php. Service providers and employers are encouraged to inform their business partners of this Technical Correction. (October 29, 2008) Question 21: Please provide clarification as to when header and trailer records should be sent. Should one header and one trailer be sent per file or one each per Data Type'?
Answer 21: Header and Trailer records should surround each Part (record type) of the Industry Best Practices data type shared. To clarify, the Parts include: Question 22: OBSOLETE (January 28, 2010) Question 23: What is the intended or recommended frequency for transmitting this data? Answer 23: This question is addressed in The SPARK Institute's Information Sharing Technology Best Practices document (Version 1.0) dated September 4, 2008. See Section G, which states that the preferred current best practices standard specifically with respect to sharing point in time data is that it would be shared with and among those who are expressly authorized by the employer to receive the information, at least monthly, except as otherwise directed by the employer. Whether the point in time information that is shared is for all or some of the participants will be determined on a case by case basis depending on who the information is going to and employer directions. (October 29, 2008) Question 24: How should the "Employer EIN" be reported when the service provider does not capture the information? Should this field be null or left blank? Answer 24: This field is necessary to "tie together" related plans of the same Employer but is not otherwise required. NULL or blank are acceptable. (October 29, 2008) Question 25: Please explain how to format "Pipe Delimited" data? Answer 25: Please refer to the following document regarding Coding "Pipe Delimited" Data. Click Here (October 29, 2008) Question 26: The Header File specified in Part I, Section C of the Best Practices does not include a file description literal along with a Data Type value but both are referenced in Part III, Sections A and B in regards to Census Data (e.g. "04-Remittance"). Is this a misprint, or does the Data Type also refer to the "Data Source" field? Answer 26: The Header Record layout described in Part I, Section C requires that the Data Type (for any section of data being reported) be identified solely as a two digit code (e.g., 04). It does not also require a literal description as was unintentionally implied in Part III, Sections A and B. Data Source is a completely distinct field that identifies the entity sending the data regardless of the data type. (December 1, 2008) Question 27: OBSOLETE (January 28, 2010) Question 28: In Part II, Section G (Loan Amount Available Data) of Version 1.02 of the Best Practices field "Filler1" replaced the field called "Date of Last Loan Distributed." The Best Practices now state that this field "is no longer needed here as this data [i.e., loan issue data] is now required within the loan component data." How do you identify or locate the date of last loan distributed information under this methodology? Answer 28: The "Date of Last Loan Distributed" is no longer required under the Best Practices and the field was redefined as "Filler1". The "Date of Last Loan Distributed" can be derived from the "Loan Initiation Date" component data, i.e., the latest loan initiation date among all the loan components reported is the Date of Last Loan Distributed". (December 1, 2008) Question 29: Should the "Cash Value Date" be the position date of the extracted data? Answer 29: The "Cash Value Date" represents the Trade Date or Valuation Date used to calculate the Cash Value fields reflected in the data file. (December 1, 2008) Question 30: One of the hardship distribution types is "U = Unknown". When this code is used does it mean that a hardship distribution has been taken; however, the reason for the distribution is unknown? Answer 30: Yes. (December 1, 2008) Question 31: OBSOLETE (January 28, 2010) Question 32: What are the high level qualifiers and/or data fields that will be used amongst providers and aggregators to match and aggregate plan level data? Answer 32: For plans where an aggregator is identified: The Aggregator Plan ID. For plans where an aggregator is not identified (i.e., providers sharing information amongst each other): The employer will assign the providers with a unique employer plan ID which The SPARK Institute suggests represents the employer EIN#. If multiple plans exist for the same employer where the aggregation of data needs to take into account all multiple plans of the same employer, then the employer will choose one EIN# to represent all the cases associated with the plan. The following fields are required to be provided:
Question 33: Basic Account Data record - Field "Employee Deferral Cash Value" (Part II, Section A): The instructions in the Best Practices refer to "Pre-Tax or Salary Deferral Contributions." Does that mean Roth amounts should also be included and reported in this field? Answer 33: The Employee Deferral Cash Value field should reflect only the current value of Employee Pre-Tax monies (excluding rollover money and Roth assets). (December 2, 2008) Question 34: OBSOLETE (January 28, 2010) Question 35: Should the "403(b)(7) Cash Value" field in Part II, Section A be reported as the total cash value of a 403(b)(7) custodial account (Type of Account = "007") and/or the cash value of the monies from 403(b)(7) custodial account(s) previously exchanged into a 403(b)(1) annuity contract for accounts as Type of Account = "008"? If the field is intended to refer to Type of Account "008", how should the cash values be reported (i.e., Employee and Employer or Employer only)? Answer 35: Note that the previously named "403(b)(7) Cash Value" field in Part II, Section A has been renamed to "403(b)(7) Employer Cash Value" to clarify its use. This should be populated if the Type of Account = "008". For this type of account, the "403(b)(7) Employer Cash Value" is a subset of the "Employer Cash Value" (reported separately) consisting of the 403(b)(7) Employer amounts if your recordkeeping system combines (b)(1) and (b)(7) information in the Employer Cash Value field or if any (b)(7) Employer dollars have been exchanged into a 403(b)(1) account. Any account that has combined (b)(1) and (b)(7) monies should be reported as Type of Account = 008. This "403(b)(7) Employer Cash Value" amount should be excluded when summing cash value fields to arrive at a total cash value for the account. The loan examples that were posted on our website on November 10, 2008 have been revised accordingly. For any Type of Account other than "008" this cash value field should reflect a default value of "0.00". (December 5, 2008) Question 36: Basic Account Data record - Fields "Rollover Roth Cash Value" and "Roth 403(b) Cash Value" (Part II, Section A): How should these fields be populated in connection with a 403(b) plan and any other plan that allows Roth Rollovers? Answer 36: "Rollover Roth Cash Value" should reflect the current value of the account's Rollover Roth source(s) regardless of the Type of Account (i.e., 403(b) as well as non-403(b) accounts). However, for the field that is currently labeled "Roth 403(b) Cash Value", it should only reflect the value of Roth contributions (i.e., employee Roth contributions) and should NOT include Roth Rollover amounts since such amounts are intended to be reported in a separate cash value field. Equally important is that the field currently labeled "Roth 403(b) Cash Value" applies to any Type of Account (i.e., 403(b) as well as non-403(b)). In order to minimize potential confusion due to the label assigned to this field, The SPARK Institute is releasing Version 1.03 of the Best Practices in which the field previously called Roth 403(b) Cash Value has been renamed as "Roth Cash Value" and its definition clarified. The loan examples that were posted on our website on November 10, 2008 have been revised accordingly. The file structure for Part II of the guidelines remains unchanged. The Best Practices document is available on The SPARK Institute website at: http://www.sparkinstitute.org/comments-and-materials.php. (December 5, 2008) Question 37: Basic Account Data record - "403(b)(7) Cash Value" field (Part II, Section A): If the plan is a 403(b)(7) type should this field and the "Employee Deferral Cash Value" field (Part II, Section A) be populated? Also, if there are Roth monies in the 403(b)(7) account, should they be included in the "403(b)(7) Cash Value" field? Your instructions just say to include "employee and employer." Answer 37: Note that the previously named "403(b)(7) Cash Value" field in Part II, Section A has been renamed to "403(b)(7) Employer Cash Value" to clarify its use. The "Employee Deferral Cash Value" field should be reported regardless of the Type of Account. The "403(b)(7) Employer Cash Value" field should be reported if the Type of Account = "008" (combination 403(b)(1) and 403(b)(7) account). The "403(b)(7) Employer Cash Value" field itself represents the 403(b)(7) subset of the Employer Cash Value for a combination account or the Employer dollars that were part of a prior exchange from a 403(b(7) to a 403(b)(1) account. For any Type of Account other than "008" the "403(b)(7) Employer Cash Value" field should reflect a default value of "0.00". Since this "403(b)(7) Employer Cash Value" field applies strictly to 403(b)(7) Employer cash value, Roth monies would not be included in this field. (December 5, 2008) Question 38: Should the "403(b)(7) Cash Value" field (Part II, Section A) include Roth accounts as well as traditional 403(b) accounts? Answer 38: Note that the previously named "403(b)(7) Cash Value" field in Part II, Section A has been renamed to "403(b)(7) Employer Cash Value" to clarify its use. The "403(b)(7) Employer Cash Value" field should be reported if the Type of Account = "008" (combination 403(b)(1) and 403(b)(7) account). The "403(b)(7) Employer Cash Value" field itself represents the 403(b)(7) portion of Employer cash value for a combination account or the Employer dollars that were part of a prior exchange from a 403(b(7) to a 403(b)(1) account. For any Type of Account other than "008" the "403(b)(7) Employer Cash Value" should reflect a default value of "0.00". Since this "403(b)(7) Employer Cash Value" field applies strictly to 403(b)(7) Employer cash value, Roth monies would not be included in this value. (December 5, 2008) Question 39: The comments section for the "Distribution Type" field in Part IV, Section A of the Best Practices states the following:
Answer 39, Part A: Any rollover distribution as defined by the IRS should be coded as an "05 - Rollover" distribution.
Part B: OBSOLETE (January 28, 2010) Question 40: In Part II, Section A of the Best Practices, when the Cash Value Type is "N", (implying that the Aggregator, or Employer if there is no Aggregator, will add outstanding and/or defaulted loan balances to the Cash Value amount to derive the Gross Total Account Cash Value), should the loan balance amount added be equal to the amount provided in the "Remaining Loan Balance Component" which includes principal and unpaid interest, or should the loan balance added to the Cash Value just represent the outstanding loan balance principal only? Answer 40: Principal and all interest outstanding (when applicable and reflected in the "Remaining Loan Balance Component") should be added to the Net Cash Values to arrive at the Gross Cash Value for the account. (December 5, 2008) Question 41: The comments section for the "Distribution Type" field in Part IV; Section A of the Best Practices includes a code "01 - (Contract) Exchange." Is that code intended to apply to an exchange between providers of the same employer? Answer 41: Yes. This applies to intra-plan contract exchanges between providers of the same employer. (December 18, 2008) Question 42: Part I, Section A of the Best Practices, and Q&A 25 on The SPARK Institute website describes and provides examples for formatting pipe delimited numeric fields. None of the examples show leading zeros in the format (e.g., "|98765.42| versus |00098765.42|. Are leading zeros acceptable? Answer 42: Reported amounts or values that are less than the maximum length of a field do not require leading zeros. The intent is for numeric fields to be variable lengths and thus leading zeros are unnecessary. Accordingly, none of the examples show leading zeros. We note however that certain numeric fields should be fixed length (e.g., dates and social security number). Whether or not leading zeros will be accepted by a particular vendor will depend on the vendor. Please refer to Part I, Section A of the Best Practices, and Q&A 25 on The SPARK Institute website describes and provides examples for formatting pipe delimited numeric fields. (December 18, 2008) Question 43: Part IV of the Best Practices deals with Distributions Made by Vendors Data. If this distribution data is provided daily then based on the data components in the Best Practices there appears to be no provision to report more than one distribution event per day per participant account. If more than one reportable distribution event occurred on the same day what distribution event should we report? Answer 43: Each "Distributions Made" event is reported separately and only once. When two distributions are made on the same date, they should be reported using two "Distributions Made" records, even if they are for the same "Distribution Type". (December 18, 2008) Question 44: Part IV of the Best Practices deals with Distributions Made by Vendors Data. Is there an expectation that if this distribution data is to be provided on a frequency other than daily (e.g. monthly) that the data reported has to be cumulative for the period? If so, is it acceptable to create a full set of distribution data for each occurrence of a distribution if a participant had more than one in that period of time? The guidelines should be clearer on that point. Answer 44: Each "Distributions Made" event should be reported separately and only once. When two distributions are made on the same date, they should be reported using two Distributions Made records, even if they are for the same "Distribution Type". For example, if two loan distributions are made on November 1st and November 15th and the vendor reports data monthly as of November 30th, then two separate "Distributions Made" records, both with "Distribution Type" = 04 (Loan) should be reported. These would not be reported again. (December 18, 2008) Question 45: Part IV of the Best Practices deals with Distributions Made by Vendors Data. The current definition of Distribution Date is "Effective date of the distribution". Could you elaborate more on what "effective date" means? Is it Trade Date or Process Date, for example? Answer 45: The date that should be reported for the "Distribution Date" is the Trade Date of the distribution. However, we note that the distribution's "process date" should be considered when determining whether a distribution itself should be reported for a particular timeframe. If Trade Date alone is used for this reporting consideration any distributions that were back dated would never be reported. (December 18, 2008) Question 46: Part I, Section A. 10 of the Best Practices it states "The "Distributions Made" data now allows for a negative amount to be reported, indicating that a Distribution has been reversed". However, there was no specific explanation on how the negative sign should be reflected in the field (i.e. should a negative amount appear like this |-12345.67| or |12345.67-|? Further, it would appear that a negative sign would appear to take up a position in the field. If that's the case, then the actual maximum amount that could be reported based on current field length would be "9999999.99" and not "99999999.99" as is the case for any other amount or cash value field. If a negative sign is intended to reflect a reversal of a distribution and accounted for in the field length then should a normal distribution also have to reflect a sign (i.e., positive)? Regardless, there is a question of whether a reversal of a distribution should reflect a positive sign rather than a negative since distributions inherently a deduction of monies from an account (i.e., negative money out) and a reversal is a restoration of monies from a prior distribution (i.e., positive money in). Answer 46: A distribution that has been reversed would be reported with a leading negative sign (e.g. |-12345.67|. The negative sign will take up a reportable position so the maximum amount of a distribution reversal would be |-9999999.99|. It is not necessary to utilize a positive sign (+) to denote a normal distribution. (December 18, 2008) Question 47: Part IV of the Best Practices deals with Distributions Made by Vendors Data. For the Distribution Amount field should this be considered the Gross Amount before any deduction of fees and charges? Answer 47: The Distribution Amount that should be reported is the Gross Amount. (December 18, 2008) Question 48: Part IV of the Best Practices deals with Distributions Made by Vendors Data. If a distribution was reversed and both events occurred in the same reporting period (e.g., over a month), is it necessary to report both events or could nothing be reported since the event is a wash? Answer 48: There are two ways this situation can be reported. One alternative is that both the original distribution and its reversal that occurred in the same reporting period are reported. The other alternative is that neither the original distribution nor the reversal is reported since the net effect is that the distribution did not occur in the reporting period. The alternative used can be determined by the investment provider or aggregator based on their preferences and capabilities. (December 18, 2008) Question 49: Part IV of the Best Practices deals with Distributions Made by Vendors Data. Starting in January 2009 if distribution data to be reported covered a period more than daily is there an expectation that distributions prior to 2009 must be reported? Answer 49: This will be based on the needs of the Employer and/or Aggregator and the availability of the data. (December 18, 2008) Question 50: Part IV of the Best Practices deals with Distributions Made by Vendors Data. Why aren't triggering events like Attainment of age 59 1/2, Death and Disability also considered as valid Distribution Types? What about a plan termination? Answer 50: The following Distribution Types were added after this question was originally answered: 07 Death, 08 Disability, 09 RMD, and 10 QDRO (December 19, 2008; revised January 28, 2010) Question 51: Date of Birth is considered a required field. If a participant account does not have a valid Date of Birth (i.e. none on record) what default value should be reflected in this field (i.e. a NULL value or a dummy Date of Birth)? Answer 51: The unavailability or absence of a valid Date of Birth will require the use of a default value. Some suggested default values are "19000101" or "19010101". Recipients of this data will need to be apprised of the use of the default value in order to ensure that the default value is recognized as such by the recipient and not confused for a valid date. (December 18, 2008) Question 52: How should the details in Part II, Section A to G of the Best Practices be reported? Answer 52: All Part II data elements (Sections A to G) should be reported on a single line (variable length record) for each account reported. (December 18, 2008)
|
|
||||||||||||||||