About This Guide > csil_mstr
  
csil_mstr
Controlled Substance Individual License Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
csil__qadc01
 
 
x(8)
 
 
csil_addr1
Licensee Address
Licensee
x(8)
 
 
csil_addr2
Producer Address
Producer
x(8)
 
 
csil_addr3
Intermediate Consignee Addr
Int Con
x(8)
 
 
csil_addr4
Final Consignee Address
Fin Con
x(8)
 
 
csil_auth
Authority
Auth
x(8)
 
 
csil_cmtindx
Comment Index
Comments
>>>>>>>9
 
 
csil_ctry_code
Country
Ctry
x(3)
 
 
csil_domain
Domain
 
x(8)
 
 
csil_end
End Date
End
99/99/99
 
 
csil_licen
License Number
 
x(30)
 
 
csil_start
Start Date
Start
99/99/99
 
 
csil_user1
Ufld1
 
x(8)
 
 
csil_user2
Ufld2
 
x(8)
 
 
oid_csil_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
csil_addr4_licen
no
csil_domain
yes
no
 
 
 
csil_addr4
yes
no
 
 
 
csil_licen
yes
no
csil_ctry_auth
yes
csil_domain
yes
no
 
 
 
csil_ctry_code
yes
no
 
 
 
csil_auth
yes
no
 
 
 
csil_licen
yes
no
 
csil_licen
no
csil_domain
yes
no
 
 
 
csil_licen
yes
no
 
oid_csil_mstr
yes
oid_csil_mstr
yes
no