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
| 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 |