RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Operational Data Store
Composite View Target: AP_BENEFICIARY_DEPENDENT

Description Source composite view contains beneficiary and benefit information for an employee.

Target Column Business Definition Database Data Type Source Name Source Column
BENEFICIARY_BIRTH_DATE Birth date of beneficiary. DATE

PDRBENE

PDRBENE_BIRTH_DATE

BENEFICIARY_FIRST_NAME First name of beneficiary. VARCHAR2(15)

PDRBENE

PDRBENE_BENE_FIRST_NAME

BENEFICIARY_LAST_NAME Last name of beneficiary. VARCHAR2(30)

PDRBENE

PDRBENE_BENE_LAST_NAME

BENEFICIARY_MIDDLE_INITIAL Middle initial of beneficiary. VARCHAR2(15)

PDRBENE

PDRBENE_BENE_MI

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

PDRBENE

PDRBENE_SSN

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

PDRBENE

PDRBENE_BENE_PIDM

BENEFIT_GROUP Benefit group. VARCHAR2(0)

NA

NA

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

PDRBCOV

PDRBCOV_BDCA_CODE

CARRIER_LONG_DESC Benefit/deduction long description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

CARRIER_SHORT_DESC Benefit/deduction short description. VARCHAR2(30)

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(0)

NA

NA

COVERAGE_OPTION_DESC Coverage option description. VARCHAR2(0)

NA

NA

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

NA

NA

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

NA

NA

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

PDRBCOV

PDRBCOV_OTHER_COV_IND

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

PDRBENE

PDRBENE_PIDM

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(30)

FUNCTION

GOKODSF.F_GET_DESC

SEQUENCE_NUMBER Sequence number identifying the dependent/beneficiary. NUMBER(2)

PDRBENE

PDRBENE_SEQ_NO

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

NA

NA



Ver: 3.1