# DW_PRFL_PRSN_RSK_LOSS_D

This dimension holds information about Person Profile type for Risk of Loss

## Details

Module: Profile Management

## Key Columns

PROFILE_ITEM_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PROFILE_ITEM_ID | NUMBER | 38 | 0 | True | Key to Profile items |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Primary Key consisting of Assignment Identifier and Calendar Date |  |
PROFILE_ID | NUMBER | 38 | 0 |  | Primary key of Profile | DW_PRFL_PROFILE_D | PROFILE_ID
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business Group |  |
SECTION_ID | NUMBER | 38 | 0 |  | Section Identifier |  |
DATE_FROM | DATE |  |  |  | Date From |  |
DATE_TO | DATE |  |  |  | Date To |  |
SOURCE_TYPE | VARCHAR2 | 32 |  |  | Source Type. For example, HRTR |  |
CONTENT_TYPE_ID | NUMBER | 38 | 0 |  | Content type Identifier | DW_CONTENT_TYPE_D | CONTENT_TYPE_ID
CONTENT_ITEM_ID | NUMBER | 38 | 0 |  | Content item Identifier | DW_CONTENT_ITEM_D | CONTENT_ITEM_ID
RISK_LEVEL_ID | NUMBER | 38 | 0 |  | Risk of Loss Rating | DW_RATING_LEVEL_D | RATING_LEVEL_ID
RISK_REASON | VARCHAR2 | 32 |  |  | Reason |  |
QUALIFIER_ID1 | NUMBER | 38 | 0 |  | Source | DW_PRFL_QUALIFIERS_D | QUALIFIER_ID

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