| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
COMMITMENT_FULFILL_DATE
 | 
Commitment Fulfill Date 
 | 
Sabbatical/leave commitment fulfillment date.
 | 
DATE
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_COMM_FULL_DATE
 
 | 
| 
COMMITMENT_FULFILL_DUE_DATE
 | 
Commitment Fulfill Due Date 
 | 
Sabbatical/leave commitment fulfillment due date.
 | 
DATE
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_COMM_FULL_DUE_DATE
 
 | 
| 
ID
 | 
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
 
 | 
| 
JOB_SUFFIX
 | 
Job Suffix 
 | 
Suffix allows users to define a job with more precision.  For example, a user could denote daytime faculty with one suffix and evening school with another.
 | 
VARCHAR2(63)
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_SUFF
 
 | 
| 
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
 
 | 
| 
NAME
 | 
Name 
 | 
Combination of the person's first, middle initial, and last name into one value.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
NEXT_SABBATICAL_REASON
 | 
Next Sabbatical Reason 
 | 
Type of academic sabbatical/leave the faculty member is eligible to take in the future.
 | 
VARCHAR2(63)
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_LREA_CODE_NEXT
 
 | 
| 
NEXT_SABBATICAL_REASON_DESC
 | 
Next Sabbatical Reason Description 
 | 
Next sabbatical/leave type description.
 | 
VARCHAR2(255)
 | 
 
 | 
 PTRLREA
 
 | 
 PTRLREA_DESC
 
 | 
| 
ORGANIZATION_CODE
 | 
Organization Code 
 | 
Organization code.
 | 
VARCHAR2(63)
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_ORGN
 
 | 
| 
ORGANIZATION_DESC
 | 
Organization Description 
 | 
Organization code desc.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTVORGN PTVORGN
 
 | 
 FTVORGN_DESC PTVORGN_DESC
 
 | 
| 
PERSON_UID
 | 
Person UID 
 | 
System generated, unique, internal identification number assigned to this person.
 | 
NUMBER
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_PIDM
 
 | 
| 
POSITION
 | 
Position 
 | 
Employee position number.
 | 
VARCHAR2(63)
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_POSN
 
 | 
| 
POSITION_TITLE
 | 
Position Title 
 | 
Employee position description. 
 | 
VARCHAR2(255)
 | 
 
 | 
 NBRJOBS
 
 | 
 NBRJOBS_DESC
 
 | 
| 
PROCESS_GROUP
 | 
Process Group 
 | 
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
SABBATICAL_ACTION_DATE
 | 
Sabbatical Action Date 
 | 
Action Date.
 | 
DATE
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_ACTION_DATE
 
 | 
| 
SABBATICAL_APPEAL_DATE
 | 
Sabbatical Appeal Date 
 | 
Sabbatical/leave appeal date.
 | 
DATE
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_APPEAL_DATE
 
 | 
| 
SABBATICAL_BEGIN_DATE
 | 
Sabbatical Begin Date 
 | 
Sabbatical/leave requested from date.
 | 
DATE
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_BEGIN_DATE
 
 | 
| 
SABBATICAL_COMMENT
 | 
Sabbatical Comment 
 | 
Sabbatical/leave comments.
 | 
VARCHAR2(4000)
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_COMMENT
 
 | 
| 
SABBATICAL_DECISION
 | 
Sabbatical Decision 
 | 
Sabbatical approval decision.
 | 
VARCHAR2(63)
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_DECISION
 
 | 
| 
SABBATICAL_DECISION_DATE
 | 
Sabbatical Decision Date 
 | 
Date of sabbatical/leave decision.
 | 
DATE
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_DECISION_DATE
 
 | 
| 
SABBATICAL_DECISION_DEFER_DATE
 | 
Sabbatical Decision Defer Date 
 | 
Sabbatical/leave decision deferred to date.
 | 
DATE
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_DECISION_DEFER_DATE
 
 | 
| 
SABBATICAL_DECISION_DESC
 | 
Sabbatical Decision Description 
 | 
Sabbatical approval decision description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
SABBATICAL_DEFER_BEGIN
 | 
Sabbatical Defer Begin 
 | 
Approved sabbatical/leave begin date.
 | 
DATE
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_DEFER_BEGIN
 
 | 
| 
SABBATICAL_DEFER_END
 | 
Sabbatical Defer End 
 | 
Approved sabbatical/leave end date.
 | 
DATE
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_DEFER_END
 
 | 
| 
SABBATICAL_END_DATE
 | 
Sabbatical End Date 
 | 
Sabbatical/leave requested To date.
 | 
DATE
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_END_DATE
 
 | 
| 
SABBATICAL_NEXT_DATE
 | 
Sabbatical Next Date 
 | 
Sabbatical next eligibility date.
 | 
DATE
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_NEXT_DATE
 
 | 
| 
SABBATICAL_REASON
 | 
Sabbatical Reason 
 | 
Sabbatical/leave reason code.
 | 
VARCHAR2(63)
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_LREA_CODE
 
 | 
| 
SABBATICAL_REASON_DESC
 | 
Sabbatical Reason Description 
 | 
Sabbatical/leave reason description.
 | 
VARCHAR2(255)
 | 
 
 | 
 PTRLREA
 
 | 
 PTRLREA_DESC
 
 | 
| 
SABBATICAL_TYPE
 | 
Sabbatical Type 
 | 
Classifies the type of sabbatical which is being tracked on this leave action.
 | 
VARCHAR2(63)
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_SBTY_CODE
 
 | 
| 
SABBATICAL_TYPE_DESC
 | 
Sabbatical Type Description 
 | 
Sabbatical/leave type description.
 | 
VARCHAR2(255)
 | 
 
 | 
 PTVSBTY
 
 | 
 PTVSBTY_DESC
 
 | 
| 
TIMESHEET_CHART_DESC
 | 
Timesheet Chart Description 
 | 
Chart of accounts code description or title.
 | 
VARCHAR2(255)
 | 
 
 | 
 FTVCOAS
 
 | 
 FTVCOAS_TITLE
 
 | 
| 
TIMESHEET_CHART_OF_ACCOUNTS
 | 
Timesheet Chart Of Accounts 
 | 
Timesheet chart of accounts.
 | 
VARCHAR2(63)
 | 
 
 | 
 PERSABB
 
 | 
 PERSABB_COAS_CODE
 
 |