Civic Intelligence
Filing

Migration Software Savings and Retirement Plan

Migration Software Systems Ltd. • EIN 77-0226388 • Plan year 2000

Company ProfileSource Archive
Filing Insights

Participants

Down

87 → 40

-47 • -54.02%

Assets

Down

$2,690,897 → $2,396,927

-$293,970 • -10.92%

Investment Management Fee

-

Admin expenses - • Total expenses $185,771

Filing Details

Context
Net investment result
$-293,970
Pension payor EIN
06-1332405

Status Flags

Fidelity bond in place

Yes

Limited-scope audit performed

Not reported

Contributions transmitted on time

Not reported

Participant loans in default

No

Leases in default

No

Reportable party-in-interest issues

Not reported

Loss discovered during year

No

Assets with undetermined value

No

Non-cash contributions

No

Assets held for investment

Not reported

5% transactions reported

Not reported

All plan assets distributed

No

Benefits paid when due

Not reported

Plan blackout period

Not reported

Plan termination resolution adopted

No

Counterparties

Company Timeline

This filing is highlighted inside the broader sponsor history.

Year / FilingFilingsParticipantsAssetsContributionsContrib./Participant
200514$617,628$0-
Migration Software Savings and Retirement Plan-4$617,628--
200217$1,040,799$81,039$11,577iApproximate average salary by contribution assumption: employee only about $289,425 at 4% or $192,950 at 6%; with 50% employer match about $192,950 at 4% or $128,633 at 6%; with 100% employer match about $144,713 at 4% or $96,475 at 6%.
Migration Software Savings and Retirement Plan-7$1,040,799$81,039$11,577iApproximate average salary by contribution assumption: employee only about $289,425 at 4% or $192,950 at 6%; with 50% employer match about $192,950 at 4% or $128,633 at 6%; with 100% employer match about $144,713 at 4% or $96,475 at 6%.
2001137$1,675,525$256,451$6,931iApproximate average salary by contribution assumption: employee only about $173,278 at 4% or $115,518 at 6%; with 50% employer match about $115,518 at 4% or $77,012 at 6%; with 100% employer match about $86,639 at 4% or $57,759 at 6%.
Migration Software Savings and Retirement Plan-37$1,675,525$256,451$6,931iApproximate average salary by contribution assumption: employee only about $173,278 at 4% or $115,518 at 6%; with 50% employer match about $115,518 at 4% or $77,012 at 6%; with 100% employer match about $86,639 at 4% or $57,759 at 6%.
2000140$2,396,927$336,318$8,408iApproximate average salary by contribution assumption: employee only about $210,199 at 4% or $140,133 at 6%; with 50% employer match about $140,133 at 4% or $93,422 at 6%; with 100% employer match about $105,099 at 4% or $70,066 at 6%.
Migration Software Savings and Retirement PlanCurrent40$2,396,927$336,318$8,408iApproximate average salary by contribution assumption: employee only about $210,199 at 4% or $140,133 at 6%; with 50% employer match about $140,133 at 4% or $93,422 at 6%; with 100% employer match about $105,099 at 4% or $70,066 at 6%.
1999175$2,690,897$329,882$4,398iApproximate average salary by contribution assumption: employee only about $109,961 at 4% or $73,307 at 6%; with 50% employer match about $73,307 at 4% or $48,871 at 6%; with 100% employer match about $54,980 at 4% or $36,654 at 6%.
Migration Software Savings and Retirement Plan-75$2,690,897$329,882$4,398iApproximate average salary by contribution assumption: employee only about $109,961 at 4% or $73,307 at 6%; with 50% employer match about $73,307 at 4% or $48,871 at 6%; with 100% employer match about $54,980 at 4% or $36,654 at 6%.
Schedule Details

Schedule A

Row 1
Filing Id
84037033093522
Form Id
12157850
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
30372033093020002
Ins Broker 01 Name
SEDGWICK NOBLE LOWNDES
Ins Broker 01 Street Addr
160 SPEAR STREET
Ins Broker 01 City
SAN FRANCISCO
Ins Broker 01 State
CA
Ins Broker 01 ZIP Code
94105
Ins Broker Comm Pd 01 Amount
$13,060
Ins Broker Fees Pd 01 Amount
$0
Ins Broker 01 Code
3
Row 2
Ins Carrier Name: CONNECTICUT GENERAL LIFE INS CO
Filing Id
84037033093522
Form Id
12157850
Schedule A EIN
77-0226388
Schedule A Plan Num
001
Schedule A Plan Year Begin Date
2000-01-01
Schedule A Tax Period
20001231
Ins Carrier Name
CONNECTICUT GENERAL LIFE INS CO
Ins Carrier EIN
06-0303370
Ins Carrier Naic Code
62308
Ins Contract Num
37200-001
Ins Prsn Covered End of year Count
56
Ins Policy From Date
2000-01-01
Ins Policy To Date
2000-12-31
Ins Broker Comm Total Amount
$13,060
Ins Broker Fees Total Amount
$0
Pension End of year Gen Account Amount
$117,120
Pension End of year Sep Account Amount
$2,157,582
Pension Prem Paid Total Amount
$0
Pension Unpaid Premium Amount
$0
Pension Contract Cost Amount
$0
Pnsn Type Unalloc Cntrct I
4
Pension Oth Unalloc Type Text
GUARANTEED GENERAL ACCOUNT CONTRACT
Pension End Prev Bal Amount
$83,700
Pension Contribution Dep Amount
$13,331
Pension Divnd Cr Dep Amount
$0
Pension Interest Cr Dur Yr Amount
$4,341
Pension Transfer From Amount
$0
Pension Other Amount
$30,808
Pension Other Text
PRIN & INTEREST, NONVESTED, CTA
Pension Total Additions Amount
$48,480
Pension Total Bal Addn Amount
$132,180
Pension Bnfts Dsbrsd Amount
$154
Pension Admin Chrg Amount
$86
Pension Transfer To Amount
$6,763
Pension Oth Ded Amount
$8,057
Pension Oth Ded Text
LOANS, NONVESTED,FORF TO OFFSET EXP
Pension Total Ded Amount
$15,060
Pension End of year Bal Amount
$117,120
Wlfr Premium Rcvd Amount
$0
Wlfr Unpaid Due Amount
$0
Wlfr Reserve Amount
$0
Wlfr Total Earned Prem Amount
$0
Wlfr Claims Paid Amount
$0
Wlfr Incr Reserve Amount
$0
Wlfr Incurred Claim Amount
$0
Wlfr Claims Chrgd Amount
$0
Wlfr Ret Commissions Amount
$0
Wlfr Ret Admin Amount
$0
Wlfr Ret Oth Cost Amount
$0
Wlfr Ret Oth Expense Amount
$0
Wlfr Ret Taxes Amount
$0
Wlfr Ret Charges Amount
$0
Wlfr Ret Oth Chrgs Amount
$0
Wlfr Ret Total Amount
$0
Wlfr Refund Amount
$0
Wlfr Held Bnfts Amount
$0
Wlfr Claims Reserve Amount
$0
Wlfr Oth Reserve Amount
$0
Wlfr Divnds Due Amount
$0
Wlfr Total Charges Paid Amount
$0
Wlfr Acquis Cost Amount
$0

Schedule D

Row 1
Filing Id
84037033093522
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
CIGNA LIFETIME60
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370170
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$4,727
Row 2
Filing Id
84037033093522
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
30372033093020003
Row 3
Filing Id
84037033093522
Page Id
1
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
CIGNA LIFETIME50
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370169
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$4,439
Row 4
Filing Id
84037033093522
Page Id
2
Page Seq
1
Page Row Num
1
Row Num
10
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
FID ADV GROWTH OPPORTUNITIES
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370044
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$489,248
Row 5
Filing Id
84037033093522
Page Id
2
Page Seq
1
Page Row Num
2
Row Num
11
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
DREYUS FOUNDERS GROWTH ACCT
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370083
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$537,106
Row 6
Filing Id
84037033093522
Page Id
2
Page Seq
1
Page Row Num
3
Row Num
12
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
WARBURG PINCUS ADV EMERG GRO
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370075
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$7,371
Row 7
Filing Id
84037033093522
Page Id
2
Page Seq
1
Page Row Num
4
Row Num
13
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
PBHG GROWTH ACCOUNT
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370073
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$59,540
Row 8
Filing Id
84037033093522
Page Id
2
Page Seq
1
Page Row Num
5
Row Num
14
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
AMERICAN CENTURY ULTRA ACCOUNT
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370108
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$69,477
Row 9
Filing Id
84037033093522
Page Id
2
Page Seq
1
Page Row Num
6
Row Num
15
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
INVESCO DYNAMICS
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370096
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$89,456
Row 10
Filing Id
84037033093522
Page Id
2
Page Seq
2
Page Row Num
1
Row Num
16
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
AIM CONSTELLATION ACCOUNT
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370059
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$10,844
Row 11
Filing Id
84037033093522
Page Id
2
Page Seq
2
Page Row Num
2
Row Num
17
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
TEMPLETON GROWTH ACCOUNT
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370079
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$29,882
Row 12
Filing Id
84037033093522
Page Id
2
Page Seq
2
Page Row Num
3
Row Num
18
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
JANUS WORLDWIDE ACCOUNT
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370070
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$175,048
Row 13
Filing Id
84037033093522
Page Id
2
Page Seq
2
Page Row Num
4
Row Num
19
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
WARBURG PINCUS ADV INTL EQUITY
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370072
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$637
Row 14
Filing Id
84037033093522
Page Id
1
Page Seq
0
Page Row Num
3
Row Num
2
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
CIGNA LIFETIME40
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370168
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$7,555
Row 15
Filing Id
84037033093522
Page Id
2
Page Seq
2
Page Row Num
5
Row Num
20
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
TEMPLETON FOREIGN ACCOUNT
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370080
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$6,827
Row 16
Filing Id
84037033093522
Page Id
1
Page Seq
0
Page Row Num
4
Row Num
3
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
CIGNA LIFETIME30
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370167
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$3,043
Row 17
Filing Id
84037033093522
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
4
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
CIGNA LIFETIME20
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370166
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$1,306
Row 18
Filing Id
84037033093522
Page Id
2
Page Seq
0
Page Row Num
2
Row Num
5
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
CHTR BALANCED FUND 1 - INVESCO
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370084
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$52,449
Row 19
Filing Id
84037033093522
Page Id
2
Page Seq
0
Page Row Num
3
Row Num
6
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
DREY FOUNDERS BALANCED ACCT
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370086
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$444
Row 20
Filing Id
84037033093522
Page Id
2
Page Seq
0
Page Row Num
4
Row Num
7
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
CHTR LARGE CO STK INDEX-CIGNA
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370123
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$604,202
Row 21
Filing Id
84037033093522
Page Id
2
Page Seq
0
Page Row Num
5
Row Num
8
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
NEUB BERMAN GUARD TRUST CLASS
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370090
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$2,725
Row 22
Filing Id
84037033093522
Page Id
2
Page Seq
0
Page Row Num
6
Row Num
9
Image Form Id
30372033093020003
DFE P1 Entity 01 Name
WARBURG PINCUS ADV VALUE ACCT
DFE P1 Spons 01 Name
CONNECTICUT GENERAL LIFE INS CO
DFE P1 Plan 01 EIN Plan number
060303370099
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$1,256

Schedule I

Schedule I Financial Statement

Small plan result

Balance sheet and activity values reported by the filer for this small-plan annual return.

End-of-year assets$2,396,927-$293,970 change

Balance Sheet

Beginning and end of plan year.

Total assets$2,690,897$2,396,927Decrease -$293,970 (-10.92%)
Total liabilities$0$0No change $0
Net assets$2,690,897$2,396,927Decrease -$293,970 (-10.92%)

Contributions

Employer contributions$68,200
Participant contributions$253,403
Other contributions$14,715

Income & Expenses

Total income$-108,199
Total expenses$185,771
Net income$-293,970
Source fields
Schedule I source fields
Filing Id
84037033093522
Schedule I EIN
77-0226388
Schedule I Plan Num
001
Schedule I Plan Year Begin Date
2000-01-01
Schedule I Tax Period
20001231
Small plan total assets at beginning of year
$2,690,897
Small plan total liabilities at beginning of year
$0
Small plan net assets at beginning of year
$2,690,897
Small plan total assets at end of year
$2,396,927
Small plan total liabilities at end of year
$0
Small plan net assets at end of year
$2,396,927
Small plan employer contributions
$68,200
Small plan participant contributions
$253,403
Small Oth Contribution Rcvd Amount
$14,715
Small Non Cash Contribution Bs Amount
$0
Small Other Income Amount
$-444,517
Small plan total income
$-108,199
Small plan total benefit distributions
$173,346
Small Corrective Distribution Amount
$0
Small Dm Dstrb Ptcp Ln A
9400
Small Oth Expenses Amount
$3,025
Small plan total expenses
$185,771
Small plan net income or loss
$-293,970
Small Total Plan Transfers Amount
$0
Small Joint Venture End of year Indicator
Yes
Small Joint Venture End of year Amount
$0
Small Employer Prop End of year Indicator
No
Small Employer Prop End of year Amount
$0
Small Investment Real Est End of year I
2
Small Investment Real Est End of year A
0
Small Employer Sec End of year Indicator
No
Small Employer Sec End of year Amount
$0
Small Mortg Participants End of year Indicator
Yes
Small Mortg Participants End of year Amount
$122,225
Small Oth Lns Participants End of year Indicator
No
Small Oth Lns Participants End of year Amount
$0
Small Personal Prop End of year Indicator
No
Small Personal Prop End of year Amount
$0
Small Fail Xmt Ctb I
2
Small Fail Xmt Ctb A
0
Small plan participant loans in default
No
Small Loans In Default Amount
$0
Small plan leases in default
No
Small Leases In Default Amount
$0
Small Pt In Interest Not Reported I
2
Small Pt In Interest Not Reported A
0
Small plan fidelity bond in place
Yes
Small plan fidelity bond amount
$100,000
Small plan loss discovered during year
No
Small Loss Discovered Dur Year Amount
$0
Small plan assets with undetermined value
No
Small Asset Undeterm Valuation Amount
$0
Small plan non-cash contributions reported
No
Small Non Cash Contribution Amount
$0
Small 20 Percent Sngl Investment Indicator
No
Small 20 Percent Sngl Investment Amount
$0
Small plan all plan assets distributed
No
Small plan resolution to terminate plan adopted
No
Small Res Terminate Plan Adpt Amount
$0

Schedule R

Schedule R Pension Information

Retirement plan characteristics

Testing, payor, opinion-letter, and transfer information reported with the filing.

Pension & Payor

Payor EIN06-1332405

Transfers

Distributed property value$0
Schedule R source fields
Payor 06-1332405
Filing Id
84037033093522
Schedule R EIN
77-0226388
Schedule R Plan number
001
Schedule R Plan Year Begin Date
2000-01-01
Schedule R Tax Period
20001231
Pension Value Dstrb Pd Property Amount
$0
Pension payor EIN
06-1332405
Pension Employer Contribution Rqr Amount
$0
Pension Employer Contribution Paid Amount
$0
Pension Funding Deficiency Amount
$0