VIEW: BEN.BEN_BENEFIT_ACTIONS#

Source

View Text - Preformatted

select BENEFIT_ACTION_ID BENEFIT_ACTION_ID, PROCESS_DATE PROCESS_DATE, MODE_CD MODE_CD, DERIVABLE_FACTORS_FLAG DERIVABLE_FACTORS_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, VALIDATE_FLAG VALIDATE_FLAG, DEBUG_MESSAGES_FLAG DEBUG_MESSAGES_FLAG, NO_PROGRAMS_FLAG NO_PROGRAMS_FLAG, NO_PLANS_FLAG NO_PLANS_FLAG, AUDIT_LOG_FLAG AUDIT_LOG_FLAG, LF_EVT_OCRD_DT LF_EVT_OCRD_DT, CLOSE_UNEAI_FLAG CLOSE_UNEAI_FLAG, UNEAI_EFFECTIVE_DATE UNEAI_EFFECTIVE_DATE, RPTG_GRP_ID RPTG_GRP_ID, LER_ID LER_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PSTL_ZIP_RNG_ID PSTL_ZIP_RNG_ID, CM_TYP_ID CM_TYP_ID, AGE_FCTR_ID AGE_FCTR_ID, PL_TYP_ID PL_TYP_ID, LOS_FCTR_ID LOS_FCTR_ID, CMBN_AGE_LOS_FCTR_ID CMBN_AGE_LOS_FCTR_ID, OPT_ID OPT_ID, ACTN_TYP_ID ACTN_TYP_ID, USE_FCTR_TO_SEL_FLAG USE_FCTR_TO_SEL_FLAG, LOS_DET_TO_USE_CD LOS_DET_TO_USE_CD, PTNL_LER_FOR_PER_STAT_CD PTNL_LER_FOR_PER_STAT_CD, BFT_ATTRIBUTE_CATEGORY BFT_ATTRIBUTE_CATEGORY, BFT_ATTRIBUTE1 BFT_ATTRIBUTE1, BFT_ATTRIBUTE3 BFT_ATTRIBUTE3, BFT_ATTRIBUTE4 BFT_ATTRIBUTE4, BFT_ATTRIBUTE5 BFT_ATTRIBUTE5, BFT_ATTRIBUTE6 BFT_ATTRIBUTE6, BFT_ATTRIBUTE7 BFT_ATTRIBUTE7, BFT_ATTRIBUTE8 BFT_ATTRIBUTE8, BFT_ATTRIBUTE9 BFT_ATTRIBUTE9, BFT_ATTRIBUTE10 BFT_ATTRIBUTE10, BFT_ATTRIBUTE11 BFT_ATTRIBUTE11, BFT_ATTRIBUTE12 BFT_ATTRIBUTE12, BFT_ATTRIBUTE13 BFT_ATTRIBUTE13, BFT_ATTRIBUTE14 BFT_ATTRIBUTE14, BFT_ATTRIBUTE15 BFT_ATTRIBUTE15, BFT_ATTRIBUTE16 BFT_ATTRIBUTE16, BFT_ATTRIBUTE17 BFT_ATTRIBUTE17, BFT_ATTRIBUTE18 BFT_ATTRIBUTE18, BFT_ATTRIBUTE19 BFT_ATTRIBUTE19, BFT_ATTRIBUTE20 BFT_ATTRIBUTE20, BFT_ATTRIBUTE21 BFT_ATTRIBUTE21, BFT_ATTRIBUTE22 BFT_ATTRIBUTE22, BFT_ATTRIBUTE23 BFT_ATTRIBUTE23, BFT_ATTRIBUTE24 BFT_ATTRIBUTE24, BFT_ATTRIBUTE25 BFT_ATTRIBUTE25, BFT_ATTRIBUTE26 BFT_ATTRIBUTE26, BFT_ATTRIBUTE27 BFT_ATTRIBUTE27, BFT_ATTRIBUTE28 BFT_ATTRIBUTE28, BFT_ATTRIBUTE29 BFT_ATTRIBUTE29, BFT_ATTRIBUTE30 BFT_ATTRIBUTE30, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, PERSON_ID PERSON_ID, ELIGY_PRFL_ID ELIGY_PRFL_ID, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID, PAYROLL_ID PAYROLL_ID, PGM_ID PGM_ID, PL_ID PL_ID, POPL_ENRT_TYP_CYCL_ID POPL_ENRT_TYP_CYCL_ID, COMP_SELECTION_RL COMP_SELECTION_RL, PERSON_TYPE_ID PERSON_TYPE_ID, BENFTS_GRP_ID BENFTS_GRP_ID, PERSON_SELECTION_RL PERSON_SELECTION_RL, CM_TRGR_TYP_CD CM_TRGR_TYP_CD, MIN_AGE MIN_AGE, MAX_AGE MAX_AGE, MIN_LOS MIN_LOS, MAX_LOS MAX_LOS, MIN_CMBN MIN_CMBN, MAX_CMBN MAX_CMBN, DATE_FROM DATE_FROM, ELIG_ENROL_CD ELIG_ENROL_CD, LMT_PRPNIP_BY_ORG_FLAG LMT_PRPNIP_BY_ORG_FLAG, INELG_ACTION_CD INELG_ACTION_CD, GRANT_PRICE_VAL GRANT_PRICE_VAL, ENRT_PERD_ID ENRT_PERD_ID, ASG_EVENTS_TO_ALL_SEL_DT ASG_EVENTS_TO_ALL_SEL_DT, CAGR_ID CAGR_ID, CONCAT_SEGS CONCAT_SEGS, GRADE_LADDER_ID GRADE_LADDER_ID, ORG_HIERARCHY_ID ORG_HIERARCHY_ID, ORG_STARTING_NODE_ID ORG_STARTING_NODE_ID, PER_SEL_DT_CD PER_SEL_DT_CD, PER_SEL_DT_FROM PER_SEL_DT_FROM, PER_SEL_DT_TO PER_SEL_DT_TO, PER_SEL_FREQ_CD PER_SEL_FREQ_CD, QUAL_STATUS QUAL_STATUS, QUAL_TYPE QUAL_TYPE, RATE_ID RATE_ID, YEAR_FROM YEAR_FROM, YEAR_TO YEAR_TO from "BEN"."BEN_BENEFIT_ACTIONS"

View Text - HTML Formatted

SELECT BENEFIT_ACTION_ID BENEFIT_ACTION_ID
, PROCESS_DATE PROCESS_DATE
, MODE_CD MODE_CD
, DERIVABLE_FACTORS_FLAG DERIVABLE_FACTORS_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, VALIDATE_FLAG VALIDATE_FLAG
, DEBUG_MESSAGES_FLAG DEBUG_MESSAGES_FLAG
, NO_PROGRAMS_FLAG NO_PROGRAMS_FLAG
, NO_PLANS_FLAG NO_PLANS_FLAG
, AUDIT_LOG_FLAG AUDIT_LOG_FLAG
, LF_EVT_OCRD_DT LF_EVT_OCRD_DT
, CLOSE_UNEAI_FLAG CLOSE_UNEAI_FLAG
, UNEAI_EFFECTIVE_DATE UNEAI_EFFECTIVE_DATE
, RPTG_GRP_ID RPTG_GRP_ID
, LER_ID LER_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PSTL_ZIP_RNG_ID PSTL_ZIP_RNG_ID
, CM_TYP_ID CM_TYP_ID
, AGE_FCTR_ID AGE_FCTR_ID
, PL_TYP_ID PL_TYP_ID
, LOS_FCTR_ID LOS_FCTR_ID
, CMBN_AGE_LOS_FCTR_ID CMBN_AGE_LOS_FCTR_ID
, OPT_ID OPT_ID
, ACTN_TYP_ID ACTN_TYP_ID
, USE_FCTR_TO_SEL_FLAG USE_FCTR_TO_SEL_FLAG
, LOS_DET_TO_USE_CD LOS_DET_TO_USE_CD
, PTNL_LER_FOR_PER_STAT_CD PTNL_LER_FOR_PER_STAT_CD
, BFT_ATTRIBUTE_CATEGORY BFT_ATTRIBUTE_CATEGORY
, BFT_ATTRIBUTE1 BFT_ATTRIBUTE1
, BFT_ATTRIBUTE3 BFT_ATTRIBUTE3
, BFT_ATTRIBUTE4 BFT_ATTRIBUTE4
, BFT_ATTRIBUTE5 BFT_ATTRIBUTE5
, BFT_ATTRIBUTE6 BFT_ATTRIBUTE6
, BFT_ATTRIBUTE7 BFT_ATTRIBUTE7
, BFT_ATTRIBUTE8 BFT_ATTRIBUTE8
, BFT_ATTRIBUTE9 BFT_ATTRIBUTE9
, BFT_ATTRIBUTE10 BFT_ATTRIBUTE10
, BFT_ATTRIBUTE11 BFT_ATTRIBUTE11
, BFT_ATTRIBUTE12 BFT_ATTRIBUTE12
, BFT_ATTRIBUTE13 BFT_ATTRIBUTE13
, BFT_ATTRIBUTE14 BFT_ATTRIBUTE14
, BFT_ATTRIBUTE15 BFT_ATTRIBUTE15
, BFT_ATTRIBUTE16 BFT_ATTRIBUTE16
, BFT_ATTRIBUTE17 BFT_ATTRIBUTE17
, BFT_ATTRIBUTE18 BFT_ATTRIBUTE18
, BFT_ATTRIBUTE19 BFT_ATTRIBUTE19
, BFT_ATTRIBUTE20 BFT_ATTRIBUTE20
, BFT_ATTRIBUTE21 BFT_ATTRIBUTE21
, BFT_ATTRIBUTE22 BFT_ATTRIBUTE22
, BFT_ATTRIBUTE23 BFT_ATTRIBUTE23
, BFT_ATTRIBUTE24 BFT_ATTRIBUTE24
, BFT_ATTRIBUTE25 BFT_ATTRIBUTE25
, BFT_ATTRIBUTE26 BFT_ATTRIBUTE26
, BFT_ATTRIBUTE27 BFT_ATTRIBUTE27
, BFT_ATTRIBUTE28 BFT_ATTRIBUTE28
, BFT_ATTRIBUTE29 BFT_ATTRIBUTE29
, BFT_ATTRIBUTE30 BFT_ATTRIBUTE30
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, PERSON_ID PERSON_ID
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, VRBL_RT_PRFL_ID VRBL_RT_PRFL_ID
, PAYROLL_ID PAYROLL_ID
, PGM_ID PGM_ID
, PL_ID PL_ID
, POPL_ENRT_TYP_CYCL_ID POPL_ENRT_TYP_CYCL_ID
, COMP_SELECTION_RL COMP_SELECTION_RL
, PERSON_TYPE_ID PERSON_TYPE_ID
, BENFTS_GRP_ID BENFTS_GRP_ID
, PERSON_SELECTION_RL PERSON_SELECTION_RL
, CM_TRGR_TYP_CD CM_TRGR_TYP_CD
, MIN_AGE MIN_AGE
, MAX_AGE MAX_AGE
, MIN_LOS MIN_LOS
, MAX_LOS MAX_LOS
, MIN_CMBN MIN_CMBN
, MAX_CMBN MAX_CMBN
, DATE_FROM DATE_FROM
, ELIG_ENROL_CD ELIG_ENROL_CD
, LMT_PRPNIP_BY_ORG_FLAG LMT_PRPNIP_BY_ORG_FLAG
, INELG_ACTION_CD INELG_ACTION_CD
, GRANT_PRICE_VAL GRANT_PRICE_VAL
, ENRT_PERD_ID ENRT_PERD_ID
, ASG_EVENTS_TO_ALL_SEL_DT ASG_EVENTS_TO_ALL_SEL_DT
, CAGR_ID CAGR_ID
, CONCAT_SEGS CONCAT_SEGS
, GRADE_LADDER_ID GRADE_LADDER_ID
, ORG_HIERARCHY_ID ORG_HIERARCHY_ID
, ORG_STARTING_NODE_ID ORG_STARTING_NODE_ID
, PER_SEL_DT_CD PER_SEL_DT_CD
, PER_SEL_DT_FROM PER_SEL_DT_FROM
, PER_SEL_DT_TO PER_SEL_DT_TO
, PER_SEL_FREQ_CD PER_SEL_FREQ_CD
, QUAL_STATUS QUAL_STATUS
, QUAL_TYPE QUAL_TYPE
, RATE_ID RATE_ID
, YEAR_FROM YEAR_FROM
, YEAR_TO YEAR_TO
FROM "BEN"."BEN_BENEFIT_ACTIONS"