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
BENEFITS_ELIGIBLE_IND	Benefits Eligible Indicator	Family medical leave eligible benefits indicator. Valid values (Y) Yes and (N) No. Default No.	VARCHAR2(1)	PERFMLA	PERFMLA_BENEFIT_IND
BENEFITS_END_DATE	Benefits End Date	Date in which the employee starts an unpaid status.	DATE	PERFMLA	PERFMLA_UNPAID_STATUS_DATE
CLAIMED_FMLA_UNIT	Claimed Fmla Unit	Family medical leave units claimed by the employee.	NUMBER	PEREFML	PEREFML_CLAIM_UNITS
DURATION_DESIGNATION	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	Duration Designation Description	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	Earnings	Identifies the transaction approval default earnings code.	VARCHAR2(63)	PEREFML	PEREFML_EARN_CODE
EARNINGS_BEGIN_DATE	Earnings Begin Date	Begin date for family medical leave.	DATE	PEREFML	PEREFML_EARN_BEGIN_DATE
EARNINGS_DESC	Earnings Description	Earnings code long description.	VARCHAR2(255)	PTREARN	PTREARN_LONG_DESC
EARNINGS_END_DATE	Earnings End Date	End date for family medical leave.	DATE	PEREFML	PEREFML_EARN_END_DATE
ELIGIBILITY_NOTIFICATION_DATE	Eligibility Notification Date	Date of eligibility notification.	DATE	PERFMLA	PERFMLA_ELIGIBLE_DATE
FMLA_ACTIVITY_DATE	Fmla Activity Date	Date of last activity (insert or update) on the record.	DATE	PERFMLA	PERFMLA_ACTIVITY_DATE
FMLA_ACTUAL_RETURN_DATE	Fmla Actual Return Date	Actual date of return.	DATE	PERFMLA	PERFMLA_ACTUAL_RETURN_DATE
FMLA_ACTUAL_TIME_STATUS	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	Fmla Actual Time Status Description	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	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	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	Fmla Approver UID	Internal identification number of the approver.	NUMBER	PERFMLA	PERFMLA_APPROVE_PIDM
FMLA_APPROVE_DATE	Fmla Approve Date	Date of approval.	DATE	PERFMLA	PERFMLA_APPROVAL_DATE
FMLA_BASE_ID	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	Fmla Begin Date	Begin Date for family medical leave.	DATE	PERFMLA	PERFMLA_BEGIN_DATE
FMLA_CARE_TYPE_COMMENT	Fmla Care Type Comment	Family medical leave type of care being given by the employee.	VARCHAR2(4000)	PERFMLA	PERFMLA_TYPE_CARE
FMLA_DATA_ORIGIN	Fmla Data Origin	Source system that created or updated the row.	VARCHAR2(63)	PERFMLA	PERFMLA_DATA_ORIGIN
FMLA_DURATION_COMMENT	Fmla Duration Comment	Optional note or comment regarding the duration of the family medical leave.	VARCHAR2(4000)	PERFMLA	PERFMLA_DURATION_NOTE
FMLA_EARNING_ID	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	Fmla End Date	End Date for family medical leave .	DATE	PERFMLA	PERFMLA_END_DATE
FMLA_PAYROLL_HISTORY_IND	Fmla Payroll History Indicator	Indicates this record was created through the Banner HR 'Import Payroll History' procedure.	VARCHAR2(1)	PEREFML	PEREFML_PAY_HISTORY_IND
FMLA_REASON	Fmla Reason	Family medical leave reason code.	VARCHAR2(63)	PERFMLA	PERFMLA_FREA_CODE
FMLA_REASON_DESC	Fmla Reason Description	Family medical leave reason description.	VARCHAR2(255)	PTVFREA	PTVFREA_DESC
FMLA_REQUEST_DATE	Fmla Request Date	Date family medical leave requested.	DATE	PERFMLA	PERFMLA_REQUEST_DATE
FMLA_SCHEDULE_RETURN_DATE	Fmla Schedule Return Date	Scheduled date of return.	DATE	PERFMLA	PERFMLA_SCHEDULE_RETURN_DATE
FMLA_SCHEDULE_TIME_STATUS	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	Fmla Schedule Time Status Description	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	Fmla Status	Status of family medical leave record.	VARCHAR2(63)	PERFMLA	PERFMLA_STATUS_CODE
FMLA_STATUS_DATE	Fmla Status Date	Date of status change of family medical leave.	DATE	PERFMLA	PERFMLA_STATUS_DATE
FMLA_STATUS_DESC	Fmla Status Description	Family medical leave status description.	VARCHAR2(255)	PTVFMST	PTVFMST_DESC
FMLA_UNIT	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	Fmla Unit Description	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	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	Fmla User ID	The Oracle ID of the user who changed the record.	VARCHAR2(63)	PERFMLA	PERFMLA_USER_ID
FMLA_YEAR	Fmla Year	Year associated with this family medical leave.	VARCHAR2(63)	FUNCTION	TO_CHAR (PERFMLA_BEGIN_DATE, 'YYYY')
FMLA_YEAR_TYPE	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	Fmla Year Type Description	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	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 Fmla Unit	Maximum number of family medical leave units.	NUMBER	PERBFML	PERBFML_MAX_UNITS
MEDICAL_DOCUMENT_RECEIVED_DATE	Medical Document Received Date	Date medical certification received.	DATE	PERFMLA	PERFMLA_MED_RECEIVED_DATE
MEDICAL_DOCUMENT_RECEIVED_IND	Medical Document Received Indicator	Medical certification received indicator.	VARCHAR2(1)	PERFMLA	PERFMLA_MED_CERT_IND
MILITARY_DOCUMENT_RECEIVED_IND	Military Document Received Indicator	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	Military Document Received Date	Date of receipt for military documentation.	DATE	PERFMLA	PERFMLA_MILITARY_DOC_DATE
MILITARY_MEMBER_CARE_IND	Military Member Care Indicator	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 Member Name	Military service member name that is receiving employee care.	VARCHAR2(255)	PERFMLA	PERFMLA_MILITARY_MEMBER_NAME
MILITARY_RECIPROCAL_TYPE	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 Reciprocal Type Description	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 Relate Description	Military member relationship description.	VARCHAR2(255)	PTRBREL	PTRBREL_DESC
MILITARY_RELATE_TYPE	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 Relate Type Description	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 Relationship	Military member relationship to the employee.	VARCHAR2(63)	PERFMLA	PERFMLA_BREL_CODE
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
PERSON_UID	Person UID	Internal identification number of the employee.	NUMBER	PERBFML	PERBFML_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
SPOUSE_EMPLOYED_HERE_IND	Spouse Employed Here Indicator	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	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	Spouse Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SPOUSE_UID	Spouse UID	Internal identification number for spouse of the employee.	NUMBER	PERBFML	PERBFML_SPOUSE_PIDM

Ver: 9.2