eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: OKC.OKC_BUS_VARIABLES_B#

Source

View Text - Preformatted


select VARIABLE_CODE VARIABLE_CODE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, VARIABLE_TYPE VARIABLE_TYPE, EXTERNAL_YN EXTERNAL_YN, VARIABLE_INTENT VARIABLE_INTENT, CONTRACT_EXPERT_YN CONTRACT_EXPERT_YN, DISABLED_YN DISABLED_YN, VARIABLE_DATATYPE VARIABLE_DATATYPE, APPLICATION_ID APPLICATION_ID, VALUE_SET_ID VALUE_SET_ID, VARIABLE_DEFAULT_VALUE VARIABLE_DEFAULT_VALUE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, XPRT_VALUE_SET_NAME XPRT_VALUE_SET_NAME, LINE_LEVEL_FLAG LINE_LEVEL_FLAG, DATE_PUBLISHED DATE_PUBLISHED, ORIG_SYSTEM_REFERENCE_CODE ORIG_SYSTEM_REFERENCE_CODE, ORIG_SYSTEM_REFERENCE_ID1 ORIG_SYSTEM_REFERENCE_ID1, ORIG_SYSTEM_REFERENCE_ID2 ORIG_SYSTEM_REFERENCE_ID2, PROCEDURE_NAME PROCEDURE_NAME, VARIABLE_SOURCE VARIABLE_SOURCE, CLM_SOURCE CLM_SOURCE, CLM_REF1 CLM_REF1, CLM_REF2 CLM_REF2, CLM_REF3 CLM_REF3, CLM_REF4 CLM_REF4, CLM_REF5 CLM_REF5, MRV_FLAG MRV_FLAG, MRV_TMPL_CODE MRV_TMPL_CODE, ZD_EDITION_NAME ZD_EDITION_NAME from "OKC"."OKC_BUS_VARIABLES_B"

View Text - HTML Formatted

SELECT VARIABLE_CODE VARIABLE_CODE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, VARIABLE_TYPE VARIABLE_TYPE
, EXTERNAL_YN EXTERNAL_YN
, VARIABLE_INTENT VARIABLE_INTENT
, CONTRACT_EXPERT_YN CONTRACT_EXPERT_YN
, DISABLED_YN DISABLED_YN
, VARIABLE_DATATYPE VARIABLE_DATATYPE
, APPLICATION_ID APPLICATION_ID
, VALUE_SET_ID VALUE_SET_ID
, VARIABLE_DEFAULT_VALUE VARIABLE_DEFAULT_VALUE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, XPRT_VALUE_SET_NAME XPRT_VALUE_SET_NAME
, LINE_LEVEL_FLAG LINE_LEVEL_FLAG
, DATE_PUBLISHED DATE_PUBLISHED
, ORIG_SYSTEM_REFERENCE_CODE ORIG_SYSTEM_REFERENCE_CODE
, ORIG_SYSTEM_REFERENCE_ID1 ORIG_SYSTEM_REFERENCE_ID1
, ORIG_SYSTEM_REFERENCE_ID2 ORIG_SYSTEM_REFERENCE_ID2
, PROCEDURE_NAME PROCEDURE_NAME
, VARIABLE_SOURCE VARIABLE_SOURCE
, CLM_SOURCE CLM_SOURCE
, CLM_REF1 CLM_REF1
, CLM_REF2 CLM_REF2
, CLM_REF3 CLM_REF3
, CLM_REF4 CLM_REF4
, CLM_REF5 CLM_REF5
, MRV_FLAG MRV_FLAG
, MRV_TMPL_CODE MRV_TMPL_CODE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "OKC"."OKC_BUS_VARIABLES_B"