S_SC_STU_WBL_X (ver 15.7.3)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| StudentsDCID | 15.7.3 | Number(10,0) | The foreign key that links this record to the Students table. |
| WBL_Add1 | 15.7.3 | Varchar2(50) | The street address of the work-based learning location. Migrated from [Students.SC_WBL_Add1]. |
| WBL_Add2 | 15.7.3 | Varchar2(50) | The street address of the work-based learning location. Migrated from [Students.SC_WBL_Add2]. |
| WBL_Add3 | 15.7.3 | Varchar2(50) | The street address of the work-based learning location. Migrated from [Students.SC_WBL_Add3]. |
| WBL_Add4 | 15.7.3 | Varchar2(50) | The street address of the work-based learning location. Migrated from [Students.SC_WBL_Add4]. |
| WBL_Add5 | 15.7.3 | Varchar2(50) | The street address of the work-based learning location. |
| WBL_AddCCR | 18.4.0 | Varchar2(50) | WBL CCR Worksite Address |
| WBL_Agreement1 | 18.4.0 | Varchar2(1) | WBL Training Agreement 1 |
| WBL_Agreement2 | 18.4.0 | Varchar2(1) | WBL Training Agreement 2 |
| WBL_Agreement3 | 18.4.0 | Varchar2(1) | WBL Training Agreement 3 |
| WBL_Agreement4 | 18.4.0 | Varchar2(1) | WBL Training Agreement 4 |
| WBL_Agreement5 | 18.4.0 | Varchar2(1) | WBL Training Agreement 5 |
| WBL_AgreementCCR | 18.4.0 | Varchar2(1) | WBL CCR Training Agreement |
| WBL_CarCod1 | 15.7.3 | Varchar2(2) | Identifies a career assessment test administered to this student. Migrated from [Students.SC_WBL_CarAssessCode1]. |
| WBL_CarCod2 | 15.7.3 | Varchar2(2) | Identifies a career assessment test administered to this student. Migrated from [Students.SC_WBL_CarAssessCode2]. |
| WBL_CarCod3 | 15.7.3 | Varchar2(2) | Identifies a career assessment test administered to this student. Migrated from [Students.SC_WBL_CarAssessCode3]. |
| WBL_CarCod4 | 15.7.3 | Varchar2(2) | Identifies a career assessment test administered to this student. |
| WBL_CarCod5 | 15.7.3 | Varchar2(2) | Identifies a career assessment test administered to this student. |
| WBL_CarCod6 | 15.7.3 | Varchar2(2) | Identifies a career assessment test administered to this student. |
| WBL_City1 | 15.7.3 | Varchar2(20) | The city of the work-based learning location. Migrated from [Students.SC_WBL_City1]. |
| WBL_City2 | 15.7.3 | Varchar2(20) | The city of the work-based learning location. Migrated from [Students.SC_WBL_City2]. |
| WBL_City3 | 15.7.3 | Varchar2(20) | The city of the work-based learning location. Migrated from [Students.SC_WBL_City3]. |
| WBL_City4 | 15.7.3 | Varchar2(20) | The city of the work-based learning location. Migrated from [Students.SC_WBL_City4]. |
| WBL_City5 | 15.7.3 | Varchar2(20) | The city of the work-based learning location. |
| WBL_CityCCR | 18.4.0 | Varchar2(20) | WBL CCR Worksite City |
| WBL_Coordinator1 | 15.7.3 | Varchar2(25) | The name of the work-based learning experience coordinator. Migrated from [Students.SC_WBL_Coordinator1]. |
| WBL_Coordinator2 | 15.7.3 | Varchar2(25) | The name of the work-based learning experience coordinator. Migrated from [Students.SC_WBL_Coordinator2]. |
| WBL_Coordinator3 | 15.7.3 | Varchar2(25) | The name of the work-based learning experience coordinator. Migrated from [Students.SC_WBL_Coordinator3]. |
| WBL_Coordinator4 | 15.7.3 | Varchar2(25) | The name of the work-based learning experience coordinator. Migrated from [Students.SC_WBL_Coordinator4]. |
| WBL_Coordinator5 | 15.7.3 | Varchar2(25) | The name of the work-based learning experience coordinator. |
| WBL_CoordinatorCCR | 18.4.0 | Varchar2(25) | WBL CCR School/Center Coordinator |
| WBL_CreditInd1 | 15.7.3 | Varchar2(1) | Indicates if the student received academic credit for participating in this work-based learning experience. Migrated from [Students.SC_WBL_CreditInd1]. |
| WBL_CreditInd2 | 15.7.3 | Varchar2(1) | Indicates if the student received academic credit for participating in this work-based learning experience. Migrated from [Students.SC_WBL_CreditInd2]. |
| WBL_CreditInd3 | 15.7.3 | Varchar2(1) | Indicates if the student received academic credit for participating in this work-based learning experience. Migrated from [Students.SC_WBL_CreditInd3]. |
| WBL_CreditInd4 | 15.7.3 | Varchar2(1) | Indicates if the student received academic credit for participating in this work-based learning experience. Migrated from [Students.SC_WBL_CreditInd4]. |
| WBL_CreditInd5 | 15.7.3 | Varchar2(1) | Indicates if the student received academic credit for participating in this work-based learning experience. |
| WBL_CreditIndCCR | 18.4.0 | Varchar2(1) | WBL CCR Course Credit |
| WBL_Email1 | 15.7.3 | Varchar2(75) | The email address of the student's employer. Migrated from [Students.SC_WBL_Email1]. |
| WBL_Email2 | 15.7.3 | Varchar2(75) | The email address of the student's employer. Migrated from [Students.SC_WBL_Email2]. |
| WBL_Email3 | 15.7.3 | Varchar2(75) | The email address of the student's employer. Migrated from [Students.SC_WBL_Email3]. |
| WBL_Email4 | 15.7.3 | Varchar2(75) | The email address of the student's employer. Migrated from [Students.SC_WBL_Email4]. |
| WBL_Email5 | 15.7.3 | Varchar2(75) | The email address of the student's employer. |
| WBL_EmailCCR | 18.4.0 | Varchar2(75) | WBL CCR Worksite Email Address |
| WBL_EmpName1 | 15.7.3 | Varchar2(35) | Identifies the name of the student's first employer. Migrated from [Students.SC_WBL_EmpName1]. |
| WBL_EmpName2 | 15.7.3 | Varchar2(35) | Identifies the name of the student's second employer. Migrated from [Students.SC_WBL_EmpName2]. |
| WBL_EmpName3 | 15.7.3 | Varchar2(35) | Identifies the name of the student's third employer. Migrated from [Students.SC_WBL_EmpName3]. |
| WBL_EmpName4 | 15.7.3 | Varchar2(35) | Identifies the name of the student's fourth employer. Migrated from [Students.SC_WBL_EmpName4]. |
| WBL_EmpName5 | 15.7.3 | Varchar2(35) | Identifies the name of the student's fourth employer. |
| WBL_EmpNameCCR | 18.4.0 | Varchar2(35) | WBL CCR Worksite Name |
| WBL_EmpPhone1 | 15.7.3 | Varchar2(25) | Identifies the phone number of the student's first employer. Migrated from [Students.SC_WBL_EmpPhone1]. |
| WBL_EmpPhone2 | 15.7.3 | Varchar2(25) | Identifies the phone number of the student's second employer. Migrated from [Students.SC_WBL_EmpPhone2]. |
| WBL_EmpPhone3 | 15.7.3 | Varchar2(25) | Identifies the phone number of the student's third employer. Migrated from [Students.SC_WBL_EmpPhone3]. |
| WBL_EmpPhone4 | 15.7.3 | Varchar2(25) | Identifies the phone number of the student's fourth employer. Migrated from [Students.SC_WBL_EmpPhone4]. |
| WBL_EmpPhone5 | 15.7.3 | Varchar2(25) | Identifies the phone number of the student's fifth employer. |
| WBL_EmpPhoneCCR | 18.4.0 | Varchar2(25) | WBL CCR Worksite Phone |
| WBL_EmpSize1 | 15.7.3 | Varchar2(1) | Identifies the size of the employer's company. Migrated from [Students.SC_WBL_EmpSize1]. |
| WBL_EmpSize2 | 15.7.3 | Varchar2(1) | Identifies the size of the employer's company. Migrated from [Students.SC_WBL_EmpSize2]. |
| WBL_EmpSize3 | 15.7.3 | Varchar2(1) | Identifies the size of the employer's company. Migrated from [Students.SC_WBL_EmpSize3]. |
| WBL_EmpSize4 | 15.7.3 | Varchar2(1) | Identifies the size of the employer's company. Migrated from [Students.SC_WBL_EmpSize4]. |
| WBL_EmpSize5 | 15.7.3 | Varchar2(1) | Identifies the size of the employer's company. |
| WBL_EmpSizeCCR | 18.4.0 | Varchar2(1) | WBL CCR Worksite Size |
| WBL_EndDate1 | 15.7.3 | Date | Identifies the date the first work-based experience ended. Migrated from [Students.SC_WBL_EndDate1]. |
| WBL_EndDate2 | 15.7.3 | Date | Identifies the date the second work-based experience ended. Migrated from [Students.SC_WBL_EndDate2]. |
| WBL_EndDate3 | 15.7.3 | Date | Identifies the date the third work-based experience ended. Migrated from [Students.SC_WBL_EndDate3]. |
| WBL_EndDate4 | 15.7.3 | Date | Identifies the date the fourth work-based experience ended. Migrated from [Students.SC_WBL_EndDate4]. |
| WBL_EndDate5 | 15.7.3 | Date | Identifies the date the fourth work-based experience ended. |
| WBL_EndDateCCR | 18.4.0 | Date | WBL CCR End Date |
| WBL_EvalScore1 | 18.4.0 | Varchar2(1) | WBL Evaluation Score 1 |
| WBL_EvalScore2 | 18.4.0 | Varchar2(1) | WBL Evaluation Score 2 |
| WBL_EvalScore3 | 18.4.0 | Varchar2(1) | WBL Evaluation Score 3 |
| WBL_EvalScore4 | 18.4.0 | Varchar2(1) | WBL Evaluation Score 5 |
| WBL_EvalScore5 | 18.4.0 | Varchar2(1) | WBL Evaluation Score 5 |
| WBL_EvalScoreCCR | 18.4.0 | Varchar2(1) | WBL CCR Evaluation Score |
| WBL_ExpCode1 | 15.7.3 | Varchar2(1) | Identifies the first work-based learning experience in which this student participated. Migrated from [Students.SC_WBL_ExpCode1]. |
| WBL_ExpCode2 | 15.7.3 | Varchar2(1) | Identifies the second work-based learning experience in which this student participated. Migrated from [Students.SC_WBL_ExpCode2]. |
| WBL_ExpCode3 | 15.7.3 | Varchar2(1) | Identifies the third work-based learning experience in which this student participated. Migrated from [Students.SC_WBL_ExpCode3]. |
| WBL_ExpCode4 | 15.7.3 | Varchar2(1) | Identifies the fourth work-based learning experience in which this student participated. Migrated from [Students.SC_WBL_ExpCode4]. |
| WBL_ExpCode5 | 15.7.3 | Varchar2(1) | Identifies the fourth work-based learning experience in which this student participated. |
| WBL_ExpCodeCCR | 18.4.0 | Varchar2(1) | WBL CCR Experience |
| WBL_ExpOwner1 | 15.7.3 | Varchar2(8) | Identifies the first work-based experience owner. Migrated from [Students.SC_WBL_ExpOwner1]. |
| WBL_ExpOwner2 | 15.7.3 | Varchar2(8) | Identifies the second work-based experience owner. Migrated from [Students.SC_WBL_ExpOwner2]. |
| WBL_ExpOwner3 | 15.7.3 | Varchar2(8) | Identifies the third work-based experience owner. Migrated from [Students.SC_WBL_ExpOwner3]. |
| WBL_ExpOwner4 | 15.7.3 | Varchar2(8) | Identifies the fourth work-based experience owner. Migrated from [Students.SC_WBL_ExpOwner4]. |
| WBL_ExpOwner5 | 15.7.3 | Varchar2(8) | Identifies the fourth work-based experience owner. |
| WBL_ExpOwnerCCR | 18.4.0 | Varchar2(8) | WBL CCR Exp Owner |
| WBL_HoursMet1 | 18.4.0 | Varchar2(1) | WBL 40-Hour Minimum Met 1 |
| WBL_HoursMet2 | 18.4.0 | Varchar2(1) | WBL 40-Hour Minimum Met 2 |
| WBL_HoursMet3 | 18.4.0 | Varchar2(1) | WBL 40-Hour Minimum Met 3 |
| WBL_HoursMet4 | 18.4.0 | Varchar2(1) | WBL 40-Hour Minimum Met 4 |
| WBL_HoursMet5 | 18.4.0 | Varchar2(1) | WBL 40-Hour Minimum Met 5 |
| WBL_HoursMetCCR | 18.4.0 | Varchar2(1) | WBL CCR 40-Hour Minimum Met |
| WBL_JobTitle1 | 15.7.3 | Varchar2(25) | Identifies the student's job title. Migrated from [Students.SC_WBL_JobTitle1]. |
| WBL_JobTitle2 | 15.7.3 | Varchar2(25) | Identifies the student's job title. Migrated from [Students.SC_WBL_JobTitle2]. |
| WBL_JobTitle3 | 15.7.3 | Varchar2(25) | Identifies the student's job title. Migrated from [Students.SC_WBL_JobTitle3]. |
| WBL_JobTitle4 | 15.7.3 | Varchar2(25) | Identifies the student's job title. Migrated from [Students.SC_WBL_JobTitle4]. |
| WBL_JobTitle5 | 15.7.3 | Varchar2(25) | Identifies the student's job title. Migrated from [Students.SC_WBL_JobTitle4]. |
| WBL_JobTitleCCR | 18.4.0 | Varchar2(25) | WBL CCR Worksite Supervisor Job Title |
| WBL_OtherSup1 | 15.7.3 | Varchar2(1) | Identifies the other support provided to the student by the employer. |
| WBL_OtherSup2 | 15.7.3 | Varchar2(1) | Identifies the other support provided to the student by the employer. Migrated from [Students.SC_WBL_OtherSupp2]. |
| WBL_OtherSup3 | 15.7.3 | Varchar2(1) | Identifies the other support provided to the student by the employer. Migrated from [Students.SC_WBL_OtherSupp3]. |
| WBL_OtherSup4 | 15.7.3 | Varchar2(1) | Identifies the other support provided to the student by the employer. Migrated from [Students.SC_WBL_OtherSupp4]. |
| WBL_OtherSup5 | 15.7.3 | Varchar2(1) | Identifies the other support provided to the student by the employer. |
| WBL_OtherSupCCR | 18.4.0 | Varchar2(1) | Other support provided to you by WBL CCR Worksite |
| WBL_PaidInd1 | 15.7.3 | Varchar2(1) | Indicates if the student received payment for the work-based experience. Migrated from [Students.SC_WBL_PaidInd1]. |
| WBL_PaidInd2 | 15.7.3 | Varchar2(1) | Indicates if the student received payment for the work-based experience. Migrated from [Students.SC_WBL_PaidInd2]. |
| WBL_PaidInd3 | 15.7.3 | Varchar2(1) | Indicates if the student received payment for the work-based experience. Migrated from [Students.SC_WBL_PaidInd3]. |
| WBL_PaidInd4 | 15.7.3 | Varchar2(1) | Indicates if the student received payment for the work-based experience. Migrated from [Students.SC_WBL_PaidInd4]. |
| WBL_PaidInd5 | 15.7.3 | Varchar2(1) | Indicates if the student received payment for the work-based experience. |
| WBL_PaidIndCCR | 18.4.0 | Varchar2(1) | WBL CCR Paid |
| WBL_RelateIn1 | 15.7.3 | Varchar2(1) | Indicates if the work-based learning experience is related to the student's career plan. Migrated from [Students.SC_WBL_RelateCareerPlanInd1]. |
| WBL_RelateIn2 | 15.7.3 | Varchar2(1) | Indicates if the work-based learning experience is related to the student's career plan. Migrated from [Students.SC_WBL_RelateCareerPlanInd2]. |
| WBL_RelateIn3 | 15.7.3 | Varchar2(1) | Indicates if the work-based learning experience is related to the student's career plan. Migrated from [Students.SC_WBL_RelateCareerPlanInd3]. |
| WBL_RelateIn4 | 15.7.3 | Varchar2(1) | Indicates if the work-based learning experience is related to the student's career plan. Migrated from [Students.SC_WBL_RelateCareerPlanInd4]. |
| WBL_RelateIn5 | 15.7.3 | Varchar2(1) | Indicates if the work-based learning experience is related to the student's career plan. |
| WBL_RelateInCCR | 18.4.0 | Varchar2(1) | WBL CCR Related to Career Plan |
| WBL_SrvcLHrs | 15.7.3 | Varchar2(4) | The number of service learning hours this student earned. Migrated from [Students.SC_WBL_SrvcLearnHrs]. |
| WBL_StartDate1 | 15.7.3 | Date | Identifies the date the first work-based experience started. Migrated from [Students.SC_WBL_StartDate1]. |
| WBL_StartDate2 | 15.7.3 | Date | Identifies the date the second work-based experience started. Migrated from [Students.SC_WBL_StartDate2]. |
| WBL_StartDate3 | 15.7.3 | Date | Identifies the date the third work-based experience started. Migrated from [Students.SC_WBL_StartDate3]. |
| WBL_StartDate4 | 15.7.3 | Date | Identifies the date the fourth work-based experience started. Migrated from [Students.SC_WBL_StartDate4]. |
| WBL_StartDate5 | 15.7.3 | Date | Identifies the date the fifth work-based experience started. |
| WBL_StartDateCCR | 18.4.0 | Date | WBL CCR Start Date |
| WBL_State1 | 15.7.3 | Varchar2(3) | The state of the work-based learning location. |
| WBL_State2 | 15.7.3 | Varchar2(3) | The state of the work-based learning location. |
| WBL_State3 | 15.7.3 | Varchar2(3) | The state of the work-based learning location. |
| WBL_State4 | 15.7.3 | Varchar2(3) | The state of the work-based learning location. |
| WBL_State5 | 15.7.3 | Varchar2(3) | The state of the work-based learning location. |
| WBL_StateCCR | 18.4.0 | Varchar2(3) | WBL CCR Worksite State |
| WBL_Supervisor1 | 15.7.3 | Varchar2(25) | Identifies the student's supervisor. Migrated from [Students.SC_WBL_Supervisor1]. |
| WBL_Supervisor2 | 15.7.3 | Varchar2(25) | Identifies the student's supervisor. Migrated from [Students.SC_WBL_Supervisor2]. |
| WBL_Supervisor3 | 15.7.3 | Varchar2(25) | Identifies the student's supervisor. Migrated from [Students.SC_WBL_Supervisor3]. |
| WBL_Supervisor4 | 15.7.3 | Varchar2(25) | Identifies the student's supervisor. Migrated from [Students.SC_WBL_Supervisor4]. |
| WBL_Supervisor5 | 15.7.3 | Varchar2(25) | Identifies the student's supervisor. |
| WBL_SupervisorCCR | 18.4.0 | Varchar2(25) | WBL CCR Worksite Supervisor |
| WBL_Type1 | 15.7.3 | Varchar2(2) | Identifies the work-based learning type of business. Migrated from [Students.SC_WBL_Type1]. |
| WBL_Type10 | 19.1.0 | Varchar2(2) | WBL Career Cluster Type 10 |
| WBL_Type2 | 15.7.3 | Varchar2(2) | Identifies the work-based learning type of business. Migrated from [Students.SC_WBL_Type2]. |
| WBL_Type3 | 15.7.3 | Varchar2(2) | Identifies the work-based learning type of business. Migrated from [Students.SC_WBL_Type3]. |
| WBL_Type4 | 15.7.3 | Varchar2(2) | Identifies the work-based learning type of business. Migrated from [Students.SC_WBL_Type4]. |
| WBL_Type5 | 15.7.3 | Varchar2(2) | Identifies the work-based learning type of business. |
| WBL_Type6 | 19.1.0 | Varchar2(2) | WBL Career Cluster Type 6 |
| WBL_Type7 | 19.1.0 | Varchar2(2) | WBL Career Cluster Type 7 |
| WBL_Type8 | 19.1.0 | Varchar2(2) | WBL Career Cluster Type 8 |
| WBL_Type9 | 19.1.0 | Varchar2(2) | WBL Career Cluster Type 9 |
| WBL_TypeCCR | 18.4.0 | Varchar2(2) | WBL CCR Career Cluster Type |
| WBL_Zip1 | 15.7.3 | Varchar2(5) | The zip code of the work-based learning location. Migrated from [Students.SC_WBL_Zip1]. |
| WBL_Zip2 | 15.7.3 | Varchar2(5) | The zip code of the work-based learning location. Migrated from [Students.SC_WBL_Zip2]. |
| WBL_Zip3 | 15.7.3 | Varchar2(5) | The zip code of the work-based learning location. Migrated from [Students.SC_WBL_Zip3]. |
| WBL_Zip4 | 15.7.3 | Varchar2(5) | The zip code of the work–based learning location. Migrated from [Students.SC_WBL_Zip4]. |
| WBL_Zip5 | 15.7.3 | Varchar2(5) | The zip code of the work–based learning location. |
| WBL_ZipCCR | 18.4.0 | Varchar2(5) | WBL CCR Zipcode |