CREATE TABLE "STORET1"."TSRLSPP" ("TSRLSPP_IS_NUMBER" NUMBER(12) 
    NOT NULL, "TSRLSPP_ORG_ID" CHAR(8) NOT NULL, 
    "OWNER_TYPE_CODE" CHAR(3) NOT NULL, "PREPARATION_ID" CHAR(15)
    NOT NULL, "NAME" VARCHAR2(120) NOT NULL, "SOURCE_NAME" 
    VARCHAR2(65) NOT NULL, "SOURCE_ACR" CHAR(12), "D_USERID_CODE"
    CHAR(8) NOT NULL, "D_LAST_UPDATE_TS" DATE NOT NULL, 
    "TSRCITN_IS_NUMBER" NUMBER(12), "TSRCITN_ORG_ID" CHAR(8), 
    CONSTRAINT "ILSPP01" PRIMARY KEY("TSRLSPP_IS_NUMBER", 
    "TSRLSPP_ORG_ID") 
    USING INDEX  
    TABLESPACE "STORET1_INDS" 
    STORAGE ( INITIAL 552K NEXT 48K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 20 FREELISTS 1 FREELIST GROUPS 1) 
    PCTFREE 10 INITRANS 2 MAXTRANS 255)  
    TABLESPACE "STORET1_TABS" PCTFREE 10 PCTUSED 40 INITRANS 1 
    MAXTRANS 255 
    STORAGE ( INITIAL 1040K NEXT 96K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 20 FREELISTS 1 FREELIST GROUPS 1) 
    LOGGING ;
COMMENT ON TABLE "STORET1"."TSRLSPP" IS 'TABLE LAB_SAMPLE_PREP_PROCEDURE, STORET1.TSRLSPP  - Version 2.0.08 - Dated 2005/12/01 - STORET Control '