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
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
EARNINGS
|
Identifies the transaction approval default earnings code.
|
VARCHAR2(63)
|
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(255)
|
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(63)
|
PERFMLA
|
PERFMLA_RETURN_FT_PT_TYPE
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
FMLA_APPROVER_NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
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(4000)
|
PERFMLA
|
PERFMLA_TYPE_CARE
|
NO
|
NO
|
FMLA_DATA_ORIGIN
|
Source system that created or updated the row.
|
VARCHAR2(63)
|
PERFMLA
|
PERFMLA_DATA_ORIGIN
|
NO
|
NO
|
FMLA_DURATION_COMMENT
|
Optional note or comment regarding the duration of the family medical leave.
|
VARCHAR2(4000)
|
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(63)
|
PERFMLA
|
PERFMLA_FREA_CODE
|
NO
|
NO
|
FMLA_REASON_DESC
|
Family medical leave reason description.
|
VARCHAR2(255)
|
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(63)
|
PERFMLA
|
PERFMLA_FT_PT_TYPE
|
NO
|
NO
|
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
|
NO
|
NO
|
FMLA_STATUS
|
Status of family medical leave record.
|
VARCHAR2(63)
|
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(255)
|
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(63)
|
PERBFML
|
PERBFML_UNIT_TYPE
|
NO
|
NO
|
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
|
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(63)
|
PERFMLA
|
PERFMLA_USER_ID
|
NO
|
NO
|
FMLA_YEAR
|
Year associated with this family medical leave.
|
VARCHAR2(63)
|
FUNCTION
|
TO_CHAR (PERFMLA_BEGIN_DATE, 'YYYY')
|
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(63)
|
PERBFML
|
PERBFML_YEAR_TYPE
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
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
|
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(255)
|
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(63)
|
PTRBREL
|
PTRBREL_BREL_CODE_RECI
|
NO
|
NO
|
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
|
NO
|
NO
|
MILITARY_RELATE_DESC
|
Military member relationship description.
|
VARCHAR2(255)
|
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(63)
|
PTRBREL
|
PTRBREL_TYPE
|
NO
|
NO
|
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
|
NO
|
NO
|
MILITARY_RELATIONSHIP
|
Military member relationship to the employee.
|
VARCHAR2(63)
|
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
|
NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
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_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
|
NO
|
NO
|
SPOUSE_NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
SPOUSE_UID
|
Internal identification number for spouse of the employee.
|
NUMBER
|
PERBFML
|
PERBFML_SPOUSE_PIDM
|
NO
|
NO
|