VIEW: BEN.BEN_BATCH_LER_INFO#

Source

View Text - Preformatted

select BATCH_LER_ID BATCH_LER_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, BENEFIT_ACTION_ID BENEFIT_ACTION_ID, PERSON_ID PERSON_ID, LER_ID LER_ID, LF_EVT_OCRD_DT LF_EVT_OCRD_DT, REPLCD_FLAG REPLCD_FLAG, CRTD_FLAG CRTD_FLAG, TMPRL_FLAG TMPRL_FLAG, DLTD_FLAG DLTD_FLAG, OPEN_AND_CLSD_FLAG OPEN_AND_CLSD_FLAG, CLSD_FLAG CLSD_FLAG, NOT_CRTD_FLAG NOT_CRTD_FLAG, STL_ACTV_FLAG STL_ACTV_FLAG, PER_IN_LER_ID PER_IN_LER_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CLPSD_FLAG CLPSD_FLAG, CLSN_FLAG CLSN_FLAG, NO_EFFECT_FLAG NO_EFFECT_FLAG, CVRGE_RT_PREM_FLAG CVRGE_RT_PREM_FLAG from "BEN"."BEN_BATCH_LER_INFO"

View Text - HTML Formatted

SELECT BATCH_LER_ID BATCH_LER_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BENEFIT_ACTION_ID BENEFIT_ACTION_ID
, PERSON_ID PERSON_ID
, LER_ID LER_ID
, LF_EVT_OCRD_DT LF_EVT_OCRD_DT
, REPLCD_FLAG REPLCD_FLAG
, CRTD_FLAG CRTD_FLAG
, TMPRL_FLAG TMPRL_FLAG
, DLTD_FLAG DLTD_FLAG
, OPEN_AND_CLSD_FLAG OPEN_AND_CLSD_FLAG
, CLSD_FLAG CLSD_FLAG
, NOT_CRTD_FLAG NOT_CRTD_FLAG
, STL_ACTV_FLAG STL_ACTV_FLAG
, PER_IN_LER_ID PER_IN_LER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLPSD_FLAG CLPSD_FLAG
, CLSN_FLAG CLSN_FLAG
, NO_EFFECT_FLAG NO_EFFECT_FLAG
, CVRGE_RT_PREM_FLAG CVRGE_RT_PREM_FLAG
FROM "BEN"."BEN_BATCH_LER_INFO"