-----------------------------------------------------------------       28201068
-- MEMBER: TBTPM00C                                            --       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 PPPTPM.             --       28201068
-----------------------------------------------------------------       28201068
    CREATE         TABLE               PPPTPM                           TBTPM00C
                   (TPM_TITLE_CODE     CHAR (0004)    NOT  NULL         TBTPM00C
                   ,TPM_UPDT_TIMESTAMP TIMESTAMP      NOT  NULL         TBTPM00C
                                                      WITH DEFAULT      TBTPM00C
                   ,TPM_MSP_CI_EFF_DT  DATE           NOT  NULL         TBTPM00C
                   ,TPM_SAL_GRADE_FLAG CHAR (0001)    NOT  NULL         TBTPM00C
                                                      WITH DEFAULT      TBTPM00C
                   ,PRIMARY KEY        (    TPM_TITLE_CODE              TBTPM00C
                                       ,    TPM_UPDT_TIMESTAMP          TBTPM00C
                                       )                                TBTPM00C
                   ,FOREIGN KEY        (    TPM_TITLE_CODE              TBTPM00C
                                       )                                TBTPM00C
                             REFERENCES     PPPTCA                      TBTPM00C
                             ON DELETE      CASCADE                     TBTPM00C
                   )                                                    TBTPM00C
                             IN        PPPCTL.PPPTPM;                   TBTPM00C