| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
AAUP_MEMBER_IND
|
AAUP Member Indicator
|
Indicates the academic staff or faculty member belongs to the American Association of University Professors.
|
VARCHAR2(63)
|
PERBFAC
|
PERBFAC_AAUP_IND
|
|
ACADEMIC_TITLE
|
Academic Title
|
Name for the academic staff member title or position at the institution. Examples may include, associate professor, adjunct faculty member, etc.
|
VARCHAR2(255)
|
PERBFAC SIBFACD
|
PERBFAC_ACADEMIC_TITLE SIBFACD_ACADEMIC_TITLE
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
APPEAL_DATE
|
Appeal Date
|
Appeal Date.
|
DATE
|
PERAPPT
|
PERAPPT_APPEAL_DATE
|
|
APPOINTMENT_ACTION_DATE
|
Appointment Action Date
|
The Action Date will generally be the date in which the information was intiated on behalf of the faculty member and typically reflects a date for work organization.
|
DATE
|
PERAPPT
|
PERAPPT_ACTION_DATE
|
|
APPOINTMENT_BEGIN_DATE
|
Appointment Begin Date
|
This records the offical begin date of the faculty member's appointment or reappointment.
|
DATE
|
PERAPPT
|
PERAPPT_BEGIN_DATE
|
|
APPOINTMENT_CHART_DESC
|
Appointment Chart Description
|
Chart of accounts code description or title.
|
VARCHAR2(255)
|
FTVCOAS
|
FTVCOAS_TITLE
|
|
APPOINTMENT_COMMENTS
|
Appointment Comments
|
Appointment comments.
|
VARCHAR2(4000)
|
PERAPPT
|
PERAPPT_COMMENT
|
|
APPOINTMENT_DECISION
|
Appointment Decision
|
Appointment decision.
|
VARCHAR2(63)
|
PERAPPT
|
PERAPPT_DECISION
|
|
APPOINTMENT_DECISION_DATE
|
Appointment Decision Date
|
Date of decision.
|
DATE
|
PERAPPT
|
PERAPPT_DECISION_DATE
|
|
APPOINTMENT_DECISION_DESC
|
Appointment Decision Description
|
Appointment decision description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(PERAPPT_DECISION)
|
|
APPOINTMENT_DISCIPLINE
|
Appointment Discipline
|
Discipline code.
|
VARCHAR2(63)
|
PERAPPT
|
PERAPPT_DISP_CODE
|
|
APPOINTMENT_DISCIPLINE_DESC
|
Appointment Discipline Description
|
Discipline code description.
|
VARCHAR2(255)
|
PTVDISP
|
PTVDISP_DESC
|
|
APPOINTMENT_EFFECTIVE_DATE
|
Appointment Effective Date
|
Appointment Effective Date.
|
DATE
|
PERAPPT
|
PERAPPT_APPT_EFF_DATE
|
|
APPOINTMENT_END_DATE
|
Appointment End Date
|
This records the offical end date of the faculty member's appointment or reappointment.
|
DATE
|
PERAPPT
|
PERAPPT_END_DATE
|
|
APPOINTMENT_FACULTY_TYPE
|
Appointment Faculty Type
|
Faculty type code.
|
VARCHAR2(63)
|
PERAPPT
|
PERAPPT_FTYP_CODE
|
|
APPOINTMENT_FACULTY_TYPE_DESC
|
Appointment Faculty Type Description
|
Faculty type code description.
|
VARCHAR2(255)
|
PTRFTYP
|
PTRFTYP_DESC
|
|
APPOINTMENT_JOB_SUFFIX
|
Appointment 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)
|
PERAPPT
|
PERAPPT_SUFF
|
|
APPOINTMENT_NEXT_REVIEW_DATE
|
Appointment Next Review Date
|
Appointment Next Review Date.
|
DATE
|
PERAPPT
|
PERAPPT_NEXT_DATE
|
|
APPOINTMENT_ORGANIZATION_CODE
|
Appointment Organization Code
|
Organization code.
|
VARCHAR2(63)
|
PERAPPT
|
PERAPPT_ORGN
|
|
APPOINTMENT_ORGANIZATION_DESC
|
Appointment Organization Description
|
Organization code desc.
|
VARCHAR2(255)
|
FTVORGN PTVORGN
|
FTVORGN_DESC PTVORGN_DESC
|
|
APPOINTMENT_POSITION
|
Appointment Position
|
Employee position number.
|
VARCHAR2(63)
|
PERAPPT
|
PERAPPT_POSN
|
|
APPOINTMENT_POSITION_TITLE
|
Appointment Position Title
|
Employee position description.
|
VARCHAR2(255)
|
NBRJOBS
|
NBRJOBS_DESC
|
|
APPOINTMENT_REVIEW
|
Appointment Review
|
Appointment review code.
|
VARCHAR2(63)
|
PERAPPT
|
PERAPPT_REVT_REAPP_CODE
|
|
APPOINTMENT_REVIEW_DESC
|
Appointment Review Description
|
Appointment review code description.
|
VARCHAR2(255)
|
PTVREVT
|
PTVREVT_DESC
|
|
APPOINTMENT_TIMESHEET_CHART
|
Appointment Timesheet Chart
|
Timesheet chart of accounts.
|
VARCHAR2(63)
|
PERAPPT
|
PERAPPT_COAS_CODE
|
|
APPOINT_DECISION_DEFERRAL_DATE
|
Appoint Decision Deferral Date
|
Decision deferred to date.
|
DATE
|
PERAPPT
|
PERAPPT_DECISION_DEFER_DATE
|
|
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
|
|
EMERITUS_STATUS_IND
|
Emeritus Status Indicator
|
Emeritus status.
|
VARCHAR2(63)
|
PERBFAC
|
PERBFAC_EMERITUS_STATUS
|
|
FACULTY_TYPE
|
Faculty Type
|
Faculty type code.
|
VARCHAR2(63)
|
PERBFAC
|
PERBFAC_FTYP_CODE
|
|
FACULTY_TYPE_DESC
|
Faculty Type Description
|
Faculty type code description.
|
VARCHAR2(255)
|
PTRFTYP
|
PTRFTYP_DESC
|
|
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
|
|
INITIAL_RANK_IND
|
Initial Rank Indicator
|
Rank initial record indicator.
|
VARCHAR2(63)
|
PERRANK
|
PERRANK_INITIAL
|
|
INITIAL_TENURE_IND
|
Initial Tenure Indicator
|
Initial tenure record.
|
VARCHAR2(63)
|
PERAPPT
|
PERAPPT_INITIAL_TENURE
|
|
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
|
|
ORIGINAL_APPOINT_BEGIN_DATE
|
Original Appoint Begin Date
|
Original appointment begin date.
|
DATE
|
PERBFAC
|
PERBFAC_ORIG_BEGIN_DATE
|
|
ORIGINAL_APPOINT_END_DATE
|
Original Appoint End Date
|
Original appointment end date.
|
DATE
|
PERBFAC
|
PERBFAC_ORIG_END_DATE
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
PERAPPT PERBFAC PERRANK PERSABB
|
PERAPPT_PIDM PERBFAC_PIDM PERRANK_PIDM PERSABB_PIDM
|
|
PREVIOUS_INSTITUTION_CREDIT
|
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
|
PERBFAC
|
PERBFAC_PREV_INST_CREDIT
|
|
PREVIOUS_TENURE_GRANT
|
Previous Tenure Grant
|
Records tenure credit, awarded at a previous institution, being considered for credit at this institution. It may also be used to record credit given in a negotiated appointment or lapse in service.
|
NUMBER
|
PERAPPT
|
PERAPPT_PREV_GRT_TENR
|
|
PRIMARY_ACTIVITY
|
Primary Activity
|
Indicates whether the primary activity of the faculty member is instructional, research, or administrative.
|
VARCHAR2(63)
|
PERBFAC
|
PERBFAC_PRIMARY_ACTIVITY
|
|
PRIMARY_ACTIVITY_DESC
|
Primary Activity Description
|
Primary activity description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(PERBFAC_PRIMARY_ACTIVITY)
|
|
PRIMARY_DISCIPLINE
|
Primary Discipline
|
Primary discipline code.
|
VARCHAR2(63)
|
PERBFAC
|
PERBFAC_DISP_CODE
|
|
PRIMARY_DISCIPLINE_DESC
|
Primary Discipline Description
|
Primary discipline code description.
|
VARCHAR2(255)
|
PTVDISP
|
PTVDISP_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
|
|
RANK
|
Rank
|
Rank code.
|
VARCHAR2(63)
|
PERRANK
|
PERRANK_RANK_CODE
|
|
RANK_ACADEMIC_TITLE
|
Rank Academic Title
|
Academic title.
|
VARCHAR2(255)
|
PERRANK
|
PERRANK_ACADEMIC_TITLE
|
|
RANK_ACTION_DATE
|
Rank Action Date
|
Rank action date.
|
DATE
|
PERRANK
|
PERRANK_ACTION_DATE
|
|
RANK_APPEAL_DATE
|
Rank Appeal Date
|
Appeal date.
|
DATE
|
PERRANK
|
PERRANK_APPEAL_DATE
|
|
RANK_BEGIN_DATE
|
Rank Begin Date
|
Rank effective date.
|
DATE
|
PERRANK
|
PERRANK_BEGIN_DATE
|
|
RANK_COMMENT
|
Rank Comment
|
Rank comments.
|
VARCHAR2(4000)
|
PERRANK
|
PERRANK_COMMENT
|
|
RANK_DECISION
|
Rank Decision
|
Decision for rank.
|
VARCHAR2(63)
|
PERRANK
|
PERRANK_DECISION
|
|
RANK_DECISION_DATE
|
Rank Decision Date
|
Decision date for rank.
|
DATE
|
PERRANK
|
PERRANK_DECISION_DATE
|
|
RANK_DECISION_DEFERRAL_DATE
|
Rank Decision Deferral Date
|
Decision deferred to date.
|
DATE
|
PERRANK
|
PERRANK_DECISION_DEFER_DATE
|
|
RANK_DECISION_DESC
|
Rank Decision Description
|
Rank decision description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(PERRANK_DECISION)
|
|
RANK_DESC
|
Rank Description
|
Rank code description.
|
VARCHAR2(255)
|
PTRRANK
|
PTRRANK_DESC
|
|
RANK_EMERITUS_STATUS
|
Rank Emeritus Status
|
Emeritue status.
|
VARCHAR2(63)
|
PERRANK
|
PERRANK_EMERITUS_STATUS
|
|
RANK_JOB_SUFFIX
|
Rank 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)
|
PERRANK
|
PERRANK_SUFF
|
|
RANK_NEXT_REVIEW_DATE
|
Rank Next Review Date
|
Rank next review Date.
|
DATE
|
PERRANK
|
PERRANK_NEXT_DATE
|
|
RANK_ORGANIZATION_CODE
|
Rank Organization Code
|
Organization code.
|
VARCHAR2(63)
|
PERRANK
|
PERRANK_ORGN
|
|
RANK_ORGANIZATION_DESC
|
Rank Organization Description
|
Organization code desc.
|
VARCHAR2(255)
|
PTVORGN
|
PTVORGN_DESC
|
|
RANK_POSITION
|
Rank Position
|
Employee position number.
|
VARCHAR2(63)
|
PERRANK
|
PERRANK_POSN
|
|
RANK_POSITION_TITLE
|
Rank Position Title
|
Employee position description.
|
VARCHAR2(255)
|
NBRJOBS
|
NBRJOBS_DESC
|
|
RANK_TIMESHEET_CHART
|
Rank Timesheet Chart
|
Chart of accounts code as defined by the Banner Finance system.
|
VARCHAR2(63)
|
PERRANK
|
PERRANK_COAS_CODE
|
|
RANK_TIMESHEET_CHART_DESC
|
Rank Timesheet Chart Description
|
Chart of accounts code description or title.
|
VARCHAR2(255)
|
FTVCOAS
|
FTVCOAS_TITLE
|
|
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_CHART_DESC
|
Sabbatical Chart Description
|
Chart of accounts code description or title.
|
VARCHAR2(255)
|
FTVCOAS
|
FTVCOAS_TITLE
|
|
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)
|
CALCULATION
|
DECODE(PERSABB_DECISION)
|
|
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_JOB_SUFFIX
|
Sabbatical 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
|
|
SABBATICAL_NEXT_DATE
|
Sabbatical Next Date
|
Sabbatical next eligibility date.
|
DATE
|
PERSABB
|
PERSABB_NEXT_DATE
|
|
SABBATICAL_ORGANIZATION_CODE
|
Sabbatical Organization Code
|
Organization code.
|
VARCHAR2(63)
|
PERSABB
|
PERSABB_ORGN
|
|
SABBATICAL_ORGANIZATION_DESC
|
Sabbatical Organization Description
|
Organization code desc.
|
VARCHAR2(255)
|
FTVORGN PTVORGN
|
FTVORGN_DESC PTVORGN_DESC
|
|
SABBATICAL_POSITION
|
Sabbatical Position
|
Employee position number.
|
VARCHAR2(63)
|
PERSABB
|
PERSABB_POSN
|
|
SABBATICAL_POSITION_TITLE
|
Sabbatical Position Title
|
Employee position description.
|
VARCHAR2(255)
|
NBRJOBS
|
NBRJOBS_DESC
|
|
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_TIMESHEET_CHART
|
Sabbatical Timesheet Chart
|
Chart of Accounts Code.
|
VARCHAR2(63)
|
PERSABB
|
PERSABB_COAS_CODE
|
|
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
|
|
STATE_PROVINCE_OF_BIRTH
|
State Province Of Birth
|
Birth State.
|
VARCHAR2(63)
|
PERBFAC
|
PERBFAC_BIRTH_STATE
|
|
TENURE
|
Tenure
|
Identifies whether this faculty or academic member of staff has tenure.
|
VARCHAR2(63)
|
PERAPPT
|
PERAPPT_TENURE_CODE
|
|
TENURE_CREDIT
|
Tenure Credit
|
Tenure credit this appointment.
|
NUMBER
|
PERAPPT
|
PERAPPT_CREDIT
|
|
TENURE_DESC
|
Tenure Description
|
Tenure description.
|
VARCHAR2(255)
|
PTRTENR
|
PTRTENR_DESC
|
|
TENURE_EFFECTIVE_DATE
|
Tenure Effective Date
|
Date of the faculty tenure.
|
DATE
|
PERAPPT
|
PERAPPT_TENURE_EFF_DATE
|
|
TENURE_FULL_TIME_EQUIVALENCY
|
Tenure Full Time Equivalency
|
Full Time Equivalency of Tenure for employee by department granting tenure.
|
NUMBER
|
PERAPPT
|
PERAPPT_TENURE_FTE
|
|
TENURE_REVIEW
|
Tenure Review
|
Tenure review code.
|
VARCHAR2(63)
|
PERAPPT
|
PERAPPT_REVT_TENURE_CODE
|
|
TENURE_REVIEW_DATE
|
Tenure Review Date
|
Tenure review date.
|
DATE
|
PERAPPT
|
PERAPPT_TENURE_REV_DATE
|
|
TENURE_REVIEW_DESC
|
Tenure Review Description
|
Tenure review code description.
|
VARCHAR2(255)
|
PTVREVT
|
PTVREVT_DESC
|
|
TENURE_TRACKING_BEGIN_DATE
|
Tenure Tracking Begin Date
|
Date when tenure tracking started.
|
DATE
|
PERAPPT
|
PERAPPT_TENURE_TRAC_BEGIN_DATE
|
|
TERMINAL_APPOINTMENT_IND
|
Terminal Appointment Indicator
|
Terminal appointment.
|
VARCHAR2(63)
|
PERAPPT
|
PERAPPT_TERMINAL_APPT
|