eLMS: owr_facility

Facilities associated with a specific application.

Return to eLMS

column

type

description

lms_application_id

varchar(32)

Primary index used for all applications.  Corresponds with the FCC’s application identifier used in LMS and therefore can be used to cross reference with FCC raw data.   Unless otherwise indicated, all relational tables in eLMS are linked by lms_application_id

facility_sequence

int

Used to distinguish specific facilities covered in an ownership report.

facility_group

int

Used to group stations owned by different entities that the respondent to the ownership report is associated with.  The name and FRN of the licensee/permittee can be obtained by associating this column with table owr_facility_group.

facility_id

int

Facility ID of associated station.

service_code

varchar(8)

Associated station’s service code.