VIEW: IEX.IEX_SCORES#

Source

View Text - Preformatted

select SCORE_ID SCORE_ID, SCORE_NAME SCORE_NAME, SECURITY_GROUP_ID SECURITY_GROUP_ID, SCORE_DESCRIPTION SCORE_DESCRIPTION, ENABLED_FLAG ENABLED_FLAG, VALID_FROM_DT VALID_FROM_DT, VALID_TO_DT VALID_TO_DT, CAMPAIGN_SCHED_ID CAMPAIGN_SCHED_ID, JTF_OBJECT_CODE JTF_OBJECT_CODE, CONCURRENT_PROG_ID CONCURRENT_PROG_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CONCURRENT_PROG_NAME CONCURRENT_PROG_NAME, STATUS_DETERMINATION STATUS_DETERMINATION, WEIGHT_REQUIRED WEIGHT_REQUIRED, SCORE_RANGE_LOW SCORE_RANGE_LOW, SCORE_RANGE_HIGH SCORE_RANGE_HIGH, OUT_OF_RANGE_RULE OUT_OF_RANGE_RULE, ZD_EDITION_NAME ZD_EDITION_NAME from "IEX"."IEX_SCORES"

View Text - HTML Formatted

SELECT SCORE_ID SCORE_ID
, SCORE_NAME SCORE_NAME
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, SCORE_DESCRIPTION SCORE_DESCRIPTION
, ENABLED_FLAG ENABLED_FLAG
, VALID_FROM_DT VALID_FROM_DT
, VALID_TO_DT VALID_TO_DT
, CAMPAIGN_SCHED_ID CAMPAIGN_SCHED_ID
, JTF_OBJECT_CODE JTF_OBJECT_CODE
, CONCURRENT_PROG_ID CONCURRENT_PROG_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CONCURRENT_PROG_NAME CONCURRENT_PROG_NAME
, STATUS_DETERMINATION STATUS_DETERMINATION
, WEIGHT_REQUIRED WEIGHT_REQUIRED
, SCORE_RANGE_LOW SCORE_RANGE_LOW
, SCORE_RANGE_HIGH SCORE_RANGE_HIGH
, OUT_OF_RANGE_RULE OUT_OF_RANGE_RULE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "IEX"."IEX_SCORES"