| 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
|
NUMBER(4,1)
|
|
|
|
|
ACADEMIC_PERIOD_FREEZE
|
|
Currently Under Review
|
VARCHAR2(8 CHAR)
|
|
|
|
|
ACADEMIC_PERIOD_FREEZE_DESC
|
|
Currently Under Review
|
VARCHAR2(265 CHAR)
|
|
|
|
|
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.
|
VARCHAR2(100 CHAR)
|
|
|
|
|
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.
|
VARCHAR2(100 CHAR)
|
|
|
|
|
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.
|
VARCHAR2(100 CHAR)
|
|
|
|
|
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.
|
VARCHAR2(100 CHAR)
|
|
|
|
|
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.
|
VARCHAR2(100 CHAR)
|
|
|
|
|
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.
|
VARCHAR2(100 CHAR)
|
|
|
|
|
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.
|
VARCHAR2(100 CHAR)
|
|
|
|
|
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.
|
VARCHAR2(100 CHAR)
|
|
|
|
|
ACCOUNT_INDEX_5
|
|
Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution.
|
VARCHAR2(100 CHAR)
|
|
|
|
|
ACCOUNT_INDEX_5_PERCENT
|
|
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.
|
VARCHAR2(100 CHAR)
|
|
|
|
|
ACCOUNT_INDEX_6
|
|
Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution.
|
VARCHAR2(100 CHAR)
|
|
|
|
|
ACCOUNT_INDEX_6_PERCENT
|
|
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.
|
VARCHAR2(100 CHAR)
|
|
|
|
|
ACTIVITY_DATE
|
|
Date of last activity (insert or update) on the record.
|
DATE
|
|
|
|
|
ADJUSTED_FACULTY_SALARY
|
|
Salary adjusted to 39 week/35 hours per week; only applicable to faculty, other roles have null value.
|
NUMBER(10,2)
|
|
|
|
|
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.
|
DATE
|
|
|
|
|
AFRICAN_AMERICAN_IND
|
|
African American indicator
|
VARCHAR2(1 CHAR)
|
|
|
|
|
AMERICAN_INDIAN_IND
|
|
American Indian indicator
|
VARCHAR2(1 CHAR)
|
|
|
|
|
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.
|
NUMBER
|
|
|
|
|
ANNUAL_SALARY
|
|
Annual salary for the Employee_Position based on the calendar year.
|
NUMBER(10,2)
|
|
|
|
|
ANOTHER TEST
|
|
DEFINITION
|
VARCHAR
|
|
|
|
|
ASIAN_IND
|
|
Asian indicator
|
VARCHAR2(1 CHAR)
|
|
|
|
|
ASSIGNMENT_GRADE
|
|
Salary grade
|
VARCHAR2(63 CHAR)
|
|
|
|
|
BIRTH_DATE
|
|
Date of birth of person.
|
DATE
|
|
|
|
|
CIP_CODE
|
|
Code assigned to tenure home discipline; used for reporting faculty data
|
VARCHAR2(63 CHAR)
|
|
|
|
|
CITIZENSHIP_DESC
|
|
Citizen type description
|
VARCHAR2(255 CHAR)
|
|
|
|
|
CITIZENSHIP_TYPE
|
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.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
CONTRACT_BEGIN_DT
|
|
Date on which a contract begins. Significant to the encumbering process.
|
DATE
|
|
|
|
|
CONTRACT_END_DT
|
|
Date on which a contract ends. Significant to the encumbering process.
|
DATE
|
|
|
|
|
CONTRACT_NUMBER
|
|
Contract number associated with this Employee Position
|
VARCHAR2(63 CHAR)
|
|
|
|
|
CURRENT_HIRE_DATE
|
|
Employees current date of hire. May differ from original date of hire in cases where an employee is re-hired.
|
DATE
|
|
|
|
|
DEGREE_INSTITUTION
|
|
Instituion where employee graduated from
|
VARCHAR2(63 CHAR)
|
|
|
|
|
EEO_SKILL
|
|
Used by institutions of higher education for Equal Employment Opportunity skills reporting as defined by the federal government.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
EEO_SKILL_DESC
|
|
EEO skill description.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
EFFECTIVE_DATE
|
|
Date an Employee_Position became effective in the payroll system
|
DATE
|
|
|
|
|
EMPLOYEE_AGE
|
|
Calculates the current age of a person based upon today's date.
|
NUMBER(4,1)
|
|
|
|
|
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
|
VARCHAR2(63 CHAR)
|
|
|
|
|
EMPLOYEE_CLASS_DESC
|
|
Employee class long description. Employee class as listed in the Employee Table from PEAMPLE Banner Screen
|
VARCHAR2(255 CHAR)
|
|
|
|
|
EMPLOYEE_STATUS
|
|
Status of the employee (Active, Termed, etc.).
|
VARCHAR2(63 CHAR)
|
|
|
|
|
EMPLOYEE_STATUS_DESC
|
|
Employee status description.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
EMPLOYMENT_CATEGORY
|
|
Federal employment reporting categories that identify either the number of month or whether the employment length is full time or part time. IPEDS report classification that specifies contract length (9,10,12 months) for faculty.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
EMPLOYMENT_CATEGORY_DESC
|
|
Employment category description. IPEDS report classification that specifies contract length (9,10,12 months) for faculty.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
EVENT
|
|
Currently Under Review
|
VARCHAR2(63 CHAR)
|
|
|
|
|
FIRST_NAME
|
|
The first name given to a person at birth, baptism, another naming ceremony or through legal change.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
FREEZE_DATE
|
|
Currently Under Review
|
DATE
|
|
|
|
|
FULL_OR_PART_TIME_IND
|
|
Internal part time/full time indicator, used for EEO reporting.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
FUNDING_END_DATE
|
|
Currently Under Review
|
DATE
|
|
|
|
|
GENDER
|
|
The gender of a person, e.g. Male, Female.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
GENDER_DESC
|
|
Gender code description.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
GRADE_ENTRY_DT
|
|
Currently Under Review
|
DATE
|
|
|
|
|
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.
|
VARCHAR2(1 CHAR)
|
|
|
|
|
HOME_CAMPUS_CD
|
HOME CAMPUS CD
|
The approved campus location assigned to a student or employee upon application, enrollment or hiring. Added after 202210 Freeze as part of Global Campus System updates.
|
VARCHAR2(63)
|
|
|
|
|
HOME_CAMPUS_COUNTRY
|
HOME CAMPUS COUNTRY
|
The nation of a student's Home Campus Cd. Added after 202210 Freeze as part of Global Campus System updates.
|
VARCHAR2(255)
|
|
|
|
|
HOME_CAMPUS_COUNTRY_DESC
|
HOME CAMPUS COUNTRY DESC
|
Description of HOME CAMPUS COUNTRY. Added after 202210 Freeze as part of Global Campus System updates.
|
VARCHAR2(255)
|
|
|
|
|
HOME_CAMPUS_DESC
|
HOME CAMPUS DESC
|
Description of HOME CAMPUS CD. Added after 202210 Freeze as part of Global Campus System updates.
|
VARCHAR2(255)
|
|
|
|
|
HRM_TENURE_DESC
|
|
Tenure description.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
HRM_TENURE_EFFECTIVE_DATE
|
|
Date when tenure was granted
|
DATE
|
|
|
|
|
IMMIGRATION_STATUS
|
|
Indicates whether immigration information has been received. For U.S. clients, this is the I-9 Form status
|
VARCHAR2(63 CHAR)
|
|
|
|
|
IMMIGRATION_STATUS_DESC
|
|
I9 status description.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
INTERDISC_FACULTY_FLAG
|
|
Indicates whether faculty is listed in the interdicsciplinary faculty view (1=interdisciplinary faculty, null=not)
|
VARCHAR2(63 CHAR)
|
|
|
|
|
IPEDS_CONTRACT_TYPE
|
|
Indicates whether faculty member’s contract is annual (A) or multiyear (M). Only FT NTT faculty have values.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
IPEDS_ETHNICITY_RACE_CODE
|
|
IPEDS reporting code
|
VARCHAR2(1 CHAR)
|
|
|
|
|
IPEDS_ETHNICITY_RACE_CODE_DESC
|
|
IPEDS reporting desc
|
VARCHAR2(255 CHAR)
|
|
|
|
|
IPEDS_PRIMARY_FUNCTION
|
|
Classification of employee function for IPEDS reporting purposes
|
VARCHAR2(63 CHAR)
|
|
|
|
|
IPEDS_PRIMARY_FUNCTION_DESC
|
|
Classification of employee function for IPEDS reporting purposes
|
VARCHAR2(255 CHAR)
|
|
|
|
|
IR_DEGREE_CODE
|
|
highest educational level employee degree
|
VARCHAR2(63 CHAR)
|
|
|
|
|
IR_DEGREE_DESC
|
|
Degree description
|
VARCHAR2(255 CHAR)
|
|
|
|
|
IR_DEGREE_YEAR
|
|
Year degree was earned
|
VARCHAR2(63 CHAR)
|
|
|
|
|
IR_FTPT
|
|
Calculation of FT PT based on position class and standard hours
|
VARCHAR2(63 CHAR)
|
|
|
|
|
JOB_CHANGE_EFFECTIVE_DATE
|
|
Date an Employee_Position became effective in the payroll system.
|
DATE
|
|
|
|
|
JOB_CODE
|
|
Job code
|
VARCHAR2(63 CHAR)
|
|
|
|
|
JOB_DESC
|
|
Job description
|
VARCHAR2(255 CHAR)
|
|
|
|
|
JOB_POSITION_NUMBER
|
|
Position number which is used to tie the employee's assignment to a position defined in the HR system
|
VARCHAR2(63 CHAR)
|
|
|
|
|
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.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
JOB_REPORTS_TO_TITLE
|
|
Title of the posiiton to which this position reports.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
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 CHAR)
|
|
|
|
|
JOB_SUPERVISOR_ID
|
|
NUID of the supervisor
|
VARCHAR2(63 CHAR)
|
|
|
|
|
JOB_SUPERVISOR_NAME
|
|
Combination of the person's first, middle initial, and last name of the supervisor.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
LAST_NAME
|
|
The last name by which a person is known.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
MANAGER_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.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
MANAGER_LEVEL_DESC
|
|
Manager position class description or title.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
MIDDLE_NAME
|
|
A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
NAME_PREFIX
|
|
An appellation used to connote rank, placement or status. A title that precedes person name.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
NAME_SUFFIX
|
|
A name suffix, in the Western naming tradition, follows a person’s full name and provides additional information about the person. There are academic, honorary, professional and inherited (social) name suffixes.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
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.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
NATION_OF_CITIZENSHIP_DESC
|
|
Nation/country of citizenship description for the person.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
NUID
|
|
Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.
|
VARCHAR2(10 CHAR)
|
|
|
|
|
ORG_LEVEL_2_EXEC
|
|
Retrieves level 2 organization within this organization hierarchy.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
ORG_LEVEL_2_EXEC_DESC
|
|
Retrieves description or title level 2 within this organization hierarchy.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
ORG_LEVEL_3_DIV
|
|
Retrieves level 3 organization within this organization hierarchy.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
ORG_LEVEL_3_DIV_DESC
|
|
Retrieves description or title level 3 within this organization hierarchy.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
ORG_LEVEL_5_SCHOOL
|
|
Retrieves level 5 organization within this organization hierarchy.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
ORG_LEVEL_5_SCHOOL_DESC
|
|
Retrieves description or title level 5 within this organization hierarchy.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
ORG_LEVEL_7_DEPT
|
|
Retrieves level 7 organization within this organization hierarchy.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
ORG_LEVEL_7_DEPT_DESC
|
|
Retrieves description or title level 7 within this organization hierarchy.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
ORIGINAL_HIRE_DATE
|
|
Date the employee was first hired.
|
DATE
|
|
|
|
|
PACIFIC_ISLDR_IND
|
|
Pacific Islander Indicator
|
VARCHAR2(1 CHAR)
|
|
|
|
|
PERM_ADDRESS_CITY
|
|
This field maintains the municipality associated with the address of person
|
VARCHAR2(63 CHAR)
|
|
|
|
|
PERM_ADDRESS_COUNTRY_CODE
|
|
This field maintains the nation/country associated with the address of person.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
PERM_ADDRESS_COUNTRY_NAME
|
|
Country code description
|
VARCHAR2(255 CHAR)
|
|
|
|
|
PERM_ADDRESS_STATE
|
|
This field maintains the state, province or territory associated with the address of person.
|
VARCHAR2(10 CHAR)
|
|
|
|
|
PERM_ADDRESS_ZIP
|
|
This field maintains the postal code associated with the address of person
|
VARCHAR2(30 CHAR)
|
|
|
|
|
PERSON_UID
|
|
System generated Banner unique ID which gets assigned to all person and non-person records within Banner
|
NUMBER(8)
|
|
|
|
|
POSITION_BEGIN_DATE
|
|
Employee_Position begin date. The date the job assignment started.
|
DATE
|
|
|
|
|
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).
|
VARCHAR2(63 CHAR)
|
|
|
|
|
POSITION_CHANGE_REASON_DESC
|
|
Employee_Position change reason description.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
POSITION_CLASS
|
|
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.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
POSITION_CLASS_DESC
|
|
Description for position class
|
VARCHAR2(255 CHAR)
|
|
|
|
|
POSITION_CONTRACT_TYPE
|
|
Indicates whether this is the Primary, Secondary, or Overload position
|
VARCHAR2(63 CHAR)
|
|
|
|
|
POSITION_CONTRACT_TYPE_DESC
|
|
Description for the type of employee contract.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
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.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
POSITION_EMPL_CLASS_DESC
|
|
Employee class description.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
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).
|
DATE
|
|
|
|
|
POSITION_STATUS
|
|
Status of the employee position
|
VARCHAR2(63 CHAR)
|
|
|
|
|
POSITION_STATUS_DESC
|
|
Position status description
|
VARCHAR2(255 CHAR)
|
|
|
|
|
POSITION_TITLE
|
|
Employee_Position description. Defaults from the position title if left blank.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
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.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
PRIMARY_DISCIPLINE
|
|
Department in which faculty's tenure is/was approved
|
VARCHAR2(63 CHAR)
|
|
|
|
|
PRIMARY_DISCIPLINE_DESC
|
|
Primary discipline code description
|
VARCHAR2(255 CHAR)
|
|
|
|
|
RANK
|
|
Numeric code that represents academic rank; 21=Professor; 22=Associate; 21=Assistant
|
VARCHAR2(63 CHAR)
|
|
|
|
|
RANK_BEGIN_DATE
|
|
Date when faculty entered current rank
|
DATE
|
|
|
|
|
RANK_DESC
|
|
Rank code description
|
VARCHAR2(63 CHAR)
|
|
|
|
|
REPORTING_CATEGORY
|
|
Standard Occupation Code grouping used for IPEDS report
|
VARCHAR2(63 CHAR)
|
|
|
|
|
RESEARCH
|
|
Flag to identify facutly and staff involved in research
|
VARCHAR2(63 CHAR)
|
|
|
|
|
ROLE_CD
|
|
Business Definition:
Employee classification by the role like Faculty, Staff, SGA, Others.
Business Logic:
If Position Employee Class code is SG (Stipend Grad Assistant) then assign Role code SGA (Stipend Grad Assistant).
If Position Employee Class code is SP (Student Part-Time Lecturer) assign Role code Other.
If Position Employee Class code is one of the following: CP (CPS Part-Time Faculty), FA (Faculty Tenured/Tenure Track), FB (Faculty Non-Tenure Track), or FP (Faculty Part-Time) assign Role code F (Faculty).
If Position Employee Class code is one of the following: A7 (Administrative Professional 7h), A8 (Administrative Professional 8h), CT (Crafts and Trades), PS (Public Safety), PA (Part-Time Admin Professional), O7 (Office Technical Support 7h), O8 (Office Technical Support 8h), or SV (Facilities Service) assign Role code S (Staff).
For all other Position Employee Class codes assign Role code Other.
|
VARCHAR2(10 CHAR)
|
|
|
|
|
SABBATICAL_BEGIN_DATE
|
|
Sabbatical/leave requested from date.
|
DATE
|
|
|
|
|
SABBATICAL_END_DATE
|
Sabbatical_End_Date
|
Sabbatical/leave requested to date
|
DATE
|
|
|
|
|
SABBATICAL_NEXT_DATE
|
|
Sabbatical next eligibility date.
|
DATE
|
|
|
|
|
SABBATICAL_REASON
|
Sabbatical_Reason
|
Sabbatical/leave reason code
|
VARCHAR2(63)
|
|
|
|
|
SABBATICAL_REASON_DESC
|
Sabbatical_Reason_Desc
|
Sabbatical/leave reason description
|
VARCHAR2(255)
|
|
|
|
|
SABBATICAL_TYPE
|
Sabbatical_Type
|
Classifies the type of sabbatical which is being tracked on this leave action
|
VARCHAR2(63)
|
|
|
|
|
SABBATICAL_TYPE_DESC
|
Sabbatical_Type_Desc
|
Sabbatical/leave type description
|
VARCHAR2(255)
|
|
|
|
|
SECOND_NATION_CITIZENSHIP_CODE
|
SECOND NATION CITIZENSHIP CODE
|
A country code for a nationality that a dual citizen maintains, but did not indicate as the primary nation of citizenship in regards to their Home Campus.. Added after 202210 Freeze as part of Global Campus System updates.
|
VARCHAR2(63)
|
|
|
|
|
SECOND_NATION_CITZENSHIP_DESC
|
SECOND NATION CITIZENSHIP DESC
|
Description of SECOND NATION CITIZENSHIP CODE. Added after 202210 Freeze as part of Global Campus System updates.
|
VARCHAR2(255)
|
|
|
|
|
SENIORITY_DATE
|
|
Institution defined date field.
|
DATE
|
|
|
|
|
SERVICE_YEARS
|
|
Calculates the length of service in years for active employees based on the difference between today's date and adjusted service date
|
NUMBER(5,1)
|
|
|
|
|
SPECIAL_DESIGNATION
|
|
Flag to identify chairs, visiting, directors, and research faculty. Based on POSITION_CLASS
|
VARCHAR2(63 CHAR)
|
|
|
|
|
STANDARD_HRS
|
|
The number of hours an employee filling this job normally works in a week; hrs_day multipled by 5
|
NUMBER(7,2)
|
|
|
|
|
STANDARD_WORK_PERIOD
|
Standard_Work_Period
|
Payroll group description or title
|
VARCHAR2(255)
|
|
|
|
|
STD_OCCUPATIONAL_CATEGORY_CODE
|
|
Code defined by federal government to classify workers into one of 23 major groupings.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
STD_OCCUPATIONAL_CATEGORY_DESC
|
|
Code defined by federal government to classify workers into one of 23 major groupings.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
TENURE_EFFECTIVE_DATE
|
|
Date when tenure was granted
|
DATE
|
|
|
|
|
TENURE_REVIEW_DATE
|
|
Tenure review date
|
DATE
|
|
|
|
|
TENURE_TRACKING_BEGIN_DATE
|
|
Date when tenure tracking started
|
DATE
|
|
|
|
|
TERMINAL_APPOINTMENT_IND
|
|
Terminal appointment
|
VARCHAR2(10 CHAR)
|
|
|
|
|
TERMINAL_DEGREE
|
|
Business Definition:
Indicates the faculty member has earned the highest degree available in their discipline.
Business Logic:
If IR_DEGREE_CODE is JD (Juris Doctor) or MD (Doctor of Medicine) or IR_DEGREE_CODE begins with 'P' then assign Terminal Degree Terminal.
If Rank is 91 (Senior Coop Coordinator), 92 (Associate Coop Coordinator), or 93 (Assistant Coop Coordinator) and IR_DEGREE_CODE begins with 'M' then assign Terminal Degree Terminal.
If IR_DEGREE_CODE begins with 'M' and ORG_LEVEL_7_DEPT is 30250 (DMSB Co-op), 33080 (Engineering Co-op), 37050 (BCHS Co-op), 37630 (CCIS Co-op), 70002 (COS Co-op), 70006 (CAMD Co-op), 70010 (CSSH Co-op), or 35900 (Journalism) then assign Terminal Degree Terminal.
If IR_DEGREE_CODE is M04 (Master of Architecture), M11 (Master of Fine Arts), M16 (Master of Music), M19 (Master in Public Administration), or M21 (Master of Studies in Law) then assign Terminal Degree Terminal.
If Role Code is F (Faculty) and IR_DEGREE_CODE is not null then assign Terminal Degree Not Terminal.
For all other IR_DEGREE_CODE assign Terminal Degree null.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
TEST
|
|
DEFINITION2
|
VARCHAR
|
|
|
|
|
TIMESHEET_ORG
|
|
Level 8 org in NBRJOBS. Organization to which the time sheet for this position is sent.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
TIMESHEET_ORG_DESCR
|
|
Organization to which this Employee_Position's time sheet is sent. Description corresponding to the level 8 org in NBRJOBS
|
VARCHAR2(255 CHAR)
|
|
|
|
|
TIME_IN_ASSISTANT_RANK
|
|
Years spent as an Assistant Professor
|
NUMBER(3,1)
|
|
|
|
|
TIME_IN_ASSOCIATE_RANK
|
|
Years as an Associate Professor
|
NUMBER(3,1)
|
|
|
|
|
TIME_IN_PROFESSOR_RANK
|
|
Years as a Full Professor
|
NUMBER(3,1)
|
|
|
|
|
VETERAN_CATEGORY
|
|
Category of veteran. Standardized by the federal government to track attendance of particular groups.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
VETERAN_CATEGORY_DESC
|
Veteran_Category_Desc
|
Person's veteran category description
|
VARCHAR2(63)
|
|
|
|
|
VETERAN_SPECIAL_DISABLED_IND
|
|
Indicates whether the person has been qualified as a disabled veteran.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
VISA_EXPIRE_DATE
|
|
Current date this person's visa expires.
|
DATE
|
|
|
|
|
VISA_ISSUE_DATE
|
|
Most recent date this person's visa was issued
|
DATE
|
|
|
|
|
VISA_ISSUING_NATION
|
|
Nation or country issuing the visa to this person
|
VARCHAR2(63 CHAR)
|
|
|
|
|
VISA_ISSUING_NATION_DESC
|
|
Description of the nation or country that issued the visa.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
VISA_REQ_DATE
|
|
Date the visa was requested by the person.
|
DATE
|
|
|
|
|
VISA_START_DATE
|
|
Current visa initial valid or begin date for this person.
|
DATE
|
|
|
|
|
VISA_TYPE
|
|
Identifies the type of visa issued to this person. May be student, employment, visitor, etc.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
VISA_TYPE_DESC
|
|
Recorded visa type description. For example, a student, a work or spouse visa, etc.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
WHITE_IND
|
|
White race indicator
|
VARCHAR2(1 CHAR)
|
|
|
|