VIEW: HRI.HRI_MB_BEN_ENRLACTN_CT#

Source

View Text - Preformatted

select SSPND_IND SSPND_IND, ACTN_ITEM_IND ACTN_ITEM_IND, INTERIM_IND INTERIM_IND, CHANGE_DATE CHANGE_DATE, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PERSON_ID PERSON_ID, ASND_LF_EVT_DT ASND_LF_EVT_DT, ACTN_TYP_CD ACTN_TYP_CD, COMPOBJ_SK_PK COMPOBJ_SK_PK, ENRT_PERD_ID ENRT_PERD_ID, ACTN_TYP_ID ACTN_TYP_ID, PER_IN_LER_ID PER_IN_LER_ID, PRTT_ENRT_ACTN_ID PRTT_ENRT_ACTN_ID, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID, INTERIM_ENRT_RSLT_ID INTERIM_ENRT_RSLT_ID, INTERIM_COMPOBJ_SK_PK INTERIM_COMPOBJ_SK_PK, DUE_DT DUE_DT, 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 from "HRI"."HRI_MB_BEN_ENRLACTN_CT"

View Text - HTML Formatted

SELECT SSPND_IND SSPND_IND
, ACTN_ITEM_IND ACTN_ITEM_IND
, INTERIM_IND INTERIM_IND
, CHANGE_DATE CHANGE_DATE
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PERSON_ID PERSON_ID
, ASND_LF_EVT_DT ASND_LF_EVT_DT
, ACTN_TYP_CD ACTN_TYP_CD
, COMPOBJ_SK_PK COMPOBJ_SK_PK
, ENRT_PERD_ID ENRT_PERD_ID
, ACTN_TYP_ID ACTN_TYP_ID
, PER_IN_LER_ID PER_IN_LER_ID
, PRTT_ENRT_ACTN_ID PRTT_ENRT_ACTN_ID
, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID
, INTERIM_ENRT_RSLT_ID INTERIM_ENRT_RSLT_ID
, INTERIM_COMPOBJ_SK_PK INTERIM_COMPOBJ_SK_PK
, DUE_DT DUE_DT
, 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
FROM "HRI"."HRI_MB_BEN_ENRLACTN_CT"