DW_BEN_BENEFICIARY_ORG_D (Preview)

This table requires activation of Benefits functional area. Beneficiary oraganization or trustee's details

Details

Module: Benefits

Key Columns

BNF_ORG_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
BNF_ORG_ID NUMBER 38 0 True Beneficiary Organization Identifier    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. Unique Source Record Identifier    
START_DATE DATE       Beneficiary Organization Start Date    
END_DATE DATE       Beneficiary Organization End Date    
BNF_TYP_CD VARCHAR2 32     Beneficiary Organization Type (Trust/Organization)    
TRUSTEE_ORG_NAME VARCHAR2 256     Beneficiary Organization Trust Name    
TRUSTEE_ORG_DESCRIPTION VARCHAR2 999     Beneficiary Organization Trust Description    
ORGANIZATION_ID NUMBER 38 0   Beneficiary Existing Organization Identifier    
PERSON_ID NUMBER 38 0   Person Identifier    

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