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: HRI.HRI_ADM_DGNSTC_SETUP#

Source

View Text - Preformatted


select OBJECT_NAME OBJECT_NAME, OBJECT_TYPE OBJECT_TYPE, DYNAMIC_SQL DYNAMIC_SQL, EXCEPTION_STATUS_MSG_CD EXCEPTION_STATUS_MSG_CD, VALID_STATUS_MSG_CD VALID_STATUS_MSG_CD, EXCEPTION_VALUE EXCEPTION_VALUE, IMPACT_MSG_NAME IMPACT_MSG_NAME, ADD_INFO_URL ADD_INFO_URL, ENABLED_FLAG ENABLED_FLAG, FOUNDATION_HR_FLAG FOUNDATION_HR_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, NULL_IMPACT_MSG_NAME NULL_IMPACT_MSG_NAME, COL_HEADING1 COL_HEADING1, COL_HEADING2 COL_HEADING2, COL_HEADING3 COL_HEADING3, COL_HEADING4 COL_HEADING4, COL_HEADING5 COL_HEADING5, OBJECT_TYPE_DESC OBJECT_TYPE_DESC, OBJECT_NAME_DESC OBJECT_NAME_DESC, DEFAULT_MODE DEFAULT_MODE, REPORT_TYPE REPORT_TYPE, SEQ_NUM SEQ_NUM, COUNT_HEADING COUNT_HEADING, OBJECT_TYPE_MSG_NAME OBJECT_TYPE_MSG_NAME, OBJECT_NAME_MSG_NAME OBJECT_NAME_MSG_NAME, OBJECT_TYPE_DTL_DESC_MSG_NAME OBJECT_TYPE_DTL_DESC_MSG_NAME, OBJECT_NAME_DTL_DESC_MSG_NAME OBJECT_NAME_DTL_DESC_MSG_NAME, FUNCTIONAL_AREA_CD FUNCTIONAL_AREA_CD, DYNAMIC_SQL_TYPE DYNAMIC_SQL_TYPE, ZD_EDITION_NAME ZD_EDITION_NAME from "HRI"."HRI_ADM_DGNSTC_SETUP"

View Text - HTML Formatted

SELECT OBJECT_NAME OBJECT_NAME
, OBJECT_TYPE OBJECT_TYPE
, DYNAMIC_SQL DYNAMIC_SQL
, EXCEPTION_STATUS_MSG_CD EXCEPTION_STATUS_MSG_CD
, VALID_STATUS_MSG_CD VALID_STATUS_MSG_CD
, EXCEPTION_VALUE EXCEPTION_VALUE
, IMPACT_MSG_NAME IMPACT_MSG_NAME
, ADD_INFO_URL ADD_INFO_URL
, ENABLED_FLAG ENABLED_FLAG
, FOUNDATION_HR_FLAG FOUNDATION_HR_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NULL_IMPACT_MSG_NAME NULL_IMPACT_MSG_NAME
, COL_HEADING1 COL_HEADING1
, COL_HEADING2 COL_HEADING2
, COL_HEADING3 COL_HEADING3
, COL_HEADING4 COL_HEADING4
, COL_HEADING5 COL_HEADING5
, OBJECT_TYPE_DESC OBJECT_TYPE_DESC
, OBJECT_NAME_DESC OBJECT_NAME_DESC
, DEFAULT_MODE DEFAULT_MODE
, REPORT_TYPE REPORT_TYPE
, SEQ_NUM SEQ_NUM
, COUNT_HEADING COUNT_HEADING
, OBJECT_TYPE_MSG_NAME OBJECT_TYPE_MSG_NAME
, OBJECT_NAME_MSG_NAME OBJECT_NAME_MSG_NAME
, OBJECT_TYPE_DTL_DESC_MSG_NAME OBJECT_TYPE_DTL_DESC_MSG_NAME
, OBJECT_NAME_DTL_DESC_MSG_NAME OBJECT_NAME_DTL_DESC_MSG_NAME
, FUNCTIONAL_AREA_CD FUNCTIONAL_AREA_CD
, DYNAMIC_SQL_TYPE DYNAMIC_SQL_TYPE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HRI"."HRI_ADM_DGNSTC_SETUP"