SECURITY ALIAS Resolution

Constituent level records will need to resolve to the SECURITY_ALIAS found in the SECURITY.XREFERENCE table. Records at the "Total" or "Segment" level are loaded to the performance table with a SECURITY_ALIAS of "0".
Steps used to resolve the SECURITY_ALIAS are as follows:

1. If BATCH ID position #7 = S (LEVEL), the procedure will attempt to resolve the security alias using the SEC ID and SEC ID TYPE combinations by matching SECURITY ID 1 (Field #12), if not NULL, to XREF_SECURITY_ID in the XREFERENCE table, and matching SECURITY ID 1 TYPE (Field #13), if not NULL, to XREF_TYPE:

• If one (1) match is found, the procedure will use the value in SECURITY_ALIAS to populate the record and will move to the Constituent insertion logic.
• If SECURITY ID 1 or SECURITY ID 1 TYPE is NULL, or an alias is not found, the procedure will proceed to Step 2 below.
• If the count of possible records returned is greater than 1, the procedure will proceed to Step 2 below.

1. The procedure will match SECURITY ID 2 (Field #14), if not NULL, to XREF_SECURITY_ID in the XREFERENCE table, and match SECURITY ID 2 TYPE (Field #15), if not NULL, to XREF_TYPE:

• If one (1) match is found, the procedure will use the value in SECURITY_ALIAS to populate the record and will move to the Constituent insertion logic.
• If SECURITY ID 2 or SECURITY ID 2 TYPE is NULL, or an alias is not found, the procedure will proceed to Step 3 below.
• If the count of possible records returned is greater than 1, the procedure will proceed to Step 3 below.

1. The same resolution process will be followed for Fields #16-21 SECID+TYPE combinations until a match is found. If no match is found, the batch will fail with the "Security Cannot Be Resolved" error.