# DW_BEN_PARTICIPANT_RATE_MONTHLY_SNAPSHOT_F (Preview)

This table requires activation of Benefits functional area. This monthly snapshot holds the values, tax consequence and other information about standard rates for a person enrolled in a plan/option.

## Details

Module: Benefits

## Key Columns

PRTT_RT_VAL_ID, CALENDAR_DATE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PRTT_RT_VAL_ID | NUMBER | 38 | 0 | True | Rate Identifier |  |
CALENDAR_DATE | DATE |  |  | True | Calendar Date |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier |  |
RT_STRT_DT | DATE |  |  |  | Rate Start Date |  |
RT_END_DT | DATE |  |  |  | Rate End Date |  |
PRTT_RT_VAL_STAT_CD | VARCHAR2 | 32 |  |  | Rate Value Status Code |  |
RATE_DISPLAY_CD | VARCHAR2 | 32 |  |  | Rate Display Code |  |
RCRRG_FLAG | VARCHAR2 | 32 |  |  | Recurring Flag |  |
TX_TYP_CD | VARCHAR2 | 32 |  |  | Tax Type |  |
ACTY_TYP_CD | VARCHAR2 | 32 |  |  | Activity Type |  |
MLTPLY_CD | VARCHAR2 | 32 |  |  | Multiply Code |  |
RT_OVRIDN_FLAG | VARCHAR2 | 32 |  |  | Rate Overridden |  |
RT_VAL | NUMBER |  |  |  | Defined Amount |  |
GLOBAL_RT_VAL | NUMBER |  |  |  | Defined Amount in global currency |  |
DEFINED_RT_FREQ | VARCHAR2 | 32 |  |  | Defined Rate Frequency |  |
CMCD_RT_VAL | NUMBER |  |  |  | Communicated Amount |  |
GLOBAL_CMCD_RT_VAL | NUMBER |  |  |  | Communicated Amount in global currency |  |
CMCD_REF_PERD_CD | VARCHAR2 | 32 |  |  | Communicated Rate Period |  |
ANN_RT_VAL | NUMBER |  |  |  | Annual Rate |  |
GLOBAL_ANN_RT_VAL | NUMBER |  |  |  | Annual Rate in global currency |  |
UOM | VARCHAR2 | 32 |  |  | Unit of measure |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier |  |
BENEFIT_RELATION_ID | NUMBER | 38 | 0 |  | Benefit Relation Identifier |  |
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment Identifier |  |
LER_ID | NUMBER | 38 | 0 |  | Life event Identifier | DW_BEN_LIFE_EVENT_D | LER_ID
PERSON_HABIT_ID | NUMBER | 38 | 0 |  | Person Habit Identifier | DW_BEN_HABITS_D | PERSON_ID
PTNL_LER_ID | NUMBER | 38 | 0 |  | Potential Life Event Identifier |  |
EVLTD_LER_ID | NUMBER | 38 | 0 |  | Evaluated Event Identifier |  |
PROGRAM_ID | NUMBER | 38 | 0 |  | Program Identifer | DW_BEN_PROGRAM_D | PROGRAM_ID
PLAN_TYPE_ID | NUMBER | 38 | 0 |  | Plan Type Identifier | DW_BEN_PLAN_TYPE_D | PLAN_TYPE_ID
PLAN_ID | NUMBER | 38 | 0 |  | Plan Identifier | DW_BEN_PLAN_D | PLAN_ID
OPTION_ID | NUMBER | 38 | 0 |  | Option Identifier | DW_BEN_PLAN_OPTION_D | OPTION_ID
PAYPERIOD_IN_YEAR_USED | NUMBER |  |  |  | Pay periods in year used |  |
ELEMENT_ENTRY_VALUE_ID | NUMBER | 38 | 0 |  | Element Entry Value Identifier |  |
PRTT_ENRT_RSLT_ID | NUMBER | 38 | 0 |  | Enrollment Result Identifier |  |
RATE_ID | NUMBER | 38 | 0 |  | Rate Identifier |  |
NON_MONETARY_UOM | VARCHAR2 | 32 |  |  | Non-monetary Unit of Measure |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Global Currency Code |  |
GLOBAL_CURRENCY_EXCH_RATE | NUMBER |  |  |  | Global currency conversion rate. |  |
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
LAST_DAY_CAL_MONTH_FLAG | VARCHAR2 | 32 |  |  | Last Day of the month Indicator |  |

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