[dbo].[al_bi_legaldoc_stathist

[dbo].[al_bi_legaldoc_stathist_view]

(local) > mdb > Views > dbo.al_bi_legaldoc_stathist_view

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	10:33:18 PM Thursday, February 10, 2011
Last Modified	10:33:18 PM Thursday, February 10, 2011

Columns

Name
STATUS_HISTORY_ID
LEGALDOC_UUID
LEGAL_STATUS
STATUS_DATE
CREATION_USER
CREATION_DATE
LAST_UPDATE_USER
LAST_UPDATE_DATE
VERSION_NUMBER
IS_CURRENT_KEY
TENANT
TENANT_DISPLAY

SQL Script

CREATE VIEW [dbo].[al_bi_legaldoc_stathist_view]
AS
SELECT     STATUS_HISTORY_ID, LEGALDOC_UUID, LEGAL_STATUS, STATUS_DATE, CREATION_USER, CREATION_DATE, LAST_UPDATE_USER,
                      LAST_UPDATE_DATE, VERSION_NUMBER, IS_CURRENT_KEY, TENANT,dbo.al_bi_bintohexstr(TENANT) AS TENANT_DISPLAY
FROM         dbo.ARG_LEGALDOC_STATHIST
GO

Uses

[dbo].[arg_legaldoc_stathist]
[dbo].[al_bi_bintohexstr]
dbo