Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Human Resources Composite View Reports

Banner Operational Data Store
Composite View Target: AP_FACULTY_SABBATICAL_HISTORY

Description Provides historical information about faculty sabbaticals.
Key & Frequency One row per person per action date.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
AAUP_MEMBER_IND Indicates the academic staff or faculty member belongs to the American Association of University Professors. VARCHAR2(1)

NA

NA

NO

NO
ACADEMIC_TITLE Name for the academic staff member title or position at the institution. VARCHAR2(80)

PERBFAC

PERBFAC_ACADEMIC_TITLE

NO

NO
COMMITMENT_FULFILL_DATE Sabbatical/leave commitment fulfillment date. DATE

PERSABB

PERSABB_COMM_FULL_DATE

NO

NO
COMMITMENT_FULFILL_DUE_DATE Sabbatical/leave commitment fulfillment due date. DATE

PERSABB

PERSABB_COMM_FULL_DUE_DATE

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
EMERITUS_STATUS_IND Emeritus Status. VARCHAR2(1)

PERBFAC

PERBFAC_EMERITUS_STATUS

NO

NO
FACULTY_TYPE Faculty Type Code. VARCHAR2(6)

PERBFAC

PERBFAC_FTYP_CODE

NO

NO
FACULTY_TYPE_DESC Description of the faculty type code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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(2)

PERSABB

PERSABB_SUFF

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
NEXT_SABBATICAL_REASON Type of academic sabbatical/leave the faculty member is eligible to take in the future. VARCHAR2(2)

PERSABB

PERSABB_LREA_CODE_NEXT

NO

NO
NEXT_SABBATICAL_REASON_DESC Next sabbatical/leave type description. VARCHAR2(30)

PTRLREA

PTRLREA_DESC

NO

NO
ORGANIZATION_CODE Organization code. VARCHAR2(6)

PERSABB

PERSABB_ORGN

NO

NO
ORGANIZATION_DESC Organization code desc. VARCHAR2(35)

FTVORGN

FTVORGN_DESC

NO

NO
ORIGINAL_APPOINT_BEGIN_DATE Original Appointment Begin Date. DATE

PERBFAC

PERBFAC_ORIG_BEGIN_DATE

NO

NO
ORIGINAL_APPOINT_END_DATE Original Appointment End Date. DATE

PERBFAC

PERBFAC_ORIG_END_DATE

NO

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

PERSABB

PERSABB_PIDM

NO

NO
POSITION Employee position number. VARCHAR2(6)

PERSABB

PERSABB_POSN

NO

NO
POSITION_TITLE Employee position description. VARCHAR2(30)

NBRJOBS

NBRJOBS_DESC

NO

NO
PREVIOUS_INSTITUTION_CREDIT Credit toward the number of years of service the employe may have from prior insitutions that may have some bearing on current faculty action eligibility. For Canadian College installations, this field is reported on the Annual Statistics Canada Report for Colleges. Two decimal places. NUMBER

NA

NA

NO

NO
PRIMARY_ACTIVITY Indicates whether the primary activity of the faculty member is instructional, research, or administrative. VARCHAR2(1)

NA

NA

NO

NO
PRIMARY_ACTIVITY_DESC Primary Activity description. VARCHAR2(30)

NA

NA

NO

NO
PRIMARY_DISCIPLINE Primary Discipline Code. VARCHAR2(6)

PERBFAC

PERBFAC_DISP_CODE

NO

NO
PRIMARY_DISCIPLINE_DESC Primary discipline code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
SABBATICAL_ACTION_DATE Action Date. DATE

PERSABB

PERSABB_ACTION_DATE

NO

NO
SABBATICAL_APPEAL_DATE Sabbatical/leave appeal date. DATE

PERSABB

PERSABB_APPEAL_DATE

NO

NO
SABBATICAL_BEGIN_DATE Sabbatical/leave requested from date. DATE

PERSABB

PERSABB_BEGIN_DATE

NO

NO
SABBATICAL_COMMENT Sabbatical/leave comments. VARCHAR2(4000)

PERSABB

PERSABB_COMMENT

NO

NO
SABBATICAL_DECISION Sabbatical approval decision. VARCHAR2(1)

PERSABB

PERSABB_DECISION

NO

NO
SABBATICAL_DECISION_DATE Date of sabbatical/leave decision. DATE

PERSABB

PERSABB_DECISION_DATE

NO

NO
SABBATICAL_DECISION_DEFER_DATE Sabbatical/leave decision deferred to date. DATE

PERSABB

PERSABB_DECISION_DEFER_DATE

NO

NO
SABBATICAL_DECISION_DESC Sabbatical approval decision description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
SABBATICAL_DEFER_BEGIN Approved sabbatical/leave begin date. DATE

PERSABB

PERSABB_DEFER_BEGIN

NO

NO
SABBATICAL_DEFER_END Approved sabbatical/leave end date. DATE

PERSABB

PERSABB_DEFER_END

NO

NO
SABBATICAL_END_DATE Sabbatical/leave requested To date. DATE

PERSABB

PERSABB_END_DATE

NO

NO
SABBATICAL_NEXT_DATE Sabbatical next eligibility date. DATE

PERSABB

PERSABB_NEXT_DATE

NO

NO
SABBATICAL_REASON Sabbatical/leave reason code. VARCHAR2(2)

PERSABB

PERSABB_LREA_CODE

NO

NO
SABBATICAL_REASON_DESC Sabbatical/leave reason description. VARCHAR2(30)

PTRLREA

PTRLREA_DESC

NO

NO
SABBATICAL_TYPE Classifies the type of sabbatical which is being tracked on this leave action. VARCHAR2(4)

PERSABB

PERSABB_SBTY_CODE

NO

NO
SABBATICAL_TYPE_DESC Sabbatical/leave type description. VARCHAR2(30)

PTVSBTY

PTVSBTY_DESC

NO

NO
STATE_PROVINCE_OF_BIRTH State or Province of the faculty's birth place. VARCHAR2(3)

PERBFAC

PERBFAC_BIRTH_STATE

NO

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

FTVCOAS

FTVCOAS_TITLE

NO

NO
TIMESHEET_CHART_OF_ACCOUNTS Timesheet chart of accounts. VARCHAR2(1)

PERSABB

PERSABB_COAS_CODE

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: