DBA Data[Home] [Help] [Dependency Information]

VIEW: BEN.BEN_BENEFIT_ACTIONS#

Object Details
Object Name: BEN_BENEFIT_ACTIONS#
Object Type: VIEW
Owner: BEN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BENEFIT_ACTION_ID NUMBER (15) Yes
PROCESS_DATE DATE
Yes
MODE_CD VARCHAR2 (30) Yes
DERIVABLE_FACTORS_FLAG VARCHAR2 (30) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
VALIDATE_FLAG VARCHAR2 (30) Yes
DEBUG_MESSAGES_FLAG VARCHAR2 (30) Yes
NO_PROGRAMS_FLAG VARCHAR2 (30) Yes
NO_PLANS_FLAG VARCHAR2 (30) Yes
AUDIT_LOG_FLAG VARCHAR2 (30) Yes
LF_EVT_OCRD_DT VARCHAR2 (240)
CLOSE_UNEAI_FLAG VARCHAR2 (30)
UNEAI_EFFECTIVE_DATE DATE

RPTG_GRP_ID NUMBER (15)
LER_ID NUMBER (15)
LEGAL_ENTITY_ID NUMBER (15)
PSTL_ZIP_RNG_ID NUMBER (15)
CM_TYP_ID NUMBER (15)
AGE_FCTR_ID NUMBER (15)
PL_TYP_ID NUMBER (15)
LOS_FCTR_ID NUMBER (15)
CMBN_AGE_LOS_FCTR_ID NUMBER (15)
OPT_ID NUMBER (15)
ACTN_TYP_ID NUMBER (15)
USE_FCTR_TO_SEL_FLAG VARCHAR2 (30)
LOS_DET_TO_USE_CD VARCHAR2 (30)
PTNL_LER_FOR_PER_STAT_CD VARCHAR2 (30)
BFT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
BFT_ATTRIBUTE1 VARCHAR2 (150)
BFT_ATTRIBUTE3 VARCHAR2 (150)
BFT_ATTRIBUTE4 VARCHAR2 (150)
BFT_ATTRIBUTE5 VARCHAR2 (150)
BFT_ATTRIBUTE6 VARCHAR2 (150)
BFT_ATTRIBUTE7 VARCHAR2 (150)
BFT_ATTRIBUTE8 VARCHAR2 (150)
BFT_ATTRIBUTE9 VARCHAR2 (150)
BFT_ATTRIBUTE10 VARCHAR2 (150)
BFT_ATTRIBUTE11 VARCHAR2 (150)
BFT_ATTRIBUTE12 VARCHAR2 (150)
BFT_ATTRIBUTE13 VARCHAR2 (150)
BFT_ATTRIBUTE14 VARCHAR2 (150)
BFT_ATTRIBUTE15 VARCHAR2 (150)
BFT_ATTRIBUTE16 VARCHAR2 (150)
BFT_ATTRIBUTE17 VARCHAR2 (150)
BFT_ATTRIBUTE18 VARCHAR2 (150)
BFT_ATTRIBUTE19 VARCHAR2 (150)
BFT_ATTRIBUTE20 VARCHAR2 (150)
BFT_ATTRIBUTE21 VARCHAR2 (150)
BFT_ATTRIBUTE22 VARCHAR2 (150)
BFT_ATTRIBUTE23 VARCHAR2 (150)
BFT_ATTRIBUTE24 VARCHAR2 (150)
BFT_ATTRIBUTE25 VARCHAR2 (150)
BFT_ATTRIBUTE26 VARCHAR2 (150)
BFT_ATTRIBUTE27 VARCHAR2 (150)
BFT_ATTRIBUTE28 VARCHAR2 (150)
BFT_ATTRIBUTE29 VARCHAR2 (150)
BFT_ATTRIBUTE30 VARCHAR2 (150)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
ORGANIZATION_ID NUMBER (15)
LOCATION_ID NUMBER (15)
PERSON_ID NUMBER (15)
ELIGY_PRFL_ID NUMBER (15)
VRBL_RT_PRFL_ID NUMBER (15)
PAYROLL_ID NUMBER (15)
PGM_ID NUMBER (15)
PL_ID NUMBER (15)
POPL_ENRT_TYP_CYCL_ID NUMBER (15)
COMP_SELECTION_RL NUMBER (15)
PERSON_TYPE_ID NUMBER (15)
BENFTS_GRP_ID NUMBER (15)
PERSON_SELECTION_RL NUMBER (15)
CM_TRGR_TYP_CD VARCHAR2 (30)
MIN_AGE NUMBER (15)
MAX_AGE NUMBER (15)
MIN_LOS NUMBER (15)
MAX_LOS NUMBER (15)
MIN_CMBN NUMBER (15)
MAX_CMBN NUMBER (15)
DATE_FROM DATE

ELIG_ENROL_CD VARCHAR2 (30)
LMT_PRPNIP_BY_ORG_FLAG VARCHAR2 (30)
INELG_ACTION_CD VARCHAR2 (30)
GRANT_PRICE_VAL NUMBER

ENRT_PERD_ID NUMBER (15)
ASG_EVENTS_TO_ALL_SEL_DT VARCHAR2 (30)
CAGR_ID NUMBER (15)
CONCAT_SEGS VARCHAR2 (2000)
GRADE_LADDER_ID NUMBER (15)
ORG_HIERARCHY_ID NUMBER (15)
ORG_STARTING_NODE_ID NUMBER (15)
PER_SEL_DT_CD VARCHAR2 (30)
PER_SEL_DT_FROM DATE

PER_SEL_DT_TO DATE

PER_SEL_FREQ_CD VARCHAR2 (30)
QUAL_STATUS VARCHAR2 (30)
QUAL_TYPE NUMBER

RATE_ID NUMBER (15)
YEAR_FROM NUMBER

YEAR_TO NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

BEN.BEN_BENEFIT_ACTIONS# references the following:

SchemaBEN
TableBEN_BENEFIT_ACTIONS
BEN.BEN_BENEFIT_ACTIONS# is referenced by following:

SchemaAPPS
SynonymBEN_BENEFIT_ACTIONS
TriggerBEN_BENEFIT_ACTIONS_WHO