ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
AAUP_MEMBER_IND	Indicates the academic staff or faculty member belongs to the American Association of University Professors.
ACADEMIC_TITLE	Academic title.
CURRENT_DATE	System current date (sysdate) or date the data was extracted.			NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
EMERITUS_STATUS_IND	Emeritus status.
FACULTY_TYPE	Faculty type code.
FACULTY_TYPE_DESC	Faculty type code description.
INITIAL_RANK_IND	Rank initial record indicator.
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.
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.
ORGANIZATION_CODE	Organization code.
ORGANIZATION_DESC	Organization code desc.
ORIGINAL_APPOINT_BEGIN_DATE	Original appointment begin date.
ORIGINAL_APPOINT_END_DATE	Original appointment end date.
PERSON_UID	System generated, unique, internal identification number assigned to this person.
POSITION	Employee position number.
POSITION_TITLE	Employee position description.
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.
PRIMARY_ACTIVITY	Indicates whether the primary activity of the faculty member is instructional, research, or administrative.
PRIMARY_ACTIVITY_DESC	Primary Activity description.
PRIMARY_DISCIPLINE	Primary discipline code.
PRIMARY_DISCIPLINE_DESC	Primary discipline code description.
RANK	Rank code.
RANK_ACADEMIC_TITLE	Academic title.
RANK_ACTION_DATE	Rank action date.
RANK_APPEAL_DATE	Appeal date.
RANK_BEGIN_DATE	Rank effective date.
RANK_COMMENT	Rank comments.
RANK_DECISION	Decision for rank.
RANK_DECISION_DATE	Decision date for rank.
RANK_DECISION_DEFERRAL_DATE	Decision deferred to date.
RANK_DECISION_DESC	Rank decision description.
RANK_DESC	Rank code description.
RANK_EMERITUS_STATUS	Emeritue status.
RANK_NEXT_REVIEW_DATE	Rank next review Date.
STATE_PROVINCE_OF_BIRTH	Birth State.
TIMESHEET_CHART_DESC	Chart of accounts code description or title.
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet chart of accounts.
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.

Ver: 8.3