Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_YEAR	ACADEMIC_YEAR	Business Definition Academic year associated with Academic Term, beginning in Summer 2 and ending in Full Summer/Summer 1. Valid Values Sample 2012-13 2013-14	VARCHAR 2 (10)
CITIZENSHIP_REQUIRED_JOB	Coop_Citizenship_Req_Job	Business Definition Indicator if US citizenship is required for job. Valid Values Sample Yes No	VARCHAR2(6)
COOP_ACADEMIC_PERIOD_MATCH		Academic term during which co-op placement begins.
COOP_CONTACT_ID	Coop_Contact_ID	Business Definition Orbis system unique identifier for a contact individual at a company where student is placed. Valid Values Sample 609837 627178	NUMBER(10)
COOP_EMPLOYER_CITY	Coop_Employer_City	Business Definition City of company where student is placed. Valid Values Sample Boston Chicago	VARCHAR2(150)
COOP_EMPLOYER_COUNTRY	Coop_Employer_Country	Business Definition Country of company where student is placed. Valid Values Sample United States China	VARCHAR2(150)
COOP_EMPLOYER_DIVISION_NM	Coop_Employer_Division_Nm	Business Definition Name of division associated to the organization where student is placed. Valid Values Sample Wolf & Company, P.C. Boston Consulting Group
COOP_EMPLOYER_ORGANIZATION_ID	Coop_Employer_Org_ID	Business Definition Orbis system unique identifier for company where student is placed. Valid Values Sample 167949 157026	NUMBER(10)
COOP_EMPLOYER_ORGANIZATION_NM	Coop_Employer_Org_Name	Business Definition Company name of organization where student is placed. Valid Values Sample Wolf & Company, P.C. Boston Consulting Group	VARCHAR2(300)
COOP_EMPLOYER_STATE	Coop_Employer_State	Business Definition State of company where student is placed. Valid Values Sample MA IL	VARCHAR2(6)
COOP_EMPLOYER_ZIPCODE	Coop_Employer_Zipcode	Business Definition Zipcode of company where student is placed. Valid Values Sample 02110 48843	VARCHAR2(60)
COOP_FUNCTION_OF_JOB		General Field of the industry of the co-op job
COOP_INDUSTRY_OF_DIVISION		Specific field of industry of job placement
COOP_INTL_PLACE_CITY		City of job placement for non-US based co-op
COOP_INTL_PLACE_COUNTRY		Country of job placement for non-US based co-op
COOP_JOBPLACEMENT_ID	Coop_JobPlacement_ID	Business Definition Orbis system unique identifier for a co-op placement in a particular job for a particular time. Valid Values Sample 684679 727447	NUMBER(6)
COOP_JOB_CLASSIFICATION_TYPE	Coop_Job_Classification_Type	Business Definition Differentiation between domestic and international job type. Valid Values Sample Coop (US Domestic) Coop (Global)	VARCHAR2(45)
COOP_JOB_FINISH_DT	Coop_Job_Finish_Date	Business Definition Indicates the end date for the co-op assignment. Prior to academic year 2013, may contain value of "1/1/2004" which are assumed to be standard end date. Fall 2017 placements and forward will have data populated.	DATE
COOP_JOB_ID		Unique identifier for job (title) a student is placed in.
COOP_JOB_MANAGER		Name of direct manager on student's co-op
COOP_JOB_OWNER_COLLEGE_CODE	Coop_Job_Owner_College_cd	Business Definition College code of the Co-op coordinator who is the primary owner for the job placement. Valid Values Sample BA AM	VARCHAR2(6)
COOP_JOB_OWNER_ID	Coop_Job_Owner_ID	Business Definition NUID of the Co-op coordinator who is the primary owner for the job placement. Valid Values Sample 000144107 000144100	VARCHAR2(60)
COOP_JOB_START_DT	Coop_Job_Start_Date	Business Definition Indicates the start date for the co-op assignment. Prior to academic year 2013, may contain value of "1/1/2004" which are assumed to be standard start date. Fall 2017 placements and forward will have data populated.	DATE
COOP_JOB_TITLE	Coop_Job_Title	Business Definition Job title of the co-op placement. Valid Values Sample Tax Intern Office Assistant	VARCHAR2(150)
COOP_PLACED_YEAR	Coop_Placement_Year	Business Definition Calendar year that a student's co-op placement takes place. Valid Values Sample 2013 2014	VARCHAR2(10)
COOP_PLACEMENT_LAST_UPDATED	Record_Update_Date	Business Definition Date of last change made on placement record. Valid Values Sample 11/1/2012 15:21 2/6/2014 12:29	DATE
COOP_PLACEMENT_TERM_NUMBER	Coop_Placement_Term_Order	Business Definition Chronological position in the order of the sequence of co-ops done by a student. (1 = first coop, 2 = second, etc.) Concurrent and split placements are aggregated and will appear with a single order number. Valid Values Sample 1 2 3 4+
COOP_PLACEMENT_TYPE	Coop_Placement_Type	Business Definition Indicator of whether co-op placement was in an assignment which is Employer based (traditional co-op employment) or Experiential (independent study, volunteer).	VARCHAR2(75)
COOP_REGIONAL_LOCATION_JOB		General region area of Coop job, used primarily to aid students when browsing job listings.
COOP_SNAPSHOT_DT		Business Definition Date of nightly extract from Nucareers. Valid Values Sample 3/7/2017 10:40	DATE
COOP_STUDENT_CLAIMED_STATUS	Coop_Stud_Claimed_Status	Business Definition Indicator of whether a co-op coordinator has assigned him/herself to the student in the Orbis system, and by extension, in the Banner system. Valid Values Sample Yes No	VARCHAR2(9)
COOP_STUDENT_GRAD_STATUS		Business Definition Current student level classification indicating whether the student is an Undergraduate (UG) or a Graduate (GR) student. Valid Values Sample UG GR	VARCHAR2(6)
COOP_STUDENT_MANAGER
COOP_STUDENT_PLACED_TERM_COUNT		Business Definition Total number of discrete placement periods done by the student as of latest data extraction (weekly). Concurrent and split placements are aggregated and will appear in a single count. Valid Values Sample
COOP_STUDENT_PRIMARY_OWNER_ID	Coop_Stud_Primary_Owner_ID	Business Definition NUID for a student's assigned primary co-op coordinator. Valid Values Sample 000144107 001074396	VARCHAR2(60)
COOP_STUD_DEVELOP_TYPE	Coop_Stud_Develop_Type	Business Definition Indicator of whether co-op placement is associated to a job which was developed by co-op coordinator or student. Valid Values Sample Coordinator Developed Student Developed	VARCHAR2(75)
COOP_STUD_PLACED_DT	Coop_Stud_Placed_Date	Business Definition Date and time when a placement of student was recorded in the Orbis system. Valid Values Sample 2013 - Spring 11/1/2012 15:21 2/6/2014 12:29	DATE
COOP_STUD_PLACED_PERIOD_DESC	Coop_Stud_Placed_Period_Desc	Business Definition Description of term of co-op placement. Valid Values Sample Fall Spring	VARCHAR2(255)
COOP_STUD_TERM_LENGTH	Coop_Stud_Term_Length	Business Definition Designated co-op placement term length. Valid Values Sample 6 Month 4 Month	VARCHAR2(300)
COOP_STUD_WAGE	Coop_Stud_Wage	Business Definition Student's monetary compensation for co-op employment. Valid Values Sample 20 13.50	NUMBER(19,4)
COOP_WAGE_TYPE_DESC		Description of system code which identifies frequency of wage payment.
COOP_WORK_CITY		City of job placement for co-op
COOP_WORK_COUNTRY		Country of job placement for co-op
COOP_WORK_STATE		Co-op State location for US-based co-op
COOP_WORK_TERM_CD	Coop_Work_Term_cd	Business Definition Code which indicates the beginning co-op placement year and term. Valid Values Sample 2013 - Spring 2013 - Fall 2014 - Spring	VARCHAR2(90)
DIVISION_DUNS		DUNS number for business co-op business entity. The Data Universal Numbering System (DUNS) is a proprietary system developed and managed by Dun & Bradstreet that assigns a unique numeric identifier to each participating business entity.
FREEZE_COLLEGE	Student_College	Business Definition Student College at time of placement. Valid Values Sample College of Professional Studies D'Amore-McKim College of Business	VARCHAR2(150)
NUID	NUID	Business Definition Identification number assigned to a person that is used externally for all communication and correspondence with the person. Valid Values Sample 000593191 000067673	VARCHAR2(10)
REGIONAL_CLASSIFICATION_JOB	Coop_Regional_Class_Job	Business Definition Geographic area classification of region associated with the job. Valid Values Sample Domestic (In State) Domestic (Out of State) Global
STUDENT_COLLEGE		This field identifies the college associated with the student's primary curriculum for the effective term.
STUDENT_COLLEGE_DESC		Description for STUDENT_COLLEGE
STUDENT_LEVEL		This field identifies the level of the student for the effective term as one of CP(Continuing Education CPS), UP(CPS - Undergraduate), GP(CPS - Graduate), UG(Undergraduate Day), GR(Graduate Day), LW(Law), US(Undergraduate Specialty Programs), GS(Graduate Specialty Programs)
STUDENT_LEVEL_DESC		Description for STUDENT_LEVEL
STUDENT_MAJOR		This field identifies the primary major within the primary curriculum for the effective term.
STUDENT_MAJOR_DESC		Description for STUDENT_MAJOR
STUDENT_PROGRAM		The combination of student level, course level, college and degree. Tied to (via curriculum rules) majors, minors, and concentrations.
STUDENT_PROGRAM_DESC		Description for STUDENT_PROGRAM
TRANSPORTATION_REQUIREMENT	Coop_Trans_Req_Job	Business Definition Indicator if transportation is required for job. Older records may contain null values. Valid Values Sample Car required for commute Car required for job function Carpool available (multi-select field, optional)	VARCHAR2(6)

Ver: 9.0