IC2 - Training Provider Registration

Entry-Level Driver Training (ELDT), Training Provider Registry (TPR)
Training Provider Registration Process, Data Tables & Data Fields
Data Table

Data Field (Name)

Data Field
(Brief Description)

Categorical Responses
(if applicable)

Additional Notes

ENTITY table (each unique record in this ENTITY table relates to at least one, and possibly more than one, record in the LOCATION table below)
ENTITY

ENTITY_ID

A unique ID assigned by FMCSA to a training
entity.

Each business entity, organization, company, motor carrier, individual person, etc., that owns, controls, or is responsible for one or more
training locations will have its own unique record in this ENTITY table.
This ENTITY_ID will be a numeric or alphanumeric that is unique to a given entity.
This ENTITY_ID will serve as the prefix component to one or more LOCATION_ID records in the LOCATION table (below). The combination
of an ENTITY_ID prefix, and a LOCATION_ID suffix, will uniquely identify an individual training location among all others nationwide with an
ENTITY_LOCATION_ID.

ENTITY

ENTITY_FILING_REASON

An indication of why an entity has logged onto to ● New request for listing on the TPR
the TPR and is either adding new records or
● Biennial update
modifying existing records.
● Change(s) to key information (other than during biennial update)
● Reapplication (after removal from TPR)
● Out of Business notification

ENTITY

ENTITY_LEGAL_NAME

Legal name, for a given entity.

ENTITY

ENTITY_DBA_NAME

Doing business as (DBA) name, for a given
entity.

ENTITY

ENTITY_MAILING_ADDRESS_LINE1

The street number and name, or P.O. Box, of the
mailing address (Line 1 of 2), for a given entity.

ENTITY

ENTITY_MAILING_ADDRESS_LINE2

The street number and name, or P.O. Box, of the
mailing address (Line 2 of 2, if necessary), for a
given entity.

ENTITY

ENTITY_MAILING_CITY

The city of the mailing address, for a given entity.

ENTITY

ENTITY_MAILING_STATE

The State (two-character postal code) of the
mailing address, for a given entity.

ENTITY

ENTITY_MAILING_ZIPCODE

The Zip Code of the mailing address, for a given
entity.

ENTITY

ENTITY_PHYSICAL_ADDRESS_LINE1

The street number and name of the physical
address (Line 1 of 2), for a given entity.

If the physical address of the entity is the same as the mailing address entered above, provide an option for the respondent to indicate that
this is so, and then automatically populate the "physical address" data fields with the "mailing address" data fields information entered above.
Unlike the mailing address above, no P.O. Box should be entered here, as this is the physical address of the entity.

ENTITY

ENTITY_PHYSICAL_ADDRESS_LINE2

The street number and name of the physical
address (Line 2 of 2, if necessary), for a given
entity.
The city of the physical address, for a given
entity.

ENTITY

ENTITY_PHYSICAL_CITY

ENTITY

ENTITY_PHYSICAL_STATE

The State (two-character postal code) of the
physical address, for a given entity.

ENTITY

ENTITY_PHYSICAL_ZIPCODE

The Zip Code of the physical address, for a given
entity.

Unlike the mailing address above, no P.O. Box should be entered here, as this is the physical address of the entity.

Page 001 of 6

Entry-Level Driver Training (ELDT), Training Provider Registry (TPR)
Training Provider Registration Process, Data Tables & Data Fields
Data Table

Data Field (Name)

Data Field
(Brief Description)

ENTITY

ENTITY_PRIMARY_PHONE

The primary telephone number , for a given
entity.

ENTITY

ENTITY_PRIMARY_FAX

The fax number (if any), for a given entity.

ENTITY

ENTITY_PRIMARY_WEBSITE

The primary website (if any), for a given entity.

ENTITY

ENTITY_PRIMARY_EMAIL

The primary email address (if any) for official
point of contact, for a given entity.

ENTITY

ENTITY_USDOT_NUMBER

If the training entity is also a motor carrier that
has a USDOT number, enter that USDOT
number (if applicable).

ENTITY

ENTITY_FTA_NTD_ID

If the training entity is also a public transit agency
that receives funding from the Federal Transit
Administration (FTA) and therefore has been
assigned a unique National Transit Database
(NTD) ID number by FTA, enter that FTA NTD ID
number (if applicable).

ENTITY

ENTITY_ED_NCES_DISTRICT_ID

If the training entity is also a public school district
that provides its own directly operated school
bus transportation, enter the U.S. Department of
Education National Center for Education
Statistics (NCES) Public School District NCES ID
number (if applicable).

Categorical Responses
(if applicable)

Additional Notes

LOCATION table (each unique record in the ENTITY above relates to at least one, and possibly more than one, record in this LOCATION table)
LOCATION

LOCATION_ID

A unique ID assigned by FMCSA to a given
location for a given training entity.

Each physical location where training is performed will have its own unique record in this LOCATION table.
Each ENTITY above will relate to one or more location record(s) in this LOCATION table, in a “one-to-one” relationship when a single
ENTITY provides training at only a single LOCATION, or in a “one-to-many” relationship when a single ENTITY provides training at more than
one LOCATION.
This LOCATION_ID will be a numeric or alphanumeric that is unique to a given LOCATION for a given ENTITY.
This LOCATION ID will serve as the suffix component to one ENTITY_ID in the ENTITY table above. The combination of an ENTITY_ID
prefix, and a LOCATION_ID suffix, will provide a complete alphanumeric identifier that is unique to an individual training location among all
others nationwide.

LOCATION

ENTITY_LOCATION_ID

A concatenation of the ENTITY_ID for the
training entity (from the ENTITY table above), a
separation character such as a dash "-", and the
LOCATION_ID generated above for the unique
location for a given entity.

LOCATION

LOCATION_LEGAL_NAME

Legal name, for a given location, for a given
entity.

LOCATION

LOCATION_MAILING_ADDRESS_LINE1

LOCATION

LOCATION_MAILING_ADDRESS_LINE2

The street number and name, or P.O. Box, of the
mailing address (Line 1 of 2), for a given
location, for a given entity.
The street number and name, or P.O. Box, of the
mailing address (Line 2 of 2, if necessary), for a
given location, for a given entity.

This combination of the ENTITY_ID and LOCATION_ID will provide a complete alphanumeric identifier that is unique to an individual training
location among all others nationwide.

Page 002 of 6

Entry-Level Driver Training (ELDT), Training Provider Registry (TPR)
Training Provider Registration Process, Data Tables & Data Fields
Data Table

Data Field (Name)

Data Field
(Brief Description)

Categorical Responses
(if applicable)

Additional Notes

LOCATION

LOCATION_MAILING_CITY

The city of the mailing address, for a given
location, for a given entity.

LOCATION

LOCATION_MAILING_STATE

LOCATION

LOCATION_MAILING_ZIPCODE

The State (two-character postal code) of the
mailing address, for a given location, for a given
entity.
The Zip Code of the mailing address, for a given
location, for a given entity.

LOCATION

LOCATION_PHYSICAL_ADDRESS_LINE1

The street number and name of the physical
address (Line 1 of 2), for a given location, for a
given entity.

If the physical address of the training location is the same as the mailing address entered above, provide an option for the respondent to
indicate that this is so, and then automatically populate the "physical address" data fields with the "mailing address" data fields information
entered above.

LOCATION

LOCATION_PHYSICAL_ADDRESS_LINE2

Unlike the mailing address above, no P.O. Box should be entered here, as this is the physical address of the training location.

LOCATION

LOCATION_PHYSICAL_CITY

The street number and name of the physical
address (Line 2 of 2, if necessary), for a given
location, for a given entity.
The city of the physical address, for a given
location, for a given entity.

LOCATION

LOCATION_PHYSICAL_STATE

LOCATION

LOCATION_PHYSICAL_ZIPCODE

LOCATION

LOCATION_PRIMARY_PHONE

The primary telephone number , for a given
location, for a given entity.

LOCATION

LOCATION_PRIMARY_FAX

The fax number (if any), for a given location, for a
given entity.

LOCATION

LOCATION_RECORDS_ADDRESS_LINE1

The street number and name of the physical
address (Line 1 of 2) where records are retained,
for a given location, for a given entity.

LOCATION

LOCATION_RECORDS_ADDRESS_LINE2

The street number and name of the physical
address (Line 2 of 2, if necessary) where records
are retained, for a given location, for a given
entity.

LOCATION

LOCATION_RECORDS_CITY

The city of the physical address where records
are retained, for a given location, for a given
entity.

LOCATION

LOCATION_RECORDS_STATE

The State (two-character postal code) of the
physical address where records are retained, for
a given location, for a given entity.

LOCATION

LOCATION_RECORDS_ZIPCODE

The Zip Code of the physical address where
records are retained, for a given location, for a
given entity.

Unlike the mailing address above, no P.O. Box should be entered here, as this is the physical address of the training location.

The State (two-character postal code) of the
physical address, for a given location, for a given
entity.
The Zip Code of the physical address, for a given
location, for a given entity.

Page 003 of 6

Entry-Level Driver Training (ELDT), Training Provider Registry (TPR)
Training Provider Registration Process, Data Tables & Data Fields
Data Table

Data Field (Name)

Data Field
(Brief Description)

Categorical Responses
(if applicable)

LOCATION

LOCATION_TYPE_IN-HOUSE

A location at which an entity trains its own
employee entry-level drivers or prospective
employee entry-level drivers with its own inhouse training staff.

LOCATION

LOCATION_TYPE_NOT-IN-HOUSE

Yes or No
A location at which an entity trains entry-level
drivers that are not its own employee entry-level
drivers or prospective employee entry-level
drivers.

LOCATION

LOCATION_TYPE_FOR-HIRE

A location open to anyone who seeks entry-level Yes or No
CDL driver training and that charges tuition or a
fee for providing this training.

LOCATION

LOCATION_TYPE_NOT-FOR-HIRE

A location that does not make itself available on Yes or No
a for-hire basis to anyone who seeks entry-level
CDL driver training.

LOCATION

LOCATON_TYPE_TRAINING_SCHOOL

Yes or No

LOCATION

LOCATON_TYPE_ED_INSTITUTION

Yes or No

LOCATION

LOCATON_TYPE_RURAL_ELEC_COOP

Yes or No

LOCATION

LOCATON_TYPE_MOTOR_CARRIER

Yes or No

LOCATION

LOCATON_TYPE_STATELOCALGOVT

Yes or No

LOCATION

LOCATON_TYPE_SCHOOL_DISTRICT

Yes or No

LOCATION

LOCATON_TYPE_JOINT_LM

Yes or No

LOCATION

LOCATON_TYPE_OWNEROPERATOR

Yes or No

LOCATION

LOCATON_TYPE_INDIVIDUAL-NONMC

Yes or No

LOCATION

LOCATON_TYPE_OTHER

Yes or No

LOCATION

LOCATON_TYPE_OTHER_SPECIFY

Yes or No

Page 004 of 6

Additional Notes

Entry-Level Driver Training (ELDT), Training Provider Registry (TPR)
Training Provider Registration Process, Data Tables & Data Fields
Data Table

Data Field (Name)

Data Field
(Brief Description)

Categorical Responses
(if applicable)

LOCATION

LOCATION_AFFILIATION_NAPFTDS

The training location is a member of the National Yes or No
Association of Publicly Funded Truck Driving
Schools (NAPFTDS).

LOCATION

LOCATION_AFFILIATION_CVTA

The training location is a member of the
Commercial Vehicle Training Association
(CVTA).

Yes or No

LOCATION

LOCATION_AFFILIATION_PTDI

The training location is a member of the
Professional Truck Driver Institute (PTDI).

Yes or No

LOCATION

LOCATION_AFFILIATION_SDLA

The training location is subject to oversight from Yes or No
a State driver licensing agency.

LOCATION

LOCATION_AFFILIATION_STATE_DOT

The training location is subject to oversight from Yes or No
a State department of transportation.

LOCATION

LOCATION_AFFILIATION_STATE_ED

The training location is subject to oversight from Yes or No
a State education department.

LOCATION

LOCATION_AFFILIATION_STATE_LICENSING

The training location is subject to oversight from Yes or No
a State or local professional or vocational
licensing board.

LOCATION

LOCATION_AFFILIATION_JOINT_LM

The training location is affiliated with a joint labor- Yes or No
management organization or union.

LOCATION

LOCATION_AFFILIATION_OTHER

Other accreditation or certification organization
(specify)

LOCATION

LOCATION_AFFILIATION_OTHER_SPECIFY

Name of "other accreditation or certification
organization"

LOCATION

Certification attestation

An affirmative response from the respondent to
the certification statement language.

Yes or No

Additional Notes

If "Other" is indicated as "Yes" regarding third-party affiliation, details can be entered into the LOCATION_AFFILIATION_OTHER_SPECIFY
data field below.

Page 005 of 6

Entry-Level Driver Training (ELDT), Training Provider Registry (TPR)
Training Provider Registration Process, Data Tables & Data Fields
Data Table

Data Field (Name)

Data Field
(Brief Description)

Categorical Responses
(if applicable)

Additional Notes

CURRICULUM table (each unique record in the LOCATION table above relates to at least one record, and possibly up to 15 records, in this CURRICULUM table)
CURRICULUM

CURRICULUM_ID

A unique numeric ID, taking a value of between 1
to 15, that is assigned by FMCSA to each of the
up to 15 possible individual curricula that could
potentially be offered at a given training location.

Each of the up to 15 possible individual curricula that could potentially be offered at a given training location will have its own unique record in
this CURRICULUM table. A separate index table, such as the following, will be established such that the same numeric value is consistently
assigned for each of the 15 possible curricula that could potentially be offered. If, for example, the values shown below are used, then the
CURRICULUM_ID value of "15" would always be assigned in the CURRICULUM table to each "Hazardous Materials (Theory Only)
curriculum, provided at a given LOCATION, for a given ENTITY.
●
●
●
●
●
●
●
●
●
●
●
●
●
●
●

1: Class A (Theory & BTW)
2: Class A (Theory Only)
3: Class A (Class B to A Upgrade Theory & BTW)
4: Class A (Class B to A Upgrade Theory Only)
5: Class A (BTW Only)
6: Class B (Theory & BTW)
7: Class B (Theory Only)
8: Class B (BTW Only)
9: Passenger (Theory & BTW)
10: Passenger (Theory Only)
11: Passenger (BTW Only)
12: School Bus (Theory & BTW)
13: School Bus (Theory Only)
14: School Bus (BTW Only)
15: Hazardous Materials (Theory Only)

Each unique training location for a given entity from the LOCATION table above will relate to one or more curricula in the CURRICULUM
table, in a “one-to-one” relationship when a single LOCATION provides only one of the 15 possible curricula, or most likely in a “one-to-many”
relationship when a single LOCATION provides more than one of the 15 possible curricula.
CURRICULUM

ENTITY_LOCATION_CURRICULUM_ID

A concatenation of the ENTITY_ID for the
training entity (from the ENTITY table above), a
separation character such as a dash "-", the
LOCATION_ID for the unique location for a given
entity (from the LOCATION table above), another
separation character such as a dash "-", and the
CURRICULUM ID

This combination of the ENTITY_ID, LOCATION_ID, and CURRICULUM_ID, will provide a complete alphanumeric identifier that is unique to
an individual curriculum at a given training location for a given entity, among all others nationwide. For example, a "Hazardous Materials
(Theory Only)" curriculum, provided at the Denver, CO, location, of the entity "SAGE Truck Driving Schools", would be uniquely identified
among all other curricula nationwide by this ENTITY_LOCATION_CURRICULUM_ID value.

CURRICULUM

THEORY_HOURS

The average number of theory training hours, for ● 1 to 20
a given curriculum at a given location
● 21 to 40
● 41 to 60
● 61 to 80
● 81 or greater

This field is only applicable to curricula that include a theory element.

The format(s) in which theory training is
provided, for a given curriculum at a given
location.

● Online
● In-Person

This field is only applicable to curricula that include a theory element.

The average number of BTW training hours
(inclusive of both range and public road), for a
given curriculum at a given location.

● 1 to 20
● 21 to 40
● 41 to 60
● 61 to 80
● 81 or greater

This field is only applicable to curricula that include a BTW element.

The average tuition in U.S. dollars that is
charged, for a given curriculum at a given
location.

● $0 to $1,000
● $1,001 to $2,000
● $2,001 to $3,000
● $3,001 to $4,000
● $4,001 to $5,000
● $5,001 or greater

These categories should be mutually exclusive (i.e., only one can be selected for any given type of the 15 possible curricula that could be
offered).

CURRICULUM

CURRICULUM

CURRICULUM

THEORY_FORMAT

BTW_HOURS

TUITION

These categories should be mutually exclusive (i.e., only one of the categories can be selected for any given type of the 15 possible curricula
that could be offered).

These categories should not be mutually exclusive (i.e., either one, or both, can be selected). This will allow for situations in which a training
provider offers the option of either online, or in-person, theory training (which is a plausible scenario).

These categories should be mutually exclusive (i.e., only one of the categories can be selected for any given type of the 15 possible curricula
that could be offered).

Page 006 of 6