DW_BEN_RELATIONSHIP_EF (Preview)

This table requires activation of Benefits functional area. It stores benefit relationship details.

Details

Module: Benefits

Key Columns

BENEFIT_RELATION_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BENEFIT_RELATION_ID NUMBER 38 0 True Relationship Identifier
EFFECTIVE_START_DATE DATE True Relationship Start Date
EFFECTIVE_END_DATE DATE True Relationship End date
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
BENEFIT_RELATION_NAME VARCHAR2 256 Relationship Name
STATUS VARCHAR2 32 Relationship Status
REL_USG_CD VARCHAR2 32 Relationship Usage Code
REL_PRIMARY_FLAG VARCHAR2 32 Relationship Primary Flag
REL_PRMRY_ASG_ID NUMBER 38 0 Relationship Assignment Identifier
PERSON_ID NUMBER 38 0 Person Identifier
PERSON_HABIT_ID NUMBER 38 0 Person Habit Identifier DW_BEN_HABITS_D PERSON_HABIT_ID
ANCHOR_DATE DATE Relationship Start Date
ASSIGNMENT_NUMBER VARCHAR2 32 Assignment Number
PRIMARY_FLAG VARCHAR2 32 Represents overall Primary assignment
ASSIGNMENT_STATUS_TYPE_ID NUMBER 38 0 Assignment Status Type Identifier DW_ASSIGNMENT_STATUS_D_TL ASSIGNMENT_STATUS_TYPE_ID
ASSIGNMENT_CATEGORY VARCHAR2 32 User defined category. For example Full-Time Permanent or Part-Time Permanent DW_ASSIGNMENT_CATEGORY_D_TL ASSIGNMENT_CATEGORY
PERMANENT_TEMPORARY_FLAG VARCHAR2 32 Permanent Temporary Flag
HOURLY_SALARIED_CODE VARCHAR2 32 Paid hourly or salaried code
FULL_PART_TIME_FLAG VARCHAR2 32 Full Part Time Flag
SYSTEM_PERSON_TYPE VARCHAR2 32 Person Type in System
PERSON_TYPE_ID NUMBER 38 0 Person Type DW_PERSON_TYPE_D_TL PERSON_TYPE_ID
LEGAL_EMPLOYER_ID NUMBER 38 0 Legal Employer DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
BUSINESS_UNIT_ID NUMBER 38 0 Business Unit Identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
LEGISLATION_CODE VARCHAR2 256 Legislation of Assignment DW_LEGISLATION_D_TL LEGISLATION_CODE
JOB_ID NUMBER 38 0 Job Identifier DW_JOB_D JOB_ID
GRADE_ID NUMBER 38 0 Grade Identifier DW_PAY_GRADE_D GRADE_ID
BARGAINING_UNIT_CODE VARCHAR2 32 Bargaining Unit Code
POSITION_ID NUMBER 38 0 Position Identifier DW_POSITION_D POSITION_ID
LOCATION_ID NUMBER 38 0 Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
DEPARTMENT_ID NUMBER 38 0 Department Identifier DW_DEPARTMENT_D DEPARTMENT_ID