IC2 - Training Provider Registration

Data Table

Data Field (Name)

Categorical Responses (if applicable)

Data Field (Brief Description)

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.

ENTITY

ENTITY_FILING_REASON

An indication of why an entity has logged onto to the TPR
and is either adding new records or modifying existing
records.

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

ENTITY

ENTITY_MAILING_CITY

The street number and name, or P.O. Box, of the
mailing address (Line 2 of 2, if necessary), for a given
entity.
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.

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_CITY

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

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.

Data Table

Data Field (Name)

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.

●
●
●
●
●

New request for listing on the TPR
Biennial update
Change(s) to key information (other than during biennial update)
Reapplication (after removal from TPR)
Out of Business notification

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.

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.

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.

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.
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_ADDRESS_LINE2

The street number and name of the physical address (Line
2 of 2, if necessary), 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.

LOCATION

LOCATION_PHYSICAL_CITY

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

LOCATION

LOCATION_PHYSICAL_STATE

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

LOCATION

LOCATION_PHYSICAL_ZIPCODE

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

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

LOCATION

LOCATION_RECORDS_ZIPCODE

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

Data Table

Data Field (Name)

Data Field (Brief Description)

Categorical Responses (if applicable)

Additional Notes

LOCATION

LOCATION_TYPE_IN-HOUSE

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

LOCATION

LOCATION_TYPE_NOT-IN-HOUSE

A location at which an entity trains entry-level drivers that Yes or No
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 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 a for-hire Yes or No
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

Data Table

Data Field (Name)

Yes or No

Data Field (Brief Description)

Categorical Responses (if applicable)

LOCATION

LOCATION_AFFILIATION_NAPFTDS

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

Yes or No

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 Yes or No
Driver Institute (PTDI).

LOCATION

LOCATION_AFFILIATION_SDLA

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

Yes or No

LOCATION

LOCATION_AFFILIATION_STATE_DOT

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

Yes or No

LOCATION

LOCATION_AFFILIATION_STATE_ED

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

Yes or No

LOCATION

LOCATION_AFFILIATION_STATE_LICENSING

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

LOCATION

LOCATION_AFFILIATION_JOINT_LM

The training location is affiliated with a joint labormanagement organization or union.

Yes or No

LOCATION

LOCATION_AFFILIATION_JOINT_LM

The training location is not subject to any additional
oversight

None

LOCATION

LOCATION_AFFILIATION_OTHER

Other accreditation or certification organization (specify)

Yes or No

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.

Data Table

Data Field (Name)

Data Field (Brief Description)

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.

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 a given
curriculum at a given location

●
●
●
●
●

CURRICULUM

THEORY_FORMAT

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.
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).

CURRICULUM

BTW_HOURS

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.
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).

CURRICULUM

TUITION

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).

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 theory element.
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).