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
|