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

VIEW: HR.BEN_BENEFIT_CLASSIFICATIONS#

Object Details
Object Name: BEN_BENEFIT_CLASSIFICATIONS#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BENEFIT_CLASSIFICATION_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
ACTIVE_FLAG VARCHAR2 (30) Yes
BENEFICIARY_ALLOWED_FLAG VARCHAR2 (30) Yes
BENEFIT_CLASSIFICATION_NAME VARCHAR2 (80) Yes
BENEFIT_CLASSIFICATION_TYPE VARCHAR2 (30) Yes
CHARGEABLE_FLAG VARCHAR2 (30) Yes
COBRA_FLAG VARCHAR2 (30) Yes
CONTRIBUTIONS_USED VARCHAR2 (30) Yes
DEPENDENTS_ALLOWED_FLAG VARCHAR2 (30) Yes
DFLT_POST_TERMINATION_RULE VARCHAR2 (30) Yes
DFLT_PROCESSING_TYPE VARCHAR2 (30) Yes
BEN_CLASS_PROCESSING_RULE VARCHAR2 (30)
LAST_UPDATE_DATE DATE

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

COMMENTS CLOB (4000)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT BENEFIT_CLASSIFICATION_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      ACTIVE_FLAG
,      BENEFICIARY_ALLOWED_FLAG
,      BENEFIT_CLASSIFICATION_NAME
,      BENEFIT_CLASSIFICATION_TYPE
,      CHARGEABLE_FLAG
,      COBRA_FLAG
,      CONTRIBUTIONS_USED
,      DEPENDENTS_ALLOWED_FLAG
,      DFLT_POST_TERMINATION_RULE
,      DFLT_PROCESSING_TYPE
,      BEN_CLASS_PROCESSING_RULE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      COMMENTS
,      ZD_EDITION_NAME
FROM HR.BEN_BENEFIT_CLASSIFICATIONS#;

Dependencies

[top of page]

HR.BEN_BENEFIT_CLASSIFICATIONS# references the following:

SchemaHR
TableBEN_BENEFIT_CLASSIFICATIONS
HR.BEN_BENEFIT_CLASSIFICATIONS# is referenced by following:

SchemaAPPS
SynonymBEN_BENEFIT_CLASSIFICATIONS
TriggerBEN_BENEFIT_CLASSIFICATIONS+
TriggerBEN_BENEFIT_CLASSIFICATION_WHO