RETURN TO REPORTING VIEW REPORTS LIST
Human Resources Reporting View Reports

SGHE 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 Definition Database Data Type Source Name Source Column
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 Sabbatical/leave commitment fulfillment date. DATE

PERSABB

PERSABB_COMM_FULL_DATE

COMMITMENT_FULFILL_DUE_DATE Sabbatical/leave commitment fulfillment due date. 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. VARCHAR2(63)

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. VARCHAR2(63)

PERSABB

PERSABB_SUFF

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

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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/leave type description. VARCHAR2(255)

PTRLREA

PTRLREA_DESC

ORGANIZATION_CODE Organization code. VARCHAR2(63)

PERSABB

PERSABB_ORGN

ORGANIZATION_DESC Organization code desc. VARCHAR2(255)

FTVORGN

PTVORGN

FTVORGN_DESC

PTVORGN_DESC

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

PERSABB

PERSABB_PIDM

POSITION Employee position number. VARCHAR2(63)

PERSABB

PERSABB_POSN

POSITION_TITLE Employee position description. VARCHAR2(255)

NBRJOBS

NBRJOBS_DESC

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 Action Date. DATE

PERSABB

PERSABB_ACTION_DATE

SABBATICAL_APPEAL_DATE Sabbatical/leave appeal date. DATE

PERSABB

PERSABB_APPEAL_DATE

SABBATICAL_BEGIN_DATE Sabbatical/leave requested from date. DATE

PERSABB

PERSABB_BEGIN_DATE

SABBATICAL_COMMENT Sabbatical/leave comments. VARCHAR2(4000)

PERSABB

PERSABB_COMMENT

SABBATICAL_DECISION Sabbatical approval decision. VARCHAR2(63)

PERSABB

PERSABB_DECISION

SABBATICAL_DECISION_DATE Date of sabbatical/leave decision. DATE

PERSABB

PERSABB_DECISION_DATE

SABBATICAL_DECISION_DEFER_DATE Sabbatical/leave decision deferred to date. DATE

PERSABB

PERSABB_DECISION_DEFER_DATE

SABBATICAL_DECISION_DESC Sabbatical approval decision description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SABBATICAL_DEFER_BEGIN Approved sabbatical/leave begin date. DATE

PERSABB

PERSABB_DEFER_BEGIN

SABBATICAL_DEFER_END Approved sabbatical/leave end date. DATE

PERSABB

PERSABB_DEFER_END

SABBATICAL_END_DATE Sabbatical/leave requested To date. DATE

PERSABB

PERSABB_END_DATE

SABBATICAL_NEXT_DATE Sabbatical next eligibility date. DATE

PERSABB

PERSABB_NEXT_DATE

SABBATICAL_REASON Sabbatical/leave reason code. VARCHAR2(63)

PERSABB

PERSABB_LREA_CODE

SABBATICAL_REASON_DESC Sabbatical/leave reason description. VARCHAR2(255)

PTRLREA

PTRLREA_DESC

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/leave type description. VARCHAR2(255)

PTVSBTY

PTVSBTY_DESC

TIMESHEET_CHART_DESC Chart of accounts code description or title. VARCHAR2(255)

FTVCOAS

FTVCOAS_TITLE

TIMESHEET_CHART_OF_ACCOUNTS Timesheet chart of accounts. VARCHAR2(63)

PERSABB

PERSABB_COAS_CODE



Ver: 3.1