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

VIEW: BEN.BEN_REPORTING#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
REPORTING_ID NUMBER (38) Yes
BENEFIT_ACTION_ID NUMBER (38) Yes
THREAD_ID NUMBER (30) Yes
SEQUENCE NUMBER (38) Yes
TEXT VARCHAR2 (2000)
REP_TYP_CD VARCHAR2 (30)
ERROR_MESSAGE_CODE VARCHAR2 (90)
NATIONAL_IDENTIFIER VARCHAR2 (90)
RELATED_PERSON_LER_ID NUMBER (15)
TEMPORAL_LER_ID NUMBER (15)
LER_ID NUMBER (15)
PERSON_ID NUMBER (15)
PGM_ID NUMBER (15)
PL_ID NUMBER (15)
RELATED_PERSON_ID NUMBER (15)
OIPL_ID NUMBER (15)
PL_TYP_ID NUMBER (15)
ACTL_PREM_ID NUMBER (15)
VAL NUMBER

MO_NUM NUMBER (15)
YR_NUM NUMBER (15)
LAST_UPDATE_DATE DATE

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

OBJECT_VERSION_NUMBER NUMBER (9)
CREATED_BY NUMBER (15)
Query Text

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


SELECT REPORTING_ID
,      BENEFIT_ACTION_ID
,      THREAD_ID
,      SEQUENCE
,      TEXT
,      REP_TYP_CD
,      ERROR_MESSAGE_CODE
,      NATIONAL_IDENTIFIER
,      RELATED_PERSON_LER_ID
,      TEMPORAL_LER_ID
,      LER_ID
,      PERSON_ID
,      PGM_ID
,      PL_ID
,      RELATED_PERSON_ID
,      OIPL_ID
,      PL_TYP_ID
,      ACTL_PREM_ID
,      VAL
,      MO_NUM
,      YR_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
FROM BEN.BEN_REPORTING#;

Dependencies

[top of page]

BEN.BEN_REPORTING# references the following:

SchemaBEN
TableBEN_REPORTING
BEN.BEN_REPORTING# is referenced by following:

SchemaAPPS
SynonymBEN_REPORTING
TriggerBEN_REPORTING_WHO