Short Codes

CustomerName -> select name from customers where  ( 1000000000 + ID_CUSTOMERS ) = CAST(@ShortCode as INT)

CustomerSsn -> select ssn from customers where  ( 1000000000 + ID_CUSTOMERS ) = CAST(@ShortCode as INT)

CustomerLei -> select LEI_CODE from customers where  ( 1000000000 + ID_CUSTOMERS ) = CAST(@ShortCode as INT)