Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Human Resources Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: FAMILY_MEDICAL_LEAVE_HISTORY

Description Provide detail information on each earnings code for persons with family medical leave. This detail will include the family medical leave reason, whether and when documentation has been received related person.
Key & Frequency one per person per family medical leave per earnings
Recommended Search Columns PERSON_UID, FMLA_BASE_ID, FMLA_USAGE_ID, FMLA_EARNING_ID
FMLA_BASE_ID
PERSON_UID, FMLA_YEAR
FMLA_BASE_ID, FMLA_USAGE_ID
FMLA_BASE_ID, FMLA_USAGE_ID, FMLA_BEGIN_DATE
FMLA_BASE_ID, FMLA_EARNING_ID, FMLA_BEGIN_DATE

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: 8.5