-----------------------------------------------------------------       28201068
-- MEMBER: TBTPY00C                                            --       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 PPPTPY.             --       28201068
-----------------------------------------------------------------       28201068
    CREATE         TABLE               PPPTPY                           TBTPY00C
                   (TPY_TITLE_CODE     CHAR (0004)    NOT  NULL         TBTPY00C
                   ,TPY_UPDT_TIMESTAMP TIMESTAMP      NOT  NULL         TBTPY00C
                                                      WITH DEFAULT      TBTPY00C
                   ,TPY_SSP_RS_EFF_DT DATE            NOT  NULL         TBTPY00C
                   ,TPY_SSP_RS_END_DT DATE            NOT  NULL         TBTPY00C
                   ,TPY_PAY_REP_CODE   CHAR (0003)    NOT  NULL         TBTPY00C
                                                      WITH DEFAULT      TBTPY00C
                   ,TPY_TOC_CODE       CHAR (0001)    NOT  NULL         TBTPY00C
                                                      WITH DEFAULT      TBTPY00C
                   ,TPY_TOC_TYPE       CHAR (0001)    NOT  NULL         TBTPY00C
                                                      WITH DEFAULT      TBTPY00C
                   ,TPY_TOC_RATE       DEC  (0009,06) NOT  NULL         TBTPY00C
                                                      WITH DEFAULT      TBTPY00C
                   ,PRIMARY KEY        (    TPY_TITLE_CODE              TBTPY00C
                                       ,    TPY_SSP_RS_EFF_DT           TBTPY00C
                                       ,    TPY_PAY_REP_CODE            TBTPY00C
                                       ,    TPY_TOC_CODE                TBTPY00C
                                       )                                TBTPY00C
                   ,FOREIGN KEY        (    TPY_TITLE_CODE              TBTPY00C
                                       )                                TBTPY00C
                             REFERENCES     PPPTCA                      TBTPY00C
                             ON DELETE      CASCADE                     TBTPY00C
                   )                                                    TBTPY00C
                             IN        PPPCTL.PPPTPY;                   TBTPY00C