The following validations are performed during the process:
- File length must equal 67 characters
- The last line of the file must contain the variable EOF. This indicates the end of the file.
- If multiple dates are contained in the file, they must be sequenced in ascending order.
- Derived prices cannot be loaded.
- Only captured status is allowed at this point. This will change when a system to system link is in place.
- NORMAL / CORRECTED price types are allowed.
- Monthly prices must be the 1st of the month.
- Daily prices must be a valid working day.
- Unit prices cannot be loaded prior to the start date of the investment medium.
- When a price is loaded, a check is done to see if a previous price has been loaded.
- If the % increase / decrease on investment medium is greater than zero, a warning will be written to the error log if the price difference exceeds the percentage captured.
- If prices are not authorized, and a different price for the same date is uploaded, the price will be updated and a warning message will be written to the error log.
- Corrected prices can only be loaded if a normal authorized price exists.
Detail record layout
|
|
Field Name |
Field Size |
DEC |
Start |
End |
ATTR |
O/M |
Description / Value |
|
1 |
Investment Medium Code |
8 |
|
1 |
8 |
Char |
M |
Left aligned |
|
2 |
Scheme Code |
7 |
|
9 |
15 |
Char |
O/M* |
Left aligned * mandatory if the method of the investment medium has been captured as portfolio level |
|
3 |
Effective Date |
8 |
|
16 |
23 |
Num |
M |
CCYYMMDD |
|
4 |
Buy Price |
16 |
8 |
24 |
39 |
Num |
M |
Cannot be zero Zero filled |
|
5 |
Sell Price |
16 |
8 |
40 |
55 |
Num |
M |
Zeroes if Buy and Sell prices are the same |
|
6 |
Price Type |
10 |
|
56 |
65 |
Char |
M |
NORMAL / CORRECTED Left aligned |
|
7 |
Status |
1 |
|
66 |
66 |
Char |
M |
C |
O = Optional field
M = Mandatory
Note:
All optional text fields must be padded with trailing spaces.
All numeric fields must be padded with leading zeroes.