-----------------------------------------------------------------       28201068
-- MEMBER: TBTPU00C                                            --       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 996.                                   --       28201068
--              Create statement for table PPPTPU.             --       28201068
-----------------------------------------------------------------       28201068
    CREATE         TABLE               PPPTPU                           TBTPU00C
                   (TPU_TITLE_CODE     CHAR (0004)    NOT  NULL         TBTPU00C
                   ,TPU_UPDT_TIMESTAMP TIMESTAMP      NOT  NULL         TBTPU00C
                                                      WITH DEFAULT      TBTPU00C
                   ,TPU_SSP_RS_EFF_DT DATE            NOT  NULL         TBTPU00C
                   ,TPU_SSP_RS_END_DT DATE            NOT  NULL         TBTPU00C
                   ,TPU_PAY_REP_CODE   CHAR (0003)    NOT  NULL         TBTPU00C
                                                      WITH DEFAULT      TBTPU00C
                   ,TPU_RANGE_ADJ_ID   CHAR (0012)    NOT  NULL         TBTPU00C
                                                      WITH DEFAULT      TBTPU00C
                   ,TPU_PAY_INTERVAL   SMALLINT       NOT  NULL         TBTPU00C
                                                      WITH DEFAULT      TBTPU00C
                   ,TPU_PAY_RATE       DEC  (0009,06) NOT  NULL         TBTPU00C
                                                      WITH DEFAULT      TBTPU00C
                   ,PRIMARY KEY        (    TPU_TITLE_CODE              TBTPU00C
                                       ,    TPU_SSP_RS_EFF_DT           TBTPU00C
                                       ,    TPU_PAY_REP_CODE            TBTPU00C
                                       ,    TPU_PAY_INTERVAL            TBTPU00C
                                       )                                TBTPU00C
                   ,FOREIGN KEY        (    TPU_TITLE_CODE              TBTPU00C
                                       ,    TPU_SSP_RS_EFF_DT           TBTPU00C
                                       ,    TPU_PAY_REP_CODE            TBTPU00C
                                       )                                TBTPU00C
                             REFERENCES     PPPTPT                      TBTPU00C
                             ON DELETE      CASCADE                     TBTPU00C
                   )                                                    TBTPU00C
                             IN        PPPCTL.PPPTPU;                   TBTPU00C