Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Human Resources Composite View Reports

Banner Operational Data Store
Composite View Target: AP_FAMILY_MEDICAL_LEAVE_HIST

Description Source composite view contains details for the employees who are on family medical leave.
Key & Frequency one per person per family medical leave per earnings

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
BENEFITS_ELIGIBLE_IND Family medical leave eligible benefits indicator. Valid values (Y) Yes and (N) No. Default No. VARCHAR2(1)

PERFMLA

PERFMLA_BENEFIT_IND

NO

NO
BENEFITS_END_DATE Date in which the employee starts an unpaid status. DATE

PERFMLA

PERFMLA_UNPAID_STATUS_DATE

NO

NO
CLAIMED_FMLA_UNIT Family medical leave units claimed by the employee. NUMBER

PEREFML

PEREFML_CLAIM_UNITS

NO

NO
CURRENT_DATE   DATE       NO
DOMAIN_VALUE   VARCHAR2(6)       NO
DURATION_DESIGNATION Primary duration designation for employee leave. Valid values (FT)Full Time, (IN)Intermittent and (CO)Combined. Default (FT)Full Time. VARCHAR2(2)

PERFMLA

PERFMLA_DURATION_TYPE

NO

NO
DURATION_DESIGNATION_DESC Primary duration designation description. VARCHAR2(255)

FUNCTION

TBD

NO

NO
EARNINGS Identifies the transaction approval default earnings code. VARCHAR2(3)

PEREFML

PEREFML_EARN_CODE

NO

NO
EARNINGS_BEGIN_DATE Begin date for family medical leave. DATE

PEREFML

PEREFML_EARN_BEGIN_DATE

NO

NO
EARNINGS_DESC Earnings code long description. VARCHAR2(30)

PTREARN

PTREARN_LONG_DESC

NO

NO
EARNINGS_END_DATE End date for family medical leave. DATE

PEREFML

PEREFML_EARN_END_DATE

NO

NO
ELIGIBILITY_NOTIFICATION_DATE Date of eligibility notification. DATE

PERFMLA

PERFMLA_ELIGIBLE_DATE

NO

NO
FMLA_ACTIVITY_DATE Date of last activity (insert or update) on the record. DATE

PERFMLA

PERFMLA_ACTIVITY_DATE

NO

NO
FMLA_ACTUAL_RETURN_DATE Actual date of return. DATE

PERFMLA

PERFMLA_ACTUAL_RETURN_DATE

NO

NO
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(2)

PERFMLA

PERFMLA_RETURN_FT_PT_TYPE

NO

NO
FMLA_ACTUAL_TIME_STATUS_DESC Family medical leave actual time status description. VARCHAR2(255)

FUNCTION

TBD

NO

NO
FMLA_APPROVER_UID Internal identification number of the approver. NUMBER

PERFMLA

PERFMLA_APPROVE_PIDM

NO

NO
FMLA_APPROVE_DATE Date of approval. DATE

PERFMLA

PERFMLA_APPROVAL_DATE

NO

NO
FMLA_BASE_ID Internally system-generated unique identification number which represents the primary key of the database record. NUMBER

PERBFML

PERBFML_ID

NO

NO
FMLA_BEGIN_DATE Begin Date for family medical leave. DATE

PERFMLA

PERFMLA_BEGIN_DATE

NO

NO
FMLA_CARE_TYPE_COMMENT Family medical leave type of care being given by the employee. VARCHAR2(200)

PERFMLA

PERFMLA_TYPE_CARE

NO

NO
FMLA_DATA_ORIGIN Source system that created or updated the row. VARCHAR2(30)

PERFMLA

PERFMLA_DATA_ORIGIN

NO

NO
FMLA_DURATION_COMMENT Optional note or comment regarding the duration of the family medical leave. VARCHAR2(200)

PERFMLA

PERFMLA_DURATION_NOTE

NO

NO
FMLA_EARNING_ID Internally system-generated unique identification number which represents the primary key of the parent record. NUMBER

PEREFML

PEREFML_ID

NO

NO
FMLA_END_DATE End Date for family medical leave . DATE

PERFMLA

PERFMLA_END_DATE

NO

NO
FMLA_PAYROLL_HISTORY_IND Indicates this record was created through the Banner HR 'Import Payroll History' procedure. VARCHAR2(1)

PEREFML

PEREFML_PAY_HISTORY_IND

NO

NO
FMLA_REASON Family medical leave reason code. VARCHAR2(2)

PERFMLA

PERFMLA_FREA_CODE

NO

NO
FMLA_REASON_DESC Family medical leave reason description. VARCHAR2(60)

PTVFREA

PTVFREA_DESC

NO

NO
FMLA_REQUEST_DATE Date family medical leave requested. DATE

PERFMLA

PERFMLA_REQUEST_DATE

NO

NO
FMLA_SCHEDULE_RETURN_DATE Scheduled date of return. DATE

PERFMLA

PERFMLA_SCHEDULE_RETURN_DATE

NO

NO
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(2)

PERFMLA

PERFMLA_FT_PT_TYPE

NO

NO
FMLA_SCHEDULE_TIME_STATUS_DESC Family medical leave schedule time status description. VARCHAR2(255)

FUNCTION

TBD

NO

NO
FMLA_STATUS Status of family medical leave record. VARCHAR2(2)

PERFMLA

PERFMLA_STATUS_CODE

NO

NO
FMLA_STATUS_DATE Date of status change of family medical leave. DATE

PERFMLA

PERFMLA_STATUS_DATE

NO

NO
FMLA_STATUS_DESC Family medical leave status description. VARCHAR2(60)

PTVFMST

PTVFMST_DESC

NO

NO
FMLA_UNIT Defines how family medical leave units are measured. Valid values will be (H) Hours, (D) Days and (W) Weeks. VARCHAR2(1)

PERBFML

PERBFML_UNIT_TYPE

NO

NO
FMLA_UNIT_DESC Family medical leave unit description. VARCHAR2(255)

FUNCTION

TBD

NO

NO
FMLA_USAGE_ID Internally system-generated unique identification number which represents the primary key of the parent record. NUMBER

PERFMLA

PERFMLA_ID

NO

NO
FMLA_USER_ID The Oracle ID of the user who changed the record. VARCHAR2(30)

PERFMLA

PERFMLA_USER_ID

NO

NO
FMLA_YEAR Year associated with this family medical leave. VARCHAR2(4)

FUNCTION

TBD

NO

NO
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(1)

PERBFML

PERBFML_YEAR_TYPE

NO

NO
FMLA_YEAR_TYPE_DESC Family medical leave period description. VARCHAR2(255)

FUNCTION

TBD

NO

NO
MAXIMUM_FMLA_UNIT Maximum number of family medical leave units. NUMBER

PERBFML

PERBFML_MAX_UNITS

NO

NO
MEDICAL_DOCUMENT_RECEIVED_DATE Date medical certification received. DATE

PERFMLA

PERFMLA_MED_RECEIVED_DATE

NO

NO
MEDICAL_DOCUMENT_RECEIVED_IND Medical certification received indicator. VARCHAR2(1)

PERFMLA

PERFMLA_MED_CERT_IND

NO

NO
MIF_DESC   VARCHAR2(30)       NO
MIF_VALUE   VARCHAR2(6)       NO
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

NO

NO
MILITARY_DOC_RECEIVED_DATE Date of receipt for military documentation. DATE

PERFMLA

PERFMLA_MILITARY_DOC_DATE

NO

NO
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

NO

NO
MILITARY_MEMBER_NAME Military service member name that is receiving employee care. VARCHAR2(230)

PERFMLA

PERFMLA_MILITARY_MEMBER_NAME

NO

NO
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(1)

PTRBREL

PTRBREL_BREL_CODE_RECI

NO

NO
MILITARY_RECIPROCAL_TYPE_DESC Military relationship type description. VARCHAR2(255)

FUNCTION

TBD

NO

NO
MILITARY_RELATE_DESC Military member relationship description. VARCHAR2(30)

PTRBREL

PTRBREL_DESC

NO

NO
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(1)

PTRBREL

PTRBREL_TYPE

NO

NO
MILITARY_RELATE_TYPE_DESC Military relationship type description. VARCHAR2(255)

FUNCTION

TBD

NO

NO
MILITARY_RELATIONSHIP Military member relationship to the employee. VARCHAR2(1)

PERFMLA

PERFMLA_BREL_CODE

NO

NO
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
PERSON_UID Internal identification number of the employee. NUMBER

PERBFML

PERBFML_PIDM

NO

NO
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
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

NO

NO
SPOUSE_UID Internal identification number for spouse of the employee. NUMBER

PERBFML

PERBFML_SPOUSE_PIDM

NO

NO
ZONE_VALUE   VARCHAR2(6)       NO


Ver: