Return to Contents

Complete Exportable Field List

Following are fields of information available for plans in the database. Any or all fields can be exported into your word-processing, spreadsheet, contact manager or other software by pressing the Export button on the List or Detail screens.

Field GroupDescriptionName
Plan Feature Codespl_feat_dol
ActuaryActuary's Addressac_address
ActuaryName of Actuarial Firmac_firm
ActuaryActuary Nameactname
ActuaryRatio of current assets to current liabilityB2C
ActuaryACTRL-NORMAL-COST-AMT 9bB9B
ActuaryFunding DeficiencyB9P
ActuaryActuary's Enrollment Numberbenrollno
FinancialAvg Acct Balance Per Participantpl_apb
FinancialAvg Contributions Per Participantpl_apc
FinancialEmployer contributionspl_contemp
FinancialParticipant Contributionspl_contpart
FinancialTotal Contributionspl_conttotal
FinancialTotal corporate debt and common stockpl_corpsec
FinancialEmployer securitiespl_empsec
FinancialFunding and benefit codepl_fundcode
FinancialFunds in insurance company general acctpl_insac
FinancialMortgages-residentialpl_mortres
FinancialPartnerships/Joint Vent.pl_partjv
FinancialRegulated Investment Co.pl_reginvco
FinancialReal Estate-income producingpl_reincprod
FinancialTotal Assetspl_totassets
FinancialTotal incomepl_totincome
FinancialPerformance Ratingpl2_invperf
InsuranceCity of Insurance Brokerbr_city
InsuranceBroker Commissionsbr_commiss
InsuranceName of Insurance Brokerbr_name
InsuranceName of Insurance Carrierins_carrier
InsuranceBeginning of policy yearins_date_beg
InsuranceEnd of policy yearins_date_end
InsuranceNumber of individuals covered by plan (insurance)ins_ind_cov
InsurancePayments to Carrierins_totprem
InsuranceWelfare Benefit Prem.ins_wbprem
InsuranceContract typewbpind
InvestmentsEntityinv_entcd
InvestmentsFund Nameinv_entname
InvestmentsValue Investedinv_invamt
InvestmentsInvestment providerinv_sponsor
PlanAccounting FirmAcctFirm
PlanCorrective Distributionpl_corrdist
PlanEffective Date of Planpl_date
PlanPlan Year-Endpl_date_end
PlanType of Plan Entitypl_etype
PlanPlan Featurespl_features
Plan401(k) Indicator (Yes/No)pl_k401
PlanPlan Namepl_name
PlanParticipation Ratepl_part_rate
PlanTotal Participantspl_partic
PlanPlan Numberpl_pno
PlanPlan Typepl_ptype
PlanRetirement Plan Typepl_rtype
PlanTotal Employeespl_total_emp
PlanWelfare Benefit Plan Typespl_wtype
PlanTotal Active Participantspl2_actpartic
PlanPartic with acct balpl2_particacct
SponsorMetropolitan areaMSA
SponsorTitle or suffix of first contactpl_cont_title
SponsorSponsor's phone numberpl_phone
SponsorSponsor's first contact namepl_signator
SponsorSponsor's Business Codessp_bs_code
SponsorBusiness categorysp_bs_ctgy
SponsorSponsor's citysp_city
SponsorCountysp_county
SponsorSponsor's Federal ID#sp_fedid
SponsorSponsor's namesp_name
SponsorSponsor's statesp_state
SponsorSponsor's street addresssp_street
SponsorSponsor's zip codesp_zipcode
Svc.ProviderAdministrator's namead_name
Svc.ProviderService Provider ID#pr_fedid
Svc.ProviderName of Service Providers(1-13)pr_name
Svc.ProviderService Provider Feessp_fees
Svc.ProviderName of Plan Trusteetr_name1
Schedule BActuary's phone numberac_phone
Schedule BAdministrator contact namead_assign
Schedule BAdministrator's cityad_city
Schedule BAdministrator's phone numberad_phone
Schedule BAdministrator's statead_state
Schedule BAdministrator's street addressad_street
Schedule BAdminstrator's zip codead_zipcode
Schedule BACTRL-ACCUM-FNDNG-DEFN-AMT 10B10
Schedule BACTRL-CHG-ACTRL-ASSUMP-CURR-IND 11B11
Schedule BACTRL-RPA94-CURR-LIAB-AMT 12bB12B
Schedule BACTRL-RQR-ADJ-VAL-ASSETS-AMT 12cB12C
Schedule BACTRL-RQR-FNDED-CURR-LIAB-PRCNT 12dB12D
Schedule BACTRL-RQR-FUNFND-CURR-LIAB-AMT 12eB12E
Schedule BACTRL-LIAB-ATTRIBUTE-AMT 12fB12F
Schedule BACTRL-OUTSTD-UNFND-LIAB-AMT 12gB12G
Schedule BACTRL-1ST-UNFND-NEW-LIAB-AMT 12hB12H
Schedule BACTRL-RQR-UNFND-NEW-LIAB-PRCNT 12iB12IPCT
Schedule BACTRL-2ND-UNFND-NEW-LIAB-AMT 12iB12ITOTAL
Schedule BACTRL-RQR-UNFND-OLD-LIAB-AMT 12jB12J
Schedule BACTRL-DEFICIT-REDUCT-AMT 12kB12K
Schedule BACTRL-FNDNG-ACCT-DEFICIT-AMT 12lB12L
Schedule BACTRL-BNFT-PD-UNPRED-AMT 12m(1)B12M1
Schedule BACTRL-RQR-UNFND-CURR-LIAB-PRCNT 12m(2)B12M2
Schedule BACTRL-TOT-PREV-PRODUCT-AMT 12M3B12M3
Schedule BACTRL-TOT-PREV-PRODUCT-AMT 12m(3)B12M4
Schedule BACTRL-1ST-AMORTZ-EVENT-LIAB-AMT 12m(4)B12M5
Schedule BACTRL-RPA94-ADDITIONAL-AMT 12m(5)B12M6
Schedule BACTRL-GREATEST-PREV-AMT 12m(6)B12M7
Schedule BACTRL-PRELIM-ADDNL-FNDNG-AMT 12nB12N
Schedule BACTRL-CONTRIB-CURR-LIAB-AMT 12oB12O
Schedule BACTRL-PRELIM-NEITHER-RULE-AMT 12pB12P
Schedule BACTRL-FINAL-TRANSIT-RULE-AMT 12qB12Q
Schedule BACTRL-FINAL-OPTIONAL-RULE-AMT 12rB12R
Schedule BACTRL-OPTIONAL-TRANSIT-RULE-AMT 12sB12S
Schedule BACTRL-ADDNL-FNDNG-CHRG-PR-AMT 12tB12T
Schedule BACTRL-ADJ-ADDNL-FNDNG-AMT 12uB12UAMT
Schedule BACTRL-ADJ-ADDNL-FNDNG-PRCNT 12uB12UPCT
Schedule BOBRA 87 CLB13A
Schedule BAdjusted value of assetsB13B
Schedule BACTRL-FNDED-CURR-LIAB-PRCNT 13cB13C
Schedule BACTRL-UNFND-CURR-LIAB-AMT 13dB13D
Schedule BACTRL-OLD-LIAB-OUTSTD-BAL-AMT 13eB13E
Schedule BACTRL-LIAB-UNPREDICT-EVENT-AMT 13fB13F
Schedule BACTRL-UNFND-NEW-LIAB-AMT 13gB13G
Schedule BACTRL-UNFND-NEW-LIAB-02-AMT 13hB13HAMT
Schedule BACTRL-UNFND-NEW-LIAB-PRCNT 13hB13HPCT
Schedule BACTRL-UNFND-OLD-LIAB-AMT 13iB13I
Schedule BACTRL-DEFICIT-RDC-CONTRIB-AMT 13jB13J
Schedule BACTRL-NEW-AMORTZ-CHRG-AMT 13kB13K
Schedule BACTRL-BNFT-PAID-EVENT-AMT 13l(1)B13L1
Schedule BACTRL-UNFND-CURR-LIAB-PRCNT 13l(2)B13L2
Schedule BACTRL-UNPREDICT-EVENT-PROD-AMT 13L3B13L3
Schedule BACTRL-UNPREDICT-EVENT-PROD-AMT 13l(3)B13L4
Schedule BACTRL-2ND-AMORTZ-EVENT-AMT 13l(4)B13L5
Schedule BACTRL-GREATER-PROD-OR-LIAB-AMT 13l(5)B13L6
Schedule BACTRL-ADDNL-FNDNG-CHRG-02-AMT 13mB13M
Schedule BACTRL-AST-NEED-INCR-LIAB-AMT 13nB13N
Schedule BACTRL-LESS-OF-CHRG-OR-AST-AMT 13oB13O
Schedule BACTRL-INT-ADJ-AMT 13pB13P
Schedule BACTRL-ADDNL-FNDNG-CHRG-03-AMT 13qB13Q
Schedule BACTRL-INIT-FND-CURR-LIAB-PRCNT 14aB14A
Schedule BACTRL-TARGET-PRCNT 14bB14B
Schedule BACTRL-TARGET-AMT 14cB14C
Schedule BACTRL-ADDNL-FNDNG-CHRG-04-AMT 14dB14D
Schedule BACTRL-TRANS-RULE-ADDNL-AMT 14eB14E
Schedule BActuarial valuation dateB1A
Schedule BCurrent value of assetsB1B1
Schedule BACTRL-AST-FNDNG-STD-AMT 1b(2)B1B2
Schedule BACTRL-ACCR-LIAB-GAIN-MTHD-AMT 1c(1)B1C1
Schedule BACTRL-UNFND-LIAB-MTHD-BASE-AMT 1c(2)(a)B1C2A
Schedule BACTRL-ACCR-LIAB-AGE-MTHD-AMT 1c(2)(b)b1c2b
Schedule BACTRL-NORM-COST-AGE-MTHD-AMT 1c(2)(c)B1C2C
Schedule BACTRL-CURR-LIAB-PRE-PARTCP-AMT 1d(1)B1D1
Schedule BACTRL-RPA94-INFO-CURR-LIAB-AMT 1d(2)(a)B1D2A
Schedule BACTRL-RPA94-EXPT-INCR-LIAB-AMT 1d(2)(b)B1D2B
Schedule BACTRL-CURR-LIAB-HIGH-INT-AMT 1d(2)(c)B1D2C
Schedule BACTRL-RPA94-EXPT-RELEASE-LIAB-AMT 1d(2)(d)B1D2D
Schedule BACTRL-OBRA87-CURR-LIAB-AMT 1d(3)(a)B1D3A
Schedule BACTRL-OBRA87-EXPT-INCR-LIAB-AMT 1d(3)(b)B1D3B
Schedule BACTRL-OBRA87-EXPT-RELEASE-LIAB-AMT 1d(3)(c)B1D3C
Schedule BACTRL-EXPECT-PLAN-PAYMENT-AMT 1d(4)B1D4
Schedule BCurrent value of assets as reported on 5500B2A
Schedule BNumber of retireesB2B1I
Schedule BRetirees and beneficiaries vested benefitsB2B1II
Schedule BRetirees and beneficiaries total benefitsB2B1III
Schedule BNumber of terminated individualsB2B2I
Schedule BTerminated participants vested benefitsB2B2II
Schedule BTerminated participants total benefitsB2B2III
Schedule BNumber of active participantsB2B3I
Schedule BActive participants vested benefitsB2B3II
Schedule BActive participants total benefitsB2B3III
Schedule BTotal participantsB2B4I
Schedule BTotal vested participantsB2B4II
Schedule BTotal benefitsB2B4III
Schedule BACTRL-TOT-EMPLR-CONTRIB-AMT 3(b)B3BTOTAL
Schedule BACTRL-TOT-EMPLEE-CONTRIB-AMT 3(c)B3CTOTAL
Schedule BACTRL-OTH-FND-CURR-LIAB-PRCNT 4aB4A
Schedule BACTRL-1ST-LIQUIDITY-SHORT-AMT 4b(1)B4B1
Schedule BACTRL-2ND-LIQUIDITY-SHORT-AMT 4b(2)B4B2
Schedule BACTRL-3RD-LIQUIDITY-SHORT-AMT 4b(3)B4B3
Schedule BACTRL-4TH-LIQUIDITY-SHORT-AMT 4b(4)B4B4
Schedule BACTRL-CHG-FNDNG-MTHD-IND 5iB5I
Schedule BACTRL-CHG-REVENUE-PROC-IND 5jB5J
Schedule BACTRL-CHG-FNDNG-MTHD-DATE 5kB5K
Schedule BACTRL-CURR-LIAB-RPA-PRCNT 6a(1)B6A1
Schedule BACTRL-CURR-LIAB-OBRA-PRCNT 6a(2)B6A2
Schedule BACTRL-WEIGHTED-RTM-AGE 6bB6B
Schedule BACTRL-RATE-SPEC-INS-POST-IND 6cB6CPOST
Schedule BACTRL-RATE-SPEC-INS-PRE-IND 6cB6CPRE
Schedule BACTRL-MORTALITY-MALE-POST-CODE 6d(1)B6D1MPOST
Schedule BACTRL-MORTALITY-MALE-PRE-CODE 6d(1)B6D1MPRE
Schedule BACTRL-MORTALITY-FEM-POST-CODE 6d(2)B6D2FPOST
Schedule BACTRL-MORTALITY-FEM-PRE-CODE 6d(2)B6D2FPRE
Schedule BACTRL-VALUATION-INT-POST-PRCNT 6eB6EPOST
Schedule BACTRL-VALUATION-INT-PRE-PRCNT 6eB6EPRE
Schedule BACTRL-EXPENSE-LOAD-POST-PRCNT 6fB6FPOST
Schedule BACTRL-EXPENSE-LOAD-PRE-PRCNT 6fB6FPRE
Schedule BACTRL-WTHDRWL-25-FEM-PRCNT 6g(1)B6G1FEMALE
Schedule BACTRL-WTHDRWL-25-MALE-PRCNT 6g(1)B6G1MALE
Schedule BACTRL-WTHDRWL-40-FEM-PRCNT 6g(2)B6G2FEMALE
Schedule BACTRL-WTHDRWL-40-MALE-PRCNT 6g(2)B6G2MALE
Schedule BACTRL-WTHDRWL-55-FEM-PRCNT 6g(3)B6G3FEMALE
Schedule BACTRL-WTHDRWL-55-MALE-PRCNT 6g(3)B6G3MALE
Schedule BACTRL-SAL-SCALE-FEM-PRCNT 6hB6HFEMALE
Schedule BACTRL-SAL-SCALE-MALE-PRCNT 6hB6HMALE
Schedule BACTRL-INVST-RETURN-PRCNT 6iB6I
Schedule BACTRL-AMORTZ-BASE-01-CODE 7(1)B71FIRST
Schedule BACTRL-AMORTZ-BASE-02-CODE 7(1)B71SECOND
Schedule BACTRL-AMORTZ-BASE-03-CODE 7(1)B71THIRD
Schedule BACTRL-AMORTZ-INIT-BAL-01-AMT 7(2)B72FIRST
Schedule BACTRL-AMORTZ-INIT-BAL-02-AMT 7(2)B72SECOND
Schedule BACTRL-AMORTZ-INIT-BAL-03-AMT 7(2)B72THIRD
Schedule BACTRL-AMORTIZATION-01-AMT 7(3)B73FIRST
Schedule BACTRL-AMORTIZATION-02-AMT 7(3)B73SECOND
Schedule BACTRL-AMORTIZATION-03-AMT 7(3)B73THIRD
Schedule BACTRL-FNDNG-DEFN-WVR-DATE 8aB8A
Schedule BACTRL-ALT-MTHD-RULE-CODE 8bB8B
Schedule BACTRL-SCH-ACTIVE-PARTCP-DATA-IND 8cB8C
Schedule BACTRL-PR-YR-FNDNG-DEFN-AMT 9aB9A
Schedule BACTRL-NOT-WVRS-OUTSTD-AMT 9c(1)B9C1OUTBAL
Schedule BACTRL-NOT-WVRS-AMT 9c(1)B9C1TOTAL
Schedule BACTRL-FNDNG-WVRS-OUTSTD-AMT 9c(2)B9C2OUTBAL
Schedule BACTRL-FNDNG-WVRS-AMT 9c(2)B9C2TOTAL
Schedule BACTRL-FNDNG-CHRGS-INT-AMT 9dB9D
Schedule BACTRL-ADDNL-INT-LATE-QRTLY-AMT 9eB9E
Schedule BACTRL-ADDNL-FNDNG-PRT2-AMT 9fB9F
Schedule BACTRL-TOT-CHARGES-AMT 9gB9G
Schedule BACTRL-PR-YR-CREDIT-BALANCE-AMT 9hB9H
Schedule BACTRL-EMPLR-CONTRIB-SCH-B-AMT 9iB9I
Schedule BACTRL-AMORTZ-CR-OUTSTD-BAL-AMT 9jB9JOUTBAL
Schedule BACTRL-AMORTZ-CREDITS-AMT 9jB9JTOTAL
Schedule BACTRL-INT-APPLICABLE-AMT 9kB9K
Schedule BACTRL-ERISA-FFL-ACCR-LIAB-AMT 9l(1)B9L1
Schedule BACTRL-OBRA87-FFL-CURR-LIAB-AMT 9l(2)B9L2
Schedule BACTRL-RPA97-OVRRIDE-CURR-AMT 9l(3)B9L3
Schedule BACTRL-FFL-CREDIT-OBRA-AMT 9l(4)B9L4
Schedule BACTRL-ADDNL-CREDIT-AMT 9l(5)B9L5
Schedule BACTRL-WAIVED-FNDNG-DEFN-AMT 9m(1)B9M1
Schedule BACTRL-OTHER-CREDITS-FFL-AMT 9m(2)B9M2
Schedule BACTRL-TOT-CREDITS-AMT 9nB9N
Schedule BACTRL-CREDIT-BAL-AMT 9oB9O
Schedule BACTRL-FNDNG-CHRG-RECNCL-AMT 9q(1)B9Q1
Schedule BACTRL-INT-CHRG-RECNCL-AMT 9q(2)B9Q2
Schedule BACTRL-RECNCL-OUTSTD-BAL-AMT 9q(3)(a)B9Q3A
Schedule BACTRL-RECONCILIATION-AMT 9q(3)(b)B9Q3B
Schedule BACTRL-TOT-RECONCILIATION-AMT 9q(4)B9Q4
Schedule BActuarial cost method usedBLNE5
Schedule BACTRL-OTH-COST-TEXT 5h Other TextBLNE5DESC
Schedule BAddress of insurance brokerbr_address
Schedule BBroker feesbr_fees
Schedule BState of insurance brokerbr_state
Schedule BZipcode of insurance brokerbr_zipcode
Schedule BItem FITEMF
Schedule BAcquisition indebtednesspl_acqdebt
Schedule BBenefits payablepl_benpay
Schedule BBldgs & other prop in plan operations pl_bldgused
Schedule BCash on handpl_cash
Schedule BCorporate debt otherpl_cdebtot
Schedule BCorporate debt preferedpl_cdebtpf
Schedule BCommon / collective trust investments pl_comcoltr
Schedule BCorporate stock-commonpl_commstock
Schedule BCourtesy for first contactpl_cont_courtesy
Schedule BFirst name of first contactpl_cont_first
Schedule BLast name of first contactpl_cont_last
Schedule BMiddle initial of first contactpl_cont_middle
Schedule BSecond contact name pl_cont_name2
Schedule BThird contact name pl_cont_name3
Schedule BNon-cash contributions pl_contncash
Schedule BOther contributionspl_contoth
Schedule BYear plan terminatedpl_date_term
Schedule BCapital gains realizedpl_earncapr
Schedule BCapital gains unrealized pl_earncapun
Schedule BTotal dividend incomepl_earndiv
Schedule BTotal interest incomepl_earnint
Schedule BTotal other income pl_earnoth
Schedule BTotal rentspl_earnrent
Schedule BTotal investment earnings pl_earntotal
Schedule BNumber of eligible employees pl_elig_emp
Schedule BEmployer property pl_empprop
Schedule BAmount of ESOP dividends paidpl_esopdiv
Schedule BAdmin exp - accountingpl_expacct
Schedule BAdmin exp - actuarypl_expactry
Schedule BAdmin exp - contract administratorpl_expadmin
Schedule BPayments to insurance carrierpl_expins
Schedule BInterest expense pl_expint
Schedule B Admin exp - investment advisorpl_expinvadv
Schedule BAdmin exp - legalpl_explegal
Schedule BAdmin exp - other pl_expoth
Schedule BAdmin exp - salaries & allowancespl_expsalary
Schedule BTotal administration expensespl_exptotadm
Schedule BTotal plan expensespl_exptotpln
Schedule BAdmin exp - trusteepl_exptrust
Schedule BAdmin exp - valuation & appraisalpl_expvalap
Schedule BSponsor's fax number pl_fax
Schedule BU.S. gov't securitiespl_govsc
Schedule B103-12 investment arrangementspl_invarr
Schedule BOther loanspl_loanoth
Schedule BMaster trustpl_masttrst
Schedule BMortgages-commercialpl_mortcom
Schedule BNet assetspl_netassets
Schedule BOperating expense payablepl_operpay
Schedule BType of CPA audit opinionpl_optype
Schedule BOther assetspl_othasset
Schedule BOther benefit paymentspl_othbenpay
Schedule BOther investmentspl_othinv
Schedule BOther liabilities pl_othliab
Schedule BParticipant loan-mortgagepl_partlnmort
Schedule BParticipant loan-otherpl_partlnoth
Schedule BPayments to participantspl_paytopart
Schedule BNet income of planpl_planincome
Schedule BPooled separate accounts pl_poolsepac
Schedule BCorporate stock-preferredpl_prefstock
Schedule BAccounts receivablepl_recbles
Schedule BReal estate-non producingpl_renonprod
Schedule BTax Period (History)pl_tax_prd
Schedule BTotal general investmentspl_totgninv
Schedule BTotal liabilitiespl_totliab
Schedule BExpenses pro feespl2_expproffee
Schedule BFidelity bond Amtpl2_fdltybdamt
Schedule BRetired or separated receiving benefitspl2_retrcvpart
Schedule BREGPROMBOXREGPROMBOX
Schedule BSponsor's delivery point codesp_delptcode
Schedule BSponsor's zip 4sp_zip4
Schedule BService descriptionsv_code
Schedule BName of second trusteetr_name2
Schedule BName of third trusteetr_name3
Schedule BName of fourth trusteetr_name4
Schedule BName of fifth trusteetr_name5
Schedule BName of sixth trusteetr_name6
Schedule BAdministrative expenses (history)ye_adm_exp
Schedule BTotal assets (history)ye_assets
Schedule BEmployer contributions (history)ye_empl_contr
Schedule BPlan year end (history)ye_end
Schedule BTotal income (history)ye_income
Schedule BInvestment earnings (history)ye_inv_earn
Schedule BParticipant contributions (history)ye_part_contr
Schedule BTotal active participants (history)ye_partic
Schedule BPayments to participants (history)ye_paytopart
Schedule BTotal plan expenses (history)ye_total_exp
undefinedACTRL-GATEWAY-PRCNT 12aB12A
undefinedACTRL-GATEWAY-PRCNT 12AB12A

Return to Contents

Complete Riskcode Listing

CodeDescription
A0#Initial plan filing
A1#Amended report filed
A2#Final report
A3#Self prepared 5500 document
A4#Participants who are separated from service
A5#Former employees with deferred vested benefits
A6#Pay related benefits
A7#Flat dollar benefits
A8#Cash balance or similar plan
A9#Floor-offset plan
AA#Code 401(h) arrangement
AB#Code section 414(k) arrangement.
AC#Plan covered by PBGC.
AD#Terminated PBGC plan
AE#Frozen plan
AF#Plan entity type missing from original filing
AG#Age weighted or new comparability plan
AH#Target benefit plan
AI#Money purchase plan
AJ#Offset plan related to other arrangement of sponsor
AK#Profit sharing plan subject to 401a regulations
AL#ESOP (Employee stock ownership plan)
AM#No 404c election filed
AN#Total participant-directed account plan
AO#Partial participant-directed account plan
AP#Stock bonus plan
AQ#Plan has a 401(k) feature
AR#Plan is a 401(m) arrangement
AS#Plan is a 403(b)(1) arrangement
AT#Plan is a 403(b)(7) account
AU#Plan is a 408 account or annuity
AV#ESOP (Leveraged)
AW#ESOP (Sub-S Corp)
AX#Participant-directed brokerage accts as an investment option
AY#Maintained outside US for nonresident aliens
AZ#Covers self-employed individuals
B0#Plan not intended to qualify for exemption
B1#Plan is a master plan
B2#Plan is a prototype plan
B3#Sponsor leased employees
B4#Single-participant plan
B5#Plan is a member of a controlled group
B6#Plan is a 401(m) arrangement
B7#Former employees with deferred vested benefits
B8#Plan has loans in default or nonexempt transactions
B9#Schedule P not filed
BA#Plan holds other hard to value assets
BB#Plan holds real estate
BC#Plan holds employer securities
BC#Plan holds employer securities
BE#Plan has low investment returns
BF#Plan CPA issued a "Disclaimer" opinion
BG#Plan CPA issued an "Adverse" opinion
BH#Required CPA opinion not filed
BI#CPA name not listed
BK#Plan has loans in default
BL#Plan held leases in default
BL#Plan held leases in default
BO#Insufficient fidelity bond
BO#Insufficient fidelity bond
BQ#Plan may not be covered by fidelity bond
BQ#Plan may not be covered by fidelity bond
BR#
BT#Plan held assets of an unknown value
BV#Assets may be overly concentrated in a single investment
BW#Resolution to terminate has been adopted
BX#Plan had low return on investment assets
BY#Plan holds partnership or joint venture assets
BZ#Plan holds employer real estate
C0#Plan holds other real estate assets
C0#Plan holds other real estate assets
C1#Plan holds employer securities
C2#Plan holds tangible personal property
C3#Employer failed to transmit contributions on time
C3#Employer failed to transmit contributions on time
C4#Plan loans in default
C5#Plan engaged in nonexempt transactions
C5#Plan engaged in nonexempt transactions
C7#Schedule P not filed
C8#Compliance issue resulting from failure to file Schedule P
C9#The plan has employees benefiting from QSLOBS
CA#Minimum coverage requirements not applied
CB#Fraud or dishonesty indicated in filing
CB#Fraud or dishonesty indicated in filing
CC#Plan assets may be difficult to value
CD#Plan received noncash contributions
CD#Plan received noncash contributions
CE#Plan was once heavily over weighted in a single investment
CF#A resolution to terminate the plan has been adopted
CG#Participants not provided with adequate trust information
CH#Plan has qualifying separate lines of business
CI#Plan has low participation rate
CJ#Low participation rate
CK#Insurance broker or agent lives out of state
CL#404c election in place
CM#Participant directed accounts without 404c election
CN#Schedule SSA required but not filed
CO#Possibly has participant directed accounts without 404c election
CP#
CQ#Per plan filing a corrective distribution was made
CR#Per plan filing, participants have no QDIA investment options to choose from. ERISA section 404(c) and the corresponding DOL regulations define how a plan sponsor can establish protective relief from liability as a fiduciary for investment decisions made by employees in participant-directed 401(k) plans. When participants fail to make investment elections and a decision must be made to invest their participant-directed contributions, plan fiduciaries must step into the decision-making role. Without an approved QDIA, plan fiduciaries remain potentially liable for losses when a participant fails to actively direct investments.

Return to Contents

Complete Plan Feature Code Listing

CodeDescription
!Separate accounts for health benefits. 401(h) arrangement
#Automatic Enrollment
$QDIA
(Employer has retirement but no health plan
*Employer has health but no retirement plan
<Insufficient fidelity bond
@"Sponsor has multiple plans"
^Sponsor did not file form 5500 for a health plan
~Professional without advanced plan feature
0Sponsor is payor of benefits
1Sponsor did not file form 5500 for a welfare benefit plan
2Sponsor has a money purchase and a profit sharing plan
3Participant directed brokerage accounts
4No 404(c) election indicated
5DC DB 403(b)
6Frozen plan
7Cash Balance Plan
8Sponsor has both DB and DC plan(s)
9Sponsor has an ESOP and is an S corporation
AESOP
BLeveraged ESOP
CParticipant-directed account plan
DPension plan maintained outside the United States
EPlan covering self-employed individuals
FMember of a controlled group
G401(k) plan
HPlan has an out of state advisor
IAge weighted and highly compensated plan
JMaster plan
KPrototype plan
LRegional prototype
MInitial plan filing
NFinal plan filing
OSelf trusteed plans
PPlan holds non-publicly traded securities
QPlan expenses paid by plan sponsor
RPlan assets require appraisal
SPlan requires CPA audit
TPlan terminated
UCollectively bargained plan
VPublicly traded company
WSponsor did not file form 5500 for a 401(k) plan
XOne participant plan
YSponsor did not file form 5500 for a defined contribution plan
ZSponsor listed as legal administrator