-----------------------------------------------------------------       37020996
-- MEMBER: TBTPC00C                                            --       37020996
-- RELEASE: ___0996______ SERVICE REQUEST(S): ____13702____    --       37020996
-- NAME:___JERRY WILCOX__ CREATION DATE:      ___07/26/94__    --       37020996
-- DESCRIPTION: REPLACEMENT CREATE FOR PPPTPC DUE TO TCT       --       37020996
--              CHANGES REFLECTING CHANGES TO CORPORATE TCS.   --       37020996
-----------------------------------------------------------------       37020996
    CREATE         TABLE               PPPTPC                           TBTPC00C
                   (TPC_TITLE_CODE     CHAR (0004)    NOT  NULL         TBTPC00C
                   ,TPC_UPDT_TIMESTAMP TIMESTAMP      NOT  NULL         TBTPC00C
                                                      WITH DEFAULT      TBTPC00C
                   ,TPC_ACAD_RS_EFF_DT DATE           NOT  NULL         TBTPC00C
                   ,TPC_ACAD_RS_END_DT DATE           NOT  NULL         TBTPC00C
                   ,TPC_PAY_REP_CODE   CHAR (0003)    NOT  NULL         TBTPC00C
                                                      WITH DEFAULT      TBTPC00C
                   ,TPC_RANGE_ADJ_ID   CHAR (0012)    NOT  NULL         TBTPC00C
                                                      WITH DEFAULT      TBTPC00C
                   ,TPC_PAY_INTERVAL   SMALLINT       NOT  NULL         TBTPC00C
                                                      WITH DEFAULT      TBTPC00C
                   ,TPC_PAY_RATE       DEC  (0009,06) NOT  NULL         TBTPC00C
                                                      WITH DEFAULT      TBTPC00C
                   ,PRIMARY KEY        (    TPC_TITLE_CODE              TBTPC00C
                                       ,    TPC_ACAD_RS_EFF_DT          TBTPC00C
                                       ,    TPC_PAY_REP_CODE            TBTPC00C
                                       ,    TPC_PAY_INTERVAL            TBTPC00C
                                       )                                TBTPC00C
                   ,FOREIGN KEY        (    TPC_TITLE_CODE              TBTPC00C
                                       ,    TPC_ACAD_RS_EFF_DT          TBTPC00C
                                       ,    TPC_PAY_REP_CODE            TBTPC00C
                                       )                                TBTPC00C
                             REFERENCES     PPPTPB                      TBTPC00C
                             ON DELETE      CASCADE                     TBTPC00C
                   )                                                    TBTPC00C
                             IN        PPPCTL.PPPTPC;                   TBTPC00C