Fannames Data Source

In this section:

The Fannames data source contains email, address, and telephone information for all fans in a fan club.

Fannames Master File

FILENAME=FANNAMES, SUFFIX=FOC
SEGNAME=CUSTOMER, SEGTYPE=S1
 FIELD=SSN,             ALIAS=SSN,        FORMAT=A11,           $
 FIELD=LASTNAME,        ALIAS=LASTNAME,   FORMAT=A10,           $
 FIELD=FIRSTNAME,       ALIAS=FIRSTNAME,  FORMAT=A8,            $
 FIELD=COMPANY,         ALIAS=COMPANY,    FORMAT=A12,           $
 FIELD=ADDRESS,         ALIAS=ADDRESS,    FORMAT=A20,           $
 FIELD=CITY,            ALIAS=CITY,       FORMAT=A10,           $
 FIELD=STATE            ALIAS=STATE,      FORMAT=A2,            $
 FIELD=ZIP,             ALIAS=ZIP,        FORMAT=A5,            $
 FIELD=PHONE,           ALIAS=PHONE,      FORMAT=A15,           $
 FIELD=EMAIL,           ALIAS=EMAIL,      FORMAT=A20,           $
 FIELD=TITLE,           ALIAS=TITLE,      FORMAT=A4,            $
 FIELD=USER,            ALIAS=USER,       FORMAT=A9,            $

Fannames Structure Diagram


Fannames structure diagram