DW_BEN_HABITS_CURRENT_D (Preview)

This table requires activation of Benefits functional area. Employees habits details current view

Details

Module: Benefits

Key Columns

LEGAL_ENTITY_ID, PERSON_HABIT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PERSON_HABIT_ID NUMBER 38 0 True Person Habit Identifier
LEGAL_ENTITY_ID NUMBER 38 0 True Legal Entity Identifier
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
PERSON_ID NUMBER 38 0 Person Identifier
STUDENT_STATUS VARCHAR2 32 Student Status
COVRD_IN_ANTHR_PLAN VARCHAR2 32 Covered in Another Plan
COORD_MED_PLAN_NAME VARCHAR2 256 Coordinated Medical Plan Name