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

SGHE 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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
COMMITMENT_FULFILL_DATE Sabbatical/leave commitment fulfillment date.    

PERSABB

PERSABB_COMM_FULL_DATE

 
COMMITMENT_FULFILL_DUE_DATE Sabbatical/leave commitment fulfillment due date.    

PERSABB

PERSABB_COMM_FULL_DUE_DATE

 
ID Identification number assigned to a person that is used externally for all communication and correspondence with the person.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
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.    

PERSABB

PERSABB_SUFF

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
NAME Combination of the person's first, middle initial, and last name into one value.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
NEXT_SABBATICAL_REASON Type of academic sabbatical/leave the faculty member is eligible to take in the future.    

PERSABB

PERSABB_LREA_CODE_NEXT

 
NEXT_SABBATICAL_REASON_DESC Next sabbatical/leave type description.    

PTRLREA

PTRLREA_DESC

 
ORGANIZATION_CODE Organization code.    

PERSABB

PERSABB_ORGN

 
ORGANIZATION_DESC Organization code desc.    

FTVORGN

PTVORGN

FTVORGN_DESC

PTVORGN_DESC

 
PERSON_UID System generated, unique, internal identification number assigned to this person.    

PERSABB

PERSABB_PIDM

 
POSITION Employee position number.    

PERSABB

PERSABB_POSN

 
POSITION_TITLE Employee position description.    

NBRJOBS

NBRJOBS_DESC

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
SABBATICAL_ACTION_DATE Action Date.    

PERSABB

PERSABB_ACTION_DATE

 
SABBATICAL_APPEAL_DATE Sabbatical/leave appeal date.    

PERSABB

PERSABB_APPEAL_DATE

 
SABBATICAL_BEGIN_DATE Sabbatical/leave requested from date.    

PERSABB

PERSABB_BEGIN_DATE

 
SABBATICAL_COMMENT Sabbatical/leave comments.    

PERSABB

PERSABB_COMMENT

 
SABBATICAL_DECISION Sabbatical approval decision.    

PERSABB

PERSABB_DECISION

 
SABBATICAL_DECISION_DATE Date of sabbatical/leave decision.    

PERSABB

PERSABB_DECISION_DATE

 
SABBATICAL_DECISION_DEFER_DATE Sabbatical/leave decision deferred to date.    

PERSABB

PERSABB_DECISION_DEFER_DATE

 
SABBATICAL_DECISION_DESC Sabbatical approval decision description.    

FUNCTION

GOKODSF.F_GET_DESC

 
SABBATICAL_DEFER_BEGIN Approved sabbatical/leave begin date.    

PERSABB

PERSABB_DEFER_BEGIN

 
SABBATICAL_DEFER_END Approved sabbatical/leave end date.    

PERSABB

PERSABB_DEFER_END

 
SABBATICAL_END_DATE Sabbatical/leave requested To date.    

PERSABB

PERSABB_END_DATE

 
SABBATICAL_NEXT_DATE Sabbatical next eligibility date.    

PERSABB

PERSABB_NEXT_DATE

 
SABBATICAL_REASON Sabbatical/leave reason code.    

PERSABB

PERSABB_LREA_CODE

 
SABBATICAL_REASON_DESC Sabbatical/leave reason description.    

PTRLREA

PTRLREA_DESC

 
SABBATICAL_TYPE Classifies the type of sabbatical which is being tracked on this leave action.    

PERSABB

PERSABB_SBTY_CODE

 
SABBATICAL_TYPE_DESC Sabbatical/leave type description.    

PTVSBTY

PTVSBTY_DESC

 
TIMESHEET_CHART_DESC Chart of accounts code description or title.    

FTVCOAS

FTVCOAS_TITLE

 
TIMESHEET_CHART_OF_ACCOUNTS Timesheet chart of accounts.    

PERSABB

PERSABB_COAS_CODE

 


Ver: 8.3