APL |
Unknown Security Report |
Unknown Security Report
The public function UNKNOWNSEC is used to generate reports showing unknown securities. Users can generate one report for trade network sponsors, one report for non-trade network custodians, or one report for both.
Sample Sponsor Report
The report includes a header with the client name, report name, time stamp, and a trailer with the record count (count of detail records only, not including header or trailer).
If there is nothing to report, the report will include the header record and the trailer record only, and the record count will be zero.
The output report has 3 columns with column headers:
- Account Identifier
- CUSIP
- Sponsor Name
Note: The UNKNOWNSEC function will read from position files in the /sa/adp/ directory only.
WHAT NEXT: UNKNOWNSEC
"WHICH REPORT(S) SHOULD BE CREATED: TRADE NETWORK SPONSORS (SPONSOR), NON-TRADE NETWORK CUSTODIANS (CUSTODIAN), OR BOTH (BOTH)? SPONSOR"
ACCOUNTS TO CONSIDER: ALL OR SELECTED? ALL
NEXT OPERATION (HIT RETURN WHEN DONE, OR TYPE HELP): UNKNOWNSECSPON.CSV
The sponsor report file is labeled UNKNOWNSECSPON.CSV.
Sample Custodian Report
WHAT NEXT: UNKNOWNSEC
"WHICH REPORT(S) SHOULD BE CREATED:
TRADE NETWORK SPONSORS (SPONSOR), NON-TRADE NETWORK CUSTODIANS (CUSTODIAN), OR BOTH (BOTH)? CUSTODIAN"
ACCOUNTS TO CONSIDER: ALL OR SELECTED? SELECTED
SEARCH FOR WHAT? RR LT 99
20518 RECORDS FOUND
NEXT OPERATION (HIT RETURN WHEN DONE, OR TYPE HELP): UNKNOWNSECCUST.CSV
The custodian report file is labeled UNKNOWNSECCUST.CSV.
Sample Report for Both
WHAT NEXT: UNKNOWNSEC
"WHICH REPORT(S) SHOULD BE CREATED:
TRADE NETWORK SPONSORS (SPONSOR), NON-TRADE NETWORK CUSTODIANS (CUSTODIAN), OR BOTH (BOTH)? BOTH"
ACCOUNTS TO CONSIDER: ALL OR SELECTED? SELECTED
SEARCH FOR WHAT? RR LT 99
20518 RECORDS FOUND
NEXT OPERATION (HIT RETURN WHEN DONE, OR TYPE HELP):
UNKNOWNSEC.CSV
The report file for both is labeled UNKNOWNSEC.CSV.
Note: The Sponsor information will display first, then the Custodian. The consolidated report does not include a header line, column headers or a trailer line.