| 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)
|
|
|
|
NO
|
|
ACADEMIC_TITLE
|
Academic title.
|
VARCHAR2(80)
|
|
|
|
NO
|
|
APPEAL_DATE
|
Appeal Date.
|
DATE
|
|
|
|
NO
|
|
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
|
|
|
|
NO
|
|
APPOINTMENT_BEGIN_DATE
|
This records the offical begin date of the faculty members appointment or reappointment.
|
DATE
|
|
|
|
NO
|
|
APPOINTMENT_COMMENTS
|
Appointment comments.
|
VARCHAR2(4000)
|
|
|
|
NO
|
|
APPOINTMENT_DECISION
|
Appointment decision.
|
VARCHAR2(1)
|
|
|
|
NO
|
|
APPOINTMENT_DECISION_DATE
|
Date of decision.
|
DATE
|
|
|
|
NO
|
|
APPOINTMENT_DECISION_DESC
|
Appointment decision description.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
APPOINTMENT_DISCIPLINE
|
Discipline code.
|
VARCHAR2(6)
|
|
|
|
NO
|
|
APPOINTMENT_DISCIPLINE_DESC
|
Discipline code description.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
APPOINTMENT_EFFECTIVE_DATE
|
Appointment Effective Date.
|
DATE
|
|
|
|
NO
|
|
APPOINTMENT_END_DATE
|
This records the offical end date of the faculty members appointment or reappointment.
|
DATE
|
|
|
|
NO
|
|
APPOINTMENT_FACULTY_TYPE
|
Faculty type code.
|
VARCHAR2(6)
|
|
|
|
NO
|
|
APPOINTMENT_FACULTY_TYPE_DESC
|
Faculty type code description.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
APPOINTMENT_NEXT_REVIEW_DATE
|
Appointment Next Review Date.
|
DATE
|
|
|
|
NO
|
|
APPOINTMENT_REVIEW
|
Appointment review code.
|
VARCHAR2(2)
|
|
|
|
NO
|
|
APPOINTMENT_REVIEW_DESC
|
Appointment review code description.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
APPOINT_DECISION_DEFERRAL_DATE
|
Decision deferred to date.
|
DATE
|
|
|
|
NO
|
|
CONTRACT_LENGTH
|
|
VARCHAR2(1)
|
|
|
|
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)
|
|
|
|
NO
|
|
EMERITUS_STATUS_IND
|
Emeritus status.
|
VARCHAR2(1)
|
|
|
|
NO
|
|
FACULTY_TYPE
|
Faculty type code.
|
VARCHAR2(6)
|
|
|
|
NO
|
|
FACULTY_TYPE_DESC
|
Faculty type code description.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
INITIAL_TENURE_IND
|
Initial tenure record.
|
VARCHAR2(1)
|
|
|
|
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)
|
|
|
|
NO
|
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
|
|
|
NO
|
|
ORGANIZATION_CODE
|
Organization code.
|
VARCHAR2(6)
|
|
|
|
NO
|
|
ORGANIZATION_DESC
|
Organization code desc.
|
VARCHAR2(35)
|
|
|
|
NO
|
|
ORIGINAL_APPOINT_BEGIN_DATE
|
Original appointment begin date.
|
DATE
|
|
|
|
NO
|
|
ORIGINAL_APPOINT_END_DATE
|
Original appointment end date.
|
DATE
|
|
|
|
NO
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
|
|
|
NO
|
|
POSITION
|
Employee position number.
|
VARCHAR2(6)
|
|
|
|
NO
|
|
POSITION_TITLE
|
Employee position description.
|
VARCHAR2(30)
|
|
|
|
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
|
|
|
|
NO
|
|
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
|
|
|
|
NO
|
|
PRIMARY_ACTIVITY
|
Indicates whether the primary activity of the faculty member is instructional, research, or administrative.
|
VARCHAR2(1)
|
|
|
|
NO
|
|
PRIMARY_ACTIVITY_DESC
|
Primary Activity description.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
PRIMARY_DISCIPLINE
|
Primary discipline code.
|
VARCHAR2(6)
|
|
|
|
NO
|
|
PRIMARY_DISCIPLINE_DESC
|
Primary discipline code description.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
STATE_PROVINCE_OF_BIRTH
|
Birth State.
|
VARCHAR2(3)
|
|
|
|
NO
|
|
TENURE
|
Identifies whether this faculty or academic member of staff has tenure.
|
VARCHAR2(2)
|
|
|
|
NO
|
|
TENURE_CREDIT
|
Tenure credit this appointment.
|
NUMBER
|
|
|
|
NO
|
|
TENURE_DESC
|
Tenure description.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
TENURE_EFFECTIVE_DATE
|
Tenure effective date.
|
DATE
|
|
|
|
NO
|
|
TENURE_FULL_TIME_EQUIVALENCY
|
Full Time Equivalency of Tenure for employee by department granting tenure.
|
NUMBER
|
|
|
|
NO
|
|
TENURE_REVIEW
|
Tenure review code.
|
VARCHAR2(2)
|
|
|
|
NO
|
|
TENURE_REVIEW_DATE
|
Tenure review date.
|
DATE
|
|
|
|
NO
|
|
TENURE_REVIEW_DESC
|
Tenure review code description.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
TENURE_TRACKING_BEGIN_DATE
|
Date when tenure tracking started.
|
DATE
|
|
|
|
NO
|
|
TERMINAL_APPOINTMENT_IND
|
Terminal appointment.
|
VARCHAR2(1)
|
|
|
|
NO
|
|
TIMESHEET_CHART_DESC
|
Chart of accounts code description or title.
|
VARCHAR2(35)
|
|
|
|
NO
|
|
TIMESHEET_CHART_OF_ACCOUNTS
|
Timesheet chart of accounts.
|
VARCHAR2(1)
|
|
|
|
NO
|
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
|
|
|
NO
|