程序代写代做 Data Dictionary : Entertainment Licenses

Data Dictionary : Entertainment Licenses
Variable Name
Label
Type
Value Codes
Missing Code
LICENSENO
Entertainment license number
Character string
NA
none, required field.
LICENSEDTTM
?
Date
DD/MM/YY HH:MM AM/PM
NA
NULL
ISSDTTM
Issue date and time of the license
Date
DD/MM/YY HH:MM AM/PM
NA
NULL
EXPDTTM
Expiration date and time of the license
Date
DD/MM/YY HH:MM AM/PM
NA
NULL
LICSTATUS
Status of license
Character String
Active
none
STNO
Street number associated with license
integer
NA
[blank]
STNOHI
Highest street number associated with license (for ranged addresses, ie 20­40 Washington st.)
integer
NA
[blank]
Address
Street associated with license
Character string (St Name SUFFIX, ie
NA
none

Mount Vernon ST)
CITY
City associated with license
Character string
see value code index
none
ZIP
Zip code associated with license
integer
see value code index
NA
STATE
State associated with license
Character string
MA, Ma
[blank]
LICCATDESC
License category
Character string
Live Entertainment, Night Club, Non­Live Entertainment
see: http://www.cityofboston .gov//consumeraffairs/e ntertainment/
none
PRIMAPPLICANT
Name of the primary applicant for the license
Character string (First Last, ie John Smith)
NA
CONTACT
Name of the location to contact regarding the issued license
Character string
NA
NULL
PHONE
Phone number to contact regarding the issued license
integer, user entered formatting varies
NA
NULL
DBANAME
The ‘doing business as’ name of the location associated
Character string
NA
none

with an issued license
BUSINESSNAME
Name of the business associated with an issued license
Character string
NA
none
Manager
Name of the manager responsible at the location issued a license
Character string (First Last)
NA
none
TOTALCAPACITY
Total capacity of the location issued a license
integer
NA
0
TOTALESTIMATEDFEES
Total estimated fees for the license
integer
NA
0
TOTALESTLIVEFEES
Total estimated fees for live entertainment licenses
integer
NA
0
FEEAMOUNT
Fee rendered upon applicant
integer
NA
0
CAL_UNITTYPECODE
Description of unit being licensed for use, relates to UnitTypeDescript
Character string
see value code index
NULL or [blank]

CAPACITY
Capacity of location being rendered a license
integer
NA
0
ENDTIME
Time of day location closes
Character string. HH:MM AM/PM
NA
NULL, See Conditions, SEE BELOW, **
NUMBEROFUNITS
Number of units being licensed for use
integer
NA
0
Neighborhood
the neighborhood of a location issued a license
character string
see value code index
none
CAL_POLICEDISTRICTC ODE
Police district licensed location is within
Character string
see value code index
none
UnitTypeDescript
Description of the unit being licensed
Character string
see value code index
NULL
TotalEntCapacity
Total capacity (this mirrors TOTALCAPACITY)
integer
NA
0
Location
Lat, Long of the location rendered a license
XY data (42.xxxxxxxxx, ­71.xxxxxxxxx)
NA
NULL