-----------------------------------------------------------------       28201068
-- MEMBER: TBTPX00C                                            --       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 PPPTPT.             --       28201068
-----------------------------------------------------------------       28201068
    CREATE         TABLE               PPPTPX                           TBTPX00C
                   (TPX_TITLE_CODE     CHAR (0004)    NOT  NULL         TBTPX00C
                   ,TPX_UPDT_TIMESTAMP TIMESTAMP      NOT  NULL         TBTPX00C
                                                      WITH DEFAULT      TBTPX00C
                   ,TPX_SSP_RS_EFF_DT DATE            NOT  NULL         TBTPX00C
                   ,TPX_SSP_RS_END_DT DATE            NOT  NULL         TBTPX00C
                   ,TPX_PAY_REP_CODE   CHAR (0003)    NOT  NULL         TBTPX00C
                                                      WITH DEFAULT      TBTPX00C
                   ,TPX_RANGE_ADJ_ID   CHAR (0012)    NOT  NULL         TBTPX00C
                                                      WITH DEFAULT      TBTPX00C
                   ,TPX_SHIFT_TYPE     CHAR (0002)    NOT  NULL         TBTPX00C
                                                      WITH DEFAULT      TBTPX00C
                   ,TPX_SHIFT_RATE     DEC  (0009,06) NOT  NULL         TBTPX00C
                                                      WITH DEFAULT      TBTPX00C
                   ,PRIMARY KEY        (    TPX_TITLE_CODE              TBTPX00C
                                       ,    TPX_SSP_RS_EFF_DT           TBTPX00C
                                       ,    TPX_PAY_REP_CODE            TBTPX00C
                                       ,    TPX_SHIFT_TYPE              TBTPX00C
                                       )                                TBTPX00C
                   ,FOREIGN KEY        (    TPX_TITLE_CODE              TBTPX00C
                                       )                                TBTPX00C
                             REFERENCES     PPPTCA                      TBTPX00C
                             ON DELETE      CASCADE                     TBTPX00C
                   )                                                    TBTPX00C
                             IN        PPPCTL.PPPTPX;                   TBTPX00C