Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_AGE		Time in years between degree date and current date; 1 decimal point
ACADEMIC_TRACK_TYPE		Describes if faculty member if Tenure track, Non-tenure track, Part-time or a Visting Scholar
ACADEMIC_UNIT_1		Primary academic department of an interdiciplinary appointment
ACADEMIC_UNIT_2		Secondary academic department of an interdiciplinary appointment
ACADEMIC_UNIT_3		Tertiary academic department of an interdiciplinary appointment
ACCOUNT_INDEX_1		Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.
ACCOUNT_INDEX_1_PERCENT		Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution.
ACCOUNT_INDEX_2		Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.
ACCOUNT_INDEX_2_PERCENT		Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution.
ACCOUNT_INDEX_3		Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.
ACCOUNT_INDEX_3_PERCENT		Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution.
ACCOUNT_INDEX_4		Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.
ACCOUNT_INDEX_4_PERCENT		Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution.
ACCOUNT_INDEX_5		Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.
ACCOUNT_INDEX_5_PERCENT		Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution.
ACCOUNT_INDEX_6		Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.
ACCOUNT_INDEX_6_PERCENT		Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution.
ACTIVITY_DATE		Date of last activity (insert or update) on the record.
ADJUSTED_FACULTY_SALARY		Salary adjusted to 9 months/35 hours per week; only applicable to faculty, other roles have null value
ADJUSTED_SERVICE_DATE		Date used to determine years of service for leave accrual if the first hire date and current hire date are not equal.
AFRICAN_AMERICAN_IND		African American indicator
AMERICAN_INDIAN_IND		American Indian indicator
ANNUALIZED_FTE		A calculation of FTE using the position budget basis, position annual basis, and job appointment percent. Represents a calculated FTE value as pro-rated by the length of appointment against the annual value of the job, and factored by the employee's appointment.
ANNUAL_SALARY		Annual salary for the Employee_Position based on the calendar year.
APPOINTMENT_TYPE_1		Designates if an appointment is Primary or Joint
APPOINTMENT_TYPE_2		Designates if an appointment is Primary or Joint
APPOINTMENT_TYPE_3		Designates if an appointment is Primary or Joint
ASIAN_IND		Asian indicator
ASSIGNMENT_GRADE		Salary grade
BENEFITS_ELIGIBLE_CD		Code that indicates employee’s eligibility for employer-sponsored benefits.
BENEFITS_ELIGIBLE_DESC		Description of Benefits Eligible Cd.
BIRTH_DATE		Date of birth of person.
CIPCODE_DESC		Description for Cip_Code
CIP_CODE		Code assigned to tenure home discipline; used for reporting faculty data
CITIZENSHIP_DESC		Citizen type description
CITIZENSHIP_TYPE		Prior to Global Campus System updates: Indicates whether the person has been identified as a citizen of the United States. After 2022 Freeze and Global Campus System updates: Indicates whether the person is a citizen or permanent resident of their home campus country.
CONTRACT_BEGIN_DT		Date on which a contract begins. Significant to the encumbering process.
CONTRACT_END_DT		Date on which a contract ends. Significant to the encumbering process.
CONTRACT_NUMBER		Contract number associated with this Employee Position
CUPACIP_CODE		Description for Cupacip Name
CUPACIP_NAME		Cip Code used for reporting to CUPA (College and University Professional Association
CURRENT_HIRE_DATE		Employees current date of hire. May differ from original date of hire in cases where an employee is re-hired.
DEGREE_INSTITUTION		Instituion where employee graduated from
DEGREE_LEVEL		Highest educational degree type earned by an employee. Recorded as ‘Masters’. ‘Terminal Masters’, ‘Doctor’, or ‘Other’.
EFFECTIVE_DATE		Date an Employee_Position became effective in the payroll system
EMPLOYEE_AGE		Calculates the current age of a person based upon today's date.
EMPLOYEE_CLASS		Employee class code. Organizes position information consistent with employee groupings. At the employee level,used to help determine controls for benefits, leave, payroll and self-service rules. Employee class as listed in the Employee Table from PEAMPLE Banner Screen
EMPLOYEE_CLASS_DESC		Employee class long description. Employee class as listed in the Employee Table from PEAMPLE Banner Screen
EMPLOYEE_STATUS		Status of the employee (Active, Termed, etc.).
EMPLOYEE_STATUS_DESC		Employee status description.
EXEMPT_STATUS		Denotes if employee is exempt of non-exempt
FIRST_NAME		The first name given to a person at birth, baptism, another naming ceremony or through legal change.
FULL_OR_PART_TIME_IND		Internal part time/full time indicator, used for EEO reporting.
GENDER		The gender of a person, e.g. Male, Female.
GENDER_DESC		Gender code description.
GRADE_ENTRY_DT		Date when employee entered current grade
HEAD_OF_SUPERVISORY_ORGS		Notes if individual has direct reports
HISPANIC_LATINO_ETHNICITY_IND		Indicates if person's ethnicity is Latino or Hispanic. Due to mandated changes to the collection of race and ethnicity, these classifications were changed to separate Race and Ethnicity. Ethnicity can now be defined as either Hispanic or Latino, or Not Hispanic or Latino.
HRM_TENURE_DESC		Tenure description.
HRM_TENURE_EFFECTIVE_DATE		Date when tenure was granted
IMMIGRATION_STATUS		Indicates whether immigration information has been received. For U.S. clients, this is the I-9 Form status
IMMIGRATION_STATUS_DESC		I9 status description
INTERDISC_DIV_1		Code for primary Org Level 3 Division of interdisciplinary faculty
INTERDISC_DIV_2		Code for secondary Org Level 3 Division of interdisciplinary faculty
INTERDISC_DIV_3		Code for tertiary Org Level 3 Division of interdisciplinary faculty
INTERDISC_DIV_DESC_1		Description for Interdisc_Div_1
INTERDISC_DIV_DESC_2		Description for Interdisc_Div_2
INTERDISC_DIV_DESC_3		Description for Interdisc_Div_3
INTERDISC_FACULTY_FLAG		Indicates if a faculty member has an interdisciplinary appointment
INTERDISC_PERCENT_1		Percentage of funding from primary position for interdisciplinary faculty
INTERDISC_PERCENT_2		Percentage of funding from secondary position for interdisciplinary faculty
INTERDISC_PERCENT_3		Percentage of funding from tertiary position for interdisciplinary faculty
IPEDS_CONTRACT_TYPE		Indicates whether faculty members contract is annual (A) or multiyear (M). Only FT NTT faculty have values.
IPEDS_ETHNICITY_RACE_CODE		IPEDS reporting code
IPEDS_ETHNICITY_RACE_CODE_DESC		IPEDS reporting desc
IPEDS_PRIMARY_FUNCTION		Classification of employee function for IPEDS reporting purposes
IPEDS_PRIMARY_FUNCTION_DESC		Classification of employee function for IPEDS reporting purposes
IR_CAMPUS_CD		Code for the home campus of an employee
IR_CAMPUS_DESC		Description of IR Campus Code
IR_DEGREE_CODE		highest educational level employee degree
IR_DEGREE_DESC		Degree description
IR_DEGREE_YEAR		Year degree was earned
IR_FTPT		Calculation of FT PT based on position class and benefits eligibility
JOB_CHANGE_EFFECTIVE_DATE		Date an Employee_Position became effective in the payroll system.
JOB_FAMILY		Description of nature of work employee holds
JOB_FAMILY_GROUP		Grouping of JOB_FAMILY into more general categories
JOB_POSITION_NUMBER		Position number which is used to tie the employee's assignment to a position defined in the HR system
JOB_PROFILE_CODE		Job Code
JOB_PROFILE_DESC		Description of Job Profile Code
JOB_REPORTS_TO		Position to which this position reports. Identifies the next position in the organizational hierarchy. The reports to position must have a position definition and cannot report to itself.
JOB_REPORTS_TO_TITLE		Title of the posiiton to which this position reports.
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.
JOB_SUPERVISOR_ID		NUID of the supervisor
JOB_SUPERVISOR_NAME		Combination of the person's first, middle initial, and last name of the supervisor.
LAST_NAME		The last name by which a person is known.
MANAGEMENT_LEVEL		Organizes the job classifications for the institution and holds attributes that control title, employee class, eel code and wage and salary data. Also, the primary organizer for the design and maintenance of the position definition. These attributes are inherited when the employee is assigned to the position.
MIDDLE_NAME		A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change.
NATION_OF_CITIZENSHIP		Prior to Global Campus System updates: Country code of the nation where the person maintains citizenship. Note: There is currently no way to store dual citizenships After 2022 Freeze and Global Campus System updates:: Country code of the nation where the person maintainS citizenship. Note: In the case of dual citizens, it is the citizenship under which they applied to the university.
NATION_OF_CITIZENSHIP_DESC		Nation/country of citizenship description for the person.
NUID		Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.
NU_RACE_NAME		Race name value or values for internal reporting
ORG_LEVEL_2_EXEC		Retrieves level 2 organization within this organization hierarchy.
ORG_LEVEL_2_EXEC_DESC		Retrieves description or title level 2 within this organization hierarchy.
ORG_LEVEL_3_DIV		Retrieves level 3 organization within this organization hierarchy.
ORG_LEVEL_3_DIV_DESC		Retrieves description or title level 3 within this organization hierarchy.
ORG_LEVEL_5_SCHOOL		Retrieves level 5 organization within this organization hierarchy.
ORG_LEVEL_5_SCHOOL_DESC		Retrieves description or title level 5 within this organization hierarchy.
ORG_LEVEL_7_DEPT		Retrieves level 7 organization within this organization hierarchy.
ORG_LEVEL_7_DEPT_DESC		Retrieves description or title level 7 within this organization hierarchy.
ORG_LEVEL_8_1		First organization to which the time sheet for this position is sent.
ORG_LEVEL_8_1_DESC		Retrieves description or title level 8 within this organizational hierarchy
ORG_LEVEL_8_2		Second organization to which the time sheet for this position is sent.
ORG_LEVEL_8_2_DESC		Retrieves description or title level 8 within this organizational hierarchy
ORG_LEVEL_8_3		Third organization to which the time sheet for this position is sent.
ORG_LEVEL_8_3_DESC		Retrieves description or title level 8 within this organizational hierarchy
ORIGINAL_HIRE_DATE		Date the employee was first hired.
PACIFIC_ISLDR_IND		Pacific Islander Indicator
PERM_ADDRESS_CITY		This field maintains the municipality associated with the address of person
PERM_ADDRESS_COUNTRY_CODE		This field maintains the nation/country associated with the address of person.
PERM_ADDRESS_COUNTRY_NAME		Country code description
PERM_ADDRESS_STATE		This field maintains the state, province or territory associated with the address of person.
PERM_ADDRESS_ZIP		This field maintains the postal code associated with the address of person
PERSON_UID		System generated Banner unique ID which gets assigned to all person and non-person records within Banner
POSITION_BEGIN_DATE		Employee_Position begin date. The date the job assignment started.
POSITION_CHANGE_REASON_CODE		Employee_Position change reason. Job change reason code associates the reason for the change with the Employee_Position record (future change).
POSITION_CONTRACT_TYPE		Indicates whether this is the Primary, Secondary, or Overload position
POSITION_CONTRACT_TYPE_DESC		Description for the type of employee contract.
POSITION_EMPL_CLASS		Employee class code. Organizes position information consistent with employee groupings. At the employee level, it's used to help determine controls for benefits, leave, payroll and self-service rules.
POSITION_EMPL_CLASS_DESC		Employee class description.
POSITION_PERSONNEL_DATE		True effective date of the job change. Date the change became effective, regardless of payroll. The personnel change Date is the date this change was actually made; as opposed to the effective date (the date the change became effective in the payroll system).
POSITION_STATUS		Status of the employee position
POSITION_STATUS_DESC		Position status description
POSITION_TITLE		Employee_Position description. Defaults from the position title if left blank.
PREFFERED_FIRST_NAME		If a person prefers to go by a name that is different from his/her legal name, the university allows the person to do this by setting a preferred name.
PRIMARY_DISCIPLINE		Department in which faculty's tenure is/was approved
PRIMARY_DISCIPLINE_DESC		Primary discipline code description
RACE_CONCAT		A concatenation of an individual's home country campus and all race codes selected
RANK		Numeric code that represents academic rank; 21=Professor; 22=Associate; 21=Assistant
RANK_BEGIN_DATE		Date when faculty entered current rank
RANK_DESC		Rank code description
REPORTING_CATEGORY		Standard Occupation Code grouping used for IPEDS report
ROLE_CD		Employee classification by the role, like Faculty, Staff, SGA, Other
SABBATICAL_BEGIN_DATE		Sabbatical/leave requested from date.
SABBATICAL_END_DATE		Sabbatical/leave requested to date
SABBATICAL_NEXT_DATE		Sabbatical next eligibility date.
SABBATICAL_TYPE		Classifies the type of sabbatical which is being tracked on this leave action
SABBATICAL_TYPE_DESC		Sabbatical/leave type description
SENIORITY_DATE		Institution defined date field.
SERVICE_YEARS		Calculates the length of service in years for active employees based on the difference between today's date and adjusted service date
STANDARD_HRS		The number of hours an employee filling this job normally works in a week; hrs_day multipled by 5
STD_OCCUPATIONAL_CATEGORY_CODE		Code defined by federal government to classify workers into one of 23 major groupings.
STD_OCCUPATIONAL_CATEGORY_DESC		Code defined by federal government to classify workers into one of 23 major groupings.
TENURE_EFFECTIVE_DATE		Date when tenure was granted
TENURE_REVIEW_DATE		Tenure review date
TENURE_TRACKING_BEGIN_DATE		Date when tenure tracking started
TERMINAL_DEGREE		Indicates the faculty member has earned the highest degree available in their discipline.
TIMESHEET_ORG		Level 8 org in NBRJOBS. Organization to which the time sheet for this position is sent.
TIMESHEET_ORG_DESCR		Organization to which this Employee_Position's time sheet is sent. Description corresponding to the level 8 org in NBRJOBS
TIME_IN_ASSISTANT_RANK		Years spent as an Assistant Professor
TIME_IN_ASSOCIATE_RANK		Years as an Associate Professor
TIME_IN_PROFESSOR_RANK		Years as a Full Professor
WHITE_IND		White race indicator

Ver: 9.0