Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: PERFMLA Human Resources
SGHE Banner Operational Data Store Composite View Source: PERFMLA - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
PERFMLA_ACTIVITY_DATE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_ACTIVITY_DATE

 
PERFMLA_ACTUAL_RETURN_DATE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_ACTUAL_RETURN_DATE

 
PERFMLA_APPROVAL_DATE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_APPROVE_DATE

 
PERFMLA_APPROVE_PIDM PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_APPROVER_UID

 
PERFMLA_BEGIN_DATE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_BEGIN_DATE

 
PERFMLA_BENEFIT_IND PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

BENEFITS_ELIGIBLE_IND

 
PERFMLA_BREL_CODE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

MILITARY_RELATIONSHIP

 
PERFMLA_DATA_ORIGIN PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_DATA_ORIGIN

 
PERFMLA_DURATION_NOTE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_DURATION_COMMENT

 
PERFMLA_DURATION_TYPE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

DURATION_DESIGNATION

 
PERFMLA_ELIGIBLE_DATE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

ELIGIBILITY_NOTIFICATION_DATE

 
PERFMLA_END_DATE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_END_DATE

 
PERFMLA_FREA_CODE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_REASON

 
PERFMLA_FT_PT_TYPE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_SCHEDULE_TIME_STATUS

 
PERFMLA_ID NA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_USAGE_ID

 
PERFMLA_MED_CERT_IND PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

MEDICAL_DOCUMENT_RECEIVED_IND

 
PERFMLA_MED_RECEIVED_DATE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

MEDICAL_DOCUMENT_RECEIVED_DATE

 
PERFMLA_MILITARY_DOC_DATE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

MILITARY_DOC_RECEIVED_DATE

 
PERFMLA_MILITARY_DOC_IND PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

MILITARY_DOCUMENT_RECEIVED_IND

 
PERFMLA_MILITARY_MEMBER_NAME PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

MILITARY_MEMBER_NAME

 
PERFMLA_REQUEST_DATE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_REQUEST_DATE

 
PERFMLA_RETURN_FT_PT_TYPE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_ACTUAL_TIME_STATUS

 
PERFMLA_SCHEDULE_RETURN_DATE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_SCHEDULE_RETURN_DATE

 
PERFMLA_STATUS_CODE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_STATUS

 
PERFMLA_STATUS_DATE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_STATUS_DATE

 
PERFMLA_TYPE_CARE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_CARE_TYPE_COMMENT

 
PERFMLA_UNPAID_STATUS_DATE PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

BENEFITS_END_DATE

 
PERFMLA_USER_ID PEAFMLA COMPOSITE VIEW

AP_FAMILY_MEDICAL_LEAVE_HIST

FMLA_USER_ID

 


Ver: