PCPA_FTP_DATA_HELP

FTP_SITE File Layout

FIELD NAME

DESCRIPTION

TYPE

ACCOUNT_ID

8 digit tangible account number

VARCHAR(12)

LN_NUM

This number uniquely identifies each tangible site address

INT

STR_NUM

Street Number

INT

STR_PFX

Street Prefix

VARCHAR(3)

STR

Street Name

VARCHAR(50)

STR_SFX

Street Suffix

VARCHAR(25)

STR_SFX_DIR

Street Suffix Direction

VARCHAR(2)

STR_BLD

Street Building

VARCHAR(10)

STR_UNIT

Street Unit

VARCHAR(15)

CITY

City

VARCHAR(50)

ZIP

Zip Code

VARCHAR(10)

COUNTY

County

VARCHAR(50)