Archives of the TeradataForum

Message Posted: Tue, 06 Jan 2004 @ 23:56:25 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Here is the DDLs.

Small Tables

CREATE SET TABLE OBC_MASTER.LU_OBC_JOB_INFO ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
      JOB_ID INTEGER NOT NULL,
      LOCATION_ID VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      LONG_DIST_PROVIDER_ID VARCHAR(8) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      SERVICE_CARRIER_ID INTEGER NOT NULL,
      CONTACT_TYPE CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      CONTACT_METHOD CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      METRIC_TYPE_CODE BYTEINT NOT NULL,
      SCHEDULED_DATE DATE FORMAT 'YYYY-MM-DD' NOT NULL,
      REPORTING_MONTH BYTEINT NOT NULL,
      REPORTING_YEAR SMALLINT NOT NULL,
      PANEL_SEQ_ID INTEGER NOT NULL,
      TESTSPEC_SET_ID CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      CONTACT_TECHNOLOGY_ID BYTEINT,
      IMPORT_LOCATION_ID VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
      RES_FILE_NAME VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
      MAP_FILE_NAME VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,
      MDN_FILE_NAME VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC)
UNIQUE PRIMARY INDEX ( JOB_ID )
UNIQUE INDEX ( LOCATION_ID ,LONG_DIST_PROVIDER_ID ,SERVICE_CARRIER_ID ,
CONTACT_TYPE ,CONTACT_METHOD ,METRIC_TYPE_CODE ,SCHEDULED_DATE ,
REPORTING_MONTH ,REPORTING_YEAR ,PANEL_SEQ_ID ,TESTSPEC_SET_ID )
INDEX ( CONTACT_TYPE )
INDEX ( CONTACT_METHOD );

CREATE SET TABLE OBC_MASTER.LU_OBC_RCONTACT_JOB_ADDNL_INFO ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
      JOB_ID INTEGER NOT NULL,
      ORIG_CONTACT_TYPE CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
      ORIG_CONTACT_METHOD CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
      ORIG_METRIC_TYPE BYTEINT)
UNIQUE PRIMARY INDEX ( JOB_ID );

CREATE SET TABLE OBC_LOAD.NPA_NXX_OUTBOUND ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
      NPANXXX INTEGER,
      OWNER_MARKET_ID SMALLINT,
      OWNER_CARRIER_ID SMALLINT,
      OCN VARCHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY INDEX ( NPANXXX ,OWNER_MARKET_ID ,OWNER_CARRIER_ID );

Big Table

CREATE SET TABLE OBC_MASTER.FA_OBC_MDN_MTD ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
      JOB_ID INTEGER NOT NULL,
      NPANXXX INTEGER NOT NULL,
      LAST_THREE_DIGIT CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      CONFIG_ID INTEGER,
      RUN_DATE DATE FORMAT 'YYYY-MM-DD',
      RUN_TIME INTEGER FORMAT '99:99:99',
      ACTIVITY_CODE BYTEINT)
UNIQUE PRIMARY INDEX ( JOB_ID ,NPANXXX ,LAST_THREE_DIGIT )
INDEX ( JOB_ID );

	<Prev	Next>		<<First	<Prev	Next>	Last>>