Tank Car Integrated Database

Tank Car Integrated Database uses inspection templates to accurately report cracks found in the stub sill attachment welds. Each template lists the welds of its corresponding stub sill design, assigns each weld a weld code and lists the possible locations of each specific weld.

Choose the appropriate design template from the list below. If the exact template is not available, choose one that most closely emulates the design.

• ABCJKL Inspection Template
• ACF100 Inspection Template
• ACF200 Inspection Template
• ACF300 Inspection Template
• CHT001 Inspection Template
• DEFGHI Inspection Template
• Draft Sill Template
• EVAWBR Inspection Template
• Full Sill Inspection Template
• GAT020 Inspection Template
• GAT090 Inspection Template
• GAT097 Inspection Template
• GAT098 Inspection Template
• GAT102 Inspection Template
• GBR001 Inspection Template
• Generic Body Bolster Template
• Generic Head Brace Template
• Generic Saddle-Sump-Skid Template
• GULWBR Inspection Template
• GUN001 Template
• NSC001/002 Template
• RICWBR Inspection Template
• TEXTEX Template
• TRN1&2 Inspection Template
• TRN3 Inspection Template
• TRN4 Template
• TYT001 Inspection Template
• UTC Inspection Template

What is the Tank Car Integrated Database system?

The Tank Car Integrated Database (TCID) is designed to consolidate the information on the AAR forms R-1, R-2, SS-3, plus provide additional reporting features. Depending on user access, TCID provides the ability to create a new inspection, implement a batch import and edit, submit or delete an inspection. The TCID application is accessible at www.railinc.com.

Who uses the TCID system and what can they do?

Railroads, equipment owners, shops and third-party entities are the primary users of the TCID system. With TCID, users can:

• Create new inspections and view existing inspections
• Add inspection data to TCID by uploading a batch file
• View the Inspection Detail Report that shows details for a specific tank car inspection
• View the Inspection Summary Report that provides a list of all submitted inspections
• View the Service History by Company Report that provides all submitted inspections information within the database for the selected company

How do I access the TCID system?

You must have a Railinc Single Sign-On (SSO) account and access to TCID to use the TCID system. If you already have an SSO account, you do not need to create a new one and can skip Step 1:

1. To create an SSO, go to www.railinc.com. The SSO login is located at the top, right of the page. Click Register Here and follow the prompts to establish your account. You will receive an email confirmation of your profile, which you must verify within 14 days to unlock your account. More information on creating a Railinc user ID is available here.
2. To request access to TCID, log into www.railinc.com with your SSO ID and select View/Request Permissions and then select the Request button for Tank Car Integrated Database. Select the applicable role under your Company ID or Mark and submit the request.

What if I don't have a Company ID or Mark?

If you are not an existing Railinc customer and do not have a Company ID or Mark you will need to register for a reporting mark or Railinc Company ID using the Railinc Onboarding Application. There is a one-time setup charge for registering a company ID with Railinc. If you already have a reporting mark or Railinc Company ID, you do not need to register again.

What roles do I need to request access to the TCID system?

TCID is a role-based application that requires a Company ID or MARK to request permissions. Choose from these four roles:

• Tank Car Inspection AAR Member
  • Tank Car Inspection AAR Members can access TCID across all company marks. This permission allows users to view all submitted data regardless of company or facility submission but does not allow entering data.
• Tank Car Inspection Company Administrator
  • Company-specific administrator access allows users to grant user access to TCID on behalf of their company. This permission does not allow entering or viewing any data and is typically included with Tank Car Inspection Owner Delegate permissions. This role was previously named "Member" in the Sims TCID application.
• Tank Car Inspection Facility User
  • Tank Car Inspection Facility access allows users to create, edit, and submit inspections and provides authority to enter facility-specific data and view their own submissions. This role was previously named "Delegate" in the Sims TCID application.
• Tank Car Inspection Owner Delegate
  • Company-specific Car Owner or Delegate access allows users to enter data and view all their company submissions. This role was previously named “Car Owner” in the Sims TCID application.

What is a Company Administrator (Admin)?

The Company Admin is responsible for responding to requests for access to a specific application. More information on the Company Admin role is available here.

What if I'm an FTP Customer?

If you submit files via FTP and do not already have an FTP mailbox with Railinc, you may request a mailbox by sending the following information to Railinc's Customer Success Center at csc@railinc.com:

    Please set up FTP Mailbox for:

        Customer Name:
        MARK:
        Mailbox:
        Test or Production:
        Company Name:
        Address:
        Phone:
        Email:
        Application: TCID

Can I receive email notifications?

To receive email notifications on FTP submissions, request access to FindUs.Rail on www.railinc.com or add the TCID category to an existing FindUs.Rail contact. More information regarding FindUs.Rail is available here.

Will existing customers have to re-enter their data?

No. Railinc is focused on making the transition to the Railinc TCID system as seamless as possible for customers. Railinc is migrating existing TCID data to the new system so that existing users do not have to re-enter existing data.  To properly map prior inspections, Railinc requires your original Sims PE login ID (email address) along with your Railinc SSO ID.

What is the implementation date for the TCID system upgrade?

The implementation date for the TCID system upgrade is November 13, 2018.

Where can I find TCID documentation and other TCID resources?

Documentation including an TCID User Guide, TCID Data Specification Manual and other supporting documentation is available here.

What if I have questions about the TCID system?

Railinc Customer Success Center is available to answer your questions. For more information about the TCID system, contact Railinc’s Customer Support Center toll free at (877) 724-5462 or via email at csc@railinc.com.

History of Implementation Notices

Notification ID	Notice Date	Target Imp Date	Actual Imp Date	Description	Files Affected
NOI_0013	Nov 14, 2019	Nov 21, 2019	Nov 21, 2019	EIN Integration for increased report visibility. Enhanced Reporting tools to begin returning entire inspection histories on a car. Enhanced “View Inspections” screen to show the most recent 100,000 inspections instead of the most recent 500. Added, removed, or renamed permissible values for Weld and Shell/Sill sections. CSV upload now allows for bulk delete in addition to bulk submission. New error email attachment for easier error resolution. Integration with Umler to allow for value conflicts to be identified. New and Updated Documentation: TCID Data Specification Manual, TCID User Guide, Data Dependencies Matrix, Stub Sill Reporting Matrix, Theme 3 Value Changes, TCID Batch File Example, and AAR TCID Form.
NOI_0012	Feb 7, 2019	Feb 12, 2019	Feb 12, 2019	Warnings on fields "Inspection Date Compartment No.", "Change Category", "Drawing No.", "AAR Approval Ref. No.", and "Drawing Comments" have been changed to Errors. Service History by Company reports have been enhanced to report all inspections. Padding Equipment Numbers with leading zeroes so that all inspection records appear. New and updated documentation: TCID Data Specification Manual, AAR Form TCID, December Webinar and accompanying slides.
NOI_0011	Nov 13, 2018	Nov 13, 2018	Nov 13, 2018	TCID began hosting at Railinc with all prior data migrated from Sims PE TCID application. Permissible value changes of Failure Type "Corrosion–Random Pits" and "Corrosion–Grouped Pits" were added for all components in the Shell/Sill section and How Repair Weld values were changed to match How Repaired Sill values in the Weld section. Warning messages were added to optional fields. New and updated documentation: TCID User Guide, TCID Data Specification Manual, TCID Batch Example File, TCID Data Dependencies Matrix that includes all TCID Permissible Value Appendixes.
NOI_0010	Jun 15, 2018	Jun 16, 2018	Jun 16, 2018	The option for UTLZBT will be added to the list of available stub sill designs. This design has been added to the UTC template, and will have all the codes listed for other designs within the same template, as shown in the Stub Sill Design Reporting Matrix. The Sill Design Template Mapping document has also been updated.
NOI_0009	Jan 3, 2018	Apr 14, 2018	Apr 14, 2018	Several stub sill design templates are being updated. Attached are the new templates, an updated sill design mapping document, the new reporting matrix, and a list of changes included in this NOI.
NOI_0008	Dec 12, 2017	Mar 17, 2018	Mar 18, 2018	TCID will now allow for entering information for multi-compartment cars. A field is added to specify the number of compartments for each car, as well as which compartment is associated with each reported change or defect. For further details, refer to the updated User’s Manual and Batch Submission Specification. The TCID-1 form has also been updated to reflect these changes.
NOI_0007	Oct 8, 2017	Jan 15, 2018	Jan 15, 2018	Per request from the industry, the 'INSPNAME' and 'CAROWNERREP' field names in the batch upload are being changed to 'SUBMITTEDBY' and 'MANAGEMENTREP' respectively. The batch upload specification and batch upload example have already been modified to reflect this change.
NOI_0006	Jan 10, 2017	Apr 10, 2017	Apr 9, 2017	The “mileage” field of the TCID form will no longer accept a “0” value. For cars with unknown cumulative mileage, users should use an estimate. If no basis for the estimate is available, users should assume 18,000 miles per year the car has been in service.
NOI_0005	Jul 27, 2016	Oct 25, 2016	Oct 26, 2016	Two new templates, CHT001 and TYT001, are being added to the database. The Stub Sill Design dependency matrix is changing accordingly, and a list of the changes is attached.
NOI_0004	Jul 22, 2016	Oct 20, 2016	Oct 25, 2016	Shell/Sill Damage dependency options are changing per the attached matrix and list of changes. Attachment Weld Inspection "How Repaired" options are changing per the attached list of changes. Also included are updated versions of the User's Manual, Batch Upload Spec, and Batch Upload Example.
NOI_0003	Apr 5, 2016	Jul 4, 2016	Jul 7, 2016	Several of the templates used for stub sill inspection reporting have been revised. This will affect the valid crack location codes for the corresponding stub sill designs. Please review the attached templates for the codes that will be accepted as of the implementation date for this notice.
NOI_0002	Mar 3, 2016	Jun 1, 2016	Jun 13, 2016	Revisions to car classification fields #4 – Stencil Class, #17 – Constructed Car Class, and #18 – Car Specification After Modification. The DOT designation will be removed from all 117 related codes. I.e. “DOT117A100W1” will become “117A100W1”.
NOI_0001	Jan 7, 2016	Apr 6, 2016	Apr 16, 2016	Revisions to car classification fields #4, #17, and #18 based on CPC-1319.