DataProvider_v1 Field Name Data Type Key Required Default Parent Lookup Database Mapping(s) Comment Checks The unique identifier of the company or agency company_code Text(40) PK Y rt_company.company_code responsible for completion and submittal of any part of this EDD. company_type Text(20) Y SUBCONTRACTOR rt_company_type.company_type rt_company.company_type The type of company. The name of the data provider. May be more company_name Text(255) Y rt_company.company_name descriptive than company_code. The name of the data contact_name Text(50) rt_company.contact_name provider contact. The license number held license_nbr Text(50) rt_company.license_nbr by the data provider. The street address of the address_1 Text(40) rt_company.address_1 data provider, line one. The street address of the address_2 Text(40) rt_company.address_2 data provider, line two. The city of the data city Text(30) rt_company.city provider. The county of the data county Text(50) rt_company.county provider. The state of the data Text(10) MT rt_state.state_code provider. The country of the data country Text(50) USA rt_company.country provider. The zip code of the data postal_code Text(30) rt_company.postal_code provider. The phone number of the phone_number Text(30) rt_company.phone_number data provider. The alternate phone alt_phone_number Text(30) rt_company.alt_phone_number number of the data provider. The email address of the email_address Text(100) rt_company.email_address data provider. custom_field_1 Text(255) rt_company.custom_field_1 A custom field. custom_field_2 Text(255) rt_company.custom_field_2 A custom field. custom_field_3 Text(255) rt_company.custom_field_3 A custom field. custom_field_4 Text(255) rt_company.custom_field_4 A custom field. custom_field_5 Text(255) rt_company.custom_field_5 A custom field.
DataProvider_v1 Field Name Data Type Key Required Default Parent Lookup Database Mapping(s) Comment Checks company_code Text(40) PK Y rt_company.company_code The unique identifier of the company or agency responsible for completion and submittal of any part of this EDD. company_type Text(20) Y SUBCONTRACTOR rt_company_type.company_type rt_company.company_type The type of company. company_name Text(255) Y rt_company.company_name The name of the data provider. May be more descriptive than company_code. contact_name Text(50) rt_company.contact_name The name of the data provider contact. license_nbr Text(50) rt_company.license_nbr The license number held by the data provider. address_1 Text(40) rt_company.address_1 The street address of the data provider, line one. address_2 Text(40) rt_company.address_2 The street address of the data provider, line two. city Text(30) rt_company.city The city of the data provider. county Text(50) rt_company.county The county of the data provider. Text(10) MT rt_state.state_code The state of the data provider. country Text(50) USA rt_company.country The country of the data provider. postal_code Text(30) rt_company.postal_code The zip code of the data provider. phone_number Text(30) rt_company.phone_number The phone number of the data provider. alt_phone_number Text(30) rt_company.alt_phone_number The alternate phone number of the data provider. email_address Text(100) rt_company.email_address The email address of the data provider. custom_field_1 Text(255) rt_company.custom_field_1 A custom field. custom_field_2 Text(255) rt_company.custom_field_2 A custom field. custom_field_3 Text(255) rt_company.custom_field_3 A custom field. custom_field_4 Text(255) rt_company.custom_field_4 A custom field. custom_field_5 Text(255) rt_company.custom_field_5 A custom field.
e-TREADS_EDD_Manual.docx