create or replace view
v_specimens
as
select cast(specimen_id as INTEGER) specimen_id, date_Drawn, participant_id, vial_type, quantity, measurement, visit_no, location, total_count, available_count
from specimen

desc v_specimens
Name Null Type

SPECIMEN_ID NUMBER(38)
DATE_DRAWN DATE
PARTICIPANT_ID NUMBER
VIAL_TYPE CHAR(5)
QUANTITY NUMBER
MEASUREMENT CHAR(2)
VISIT_NO NUMBER
LOCATION VARCHAR2(4000)
TOTAL_COUNT NUMBER
AVAILABLE_COUNT NUMBER

Specifying the database as Integer doesn't change anything. As the rdbms still just has the data type as NUMBER, with the precision,scale specified - so more of a convenience then specifying precisions/scale yourself.

SO, still comes through as Number (Double) in LabKey.

(off-topic: would be good to have a no format [like pre or code html tags] formatting option)