Views [dbo].[al_bi_model_def_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
subclass_id
inactive
name
abbreviation
creation_user
creation_date
last_update_user
last_update_date
version_number
description
current_as_of_date
class_id
family_id
preferred_seller_uuid
manufacturer_uuid
exclude_registration
delete_time
operating_system
capacity
capacity_unit
gl_code
asset_capable
authoritative
tenant
TENANT_DISPLAY
model_uuid
model_uuid_display
SQL Script
CREATE VIEW [dbo].[al_bi_model_def_view]
AS
SELECT     subclass_id, inactive, name, abbreviation, creation_user, creation_date, last_update_user, last_update_date, version_number, description,
                      current_as_of_date, class_id, family_id, preferred_seller_uuid, manufacturer_uuid, exclude_registration, delete_time, operating_system, capacity,
                      capacity_unit, gl_code, asset_capable, authoritative, tenant,dbo.al_bi_bintohexstr(tenant) AS TENANT_DISPLAY, model_uuid,dbo.al_bi_bintohexstr(model_uuid)
                      AS model_uuid_display
FROM         dbo.ca_model_def
GO
Uses