DW_BEN_PARTICIPANT_CONTACT_CURRENT_D (Preview)

This table requires activation of Benefits functional area. Participant contact information current view

Details

Module: Benefits

Key Columns

CONTACT_RELATIONSHIP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTACT_RELATIONSHIP_ID NUMBER 38 0 True Contact Relationship 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
CONTACT_PERSON_ID NUMBER 38 0 Contact Person Identifier
CONTACT_TYPE VARCHAR2 32 Contact Relationship
EMERGENCY_CONTACT_FLAG VARCHAR2 32 Contact Emergency Contact Flag