6.17 Configuring Transmitter Record for E-File

The first record on each E-File must be the Transmitter Record and to provide this the corresponding table is KDD_TRANSMITTER. This table contains information identifying the batch file transmitter (person or organization handling the data accumulation and formatting). There will be only one transmitter record in the table. All data elements for this record are required.

Table 6-7 KDD_TRANSMITTER table Attributes

Column Name	Description
TRNSMTR_NM	Client Company Name (Static)
TRNSMTR_ADDR_STRT_TX	Client Company Address (Static)
TRNSMTR_ADDR_CITY_NM	Client Company City (Static)
TRNSMTR_ADDR_STATE_CD	Client Company State (Static)
TRNSMTR_ADDR_POSTL_CD	Client Company ZIP Code (Static)
TRNSMTR_ADDR_CNTRY_CD	Client Company Country (Static)
TRNSMTR_PHON_NB	Client Company Telephone Number(Static)
TRNSMTR_CNT_NM	Client Company Contact Name for CTR (Static)
TRNSMTR_TAX_ID	Client Company TIN (Static)
TRNSMTR_CNTRL_CD	8-character Transmitter Control Code
CNT_OFFICE_NM	Name of the office to contact for information concerning the BSA CTR
PHON_NB	Contact office phone number
PHON_EXT_NB	Contact office phone extension

In order to insert a record in the KDD_TRANSMITTER table, execute the following query in the Atomic schema

INSERTINTO KDD_TRANSMITTER
TRNSMTR_NM,TRNSMTR_ADDR_STRT_TX, TRNSMTR_ADDR_CITY_NM, TRNSMTR_ADDR_STATE_CD,
TRNSMTR_ADDR_POSTL_CD, TRNSMTR_ADDR_CNTRY_CD, TRNSMTR_PHON_NB, TRNSMTR_CNT_NM,
TRNSMTR_TAX_ID, TRNSMTR_CNTRL_CD, CNT_OFFICE_NM, PHON_NB,
PHON_EXT_NB)VALUES('<Name>','<Address>', '<City>', '<State>',<PostalCode>, 
'<Country>',<Phone Number>, '<ContactName>',<CompanyTIN>,<TransmitterCode>,
'<ContactOffice Name>',<ContactOffice Phone Number>,<ContactOffice Extension>);
 COMMIT;