Reporting View Target: FACULTY_SABBATICAL

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Human Resources Reporting View Reports

Banner Operational Data Store
Reporting View Target: FACULTY_SABBATICAL_HISTORY

Description Provides historical information about faculty sabbaticals.
Key & Frequency One row per person per action date.
Recommended Search Columns PERSON_UID, SABBATICAL_ACTION_DATE

Target Column Business Name Business Definition Database Data Type Source Name Source Column

ADMINISTRATIVE_GROUP Administrative Group Administrative-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

Ver: 9.2

Description	Provides historical information about faculty sabbaticals.
Key & Frequency	One row per person per action date.
Recommended Search Columns	PERSON_UID, SABBATICAL_ACTION_DATE

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-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