-----------------------------------------------------------------       37020996
-- MEMBER: TBTPB00C                                            --       37020996
-- RELEASE: ___0996______ SERVICE REQUEST(S): ____13702____    --       37020996
-- NAME:___JERRY WILCOX__ CREATION DATE:      ___07/26/94__    --       37020996
-- DESCRIPTION: REPLACEMENT CREATE FOR PPPTPB DUE TO TCT       --       37020996
--              CHANGES REFLECTING CHANGES TO CORPORATE TCS.   --       37020996
-----------------------------------------------------------------       37020996
    CREATE         TABLE               PPPTPB                           TBTPB00C
                   (TPB_TITLE_CODE     CHAR (0004)    NOT  NULL         TBTPB00C
                   ,TPB_UPDT_TIMESTAMP TIMESTAMP      NOT  NULL         TBTPB00C
                                                      WITH DEFAULT      TBTPB00C
                   ,TPB_ACAD_RS_EFF_DT DATE           NOT  NULL         TBTPB00C
                   ,TPB_ACAD_RS_END_DT DATE           NOT  NULL         TBTPB00C
                   ,TPB_PAY_REP_CODE   CHAR (0003)    NOT  NULL         TBTPB00C
                                                      WITH DEFAULT      TBTPB00C
                   ,TPB_RANGE_ADJ_ID   CHAR (0012)    NOT  NULL         TBTPB00C
                                                      WITH DEFAULT      TBTPB00C
                   ,TPB_NO_STEPS       SMALLINT       NOT  NULL         TBTPB00C
                                                      WITH DEFAULT      TBTPB00C
                   ,TPB_NO_PAY_INTRVLS SMALLINT       NOT  NULL         TBTPB00C
                                                      WITH DEFAULT      TBTPB00C
                   ,TPB_ACAD_COMP_GRP  CHAR (0003)    NOT  NULL         TBTPB00C
                                                      WITH DEFAULT      TBTPB00C
                   ,PRIMARY KEY        (    TPB_TITLE_CODE              TBTPB00C
                                       ,    TPB_ACAD_RS_EFF_DT          TBTPB00C
                                       ,    TPB_PAY_REP_CODE            TBTPB00C
                                       )                                TBTPB00C
                   ,FOREIGN KEY        (    TPB_TITLE_CODE              TBTPB00C
                                       )                                TBTPB00C
                             REFERENCES     PPPTCA                      TBTPB00C
                             ON DELETE      CASCADE                     TBTPB00C
                   )                                                    TBTPB00C
                             IN        PPPCTL.PPPTPB;                   TBTPB00C