Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Human Resources Reporting View Reports

Banner Operational Data Store
Reporting View Target: BENEFICIARY_DEPENDENT

Description Contains employee beneficiary information.
Key & Frequency One row per person per beneficiary per sequence number per relationship.
Recommended Search Columns PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACA_REPORTABLE_CHILD_IND Indicates if the child is reportable under the current definition of child dependent. Valid values are (Y)es or (N)o. VARCHAR2(1)

PDRBENE

PDRBENE_ACA_CHILD_REPORT_IND

NO

NO
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
BENEFICIARY_BIRTH_DATE Birth date of beneficiary. DATE

PDRBENE

PDRBENE_BIRTH_DATE

NO

NO
BENEFICIARY_ID Person's current identification number. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

NO

NO
BENEFICIARY_NAME Beneficiary full name. VARCHAR2(255)

CALCULATION

DECODE(BENEFICIARY_NAME)

NO

NO
BENEFICIARY_TAX_ID Tax ID or federal social security number for the beneficiary. VARCHAR2(63)

PDRBENE

PDRBENE_SSN

NO

NO
BENEFICIARY_UID System generated, unique, internal identification number assigned to this person. NUMBER

PDRBENE

PDRBENE_BENE_PIDM

NO

NO
BENEFIT_GROUP Benefit group. VARCHAR2(255)

NA

NA

NO

NO
CARRIER Identifies the specific benefit/deduction provider. VARCHAR2(63)

PDRBCOV

PDRBCOV_BDCA_CODE

NO

NO
CARRIER_LONG_DESC Benefit/deduction long description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
CARRIER_SHORT_DESC Benefit/deduction short description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COVERAGE_BEGIN_DATE Date the benefit/deduction begins. DATE

PDRBCOV

PDRBCOV_BEGIN_DATE

NO

NO
COVERAGE_END_DATE Date the benefit/deduction ends. DATE

PDRBCOV

PDRBCOV_END_DATE

NO

NO
COVERAGE_OPTION Coverage option associated with this benefit. VARCHAR2(255)

NA

NA

NO

NO
COVERAGE_OPTION_DESC Coverage option description. VARCHAR2(255)

NA

NA

NO

NO
ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

NO

NO
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
OTHER_COVERAGE_IND Indicator which indicates whether Beneficiary is otherwise covered. VARCHAR2(1)

PDRBCOV

PDRBCOV_OTHER_COV_IND

NO

NO
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

PDRBENE

PDRBENE_PIDM

NO

NO
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
RELATIONSHIP Code used to identify the relationship of the beneficiary to the employee. VARCHAR2(1)

PDRBENE

PDRBENE_BREL_CODE

NO

NO
RELATIONSHIP_DESC Relationship description. Identifies the various types of beneficiary relationships to an employee. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
SEQUENCE_NUMBER Sequence number identifying the dependent/beneficiary. NUMBER

PDRBENE

PDRBENE_SEQ_NO

NO

NO


Ver: 9.2