| 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 |
|