The FinSwitch Price Distribution (PD) file is used for the upload of a file of unit prices received in a csv file from an Asset Manager, using the FinSwitch Interface.
When the file is uploaded, the system will update the Unit Price table as per the details in the Unit Price Field column in the table below:
Detail record layout
|
Field Name |
Type |
Field Size |
Value/Description |
Unit Price Field |
|
Message Type Code |
|
30 |
PD.
Indicates that the file is a Price Distribution file |
|
|
Message Type Name |
|
30 |
Price Distribution |
|
|
Type Code |
|
30 |
NP = Net Asset Value Price (NAV) CP = Net Asset Value Price (NAV) excluding accrued dividend and interest income or any other charges or levies IC = Initial Charge TY = Today’s Yield for Money Market funds AY = Annualised Yield for Money Market funds. CY = Current Yield for Money Market – Bond/Gilt yields. |
If the value for Type Code is not NP do not create a Unit Price record. |
|
Type Name |
|
30 |
Single Price Clean Price Initial Charge Today’s yield Annualised yield Current yield |
|
|
ManCo Code |
|
30 |
Management Company code |
|
|
ManCo Name |
|
50 |
Management Company Name |
|
|
Fund Code |
|
30 |
FinSwitch/JSE Fund Code |
Read the Translation Value for the Target System Attribute FUND CODE for the Source System Attribute INVESTMENT MED for which the Translation Value is equal to the value in the file.
Read the Capture Method on the Investment Medium with a Code equal to the Source System value and it is CAPTURED/INV MED update the relationship to the Investment Medium.
If it is CAPTURED/PORTF write an error message to the error log.
If no Investment Medium is found with a value equal to the Translation Value for the Source System Attribute INVESTMENT MED read the Translation Value for the Target System Attribute FUND CODE for the Source System Attribute SCHEMEPORTFOLIO for which the Translation Value is equal to the value in the file.
Read the Capture Method on the Investment Medium to which the Portfolio with a Code equal to the Source System value and it is CAPTURED/PORTF update the relationship to the Portfolio. If it is CAPTURED/INV MED write an error message to the error log. |
|
Fund Name |
|
50 |
Fund Name |
|
|
Value Date |
Date |
10 |
Price Date in format DD/MM/CCYY |
EFFECTIVE_DATE |
|
Price |
|
20 |
Price |
BUY_PRICE and SELL_PRICE.
Update if the value for Type Code is NP.
If the value for Type Code is not NP, do not update. |
|
Date Submitted |
|
10 |
Date and time the file was uploaded into FinSwitch |
|
|
Status |
|
20 |
Status of Price / Yield. ORIGINAL CORRECTED |
PRICE_TYPE
NORMAL if the value in the file is ORIGINAL.
CORRECTED if the value in the file is CORRECTION. |