The IANA IDD initally needs a full driver file then only files with driver records changed/added. Frequency of updates is up-to-you.

IANA IDD will receive plain text files via FTP in Fixed Column format. FTP server prefers filenames in 8.3 format (eg yyddhhmm.txt) or send with FTP "UNIQUE" command.

* = mandatory data

o = optional data, may be blank filled

x = may be blank but system will fill

*	SCAC	4	SCAC code for driver (your company)
X	DV_REF	10	If you use internal driver #, We'll fill with 1st 10 characters of drivers license if blank
*	DSP_OFFICE	13	Dispatch Office number for this driver (xxx)xxx-xxxx
*	UP_RMP	5	UP code for ramp driver most likely
*	DV_HIRE	8	mmddccyy driver hired
*	DV_TERM	8	mmddccyy driver terminated or inactive Leave blank if driver active.
*	FIRSTNAME	20
*	MID	10
*	LASTNAME	20
*	LICENSE	20	License #s are edited internally to Upper Case and contain: 0-9 and A-Z and *.
*	LIC_STATE	2
*	LIC_CNTRY	3
*	LIC_EXPIRE	8
*	LIC_CDL	1	Y/N
x	HAZMAT_OK	1	Y/N    blank = N
x	DOUBLE_OK	1	Y/N    blank = N
x	TRIPLE_OK	1	Y/N    blank = N
x	TANKER_OK	1	Y/N    blank = N
o	SOCIAL_SEC	12
o	ADDRESS1	30
o	ADDRESS2	20
o	CITY	20
o	STATE	2
o	ZIP	10
o	PHONE	13
o	PHON2	13
m	DV_PIN	10	(See users guide for desciption.)
o	TRC_LIC	15	|
o	TRC_STATE	2	| -> Owner/Operator Tractor
o	TRC_RFID	15	|

Please note:

1. A unique record in the IDD is SCAC + License + License State. The upload process first looks for an existing record based on this key. If found each field in the IDD record is compared with the upload record if there is a difference the IDD record is updated with the fields in the upload record. If the key is not found in the IDD a new record is added.

This means that if you are corecting a drivers license and/or license state two update records must be send. The first with the existing information with DV_TERM filled in with a date. The second with the correct information would then add a new record.

If you are unable to do this when preparing an upload file then we recommend that you implement a manual procedure to terminated or delete the existing IDD record using the web based interface.

This delete/add is handled transparently when changing a license/license state in the web interface.

2. No check of the data is made when your file is uploaded. We recommend that you periodically use the web interface to check that all in the IDD is as you expect. There is the ability to download your records via the web interface.

3. The license and license state entry made via the web interface is checked for following the rules that each state uses for there numbers.

If a record is added/saved via the web interface and fails this test the user is notified and the record is NOT saved.

This check is NOT made when adding records via auto-updates.

This means that it is possible for a record in the IDD to be edited via the web interface and the user may not be able to be save the record until the license/license state is corrected.

To start testing, please send an e-mail with the subject line:
   "SCAC (your scac code), IDD Auto-update"
to the address below.

Thank you,

Martin Stefflre

mcs@uiia.org

---

Business non-technical questions to:

Debbie Sasko
debbie.sasko@intermodal.org

---

Below is the layout for a fixed column file:

	FIELD_NAME	FIELD_LEN	BEG_COL	END_COL
1	SCAC	4	1	4
2	DV_REF	10	5	14
3	DSP_OFFICE	13	15	27
4	UP_RMP	5	28	32
5	DV_HIRE	8	33	40
6	DV_TERM	8	41	48
7	FIRSTNAME	20	49	68
8	MID	10	69	78
9	LASTNAME	20	79	98
10	LICENSE	20	99	118
11	LIC_STATE	2	119	120
12	LIC_CNTRY	3	121	123
13	LIC_EXPIRE	8	124	131
14	LIC_CDL	1	132	132
15	HAZMAT_OK	1	133	133
16	DOUBLE_OK	1	134	134
17	TRIPLE_OK	1	135	135
18	TANKER_OK	1	136	136
19	SOCIAL_SEC	12	137	148
20	ADDRESS1	30	149	178
21	ADDRESS2	20	179	198
22	CITY	20	199	218
23	STATE	2	219	220
24	ZIP	10	221	230
25	PHONE	13	231	243
26	PHON2	13	244	256
27	DV_PIN	10	257	266
28	TRAC_LIC	15	267	281
29	TRC_STATE	2	282	283
30	TRC_RFID	15	284	298