-----------------------------------------------------------------       28201068
-- MEMBER: TBTPT00C                                            --       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               PPPTPT                           TBTPT00C
                   (TPT_TITLE_CODE     CHAR (0004)    NOT  NULL         TBTPT00C
                   ,TPT_UPDT_TIMESTAMP TIMESTAMP      NOT  NULL         TBTPT00C
                                                      WITH DEFAULT      TBTPT00C
                   ,TPT_SSP_RS_EFF_DT DATE            NOT  NULL         TBTPT00C
                   ,TPT_SSP_RS_END_DT DATE            NOT  NULL         TBTPT00C
                   ,TPT_PAY_REP_CODE   CHAR (0003)    NOT  NULL         TBTPT00C
                                                      WITH DEFAULT      TBTPT00C
                   ,TPT_RANGE_ADJ_ID   CHAR (0012)    NOT  NULL         TBTPT00C
                                                      WITH DEFAULT      TBTPT00C
                   ,TPT_NO_STEPS       SMALLINT       NOT  NULL         TBTPT00C
                                                      WITH DEFAULT      TBTPT00C
                   ,TPT_NO_PAY_INTRVLS SMALLINT       NOT  NULL         TBTPT00C
                                                      WITH DEFAULT      TBTPT00C
                   ,TPT_SSP_SS_EXCPT CHAR (0001)      NOT  NULL         TBTPT00C
                                                      WITH DEFAULT      TBTPT00C
                   ,TPT_MERIT_BASED  CHAR (0001)      NOT  NULL         TBTPT00C
                                                      WITH DEFAULT      TBTPT00C
                   ,TPT_MEMO_GRADE   CHAR (0002)      NOT  NULL         TBTPT00C
                                                      WITH DEFAULT      TBTPT00C
                   ,PRIMARY KEY        (    TPT_TITLE_CODE              TBTPT00C
                                       ,    TPT_SSP_RS_EFF_DT           TBTPT00C
                                       ,    TPT_PAY_REP_CODE            TBTPT00C
                                       )                                TBTPT00C
                   ,FOREIGN KEY        (    TPT_TITLE_CODE              TBTPT00C
                                       )                                TBTPT00C
                             REFERENCES     PPPTCA                      TBTPT00C
                             ON DELETE      CASCADE                     TBTPT00C
                   )                                                    TBTPT00C
                             IN        PPPCTL.PPPTPT;                   TBTPT00C