Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated	DATE		NA	SYSDATE
ADMINISTRATIVE_GROUP	Administrative Group	Organization-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 Banner unique ID which gets assigned to all person and non-person records within Banner.	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.0