IFAST File Formats

IFAST File Formats

IFAST provides files in Excel format to allow incorporation of IFAST databases into other software by IFAST members. Every assignee of an IRM or SID code can become an IFAST member upon application without paying a fee. Other industry organizations or individuals with a legitimate interest in IFAST activities can become a member upon application and upon paying an annual fee. Please contact the IFAST Secretariat for more information on membership.

Conventions for the file format are:

Th first column indicates the Excel column letter and the field name shown in row 1 of the file.

The second column describes the field.

Fields are optional (i.e. may be blank) unless it is stated that they are mandatory or some condition for their inclusion is given.

If a mandatory field is blank then the value from the preceding record with a non-blank value is applicable.

The IFAST file formats are:

International Roaming MIN (IRM)

System Identification Number (SID)

IRM (International Roaming MIN

Column	Data
A: IRM	The four digit IRM code. Mandatory.
B: IRM_Status	The status of an IRM (Assigned, Reserved, Unassigned, Dormant, Conflict, Invisible). Mandatory.
C: Application_status	The status of an application (Pending, Internally Reviewed, External Review) if one is in progress.
D: Application_Type	The type of an application (Assignment, Reservation, Withdrawal, Return, Change).
E: Application_Date	The date that an application was processed in the format MM/DD/YYYY.
F: Carrier_billing	The name of an operator used within IFAST. Mandatory if IRM is assigned.
G: Carrier_alternate	The name of an operator for publication on the website. If blank the 'Carrier_billing' is used.
H: Country	The name of the country in which the operator provides service or another indication of the purpose of the code (e.g. 'Worldwide').
I: Technology	The type of radio technology (AMPS, CDMA, TDMA or Satellite).
J: Frequency	The frequency of radio technology (700 MHz, US 800, US 800 A, US 800 B, PCS 1900, TACS 900, Japan 800, Korea PCS 1800, NMT 450, 2 GHz, PCS 1800, GSM 1900, PAMR 400, PAMR 800, AWS 1700 2100, US 800+1900, Korean 800+1800, 450+800, Various).
K: Expiry	The date on which IFAST annual maintenance fee payments expire (or expired).
L: Company::Address Street	The street address of the assignee.
M: Company::Address City	The city of the assignee.
N: Company::Address State	The state, province or other region of the assignee.
O: Company::Address Postal Code	The zip or other postal code of the assignee.
P: Company::Address Country	The country of the assignee.
Q: Company::Address Phone	The phone Number of the assignee.
R: Company::Address Fax	The fax number of the assignee.
S: Company::Address Email	The email address of the assignee.
T: Company::Address URL	The URL (website address) of the assignee.

SID (System Identification Number)

Column	Data
A: SID (Low)	The starting SID number of a range. Mandatory.
B: SID (High)	The ending SID number of a range. If not present the range only has one SID code.
C: Quantity	The number of SID codes in the range. Mandatory.
D: SID Type	Whether broadcast in one country or more than one (National, International). Mandatory.
E: Current SID State	The current state of a SID (Unassigned, Pending, Paid, Under Review, Assigned, Reserved, Grandfathered, Conflict, National Assignment, BID, Being Reclaimed, Returning, Dormant). Mandatory.
F: Proposed SID State	If an application is in progress this field will have the proposed new state, using one of the values applicable to the previous field.
G: Conflicting Carrier	The name of an operator using this range of SID codes without approval.
H: Conflicting Country	The name of the country in which the unauthorized use is occurring.
I: Created	The date that this SID record was created.
J: Assignee Name	The name of the assigned operator or other organization.
K: Frequency	The frequency of radio technology (700 MHz, US 800, US 800 A, US 800 B, PCS 1900, TACS 900, Japan 800, Korea PCS 1800, NMT 450, 2 GHz, PCS 1800, GSM 1900, PAMR 400, PAMR 800, AWS 1700 2100, US 800+1900, Korean 800+1800, 450+800, Various).
L: Technology	The type of radio technology (AMPS, CDMA, TDMA or Satellite).
M: Street Address	The street address of the assignee.
N: City	The City of the assignee.
O: State	The state, province or other region of the assignee.
P: Postal Code	The zip or other postal code of the assignee.
Q: Phone	The phone number of the assignee.
R: Fax Number	The fax number of the assignee.
S: Email	The email address of the assignee.
T: URL	The URL (website address) of the assignee.
U: Region	One region in which this SID range is used. If there are multiple regions preceding fields will be blank for all but the first region.
V: License ID	The license identification associated with this region, if known.
W: Call Sign	The call sign associated with this region, if known.
X: License Holder	The name of the license holder, if not the same as the overall assignee.
Y: NID	The NID associated with this region, if known.