-----------------------------------------------------------------       28201068
-- MEMBER: TBTPS00C                                            --       28201068
-- RELEASE: ___1068______ SERVICE REQUEST(S): ____12820____    --       28201068
-- NAME:_____J.WILCOX____ CREATION DATE:      ___05/08/96__    --       28201068
-- DESCRIPTION: Completely replaces the DDL issued with        --       28201068
--              Release 707.                                   --       28201068
--              Create statement for table PPPTPS.             --       28201068
-----------------------------------------------------------------       28201068
    CREATE         TABLE               PPPTPS                           TBTPS00C
                   (TPS_TITLE_CODE     CHAR (0004)    NOT  NULL         TBTPS00C
                   ,TPS_UPDT_TIMESTAMP TIMESTAMP      NOT  NULL         TBTPS00C
                                                      WITH DEFAULT      TBTPS00C
                   ,TPS_SSP_CI_EFF_DT DATE            NOT  NULL         TBTPS00C
                   ,TPS_SPV_TITLE_FLAG CHAR (0001)    NOT  NULL         TBTPS00C
                                                      WITH DEFAULT      TBTPS00C
                   ,TPS_SIXMO_INCRS_CD CHAR (0001)    NOT  NULL         TBTPS00C
                                                      WITH DEFAULT      TBTPS00C
                   ,TPS_SSP_GRADE      SMALLINT       NOT  NULL         TBTPS00C
                                                      WITH DEFAULT      TBTPS00C
                   ,TPS_HEALTH_FLAG    CHAR(0001)     NOT  NULL         TBTPS00C
                                                      WITH DEFAULT      TBTPS00C
                   ,TPS_SSP_LOOKUP_COV CHAR(0001)     NOT  NULL         TBTPS00C
                                                      WITH DEFAULT      TBTPS00C
                   ,TPS_SSP_LOOKUP_UNC CHAR(0001)     NOT  NULL         TBTPS00C
                                                      WITH DEFAULT      TBTPS00C
                   ,PRIMARY KEY        (    TPS_TITLE_CODE              TBTPS00C
                                       ,    TPS_UPDT_TIMESTAMP          TBTPS00C
                                       )                                TBTPS00C
                   ,FOREIGN KEY        (    TPS_TITLE_CODE              TBTPS00C
                                       )                                TBTPS00C
                             REFERENCES     PPPTCA                      TBTPS00C
                             ON DELETE      CASCADE                     TBTPS00C
                   )                                                    TBTPS00C
                             IN        PPPCTL.PPPTPS;                   TBTPS00C