General Licencing


This proof model is for verifying / proving the status of General Licence types and the verification steps taken before issuing licences.

The General Licence types Proof Module model captures the following data events, workflows and outputs:

Data and Workflow Evidence Keys Captured in Module:

 

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

 

 

evidentproof-bespoke-workflow-icon

Customisable

This Module can be customised. Contact sales@berkshirecloud.com for detail.