DW_BEN_RELATIONSHIP_MONTHLY_SNAPSHOT_F (Preview)

This table requires activation of Benefits functional area. Benefits Relationship Monthly Snapshot

Details

Module: Benefits

Key Columns

BENEFIT_RELATION_ID, CALENDAR_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BENEFIT_RELATION_ID NUMBER 38 0 True Relationship Identifier    
CALENDAR_DATE DATE     True Calendar Date    
SOURCE_RECORD_ID VARCHAR2 256     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 DW_PERSON_D PERSON_ID
PERSON_HABIT_ID NUMBER 38 0   Person Habit Identifier DW_BEN_HABITS_D PERSON_HABIT_ID
EFFECTIVE_START_DATE DATE       Relationship effective Start Date    
EFFECTIVE_END_DATE DATE       Relationship effective End 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#8 DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
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#5 DW_DEPARTMENT_D DEPARTMENT_ID
LEGISLATION_CODE VARCHAR2 256     Legislation of Assignment DW_LEGISLATION_D_TL LEGISLATION_CODE
LAST_DAY_CAL_MONTH_FLAG VARCHAR2 32     Last Day of the month Indicator    

Copyright © 2019, 2025, Oracle and/or its affiliates.