APL |
Sleeve Level Performance Extract |
Sleeve Level Performance Extract
This enhancement adds a new extract for sleeve level performance.
Three new functions have been added:
- DOWNAISMSPPERF^INIT
- DOWNAISMSPPERF^RUN
- DOWNAISMSPPERF^FINISH
The extract will be run on a Daily and Quarterly basis.
The Daily Sleeve Performance Run extract will be generated every night by Batch and cannot be run adhoc. As of Date = Prior business day
The Quarterly Sleeve Performance Run extract will be generated one time, quarter end by batch. This can be regenerated adhoc. As of Date = Prior Quarter end day.
Sample Workflow
DOWNAISMSPPERF^INIT
WHAT NEXT (japptst01) ? DOWNAISMSPPERF^INIT
Enter Extract Name: AISMSPPRF
File AISPERFEXTSAISMSPPRF Ready
Please Run DOWNAISMSPPERF^RUN Concurrently Followed by DOWNAISMSPPERF^FINISH
DOWNAISMSPPERF^RUN
WHAT NEXT (japptst01) ? DOWNAISMSPPERF^RUN
AS OF DATE (MM/DD/YY) - HIT ENTER FOR 08/15/22 : 8/16/2022
1510414 ACCOUNTS CURRENTLY ON FILE
SEARCH FOR WHAT? RR LT 99
19232 RECORDS FOUND
NEXT OPERATION (HIT RETURN WHEN DONE, OR TYPE HELP): AND
AND WHAT? BILLNO EQ MSP
19229 RECORDS FOUND
NEXT OPERATION (HIT RETURN WHEN DONE, OR TYPE HELP):
Select the Type of MSP Performance to Consider? STRATEGY OR SLEEVE?
INVALID OPTION , PLEASE ANSWER ONE OF THE FOLLOWING:
STRATEGY OR SLEEVE
Select the Type of MSP Performance to Consider? STRATEGY OR SLEEVE? SLEEVE
Enter Extract Name: AISMSPPRF
Enter Sequence Number: 1
100% COMPLETE [****************]
Performance Data Collected and Stored.
Be Sure to Run DOWNAISMSPPERF^FINISH Once All Processes of DOWNAISPERF®RUN Have Completed.
DOWNAISMSPPERF^FINISH
WHAT NEXT (japptst01) ? DOWNAISMSPPERF^FINISH
AS OF DATE (MM/DD/YY) - HIT ENTER FOR 08/15/22 : 8/16/22
Enter Extract Name: AISMSPPRF
AISMSPDPF.PR1
Fields
The Header record includes the following:
“HEADER”|”MSPPERFORM”|RUN DATE<YYYYMMDD>
Example: HEADER|MSPPERFORM|20220816
The Detail records include the following:
- SNAM
- Strategy ID or Sleeve ID (depending on the response to the STRATEGY vs SLEEVE prompt)
- Performance Sector Number
- As-of Date
- Market Value with Accruals from performance sector file
- Accruals
- Performance periods:
- Quarter to date (QTD)
- Year to date (YTD)
- Last calendar quarter
- Previous 6 months (from as-of date)
- Previous 1 year (from as-of date)
- Last calendar year
- Previous 3 years (from as-of date)
- Previous 5 years (from as-of date)
- Previous 10 years (from as-of date)
- Since inception (annualized, if greater than 1 year)
- Sleeve inception date (date of first V value in performance sector)
The Trailer record includes the following:
“TRAILER”|”MSPPERFORM”|RUN DATE<YYYYMMDD>|<number of records including header/trailer lines>
Example: TRAILER|MSPPERFORM|20220816|3
Sample AISMSPDPF.PR1 File
HEADER|MSPPERFORM|20221026
AE4459|GNA1K|112|20220831|26075.51|80.49|2.09|-16.12|-14.92|-11.34|-14.21|20.26|6.15|6.06|0.00|6.12|20150710
AE4459|GNA8Z|5250|20220831|724.66|0.00|-16.01|-40.21|-14.35|-28.06|-50.22|-55.83|-50.61|-50.03|-59.35|-100.00|20090716
TRAILER|MSPPERFORM|20221026|4