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
BENEFITS_ELIGIBLE_IND	Family medical leave eligible benefits indicator. Valid values (Y) Yes and (N) No. Default No.	VARCHAR2(1)	PERFMLA	PERFMLA_BENEFIT_IND
BENEFITS_END_DATE	Date in which the employee starts an unpaid status.	DATE	PERFMLA	PERFMLA_UNPAID_STATUS_DATE
CLAIMED_FMLA_UNIT	Family medical leave units claimed by the employee.	NUMBER	PEREFML	PEREFML_CLAIM_UNITS
DURATION_DESIGNATION	Primary duration designation for employee leave. Valid values (FT)Full Time, (IN)Intermittent and (CO)Combined. Default (FT)Full Time.	VARCHAR2(63)	PERFMLA	PERFMLA_DURATION_TYPE
DURATION_DESIGNATION_DESC	Primary duration designation description.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'DURATION_DESIGNATION' AND VALUE = F.DURATION_DESIGNATION
EARNINGS	Identifies the transaction approval default earnings code.	VARCHAR2(63)	PEREFML	PEREFML_EARN_CODE
EARNINGS_BEGIN_DATE	Begin date for family medical leave.	DATE	PEREFML	PEREFML_EARN_BEGIN_DATE
EARNINGS_DESC	Earnings code long description.	VARCHAR2(255)	PTREARN	PTREARN_LONG_DESC
EARNINGS_END_DATE	End date for family medical leave.	DATE	PEREFML	PEREFML_EARN_END_DATE
ELIGIBILITY_NOTIFICATION_DATE	Date of eligibility notification.	DATE	PERFMLA	PERFMLA_ELIGIBLE_DATE
FMLA_ACTIVITY_DATE	Date of last activity (insert or update) on the record.	DATE	PERFMLA	PERFMLA_ACTIVITY_DATE
FMLA_ACTUAL_RETURN_DATE	Actual date of return.	DATE	PERFMLA	PERFMLA_ACTUAL_RETURN_DATE
FMLA_ACTUAL_TIME_STATUS	Actual Full Time or Part Time status. Valid values: (FT)Full Time and (PT)Part Time. Default (FT)Full Time.	VARCHAR2(63)	PERFMLA	PERFMLA_RETURN_FT_PT_TYPE
FMLA_ACTUAL_TIME_STATUS_DESC	Family medical leave actual time status description.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FMLA_ACTUAL_TIME_STATUS' AND VALUE = F.FMLA_ACTUAL_TIME_STATUS
FMLA_APPROVER_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
FMLA_APPROVER_NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
FMLA_APPROVER_UID	Internal identification number of the approver.	NUMBER	PERFMLA	PERFMLA_APPROVE_PIDM
FMLA_APPROVE_DATE	Date of approval.	DATE	PERFMLA	PERFMLA_APPROVAL_DATE
FMLA_BASE_ID	Internally system-generated unique identification number which represents the primary key of the database record.	NUMBER	PERBFML	PERBFML_ID
FMLA_BEGIN_DATE	Begin Date for family medical leave.	DATE	PERFMLA	PERFMLA_BEGIN_DATE
FMLA_CARE_TYPE_COMMENT	Family medical leave type of care being given by the employee.	VARCHAR2(4000)	PERFMLA	PERFMLA_TYPE_CARE
FMLA_DATA_ORIGIN	Source system that created or updated the row.	VARCHAR2(63)	PERFMLA	PERFMLA_DATA_ORIGIN
FMLA_DURATION_COMMENT	Optional note or comment regarding the duration of the family medical leave.	VARCHAR2(4000)	PERFMLA	PERFMLA_DURATION_NOTE
FMLA_EARNING_ID	Internally system-generated unique identification number which represents the primary key of the parent record.	NUMBER	PEREFML	PEREFML_ID
FMLA_END_DATE	End Date for family medical leave .	DATE	PERFMLA	PERFMLA_END_DATE
FMLA_PAYROLL_HISTORY_IND	Indicates this record was created through the Banner HR 'Import Payroll History' procedure.	VARCHAR2(1)	PEREFML	PEREFML_PAY_HISTORY_IND
FMLA_REASON	Family medical leave reason code.	VARCHAR2(63)	PERFMLA	PERFMLA_FREA_CODE
FMLA_REASON_DESC	Family medical leave reason description.	VARCHAR2(255)	PTVFREA	PTVFREA_DESC
FMLA_REQUEST_DATE	Date family medical leave requested.	DATE	PERFMLA	PERFMLA_REQUEST_DATE
FMLA_SCHEDULE_RETURN_DATE	Scheduled date of return.	DATE	PERFMLA	PERFMLA_SCHEDULE_RETURN_DATE
FMLA_SCHEDULE_TIME_STATUS	Scheduled Full Time or Part Time status. Valid values: (FT)Full Time and (PT)Part Time. Default (FT)Full Time	VARCHAR2(63)	PERFMLA	PERFMLA_FT_PT_TYPE
FMLA_SCHEDULE_TIME_STATUS_DESC	Family medical leave schedule time status description.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FMLA_SCHEDULE_TIME_STATUS' AND VALUE = F.FMLA_SCHEDULE_TIME_STATUS
FMLA_STATUS	Status of family medical leave record.	VARCHAR2(63)	PERFMLA	PERFMLA_STATUS_CODE
FMLA_STATUS_DATE	Date of status change of family medical leave.	DATE	PERFMLA	PERFMLA_STATUS_DATE
FMLA_STATUS_DESC	Family medical leave status description.	VARCHAR2(255)	PTVFMST	PTVFMST_DESC
FMLA_UNIT	Defines how family medical leave units are measured. Valid values will be (H) Hours, (D) Days and (W) Weeks.	VARCHAR2(63)	PERBFML	PERBFML_UNIT_TYPE
FMLA_UNIT_DESC	Family medical leave unit description.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FMLA_UNIT' AND VALUE = F.FMLA_UNIT
FMLA_USAGE_ID	Internally system-generated unique identification number which represents the primary key of the parent record.	NUMBER	PERFMLA	PERFMLA_ID
FMLA_USER_ID	The Oracle ID of the user who changed the record.	VARCHAR2(63)	PERFMLA	PERFMLA_USER_ID
FMLA_YEAR	Year associated with this family medical leave.	VARCHAR2(63)	FUNCTION	TO_CHAR (PERFMLA_BEGIN_DATE, 'YYYY')
FMLA_YEAR_TYPE	Year or period type associated with this family medical leave. Valid values are (C) Calendar Year, (F) Fiscal Year, (I) Institution Year, (S) Service Year, (Q) Qualifying Event and (R) Rolling Backward.	VARCHAR2(63)	PERBFML	PERBFML_YEAR_TYPE
FMLA_YEAR_TYPE_DESC	Family medical leave period description.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'FMLA_YEAR_TYPE' AND VALUE = F.FMLA_YEAR_TYPE
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
MAXIMUM_FMLA_UNIT	Maximum number of family medical leave units.	NUMBER	PERBFML	PERBFML_MAX_UNITS
MEDICAL_DOCUMENT_RECEIVED_DATE	Date medical certification received.	DATE	PERFMLA	PERFMLA_MED_RECEIVED_DATE
MEDICAL_DOCUMENT_RECEIVED_IND	Medical certification received indicator.	VARCHAR2(1)	PERFMLA	PERFMLA_MED_CERT_IND
MILITARY_DOCUMENT_RECEIVED_IND	Reflects that military service care documentation has been received. Valid values (Y) Yes and (N) No. Default No.	VARCHAR2(1)	PERFMLA	PERFMLA_MILITARY_DOC_IND
MILITARY_DOC_RECEIVED_DATE	Date of receipt for military documentation.	DATE	PERFMLA	PERFMLA_MILITARY_DOC_DATE
MILITARY_MEMBER_CARE_IND	Signifies that the employee is authorized extended leave to care for military service member. Valid values (Y) Yes and (N) No. Default No.	VARCHAR2(1)	PERBFML	PERBFML_MILITARY_MEMBER_IND
MILITARY_MEMBER_NAME	Military service member name that is receiving employee care.	VARCHAR2(255)	PERFMLA	PERFMLA_MILITARY_MEMBER_NAME
MILITARY_RECIPROCAL_TYPE	System defined code which identifies the type of relationship being defined. Values include C = Child, E = Employee, O = Other or S = Spouse.	VARCHAR2(63)	PTRBREL	PTRBREL_BREL_CODE_RECI
MILITARY_RECIPROCAL_TYPE_DESC	Military relationship type description.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'MILITARY_RECIPROCAL_TYPE' AND VALUE = F.MILITARY_RECIPROCAL_TYPE
MILITARY_RELATE_DESC	Military member relationship description.	VARCHAR2(255)	PTRBREL	PTRBREL_DESC
MILITARY_RELATE_TYPE	System defined code which identifies the type of relationship being defined. Values include C = Child, E = Employee, O = Other or S = Spouse.	VARCHAR2(63)	PTRBREL	PTRBREL_TYPE
MILITARY_RELATE_TYPE_DESC	Military relationship type description.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'MILITARY_RELATE_TYPE' AND VALUE = F.MILITARY_RELATE_TYPE
MILITARY_RELATIONSHIP	Military member relationship to the employee.	VARCHAR2(63)	PERFMLA	PERFMLA_BREL_CODE
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
PERSON_UID	Internal identification number of the employee.	NUMBER	PERBFML	PERBFML_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
SPOUSE_EMPLOYED_HERE_IND	Indicates if spouse is employed by the same company as employee. Valid values (Y) Yes and (N) No. Default No.	VARCHAR2(1)	PERBFML	PERBFML_SPOUSE_IND
SPOUSE_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
SPOUSE_NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SPOUSE_UID	Internal identification number for spouse of the employee.	NUMBER	PERBFML	PERBFML_SPOUSE_PIDM

Ver: 9.1