PAF Software Documentation

PAF SOFTWARE

DOCUMENTATION

Contents

Introduction. 2

Database modules. 2

PAF user menu. 3

Loading a PAF update CD: 3

PAF Configuration file: 3

Change1. 4

Change2. 4

Change to change2 parameter file. 4

PAF file layouts. 5

FILE: ADDRESS. 5

PAF account: file and index list. 6

PAFreports account: file list. 7

QVSpaf account: file list. 7

Introduction

The PAF database is supplied by the Post Office and is the UK post code address database, comprising of both UK residential and commercial postal addresses.

The PAF database is imported into the UniVision DBMS from fixed length ASCII files supplied from the UK post office.

Database modules.

1) PAF account, main PAF database.

2) QVSpaf account, PAF software.

3) WEB.INTERFACE account, QVS web software.

4) PAFreports account, PAF users and monthly usage stats.

WEB.INTERFACE is the base Quantum VS software required by all Quantum VS enable packages.
PAF is the main data account all of the UK addresses are located here.
QVSpaf is the main software library for the PAF system.
PAFreports this account is a myViewpoint account password [f1asc0], this account also hold the users, passwords and clicks.

We have two webapp containers paf web service and mvppaf used by PAF users to monitor clicks.

PAF user menu

PostOffice Address File (PAF)

1) Run manual update process.
2) Verify PAF system.
3) List PAF user stat's.

T) UCL
O) OFF

Enter option :

Loading a PAF update CD:

1) From root mount the PAF update CDROM.

#mount /media/cdrom

PAF update uses the path /media/cdrom

2) Login into the UniVision PAF account and take option 1.

PAF Configuration file:

The configuration file QVSparameters in the PAF account has three items.

1) “update”, this is PAF update master record and points to the required change files.

2) “ change1”, this is the first change file referenced by the update software.

3) “change2”, this is the second change file referenced by the update software.

Change1.

>ED QVSparameters change1

change1
TOP
001 #
002 # Path to PAF update file "change 1" file.
003 #
004 UpdateFile]/media/cdrom/CPCHANGE.C01/changes1.c01
005 #
006 # Each update file in the change file has a file "ID"
007 # FileList is a list of value file "ID's" for this change

The second value on attribute 4 “UpdateFile” is the path and file name used by the update software, this is also true for change2, but the file name will differ.

Change2.

>ED QVSparameters change2

change2
TOP
001 #
002 # Path to PAF update file "change 2" file.
003 #
004 UpdateFile]/media/cdrom/CPCHANGE.C01/fpchngs2.c01
005 #
006 # Each update file in the change file has a file "ID"
007 # FileList is a list of value file "ID's" for this change
008 # file.
009 #

Change to change2 parameter file.

The Post Office change the name on the third update CDROM, the name changed from fpchngs2.c01 to fpchng2.c01, they ”The Post Office” removed the “s” from the name.

PAF file layouts.

FILE: ADDRESS

FIELD NAME	LEVEL	DATA TYPE	SIZE	OCCURS	ADDRESS Attribute
Postcode Type	1	Alphanumeric	1	1	0
*Organisation Key*	1	Numeric	8	1	0
Address Key	1	Numeric	8	1	0
Postcode Outcode	2	Alphanumeric	4	1	1
Postcode Incode	2	Alphanumeric	4	1	2
*Locality Key*	1	Numeric	6	1	3
*Thoroughfare Key*	1	Numeric	8	1	4
*Thoroughfare Descriptor Key*	1	Numeric	4	1	5
Dependent Thoroughfare Key	1	Numeric	8	1	6
Dependent *Thoroughfare* *Descriptor Key*	1	Numeric	4	1	7
*Building Number*	1	Numeric	4	1	8
*Building Name Key*	1	Numeric	8	1	9
*Sub* *Building* *Name Key*	1	Numeric	8	1	10
Number of Households	1	Numeric	4	1	11
Concatenation Indicator	1	Alphanumeric	1	1	12
Delivery Point Suffix	1	Alphanumeric	2	1	13
Small User Organisation Indicator	1	Alphanumeric	1	1	14
PO Box Number	1	Alphanumeric	6	1	15

Note:

The following fields “Organisation Key, Locality Key, Thoroughfare Key, Thoroughfare Descriptor Key, Dependent Thoroughfare Key, Dependent Thoroughfare Descriptor Key, Building Number, Building Name Key, and Sub Building Name Key” are either zero filled or they contain numeric data, so to reduce the size of the PAF database the import process applies a simple logical rule, “Data Field + 0”.

This reduces “0000” to “0”.

PAF account: file and index list.

Dictionary File names	Data and index file names (Diagnostic file names)
ADDRESS	ADDRESS
	INDEX\|ADDRESS\|DDLOCAL
	INDEX\|ADDRESS\|DLOCAL
	INDEX\|ADDRESS\|pafSearch
	INDEX\|ADDRESS\|POSTCODE
	INDEX\|ADDRESS\|POSTTOWN
	INDEX\|ADDRESS\|ThoroughFare
	(VINDEX\|ADDRESS\|ThoroughFare)
	(VINDEX\|ADDRESS\|DDLOCAL)
	(VINDEX\|ADDRESS\|DLOCAL)
	(VINDEX\|ADDRESS\|pafSearch)
	(VINDEX\|ADDRESS\|POSTCODE)
	(VINDEX\|ADDRESS\|POSTTOWN)
BUILDING	BUILDING
LOCALITY	LOCALITY
MAILSORT	MAILSORT
MetaphoneFile	MetaphoneFile
ORGANISA	ORGANISA
pafTransactions	(ADDRESS)
	(audit)
	(BUILDING)
	(LOCALITY)
	(ORGANISA)
	(pafTransactions)
	(SUBBUILD)
	(THDESCRI)
	(THOROUGH)
QVSparameters	QVSparameters
QVSweb	QVScontrol
	QVSdebug
	QVSdebugInMessages
	QVSdebugOutMessages
	QVSprogIndex
	QVSsavedLists
	QVSsessions
	QVSsessionsWork
	QVSuniqueIds
	QVSweb
SUBBUILD	SUBBUILD
THDESCRI	THDESCRI
THOROUGH	THOROUGH

PAF account: Q pointer list.
File name Account name Real file name.

BP QVSpaf BP

BP.IF QVSpaf BP.IF

mvpAccountParameters PAFreports mvpAccountParameters

PAF-USERS PAFreports USERS

Param.org QVSpaf PafParam

PROCS QVSpaf PROCS

QFILE QVSpaf.new2 DICTS

QTHOR PAF THOROUGH

QVSapi WEB.INTERFACE QVSapiUtils.BP

QVSp QVSpaf QVSparameters

PAFreports account: file list.

Dictionary File names	Data and index file names
BP	BP
mvpAccountParameters	mvpAccountParameters
QVSmvp	QVScontrol
	QVSdebug
	QVSmvp
	QVSparameters
	QVSsavedLists
	QVSsessions
	QVSsessionsWork
	QVSsysMessages
	QVSuniqueIds
USERS	USERS

QVSpaf account: file list.

Dictionary File names	Data and index file names
BP	BP
BP.IF	BP.IF
BP.PAF	BP.PAF
BSYM	BSYM
DICTS	DICTS
PafParam	PafParam
pafTransactions	Audit
	pafTransactions
PROCS	PROCS
QVSmessages	QVSmessages
QVSparameters	QVSparameters
QVStestMessages	QVStestMessages
QVStimings	QVStimings
QVSweb.BP	QVSweb.BP
QVSweb.BPIF	QVSweb.BPIF
SAFE	SAFE
UNIX	UNIX

QVSpaf account: Q pointer list.
File name Account name Real file name.

DEV.BP WEB.INTERFACE DEV.BP

LISTFILES.QPTR QVSpaf_org

mvpAccountParameters PAFreports mvpAccountParameters

PB PAF BP

POINTER-FILE POINTER-FILE

PU PAF PAF-USERS

Q BENCH.ADMIN PROC

QFILE PAF ADDRESS

QVSapiUtils.BP WEB.INTERFACE QVSapiUtils.BP

QVStests.BP WEB.INTERFACE QVStests.BP

QVSweb PAF QVSweb

QVSwebI WEB.INTERFACE QVSweb

QVSwebUser.BPIF WEB.INTERFACE QVSwebUser.BPIF

SYSTEM SYSTEM

USERS PAF PAF-USERS