------------------------------------------------------------------------36360707
--  DDL MEMBER:    PPPTPA              SERVICE REQUEST(S): 3636____   --36360707
--  RELEASE:       0707____            CREATION DATE:      10/16/92   --36360707
--  NAME:          M.CLARK_                                           --36360707
--  DESCRIPTION:   COMPLETELY REPLACES THE DDL ORIGINALLY INCLUDED    --36360707
--                 WITH RELEASE 705.                                  --36360707
--                 CREATE STATEMENT FOR TABLE PPPTPA.                 --36360707
------------------------------------------------------------------------36360707
    CREATE         TABLE               PPPTPA                           TBTPA00C
                   (TPA_TITLE_CODE     CHAR (0004)    NOT  NULL         TBTPA00C
                   ,TPA_UPDT_TIMESTAMP TIMESTAMP      NOT  NULL         TBTPA00C
                                                      WITH DEFAULT      TBTPA00C
                   ,TPA_ACAD_CI_EFF_DT DATE           NOT  NULL         TBTPA00C
                   ,TPA_ACAD_RANK      CHAR (0001)    NOT  NULL         TBTPA00C
                                                      WITH DEFAULT      TBTPA00C
                   ,TPA_ACAD_SB_ELG_CD CHAR (0001)    NOT  NULL         TBTPA00C
                                                      WITH DEFAULT      TBTPA00C
                   ,TPA_ACAD_SERV_LMT  SMALLINT       NOT  NULL         TBTPA00C
                                                      WITH DEFAULT      TBTPA00C
                   ,TPA_ACAD_APPT_TYPE CHAR (0001)    NOT  NULL         TBTPA00C
                                                      WITH DEFAULT      TBTPA00C
                   ,TPA_ACAD_APPT_BAS  CHAR (0001)    NOT  NULL         TBTPA00C
                                                      WITH DEFAULT      TBTPA00C
                   ,TPA_ACAD_PAY_PERD  CHAR (0001)    NOT  NULL         TBTPA00C
                                                      WITH DEFAULT      TBTPA00C
                   ,TPA_ACAD_SICK_ELIG CHAR (0001)    NOT  NULL         TBTPA00C
                                                      WITH DEFAULT      TBTPA00C
                   ,TPA_HSCP_FLAG      CHAR (0001)    NOT  NULL         TBTPA00C
                                                      WITH DEFAULT      TBTPA00C
                   ,TPA_OFF_SCALE_FLAG CHAR (0001)    NOT  NULL         TBTPA00C
                                                      WITH DEFAULT      TBTPA00C
                   ,PRIMARY KEY        (    TPA_TITLE_CODE              TBTPA00C
                                       ,    TPA_UPDT_TIMESTAMP          TBTPA00C
                                       )                                TBTPA00C
                   ,FOREIGN KEY        (    TPA_TITLE_CODE              TBTPA00C
                                       )                                TBTPA00C
                             REFERENCES     PPPTCA                      TBTPA00C
                             ON DELETE      CASCADE                     TBTPA00C
                   )                                                    TBTPA00C
                             IN        PPPCTL.PPPTPA;                   TBTPA00C