Measure Drilldown
Use the browser's
Back button to return to this point.
WIA ADULT
Average Earnings
Employment and
Credential/Certificate
Entered Employment
Retention
WIA DISLOCATED WORKER
Average Earnings
Employment
and Credential/Certificate
Entered Employment
Retention
WIA OLDER YOUTH
Credential/Certificate
Earnings Change
Entered Employment
Retention
WIA YOUNGER YOUTH
High School Diploma
Retention
Skill Attainment Rate
ALL WIA YOUTH
Degree/Certificate
OS_BSD
Testing
Placement in
Employment or Education
WIA ADULT
Population:
Common Exit within measure’s date range
Office_id
Program: WIA ADULT
Self_employed not true
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr
SKIES Employed Flag:
Q1: if q1_employed_flag true, show “X”
Q2: if q2_employed_flag true, show “X”
Q3: if q3_employed_flag true, show “X”
TAXIS Wages:
Outcome:
If we don’t have TAXIS for Q3, show “-----“.
If we have TAXIS for Q3:
If one quarter has no earnings, show “Excluded”.
If we have earnings for all 3 quarters, show total of TAXIS Wages Q2 and Q3.
Numerator: Show sum of Outcome amounts.
Denominator: Count only those with an Outcome amount.
EMPLOYMENT AND CREDENTIAL/CERTIFICATE (Adult)
Population:
Common Exit within measure’s date range
Office_id
Date_first_tng_svc not blank
Program: WIA ADULT
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr
Self-Empl: If self_employed true, show “Y”.
SKIES Employed Flag Q1: If q1_employed_flag true, show “X”.
Employed per TAXIS Q1: If q1_taxis_earnings>0, show “Y”.
Received Cred/Cert:
If date_first_tng_svc before 7/1/06 and if q3_credential true, show “Y”.
If date_first_tng_svc on or after 7/1/06 and if q3_certificate true, show “Y”.
Outcome:
If (self_employed true and q1_employed_flag true)
and Received Cred/Cert = “Y” then show “POS”.
or
If q1_taxis_earnings>0 and Received Cred/Cert = “Y” then show “POS”
If not one of the above….
If post_exit_qtr_completed is not >= 1 or taxis_for_qtr < 1 then show “-----“.
If not “POS” or “-----“ then show “Neg”.
Numerator: Count of all “POS”
Denominator: Count of all “POS” and “Neg”
Population:
Common Exit within measure’s date range
Office_id
Not_emp_at_start = true
Program: WIA ADULT
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr
Self-Empl: If self_employed true, show “Y”.
SKIES Employed Flag Q1: If q1_employed_flag true, show “X”.
Employed per TAXIS Q1: If q1_taxis_earnings>0, show “Y”.
Outcome:
If self_employed true and q1_employed_flag true
then show “POS”.
or
If q1_taxis_earnings > 0 then show “POS”
If not one of the above….
If post_exit_qtr_completed is not >= 1 or taxis_for_qtr < 1 then show “-----“.
If not “POS” or “-----“ then show “Neg”.
Numerator: Count of all “POS”
Denominator: Count of all “POS” and “Neg”
Population:
Common Exit within measure’s date range
Office_id
Program: WIA ADULT
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr
Self-Empl: If self_employed true, show “Y”.
SKIES Employed Flag:
Q1: If q1_employed_flag true, show “Y”
Q2: If q2_employed_flag true, show “Y”
Q3: If q3_employed_flag true, show “Y”
Employed per TAXIS:
Q1: If q1_taxis_earnings > 0 then show “Y”.
Q2: If q2_taxis_earnings > 0 then show “Y”.
Q3: If q3_taxis_earnings > 0 then show “Y”.
Outcome:
If post_exit_qtr_completed is less than 3, show “-----“.
If post_exit_qtr_completed is 3:
If self_employed true…
If os_q1_employed_flag not true show “Excluded”
If q1_employed_flag true and both q2_employed_flag and q3_employed_flag are true then show “POS”
If q1_employed_flag true and q2 or q3 are lacking a flag then show “Neg”
If self_employed is not true (not self-employed):
If taxis_for_qtr is less that 3 then show “-----“.
If we do have TAXIS for q3:
If q1_taxis_earnings is not more than 0 show “Excluded”
If q1_taxis_earnings is more than 0:
If both q2_taxis_earnings > 0 and q3_taxis_earnings > 0 then show “POS”.
If q2 or q3_taxis_earnings are zero, show “Neg”.
WIA DISLOCATED WORKER
AVERAGE EARNINGS (Dislocated Worker)
Population:
Common Exit within measure’s date range
Office_id
Program: WIA DISLOCATED WORKER
Self_employed not true
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr
SKIES Employed Flag:
Q1: if q1_employed_flag true, show “X”
Q2: if q2_employed_flag true, show “X”
Q3: if q3_employed_flag true, show “X”
TAXIS Wages:
Outcome:
If we don’t have TAXIS for Q3, show “-----“.
If we have TAXIS for Q3:
If one quarter has no earnings, show “Excluded”.
If we have earnings for all 3 quarters, show total of TAXIS Wages Q2 and Q3.
Numerator: Show sum of Outcome amounts.
Denominator: Count only those with an Outcome amount.
EMPLOYMENT AND CREDENTIAL/CERTIFICATE (Dislocated Worker)
Population:
Common Exit within measure’s date range
Office_id
Date_first_tng_svc not blank
Program: WIA ADULT
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr
Self-Empl: If self_employed true, show “Y”.
SKIES Employed Flag Q1: If q1_employed_flag true, show “X”.
Employed per TAXIS Q1: If q1_taxis_earnings>0, show “Y”.
Received Cred/Cert:
If date_first_tng_svc before 7/1/06 and if q3_credential true, show “Y”.
If date_first_tng_svc on or after 7/1/06 and if q3_certificate true, show “Y”.
Outcome:
If (self_employed true and q1_employed_flag true)
and Received Cred/Cert = “Y” then show “POS”.
or
If q1_taxis_earnings > 0 and Received Cred/Cert = “Y” then show “POS”
If not one of the above….
If post_exit_qtr_completed is not >= 1 or TAXIS for Quarter < 1 then show “-----“.
If not “POS” or “-----“ then show “Neg”.
Numerator: Count of all “POS”
Denominator: Count of all “POS” and “Neg”
ENTERED EMPLOYMENT (Dislocated Worker)
Population:
Common Exit within measure’s date range
Office_id
Not_emp_at_start true (Not employed at start of enrollment)
Program: WIA DISLOCATED WORKER
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr
Self-Empl: If self_employed true, show “Y”.
SKIES Employed Flag Q1: If q1_employed_flag true, show “X”.
Employed per TAXIS Q1: If q1_taxis_earnings > 0, show “Y”.
Outcome:
If self_employed true and q1_employed_flag true
then show “POS”.
or
If q1_taxis_earnings > 0 then show “POS”
If not one of the above….
If post_exit_qtr_completed is not >= 1 or TAXIS for Quarter < 1 then show “-----“.
If not “POS” or “-----“ then show “Neg”.
Numerator: Count of all “POS”
Denominator: Count of all “POS” and “Neg”
Population:
Common Exit within measure’s date range
Office_id
Program: WIA DISLOCATED WORKER
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr
Self-Empl: If self_employed true, show “Y”.
SKIES Employed Flag:
Q1: If q1_employed_flag true, show “Y”
Q2: If q2_employed_flag true, show “Y”
Q3: If q3_employed_flag true, show “Y”
Employed per TAXIS:
Q1: If q1_taxis_earnings > 0 then show “Y”.
Q2: If q2_taxis_earnings > 0 then show “Y”.
Q3: If q3_taxis_earnings > 0 then show “Y”.
Outcome:
If post_exit_qtr_completed is less than 3, show “-----“.
If post_exit_qtr_completed is 3:
If self_employed true…
If os_q1_employed_flag not true show “Excluded”
If q1_employed_flag true and both q2_employed_flag and q3_employed_flag are true then show “POS”
If q1_employed_flag true and q2 or q3 are lacking a flag then show “Neg”
If self_employed is not true (not self-employed):
If taxis_for_quarter is less that 3 then show “-----“.
If we do have TAXIS for q3:
If q1_taxis_earnings is not more than 0 show “Excluded”
If q1_taxis_earnings is more than 0:
If both q2_taxis_earnings>0 and q3_taxis_earnings>0 then show “POS”.
If q2 or q3_taxis_earnings are zero, show “Neg”.
WIA ALL YOUTH
DEGREE/CERTIFICATE (All Youth)
Population:
Common Exit Date within measure’s date range
Enrl_in_ed is true (Enrolled in education)
Enrollment_start_date >= 7/1/06
Office_id
Program: Like “*YOUTH”
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
Diploma GED Certificate:
If q3_certificate = true or q3_attained_diploma = true then show “Y”.
Outcome:
If Diploma GED Certificate shows “Y” then show “POS”.
If no Diploma GED Certificate:
If .post_exit_quarter is less than 3 show “-----“.
Otherwise show “Neg”.
Numerator: Count of “POS”
Denominator: Count of “POS” and “Neg”
OUT OF SCHOOL BASIC SKILLS DEFICIENT TESTING (All Youth)
Population (from table: Os_bsd_report_data):
Office_id
Enroll Start: Enrollment_start_date
Anniv Date: Anniversary_date
Year # of 3 Reported: Year_number
Has Pre-test: If has_pretest is true then show “Y”
Testing Stream with EFL Gain This Anniv Year: Years_gain_stream
Exit Before This Anniv:
If no EnrollmentEndDate show blank.
If there is an EnrollmentEndDate:
If EnrollmentEndDate is within this anniversary year show “Y”.
(Year # 2/3 Exit) Follow Up Svc Within Anniv Year:
If Exit Before This Anniv date shows “Y” and year_number is 2 or 3: Query for follow up services between EnrollmentEndDate and Anniversary Date. If there are any, show “Y”.
Outcome:
If anniversary year 1:
If have something in Testing Stream With EFL Gain This Anniv Year then show “POS”.
If nothing in Testing Stream…:
If date of report is less than year’s Anniversary Date then show “-----“.
If date of report is on or after Anniv Date then show “Neg”.
If anniversary year is 2 or 3:
If have something in Testing Stream With EFL Gain This Anniv Year then show “POS”.
If nothing in Testing Stream…:
If Exit Before This Anniv Shows “Y” and (Year # 2/3 Exit) Follow Up Svc… shows “Y” then show “Excluded”
Otherwise show “Neg”.
Numerator: Count of “POS”
Denominator: Count of “POS” and “Neg”
PLACEMENT IN EMPLOYMENT OR EDUCATION (All Youth)
Population:
Common Exit Date within measure’s date range.
Not_post_sec_at_start is true
(Not in post-secondary education at start of enrollment)
Not_empl_at_start is true (Not employed
at start of enrollment)
Office_id
Program: Like “*YOUTH”
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr
SKIES In Training Flag Q1: If q1_training_flag true then show “Y”.
SKIES Employed Flag Q1: If q1_employed_flag true then show “Y”.
Employed Per TAXIS Q1: If q1_taxis_earnings > 0 then show “Y”’
Outcome:
If Have Taxis for Qtr is 0 then show “-----“.
If Have Taxis for Qtr >= 1:
If q1_training_flag true or q1_taxis_earnings > 0: true show “POS”, not true show “Neg”
Numerator: Count of “POS”
Denominator: Count of “POS” and “Neg”
OLDER YOUTH
CREDENTIAL/CERTIFICATE (Older Youth)
Population:
Common Exit Date within measure’s date range.
Age: >= 19 and < 22
Office_id
Program: Like “*YOUTH”
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr
SKIES Employed Flag Q1: If q1_employed_flag true then show “Y”.
Employed Per TAXIS Q1: If q1_taxis_earnings > 0 then show “Y”.
SKIES In Training Flag: If q1_training_flag true then show “Y”.
Received Cred/Cert Q3:
If enrollment_start_date < 7/1/06:
If q3_credential true then show “Y”
If enrollment_start_date >= 7/1/06:
If q3_certificate true then show “Y”
Outcome:
If Have TAXIS for Qtr = 0 then show “-----“
If Have TAXIS for Qtr >= 1:
If (q1_taxis_earnings > 0 or q1_training_flag true) and
Received Cred/Cert Q2 = ”Y”
True, show “POS”
False:
If Post Exit Quarter Completed = 3 then show “Neg”
If Post Exit Quarter Completed < 3 then show “-----“
Numerator: Count of “POS”
Denominator: Count of “POS” and “Neg”
Population:
Common Exit within measure’s date range
Office_id
Program: Like “*YOUTH”
Age: >= 19 and < 22
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr.
SKIES Employed Flag:
Q1: If q1_employed_flag true, show “Y”
Q2: If q2_employed_flag true, show “Y”
Q3: If q3_employed_flag true, show “Y”
Employed per TAXIS:
Q1: If q1_taxis_earnings > 0 then show “Y”.
Q3: If q3_taxis_earnings > 0 then show “Y”.
SKIES Tng Flag Q3: If q3_training_flag true, show “Y”.
TAXIS Post-Pgm Earnings:
TAXIS Pre-Pgm Earnings:
Outcome:
If Have TAXIS for Qtr < 3 then show “------“
If Have TAXIS for Qtr = 3:
If q1_taxis_earnings > 0 and
(q3_training_flag false or q3_taxis_earnings > 0)
True
(q2_taxis_earnings + q3_taxis_earnings) minus (os_q2_prior_earnings + q3_prior_earnings)
False
Show “Excluded”
Numerator: Sum of numeric Outcomes.
Denominator: Count of numeric Outcomes.
ENTERED EMPLOYMENT (Older Youth)
Population:
Common Exit within measure’s date range
Office_id
Program: Like “*YOUTH”
Age: >= 19 and < 22
Not_empl_at_start true (Not employed at start of enrollment)
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr.
SKIES Tng Flag Q1: If q1_training_flag true, show “Y”.
SKIES Employed Flag Q1: If q1_employed_flag true, show “Y”
Employed per TAXIS Q1: If q1_taxis_earnings > 0 then show “Y”.
Outcome:
If Have TAXIS for Qtr = 0 then show “-----“
If Have TAXIS for Qtr >= 1:
If q1_training_flag true then show “Excluded”
else
If q1_taxis_earnings > 0 then show “POS”
Otherwise show “Neg”
Numerator: Count of “POS”
Denominator: Count of “POS” and “Neg”
Population:
Common Exit within measure’s date range
Office_id
Program: Like “*YOUTH”
Age: >= 19 and < 22
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.)
Common Exit Date: common_exit_date
Post Exit Quarter Completed: post_exit_qtr_completed
TAXIS for Quarter: taxis_for_qtr.
SKIES Employed Flag:
Q1: If q1_employed_flag true, show “Y”
Q3: If q3_employed_flag true, show “Y”
Employed per TAXIS:
Q1: If q1_taxis_earnings > 0 then show “Y”.
Q3: If q3_taxis_earnings > 0 then show “Y”.
SKIES Tng Flag Q3: If q3_training_flag true, show “Y”.
Outcome:
If Have TAXIS for Qtr < 3 then show “-----“
If Have TAXIS for Qtr = 3:
If (q1_taxis_earnings = 0 or q3_training_flag true)
True
Show “Excluded”
False
If q3_taxis_earnings > 0 then show “POS”
else show “Neg”
Numerator: Count of “POS”
Denominator: Count of “POS” and “Neg”
YOUNGER YOUTH
HIGH SCHOOL DIPLOMA (Younger Youth)
Population:
Common Exit Date within measure’s date range
Office_id
Age less than 19
No_dip_GED_at_start = true
(No diploma or GED at start of enrollment)
Program: Like “*YOUTH”
Secondary_school_exit = false Common Exit Date:
common_exit_date Post-exit Quarter
Completed: post_exit_qtr_completed Diploma or Equiv Q1: If
q1_attained_diploma true then show “Y” Outcome: If q1_attained_diploma true then show “POS” else If post_exit_qtr_completed = 0 then show “-----“
otherwise show “Neg” Numerator: Count of “POS” Denominator: Count of
“POS” and “Neg” Population: Common_exit_date within measure’s date range Office_id Age less than 19 Secondary_school_exit = false
Program: like “*YOUTH”
Not pseudo-ssn or opt-out (“XXX”) (Opt-outs can be matched for performance.) Common Exit Date:
common_exit_date Post Exit Quarter
Completed: post_exit_qtr_completed Have TAXIS for Quarter:
taxis_for_qtr. SKIES Employed Flag Q3: If
q3_employed_flag true, show “Y” Employed per TAXIS Q3: If
q3_taxis_earnings > 0 then show “Y”. SKIES Tng Flag Q3: If
q3_training_flag true, show “Y”. Outcome:
If taxis_for_qtr is less than 3 then show “-----“
else
If q3_taxis_earnings > 0 or q3_training_flag = true then show “POS”
otherwise
show “Neg” Numerator: Count of “POS” Denominator: Count of
“POS” and “Neg” Population (Uses table:
_youth_skills) Office_id Type: desc_abbr
(Abbreviation for goal type) Evaluation Date:
evaluation_date Service End Date: sa_actual_completion Had Hold: if
had_hold_during true then show “Y” Service Outcome:
If actual_outcome is not blank then show the right 20 characters of the
actual _outcome
otherwise
show “None” Perf Outcome:
If achieved_in_a_year true then show “POS”
else
If report date is before evaluation_date then show “-----“
otherwise
Show “Neg” Numerator: Count of “POS” Denominator: Count of
“POS” and “Neg”
Table Content (Processing.mdb) Initial setup Initial setup
(formula-fund offices) Quarter start and end
dates for each PY. (No maintenance until PY 2011) List of measures and their
categories and descriptions (No maintenance) List of measures and their
date range categories. Categories with start and
end date of ranges. For connection to measure_list. (No maintenance until 2011) Programs whose services do
not affect the Common Exit Date. Lists program values updated to Terry by Carl
Wolfhagen. Participation services
that affect the Common Exit Date. Updated to Terry by Carl Wolfhagen. Services that count as
“training” in performance measurement. Updated to Terry by Carl Wolfhagen. Services that count as
“education” in performance measurement. Updated to Terry by Carl Wolfhagen Buffer dates for each PY’s
processing (No maintenance until PY 2011)
_fol_all2 (Lists program completions) Population:
(Uses Dwuser_seeker_data_optout, Appowner_program_enrollment) region_id All formula-fund program
completions:
Start: One quarter prior to earliest measure start date
End: End of subject PY Processing of fields in
the table:
NOT_EMPL_AT_START: (Not employed at start of
enrollment) If employment_status not “EMPLOYED” mark checkbox true.
NO_DIP_GED_AT_START: (No diploma or GED at
start of enrollment) If
highest_degree_completed is null or starts with a number or contains “None”,
mark checkbox true.
LAST_ENROLLMENT_SERVICE: (Uses
Temp_last_service_pure) Get last service plan
service affiliated with the program, excluding “HOLD”. Enter the
ActivityCompletionDate of the last enrollment service. If there is a service
within 90 days after the last_enrollment_service, get the end date of the last
one (“last of 90”).
If there is a service within 90 days of the previous “last of 90”, get the end
date of the last one (it becomes “last of 90”).
Repeat this until no services within the 90 day periods.
Common_exit_date=”last of 90” date. If there are no services
within 90 days after the last_enrollment_service, Common_exit_date=Last_enrollment_service date
DATE_FIRST_TNG_SVC: (Date first training
service. Uses Temp_last_service [which includes local services] and
Training_service_types.) Get the enrollment’s first
training service start date.
NOT_POST_SEC_AT_START: (Not in
post-secondary education at start of enrollment. Uses _Fol_all2) If in_school_flag = Yes
and highest_degree_completed is GED/High School or greater, then uncheck the
checkbox. (The person was in post_secondary education.)
ENRL_IN_ED: (Enrolled in education. Uses _Fol_all2,
Temp_last_service and
Ed_svcs_during_enrlmt.) If in_school_flag is yes,
check the checkbox. If exit_outcome is one of
the following, check the checkbox:
ALTERNATIVE SCHOOL
TRANS_ADVANCED
TRANS_POST
TRANS_SCHOOL If one of
ed_svcs_during_enrlmt services was started during enrollment, check the
checkbox.
EXIT_EXCLUSION: (Uses _Fol_all2,
Temp_followup_services) If one of the following
exit_outcomes:
OTHER_INST
OTHER_HEALTH
OTHER_FAMILY
RELOCATED_YOUTH
OTHER_DECEASED
OTHER_RESERVIST
If common_exit_date is not the same as the end of the last_enrollment_service
If there is a followup service like “EXIT
EXCLUSION*” with an actual start date on or after the common_exit_date, check
the checkbox.
If common_exit_date is the same as the last_enrollment_service, check the
checkbox.
SELF_EMPLOYED: (Uses _Fol_all2,
Self_employment_plan) If exit_outcome is “SELF
EMPLOYMENT” and if a service plan for the enrollment has the characters “self
emp” or “self-emp” in its Justification, check the checkbox.
self_employment_plan (Lists Participant
self-employment service plans) Population: (Uses
Appowner_employment_plan and Lookup_office_data) region_id Plan’s
Actual_completion_date is greater than start of 2 quarters prior to the earliest
measure start date. Plan’s Justification has
the characters “self emp” or “self-emp” in it.
temp_followup_services (Lists Participant
follow up services) Population: (Uses
Dwschema_service_optout) region_id Service group type like
“F*” Service Date (Actual start
date) after start of one quarter before earliest measure start date.
temp_last_service (Lists Participant services) Population: (Uses
Dwschema_services_optout, Appowner_program_enrollment, Lookup_office_data) Seeker Services Region_id ServiceDate >= start of
one quarter prior to earliest measure start date. SeekerServiceID is not
blank. Enrollment_Completion_Date
>= Earliest measure start date Seekers in Formula-fund
enrollments Excluding Follow Up
category services as well as “Finished All Planned Services” Service Plan Services Region_id ServiceDate >= start of
one quarter prior to earliest measure start date. SeekerActivityID is not
blank. Enrollment_Completion_Date
>= Earliest measure start date Seekers in Formula-fund
enrollments Excluding Follow Up
category services as well as “Finished All Planned Services” ServiceEnd: If
ActivityActualEndDate is blank (an open service), use last Sunday’s date. If not
blank, use the ActivityActualEndDate
temp_last_service_pure (Lists Participant
services used to determine Common Exit Date) Population: (Uses
Temp_last_service,
participation_services,
Temp_last_service_pure,
_Excluded_programs) Copy only records from
temp_last_service that are listed in participation_services (excludes local
services). Delete all services
affiliated with an excluded program.
Table Content (Outcome_source.mdb)
_youth_skills (Lists Participant Skill Goals) Population: (Uses
Appowner_program_enrollment, Dwschema_services_optout, Lookup_office_data) Region_id Age:>=14 and <=18 ServiceID: One of the 6
skill goal service ids SA_actual_start:
ActivityActualStartDate is >= a year before the measure’s start date and <= the
measure’s end date. Not an excluded exit outcome. Processing for fields in
table:
Maximum_date: ActivityActualStartDate plus one year and 14 days
If ActivityActualStartDate is blank or
(ActivityActualCompletionDate minus ActivityActualStartDate) > one year and 14
days, then check the checkbox.
If ActivityOutcome is like one of the following:
“*GOAL ATTAINED”
“*DEGREE*”
“*HS*”
“*DIPLOMA*”
and ActivityActualCompletionDate < (ActivityActualStartDate plus one year and 14
days), check the checkbox.
If ActivityActualCompletionDate is not blank and
ActivityActualCompletion date < (ActivityActualStartDate plus one year and 14
days), show ActivityActualCompletionDate.
If false, show ActivityActualStartDate plus one year and 14 days. Delete _youth_skills
records in which
Evaluation_date < start of measure’s date range or
Evaluation_date > end of measure’s date range. If a Participant has more
than 3 skill goals with an evaluation_date within the measure’s date range,
delete the latter ones. (This was the method used prior to having the DOL Data Validation software pick them. It is
still unknown how that rationale works.) If a skill goal was
attained but is Over the one year and 14 days time limit, test to see if a
“Hold” was the cause. If there was a “Hold”:
had_hold_during checked true
hold_days = Hold’s ActivityActualCompletionDate minus Hold’s
ActivityActualStartDate.
Hold_revised_target_date = evaluation_date + hold_days
Achieved_in_a_year: If (evaluation_date + hold_days) >= Hold’s
ActivityActualCompletionDate then check it true.
indiv_services (Lists all service types for
enrollments) Population: (Uses
Appowner_program_enrollment, dwschema_EnrollmentData_optout, Lookup_office_data) Region_id ActivityActualStartDate is
not blank Enrollment_completion_date
> one quarter prior to earliest measure start date Formula_fund programs only
older_youth_prior_earnings (Lists older
youth pre-enrollment earnings) Population: (Uses
Dwschema_enrollmentData_optout) Region_id Age >= 19 and < 22 EnrollmentEndDate >= one
quarter prior to earliest measure start date
os_bsd_youth (Lists Out of School, Basic Skills Deficient youth) Population: (Uses
Dwschema_enrollmentdata_optout) Region_id
EnrollmentProgramDescription like “*YOUTH” Age >= 14 and <= 21 InSchoolFlag not Yes LiteracySkillDeficientFlag
= Yes ProgramStatus = ENROLLED
or EXIT EnrollmentStartDate <=
Last end date of any measure and >= 7/1/06 EnrollmentEndDate >= first
start of any measure or is blank (open enrollment)
_os_tests (Lists all test scores) Population: (Uses
Appowner_test_data, Dwuser_agent_data_vw, Lookup_agent_office,
Lookup_office_data) Region_id Test_date >= 1/1/06 Test_value_id (Ids of
specific test types):
7 – Reading TABE
8 – Math TABE
62- Writing TABE
52- CASAS Math
53- CASAS Reading Population: (Uses
Os_bsd_youth and _Os_tests) Copy all os_bsd_youth into table Delete any youth which have an
exit_exclusion Processing of fields for each record: If EnrollmentStartDate >= start of
the os_bsd measure's date range then show 12/12/2012 If EnrollmentStartDate < start of
os_bsd measure's date range then show date of end of current anniversary
year If more than 3 years have gone by,
delete that record and go on to next If less than 3 years have gone by: (Uses
_Os_tests) Year_number = current number of
anniversary year that has elapsed Has_pretest: if one exists check
checkbox true For each testing stream (i.e. Reading,
Math, etc.) in current anniversary year: Years_gain_stream: If a post_test exists
in the year with an EFL gain check checkbox true.
taxis_subset (Lists all TAXIS records for exiters) Population: (Uses
_Fol_all2 and Dwuser_taxis_wage_data_optout) Year >= right 2 characters
of 4 digit PY Population: (Uses
_Fol_all2) Common_exit_date is: not blank and >= earliest start date of
all measures and <= last end date of all
measures Exit_exclusion is false Processing for each of the
above records:
Post_exit_qtr_completed: Enter # based on
dates
Taxis_for_qtr: Enter Participant's post-exit quarter that has TAXIS
information (Using taxis_subset)
Q1_taxis_earnings: Amount (Using taxis_subset)
Q2_taxis_earnings: Amount (Using taxis_subset)
Q3_taxis_earnings: Amount (Using taxis_subset)
Q1_employed_flag: Check if true (Using
indiv_services)
Q2_employed_flag: Check if true (Using
indiv_services)
Q3_employed_flag: Check if true (Using
indiv_services)
Q1_training_flag: Check if age < 22 and is true
(Using indiv_services)
Q2_training_flag: Check if age < 22 and is true
(Using indiv_services)
Q3_training_flag: Check if age < 22 and is true
(Using indiv_services)
Q2_prior_earnings: Amount (Using
older_youth_prior_earnings)
Q3_prior_earnings: Amount (Using
older_youth_prior_earnings)
Q3_attained_diploma: Check if true (Using
indiv_services)
ActivityActualCompletionDate <= Q3_end
ActivityOutcome like:
“*HIGH*”
“*GED*”
“*DEGREE*”
Q3_credential: Check if true (Using indiv_services)
ActivityActualCompletionDate <= Q3_end
ActivityOutcome like:
“*HIGH*”
“*GED*”
“*DEGREE*”
“*CERTIFICATE*”
“*LICENSE*”
“*OTHER CREDENTIAL*”
Q3_certificate: Check if true (Using indiv_services)
ActivityActualCompletionDate <= Q3_end
ActivityOutcome like:
“*CERTIFICATE*”
“*LICENSE*”
Q1_attained_diploma: Check if age < 19 and is
true (using indiv_services)
ActivityActualCompletionDate <= Q1_end
ActivityOutcome like:
“*HIGH*”
“*GED*”
“*DEGREE*”
Secondary_school_exit: If exit_outcome =
“TRANS_SCHOOL” or exit_outcome = “ALTERNATIVE SCH" check checkbox true ---Make a record in
Outcome_Source---