| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
AAUP_MEMBER_IND
|
Indicates the academic staff or faculty member belongs to the American Association of University Professors.
|
VARCHAR2(1)
|
NA
|
NA
|
|
ACADEMIC_TITLE
|
Name for the academic staff member title or position at the institution.
|
VARCHAR2(80)
|
PERBFAC
|
PERBFAC_ACADEMIC_TITLE
|
|
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
|
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
|
EMERITUS_STATUS_IND
|
Emeritus Status.
|
VARCHAR2(1)
|
PERBFAC
|
PERBFAC_EMERITUS_STATUS
|
|
FACULTY_TYPE
|
Faculty Type Code.
|
VARCHAR2(6)
|
PERBFAC
|
PERBFAC_FTYP_CODE
|
|
FACULTY_TYPE_DESC
|
Description of the faculty type code.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
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
|
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
|
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
|
|
NEXT_SABBATICAL_REASON_DESC
|
Next sabbatical/leave type description.
|
VARCHAR2(30)
|
PTRLREA
|
PTRLREA_DESC
|
|
ORGANIZATION_CODE
|
Organization code.
|
VARCHAR2(6)
|
PERSABB
|
PERSABB_ORGN
|
|
ORGANIZATION_DESC
|
Organization code desc.
|
VARCHAR2(35)
|
FTVORGN
|
FTVORGN_DESC
|
|
ORIGINAL_APPOINT_BEGIN_DATE
|
Original Appointment Begin Date.
|
DATE
|
PERBFAC
|
PERBFAC_ORIG_BEGIN_DATE
|
|
ORIGINAL_APPOINT_END_DATE
|
Original Appointment End Date.
|
DATE
|
PERBFAC
|
PERBFAC_ORIG_END_DATE
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER(8)
|
PERSABB
|
PERSABB_PIDM
|
|
POSITION
|
Employee position number.
|
VARCHAR2(6)
|
PERSABB
|
PERSABB_POSN
|
|
POSITION_TITLE
|
Employee position description.
|
VARCHAR2(30)
|
NBRJOBS
|
NBRJOBS_DESC
|
|
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(5, 2)
|
NA
|
NA
|
|
PRIMARY_ACTIVITY
|
Indicates whether the primary activity of the faculty member is instructional, research, or administrative.
|
VARCHAR2(1)
|
NA
|
NA
|
|
PRIMARY_ACTIVITY_DESC
|
Primary Activity description.
|
VARCHAR2(30)
|
NA
|
NA
|
|
PRIMARY_DISCIPLINE
|
Primary Discipline Code.
|
VARCHAR2(6)
|
PERBFAC
|
PERBFAC_DISP_CODE
|
|
PRIMARY_DISCIPLINE_DESC
|
Primary discipline code description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
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(1)
|
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(30)
|
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(2)
|
PERSABB
|
PERSABB_LREA_CODE
|
|
SABBATICAL_REASON_DESC
|
Sabbatical/leave reason description.
|
VARCHAR2(30)
|
PTRLREA
|
PTRLREA_DESC
|
|
SABBATICAL_TYPE
|
Classifies the type of sabbatical which is being tracked on this leave action.
|
VARCHAR2(4)
|
PERSABB
|
PERSABB_SBTY_CODE
|
|
SABBATICAL_TYPE_DESC
|
Sabbatical/leave type description.
|
VARCHAR2(30)
|
PTVSBTY
|
PTVSBTY_DESC
|
|
STATE_PROVINCE_OF_BIRTH
|
State or Province of the faculty's birth place.
|
VARCHAR2(3)
|
PERBFAC
|
PERBFAC_BIRTH_STATE
|
|
TIMESHEET_CHART_DESC
|
Chart of accounts code description or title.
|
VARCHAR2(35)
|
FTVCOAS
|
FTVCOAS_TITLE
|
|
TIMESHEET_CHART_OF_ACCOUNTS
|
Timesheet chart of accounts.
|
VARCHAR2(1)
|
PERSABB
|
PERSABB_COAS_CODE
|
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|