eLMS: owr_family

One entry per family member.

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

family_sequence

int

Sequence of family relationships within an application ID.

frn1

varchar(11)

FRN of first family member.

name1

varchar(80)

Name of first family member.

frn2

varchar(11)

FRN of second family member.

name2

varchar(80)

Name of second family member.

relationship

varchar(1)

Familial relationship: [M]=spouses, [P]arent-child, [S]ibling.