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

Banner Operational Data Store
Reporting View Target: BENEFICIARY_SLOT

Description Uses data from the BENEFICIARY_DEPENDENT view, displays up to five sets of values pertaining to beneficiaries.
Key & Frequency One row per person per carrier.
Recommended Search Columns PERSON_UID, CARRIER
ACTIVITY_DATE

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACA_REPORTABLE_CHILD_IND1 ACA Reportable Child Indicator 1 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

ACA_REPORTABLE_CHILD_IND2 ACA Reportable Child Indicator 2 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

ACA_REPORTABLE_CHILD_IND3 ACA Reportable Child Indicator 3 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

ACA_REPORTABLE_CHILD_IND4 ACA Reportable Child Indicator 4 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

ACA_REPORTABLE_CHILD_IND5 ACA Reportable Child Indicator 5 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

ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE

NA

SYSDATE

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

NA

NA

BENEFICIARY_BIRTH_DATE1 Beneficiary Birth Date 1 Birth date of beneficiary. DATE

PDRBENE

PDRBENE_BIRTH_DATE

BENEFICIARY_BIRTH_DATE2 Beneficiary Birth Date 2 Birth date of beneficiary. DATE

PDRBENE

PDRBENE_BIRTH_DATE

BENEFICIARY_BIRTH_DATE3 Beneficiary Birth Date 3 Birth date of beneficiary. DATE

PDRBENE

PDRBENE_BIRTH_DATE

BENEFICIARY_BIRTH_DATE4 Beneficiary Birth Date 4 Birth date of beneficiary. DATE

PDRBENE

PDRBENE_BIRTH_DATE

BENEFICIARY_BIRTH_DATE5 Beneficiary Birth Date 5 Birth date of beneficiary. DATE

PDRBENE

PDRBENE_BIRTH_DATE

BENEFICIARY_FIRST_NAME1 Beneficiary First Name 1 Beneficiary first name. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_FIRST_NAME

BENEFICIARY_FIRST_NAME2 Beneficiary First Name 2 Beneficiary first name. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_FIRST_NAME

BENEFICIARY_FIRST_NAME3 Beneficiary First Name 3 Beneficiary first name. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_FIRST_NAME

BENEFICIARY_FIRST_NAME4 Beneficiary First Name 4 Beneficiary first name. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_FIRST_NAME

BENEFICIARY_FIRST_NAME5 Beneficiary First Name 5 Beneficiary first name. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_FIRST_NAME

BENEFICIARY_LAST_NAME1 Beneficiary Last Name 1 Beneficiary last name. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_LAST_NAME

BENEFICIARY_LAST_NAME2 Beneficiary Last Name 2 Beneficiary last name. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_LAST_NAME

BENEFICIARY_LAST_NAME3 Beneficiary Last Name 3 Beneficiary last name. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_LAST_NAME

BENEFICIARY_LAST_NAME4 Beneficiary Last Name 4 Beneficiary last name. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_LAST_NAME

BENEFICIARY_LAST_NAME5 Beneficiary Last Name 5 Beneficiary last name. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_LAST_NAME

BENEFICIARY_MIDDLE_INITIAL1 Beneficiary Middle Initial 1 Beneficiary middle initial. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_MI

BENEFICIARY_MIDDLE_INITIAL2 Beneficiary Middle Initial 2 Beneficiary middle initial. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_MI

BENEFICIARY_MIDDLE_INITIAL3 Beneficiary Middle Initial 3 Beneficiary middle initial. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_MI

BENEFICIARY_MIDDLE_INITIAL4 Beneficiary Middle Initial 4 Beneficiary middle initial. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_MI

BENEFICIARY_MIDDLE_INITIAL5 Beneficiary Middle Initial 5 Beneficiary middle initial. VARCHAR2(63)

PDRBENE

PDRBENE_BENE_PIDM

BENEFICIARY_TAX_ID1 Beneficiary Tax ID 1 Tax ID or federal social security number for the beneficiary. VARCHAR2(63)

PDRBENE

PDRBENE_SSN

BENEFICIARY_TAX_ID2 Beneficiary Tax ID 2 Tax ID or federal social security number for the beneficiary. VARCHAR2(63)

PDRBENE

PDRBENE_SSN

BENEFICIARY_TAX_ID3 Beneficiary Tax ID 3 Tax ID or federal social security number for the beneficiary. VARCHAR2(63)

PDRBENE

PDRBENE_SSN

BENEFICIARY_TAX_ID4 Beneficiary Tax ID 4 Tax ID or federal social security number for the beneficiary. VARCHAR2(63)

PDRBENE

PDRBENE_SSN

BENEFICIARY_TAX_ID5 Beneficiary Tax ID 5 Tax ID or federal social security number for the beneficiary. VARCHAR2(63)

PDRBENE

PDRBENE_SSN

BENEFICIARY_UID1 Beneficiary UID 1 System generated, unique, internal identification number assigned to this person. NUMBER

PDRBENE

PDRBENE_BENE_PIDM

BENEFICIARY_UID2 Beneficiary UID 2 System generated, unique, internal identification number assigned to this person. NUMBER

PDRBENE

PDRBENE_BENE_PIDM

BENEFICIARY_UID3 Beneficiary UID 3 System generated, unique, internal identification number assigned to this person. NUMBER

PDRBENE

PDRBENE_BENE_PIDM

BENEFICIARY_UID4 Beneficiary UID 4 System generated, unique, internal identification number assigned to this person. NUMBER

PDRBENE

PDRBENE_BENE_PIDM

BENEFICIARY_UID5 Beneficiary UID 5 System generated, unique, internal identification number assigned to this person. NUMBER

PDRBENE

PDRBENE_BENE_PIDM

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

PDRBCOV

PDRBCOV_BDCA_CODE

COVERAGE_BEGIN_DATE1 Coverage Begin Date 1 Date the benefit/deduction begins. DATE

PDRBCOV

PDRBCOV_BEGIN_DATE

COVERAGE_BEGIN_DATE2 Coverage Begin Date 2 Date the benefit/deduction begins. DATE

PDRBCOV

PDRBCOV_BEGIN_DATE

COVERAGE_BEGIN_DATE3 Coverage Begin Date 3 Date the benefit/deduction begins. DATE

PDRBCOV

PDRBCOV_BEGIN_DATE

COVERAGE_BEGIN_DATE4 Coverage Begin Date 4 Date the benefit/deduction begins. DATE

PDRBCOV

PDRBCOV_BEGIN_DATE

COVERAGE_BEGIN_DATE5 Coverage Begin Date 5 Date the benefit/deduction begins. DATE

PDRBCOV

PDRBCOV_BEGIN_DATE

COVERAGE_END_DATE1 Coverage End Date 1 Date the benefit/deduction ends. DATE

PDRBCOV

PDRBCOV_END_DATE

COVERAGE_END_DATE2 Coverage End Date 2 Date the benefit/deduction ends. DATE

PDRBCOV

PDRBCOV_END_DATE

COVERAGE_END_DATE3 Coverage End Date 3 Date the benefit/deduction ends. DATE

PDRBCOV

PDRBCOV_END_DATE

COVERAGE_END_DATE4 Coverage End Date 4 Date the benefit/deduction ends. DATE

PDRBCOV

PDRBCOV_END_DATE

COVERAGE_END_DATE5 Coverage End Date 5 Date the benefit/deduction ends. DATE

PDRBCOV

PDRBCOV_END_DATE

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

NA

NA

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

NA

NA

OTHER_COVERAGE_IND1 Other Coverage Indicator 1 Indicator which indicates whether Beneficiary is otherwise covered. VARCHAR2(1)

PDRBCOV

PDRBCOV_OTHER_COV_IND

OTHER_COVERAGE_IND2 Other Coverage Indicator 2 Indicator which indicates whether Beneficiary is otherwise covered. VARCHAR2(1)

PDRBCOV

PDRBCOV_OTHER_COV_IND

OTHER_COVERAGE_IND3 Other Coverage Indicator 3 Indicator which indicates whether Beneficiary is otherwise covered. VARCHAR2(1)

PDRBCOV

PDRBCOV_OTHER_COV_IND

OTHER_COVERAGE_IND4 Other Coverage Indicator 4 Indicator which indicates whether Beneficiary is otherwise covered. VARCHAR2(1)

PDRBCOV

PDRBCOV_OTHER_COV_IND

OTHER_COVERAGE_IND5 Other Coverage Indicator 5 Indicator which indicates whether Beneficiary is otherwise covered. VARCHAR2(1)

PDRBCOV

PDRBCOV_OTHER_COV_IND

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

PDRBENE

PDRBENE_PIDM

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

NA

NA

RELATIONSHIP1 Relationship 1 Code used to identify the relationship of the beneficiary to the employee. VARCHAR2(63)

PDRBENE

PDRBENE_BREL_CODE

RELATIONSHIP2 Relationship 2 Code used to identify the relationship of the beneficiary to the employee. VARCHAR2(63)

PDRBENE

PDRBENE_BREL_CODE

RELATIONSHIP3 Relationship 3 Code used to identify the relationship of the beneficiary to the employee. VARCHAR2(63)

PDRBENE

PDRBENE_BREL_CODE

RELATIONSHIP4 Relationship 4 Code used to identify the relationship of the beneficiary to the employee. VARCHAR2(63)

PDRBENE

PDRBENE_BREL_CODE

RELATIONSHIP5 Relationship 5 Code used to identify the relationship of the beneficiary to the employee. VARCHAR2(63)

PDRBENE

PDRBENE_BREL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC



Ver: 9.2