 |
Members of participating UsNet credit unions can enjoy the convenience of the services that a CU Service Center offers.
Below is a list of credit unions which participate in the UsNet network.
Members of these participating credit unions can transact business at any of our
shared service centers.
For a detailed list of shared service centers, please visit our
UsNet CU Service Center Locator.
Participating UsNet Credit Unions
Error processing SSI file
select
customer.master_customer_id,
customer.sub_customer_id,
customer.label_name,
cus_communication.formatted_phone_address as primary_url,
cus_address_vw.address_1,
cus_address_vw.address_2,
cus_address_vw.address_3,
cus_address_vw.address_4,
cus_address_vw.city,
cus_address_vw.state,
cus_address_vw.postal_code,
customer.primary_phone
from
customer inner join cus_address_vw
on
customer.master_customer_id = cus_address_vw.master_customer_id
and customer.sub_customer_id = cus_address_vw.sub_customer_id
inner join usr_cu_master
on
customer.master_customer_id = usr_cu_master.master_customer_id
and customer.sub_customer_id = usr_cu_master.sub_customer_id
inner join cus_communication
on
customer.master_customer_id = cus_communication.master_customer_id
and customer.sub_customer_id = cus_communication.sub_customer_id
and cus_communication.comm_type_code= 'WEB'
where
(customer.customer_class_code = 'CU')
and (cus_address_vw.address_type_code = 'BUS_PHYS')
and (cus_address_vw.ADDRESS_STATUS_CODE = 'GOOD')
and (customer.customer_status_code = 'ACTIVE')
and (usr_cu_master.usr_ssc_mem = 'Y')
union
select
customer.master_customer_id,
customer.sub_customer_id,
customer.label_name,
cus_communication.formatted_phone_address as primary_url,
cus_address_vw.address_1,
cus_address_vw.address_2,
cus_address_vw.address_3,
cus_address_vw.address_4,
cus_address_vw.city,
cus_address_vw.state,
cus_address_vw.postal_code,
customer.primary_phone
from
customer inner join cus_address_vw
on
customer.master_customer_id = cus_address_vw.master_customer_id
and customer.sub_customer_id = cus_address_vw.sub_customer_id
inner join usr_cu_master
on
customer.master_customer_id = usr_cu_master.master_customer_id
and customer.sub_customer_id = usr_cu_master.sub_customer_id
inner join cus_communication
on
customer.master_customer_id = cus_communication.master_customer_id
and customer.sub_customer_id = cus_communication.sub_customer_id
and cus_communication.comm_type_code= 'WEB'
where
(customer.customer_class_code = 'CU')
and (cus_address_vw.address_type_code = 'BUS_MAIL')
and (customer.customer_status_code = 'ACTIVE')
and (cus_address_vw.ADDRESS_STATUS_CODE = 'GOOD')
and (usr_cu_master.usr_ssc_mem = 'Y')
and (cus_address_vw.master_customer_id not in
(select temp.master_customer_id
from cus_address_vw temp
where temp.ADDRESS_TYPE_CODE = 'BUS_PHYS')
)
order by
customer.label_name
Join
a New York Credit Union
|
Some files provided
on this web site are in Portable Document Format (PDF) which can be viewed
with Adobe Acrobat Reader.