Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	SYSDATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
BANKED_HOURS1	Number of hours banked for employee's leaves. The amount of leave banked for this leave code and this job.	NUMBER	PERJLEV PERLEAV	PERJLEV_HRS_BANKED PERLEAV_HRS_BANKED	NO NO	NO
BANKED_HOURS2	Number of hours banked for employee's leaves. The amount of leave banked for this leave code and this job.	NUMBER	PERJLEV PERLEAV	PERJLEV_HRS_BANKED PERLEAV_HRS_BANKED	NO NO	NO
BANKED_HOURS3	Number of hours banked for employee's leaves. The amount of leave banked for this leave code and this job.	NUMBER	PERJLEV PERLEAV	PERJLEV_HRS_BANKED PERLEAV_HRS_BANKED	NO NO	NO
BANKED_HOURS4	Number of hours banked for employee's leaves. The amount of leave banked for this leave code and this job.	NUMBER	PERJLEV PERLEAV	PERJLEV_HRS_BANKED PERLEAV_HRS_BANKED	NO NO	NO
BANKED_HOURS5	Number of hours banked for employee's leaves. The amount of leave banked for this leave code and this job.	NUMBER	PERJLEV PERLEAV	PERJLEV_HRS_BANKED PERLEAV_HRS_BANKED	NO NO	NO
BEGINNING_BALANCE1	Leave balance at the beginning of the year.	NUMBER	PERJLEV PERLEAV	PERJLEV_BEGIN_BALANCE PERLEAV_BEGIN_BALANCE	NO NO	NO
BEGINNING_BALANCE2	Leave balance at the beginning of the year.	NUMBER	PERJLEV PERLEAV	PERJLEV_BEGIN_BALANCE PERLEAV_BEGIN_BALANCE	NO NO	NO
BEGINNING_BALANCE3	Leave balance at the beginning of the year.	NUMBER	PERJLEV PERLEAV	PERJLEV_BEGIN_BALANCE PERLEAV_BEGIN_BALANCE	NO NO	NO
BEGINNING_BALANCE4	Leave balance at the beginning of the year.	NUMBER	PERJLEV PERLEAV	PERJLEV_BEGIN_BALANCE PERLEAV_BEGIN_BALANCE	NO NO	NO
BEGINNING_BALANCE5	Leave balance at the beginning of the year.	NUMBER	PERJLEV PERLEAV	PERJLEV_BEGIN_BALANCE PERLEAV_BEGIN_BALANCE	NO NO	NO
DATE_LEAVE_AVAILABLE1	Date leave becomes available for employee.	DATE	PERJLEV PERLEAV	PERJLEV_DATE_AVAIL PERLEAV_DATE_AVAIL	NO NO	NO
DATE_LEAVE_AVAILABLE2	Date leave becomes available for employee.	DATE	PERJLEV PERLEAV	PERJLEV_DATE_AVAIL PERLEAV_DATE_AVAIL	NO NO	NO
DATE_LEAVE_AVAILABLE3	Date leave becomes available for employee.	DATE	PERJLEV PERLEAV	PERJLEV_DATE_AVAIL PERLEAV_DATE_AVAIL	NO NO	NO
DATE_LEAVE_AVAILABLE4	Date leave becomes available for employee.	DATE	PERJLEV PERLEAV	PERJLEV_DATE_AVAIL PERLEAV_DATE_AVAIL	NO NO	NO
DATE_LEAVE_AVAILABLE5	Date leave becomes available for employee.	DATE	PERJLEV PERLEAV	PERJLEV_DATE_AVAIL PERLEAV_DATE_AVAIL	NO NO	NO
LEAVE1	Code identifying the type of leave.	VARCHAR2(63)	PERJLEV PERLEAV	PERJLEV_LEAV_CODE PERLEAV_LEAV_CODE	NO NO	NO
LEAVE2	Code identifying the type of leave.	VARCHAR2(63)	PERJLEV PERLEAV	PERJLEV_LEAV_CODE PERLEAV_LEAV_CODE	NO NO	NO
LEAVE3	Code identifying the type of leave.	VARCHAR2(63)	PERJLEV PERLEAV	PERJLEV_LEAV_CODE PERLEAV_LEAV_CODE	NO NO	NO
LEAVE4	Code identifying the type of leave.	VARCHAR2(63)	PERJLEV PERLEAV	PERJLEV_LEAV_CODE PERLEAV_LEAV_CODE	NO NO	NO
LEAVE5	Code identifying the type of leave.	VARCHAR2(63)	PERJLEV PERLEAV	PERJLEV_LEAV_CODE PERLEAV_LEAV_CODE	NO NO	NO
LEAVE_BALANCE_RULE	LEAVE_BALANCE_RULE is stored as MGRSDAX_INTERNAL_CODE column and is used to define a specific hierarchy or sequence for display of the values in a slotted reporting view. This may be used to specify the values for each slot or to select data through a reporting tool selection criteria.	VARCHAR2(63)	MGRSDAX	MGRSDAX_INTERNAL_CODE	NO	NO
LEAVE_DESC1	Leave description.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
LEAVE_DESC2	Leave description.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
LEAVE_DESC3	Leave description.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
LEAVE_DESC4	Leave description.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
LEAVE_DESC5	Leave description.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC	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	System generated, unique, internal identification number assigned to this person.	NUMBER	PERJLEV PERLEAV	PERJLEV_PIDM PERLEAV_PIDM	NO 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
PROFILE_CODE	This BUSNIESS PROFILE code is stored as MGRSDAX_PROFILE_CODE column and is used to set up display rules specific to an institution office or role. This may be used to define security for the rows of data available to a reporting user, or to select data through a reporting tool selection criteria.	VARCHAR2(63)	MGRSDAX	MGRSDAX_PROFILE_CODE	NO	NO
TIME_ACCRUED1	Amount of leave accrued.	NUMBER	PERJLEV PERLEAV	PERJLEV_ACCRUED PERLEAV_ACCRUED	NO NO	NO
TIME_ACCRUED2	Amount of leave accrued.	NUMBER	PERJLEV PERLEAV	PERJLEV_ACCRUED PERLEAV_ACCRUED	NO NO	NO
TIME_ACCRUED3	Amount of leave accrued.	NUMBER	PERJLEV PERLEAV	PERJLEV_ACCRUED PERLEAV_ACCRUED	NO NO	NO
TIME_ACCRUED4	Amount of leave accrued.	NUMBER	PERJLEV PERLEAV	PERJLEV_ACCRUED PERLEAV_ACCRUED	NO NO	NO
TIME_ACCRUED5	Amount of leave accrued.	NUMBER	PERJLEV PERLEAV	PERJLEV_ACCRUED PERLEAV_ACCRUED	NO NO	NO
TIME_TAKEN1	Amount of leave taken this year.	NUMBER	PERJLEV PERLEAV	PERJLEV_TAKEN PERLEAV_TAKEN	NO NO	NO
TIME_TAKEN2	Amount of leave taken this year.	NUMBER	PERJLEV PERLEAV	PERJLEV_TAKEN PERLEAV_TAKEN	NO NO	NO
TIME_TAKEN3	Amount of leave taken this year.	NUMBER	PERJLEV PERLEAV	PERJLEV_TAKEN PERLEAV_TAKEN	NO NO	NO
TIME_TAKEN4	Amount of leave taken this year.	NUMBER	PERJLEV PERLEAV	PERJLEV_TAKEN PERLEAV_TAKEN	NO NO	NO
TIME_TAKEN5	Amount of leave taken this year.	NUMBER	PERJLEV PERLEAV	PERJLEV_TAKEN PERLEAV_TAKEN	NO NO	NO

Ver: 9.2