Name: CWAP_Participants_03172021.csv

Display Field: If_yes__name_of_Employer_

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PID (type: esriFieldTypeInteger, alias: PID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Training_Provider (type: esriFieldTypeString, alias: Training Provider, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Street_Address1 (type: esriFieldTypeString, alias: Street Address1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Street_Address2 (type: esriFieldTypeString, alias: Street Address2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Zip (type: esriFieldTypeInteger, alias: Zip, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age (type: esriFieldTypeInteger, alias: Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Gender (type: esriFieldTypeString, alias: Gender, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Ethnicity (type: esriFieldTypeString, alias: Ethnicity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Job_Status_at_Time_of_Applicati (type: esriFieldTypeString, alias: Job Status at Time of Application, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Receiving_Unemployment_ (type: esriFieldTypeString, alias: Receiving Unemployment?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Employer_before_Covid (type: esriFieldTypeString, alias: Employer before Covid, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Hourly_Wage_before_Covid (type: esriFieldTypeDouble, alias: Hourly Wage before Covid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Highest_Level_of_Education (type: esriFieldTypeString, alias: Highest Level of Education, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Program_of_Interest (type: esriFieldTypeString, alias: Program of Interest, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Categories_Apply__Social_Securi (type: esriFieldTypeInteger, alias: Categories Apply: Social Security / Retirement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Categories_Apply__Limited_Engli (type: esriFieldTypeString, alias: Categories Apply: Limited English Proficiency, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Categories_Apply__Disability (type: esriFieldTypeInteger, alias: Categories Apply: Disability, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Categories_Apply__Welfare_Recip (type: esriFieldTypeInteger, alias: Categories Apply: Welfare Recipient, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Categories_Apply__SNAP_Food_Sta (type: esriFieldTypeInteger, alias: Categories Apply: SNAP/Food Stamps, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Categories_Apply__TANF_VIEW (type: esriFieldTypeInteger, alias: Categories Apply: TANF/VIEW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Categories_Apply__Low_Income (type: esriFieldTypeInteger, alias: Categories Apply: Low Income, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Categories_Apply__Section_8_Hou (type: esriFieldTypeInteger, alias: Categories Apply: Section 8 Housing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Categories_Apply__Offender_Crim (type: esriFieldTypeInteger, alias: Categories Apply: Offender/Criminal Justice, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Categories_Apply__Dislocated_Wo (type: esriFieldTypeInteger, alias: Categories Apply: Dislocated Worker, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Categories_Apply__Homeless (type: esriFieldTypeInteger, alias: Categories Apply: Homeless, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Categories_Apply__Foster_Care (type: esriFieldTypeString, alias: Categories Apply: Foster Care, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Information_Technology__Full_St (type: esriFieldTypeString, alias: Information Technology: Full-Stack Java, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CDL_Class_A_Truck_Driving__Tuit (type: esriFieldTypeInteger, alias: CDL Class A Truck Driving (Tuition Books & Fees), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Professional_Tracktor_Trailer_D (type: esriFieldTypeInteger, alias: Professional Tracktor-Trailer Driver Training - 16n Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Marine_Trade_Training___Coating (type: esriFieldTypeInteger, alias: Marine Trade Training - Coatings Level 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Marine_Trade_Training___Outside (type: esriFieldTypeInteger, alias: Marine Trade Training - Outside Machinist Level 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Marine_Trade_Training___Electri (type: esriFieldTypeInteger, alias: Marine Trade Training - Electrical Level 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Marine_Trade_Training___Welding (type: esriFieldTypeInteger, alias: Marine Trade Training - Welding Level 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Training_Personal_Care_Aide__Tu (type: esriFieldTypeInteger, alias: Training-Personal Care Aide (Tuition, Books & Fees), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Training_Registered_Medication_ (type: esriFieldTypeInteger, alias: Training-Registered Medication Aide (Tuition, Books & Fees), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Training_Medication_Aide__Tuiti (type: esriFieldTypeInteger, alias: Training-Medication Aide (Tuition, Books & Fees), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Facility_Maintenance_Apprentice (type: esriFieldTypeString, alias: Facility Maintenance Apprenticeship Program, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Electrician_Apprenticeship_Prog (type: esriFieldTypeString, alias: Electrician Apprenticeship Program, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HVAC_Apprenticeship_Program (type: esriFieldTypeString, alias: HVAC Apprenticeship Program, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Plumbing_Apprenticeship_Program (type: esriFieldTypeString, alias: Plumbing Apprenticeship Program, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Training_Cost (type: esriFieldTypeString, alias: Training Cost, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Supplemental_Service__1 (type: esriFieldTypeString, alias: Supplemental Service #1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SS_1_Cost (type: esriFieldTypeString, alias: SS#1 Cost, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Supplemental_Service__2 (type: esriFieldTypeString, alias: Supplemental Service #2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SS_2_Cost (type: esriFieldTypeString, alias: SS#2 Cost, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Supplemental_Service__3 (type: esriFieldTypeString, alias: Supplemental Service #3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SS_3_Cost (type: esriFieldTypeString, alias: SS#3 Cost, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SS_Total_Cost (type: esriFieldTypeString, alias: SS Total Cost, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Did_Participa0t_Complete_the_Pr (type: esriFieldTypeString, alias: Did Participa0t Complete the Program? (1 or 0), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• F1st_Certificate_or_Credential (type: esriFieldTypeString, alias: 1st Certificate or Credential, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• F2nd_Certificate_or_Credential (type: esriFieldTypeString, alias: 2nd Certificate or Credential, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• F3rd_Certificate_or_Credential (type: esriFieldTypeString, alias: 3rd Certificate or Credential, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Did_Participant_Obtain_Emplomen (type: esriFieldTypeString, alias: Did Participant Obtain Emploment in the Field? (1 or 0), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• If_yes__name_of_Employer_ (type: esriFieldTypeString, alias: If yes, name of Employer?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Hourly_Wage (type: esriFieldTypeDouble, alias: Hourly Wage, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: CWAP_Participants_03172021.csv
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/19/2021 3:30:22 PM

Schema Last Edit Date: 3/19/2021 3:30:22 PM

Data Last Edit Date: 3/19/2021 3:30:22 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat