APL |
Issue Type Exception Report |
Issue Type Exception Report
For some products, accounts cannot hold a security that falls outside a specific issue type (for example, ISSTY EQ 28). Customers can use the new function ISSUETYPEEXCEPTION to generate a report which identifies any security that an account should not hold by issue type.
The report can be run adhoc or overnight to identify any non-allowable issue types. For example:
WHAT NEXT? ISSUETYPEEXCEPTION
AS OF DATE (MM/DD/YY) - HIT ENTER FOR 03/21/22 : 03/21/22
ENTER THE ACCOUNTS TO BE INCLUDED:
148162 ACCOUNTS CURRENTLY ON FILE
SEARCH FOR WHAT? RR LT 99
28771 RECORDS FOUND
NEXT OPERATION (HIT RETURN WHEN DONE, OR TYPE HELP):
ENTER THE ISSUE TYPE(S) THE ACCOUNT IS ALLOWED TO HOLD:(EX:28 44 210 etc.): 28
NEXT OPERATION (RETURN WHEN DONE, OR HELP):
PROCESSING
ISSUETYPEEXCEPTION.CSV
The output report is called ISSUETYPEEXCEPTION.CSV. It contains the following columns:
- BWNUM: Account Number. This will display multiple times for each issue type listed
- DTCNO: Combination of DTCNO1 and DTCNO2. This number will display multiple times for each issue type listed
- ISSUE TYPE
- CUSIP: Combination of CUSIP1 and CUSIP2
- TICKER
- UNITS: This will go out to 2 decimal places. For mortgage-backed securities, displays the ORIGINAL FACE value
Sample report output:
MRC - ISSUE TYPE EXCEPTION REPORT - RUN DATE 03/22/22 10:19 A.M
AS OF: 03/21/22 - RR LT 99
ISSUE TYPES THE ACCOUNT IS ALLOWED TO HOLD: 28
BWNUM,DTCNO,ISSUE TYPE,CUSIP,TICKER,UNITS
123456789,111111111111,035,999999999,ABC123,100.00
222222222,121212121212,215,888888888,XYZ,250.00
222222222,121212121212,034,777777777,EFG,1250.00
222222222,121212121212,444,555555555,AAA,0.00
TRL4