Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-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	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	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: 9.1