Views [dbo].[al_bi_res_class_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:33:18 PM Thursday, February 10, 2011
Last Modified10:33:18 PM Thursday, February 10, 2011
Columns
Name
id
inactive
name
family_id
parent_id
usp_nsm_class
creation_user
creation_date
last_update_user
last_update_date
version_number
description
exclude_registration
delete_time
tenant
TENANT_DISPLAY
SQL Script
CREATE VIEW [dbo].[al_bi_res_class_view]
AS
SELECT     id, inactive, name, family_id, parent_id, usp_nsm_class, creation_user, creation_date, last_update_user, last_update_date, version_number,
                      description, exclude_registration, delete_time, tenant,dbo.al_bi_bintohexstr(tenant) AS TENANT_DISPLAY
FROM         dbo.ca_resource_class
GO
Uses