Time for IRAP to Provide SRE with Performance Information

Confidential, Deliberative Draft

IRAP Performance Reporting Data Dictionary

DOCUMENT #1. IRAP NEW PROGRAM RECOGNITION REPORT
A. Identifying Information
IRAP
SRE/IRAP Performance
Performance Measure
Measure/Data Element Name
Proposed Definition
1. SRE
Name of Standards Recognition
Entity organization
varchar(55)
2.

3.

4.

5.

6.

7.

SRE ID

IRAP Provider

IRAP Provider ID

IRAP Program

IRAP Program ID

Date of Submission

Data Type

Domain & Range
Upper and lowercase letters A-Z

SRE ID
int(11)

Integer

varchar(55)

Upper and lowercase letters A-Z

int(11)

Integer

varchar(55)

Upper and lowercase letters A-Z

int(11)

Integer

date

date

Enter name of IRAP Provider

IRAP Provider ID

Enter name of IRAP Program

IRAP Program ID

Date of Submission

B. IRAP Status Form
IRAP Provider Contact Info and Status
SRE/IRAP Performance
Measure/Data Element Name
1.

2.

3.

4.

5.

6.

7.

8.

9.

Org (IRAP Provider)

IRAP Provider ID

Org Type

IRAP Provider address

IRAP Provider city

IRAP Provider state

IRAP Provider ZIP5

IRAP Provider ZIP4

IRAP Provider country

IRAP
Performance Measure
Proposed Definition
Enter name of Employer,
Intermediary, Other

Type of Organization: Single
Employer, Consortia,
Intermediary, etc.

int(11)

Integer

varchar(55)

Upper and lowercase letters A-Z

varchar(60)

Upper and lowercase letters A-Z

varchar(55)

Upper and lowercase letters A-Z

varchar(2)

Upper and lowercase letters A-Z

varchar(5)

Numbers 0-9

varchar(4)

Numbers 0-9

varchar(55)

Upper and lowercase letters A-Z

varchar(255)V

Upper and lowercase letters A-Z

varchar(55)

Upper and lowercase letters A-Z

varchar(2)V

Upper and lowercase letters A-Z

varchar(255)V

Upper and lowercase letters A-Z, numbers 0-9,
common special characters

varchar(255)V

Numbers 0-9

IRAP Provider city

IRAP Provider state

IRAP Provider ZIP5

IRAP Provider ZIP4

IRAP Provider Country

11. IRAP Provider contact last
name

IRAP Provider POC last name

12. IRAP Provider contact Title

IRAP Provider POC Title

14. IRAP Provider contact phone

Upper and lowercase letters A-Z

IRAP Provider address

IRAP Provider POC first name

Domain & Range

varchar(55)

IRAP Provider ID

10. IRAP Provider contact first
name

13. IRAP Provider contact email

Data Type

IRAP Provider POC email

IRAP Provider POC phone

1

Confidential, Deliberative Draft

15. IRAP Provider contact phone
extension

IRAP Provider POC phone
extension

16. IRAP Provider Website

Organization/Program website

C.

Numbers 0-9

varchar(2083)

Upper and lowercase letters A-Z, numbers 0-9,
common special characters

IRAP Program Info

SRE/IRAP Performance
Measure/Data Element Name
1.

varchar(4)V

IRAP Program Name

IRAP
Performance Measure
Proposed Definition
Enter IRAP Program Name

Data Type

Domain & Range

varchar(255)V

Upper and lowercase letters A-Z

int(11)

integer

date

date

varchar(4000)

Upper and lowercase letters A-Z

varchar(2)

Numbers 0-9

int(8)

Numbers 0-9

int(11)

integer

Enter All Credentials to be
attained (at least 1)

varchar(255)V

Upper and lowercase letters A-Z

Enter Employer Name, If
consortia, list all employers

varchar(255)V

Upper and lowercase letters A-Z,

10. Related Instruction Provider(s) List Related Instruction
Provider(s)

varchar(255)V

Upper and lowercase letters A-Z,

11. Program Type (National, Local, Enter Area of Service
Regional)

varchar(255)V

Upper and lowercase letters A-Z,

Provide URL where info can be
found

varchar(2083)V

Upper and lowercase letters A-Z, numbers 0-9,
common special characters

Provide URL where info can be
found

varchar(2083)V

Upper and lowercase letters A-Z, numbers 0-9,
common special characters

varchar(2)V

Upper and lowercase letters A-Z

2.

3.

4.

5.

6.

7.

8.

9.

IRAP Program ID

Date of Recognition

Short Description

Industry

Occupation Title

Occupation ID

Credential(s)

Employer(s) if applicable

12. Fees

13. Complaint Info

14. Program Status (Recognized,
Derecognized, Suspended)

IRAP Program ID

Date Program recognized by SRE

Narrative describing the
program
2 Digit NAICS code

O*NET-SOC Code

Occupation ID

Status of Program with SRE

15. Reason for Change in Program Narrative describing the reason
Status
for change in program status
varchar(4000)

2

Upper and lowercase letters A-Z

Confidential, Deliberative Draft

DOCUMENT #2A. SRE ANNUAL PROGRAM AND PERFORMANCE REPORT
Identifying Information (Scope and Timeframe of Report)
IRAP
SRE/IRAP Performance Measure/Data
Performance Measure
Data Type
Element Name
Proposed Definition
SRE (Submitter)
Name of Standards Recognition
Entity (submitter)
varchar(255)V
A.

SRE ID

SRE ID

Upper and lowercase letters A-Z

integer

int(11)

Fiscal Year (October 1 of the
budget's prior year through
Date range
September 30 of the year being
described)
B. Total SRE In-Program Performance and Activity Measure (Sum all SRE Recognized IRAPs)
IRAP
SRE/IRAP Performance Measure/Data
Performance Measure
Data Type
Element Name
Proposed Definition
1. New Apprentices (current
The total number of apprentices
period)
that entered into an
apprenticeship agreement in an int(11)
IRAP during the current reporting
period.
2. Active Apprentices
The total number of apprentices
that were active under an
apprenticeship agreement in an int(11)
IRAP at the end of the previous
reporting period.
3. Total Apprentices Served
The total apprentices served
during the current reporting
int(11)
period.
Reporting Period

4.

Domain & Range

Training Cost per Apprentice

The cost of training per
apprentice as defined by the total
cost of classroom instruction for
decimal(11,0)
all of an IRAP’s apprentices
divided by the total number of
apprentices.
5. Active Apprentices
The total number of apprentices
that were active under an
apprenticeship agreement in an int(11)
IRAP at the end of the current
reporting period
6. Inactive Apprentices (current
The total number of apprentices
period)
under an apprenticeship
agreement in an IRAP that
int(11)
became inactive at any time
during the current reporting
period.
7. Completers
The total number of apprentices
that successfully completed the
IRAP requirements and separated
int(11)
from the apprenticeship program
during the current reporting
period (subset of inactives #6).
8. Non-Completers (current
The total number of apprentices
period)
who did not complete the IRAP
requirements and separated
int(11)
from the IRAP during the current
reporting period (subset of
inactives #6).
9. Annual Completion Rate
The annual rate of completion for
apprentices as determined by
comparing the number of
apprentices who successfully
completed the IRAP
requirements during the current decimal(11,0)
reporting period with the number
of apprentices that became
inactive during the current
reporting period. (Completers /
Inactives).
10. Median Length of Time for IRAP The midpoint value for the values
Completion
of all of an IRAP’s apprentices
time for IRAP completion
calculated from time of entry into
an apprenticeship agreement
int(11)
until the time the apprentice has
successfully completed the IRAP
requirements for the current
reporting period.

3

date

Formula
SUM OF NEW APPRENTICES IN ALL
REPORTED IRAPS DURING CURRENT
REPORTING PERIOD

SUM OF ACTIVE APPRENTICES IN ALL
REPORTED IRAPS AT END OF PREVIOUS
REPORTING PERIOD

SUM OF ACTIVE APPRENTICES IN THE
PREVIOUS reporting PERIOD and NEW
APPRENTICES IN THE CURRENT
REPORTING PERIOD
SUM OF TOTAL TRAINING COSTS PER
APPRENTICE (CLASSROOM
INSTRUCTION) DIVIDED BY THE TOTAL
NUMBER OF APPRENTICES

SUM OF ACTIVE APPRENTICES IN ALL
REPORTED IRAPS AT END OF CURRENT
REPORTING PERIOD

SUM OF INACTIVE APPRENTICES IN ALL
REPORTED IRAPS DURING THE CURRENT
REPORTING PERIOD.

SUM OF APPRENTICES COMPLETERS IN
ALL REPORTED IRAPS

SUM OF NON-COMPLETERS IN ALL
REPORTED IRAPS DURING THE CURRENT
REPORTING PERIOD

#7 Divided by #6

VALUE (MONTHS/DAYS)

Confidential, Deliberative Draft

11. Number Credentials attained by The number of credentials
Completers
attained by completers during
the current reporting period.
12. Aggregated Number of
Complaints for each IRAP

SUM OF ALL CREDENTIALS ATTAINED BY
ALL APPRENTICES IN ALL REPORTED
IRAPS DURING THE CURRENT
REPORTING PERIOD

int(11)

The aggregated number of
complaints for received for each int(11)
IRAP.

NUMBER OF COMPLAINTS RECEIVED

4

Confidential, Deliberative Draft

DOCUMENT #2B. IRAP ANNUAL PROGRAM AND PERFORMANCE REPORT
IRAP Identifying Information (Scope and Timeframe of Report)
IRAP
Performance Measure/ Data Element
Performance Measure
Data Type
Name
Proposed Definition
1. SRE (Submitter)
SRE (Submitter)
A.

2.

3.

4.

5.

6.

7.

SRE ID

IRAP Provider

IRAP Provider ID

IRAP Program

IRAP Program ID

Domain & Range

varchar(55)

Upper and lowercase letters A-Z

int(11)

Integer

varchar(55)

Upper and lowercase letters A-Z

int(11)

Integer

varchar(55)

Upper and lowercase letters A-Z

int(11)

Integer

SRE ID

IRAP Provider

IRAP Provider ID

IRAP Program

IRAP Program ID

Reporting Period

Fiscal Year (October 1 of the
budget's prior year through
date
September 30 of the year being
described)
B. IRAP In-Program Performance and Activity Measure (Submitted Annually for each IRAP)
IRAP
Performance Measure/Data Element
Performance Measure
Data Type
Name
Proposed Definition
1. New Apprentices
The total number of
(current period)
apprentices that entered into
an apprenticeship agreement in int(11)
an IRAP during the current
reporting period.
2. Active Apprentices (previous
The total number of
period)
apprentices that were active
under an apprenticeship
agreement in an IRAP at the
int(11)
end of the previous reporting
period (e.g. prior October 1 –
September 30).
3. Total Apprentices served
The total number of
(current period)
apprentices served during the int(11)
current reporting period

date

Formula
SUM OF NEW APPRENTICES IN ALL
REPORTED IRAPS

SUM OF ACTIVE APPRENTICES IN ALL
REPORTED IRAPS AT END OF PREVIOUS
REPORTING PERIOD

SUM OF TOTAL APPRENTICES IN ALL
REPORTED IRAPS

4.

Training Cost per Apprentice

Training Cost per Apprentice
(Total Cost / Total Apprentices decimal(11,0)
(3))

TOTAL COST / TOTAL APPRENTICES

5.

Active Apprentices (end of
current period)

SUM OF ACTIVE APPRENTICES IN ALL
REPORTED IRAPS AT END OF CURRENT
REPORTING PERIOD

6.

Number Inactive Apprentices
(current period)

The total number of
apprentices that were active
under an apprenticeship
agreement in an IRAP at the
int(11)
end of the current reporting
period (e.g. October 1 –
September 30)
The total number of
apprentices under an
apprenticeship agreement in an
int(11)
IRAP that became inactive at
any time during the current
reporting period.

7.

Number of Completers (current The total number of
period)
apprentices who successfully
complete the IRAP
requirements during the
current reporting period.

8.

Number of Non-Completers
(current period)

(subset of inactives #6)
The total number of
apprentices who do not
complete the IRAP
requirements and separated
from IRAP during the current

SUM OF INACTIVE APPRENTICES IN ALL
REPORTED IRAPS

SUM OF APPRENTICES COMPLETERS IN ALL
REPORTED IRAPS FOR CURRENT
REPORTING PERIOD
int(11)

SUM OF NON-COMPLETERS IN ALL
REPORTED IRAPS DURING THE CURRENT
REPORTING PERIOD.
int(11)

reporting period. (subset of
inactives #6)

5

Confidential, Deliberative Draft

9.

Annual Completion Rate

The annual rate of completion
for apprentices as determined
by comparing the number of
apprentices who successfully
completed the IRAP
requirements during the
decimal(11,0)
current reporting period with
the number of apprentices that
became inactive during the
current reporting period.
(Completers / Inactives)
10. Median Length of Time for
The midpoint value for the
Completion
values of all of an IRAP’s
apprentice’s time for IRAP
completion calculated from
time of entry into an
TBD
apprenticeship agreement until
the time the apprentice has
successfully completed the IRAP
requirements during the
current reporting period.
11. Number of Credentials attained The number of credentials
by Completers
attained by completers during int(11)
the current reporting period.
12. Aggregated Number of
Complaints (for each IRAP)
C.

The aggregated number of
complaints received for each
IRAP

TBD

SUM OF ALL CREDENTIALS ATTAINED BY
ALL APPRENTICES IN ALL REPORTED IRAPS

SUM OF COMPLAINTS RECEIVED FOR EACH
IRAP

int(11)

Credentials Issued (Submitted Annually)

Performance Measure/Data Element
Name
1.

NUMBER OF COMPLETERS DURING
CURRENT REPORTING PERIOD (SUBSET OF
INACTIVES) DIVIDED BY NUMBER OF
APPRENTICES THAT BECAME INACTIVE AT
ANY TIME DURING THE CURRENT
REPORTING PERIOD

Credential Name

IRAP
Performance Measure
Proposed Definition
Name of Credential

Data Type

Formula
N/A

varchar(55)
2.

Credential Name ID

Credential Name ID

N/A
int(11)

3.

Number of Credentials Attained Number of Credentials Attained

SUM OF ALL CREDENTIALS ATTAINED BY
ALL APPRENTICES IN ALL REPORTED IRAPS

int(11)

IRAP ANNUAL PROGRAM AND PERFORMANCE REPORT
D. IRAP Post Program Performance and Activity Measures (submitted Annually)
6 Months Post Completion IRAP Measure or Data Element
IRAP
Performance Measure/Data Element
Performance Measure
Data Type
Name
Proposed Definition
1. Number of Completers
Number of completers from
(current period)
October 1 thru March 31st of
int(11)
the current reporting period

Formula
VALUE (#)

2.

Number of Completers
(prior period)

Number of completers from
April 1 thru September 30th of int(11)
the previous period

VALUE PROVIDED FROM PREVIOUS YEAR
REPORT (#3 BELOW) – PRE-POPULATE

3.

Number of Completers
(current period)

Number of completers from
April 1 thru September 30th of int(11)
the current reporting period

DIFFERENCE OF #7 IN TABLE B AND #1
ABOVE

4.

Number of Completers

5.

6.

Number of completers from
April 1 thru September 30th of
the previous period and
int(11)
October 1 thru March 31st of
the current reporting period.
Number of Completers
Number of completers in #4 (6
month completers) employed
with their IRAP provider 6
int(11)
months after apprenticeship
completion DURING the
current reporting PERIOD
Employment Retention Rate The percentage as expressed
(6 months)
by the total number of
completers from the last two
quarters of the prior reporting
period (e.g. April 1st thru
September 30th) and the first
two quarters of the current
decimal(11,0)
reporting period (e.g., October
st
st
1 thru March 31 ) still
employed with their IRAP
provider 6 months after
apprenticeship completion
during the current reporting
period divided by the total

6

SUM OF #1 AND #2 ABOVE

VALUE (#)

#5 DIVIDED BY #4 (%)

Confidential, Deliberative Draft
number of completers from the
above referenced two
reporting periods.

7.

Average Earnings

The total earnings of all
completers from the last two
quarters of the previous
reporting period (e.g., April 1st
thru September 30th) and the
first two quarters of the
current reporting period (e.g.,
decimal(11,0)
October 1st thru March 31st)
divided by the total number of
completers from the
referenced two reporting
periods.
Average Earnings of all
Completers in #4
12 Months Post Completion IRAP Measure or Data Element
IRAP
Performance Measure/Data
Performance Measure
Element Name
Proposed Definition
Number of completers from
1. Number of Completers
the previous period
int(11)
(previous period)
2.

VALUE ($)

Data Type

VALUE PROVIDED FROM PREVIOUS YEAR
REPORT (TABLE B. LINE #7)

12 month completers

Number of completers in #1
(12 month completers)
employed with their IRAP
provider 12 months after
int(11)
apprenticeship completion
during the current reporting
period
3. Employment Retention Rate The percentage as expressed
(12 month post completion)
by the total number of
completers still employed with
their IRAP provider 12 months
after apprenticeship
completion during the current decimal(11,0)
reporting period divided by the
total number of completers
from the current reporting
period.

C. IRAP Demographic Information (submitted annually)
IRAP Provider Contact Info and Status
IRAP
SRE/IRAP Performance
Performance Measure
Measure/Data Element Name
Proposed Definition
Sex
1.

Male

Formula

VALUE (#)

#2 DIVIDED BY #1

Data Type

Male flag

Domain & Range

0,1,null
varchar(1)

2.

Female

Female flag

0,1,null
varchar(1)

3.

Blank/Other

Blank/Other flag

0,1,null
varchar(1)

Race

7

Confidential, Deliberative Draft

1.

2.

American Indian or Alaska American Indian or Alaska Native flag
Native
Asian

0,1,null
varchar(1)

Asian flag

0,1,null
varchar(1)

3.

Black or African American

Black or African American flag

0,1,null
varchar(1)

4.

Native Hawaiian or other
Pacific Islander

Native Hawaiian or other Pacific Islander
flag
varchar(1)

0,1,null

5.

White

White flag

0,1,null
varchar(1)

6.

Two or more races

Two or more races flag

0,1,null
varchar(1)

7.

Blank /Other

Blank /Other flag

0,1,null
varchar(1)

Ethnicity

8.

Hispanic or Latino

Hispanic Latino flag

0,1,null
varchar(1)

9.

Not Hispanic or Latino

Not Hispanic Latino flag

0,1,null
varchar(1)

8