CREATE TABLE "STORET1"."TSRANLPR" ("TSRANLPR_IS_NUMBER" 
    NUMBER(12) NOT NULL, "TSRANLPR_ORG_ID" CHAR(8) NOT NULL, 
    "OWNER_TYPE_CODE" CHAR(3) NOT NULL, "PROCEDURE_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), 
    "TSRANLPR0IS_NUMBER" NUMBER(12), "TSRANLPR0ORG_ID" CHAR(8), 
    "TSRANLEQ_IS_NUMBER" NUMBER(12), "TSRANLEQ_ORG_ID" CHAR(8), 
    "DESCRIPTION_TEXT" VARCHAR2(4000), 
    CONSTRAINT "IANLPR01" PRIMARY KEY("TSRANLPR_IS_NUMBER", 
    "TSRANLPR_ORG_ID") 
    USING INDEX  
    TABLESPACE "STORET1_INDS" 
    STORAGE ( INITIAL 520K NEXT 64K 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 216K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 20 FREELISTS 1 FREELIST GROUPS 1) 
    LOGGING ;
COMMENT ON TABLE "STORET1"."TSRANLPR" IS 'TABLE ANALYTICAL_PROCEDURE, STORET1.TSRANLPR - Version 2.0.08 - Dated 2005/12/01 - STORET Control '