LICENCE PROOF SEAL BUNDLE FIELDS

Type

ADVICE

LICENCE_TYPE

Any type is fine

Licence Type

LICENCE_GROUP

Any type is fine

Licence Transaction Type

FIRST_IS_DATE

datetime null

First Issue Date

CURR_ISSUE_DATE

datetime null

Current Issue Date

AMOUNT_FEEPAID

money null

Total of Fees Paid

RENEWSENT_DATE

datetime null

Renewal Sent Date

START_DATE

datetime null

Current Start Date

END_DATE

datetime null

Current End Date

LICENCE_PERIOD

numeric(3,0) null

Licence Period

LICENCE_PERIODTYPE

Licence Period Type

LICENCE_DATE

char(1) null

D = Days
M = Months

LICENCE_STATUS

numeric(2,0) null

1 = Not Issued
2 = Current Registration
3 = Current Licence
10 = To Commence
11 = Renewal Sent
12 = In Progress
13 = Waiting Issue
14 = Hearing Set
15 = Issued
16 = Provisional

TRANSFER_DATE

datetime null

Transfer Date

VARIATION DATE

datetime null

Variation Date

REVISION_DATE

datetime null

Revision Date

REG_NAME

varchar(255) null

Registered Name - not sure if needed?? Not needed

FEEPAID_DATE

datetime null

Date of payment of last fee

ANNUALFEE_STARTDATE

datetime null

Annual Fee Start Date

ANNUALFEE_ENDDATE

datetime null

Annual Fee End Date

SUSP_DATEFROM

datetime null

Suspended From (only required if there is a current suspension)

SUSP_DATETO

datetimenull

Suspended To (only required if there is a current suspension)

SUSP_REASON

varchar(200)

Suspended Reason (only required if there is a current suspension)

SUSP_UPDATEDON

datetime null

Suspended Update Date (only required if there is a current suspension)

NOTE: “VEH” or “Vehicle” to be replaced by item name or licence type and attributes.

REGNO

varchar(10) null

Vehicle Licences Only - Registration Number

REG_DATE

datetime null

Vehicle Licences Only - Registered Date

VEH_MAKE

varchar(8) null

Vehicle Licences Only - Vehicle Make

VEH_MODEL

varchar(8) null

Vehicle Licences Only - Vehicle Model

VEH_COLOUR

varchar(8) null

Vehicle Licences Only - Vehicle Colour

VEH_FUEL

varchar(4) null

Vehicle Licences Only - Vehicle Fuel Type

VEHICLE_PLATE

varchar(25) null

Vehicle Licences Only - Vehicle Plate

OPERATOR_TITLE

varchar(25) null

OPTONAL Only needed where an operator exists

OWNER_TITLE

Any type is fine

Title

FAM_NAME

varchar(50) null

Family Name

FORE_NAME

varchar(36) null

First Name

TELH

varchar(20) null

Home Telephone

WORKPHONE_NUM

varchar(20) null

Work Telephone

MOBILE_NUM

varchar(20) null

Mobile Telephone

EMAILADDRESS

varchar(60) null

Email Address

DATEOFBIRTH

datetime null

Date of Birth

COMPNAME

varchar(100) null

Company / Organisation Name

SREETREF

varchar(25) null

Door number or house name

STREETNAME

varchar(100) null

Street Name

ADDR1

varchar(60) null

Address Line 1 - Only needed if PI/5

ADDR2

varchar(60) null

Address Line 2 - Only needed if PI/5

ADDR3

varchar(60) null

Address Line 3 - Only needed if PI/5

ST_LOCAL

varchar(35) null

Locality

ST_TOWN

varchar(30) null

Town

ST_COUNTY

varchar(30) null

County

POST_CD

varchar(8) null

postcode