Design and Implementation
Data Dictionary One-Day Liquor License
Table Of Contents
1 Applicant Table 1
2 License Table 4
3 Organization Table 5
4 Facility table 5
5 License Approval Table 5
6 Organization Officers Table 5
7 Facility Owner Table 5
Note: The following format is utilized to illustrate the entities and descriptive information.
Entity Name
FieldDesignator Type Size
Definition
- Applicant Table
Application ID (Primary Key)
ApplicationID Integer (Auto-Generate) 9
Required - The application identification number is generated by the application with the first four digits representing the year and the last five digits being a sequential counter starting from 1. An example of the ApplicationID being 200300001.
Organization ID (Foreign Key – Organization Table)
OrganizationID Integer (Auto-Generate) 5
Required - The organization identification number is a sequential number generated by the application beginning with one (1).
Name Prefix
NamePrefix Character 4
Optional – Applicant title. The domain for this entity is Dr., Mr., Mrs., Miss., Ms.
Last Name
LastName Character 30
Required – Last name of the applicant. Hyphenated names acceptable.
First Name
FirstName Character 30
Required – First name of applicant.
Middle Initial
MiddleInitial Character 1
Optional – Middle initial of applicant.
Name Suffix
NameSuffix Character 3
Optional – Applicant name suffix. The domain for this entity is Jr., Sr. Ph.D., II, III, IV, V.
Officer
Officer Character 1
Required – Acknowledgement of whether applicant is an officer in the organization. The domain for this entity is Y, N (Yes, No)
Date of Birth
DateOfBirth Date 8
Required - Date of birth of the applicant. This field is used to calculate their age.
Phone
Phone Character 10
Required – Phone number of applicant entered with out parentheses or dash.
Street Number
StreetNumber Character 9
Required – Street number of applicant. If street number contains fraction, the fraction should be preceded by a space. If street number contains alphabetic characters, there should not be a space between the number and the letter.
Street Prefix
StreetPrefix Character 2
Optional – Street prefix of applicant. The domain for this entity is N, S, E, W, NE, NW, SE, SW.
Street Name
StreetName Character 30
Required – The street name of the applicant.
Street Type
StreetType Character 5
Required – The street type of the applicant abbreviated based on United States Postal Service - Postal Addressing Standards, Publication 28.
Street Suffix
StreetSuffix Character 2
Optional – Street suffix of applicant. The domain for this entity is N, S, E, W, NE, NW, SE, SW.
Secondary Unit Designators
SecondaryUnitDesignator Character 10
Optional – The secondary address designator of the application. Generally includes such references as apartment, building, floor, suite, unit, room, and department.
City
City Character 30
Required – The city of the applicant. Lookup, auto-generated based on the zip code.
State
State Character 2
Required – The state of the applicant. Look-up, auto-generated based on the zip code.
Zip+4
ZipCode Character 9
Required – The zip+4 code of the applicant validated against national/international list entered without dash.
Country
Country Character 2
Optional – The country of origin of the applicant validated against international abbreviations list.
- License Table
License Number (Primary Key)
LicenseNumber Integer (Auto-Generate) 9
Required - The license number is generated by the application with the first four digits representing the year and the last five digits being a sequential counter starting from 1. An example of the ApplicationID being 200300001.
License Type
LicenseType Integer 1
Required – The type of license specified by the applicant. The valid types are beer and light wine (1), beer wine and liquor (2), wine tasting (3).
Date of Activity
DateOfActivity Date 8
Required – The date of the activity as specified on the application.
Consecutive Days
ConsecutiveDays Integer 1
Required – Default 1 – The number of consecutive days for the license of request up to a maximum of 7.
Start Time
StartTime Time 4
Required – The start time of the activity expressed in 24-hour clock units.
End Time
EndTime Time 4
Required – The end time of the activity expressed in 24-hour clock units.
Funds Purpose
FundsPurpose Char 120
Required – A short description of the disposition or purpose of how the funds raised will be used.
- Organization Table
- Facility table
- License Approval Table
- Organization Officers Table
- Facility Owner Table
0 2/19/2003 V1.0