Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Human Resources Reporting View Reports

SGHE 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
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

BENEFICIARY_BIRTH_DATE Birth date of beneficiary. DATE

PDRBENE

PDRBENE_BIRTH_DATE

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

SPRIDEN

SPRIDEN_ID

BENEFICIARY_NAME Beneficiary full name. VARCHAR2(255)

CALCULATION

DECODE(BENEFICIARY_NAME)

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

PDRBENE

PDRBENE_SSN

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

PDRBENE

PDRBENE_BENE_PIDM

BENEFIT_GROUP Benefit group. VARCHAR2(255)

NA

NA

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

PDRBCOV

PDRBCOV_BDCA_CODE

CARRIER_LONG_DESC Benefit/deduction long description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CARRIER_SHORT_DESC Benefit/deduction short description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COVERAGE_BEGIN_DATE Date the benefit/deduction begins. DATE

PDRBCOV

PDRBCOV_BEGIN_DATE

COVERAGE_END_DATE Date the benefit/deduction ends. DATE

PDRBCOV

PDRBCOV_END_DATE

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

NA

NA

COVERAGE_OPTION_DESC Coverage option description. VARCHAR2(255)

NA

NA

ID Person's or organization's current identification number. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

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

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

PDRBCOV

PDRBCOV_OTHER_COV_IND

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

PDRBENE

PDRBENE_PIDM

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

NA

NA

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

PDRBENE

PDRBENE_BREL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

SEQUENCE_NUMBER Sequence number identifying the dependent/beneficiary. NUMBER

PDRBENE

PDRBENE_SEQ_NO



Ver: 8.0