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

Ver: 9.1