The Massachusetts School to Career Connecting Activities Initiative

 


DATABASE FIELD LIST

The following tables show a list of the database fields from key tables in the Massachusetts Career Ready Database. This list may be helpful for understanding what information should be gathered and entered into the database as well as for knowing the field names for technical purposes such as writing reports, and other technical work.


WBL1 (Placement Screen) table
Name of Field Type Description Comments
PlanID Text Automatic number Required
ParticipantName Text Participant name -- recommended format is: Lastname, Firstname Required
ParticipantEmail Text Is also the username Needed for database sharing
ParticipantShare Text Read Only, Read/Write, No Access  
SupervisorName Text    
SupervisorEmail Text Is also the username Needed for database sharing
SupervisorShare Text Read Only, Read/Write, No Access  
StaffName Text    
StaffEmail Text Is also the username Needed for database sharing [Is actually currently stored in another table]
StaffShare Text Read Only, Read/Write, No Access  
TeacherName Text    
TeacherEmail Text Is also the username Needed for database sharing [Is actually currently stored in another table]
TeacherShare Text Read Only, Read/Write, No Access  
EmplID Text Employer ID Required
EmplName Text Employer Name Required
IndustryCluster Text [ ] Arts, Media And Communications
[ ] Arts, Media And Communications
[ ] Business
[ ] Child Care / Camp Counselor
[ ] Construction And Design
[ ] Education
[ ] Environment, Natural Resources And Agriculture
[ ] Health Care
[ ] Hospitality, Tourism And Recreation
[ ] Human Services
[ ] Information Technology
[ ] Law, Government And Public Service
[ ] Maintenance / Landscaping
[ ] Manufacturing, Science, Technology, Engineering And Math
[ ] Marine Industries
[ ] Office Support / Clerical
[ ] Retail And Services
[ ] Transportation
 
JobTitle Text Job Title for the participant.� It is important that your region/organization develop guidelines for using this field consistently.� This field can be used in reports, and therefore it is useful to be somewhat descriptive, such as "Teacher Aide" rather than "Aide" and "Database Development Intern" rather than "Intern."� It is important that your region/organization develop guidelines for using this field consistently.  
SchoolProgram Text Name of the participant's school, or, if not in school, a program name if applicable.� School names may be typed or selected from a dropdown list.  
SchoolCode Text The 8-digit school code. This is filled in automatically when you choose the school from the dropdown list. For private schools, alternative schools or other schools not on the dropdown list, we can add a school code and/or use all zeroes - 00000000.  
StartMM Text The placement start date and end date are entered through a dropdown list. StartMM is the start month, and is 2 digits, such as �01�, �02�, �03�, etc., or �0� if missing Required
StartDD Text StartD is the start day, and is 2 digits, such as �01�, �02�, �03�, etc., or �0� if missing Required
StartYY Text StartYY is the start year, and is 4 digits, such as �2010� or �0� if missing Required
EndMM Text The placement start date and end date are entered through a dropdown list. EndMM is the end month, and is 2 digits, such as �01�, �02�, �03�, etc., or �0� if missing Required  
EndDD Text EndDD is the end day, and is 2 digits, such as �01�, �02�, �03�, etc., or �0� if missing Required
EndYY Text EndYY is the end year, and is 4 digits, such as �2010� or �0� if missing Required
ReviewDate1 Date Date of first review, such as 7/10/2009. This is entered automatically with the current date when you fill in any of the fields for the first review, but may also be typed in. Required
ReviewDateFinal Date Date of second review, such as 8/28/2009. This is entered automatically with the current date when you fill in any of the fields for the first review, but may also be typed in. Required
CareerArea Text Career area for the participant and/or placement. This may be based on a career pathway or program (a health careers pathway or carpentry vocational program) or may be based on the general career area of the placement (such as business, health, arts, etc.) This is an open-ended field that allows users to type or choose from a dropdown. It is recommended that regions/programs develop their own guidelines for using this field consistently. Important
Region Text Region - entered automatically based on the region of the person entering the data. Region is selected when you sign up for a username/password. Automatic
Programca Text Lower case x for yes. Dash (-) or blank for no Checkbox � Is Connecting Activities
Programyw Text Lower case x for yes. Dash (-) or blank for no Checkbox � Is YouthWorks
Programwiayouth Text Lower case x for yes. Dash (-) or blank for no Checkbox � Is WIA Youth
ProgramCoop Text Lower case x for yes. Dash (-) or blank for no Checkbox � Is CVTE Cooperative Education
Program597 Text Lower case x for yes. Dash (-) or blank for no Checkbox � Is Academic Support Fundcode 596-597
Program593 Text Lower case x for yes. Dash (-) or blank for no Checkbox � Is Academic Support Fundcode 596
Program626 Text Lower case x for yes. Dash (-) or blank for no Checkbox � Is Academic Support Fundcode 626
ProgramWIAAdult Text Lower case x for yes. Dash (-) or blank for no Checkbox � Is WIA Adult
ProgramDYSbridging Text Lower case x for yes. Dash (-) or blank for no Checkbox � Is DYS Bridging Program
programother Text Lower case x for yes. Dash (-) or blank for no Checkbox � Is another program (specify in programnameother)
programnameother Text Fill in the blank (could be dropdown) Name of other program
JobDescription Text Job Description - Unlimited length This is part of the WBLP
Comment1 Text Comment from First Review - Unlimited length This is part of the WBLP
CommentFinal Text Comment from Second Review -- Unlimited length This is part of the WBLP
NameActivity Text Name of the activity or program. Your organization may have several different summer and year-round job and internship programs or may have a single program. It is important that your region/organization develop guidelines for using this field consistently. Important
ParticipantID Text Participant ID. May be typed in or automatically assigned. Required. Note: If a participant has more than one placement in the database, it is important that you use the same participant ID. The placement screen has a button that allows you to check for previous entries.
BirthDate Date Date of birth - important both for matching records with other databases and for determining age of particpant. YouthWorks
Gender Text M or F YouthWorks
Race Text American Indian or Alaska Native; Asian; Black/African American; Cape Verdean; Hispanic Origin; Multi-race; Native Hawaiian or Other Pacific Islander; White/Caucasian; Other YouthWorks
Gradyear Text Four-digit year of high school graduation (or "class of ") Required
CityOfResidence Text City of residence for participant (A YouthWorks required field) YouthWorks
ParticipantZipCode Text Zipcode for participant (A YouthWorks required field) YouthWorks
ParentName Text Parent name - optional  
ParentPhone Text Parent phone number - optional - this is an open ended field in which you can enter one or more phone numbers as well as other information.  
SupervisorPhone Text Supervisor phone number  
SupervisorTitle Text Supervisor job title  
Risk1 Text YOUTHWORKS RISK FACTORS.  Risk1 = Homeless Youth / NOTE: Risk factor fields use a lower case x for yes and dash (-) or blank for no YouthWorks
Risk2 Text Risk2=Foster Youth YouthWorks
Risk3 Text Risk3=Poor academics - either MCAS Level 1 or 2 OR at least one year behind grade level in credits YouthWorks
Risk4 Text Risk4=Child of a single working parent YouthWorks
Risk5 Text Risk5=Limited English Skills YouthWorks
Risk6 Text Risk6=Teen Parent YouthWorks
Risk7 Text Risk7=Juvenile arrest, Court-involved, gang-involved, probation, CHINS YouthWorks
Risk8 Text Has a disability or is a special needs student with an IEP YouthWorks
Risk9 Text Risk9=Former Foster Youth who has aged out YouthWorks
Risk10 Text Risk10 = DYS-Committed YouthWorks
Risk0 Text No Barriers  
Risk11_DCF Text Risk11_DCF=CRA (formerly called CHIN) or DCF involved  
LowInc Text Low Income // for YouthWorks eligibiity or other reports or tracking YouthWorks
ParticipantPhone Text As entered (no special formatting)  
SchoolEnrolled Text Lower case x for yes and dash (-) or blank for no YouthWorks Checkboxes for school enrollment. You may check more than one.�Required for YouthWorks; Recommended for other programs
SchoolNotEnrolled Text Lower case x for yes and dash (-) or blank for no same
SchoolSecondary Text Lower case x for yes and dash (-) or blank for no same
SchoolPostsecondary Text Lower case x for yes and dash (-) or blank for no same
SchoolPostsecondarydegree Text Lower case x for yes and dash (-) or blank for no same
SchoolPostsecondarycertificate Text Lower case x for yes and dash (-) or blank for no same
SchoolGED Text Lower case x for yes and dash (-) or blank for no same
SchoolAlternative Text Lower case x for yes and dash (-) or blank for no same
SchoolDYS Text Lower case x for yes and dash (-) or blank for no same
SchoolReenrolled Text Lower case x for yes and dash (-) or blank for no same
SchoolEnrollmentComment Text Lower case x for yes and dash (-) or blank for no same
HighestGrade Text Choose from dropdown same
HourlyPay Number Such as 8.00 Required
HoursPerWeek Number Such as 25 Required
TypeOfPay Text Paid, Unpaid, Sponsored Required
HasWBLP Text Yes in Database, Yes � Pen and Paper, Yes � Microsoft Word, No, Pending Required
HasElementG Text Yes - College and Career Plan, Yes - Other, No, Unknown Required for Connecting Activitites

HasElementGOther

Has ElemntROther

Has ElementOOther

Text

Text

Text

Any comments about Element G

Any comments about Element R

Any comments about Element O

Optional
HasElementR Text Yes, No, Unknown Required for Connecting Activitites
HasElementO Text Has Workshop or Classroom Component Required for Connecting Activitites
ProgramCity Text What city is the program for? (A YouthWorks required field) YouthWorks
Vendor Text What organization is the vendor for this program? (A YouthWorks required field) YouthWorks
YWGrant Text Is this a summer or year-round program? (A YouthWorks required field) YouthWorks
Organization Text Name of your organization. Required for YouthWorks and recommended for other programs because it is a useful field for searching and reporting from the database.� (That is - running reports for all placements where organization equals .) Required for YouthWorks, recommended for other programs
RecordID Text This field is included in order to facilitate importing data. It can be the record id from another database. It can be used in the import process to check to see if the record has previously been imported. Not used except for importing data
PayrollProvider Text What organization is the payroll provider (for subsidized or sponsored jobs)? (A YouthWorks required field) YouthWorks
Username Text (Username) Automatic � the username (email address) for the person who first entered the data Automatic
CreatedBy Text (Username) Automatic � the username (email address) for the person who first entered the data. Same as username field; but may be useful if the username field is ever edited, such as if an email address/username changes. Automatic
ModifiedBy Text (Username) Automatic � the username (email address) for the person who most recently modified the data Automatic
CreatedDate Date Date that the record was first created  
UseInBank Text Should the system display the job description and skills/tasks from this placement in the bank of job descriptions and skills/tasks? Lower case x for yes and dash or blank for no  
EMPLOYERS table
Name of Field Type Description Comments
NameOfEmployer Text

Name of employer...

If there are multiple locations for the employer, it is useful to specify a location or number in the Employer Name field, such as �Starbucks/Pleasant St. Mill Valley� or �Stop and Shop #49�.

Required
EmplID Text Automatically generated � an ID for the employer Required
Region Text What region � is entered automatically based on the region of the username, which is selected when you register or when you modify your account. Required
EmplAddress Text Employer address � important for distinguishing similar employers  
EmplCity Text Employer City  
EmplState Text Employer State � use two letters such as MA  
EmplZip Text Employer zip code  
EmplSize Text Small (under 50 employees); Medium (50 to 499 employees); Large (500 or more employees) Optional
EmplType Text Public; Private; Nonprofit Required
EmployerIndustryCluster Text This field is not fully developed yet. It is currently the same as industry cluster list in the participant record � but may, in the future, refer to the employer type rather than placement type.  
Username Text Username of person who most recently entered a placement using this record Automatic
AccountRep Text There will probably be an �account rep� field for the employer record in the future  
USERNAMES table
YourName Text Full Name  
Username Text Email address  
pword Text Password  
accounttype Text Staff or Intern or Employer  
share1 Text Email address of person with whom you want to share all data  
share2 Text Email address of person with whom you want to share all data  
share3 Text Email address of person with whom you want to share all data  
yourname Text Full name of person  
region Text Choose from dropdown list  
activedate Text Indicates what records the person wants to view � including ANY or records since 7/1/2009 or records since 9/1/2009  
WBLReviews Table
Name of Field Type Description Comments
PlanID Text Matches to WBL1 table The WBLReviews table has one record per skill (including the 8 foundation skills and up to 7 workplace and career specific skills) and matches to the placement record in the table WBL1.
WhatSection Text 1 or 2 (1=Foundation Skills and 2=Career and Workplace Specific Skills)  
SkillNumber Text 1.1 through 1.8 for foundation skills and 2.1 through 2.7 for career and workplace specific skills  
WhatSkill Text This field is blank for foundation skills (these are always the same) and this field contains the specific skill name for the Career and Workplace Specific skills  
SkillTaskDescription Text Description of the skill � limit 255 characters  
Review1 Number Rating 1 to 5 at first review  
ReviewFinal Number Rating 1 to 5 at second or final review  
Goals Text Goals � this field may be updated during both the first and second review  
Username Text Email address  
CreatedDate Date Automatically entered  
ACTIVITES table
ActivityId Number Automatic Numbering  
NameActivity Text Name of Activity  
ActivityDate Date Date (or start date) of Activity in mm/dd/yyyy format  
ActivityDescription Memo Brief description
StaffContactName Text  
StaffContactEmail Text  
OKToShare Text 1=Yes; 2=Yes; 3=No (1=Yes includes staff name and email)
Region Text  
WhatSchool Text  
SchoolCode Text 8-Digit ESE School Code
WhatOrganization Text  
ACTIVITY TYPE CHECKLIST (SEE BELOW)   See list below. �All fields filled with x or - or blank
forgradek8 Text Filled with x or - or blank
forgrade09 Text Filled with x or - or blank
forgrade10 Text Filled with x or - or blank
forgrade11 Text Filled with x or - or blank
forgrade12 Text Filled with x or - or blank
IsOtherType Text Part of the checklist - filled with x or - or blank
OtherSpecify Text Part of the checklist - fill-in with other type of activity
AllStudents Number Number of participating students (if not listed individually in placement screen)
     
Employers Number Number of participating employers (please also list in the form at the bottom of the Activity Screen)
Teachers Number Number of participating teachers/staff (for professional activites
MonetarySupport Text Number (dollar amount) of monetary support (optional field)
InkindSupport Text Number (dollar amount) of inkind support (optional field)
ContributionsDescription Text  
IsConnectingActivities Text Yes or No
SpecifyOtherProgram Text If not Connecting Activities, what program sponsored this
Username Text  
CreatedDate Date Date and Time Stamp (yyyy-mm-dd hh:mm:ss)
ModifiedDate Date Date

DETAILS - ACTIVITY TYPES CHECKLIST

ActivityType NameOfField Category ActivityComment
Career Interest Assessments iscareerinventory Career Awareness  
Career Day / Career Fair iscareerday Career Awareness  
Career Speakers iscareerspeaker Career Awareness  
College and Career Plans ~ Print isccpprint Career Awareness (Starting or updating a four-year "College and Career Plan" paper/print version)
College and Career Plans ~ Online isccponline Career Awareness (Starting or updating an individualized college and career plan on computer, using a program such as YourPlanForCollege, Career Cruising, Naviance or other software)
Company Tours / Field Trips isfieldtrip Career Awareness  
Labor Market Information islabormarketinfo Career Awareness  
Family Events isfamilyevent Career Awareness Career Awareness for Students and Families
Middle School Events ismiddleschoolevent Career Awareness Career Awareness / Career Planning / High School Choices
Career Exploration Class isclass Career Exploration  
Career Exploration Class - Online isclassonline Career Exploration  
Workshop / Presentation isworkshop Career Exploration  
Individual Guidance / Counseling isindividual Career Exploration  
Community Service / Service Learning isservice Career Exploration  
Contextual Learning Coursework iscontextuallearning Career Exploration  
Informational Interviews isinformationalinterview Career Exploration  
Job Shadows isjobshadow Career Exploration  
Workshop Topics: Financial / Economic Literacy isfinancial Career Exploration  
Workshop Topics: Interviewing, Job Search, Resumes isjobsearch Career Exploration  
Workshop Topics: Work Readiness isworkreadiness Career Exploration  
Capstone Project / Senior Project isproject Career Immersion  
Career Clubs iscareerclubs Career Immersion  
Career-Focused Elective Courses iselective Career Immersion (Engineering, Childcare, Business, Computer Technology, etc.)
Entrepreneurship Program isentrepreneurship Career Immersion  
Mentorship Program ismentorship Career Immersion  
Skills Portfolios isportfolio Career Immersion  
Outreach / Media / Publicity isoutreachmedia Program Development / Teacher and Staff Development (such as press releases, presentation to business groups, media outreach)
Professional Development for teachers, employers, community isprofdev Program Development / Teacher and Staff Development  
Teacher Externship isexternship Program Development / Teacher and Staff Development  
College Fairs iscollegefair Other Events  
Job Fair isjobfair Other Events  
Staff Meetings / Community Meetings / Community Connections isstaffcommunityconnections Program Development / Teacher and Staff Development  
Work-Based Learning iswbl Career Immersion  

EMPLOYER PARTICIPATION
RecordID Number Automatic Number
EmplID Text Links to EmplID Employer table
ParticipationDate Date In yyyy-mm-dd format
ActivityID Number Links to ActivityID in Activity table
SchoolCode Text 8-digit ESE School Code (optional if applicable to activity)
EnteredBy Text Username
EnteredDate Date  
ModifiedBy Text Username
ModifiedDate Date  
Region Text  
1 - INTRODUCTION TO THE DATABASE - VIDEO
1a - Key Points About the Database
1b - REGISTERING AND SIGNING IN - VIDEO
1c - Navigating the Database Screens
2 - USING THE PLACEMENT SCREEN - VIDEO
2a -Classifying Placements - Activity Name, Program Checkboxes, Job Title, etc.
2b. Classifying and Defining STEM Placements
2c - Placement and WBLP Screen - Sharing via Email/Username
2d - Participants with more than one work experience
2d - Worksites with multiple participants - Using the COPY WBLP button
2e - Placement Screen - Required and Optional Fields
2g - Work and Learning Program Elements (Preview of FY19 elements)
2h - Career Areas
2z - Deleting Placement Screen Records
3 - USING THE JOB DESCRIPTION AND SKILLS/TASKS SCREENS - VIDEO
4 - USING THE PERFORMANCE REVIEW SCREEN - VIDEO
5 - ACTIVITY SCREEN - VIDEO
6 - Reflection Screen
7 - Importing
8 - REPORTS MENU AND EMPLOYER SCREENS - POWERPOINT PRESENTATION
8a - About the Reports/Admin Menu
8b - Connecting Activities Quarterly Report
8c - Connecting Activities Qualifying Wages Report
8d - Custom Reports
8e - Employer Screens
9 - Sharing, Collaboration and Privacy
9a - UPDATING MY ACCOUNT SETTINGS - VIDEO
9b - Add | Invite New Usernames
9c - Using the "One-Step WBLP Review Screen" for Supervisors
9d: Instructions for students to create their WBLPs online
DATABASE FIELD LIST
What's New in the Database
Winter/Spring 2019 Webinar Series