| ALL
PRODUCTS |
| |
| 4/21/08 - New Trust Status Code implementation to track
accounts through a sequence of service, beginning with
account opening through closing (done for ETC). This project
can be selectively implemented based on the existence of
file TRSTATUS. Not all of the project has to be sent. |
| |
| Participant
Loookup |
| 9/3/08 - Fixed a 500 error when searching a names with
a string that contains an apostrophe. |
| Programs: SQLRules, SQLFileManager |
| |
| 20 Fund CBR and Strategy Upgrade |
| 5/22/08 - Upgraded CBR records and Strategy records to support 20 funds. |
Programs: Plr080wPopupServlet
tsc.planis.cbr.payroll.*
tsc.planis.files.*
All planis/cbr/payroll JSPs
tsc.planis.cbr.elections.*
All planis/cbr/elections JSPs
tsc.trustas.files.TRSTRATFormat
tsc.business.rules.ChangeCusipNumberRules
tsc.business.rules.ContributionPercentageRules
tsc.business.rules.Tlr850Rules,tsc.planas.Plan9RecordUpdateServlet
tsc.business.rules.ImportRules
tsc.trustas.servlets.Tlr850wUpdateServlet
tsc.trustas.servlets.Tlr850wGlobalChangeServlet
PLANIS (DDS)
TRUSTIS (DDS)
TRCBDPS (DDS)
TRCBDHS (DDS)
TRCBDAS (DDS)
TRCBDOS (DDS)
TRCBDSS (DDS)
TRCBDTPS (DDS)
TRCBDTAS (DDS)
TRCBDTOS (DDS)
TRCBDTSS (DDS)
TRSTRATS (DDS)
PLR300F (DDS)
PLR300 (DDS)
PLR380FM (DDS)
PLR385FM (DDS)
TLR850FM (DDS)
Updated Programs
TRCBR (RPGLE copybook)
TRSTRAT (RPGLE copybook)
PLR045C (RPGLE)
PLR300H (Coverted to RPGLE)
PLR310A (RPGLE)
PLR310C (RPGLE)
PLR340 (RPGLE)
PLR360 (Coverted to RPGLE)
PLR380 (RPGLE)
PLR380B (RPGLE)
PLR380D (RPGLE)
PLR380A (Coverted to RPGLE)
PLR385 (Coverted to RPGLE)
PLR385A (Coverted to RPGLE)
PLR390 (Coverted to RPGLE)
PLR690 (RPGLE)
TLR060 (Coverted to RPGLE)
TLR070 (Coverted to RPGLE)
TLR850P (Coverted to RPGLE)
Compile
PLR095 (RPG)
PLR390A (RPG)
PLR950 (RPG)
PLR045A (RPGLE)
PLR045G (RPGLE)
PLR300J (RPGLE)
PLR370M (RPGLE)
TSC010 (RPGLE) |
| |
|
TRUST
AND IRA IS |
| |
| INQUIRY
AND REPORTS |
| |
| Cash
Ledger |
| 8/8/08 - Corrected problem in handling cusip# related
transactions that have the same sign for Principal and
Unit/Shares. This affects the ledger that does not separate
principal and income. |
| Programs: Tlr250Rules. |
| |
| DEPARTMENTAL
REPORTS |
| |
| Check
Reconciliation |
| 5/27/08 - Added the ability to reverse a cusip# related
transactioin when stopping or voiding a check. |
| Programs: Tlr560Rules. |
| |
| IRA
5498 Report |
| 5/21/08 - Changed handling of Roth recharacterizations
for ETC. |
| Programs: IRA094 (RPGLE). |
| 5/20/09 - Corrected problem with trade/settlement date
logic when computing market value. |
| Programs: SR0081 (RPGLE). |
| 5/31/09 - Corrected error in determining the type of
account when the account had no contributions during the
reporting period. |
| Programs: IRA094Rules. |
| |
| Security
Location Report |
| 12/18/08 - Corrected problem with not printing multiple
asset description lines for some of the records (CCOPG). |
| Programs: TLR170 (RPGLE). |
| |
| RECORD
ENTRY |
| |
| Trust
Master Records |
| 4/21/08 - Added new feature to track historical trust
status. Accounts can be classified as open, closed, closing,
locked, escheated or unclaimed. This feature is optional
based on whether the file TRSTATUS is found in your production
library. When the file is not found, only opened or closed
is applicable. |
| Programs: tlr000w/personalGeneral.jsp and ebtGeneral.jsp,
trustStatus/jsp folder, TRSTATUS (DDS), Tlr000Rules, Tlr000wTrustTypeLookupServlet,
Tlr000wLoadTrustTypeServlet, Tlr200wTabChangeServlet, Tlr710wTabChangeServlet,
TrustStatusRules, TrustStatusServlet, TrustStatusUpdateServlet,
Tlr200Rules, Tlr200ImportRules, Tlr540Rules, Tlr530wTabChangeServlet.
Note: send Custom1Servlet, equitytrustcompany.jsp, CustomUserRestrictionsServlet
and CustomUserRestrictions.jsp (if applicable). |
| 3/20/09 - Added new tab to store OFAC information for
ETC. |
| Programs: tlr000w/all JSPs, images/tlr000/ofac_information,
OfacInformationRules, Tlr000wPopulatePersonalServlet, Tlr000wUpdateServlet. |
| 6/11/09 - Added a generic Client Information screen that can be used in Personal or EBT trusts. |
| Programs: tlr000w/all JSPs,
Tlr000ClientRules, Tlr000wPopulateEBTServlet, Tlr000wClientPopulateServlet, Tlr000wClientUpdateServlet, TRMIDCATRFormat |
| |
| Investment
Catalog Records |
| 6/18/08 - Added XML controlled option to get next available
investment number option for ETC. This project does not
affect any other users. |
| Programs: tlr300w/enterInvestmentCatalogRecords.jsp,
Trust3RecordEntryServlet, NextAvailableIrn, NextAvailableIrnServlet,
customers/config.xml. |
| 9/19/08 - Added new information to the real estate file
for ETC. |
| Programs: tlr300w/displayRealEstateDescription.jsp, Tlr300Rules,
RealEstateDescriptionServlet, TRREALS (DDS). |
| 9/19/08: - Added new promissory note tab to keep detail
information about notes and loans. Also added amortization
schedule (ETC). |
| Programs: tlr300/promissory_notes.jpg, tlr300w/displayInvestmentCatalogRecords.jsp,
displayPromissoryNote.jsp, Tlr300wTabChangeServlet, Tlr300Rules,
AmortizationScheduleRules, AmortizationScheduleServlet,
PromissoryNoteServlet, Tlr300wServlet, customers/config.xm,
TRNOTES (DDS). |
| 10/13/08 - Added new entities tab to keep detail information
about entities such as closely held corporatioins and partinerships
(ETC). |
| Programs: tlr300/entities.jpg, tlr300w/displayInvestmentCatalogRecords.jsp,
displayEntities.jsp and help text, Tlr300wTabChangeServlet,
Tlr300Rules, EntitiesServlet, TRENTITIES (DDS). |
| 2/20/09 - Modified TRENTITIES to include Units/Shares
Owned. Added Parcel# and Contract Price to Asset Description
lines (ETC/JCW). |
| Programs: displayEntities.jsp, EntitiesServlet and Tlr300Rules. |
| |
| Trust
Transactions |
| 6/11/08 - Corrected problem with negative numbers when
checking IRA limits. |
| Programs: Tlr200Rules (eliminate TLR200IRA java program
call). |
| 10/1/08 - Added loan processing transactions based on
an amortization schedule. The program will automatically
create principal transactions. |
| Programs: AmortizationScheduleRules, Tlr200Rules, Tlr200wServlet,
Trust3RecordEntryServlet, config.xml file. NOTE: This project
assumes that the Note functionality in the Investment Catalog
has been installed. |
| |
| Creditor Records |
| 6/25/09 - Added Creditor level ACH records to store bank information |
| Programs: CreditorAchRules, CreditorAchServlet, CreditorAchUpdateServlet, Tlr525wTabChangeServlet, tlr525w/*.jsp, tlr525/ach tab images, TRCRACHS (DDS). |
| |
| Strategy
Trading |
| 9/29/08 - Changed Strategy Trading Report to list 20
investments. |
| Programs: TLR850P (RPGLE). |
| |
| RECORD
UPDATE |
| |
| Change/Delete
Trust Transactions |
| 5/28/08 - Added new Change/Delete/Reverse Report which
lists information from the file containing the history
of modified trust transactions (TRDCHISS). |
| Programs: Tlr230Rules, Tlr230wTabChangeServlet, Tlr230wChangeDeleteReverseServlet,
tlr230w/changeDeleteReverse.jsp, enterDeleteTrustTransactions.jsp,
images/tlr230/print_report.jpgs, ChangeDeleteReverseReport.jasper.
NOTE: This project also requires the program changes documented
on 3/15/08. |
| 6/11/09 - Added the capability of reversing a transaction
with either current or original dates. |
| Programs: reverseTransactions.jsp, Tlr230Rules, Tlr230wReverseRecordServlet,
Tlr230wUpdateServlet. |
| 6/11/09 - Added report selection options and posting
date to the Change/Delete/Reverse Report. |
| Programs: changeDeleteReverseReport.jsp, Tlr230Rules,
Tlr230wTabChangeServlet, TLR230wChangeDeleteReverseServlet. |
| 6/28/09 - Add "reverse" to description lines, repaired
"original date" reversals appearing on the Reversal Report
and added date to Cash Ledger for Stopped and Voided checks. |
| Programs: All of the above changes and Tlr250Rules. |
| |
| Investment
Income Distribution |
| 12/22/08: Revised report columns to avoid cutting off
reinvested share amount. |
| Programs: TLR150B (RPGLE). |
| |
| Accounts
Payable and Check Processing |
| 5/5/08 - Added the capability of purchasing investments
using the accounts payable program. |
| Programs: tlr530w/JSP folder, Tlr540Rules, Tlr530TabChangeServlet,
Tlr540wAddNewPayablesServlet, Tlr540wAddNewMiscPayablesServlet,
Tlr540wReviewPayablesServlet, Tlr540wChangePayables1Servlet,
Tlr540wChangePayables2Servlet. |
| 6/2/08 - Bypass check writing when ACH=A, C or W. Used
the field UPC in TRCODES to denote this. Allow posting
of ACH, Cashier's Checks and Wires without a Check#. Write
to TRCHECKS only when ACH=M or Blanks. TRCBHISS now gets
Mail or ACH from ACH in TRAPS. |
| Programs: Tlr540Rules, TLR550A, TLR550B and TLR550P (RPGLE). |
| 7/1/08 - Improved capability to change users when reviewing
and adding new payees. |
| Programs: tlr530w/addpayees.jsp, enterAccountsPayable.jsp,
reviewAccountsPayable.jsp, images/tlr530/change_userid.jpgs,
Tlr530wTabChangeServlet, Tlr540Rules. |
| 6/25/09 - Added ACH processing to Check Processing. Currently only used by CCOPG. tsc.ach.*, |
| Programs: tsc.ach.*, Tlr550wCheckProcessingServlet, TrustAchProcessingBaseRules, AchRegister.jasper, /tsc/customers/X/ach/ach.properties, TRCRACHS (DDS), commons-lang-2.4.jar (remember to add to /www/tsc/conf/workers.properties |
| |
| Trust
Fee Processing |
| 6/8/10 = Added rebalance all accounts option to Reports
Menu. |
| Programs: tlr710w/enterFeeReports.jsp and HelpFeeReports.html,
Tlr750Rules, Tlr710wFeeReportsServlet. |
| SYSTEM
MAINTENANCE |
| |
| Automated
Pricing |
| 6/23/08 - Added check for EXCHG not equal to "Z" to
bypass IDC pricing for non-publically traded securities
but do have a price table. |
| Programs: TLR335A (RPGLE). |
| |
| Change
Cusip Number |
| 5/22/08 - Corrected problem with the number of investments
in the Distribution Breakdown Record. Should be 10 not
20. |
| Programs: ChangeCusipNumberRules. |
| |
PLAN
IS |
| |
| INQUIRY
AND REPORTS |
| |
| Census
Update |
| 10/8/08 - Fixed a problem where, when updating addresses
in a Census Update, that if an old address had a 2nd address
line and the new address did not, that the old 2nd address
line would not get cleared. |
| Programs: CensusImportRules |
| |
| Participant
Trial Balance |
| 1/28/09 - Added Cusip# and Ticker to the Summary Report. |
| Programs: PLR120 (RPGLE). |
| |
| Non-Discrimination
Testing |
| 2/20/09 - Cross Testing and New Comparability added to
PlanIS. |
| Programs: crossTesting/JSP folder, CrossTestingRules,
4 Cross Testing Servlets. |
| |
| Loan
Delinquency Report |
| 3/27/09 - Corrected problem with amortization schedule
when loan payment is the last day of the month. |
| Programs: PLR350B (RPGLE). |
| |
| DEPARTMENTAL
REPORTS |
| |
| Trust
Balances by Cusip# |
| 5/29/08 - Changed the requirement for a price table and
shares. Price now defaults to $1.00 and all accounts will
appear on the report if they have a book value or share
value > 0.. |
| Programs: Plr285Rules. |
| |
| Inactivity
Report |
| 6/2/08 - Added new option to run all reports for a specific
department number. |
| Programs: plr430w/JSP folder, Plr430wServlet, Plr430Rules,
Plr660TabChangeServlet, PLR430 (RPGLE). |
| |
| Summary
Audit Report By Asset |
| 6/3/08 - Corrected heading display, added page number,
run date and replaced hard coded transaction codes with
Planmaps File. |
| Programs: plr650w/JSP folder, PLR650C (RPGLE). |
| 6/24/08 - Repaired unrealized gain/loss which was broken
from the 6/3/08 changes. |
| Programs: Plr650wServlet, PLR650C (RPGLE). |
| |
| Summary
Participant Trial Balance |
| 1/28/09 - Added Ticker Symbol to the report (JCW). |
| Programs: PLR125 (RPG). |
| |
| Participant
Labels |
| 6/4/08 - Added as of date capability when omitting zero
balance accounts. |
| Programs: Plan7DepartmentalReportsServlet, participantLabels/JSP
folder, ParticipantLabelRules, ParticipantLabelsServlet. |
| 9/5/08 - Added a Participant Level Department Number
filter option and changed the label file to sort by last
name instead of SSN. |
| Programs: Plan7DepartmentalReportsServlet, participantLabels/JSP
folder, ParticipantLabelRules, ParticipantLabelsServlet.,
tsc.rules.MapPnameAlphaSort |
| |
| 1099R
Report |
| 10/14/08 - Added new option to run the report by month
and well as year to date (Jeld-Wen). |
| Programs: plr490w/JSP folder, Plr490wServlet, PLR490
and PLR490A (RPGLE), PLR490JCL (CLP). PLR490JCL.java eliminated. |
| |
| RECORD
ENTRY |
| |
| Participant
Loans |
| 11/13/08 - Corrected problem with
displaying the wrong loan fee amount on the benefit payment
when the fee is prorated across more than one asset. |
| Programs: Plr320wBenefitPaymentRecordServlet,
Plr320Rules. |
| |
|
RECORD
UPDATE |
| |
| Participant
Vesting Update |
| 6/23/08 - Repaired problem with not entering
a leading zero for single digit sources and repaired handling
of grandfathered years of service. |
| Programs: Plr150wServlet, PLR150 (RPGLE). |
| 4/1/09 - Corrected use and display of age
18 when less that hire1 . |
| Programs: PLR150A (RPGLE). |
| |
| Gain/Loss
Allocations |
| 7/21/08 - Changed this program to start
with the highest PTIME from TRPTRANS in order to avoid
writing
a duplicate TRCTRANS record when someone stacks up a lot
of dividend allocations to be run at the same time. The
program used to use UTIME as a start which causes PTIME
to exceed the Clock. |
| Programs: PLR260U and SR0082 (RPGLE). |
| 9/30/08 - Changed the sort sequence in the
query to get the TANs in alpha sequence when submitting
multiple income allocations (BAC). |
| Programs: PLR260CL (CLP). |
| |
| Participant
Transfers |
| 9/15/08 - Added the capability of creating
a trading file from the Participant Transfer Report screen.
This can be used by customers who do not need all of the
capabilities of the trading system (Sinclair). This project
is in Development, not in Production. |
| Programs: Plr370wPostingOptionsServlet, Plr370wTransferReportsServlet,
TRADING (PF DDS), PLR370R1 (RPGLE), PLR370JCL (CLP), PLR370JCL
(Java eliminated). Requires customer special programs to
process and download the file and a parameter in the config
XML file to create the file. |
| 9/26/08 - Corrected problem with wrong cusip#
passed to Sr0040 in PRCSR, this is a very rare circumstance
and not a critical PTF. |
| Programs: PLR370I (RPGLE). |
| 10/5/08: Changed CHECKROUND subroutine to
allow rounding error tolerance of .005 shares. |
| Programs: PLR370I (RPGLE). |
| 2/20/09 - Changed duplicate or conflicting
transfer entries to ignore "to side only" transfers. A
rebalance request should ignore a pending contribution,
for example. Also changed the program to process all "to
side only" requests including, loan payments, contributions
and load repayments. |
| Programs: transferTo.jsp, confirmTransfer.jsp,
Plr370Rules, Plr370wSelectServlet and Plr370wTransferToServlet. |
| |
| Portfolio
Rebalancing |
| 11/26/08 - Removed historical CBD logic,
PLR380B always uses current
elections. |
| Programs: PLR380D (RPGLE). |
| |
| Payroll and Loan Processing |
9/4/09: Set Contribution date to today by default.
Kansas only (via XML config value): CBR - if creating trade transactions and transaction date is blank, new logic will set the date to the next business day. Also added fields for Power Image number and Deposit Method.
|
| Programs
Java/JSP
- tsc.planas.Plan9RecordUpdateServlet
- tsc.planis.cbr.payroll.PayrollProcessingRules
- tsc.planis.cbr.payroll.ContributionBreakdownReport2Servlet
- tsc.planis.files.PLR300RFormat
- /planis/cbr/payroll/CBR2.jsp
SQL Tables
- TRCASHRECS
- CREATE TABLE EPKANSAS.TRCASHRECS
(ID INTEGER NOT NULL
GENERATED ALWAYS AS IDENTITY
(INCREMENT BY 1 CYCLE),
METHOD CHAR(1),
PINUMBER CHAR(12),
PRIMARY KEY (ID));
CL
DDS
- PLR300
- PLR300F
- TRTTRANS
- TRTLANDS
RPGLE
Compile
- RPGLE
- PLR045A, B, E, H
- PLR140B, I
- PLR145, A
- PLR300J
- PLR340
- PLR370I, J, M, R1, R3
- PLR380B
- PLR450N, P
- PLR800
- PLR850C, D, F, G
- PLR870A
RPG
- PLR370B, C, D
- PLR850A
- PLR870F
|
| |
| Trading
System |
| 7/10/08 - Added Trade# control break to solve
the problem of same day trades of shares and dollars in
the same account. |
| Programs: PLR840D (RPGLE). |
| 7/18/08 - Added edit for trading platform
program number when the Travel Code is "F" for
file. |
| Programs: PLR800 (RPGLE). |
| 11/20/08 - Matrix Bank sends the total
shares after all dividends,
capital gains, etc. Changed this program to comparing
shares before all dividends in order to avoid incorrect
share out of balance messages. Also changed the Java code
to set back the share balance to before the dividends. |
| Programs: tsc.psc.MatrixRules, PLR865 (RPGLE). |
| 6/10/09 - Added trading partner number to
trade account files in order to join Trade Land transactions
by partner number for trading files. |
| Programs: Plr830w/all JSPs and Help, TRADEPFormat,
TRADEPLFormat, TRADETFormat, TRADETLFormat, TRADEACP (DDS),
TRADEACT (DDS), Plr830Rules, Plr830wServlet, BuildTradingFile
(CSTC), TradingMenuServlet (CSTC), OpenTradeReport (CSTC),
numerous compiles of RPG and RPGLE programs, mostly obsolete
for new installations (see list).. NOTE: must install new
customer_config.xml file in order to use CSTC direct trading
method. |
| 6/10/09 - Add new scheduled program to download
IDC dividends in situations where trading partners do not
send share positions or dividend rates. |
| Programs: tsc.business.rules.IDCDividends,
ProcessDividends (CSTC). |
| 6/12/09 - Cleaned up displays for Fund Family
records and changed several defaults for new Fund Families
and Funds. |
| Programs: plr820w/jsp folder, Plr820Rules. |
| 6/14/09 - Removed requirement to enter a
partial name in Fund Family lookup. |
| Programs: Plr820wServlet. |
| |
| TRANSFER
IS |
| |
| |
If
you have any questions while reviewing our website, please use our typewriter
and send e-mail to swhittle@expertplan.com
