Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BARGAINING_UNIT	Bargaining Unit	Bargaining unit code associated with this employee.	VARCHAR2(63)	PERBARG	PERBARG_BARG_CODE
BARGAINING_UNIT_DESC	Bargaining Unit Description	Bargaining unit code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
EFFECTIVE_DATE	Effective Date	Date from which this employee was eligible to be a member or was a member of the Bargaining Unit.	DATE	PERBARG	PERBARG_EFFECTIVE_DATE
EFFECTIVE_END_DATE	Effective End Date	End effective date.	DATE	PERBARG	PERBARG_END_DATE
EFFECTIVE_START_DATE	Effective Start Date	Start effective date.	DATE	PERBARG	PERBARG_EFFECTIVE_DATE
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MEMBERSHIP_STATUS	Membership Status	Membership status the employee has with the selected bargaining unit.	VARCHAR2(63)	NA PERBARG	NA PERBARG_BURE_CODE
MEMBERSHIP_STATUS_DESC	Membership Status Description	Membership status code description.	VARCHAR2(255)	NA	NA
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
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OFFICER_IND	Officer Indicator	Indicates whether the employee holds an officer position.	VARCHAR2(63)	NA	NA
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PERBARG	PERBARG_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
RELATIONSHIP_STATUS	Relationship Status	Relationship status the employee has with the selected bargaining unit.	VARCHAR2(63)	PERBARG	PERBARG_BURE_CODE
RELATIONSHIP_STATUS_DESC	Relationship Status Description	Relationship status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SENIORITY_DATE	Seniority Date	Seniority date associated with this bargaining unit for this employee.	DATE	PERBARG	PERBARG_BARG_SENIORITY_DATE

Ver: 9.2