Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE	NA	SYSDATE
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BANKED_HOURS1	Banked Hours 1	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
BANKED_HOURS2	Banked Hours 2	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
BANKED_HOURS3	Banked Hours 3	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
BANKED_HOURS4	Banked Hours 4	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
BANKED_HOURS5	Banked Hours 5	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
BEGINNING_BALANCE1	Beginning Balance 1	Leave balance at the beginning of the year.	NUMBER	PERJLEV PERLEAV	PERJLEV_BEGIN_BALANCE PERLEAV_BEGIN_BALANCE
BEGINNING_BALANCE2	Beginning Balance 2	Leave balance at the beginning of the year.	NUMBER	PERJLEV PERLEAV	PERJLEV_BEGIN_BALANCE PERLEAV_BEGIN_BALANCE
BEGINNING_BALANCE3	Beginning Balance 3	Leave balance at the beginning of the year.	NUMBER	PERJLEV PERLEAV	PERJLEV_BEGIN_BALANCE PERLEAV_BEGIN_BALANCE
BEGINNING_BALANCE4	Beginning Balance 4	Leave balance at the beginning of the year.	NUMBER	PERJLEV PERLEAV	PERJLEV_BEGIN_BALANCE PERLEAV_BEGIN_BALANCE
BEGINNING_BALANCE5	Beginning Balance 5	Leave balance at the beginning of the year.	NUMBER	PERJLEV PERLEAV	PERJLEV_BEGIN_BALANCE PERLEAV_BEGIN_BALANCE
DATE_LEAVE_AVAILABLE1	Date Leave Available 1	Date leave becomes available for employee.	DATE	PERJLEV PERLEAV	PERJLEV_DATE_AVAIL PERLEAV_DATE_AVAIL
DATE_LEAVE_AVAILABLE2	Date Leave Available 2	Date leave becomes available for employee.	DATE	PERJLEV PERLEAV	PERJLEV_DATE_AVAIL PERLEAV_DATE_AVAIL
DATE_LEAVE_AVAILABLE3	Date Leave Available 3	Date leave becomes available for employee.	DATE	PERJLEV PERLEAV	PERJLEV_DATE_AVAIL PERLEAV_DATE_AVAIL
DATE_LEAVE_AVAILABLE4	Date Leave Available 4	Date leave becomes available for employee.	DATE	PERJLEV PERLEAV	PERJLEV_DATE_AVAIL PERLEAV_DATE_AVAIL
DATE_LEAVE_AVAILABLE5	Date Leave Available 5	Date leave becomes available for employee.	DATE	PERJLEV PERLEAV	PERJLEV_DATE_AVAIL PERLEAV_DATE_AVAIL
LEAVE1	Leave 1	Code identifying the type of leave.	VARCHAR2(63)	PERJLEV PERLEAV	PERJLEV_LEAV_CODE PERLEAV_LEAV_CODE
LEAVE2	Leave 2	Code identifying the type of leave.	VARCHAR2(63)	PERJLEV PERLEAV	PERJLEV_LEAV_CODE PERLEAV_LEAV_CODE
LEAVE3	Leave 3	Code identifying the type of leave.	VARCHAR2(63)	PERJLEV PERLEAV	PERJLEV_LEAV_CODE PERLEAV_LEAV_CODE
LEAVE4	Leave 4	Code identifying the type of leave.	VARCHAR2(63)	PERJLEV PERLEAV	PERJLEV_LEAV_CODE PERLEAV_LEAV_CODE
LEAVE5	Leave 5	Code identifying the type of leave.	VARCHAR2(63)	PERJLEV PERLEAV	PERJLEV_LEAV_CODE PERLEAV_LEAV_CODE
LEAVE_BALANCE_RULE	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
LEAVE_DESC1	Leave Description 1	Leave description.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC
LEAVE_DESC2	Leave Description 2	Leave description.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC
LEAVE_DESC3	Leave Description 3	Leave description.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC
LEAVE_DESC4	Leave Description 4	Leave description.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC
LEAVE_DESC5	Leave Description 5	Leave description.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PERJLEV PERLEAV	PERJLEV_PIDM PERLEAV_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROFILE_CODE	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
TIME_ACCRUED1	Time Accrued 1	Amount of leave accrued.	NUMBER	PERJLEV PERLEAV	PERJLEV_ACCRUED PERLEAV_ACCRUED
TIME_ACCRUED2	Time Accrued 2	Amount of leave accrued.	NUMBER	PERJLEV PERLEAV	PERJLEV_ACCRUED PERLEAV_ACCRUED
TIME_ACCRUED3	Time Accrued 3	Amount of leave accrued.	NUMBER	PERJLEV PERLEAV	PERJLEV_ACCRUED PERLEAV_ACCRUED
TIME_ACCRUED4	Time Accrued 4	Amount of leave accrued.	NUMBER	PERJLEV PERLEAV	PERJLEV_ACCRUED PERLEAV_ACCRUED
TIME_ACCRUED5	Time Accrued 5	Amount of leave accrued.	NUMBER	PERJLEV PERLEAV	PERJLEV_ACCRUED PERLEAV_ACCRUED
TIME_TAKEN1	Time Taken 1	Amount of leave taken this year.	NUMBER	PERJLEV PERLEAV	PERJLEV_TAKEN PERLEAV_TAKEN
TIME_TAKEN2	Time Taken 2	Amount of leave taken this year.	NUMBER	PERJLEV PERLEAV	PERJLEV_TAKEN PERLEAV_TAKEN
TIME_TAKEN3	Time Taken 3	Amount of leave taken this year.	NUMBER	PERJLEV PERLEAV	PERJLEV_TAKEN PERLEAV_TAKEN
TIME_TAKEN4	Time Taken 4	Amount of leave taken this year.	NUMBER	PERJLEV PERLEAV	PERJLEV_TAKEN PERLEAV_TAKEN
TIME_TAKEN5	Time Taken 5	Amount of leave taken this year.	NUMBER	PERJLEV PERLEAV	PERJLEV_TAKEN PERLEAV_TAKEN

Ver: 9.2