Spreadsheet: 24728d1215506795-designing-a-spreadsheet-for-projects-projects
Sheet: Current Iteration

Project | Date Added | I.D | TT no | Client | Fund Code | User | Priority | Reason for Priority | Report Affected | Issue | Assigned to | Updates | Status | E.T.A |  | [NAME] on Project
Crystal project - Black Box File for SS |  | 228318 |  |  |  |  |  |  | Crystal Project |  | [NAME] | DEV | Currenlty being worked on
GMO Trans Files Capture back post trans |  | Not in XPLANNER |  |  |  |  |  |  |  | [NAME] back post trans | [NAME] | UAT | Currenlty being worked on
Re Testing Chnages to imssub_unrealized_pl to avoid table scan |  | Not in XPLANNER |  |  |  |  |  |  |  |  | [NAME] | DEV | Currenlty being worked on
analysis of pt-trmast data for optimization |  | Not in XPLANNER |  |  |  |  |  |  |  |  | [NAME] |  | Currenlty being worked on
Modifications to the sub stored procedures that are used by imssp_pl_core for optimization |  | 250811 |  |  |  |  |  |  | Stored Procedures | Modifications are being made to the sub stored procedures that are used by imssp_pl_core for optimization, [NAME]: produce significant performance improvement for big funds like FUND B | Sata Malla |  | Created
DBARS expense Date file format change |  | 250117 |  |  |  |  |  |  | DBARS expense Date | want to make a few changes to the current DBARS_expense datafile, FundCode - that is the ISS code, we can create a table to map,Fund name instead of account name ,Base Curr- base curr of the fund, Nav - Nav of the fund | [NAME] | UAT | Currenlty being worked on
Pay as you go Swaps to be included in REPORTS |  | 196958 |  |  |  |  |  |  |  | A new PAUG (pay as you go) security has been created on GLSD.GPS. Smsecid: 1400898 smtype 324, investment type = 4073,I'll post some transactions to the following account,Acid: 7402 LCP.CSFBNY,Let me know when I can start posting | [NAME] | DEV | Currenlty being worked on
PE - Trial balance for 60 days |  | 240988 |  |  |  |  |  |  | Trial Balance |  | [NAME] | UAT | Currenlty being worked on
Transaction report_Amendment (TT246032) |  | 238989 | 246032 |  |  |  |  |  | Cutomised Client report | client has requested that a current report that he receivies be updated to hold some additional information. [NAME] and myself will need to sit down with someone to go over the clients requests | Vivekvikash Agarwal | QA | Currenlty being worked on
01_Dynamic Holdings Stored Proc |  | 231124 |  |  |  |  |  |  | Holdings report | [NAME] holdings Stored Proc needs to be amended to include the new columns that were developed for new client TOURADJI.
[NAME] to USE 'POST DATE' |  | 189919 |  |  |  |  |  |  | Trade date cash report | want report to output what has changed in their cash from running it this morning to this afternoon.
01_RISK Report for PIMCO |  | 191489 |  |  |  |  |  |  | Risk report | Risk report for Pimco
02_FAS Report_New Report Required. Sample required by 04.08.08 |  | 232687 |  |  |  |  |  |  | Risk report | Goldmans need a Level 3 PnL Cost Market Roll Report.
Additional 2 columns Investment Analysis Report -(tt 227830) |  | 221252 | 227830 |  |  |  |  |  | Cutomised Client report | Additional 2 columns to be added to investment analysis report
Amort Data file based on 08_YTM report |  | 201263 |  |  |  |  |  |  | Amortisation report | is possible to get a data export (in excel preferably) from a completed amort report that would detail;
GMO- Trans_td file - include post date to account for missing transactions |  | 250805 |  |  |  |  |  |  |  | trans_td is currently only picking up trades that have a tradedate of the report date but this sometimes causes a problem if they post as of trades.
Master switch to point reporting to different servers |  | 196515 |  |  |  |  |  |  | Master [NAME] | Please create a master switch to point GPS GPS3 GPS4 GPS5 to different servers
YTM amort report |  | 189007 |  |  |  |  |  |  | Amortisation report | number of issues of this report
Caliber AAR report changes - missing store proc for pn..statements |  | 233876 |  |  |  |  |  |  | Caliber AAR report | Add a filter - in Caliber AAR stored proc - PN[_]% to capture pn.. statement
Private [NAME] dataexport file - TB numbers |  | 237180 |  |  |  |  |  |  | dataexport file | Need to create a file that will send over the TB numbers to the private equity group in boston
Saving Month End Numbers |  | 231049 |  |  |  |  |  |  |  | Saving and Updating Month end numbers like holdings,P&L and ROR by acid,secid,longshort
Taco - Tax lot Holdings data file |  | 227372 |  |  |  |  |  |  | Holdings report | Taco need the exact same datafile used by GMO
Replication Testing |  | 205286 |  |  |  |  |  |  | Replication Testing | All non-replicated tables not needed for reporting, should be truncated to shrink nightly backups and weekend maintenance
( TT 250063) T+1 Eze Castle Position Extract |  | 217769 | 250063 |  |  |  |  |  | T+1 position extract | need a T+1 position extract to be sent to eze castle each morning
(TT 232682) Tax Reports 13 Qualified Dividend Income |  | 208178 |  |  |  |  |  |  | Tax report | Need to run estimate QDI report Comments: Please add India in the treaty country for QDI
(TT260358) - TRACE - Datafile for 193Trading |  | 227736 |  |  |  |  |  |  |  | client is also requesting that 193TRADING positions be sent as a separate file to the ftp as well as included in the current file
Add GPS5 to the daily Performance report |  | 202161 |  |  |  |  |  |  | Actuate reporting Performace reports | GPS5 will be going live 10/1/07 we will need to add this database to our Actuate reporting Performace reports
Custom Column update in P&L |  | 201732 |  |  |  |  |  |  | P&L report | [NAME] column update from textbox to LeftRightSortControl
customer ticker correction for Truview (TT298461) |  | 251050 |  |  |  |  |  |  | Trueview | CustomerTicker? has incorrect Data.Please run the following stored proc, and customerTicker has incorrect data
Get call dates in 07_Amortization Report YTC  (Yield to Call) from RDM |  | 217288 |  |  |  |  |  |  | Amortisation report | Need to populate call dates in GLS from RDM
Spaces in CBL |  | 212884 |  |  |  |  |  |  |  | It's not a specific field, but any field that has null data becomes a space. So in the two positions I sent, there is one field, for example, that is sometimes null, and sometimes not..
TB vs PL rec - show outage details |  | 239418 |  |  |  |  |  |  | TB vs PL | Add another section to the TB vs PL reconcilation report to show the outage by acid/secid/glaccount/curr
Trade date cash - new sort optioins |  | 206988 |  |  |  |  |  |  | Trade date cash report | add extra columns to show original acid and account alias group report by account alias
Trueview - ew gls performance stored procedure - need to collapse cash ( TT 261180) |  | 225201 |  |  |  |  |  |  | Trueview
Create Nightly cash export for AlphaFrontier |  | 253081 | 291282 | AlphaFrontier |  |  |  |  | Autosys Job | It would be ideal if you would create an autosys job to extract this data out nightly for the clients in AlphaFrontier?. We would then take this information and import into AF. We only need this for the cash account 11130 and all the clearers set up in that account