Conference orarep::nomahs::rdbexpert

732.0. "Problem with a view definition" by BROKE::BASTINE () Tue Mar 11 1997 09:40

I have a customer trying to use Rdbexpert.  In the process of running it, 
it is trying to use/read RDBX_SCHEMA.SQL and fails with this error:

Error: Found 'ON' at or near line 3709 of file RDBX_SCHEMA.SQL 
 
Expecting 1 of the following items: 
 
,, WHERE, GROUP, HAVING, JOIN, LEFT, FULL, UNION, CROSS 
, RIGHT, INNER, LIMIT,  
ORDER, NATURAL, WITH, ; 
 
I will include the entire RDBX_SCHEMA.SQL, but it appears it is failing on 
a view definition.  The view name is DROP_ATC_RESULTS.

I checked the view definition and it looks OK to me except for the where 
clause... never saw syntax like this before:

where (C1.REQUEST_TIME <= DATE VMS '20-JAN-1997 00:00:00.00')

However, this same sytax appears above in other view definitions and is not
flagged as being illegal, it is accepted, so it must be OK.

I have counted the # of columns vs. the # of select columns and they are equal.
I saw notes regarding problems if the numbers didn't match.  

This customer is running 2.1A of Expert, I could ask her to upgrade, but haven't
seen anything that indicates this proble might be fixed.

This view was created by MSAccess in the Rdb database... it can be seen by Rdb
and MSAccess, but for some reason expert chokes on it.

Any suggestions?

Here is the .SQL file:

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                           Database Definition File
--
-- Source Database Name:
EAS$DISK_1:[EAS.DATABASE.TSPT]EAS_SCH_MULTI.RDB;1
------------------------------------------------------------------------
--------
set verify;
set language ENGLISH;
set default date format 'SQL92';
set quoting rules 'SQL92';
set date format DATE 001, TIME 001;

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                         Physical Database Definition
--
------------------------------------------------------------------------
--------
create database
    filename 'EAS$DISK_1:[EAS.DATABASE.TSPT]EAS_SCH_MULTI.RDB'
; -- end create database

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                             Collating Sequences
--
------------------------------------------------------------------------
--------
-- no collating sequences defined

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                              Domain Definitions
--
------------------------------------------------------------------------
--------
create domain ACCESS_SW_DOM
    INTEGER;
 
create domain ACCT_ITV_NB_DOM
    INTEGER;
 
create domain ACC_MTHD_CD_DOM
    CHAR (1);
 
create domain ACL_RSV_MW_QY_DOM
    INTEGER
    default 0;
 
create domain ACV_CD_DOM
    CHAR (1);
 
create domain ADD_INDC_SW_DOM
    CHAR (1);
 
create domain ADD_IN_TOT_INDC_SW_DOM
    CHAR (1)
    default 'Y';
 
create domain ADJ_FCT_QY_DOM
    INTEGER
    default 1;
 
create domain ADJ_ICHG_PT_ID_DOM
    CHAR (4);
 
create domain AIB_INDC_SW_DOM
    CHAR (1);
 
create domain AM_DOM
    INTEGER (2);
 
create domain AN_TYP_ID_DOM
    CHAR (4);
 
create domain AN_TYP_NM_DOM
    CHAR (15);
 
create domain BASE_NET_INAD_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain BASE_REQ_RSV_QY_DOM
    INTEGER
    default 0;
 
create domain BLL_RT_CALC_METH_ID_DOM
    CHAR (6);
 
create domain BOW_HH_QY_DOM
    INTEGER
    default 0;
 
create domain BOW_ID_DOM
    CHAR (4);
 
create domain BOW_NM_DOM
    CHAR (16);
 
create domain BRKR_CO_ID_DOM
    CHAR (6);
 
create domain BRKR_FEE_PCT_QY_DOM
    INTEGER (3);
 
create domain BRKR_FEE_RT_AM_DOM
    INTEGER (2);
 
create domain BRKR_FEE_TOT_AM_DOM
    INTEGER (2);
 
create domain BUY_BCK_PCT_RT_DOM
    INTEGER (4);
 
create domain BUY_SELL_INDC_SW_DOM
    CHAR (1);
 
create domain CAP_CHRG_AM_DOM
    INTEGER (2);
 
create domain CAP_ENR_CD_DOM
    CHAR (1)
    default 'E';
 
create domain CAP_MW_QY_DOM
    INTEGER;
 
create domain CAP_PCT_RT_DOM
    INTEGER (4);
 
create domain CAP_PRC_UOM_TX_DOM
    CHAR (1);
 
create domain CAP_PRTE_DD_NB_DOM
    SMALLINT
    default 0;
 
create domain CAP_QUO_PRC_QY_DOM
    INTEGER (2);
 
create domain CD_DOM
    CHAR (11)
    default 'PRELIMINARY';
 
create domain CGN_DD_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain CGN_HH_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain CGN_MM_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain CGN_TM_HH_QY_DOM
    INTEGER;
 
create domain CGN_TM_MN_QY_DOM
    INTEGER;
 
create domain CGN_YY_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain CMT_DOM
    CHAR (80);
 
create domain CMT_TX_DOM
    CHAR (20);
 
create domain CNT_NM_DOM
    CHAR (24);
 
create domain CO_HOL_SW_DOM
    CHAR (1)
    default 'N';
 
create domain CO_ID_DOM
    CHAR (6);
 
create domain CO_NM_DOM
    CHAR (40);
 
create domain CT_TYP_ID_DOM
    CHAR (4);
 
create domain CT_TYP_NM_DOM
    CHAR (15);
 
create domain CUR_CAP_QY_DOM
    INTEGER (3);
 
create domain CUR_FSTR_QY_DOM
    INTEGER;
 
create domain CUR_MTR_ROLL_QY_DOM
    INTEGER;
 
create domain CUR_QY_DOM
    INTEGER;
 
create domain CUS_FUEL_RT_AM_DOM
    INTEGER (3);
 
create domain CUS_ID_DOM
    CHAR (9);
 
create domain CUS_MEAS_HH_QY_DOM
    INTEGER
    default 0;
 
create domain CUS_MISC_MEAS_MWH_QY_DOM
    INTEGER;
 
create domain CUS_MISC_MEAS_NM_DOM
    CHAR (24);
 
create domain CUS_MISC_QY_DOM
    INTEGER;
 
create domain CUS_NM_DOM
    CHAR (24);
 
create domain DAY_ID_DOM
    CHAR (3);
 
create domain DAY_NM_DOM
    CHAR (10);
 
create domain DAY_TYP_ID_DOM
    CHAR (3);
 
create domain DD_DOM
    CHAR (2);
 
create domain DD_NB_QY_DOM
    INTEGER
    default 0;
 
create domain DIR_CD_DOM
    CHAR (4);
 
create domain DSM_MW_QY_DOM
    INTEGER (3);
 
create domain DSM_TYP_ID_DOM
    CHAR (3);
 
create domain DSM_TYP_NM_DOM
    CHAR (24);
 
create domain DSM_USE_DD_TX_DOM
    CHAR (24);
 
create domain DST_1AM_SW_DOM
    CHAR (1)
    default 'N';
 
create domain DST_CHG_CD_DOM
    CHAR (3);
 
create domain DT_DOM
    DATE VMS;
 
create domain DVC_ID_DOM
    CHAR (14);
 
create domain DVC_TYP_ID_DOM
    CHAR (6);
 
create domain EA_FUEL_TYP_ID_DOM
    CHAR (4);
 
create domain ECON_SW_DOM
    CHAR (1);
 
create domain ECO_ADJ_FCT_QY_DOM
    INTEGER (3);
 
create domain EDT_SW_DOM
    CHAR (1)
    default 'N';
 
create domain EMS_WTH_STN_ID_DOM
    CHAR (8);
 
create domain END_CR_BAL_QY_DOM
    INTEGER
    default 0;
 
create domain EXTR_NB_DOM
    INTEGER;
 
create domain FCST_RSV_MW_QY_DOM
    INTEGER
    default 0;
 
create domain FCT_QY_DOM
    INTEGER (4);
 
create domain FEE_TYP_DOM
    CHAR (6);
 
create domain FERC_RT_DOM
    INTEGER (2);
 
create domain FIRM_DEG_CD_DOM
    CHAR (1);
 
create domain FIRM_INDC_SW_DOM
    CHAR (1);
 
create domain FIRM_PRC_DOM
    CHAR (4);
 
create domain FIRM_PRC_INDC_SW_DOM
    CHAR (1);
 
create domain FIRM_SW_DOM
    CHAR (1);
 
create domain FUEL_NM_DOM
    CHAR (20);
 
create domain FUEL_SRC_TYP_ID_DOM
    CHAR (1);
 
create domain FUEL_TYP_NM_DOM
    CHAR (24);
 
create domain FUT_EVN_SW_DOM
    CHAR (1);
 
create domain GCF_QY_DOM
    INTEGER (3);
 
create domain GEN_TYP_DD_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain GEN_TYP_HH_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain GEN_TYP_ID_DOM
    CHAR (8);
 
create domain GEN_TYP_MM_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain GEN_TYP_NM_DOM
    CHAR (12);
 
create domain GEN_TYP_YY_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain HH_DOM
    CHAR (4);
 
create domain HH_MWH_QY_DOM
    INTEGER;
 
create domain HOL_DESC_DOM
    CHAR (12);
 
create domain HR_QY_DOM
    DOUBLE PRECISION
    default 0.000000;
 
create domain ICHG_CT_TYP_ID_DOM
    CHAR (4);
 
create domain ICHG_DIR_TYP_ID_DOM
    CHAR (4);
 
create domain ICHG_DIR_TYP_NM_DOM
    CHAR (24);
 
create domain ICHG_INAD_HDAY_DOM
    DATE VMS;
 
create domain ICHG_PRC_FCT_TYP_DOM
    CHAR (8);
 
create domain ICHG_PT_DD_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain ICHG_PT_HH_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain ICHG_PT_ID_DOM
    CHAR (4);
 
create domain ICHG_PT_MM_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain ICHG_PT_NM_DOM
    CHAR (24);
 
create domain ICHG_PT_TYP_CD_DOM
    CHAR (4);
 
create domain ICHG_PT_YY_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain ICHG_TYP_ID_DOM
    CHAR (6);
 
create domain ICHG_TYP_NM_DOM
    CHAR (24);
 
create domain INAD_QY_DOM
    INTEGER
    default 0;
 
create domain INIT_SW_DOM
    CHAR (1);
 
create domain INSN_MW_QY_DOM
    DOUBLE PRECISION
    default 0.000000;
 
create domain IPT_CST_DOM
    INTEGER (2)
    default 0;
 
create domain IPT_PRC_FUEL_RT_DOM
    INTEGER (4);
 
create domain IPT_PRC_MRKUP_QY_DOM
    INTEGER (4);
 
create domain IPT_PRC_QY_DOM
    INTEGER (2)
    default 0;
 
create domain ITP_CMT_TX_DOM
    CHAR (512);
 
create domain ITP_EVN_NB_DOM
    INTEGER;
 
create domain ITP_EVN_SEQ_NB_DOM
    INTEGER;
 
create domain JOWS_CO_ID_DOM
    CHAR (6);
 
create domain LDG_NB_DOM
    INTEGER;
 
create domain LD_FCT_RT_DOM
    DOUBLE PRECISION
    default 0.000000;
 
create domain LINE_1_TX_DOM
    CHAR (132);
 
create domain LINE_TX_DOM
    CHAR (132);
 
create domain LOSS_RT_QY_DOM
    INTEGER (3);
 
create domain LOS_QY_DOM
    INTEGER
    default 0;
 
create domain MARK_UP_RT_DOM
    INTEGER (2);
 
create domain MISC_MEAS_HH_QY_DOM
    INTEGER (2)
    default 0.000000;
 
create domain MISC_MEAS_QY_DOM
    INTEGER (2)
    default NULL;
 
create domain MISC_MEAS_TYP_ID_DOM
    CHAR (8);
 
create domain MISC_MEAS_TYP_NM_DOM
    CHAR (24);
 
create domain MISC_SVC_TYP_ID_DOM
    CHAR (6);
 
create domain MISC_SVC_TYP_NM_DOM
    CHAR (20);
 
create domain MKRU_PUR_RT_DOM
    INTEGER (2);
 
create domain MKTR_CO_ID_DOM
    CHAR (6);
 
create domain MM_ABR_DOM
    CHAR (3);
 
create domain MM_DEC_SEQ_NB_DOM
    INTEGER;
 
create domain MM_DOM
    CHAR (2);
 
create domain MM_ID_DOM
    CHAR (2);
 
create domain MM_NM_DOM
    CHAR (10);
 
create domain MNDC_MWH_QY_DOM
    INTEGER;
 
create domain MN_DOM
    CHAR (2)
    default '00';
 
create domain MRKU_PUR_RT_DOM
    INTEGER (2);
 
create domain MTR_MWH_DOM
    DOUBLE PRECISION
    default 0.000000;
 
create domain MTR_OWS_CO_ID_DOM
    CHAR (6);
 
create domain MTR_QY_CMT_TX_DOM
    CHAR (64);
 
create domain MTR_QY_DOM
    INTEGER
    default 0;
 
create domain MWH_QY_DOM
    INTEGER
    default 0;
 
create domain MW_QY_DOM
    INTEGER
    default 0;
 
create domain NCP_DD_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain NCP_HH_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain NCP_MM_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain NCP_YY_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain NM_DOM
    CHAR (24);
 
create domain NON_ECON_RPT_SW_DOM
    CHAR (1);
 
create domain OFL_SW_DOM
    CHAR (1);
 
create domain ONE_LINE_NB_DOM
    INTEGER;
 
create domain ON_OFF_PK_CD_DOM
    CHAR (3);
 
create domain OPA_ID_DOM
    CHAR (6);
 
create domain OPA_NB_DOM
    SMALLINT;
 
create domain OPA_NM_DOM
    CHAR (24);
 
create domain ORIG_QUO_RT_DOM
    INTEGER (2);
 
create domain OTG_RSN_CD_DOM
    CHAR (4);
 
create domain OTG_TYP_CD_DOM
    CHAR (2);
 
create domain OTH_UTL_ID_DOM
    CHAR (6);
 
create domain OTRF_ADD_RT_AM_DOM
    INTEGER (2);
 
create domain PK_CD_DOM
    CHAR (3);
 
create domain PK_DAY_TYP_HH_DOM
    CHAR (4);
 
create domain PK_DAY_TYP_ID_DOM
    CHAR (2);
 
create domain PK_DAY_TYP_NM_DOM
    CHAR (10);
 
create domain PK_HH_MWH_QY_DOM
    INTEGER (3)
    default 0;
 
create domain PK_HR_ONL_SW_DOM
    CHAR (1);
 
create domain PK_QY_DOM
    INTEGER (2);
 
create domain PLT_DD_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain PLT_HH_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain PLT_ID_DOM
    CHAR (4);
 
create domain PLT_MM_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain PLT_NM_DOM
    CHAR (24);
 
create domain PLT_YY_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain PRC_FUEL_TYP
    CHAR (4);
 
create domain PRC_FUEL_TYP_DOM
    CHAR (4);
 
create domain PRC_OM_TYP
    CHAR (4);
 
create domain PRC_OM_TYP_DOM
    CHAR (4);
 
create domain PRC_QY_3_DOM
    INTEGER (3);
 
create domain PRC_QY_DOM
    INTEGER (2)
    default 0;
 
create domain PRC_UOM_CD_DOM
    CHAR (6);
 
create domain PRLM_RSV_MW_QY_DOM
    INTEGER;
 
create domain QLT_CD_DOM
    CHAR (1);
 
create domain QUO_PRC_QY_DOM
    INTEGER (2);
 
create domain QY_DOM
    DOUBLE PRECISION
    default 0.000000;
 
create domain RDC_TYP_CD_DOM
    CHAR (3);
 
create domain REAL_OPA_SW_DOM
    CHAR (1)
    default 'Y';
 
create domain REC_ID_DOM
    INTEGER;
 
create domain REC_TYP_ID_DOM
    CHAR (4)
    default 'BOOK';
 
create domain REQ_RSV_MW_QY_DOM
    INTEGER
    default 0;
 
create domain RLY_TX_DOM
    CHAR (96);
 
create domain RNG_MW_DOM
    INTEGER
    default 0;
 
create domain RNG_MW_QY_DOM
    INTEGER
    default 0;
 
create domain RPT_LBL_NM_DOM
    CHAR (10);
 
create domain RPT_SRT_CD_DOM
    CHAR (2);
 
create domain RSD_MWH_ACM_QY_DOM
    DOUBLE PRECISION
    default 0.000000;
 
create domain RSN_CD_DOM
    CHAR (1);
 
create domain RSV_ACT_CMT_TX_DOM
    CHAR (25);
 
create domain RSV_CMT_TX_DOM
    CHAR (120);
 
create domain RSV_MW_QY_DOM
    INTEGER;
 
create domain RT_CALC_METH_ID_DOM
    CHAR (6)
    default 'METH1';
 
create domain RT_SCH_ID_DOM
    CHAR (5);
 
create domain RT_SEAS_ID_DOM
    CHAR (1);
 
create domain SBS_ID_DOM
    CHAR (4);
 
create domain SBS_TX_DOM
    CHAR (96);
 
create domain SCH_ICHG_CMT_TX_DOM
    VARCHAR (255);
 
create domain SCH_ICHG_DD_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain SCH_ICHG_DIR_TYP_ID_DOM
    CHAR (4)
    default 'SAL';
 
create domain SCH_ICHG_HH_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain SCH_ICHG_MM_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain SCH_ICHG_MW_QY_DOM
    INTEGER
    default 0;
 
create domain SCH_ICHG_YY_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain SC_SALE_TAX_RT_DOM
    INTEGER (2);
 
create domain SEAS_ID_DOM
    CHAR (1);
 
create domain SEPA_SW_DOM
    CHAR (1);
 
create domain SK_ACCT_PRD_ID_DOM
    CHAR (1);
 
create domain SRC_ID_DOM
    CHAR (12);
 
create domain SRC_TYP_DOM
    CHAR (4);
 
create domain STATE_ID_DOM
    CHAR (2);
 
create domain STA_CD_DOM
    CHAR (1)
    default 'O';
 
create domain STOR_SW_DOM
    CHAR (1);
 
create domain STR_CR_BAL_QY_DOM
    INTEGER
    default 0;
 
create domain STTL_MTHD_CD_DOM
    CHAR (4);
 
create domain ST_CD
    CHAR (1);
 
create domain SUB_CLS_CD_DOM
    CHAR (2);
 
create domain SUR_TYP_ID_DOM
    CHAR (6)
    default 'PA';
 
create domain SVC_AREA_CD_DOM
    CHAR (3);
 
create domain SW_DOM
    CHAR (1);
 
create domain SW_TX_DOM
    CHAR (96);
 
create domain TAX_TYP_DOM
    CHAR (3);
 
create domain TCP_DD_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain TCP_HH_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain TCP_MM_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain TCP_YY_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain THRD_PTY_RCP_NM_DOM
    CHAR (30);
 
create domain TMPR_QY_DOM
    INTEGER (2)
    default 0;
 
create domain TM_DOM
    CHAR (4);
 
create domain TOP_DD_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain TOP_HH_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain TOP_ICHG_STOR_SW_DOM
    CHAR (1)
    default 'N';
 
create domain TOP_MM_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain TOP_YY_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain TRAN_LOSS_EST_OPA_ID_DOM
    CHAR (6);
 
create domain TRAN_USE_RT_DOM
    INTEGER (2);
 
create domain TRN_FUEL_TYP_DOM
    CHAR (4);
 
create domain TRN_GEN_CT_TYP_DOM
    CHAR (4);
 
create domain TXN_ID_DOM
    CHAR (8);
 
create domain TX_DOM
    CHAR (80);
 
create domain TYP_CD_DOM
    CHAR (1);
 
create domain UGC_DD_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain UGC_HH_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain UGC_MM_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain UGC_YY_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain UGRP_CMT_TX_DOM
    CHAR (20);
 
create domain UGRP_DD_CAP_QY_DOM
    INTEGER;
 
create domain UGRP_DD_CMT_TX_DOM
    CHAR (24);
 
create domain UGRP_DD_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain UGRP_HH_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain UGRP_ID_DOM
    CHAR (4);
 
create domain UGRP_MM_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain UGRP_NON_FS_CAP_QY_DOM
    INTEGER;
 
create domain UGRP_YY_MWH_QY_DOM
    INTEGER
    default 0;
 
create domain UNT_AVG_QY_DOM
    INTEGER (3)
    default 0;
 
create domain UNT_CMT_TX_DOM
    CHAR (20);
 
create domain UNT_DRT_TYP_CD_DOM
    CHAR (3);
 
create domain UNT_ID_DOM
    CHAR (4);
 
create domain UNT_MEAS_ID_DOM
    CHAR (6);
 
create domain UNT_MEAS_NM_DOM
    CHAR (20);
 
create domain UNT_MGT_TYP_CD_DOM
    CHAR (3)
    default 'CPL';
 
create domain UNT_MNDC_MWH_QY_DOM
    INTEGER (3);
 
create domain UNT_RT_SEAS_ID_DOM
    CHAR (1);
 
create domain UNT_RT_SEAS_NM_DOM
    CHAR (6);
 
create domain UNT_STR_NM_DOM
    CHAR (4);
 
create domain UNT_STR_TYP_ID_DOM
    CHAR (1);
 
create domain UNT_STR_UP_CST_FUEL_DOM
    INTEGER (2);
 
create domain UNT_STR_UP_CST_TOT_DOM
    INTEGER (2);
 
create domain UOM_TYP_CD_DOM
    CHAR (6);
 
create domain UOM_TYP_NM_DOM
    CHAR (20);
 
create domain UOT_SW_DOM
    CHAR (1);
 
create domain UPD_CYL_CD_DOM
    CHAR (2)
    default 'HH';
 
create domain USERNAME_DOM
    CHAR (80);
 
create domain USR_NM_DOM
    CHAR (15);
 
create domain VLLY_QY_DOM
    INTEGER (2);
 
create domain VOL_SW_DOM
    CHAR (3);
 
create domain WTH_CMT_TX_DOM
    CHAR (64);
 
create domain WTH_MEAS_QY_DOM
    INTEGER
    default 0;
 
create domain WTH_MEAS_TYP_ID_DOM
    CHAR (4);
 
create domain WTH_STN_ID_DOM
    CHAR (4);
 
create domain WTR_BYP_DD_QY_DOM
    INTEGER
    default 0;
 
create domain WTR_BYP_HH_QY_DOM
    INTEGER
    default 0;
 
create domain WTR_BYP_MM_QY_DOM
    INTEGER
    default 0;
 
create domain WTR_BYP_YY_QY_DOM
    INTEGER
    default 0;
 
create domain WTR_QY_DOM
    INTEGER
    default 0;
 
create domain WTR_USE_DD_QY_DOM
    INTEGER
    default 0;
 
create domain WTR_USE_MM_QY_DOM
    INTEGER
    default 0;
 
create domain WTR_USE_YY_QY_DOM
    INTEGER
    default 0;
 
create domain WW_NB_QY_DOM
    INTEGER
    default 0;
 
create domain YY_DOM
    CHAR (4);
 
commit work;

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                             Function Definitions
--
------------------------------------------------------------------------
--------
-- no functions defined

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                              Table Definitions
--
------------------------------------------------------------------------
--------
create table CAL_DT (
    CAL_DT DT_DOM,
    NXT_DT DT_DOM,
    PK_DAY_TYP_ID PK_DAY_TYP_ID_DOM,
    DST_CHG_CD DST_CHG_CD_DOM,
    CO_HOL_SW CO_HOL_SW_DOM,
    DST_1AM_SW DST_1AM_SW_DOM,
    constraint CAL_DT_PK
        primary key (CAL_DT)
        deferrable);
comment on table CAL_DT is
 'A representation of a particular year, month, and day in the Gregorian
calendar.'
;
comment on column CAL_DT.CAL_DT is
 'Represents a division of the time in terms of the day, month, and year
in the Gregorian calendar.'
;
comment on column CAL_DT.NXT_DT is
 'Provides the next days date for the date represented as a row in the
CAL DT table.  This is required due to a limitation within RALLY
limiting the result of a calculation as a table search arguement.'
;
comment on column CAL_DT.PK_DAY_TYP_ID is
 'The peak day types provided by FERC which the Company uses for
inadvertent accounting.  Examples:  HO - Holiday, WD - Weekday and WE -
Weekend.'
;
comment on column CAL_DT.DST_CHG_CD is
 'A code which indicates whether daylight savings time starts or ends on
the date identified.'
;
comment on column CAL_DT.CO_HOL_SW is
 'Indicates whether or not the date is an official Company holiday.';
comment on column CAL_DT.DST_1AM_SW is
 'Indicates whether on the day that daylight savings time ends, i.e.,
when a one hour fallback occurs, that the 1AM hour has already been used
and that the second 1AM hour needs to be put into the 2AM slot.'
;
 
create table CO (
    CO_ID CO_ID_DOM,
    NM CO_NM_DOM,
    MKTR_SW SW_DOM,
    BRKR_SW SW_DOM,
    OTH_UTL_SW SW_DOM,
    constraint CO_PK
        primary key (CO_ID)
        deferrable);
comment on column CO.CO_ID is
 'The identifier which denotes a specific commercial or industrial
enterprise.  Examples:  CPL - Carolina Power & Light Co., DUKE - Duke
Power Company, FSTWHL - Foster Wheeler, etc.'
;
comment on column CO.NM is
 'The name associated with a specific commercial or industrial
enterprise.  Examples:  Carolina Power & Light, Duke Power Company,
Foster Wheeler, etc.'
;
 
create table CUS (
    CUS_ID CUS_ID_DOM,
    CUS_NM CUS_NM_DOM,
    SVC_AREA_CD SVC_AREA_CD_DOM,
    constraint CUS_ID_PK
        primary key (CUS_ID)
        deferrable);
comment on table CUS is
 'An individual, firm or organization who receives or who may
potentially receive charged or non/charged services, or makes a
voluntary contribution to a company community assistance program  or is
involved in a claim initiated by CP&L.'
;
comment on column CUS.CUS_ID is
 'The identifier which denotes an individual, firm or organization who
receives charged or non/charged services, or makes a voluntary
contribution to a company community assistance program or is involved in
a claim initiated by CP&L.'
;
comment on column CUS.CUS_NM is
 'The name associated with a specific CUSTOMER of interest to the
corporation.  Examples:  Power Agency, etc.'
;
comment on column CUS.SVC_AREA_CD is
 'Indicates whether a specific customer is located internal or external
to the companys defined service area territory.'
;
 
create table DAY_TYP (
    DAY_TYP_ID DAY_TYP_ID_DOM,
    NM DAY_NM_DOM,
    PK_DAY_TYP_ID PK_DAY_TYP_ID_DOM,
    constraint DAY_TYP_PRIMARY_DAY_TYP_ID
        primary key (DAY_TYP_ID)
        deferrable);
comment on table DAY_TYP is
 'A period of time consisting of twenty-four hours and including the
solar day and night.  This is the period of time during which the earth
makes one revolution on its axis.'
;
comment on column DAY_TYP.DAY_TYP_ID is
 'The weekday types that can occur during a specific week. Examples: SUN
- Sunday, MON - Monday, TUE - Tuesday, WED - Wednesday, THU - Thursday,
FRI - Friday, SAT - Saturday.'
;
comment on column DAY_TYP.NM is
 'The name associated with a specific DAY TYPE within a specific week.
Examples: Monday, Tuesday, Wednesday, etc.'
;
comment on column DAY_TYP.PK_DAY_TYP_ID is
 'A peak day type provided by FERC which the Company uses for
inadvertent accounting that is assigned to a specific day type.
Examples:  MON - Monday is considered a WD - Weekday by FERC, etc.'
;
 
create table MISC_MEAS_TYP (
    MISC_MEAS_TYP_ID MISC_MEAS_TYP_ID_DOM,
    MISC_MEAS_TYP_NM MISC_MEAS_TYP_NM_DOM,
    UNT_MEAS_NM UNT_MEAS_NM_DOM,
    ADD_INDC_SW ADD_INDC_SW_DOM,
    ACCT_ITV_NB ACCT_ITV_NB_DOM,
    INTR_VAL_SW SW_DOM
        default 'N',
    LO_HR_MEAS_QY MISC_MEAS_QY_DOM,
    HI_HR_MEAS_QY MISC_MEAS_QY_DOM,
    constraint MISC_MEAS_TYP_ID_PK
        primary key (MISC_MEAS_TYP_ID)
        deferrable);
comment on table MISC_MEAS_TYP is
 'A type of measurement that is used to manage the electrical system and
is often required to be maintained historically.'
;
comment on column MISC_MEAS_TYP.MISC_MEAS_TYP_ID is
 'The identifier which denotes a specific measurement type of interest
to the corporation.  Examples include: gross MWH, auxiliary MWH, coal
handling MWH, ACE, LAMBDA, temperature, etc.'
;
comment on column MISC_MEAS_TYP.MISC_MEAS_TYP_NM is
 'The name associated with a specific MEASUREMENT TYPE.';
comment on column MISC_MEAS_TYP.UNT_MEAS_NM is
 'The name of the unit of measure reported with a specific measurement
type.  Examples: MW, MWH, DOL, DEGF, etc.'
;
comment on column MISC_MEAS_TYP.ADD_INDC_SW is
 'Indicates whether discrete measures for this specific measurement type
are addable or not.  Examples - ACE is not addable, METERED LOAD is
addable, etc.'
;
comment on column MISC_MEAS_TYP.ACCT_ITV_NB is
 'Indicates the number of intervals within an hour for which
measurements associated with this measurement type are stored within EMS
Energy Accounting.'
;
 
create table OPA (
    OPA_ID OPA_ID_DOM,
    NM OPA_NM_DOM,
    CO_ID CO_ID_DOM,
    EXTR_OPA_NB EXTR_NB_DOM,
    MKTR_SW SW_DOM,
    OTH_UTL_SW SW_DOM,
    constraint OPA_PK
        primary key (OPA_ID)
        deferrable);
comment on table OPA is
 'A territorial partition of a company used as a control or generation
level for energy management.'
;
comment on column OPA.OPA_ID is
 'The identifier which denotes a specific contiguous territorial
partition of the Company used as a control area for energy management.'
;
comment on column OPA.NM is
 'The name of a specific contiguous territorial area of a company that
is controlled for energy management purposes. Examples: CP&L East, CP&L
West, Duke, etc.'
;
comment on column OPA.CO_ID is
 'The identifier which denotes the specific commercial or industrial
enterprise of which a specific operating area is part.'
;
comment on column OPA.EXTR_OPA_NB is
 'Provides the number by which the operating area is known on the AIB
Extract file.'
;
 
create table TCP (
    TCP_1_CO_ID CO_ID_DOM,
    TCP_2_CO_ID CO_ID_DOM,
    REAL_CO_SW SW_DOM,
    constraint TCP_PK
        primary key (TCP_1_CO_ID, TCP_2_CO_ID)
        deferrable);
comment on table TCP is
 'Specifies two electric companies which have an agreement to sell/buy
electric power from one another.'
;
comment on column TCP.TCP_1_CO_ID is
 'The identifier which denotes the first of the specific commercial or
industrial enterprises in a pair who are identified as valid
participants in the sale or purchase of electricity.'
;
comment on column TCP.TCP_2_CO_ID is
 'The identifier which denotes the second of the specific commercial or
industrial enterprises in a pair who are identified as valid
participants in the sale or purchase of electricity.'
;
 
create table TCP_ICHG (
    ICHG_TYP_ID ICHG_TYP_ID_DOM,
    TCP_1_CO_ID CO_ID_DOM,
    TCP_2_CO_ID CO_ID_DOM,
    BUY_INDC_SW BUY_SELL_INDC_SW_DOM,
    SELL_INDC_SW BUY_SELL_INDC_SW_DOM,
    FIRM_PRC_INDC_SW SW_DOM,
    LOSS_RT_QY LOSS_RT_QY_DOM,
    FIRM_SW SW_DOM,
    OPA_NB OPA_NB_DOM,
    ICHG_TYP_GRP_ID ICHG_TYP_ID_DOM,
    WHL_2_OPA_ID OPA_ID_DOM,
    constraint TCP_ICHG_PK
        primary key (ICHG_TYP_ID, TCP_1_CO_ID, TCP_2_CO_ID)
        deferrable);
comment on table TCP_ICHG is
 'A combination of TRANSACTING COMPANY PAIR and INTERCHANGE TYPE that
are valid.'
;
comment on column TCP_ICHG.ICHG_TYP_ID is
 'The interchange type identifier that is valid for a specific
transacting company pair.  The interchange type defines the conditions
under which power is exchanged, as well as the conditions for
accounting, billing and payment.'
;
comment on column TCP_ICHG.TCP_1_CO_ID is
 'The identifier which denotes the first company in a company pair who
are identified as valid participants in the sale or purchase of
electricity for a specific type of interchange.'
;
comment on column TCP_ICHG.TCP_2_CO_ID is
 'The identifier which denotes the second company in a company pair who
are identified as valid participants in the sale or purchase of
electricity for a specific type of interchange.'
;
comment on column TCP_ICHG.BUY_INDC_SW is
 'Indicates whether the company identified in transacting company 1 can
buy energy from the company identified in transacting company 2.'
;
comment on column TCP_ICHG.SELL_INDC_SW is
 'Indicates whether the company identified in transacting company 1 can
sell energy to the company identified in transacting company 2.'
;
 
create table TOP (
    TOP_1_OPA_ID OPA_ID_DOM,
    TOP_2_OPA_ID OPA_ID_DOM,
    REAL_OPA_SW REAL_OPA_SW_DOM,
    constraint TOP_PK
        primary key (TOP_1_OPA_ID, TOP_2_OPA_ID)
        deferrable);
comment on table TOP is
 'Specifies two OPERATING AREAs which have an agreement to sell/buy
power from one another.'
;
comment on column TOP.TOP_1_OPA_ID is
 'The identifier which denotes the first operating area in a pair of
operating areas who are identified as valid participants in the exchange
of electricity.'
;
comment on column TOP.TOP_2_OPA_ID is
 'The identifier which denotes the second operating area in a pair of
operating areas who are identified as valid participants in the exchange
of electricity.'
;
comment on column TOP.REAL_OPA_SW is
 'Indicates whether the operating area specified as the second of the
two operating areas in the pair is a real operating area or not.'
;
 
create table TOP_ICHG (
    ICHG_TYP_ID ICHG_TYP_ID_DOM,
    TOP_1_OPA_ID OPA_ID_DOM,
    TOP_2_OPA_ID OPA_ID_DOM,
    BUY_INDC_SW BUY_SELL_INDC_SW_DOM,
    SELL_INDC_SW BUY_SELL_INDC_SW_DOM,
    AIB_INDC_SW AIB_INDC_SW_DOM,
    FIRM_PRC_INDC_SW FIRM_PRC_INDC_SW_DOM,
    EXTR_PUR_IND_NB EXTR_NB_DOM,
    EXTR_SALE_IND_NB EXTR_NB_DOM,
    EXTR_AIB_PUR_NB EXTR_NB_DOM,
    EXTR_AIB_SALE_NB EXTR_NB_DOM,
    LOSS_RT_QY LOSS_RT_QY_DOM,
    ADJ_ICHG_PT_ID ADJ_ICHG_PT_ID_DOM,
    FUT_EVN_SW FUT_EVN_SW_DOM,
    FIRM_SW FIRM_SW_DOM,
    FIRM_DEG_CD FIRM_DEG_CD_DOM,
    WHL_1_OPA_ID OPA_ID_DOM,
    WHL_2_OPA_ID OPA_ID_DOM,
    WHL_ICHG_TYP_ID ICHG_TYP_ID_DOM,
    OPA_NB OPA_NB_DOM,
    NON_ECON_RPT_SW NON_ECON_RPT_SW_DOM,
    CAP_PRTE_DD_NB CAP_PRTE_DD_NB_DOM,
    TOP_ICHG_STOR_SW TOP_ICHG_STOR_SW_DOM,
    IMPL_CAP_SW SW_DOM
        default 'N',
    SUM_INDX_SW SW_DOM
        default 'N',
    ICHG_TYP_GRP_ID ICHG_TYP_ID_DOM,
    constraint TOP_ICHG_PK
        primary key (ICHG_TYP_ID, TOP_1_OPA_ID, TOP_2_OPA_ID)
        deferrable);
comment on table TOP_ICHG is
 'A combination of two operating areas that are allowed to transact
along with a valid type of interchange that is allowed to occur between
the two operating areas.  CP&L may be the direct purchaser or seller of
the power.'
;
comment on column TOP_ICHG.ICHG_TYP_ID is
 'The interchange type identifier that is valid for a specific
transacting operating area pair.  The interchange type defines the
conditions under which power is exchanged, as well as the conditions for
accounting, billing and payment.'
;
comment on column TOP_ICHG.TOP_1_OPA_ID is
 'The identifier which denotes the first operating area in a pair of
operating areas who are identified as valid participants in the exchange
of electricity.'
;
comment on column TOP_ICHG.TOP_2_OPA_ID is
 'The identifier which denotes the second operating area in a pair of
operating areas who are identified as valid participants in the exchange
of electricity.'
;
comment on column TOP_ICHG.BUY_INDC_SW is
 'Indicates whether the operating area identified in transacting
operatinga area 1 can buy energy from the operating area identified in
transacting operating area 2.'
;
comment on column TOP_ICHG.SELL_INDC_SW is
 'Indicates whether the operating area identified in transacting
operating area 1 can sell energy to the operating area identified in
transacting operating area 2.'
;
comment on column TOP_ICHG.AIB_INDC_SW is
 'Indicates whether the details associated with this transacting
operating area pair and interchange type combination are required for
processing within the Automated Interchange Billing process.'
;
comment on column TOP_ICHG.FIRM_PRC_INDC_SW is
 'Indicates if there is a firm price assoicated with the Interchange
Type for the transacting operating area pair as specified by contract.'
;
comment on column TOP_ICHG.EXTR_PUR_IND_NB is
 'Provides the index number of the data location within a block of data
on the AIB Extract file which contains the measurement for purchases
associated with this transacting operating area interchange.'
;
comment on column TOP_ICHG.EXTR_SALE_IND_NB is
 'Provides the index number of the data location within a block of data
on the AIB Extract file which contains the measurement for sales of
energy associated with this specific transacting operating area pair
interchange.'
;
comment on column TOP_ICHG.EXTR_AIB_PUR_NB is
 'Provides the number by which purchases associated with this specific
interchange type are identified for this specific transacting operating
area pair in the AIB portion of the EAS extract data.'
;
comment on column TOP_ICHG.EXTR_AIB_SALE_NB is
 'Provides the number by which sales associated with this specific
interchange type are identified for this specific transacting operating
area pair in the AIB portion of the EAS extract data.'
;
comment on column TOP_ICHG.LOSS_RT_QY is
 'The rate factor used to determine the amount of line loss attributed
to a specific interchange when a scheduled interchange path is used
involving the specific transacting operating area pair named.'
;
comment on column TOP_ICHG.ADJ_ICHG_PT_ID is
 'The identifier of an interchange adjustment which must use the details
of power exchanged associated with this specific scheduled interchange
type between two transacting areas as a component of the interchange
adjustment total between two areas.'
;
comment on column TOP_ICHG.FUT_EVN_SW is
 'Indicates whether the details of events which are scheduled in the
future are valid in the Energy Accounting portion of the Energy
Management process.  These events are with a specific transacting
operating area pair and type combination.'
;
comment on column TOP_ICHG.FIRM_SW is
 'Indicates whether for this specific transacting operating area pair
interchange an agreed upon amount of capacity available must be reserved
in advance prior to the scheduling of the energy.'
;
comment on column TOP_ICHG.FIRM_DEG_CD is
 'Indicates the degree of firmness for those transacting operating area
pair interchange types that have been designated as firm.  Example: H -
High degree of firmness, L - Low degree of firmness, etc.'
;
comment on column TOP_ICHG.WHL_1_OPA_ID is
 'The identifier which denotes the first operating area in a the
transacting operating area pair interchange which will contain the
reciprocal schedule interchange for this interchange which is part of a
wheeling transaction.'
;
comment on column TOP_ICHG.WHL_2_OPA_ID is
 'The identifier which denotes the second operating area in a the
transacting operating area pair interchange which will contain the
reciprocal schedule interchange for this interchange which is part of a
wheeling transaction.'
;
comment on column TOP_ICHG.WHL_ICHG_TYP_ID is
 'The identifier which denotes the interchange type in a the transacting
operating area pair interchange which will contain the reciprocal
schedule interchange for this interchange which is part of a wheeling
transaction.'
;
comment on column TOP_ICHG.OPA_NB is
 'The number of operating areas involved in a specific path for a
specific transacting operating area pair path.'
;
comment on column TOP_ICHG.NON_ECON_RPT_SW is
 'Indicates whether capacity and energy schedules for this transacting
operating area pair and interchange type combination should be included
on the non-economy report.'
;
comment on column TOP_ICHG.CAP_PRTE_DD_NB is
 'The number of days used that are used in the proration formula for
capacity calculations when there is a short week, i.e., a week in a
month with less than 7 days in the same week.'
;
comment on column TOP_ICHG.TOP_ICHG_STOR_SW is
 'Indicates whether storage account balances are maintained for this
particulat transacting operating area pair and interchange type
combination.'
;
 
create table ATC_REQUEST (
    ATC_REQUEST_ID
        INTEGER,
    REQUEST_TIME DT_DOM,
    NETWORK_SOURCE
        CHAR (6),
    NETWORK_SINK
        CHAR (6),
    STUDY_DATE DT_DOM,
    STUDY_HH
        CHAR (2),
    FIRM_MW_QY
        INTEGER,
    NON_FIRM_MW_QY
        INTEGER);
 
create table SOURCE_SINK (
    SOURCE_SINK
        VARCHAR (14)
        constraint SOURCE_SINK_NOT_NULL1
            not null
            deferrable,
    SOURCE_SINK_NAME
        VARCHAR (80),
    NETWORK_SOURCE_SINK
        CHAR (6),
    constraint SOURCE_SINK_PRIMARY_SOURCE_SINK
        primary key (SOURCE_SINK)
        deferrable);
 
create table "STATUS" (
    STATUS_ID
        INTEGER,
    STATUS_NAME
        CHAR (20),
    STATUS_DESCRIPTION
        CHAR (50),
    constraint STATUS_PRIMARY_STATUS_ID
        primary key (STATUS_ID)
        deferrable);
 
create table TRANS_DURATION_TYPE (
    CAPACITY_DURATION
        VARCHAR (14)
        constraint TRANS_DURATION_TYP_NOT_NULL1
            not null
            deferrable,
    DURATION_DEFINITION
        VARCHAR (80),
    constraint TRANS_DURATION_TYP_PRIMARY1
        primary key (CAPACITY_DURATION)
        deferrable);
 
create table STATUS_OF_PATH (
    PATH_STATUS_ID
        TINYINT,
    DESCRIPTION
        VARCHAR (80)
        constraint STATUS_OF_PATH_NOT_NULL1
            not null
            deferrable,
    constraint STATUS_OF_PATH_PRIMARY1
        primary key (PATH_STATUS_ID)
        deferrable);
 
create table TRANS_REQUEST_STATUS (
    REQUEST_STATUS_ID
        TINYINT,
    DESCRIPTION
        VARCHAR (80)
        constraint TRANS_REQUEST_STAT_NOT_NULL1
            not null
            deferrable,
    constraint TRANS_REQUEST_STAT_PRIMARY1
        primary key (REQUEST_STATUS_ID)
        deferrable);
 
create table SRC_SNK_TYPE (
    SOURCE_SINK_TYPE
        TINYINT,
    DESCRIPTION
        VARCHAR (80)
        constraint SRC_SNK_TYPE_NOT_NULL1
            not null
            deferrable,
    constraint SRC_SNK_TYPE_PRIMARY1
        primary key (SOURCE_SINK_TYPE)
        deferrable);
 
create table SP_TYPE (
    SERVICE_POINT_TYPE
        TINYINT,
    DESCRIPTION
        VARCHAR (80)
        constraint SP_TYPE_DESCRIPTION_NOT_NULL
            not null
            deferrable,
    constraint SP_TYPE_PRIMARY1
        primary key (SERVICE_POINT_TYPE)
        deferrable);
 
create table STATUS_OF_RECORD (
    STATUS_ID
        TINYINT,
    DESCRIPTION
        VARCHAR (80)
        constraint STATUS_OF_RECORD_NOT_NULL1
            not null
            deferrable,
    constraint STATUS_OF_RECORD_PRIMARY1
        primary key (STATUS_ID)
        deferrable);
 
create table COMPANY (
    COMPANY_ID
        INTEGER,
    FULL_COMPANY_NAME
        VARCHAR (50),
    COMPANY_NAME
        VARCHAR (25)
        constraint COMPANY_COMPANY_NAME_NOT_NULL
            not null
            deferrable,
    DUNS
        VARCHAR (12)
        constraint COMPANY_DUNS_NOT_NULL
            not null
            deferrable,
    "STATUS"
        TINYINT
        constraint COMPANY_STATUS_NOT_NULL
            not null
            deferrable,
    OWNER_CODE
        VARCHAR (4),
    TIME_OF_LAST_UPDATE DT_DOM,
    PRIMARY_PROVIDER_FLAG
        TINYINT,
    RETURN_TZ
        VARCHAR (8),
    constraint COMPANY_PRIMARY_COMPANY_ID
        primary key (COMPANY_ID)
        deferrable);
 
create table SERVICE_POINT (
    SERVICE_POINT_ID
        INTEGER,
    SERVICE_POINT_NAME
        VARCHAR (12)
        constraint SERVICE_POINT_NOT_NULL1
            not null
            deferrable,
    "STATUS"
        TINYINT
        constraint SERVICE_POINT_STATUS_NOT_NULL
            not null
            deferrable,
    PROVIDER
        INTEGER
        constraint SERVICE_POINT_PROVIDER_NOT_NULL
            not null
            deferrable,
    PROVIDER_COMMENT
        VARCHAR (255),
    SERVICE_POINT_TYPE
        TINYINT
        constraint SERVICE_POINT_NOT_NULL2
            not null
            deferrable,
    TIME_OF_LAST_UPDATE DT_DOM,
    SOURCE_SINK_TYPE
        TINYINT
        constraint SERVICE_POINT_NOT_NULL3
            not null
            deferrable,
    NETWORK_SERVICE_POINT_NAME
        CHAR (22),
    RESERVABLE
        TINYINT,
    constraint SERVICE_POINT_PRIMARY1
        primary key (SERVICE_POINT_ID)
        deferrable);
 
create table PATH (
    PATH_ID
        INTEGER,
    POINT_OF_DELIVERY
        INTEGER,
    PROVIDER
        INTEGER
        constraint PATH_PROVIDER_NOT_NULL
            not null
            deferrable,
    POINT_OF_RECEIPT
        INTEGER,
    PATH_NAME
        VARCHAR (50)
        constraint PATH_PATH_NAME_NOT_NULL
            not null
            deferrable,
    REGION_CODE
        VARCHAR (2),
    OWNER_CODE
        VARCHAR (4),
    PATH_CODE
        VARCHAR (12)
        constraint PATH_PATH_CODE_NOT_NULL
            not null
            deferrable,
    OPTIONAL_CODE
        VARCHAR (25),
    SPARE_CODE
        VARCHAR (3),
    INTERFACE_TYPE
        CHAR (2),
    "STATUS"
        TINYINT
        constraint PATH_STATUS_NOT_NULL
            not null
            deferrable,
    CONSTRAINED
        SMALLINT,
    TIME_OF_LAST_UPDATE DT_DOM,
    TOP_2_OPA_ID OPA_ID_DOM,
    SCH_ICHG_DIR_TYP_ID ICHG_DIR_TYP_ID_DOM,
    NETWORK_PATH
        CHAR (48),
    DISP_SW
        INTEGER,
    EMS_ORDER_SEQ
        INTEGER,
    RESERVABLE
        TINYINT,
    POSTABLE
        TINYINT,
    LOCAL_SELECT_SW
        INTEGER
        default 0,
    constraint PATH_PRIMARY_PATH_ID
        primary key (PATH_ID)
        deferrable);
 
create table TSIN_USER (
    USER_ID
        INTEGER,
    COMPANY_ID
        INTEGER
        constraint TSIN_USER_COMPANY_ID_NOT_NULL
            not null
            deferrable,
    "NAME"
        VARCHAR (25)
        constraint TSIN_USER_NAME_NOT_NULL
            not null
            deferrable,
    PHONE
        VARCHAR (20),
    FAX
        VARCHAR (20),
    EMAIL
        VARCHAR (60),
    "STATUS"
        TINYINT
        constraint TSIN_USER_STATUS_NOT_NULL
            not null
            deferrable,
    CERTIFICATE_NAME
        VARCHAR (128),
    DATABASE_NAME
        VARCHAR (30),
    TIME_OF_LAST_UPDATE DT_DOM,
    constraint TSIN_USER_PRIMARY_USER_ID
        primary key (USER_ID)
        deferrable);
 
create table OFFER_TYPE (
    DESCRIPTION
        VARCHAR (80)
        constraint OFFER_TYPE_DESCRIPTION_NOT_NULL
            not null
            deferrable,
    OFFERING_TYPE_ID
        TINYINT,
    constraint OFFER_TYPE_PRIMARY1
        primary key (OFFERING_TYPE_ID)
        deferrable);
 
create table SUMMARY_TYPE (
    SUMMARY_ID
        TINYINT,
    DESCRIPTION
        VARCHAR (80)
        constraint SUMMARY_TYPE_NOT_NULL1
            not null
            deferrable,
    constraint SUMMARY_TYPE_PRIMARY_SUMMARY_ID
        primary key (SUMMARY_ID)
        deferrable);
 
create table SERVICE (
    SERVICE_ID
        INTEGER,
    PROVIDER
        INTEGER
        constraint SERVICE_PROVIDER_NOT_NULL
            not null
            deferrable,
    OFFERING_TYPE
        TINYINT
        constraint SERVICE_OFFERING_TYPE_NOT_NULL
            not null
            deferrable,
    SERVICE_NAME
        VARCHAR (50)
        constraint SERVICE_SERVICE_NAME_NOT_NULL
            not null
            deferrable,
    SERVICE_DESCRIPTION
        VARCHAR (200),
    TARIFF
        VARCHAR (150),
    TIME_OF_LAST_UPDATE DT_DOM,
    SUMMARY
        TINYINT
        constraint SERVICE_SUMMARY_NOT_NULL
            not null
            deferrable,
    SUMMARY_SEQ
        SMALLINT,
    "STATUS"
        TINYINT
        constraint SERVICE_STATUS_NOT_NULL
            not null
            deferrable,
    PRICE_UNITS
        VARCHAR (6),
    CURT_SEQ
        INTEGER,
    EFF_START_DT DT_DOM,
    PRICE
        INTEGER (2),
    FIRM_SW
        INTEGER,
    RESERVABLE
        INTEGER,
    ON_PEAK_SW
        INTEGER,
    constraint SERVICE_PRIMARY_SERVICE_ID
        primary key (SERVICE_ID)
        deferrable);
 
create table TRANSMISSION_REQUEST (
    REQUEST_ID
        INTEGER,
    SELLER
        INTEGER,
    SELLER_COMPANY
        INTEGER
        constraint TRANSMISSION_REQUE_NOT_NULL1
            not null
            deferrable,
    PATH_ID
        INTEGER,
    POINT_OF_RECEIPT
        INTEGER,
    POINT_OF_DELIVERY
        INTEGER,
    CAPACITY_TYPE
        INTEGER
        constraint TRANSMISSION_REQUE_NOT_NULL2
            not null
            deferrable,
    CUSTOMER
        INTEGER
        constraint TRANSMISSION_REQUE_NOT_NULL3
            not null
            deferrable,
    BEGTIME DT_DOM
        constraint TRANSMISSION_REQUE_NOT_NULL4
            not null
            deferrable,
    ENDTIME DT_DOM
        constraint TRANSMISSION_REQUE_NOT_NULL5
            not null
            deferrable,
    SALE_REF
        VARCHAR (12),
    DEAL_REF
        VARCHAR (12),
    REQUEST_QUEUE_TIME DT_DOM,
    REQUEST_REF
        VARCHAR (12),
    REQUEST_STATUS
        SMALLINT
        constraint TRANSMISSION_REQUE_NOT_NULL9
            not null
            deferrable,
    "SOURCE"
        VARCHAR (14),
    SINK
        VARCHAR (14),
    TIME_OF_LAST_UPDATE DT_DOM,
    STATUS_COMMENTS
        VARCHAR (80),
    CUSTOMER_COMMENTS
        VARCHAR (80),
    PRECONFIRMED
        SMALLINT,
    PRESCHEDULE
        SMALLINT,
    ENERGY_RATE
        INTEGER (3),
    LOSS_RATE
        INTEGER (3),
    LOSS_SUPPLIER
        CHAR (10),
    FUEL_RATE
        INTEGER (3),
    DEPOSIT
        INTEGER (2),
    INTEREST
        INTEGER (3),
    EVAL_SW
        INTEGER,
    SELLER_COMMENTS
        CHAR (80),
    PROVIDER_COMMENTS
        CHAR (80),
    POST_TO_OASIS_SW
        INTEGER,
    OASIS_REQUEST_ID
        INTEGER,
    UPDATE_FROM_OASIS
        CHAR (6),
    POST_TO_OASIS_STATUS
        INTEGER,
    NATIVE_LOAD_SW
        INTEGER
        default 0,
    constraint TRANSMISSION_REQUE_PRIMARY1
        primary key (REQUEST_ID)
        deferrable);
 
create table RE_ASSIGNMENT (
    RA_ID
        INTEGER,
    OLD_REQUEST
        INTEGER
        constraint RE_ASSIGNMENT_NOT_NULL1
            not null
            deferrable,
    NEW_REQUEST
        INTEGER
        constraint RE_ASSIGNMENT_NOT_NULL2
            not null
            deferrable,
    BEGTIME DT_DOM
        constraint RE_ASSIGNMENT_BEGTIME_NOT_NULL
            not null
            deferrable,
    ENDTIME DT_DOM
        constraint RE_ASSIGNMENT_ENDTIME_NOT_NULL
            not null
            deferrable,
    CAPACITY
        REAL,
    TIME_OF_LAST_UPDATE DT_DOM,
    constraint RE_ASSIGNMENT_PRIMARY_RA_ID
        primary key (RA_ID)
        deferrable);
 
create table AUDIT_LOG (
    AUDIT_ID
        INTEGER,
    USER_ID
        INTEGER,
    TIME_STAMP DT_DOM,
    TEMPLATE
        VARCHAR (20),
    TABLE_ID
        VARCHAR (50),
    constraint AUDIT_LOG_PRIMARY_AUDIT_ID
        primary key (AUDIT_ID)
        deferrable);
 
create table CHANGE_DETAILS (
    CHANGE_ID
        INTEGER,
    AUDIT_ID
        INTEGER
        constraint CHANGE_DETAILS_NOT_NULL1
            not null
            deferrable,
    ELEMENT_NAME
        VARCHAR (40),
    OLD_DATA
        VARCHAR (20),
    NEW_DATA
        VARCHAR (20),
    constraint CHANGE_DETAILS_PRIMARY1
        primary key (CHANGE_ID)
        deferrable);
 
create table REQUEST_SEGMENT (
    SEGMENT_ID
        INTEGER,
    REQUEST_ID
        INTEGER
        constraint REQUEST_SEGMENT_NOT_NULL1
            not null
            deferrable,
    CAPACITY
        INTEGER (2),
    PRICE
        INTEGER (2)
        constraint REQUEST_SEGMENT_PRICE_NOT_NULL
            not null
            deferrable,
    BEGTIME DT_DOM,
    ENDTIME DT_DOM,
    TIME_OF_LAST_UPDATE DT_DOM,
    CBM_TYPE_SW
        INTEGER
        default 0,
    OASIS_REQUEST_ID
        INTEGER,
    OASIS_SEGMENT_ID
        INTEGER,
    POST_TO_OASIS_SW
        INTEGER,
    constraint REQUEST_SEGMENT_PRIMARY1
        primary key (SEGMENT_ID)
        deferrable);
 
create table CURTAILMENT (
    CURTAILMENT_ID
        INTEGER,
    SEGMENT_ID
        INTEGER
        constraint CURTAILMENT_SEGMENT_ID_NOT_NULL
            not null
            deferrable,
    BEGTIME DT_DOM,
    CAPACITY_CURTAILED
        REAL,
    CURTAILMENT_REASON
        VARCHAR (80),
    CURTAILMENT_PROCEDURES
        VARCHAR (80),
    CURTAILMENT_OPTIONS
        VARCHAR (80),
    TIME_OF_LAST_UPDATE DT_DOM,
    constraint CURTAILMENT_PRIMARY1
        primary key (CURTAILMENT_ID)
        deferrable);
 
create table "SCHEDULE" (
    SCHEDULE_ID
        INTEGER,
    SEGMENT_ID
        INTEGER
        constraint SCHEDULE_SEGMENT_ID_NOT_NULL
            not null
            deferrable,
    BEGTIME DT_DOM,
    CAPACITY_SCHEDULED
        REAL,
    TIME_OF_LAST_UPDATE DT_DOM,
    OASIS_SCHEDULE_ID
        INTEGER,
    POST_TO_OASIS_SW
        INTEGER,
    OASIS_SEGMENT_ID
        INTEGER,
    constraint SCHEDULE_PRIMARY_SCHEDULE_ID
        primary key (SCHEDULE_ID)
        deferrable);
 
create table EVAL_REQUEST (
    REQUEST_TIME DT_DOM,
    CLONE_NAME
        CHAR (5),
    STUDY_TYPE
        CHAR (1),
    XTTC_TIMESTAMP DT_DOM,
    STUDY_BEGTIME DT_DOM,
    "RANGE"
        SMALLINT,
    TRANS_REQUEST_ID
        VARCHAR (100),
    POST_TO_OASIS_SW
        INTEGER,
    ACCEPT_SW
        INTEGER,
    OASIS_REQUEST_ID
        VARCHAR (100),
    EVAL_REQUEST_NUMBER
        INTEGER,
    constraint EVAL_REQUEST_PRIMARY1
        primary key (REQUEST_TIME, CLONE_NAME, STUDY_TYPE)
        deferrable);
 
create table EVAL_REQUIRED_TIME (
    CLONE_NAME
        CHAR (5),
    REQUIRED_TIME
        DOUBLE PRECISION,
    EFF_START_DT DT_DOM,
    UOM
        CHAR (7),
    constraint EVAL_PK
        primary key (CLONE_NAME, REQUIRED_TIME, EFF_START_DT)
        deferrable);
 
create table NETWORK_FACTOR (
    EVN_DT DT_DOM,
    NETWORK_SOURCE
        CHAR (6),
    NETWORK_SINK
        CHAR (6),
    NETWORK_RESPONSE_FACTOR
        INTEGER (4),
    PATH_CODE
        VARCHAR (12),
    constraint NETWORK_FACTOR_PK
        primary key (EVN_DT, NETWORK_SOURCE, NETWORK_SINK, PATH_CODE)
        deferrable);
 
create table NETWORK_SOURCE_SINK (
    "SOURCE"
        VARCHAR (14)
        constraint NETWORK_SOURCE_SIN_NOT_NULL1
            not null
            deferrable,
    SINK
        VARCHAR (14)
        constraint NETWORK_SOURCE_SIN_NOT_NULL2
            not null
            deferrable,
    NETWORK_SOURCE_SINK_ID
        VARCHAR (14)
        constraint NETWORK_SOURCE_SIN_NOT_NULL3
            not null
            deferrable,
    constraint NETWORK_SOURCE_SIN_PRIMARY1
        primary key ("SOURCE", SINK)
        deferrable);
 
create table TRANSFER_LOSS_REQUEST (
    LOSS_REQUEST_ID
        INTEGER,
    SELLER
        INTEGER
        constraint TRANSFER_LOSS_REQU_NOT_NULL1
            not null
            deferrable,
    CUSTOMER
        INTEGER
        constraint TRANSFER_LOSS_REQU_NOT_NULL2
            not null
            deferrable,
    ASSIGN_REF
        VARCHAR (12),
    CUSTOMER_REQUEST_ID
        VARCHAR (25),
    DEAL_REF
        VARCHAR (12),
    CUSTOMER_COMMENT
        VARCHAR (50),
    TRANS_REQUEST_ID
        INTEGER,
    BEGTIME DT_DOM,
    ENDTIME DT_DOM,
    ENERGY_RATE
        INTEGER (2),
    FUEL_RATE
        INTEGER (2),
    constraint TRANSFER_LOSS_REQU_PRIMARY1
        primary key (LOSS_REQUEST_ID)
        deferrable);
 
create table SCHEDULE_EVENT (
    SCHEDULE_ID
        INTEGER,
    SEGMENT_ID
        INTEGER
        constraint SCHEDULE_EVENT_NOT_NULL1
            not null
            deferrable,
    TIME_OF_LAST_UPDATE DT_DOM,
    TRANS_REQUEST_ID
        INTEGER,
    ICHG_TYP_ID ICHG_TYP_ID_DOM,
    START_TIME DT_DOM,
    CAPACITY
        INTEGER,
    "COMMENT"
        CHAR (80),
    END_TIME DT_DOM,
    IN_ICHG_TYP_ID
        CHAR (6),
    OUT_ICHG_TYP_ID
        CHAR (6),
    constraint SCHEDULE_EVENT_PRIMARY1
        primary key (SCHEDULE_ID)
        deferrable);
 
create table TIMEZONE_REFERENCE (
    "NAME"
        VARCHAR (8)
        constraint TIMEZONE_REFERENCE_NOT_NULL1
            not null
            deferrable,
    GMT_OFFSET
        INTEGER
        constraint TIMEZONE_REFERENCE_NOT_NULL2
            not null
            deferrable,
    DESCRIPTION
        VARCHAR (80),
    TIME_OF_LAST_UPDATE DT_DOM,
    constraint XPKTIMEZONE_REFERENCE
        primary key ("NAME")
        deferrable);
 
create table CONTROL_AREA (
    CONTROL_AREA_ID
        INTEGER,
    CONTROL_AREA_NAME
        VARCHAR (20),
    "STATUS"
        TINYINT,
    TIME_OF_LAST_UPDATE DT_DOM,
    constraint CONTROL_AREA_PK
        primary key (CONTROL_AREA_ID)
        deferrable);
 
create table ANCILLARY_SERVICE (
    ANCILLARY_SERVICE_ID
        INTEGER,
    OASIS_ANCILLARY_SERVICE_ID
        INTEGER,
    PROVIDER
        INTEGER
        constraint ANCILLARY_SERVICE_NOT_NULL1
            not null
            deferrable,
    ANC_SERVICE_NAME
        VARCHAR (20),
    PRICE_UNITS
        VARCHAR (20),
    "STATUS"
        TINYINT,
    RESERVABLE
        TINYINT,
    ANC_SERVICE_DESCRIPTION
        VARCHAR (200),
    TIME_OF_LAST_UPDATE DT_DOM,
    ON_PEAK_SW
        INTEGER,
    constraint ANCILLARY_SERV_PK
        primary key (ANCILLARY_SERVICE_ID)
        deferrable);
 
create table ANCILLARY_OFFERING (
    ANCILLARY_OFFER_ID
        INTEGER,
    CONTROL_AREA_ID
        INTEGER,
    SELLER
        INTEGER,
    ANCILLARY_SERVICE_TYPE
        INTEGER
        constraint ANCILLARY_OFFERING_NOT_NULL1
            not null
            deferrable,
    PRICE
        REAL,
    BEGTIME DT_DOM,
    SERVICE_DESCRIPTION
        VARCHAR (200),
    SELLER_COMMENTS
        VARCHAR (80),
    SALE_REF
        VARCHAR (12),
    TIME_OF_LAST_UPDATE DT_DOM,
    ENDTIME DT_DOM,
    constraint XPK_ANC_OFFER
        primary key (ANCILLARY_OFFER_ID)
        deferrable);
 
create table ANCILLARY_REQUEST (
    REQUEST_ID
        INTEGER,
    OASIS_REQUEST_ID
        INTEGER,
    CONTROL_AREA_ID
        INTEGER
        constraint ANCILLARY_REQUEST_NOT_NULL1
            not null
            deferrable,
    SELLER_COMPANY
        INTEGER
        constraint ANCILLARY_REQUEST_NOT_NULL2
            not null
            deferrable,
    ANCILLARY_SERVICE_ID
        INTEGER
        constraint ANCILLARY_REQUEST_NOT_NULL3
            not null
            deferrable,
    CUSTOMER
        INTEGER
        constraint ANCILLARY_REQUEST_NOT_NULL4
            not null
            deferrable,
    BEGTIME DT_DOM,
    ENDTIME DT_DOM,
    REQUEST_STATUS
        TINYINT
        constraint ANCILLARY_REQUEST_NOT_NULL5
            not null
            deferrable,
    PRICE
        INTEGER (2),
    SERVICE_DESCRIPTION
        VARCHAR (200),
    SELLER
        INTEGER,
    DEAL_REF
        VARCHAR (12),
    REQUEST_REF
        VARCHAR (12),
    SALE_REF
        VARCHAR (12),
    CUSTOMER_COMMENTS
        VARCHAR (80),
    SELLER_COMMENTS
        VARCHAR (80),
    STATUS_COMMENTS
        VARCHAR (80),
    PROVIDER_COMMENTS
        VARCHAR (80),
    PRECONFIRMED
        TINYINT,
    REASSIGNED_REF
        INTEGER,
    REQUEST_QUEUE_TIME DT_DOM,
    TIME_OF_LAST_UPDATE DT_DOM,
    TRANS_REQUEST_ID
        INTEGER,
    QUANTITY
        INTEGER,
    constraint ANC_REQ_PK
        primary key (REQUEST_ID)
        deferrable);
 
create table ICHG_PRC_MISC_FCT (
    EFF_STR_DT DT_DOM,
    EFF_END_DT DT_DOM,
    MISC_FCT_TYP_ID ICHG_PRC_FCT_TYP_DOM,
    FCT_VAR_TYP_CD ICHG_PRC_FCT_TYP_DOM,
    QY FCT_QY_DOM,
    constraint ICHG_PRC_MISC_FCT_PK
        primary key (EFF_STR_DT, MISC_FCT_TYP_ID, FCT_VAR_TYP_CD)
        deferrable);
 
create table ATC_RESULT (
    REQUEST_TIME DT_DOM,
    STUDY_TYPE
        CHAR (1),
    STUDY_DATE DT_DOM,
    STUDY_HH
        CHAR (3),
    PATH_CODE
        CHAR (12),
    FIRM_PATH_ATC
        INTEGER,
    FIRM_NETWORK_ATC
        INTEGER,
    FIRM_POSTED_ATC
        INTEGER,
    NFIRM_PATH_ATC
        INTEGER,
    NFIRM_NETWORK_ATC
        INTEGER,
    NFIRM_POSTED_ATC
        INTEGER,
    TTC
        INTEGER,
    FIRM_MON_ELM
        CHAR (40),
    FIRM_CTG_ELM
        CHAR (40),
    NFIRM_MON_ELM
        CHAR (40),
    NFIRM_CTG_ELM
        CHAR (40),
    FIRM_CTG_ID
        CHAR (10),
    NFIRM_CTG_ID
        CHAR (10),
    ERROR_MESSAGE
        CHAR (80),
    EVAL_STATUS
        CHAR (1),
    CLONE_NAME
        CHAR (5),
    POST_SW
        INTEGER,
    ON_PEAK_SW
        INTEGER,
    OASIS_BEGTIME DT_DOM,
    constraint ATC_RESULT_PRIMARY1
        primary key (REQUEST_TIME, STUDY_DATE, STUDY_HH, PATH_CODE,
CLONE_NAME, 
        STUDY_TYPE, ON_PEAK_SW)
        deferrable);
 
create table NETWORK_SOURCE_SINK_VALID (
    NETWORK_SOURCE
        CHAR (8),
    NETWORK_SINK
        CHAR (8),
    PATH_ID
        INTEGER);
 
create table TRANSMISSION_CAPABILITY (
    CAPABILITY_ID
        INTEGER,
    CAPACITY_TYPE
        INTEGER,
    SELLER_COMPANY
        INTEGER,
    SELLER
        INTEGER,
    PATH_ID
        INTEGER,
    SALE_REF
        VARCHAR (12),
    CAPACITY
        INTEGER (2),
    PRICE
        INTEGER (2),
    SELLER_COMMENTS
        VARCHAR (80),
    PROVIDER_COMMENTS
        VARCHAR (80),
    BEGTIME DT_DOM,
    TIME_OF_LAST_UPDATE DT_DOM,
    POST_TO_OASIS_SW
        INTEGER,
    OASIS_CAPABILITY_ID
        INTEGER,
    POSTING_REF
        INTEGER,
    EVAL_REQUEST_NUMBER
        INTEGER);
 
create table TRANS_ICHG_RT_HH (
    TOP_1_OPA_ID OPA_ID_DOM,
    TOP_2_OPA_ID OPA_ID_DOM,
    ICHG_TYP_ID ICHG_TYP_ID_DOM,
    SCH_ICHG_DIR_TYP_ID SCH_ICHG_DIR_TYP_ID_DOM,
    EST_STR_DT DT_DOM,
    EVN_DT DT_DOM,
    EVN_HH HH_DOM,
    EST_MW_QY MW_QY_DOM,
    LEG
        INTEGER,
    SEQ_NO
        INTEGER,
    OPA OPA_ID_DOM,
    DESCR
        CHAR (20),
    TRANSFER_COST IPT_PRC_QY_DOM,
    TRANSFER_MWH
        INTEGER,
    FIXED_COST IPT_PRC_QY_DOM,
    LOSS_PERCENT
        INTEGER (3),
    constraint TRANS_ICHG_RT_HH_PK
        primary key (TOP_1_OPA_ID, TOP_2_OPA_ID, ICHG_TYP_ID, 
        SCH_ICHG_DIR_TYP_ID, EST_STR_DT, EVN_DT, EVN_HH, LEG, SEQ_NO)
        deferrable);
 
create table NOTIFY_MESSAGE_LOG (
    ID
        INTEGER,
    EVN_DT DT_DOM,
    FROM_PC_NAME
        CHAR (32),
    TO_PC_NAME
        CHAR (32),
    MESSAGE
        CHAR (192),
    MESSAGE_READ_SW
        INTEGER);
 
alter table OPA
    add constraint 
    constraint OPA_FK
        foreign key (CO_ID)
            references CO (CO_ID)
        deferrable;
alter table TCP
    add constraint 
    constraint TCP_FK_001
        foreign key (TCP_1_CO_ID)
            references CO (CO_ID)
        deferrable;
alter table TCP_ICHG
    add constraint 
    constraint TCP_ICHG_FK_001
        foreign key (TCP_1_CO_ID)
            references CO (CO_ID)
        deferrable
    add constraint 
    constraint TCP_ICHG_FK_002
        foreign key (TCP_2_CO_ID)
            references CO (CO_ID)
        deferrable;
alter table TOP
    add constraint 
    constraint TOP_FK_001
        foreign key (TOP_1_OPA_ID)
            references OPA (OPA_ID)
        deferrable
    add constraint 
    constraint TOP_FK_002
        foreign key (TOP_2_OPA_ID)
            references OPA (OPA_ID)
        deferrable;
alter table TOP_ICHG
    add constraint 
    constraint TOP_ICHG_FK_002
        foreign key (TOP_1_OPA_ID)
            references OPA (OPA_ID)
        deferrable
    add constraint 
    constraint TOP_ICHG_FK_003
        foreign key (TOP_2_OPA_ID)
            references OPA (OPA_ID)
        deferrable;
alter table COMPANY
    add constraint 
    constraint IS_IN_HAS6
        foreign key ("STATUS")
            references STATUS_OF_RECORD (STATUS_ID)
        deferrable;
alter table SERVICE_POINT
    add constraint 
    constraint IS_IN_HAS2
        foreign key (SERVICE_POINT_TYPE)
            references SP_TYPE (SERVICE_POINT_TYPE)
        deferrable
    add constraint 
    constraint IS_IN_HAS3
        foreign key (SOURCE_SINK_TYPE)
            references SRC_SNK_TYPE (SOURCE_SINK_TYPE)
        deferrable
    add constraint 
    constraint IS_IN_HAS4
        foreign key ("STATUS")
            references STATUS_OF_RECORD (STATUS_ID)
        deferrable
    add constraint 
    constraint POSSESSES___IS_POSSESSED
        foreign key (PROVIDER)
            references COMPANY (COMPANY_ID)
        deferrable;
alter table PATH
    alter INTERFACE_TYPE 
    constraint INTERFACE_TYPE
        check(((PATH.INTERFACE_TYPE = 'I')
            or ((PATH.INTERFACE_TYPE = 'E')
            or (PATH.INTERFACE_TYPE = 'O'))))
        deferrable;
alter table PATH
    add constraint 
    constraint HAS_POD
        foreign key (POINT_OF_DELIVERY)
            references SERVICE_POINT (SERVICE_POINT_ID)
        deferrable
    add constraint 
    constraint HAS_POR
        foreign key (POINT_OF_RECEIPT)
            references SERVICE_POINT (SERVICE_POINT_ID)
        deferrable
    add constraint 
    constraint IS_IN_HAS1
        foreign key ("STATUS")
            references STATUS_OF_PATH (PATH_STATUS_ID)
        deferrable
    add constraint 
    constraint OPERATES
        foreign key (PROVIDER)
            references COMPANY (COMPANY_ID)
        deferrable;
alter table TSIN_USER
    add constraint 
    constraint EMPLOYS___IS_EMPLOYED_BY
        foreign key (COMPANY_ID)
            references COMPANY (COMPANY_ID)
        deferrable
    add constraint 
    constraint R_76
        foreign key ("STATUS")
            references STATUS_OF_RECORD (STATUS_ID)
        deferrable;
alter table SERVICE
    add constraint 
    constraint DURATION
        foreign key (OFFERING_TYPE)
            references OFFER_TYPE (OFFERING_TYPE_ID)
        deferrable
    add constraint 
    constraint IS_IN_HAS5
        foreign key ("STATUS")
            references STATUS_OF_RECORD (STATUS_ID)
        deferrable
    add constraint 
    constraint PROVIDES___IS_PROVIDED_BY
        foreign key (PROVIDER)
            references COMPANY (COMPANY_ID)
        deferrable
    add constraint 
    constraint R_78
        foreign key (SUMMARY)
            references SUMMARY_TYPE (SUMMARY_ID)
        deferrable;
alter table TRANSMISSION_REQUEST
    add constraint 
    constraint AT_POD_PROVIDES_IS_PROVIDED_BY
        foreign key (POINT_OF_DELIVERY)
            references SERVICE_POINT (SERVICE_POINT_ID)
        deferrable
    add constraint 
    constraint AT_POR_PROVIDES_IS_PROVIDED_BY
        foreign key (POINT_OF_RECEIPT)
            references SERVICE_POINT (SERVICE_POINT_ID)
        deferrable
    add constraint 
    constraint HAS_HAS
        foreign key (PATH_ID)
            references PATH (PATH_ID)
        deferrable
    add constraint 
    constraint REQUESTS2
        foreign key (CAPACITY_TYPE)
            references SERVICE (SERVICE_ID)
        deferrable
    add constraint 
    constraint SUBMITS___IS_SUBMITTED_BY
        foreign key (SELLER)
            references TSIN_USER (USER_ID)
        deferrable;
alter table RE_ASSIGNMENT
    add constraint 
    constraint NEW_IS_REASSIGNED
        foreign key (NEW_REQUEST)
            references TRANSMISSION_REQUEST (REQUEST_ID)
        deferrable
    add constraint 
    constraint "OLD_IS_RE_ASSIGNED_"
        foreign key (OLD_REQUEST)
            references TRANSMISSION_REQUEST (REQUEST_ID)
        deferrable;
alter table AUDIT_LOG
    add constraint 
    constraint FK_USER_LOG
        foreign key (USER_ID)
            references TSIN_USER (USER_ID)
        deferrable;
alter table CHANGE_DETAILS
    add constraint 
    constraint HAS_IS_PART_OF
        foreign key (AUDIT_ID)
            references AUDIT_LOG (AUDIT_ID)
        deferrable;
alter table REQUEST_SEGMENT
    add constraint 
    constraint CONSISTS_OF
        foreign key (REQUEST_ID)
            references TRANSMISSION_REQUEST (REQUEST_ID)
        deferrable;
alter table CURTAILMENT
    add constraint 
    constraint CURTAILED
        foreign key (SEGMENT_ID)
            references REQUEST_SEGMENT (SEGMENT_ID)
        deferrable;
alter table "SCHEDULE"
    add constraint 
    constraint SCHEDULED
        foreign key (SEGMENT_ID)
            references REQUEST_SEGMENT (SEGMENT_ID)
        deferrable;
alter table TRANSFER_LOSS_REQUEST
    add constraint 
    constraint FK_CUSTOMER_ANCILLARY_REQUEST
        foreign key (CUSTOMER)
            references COMPANY (COMPANY_ID)
        deferrable
    add constraint 
    constraint FK_TRANS_ANCILLARY_REQUEST
        foreign key (TRANS_REQUEST_ID)
            references TRANSMISSION_REQUEST (REQUEST_ID)
        deferrable
    add constraint 
    constraint FK_USER_ANCILLARY_REQUEST
        foreign key (SELLER)
            references TSIN_USER (USER_ID)
        deferrable;
alter table SCHEDULE_EVENT
    add constraint 
    constraint SCHEDULE_EVENT
        foreign key (SEGMENT_ID)
            references REQUEST_SEGMENT (SEGMENT_ID)
        deferrable
    add constraint 
    constraint TRANSMISSION_REQUEST_SCHEDULED
        foreign key (TRANS_REQUEST_ID)
            references TRANSMISSION_REQUEST (REQUEST_ID)
        deferrable;
commit work;

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                              Index Definitions
--
------------------------------------------------------------------------
--------
create unique index ANCILLARY_REQUEST_IDX
    on ANCILLARY_REQUEST (
    REQUEST_ID
        asc)
    type is SORTED
    store in OASIS_STORAGE_AREA;
commit work;
 
create unique index ANCILLARY_SERVICE_IDX
    on ANCILLARY_SERVICE (
    ANCILLARY_SERVICE_ID
        asc)
    type is SORTED;
commit work;
 
create unique index ANC_OFFER_IDX
    on ANCILLARY_OFFERING (
    ANCILLARY_OFFER_ID
        asc)
    type is SORTED;
commit work;
 
create unique index CAL_DT_IDX
    on CAL_DT (
    CAL_DT
        asc,
    NXT_DT
        asc,
    PK_DAY_TYP_ID
        asc,
    DST_CHG_CD
        asc,
    CO_HOL_SW
        asc)
    type is SORTED
    node size 444
    usage QUERY
    disable compression
    store in DEFAULT_AREA;
commit work;
 
create unique index CONTROL_AREA_ID
    on CONTROL_AREA (
    CONTROL_AREA_NAME
        asc)
    type is SORTED;
commit work;
 
create unique index CO_SORT_IDX
    on CO (
    NM
        asc)
    type is SORTED
    node size 506
    usage QUERY
    disable compression
    store in DEFAULT_AREA;
commit work;
 
create index EVAL_REQUIRED_TIME_IDX
    on EVAL_REQUIRED_TIME (
    CLONE_NAME
        asc,
    REQUIRED_TIME
        asc,
    EFF_START_DT
        asc)
    type is SORTED;
commit work;
 
create unique index IDX_HASHED_13
    on OPA (
    OPA_ID)
    type is HASHED
    store in EAS_SCH_MULTI_MA_00003;
commit work;
 
create unique index IDX_HASHED_144
    on CO (
    CO_ID)
    type is HASHED
    store in EAS_SCH_MULTI_MA_00007;
commit work;
 
create unique index IDX_HASHED_97
    on TOP_ICHG (
    ICHG_TYP_ID,
    TOP_2_OPA_ID,
    TOP_1_OPA_ID)
    type is HASHED
    store in EAS_SCH_MULTI_MA_00012;
commit work;
 
create unique index NETWORK_SOURCE_SINK_PK
    on NETWORK_SOURCE_SINK_VALID (
    NETWORK_SOURCE
        asc,
    NETWORK_SINK
        asc,
    PATH_ID
        asc)
    type is SORTED
    store in DEFAULT_AREA;
commit work;
 
create index NOTIFY_MESSAGE_LOG_IDX
    on NOTIFY_MESSAGE_LOG (
    ID
        asc,
    EVN_DT
        asc)
    type is SORTED
    store in SCH_ICHG_EVN_UA;
commit work;
 
create unique index NOTIFY_MSG_PK_IDX
    on NOTIFY_MESSAGE_LOG (
    ID
        asc)
    type is SORTED
    store in SCH_ICHG_EVN_UA;
commit work;
 
create index OASIS_POST_IDX
    on TRANSMISSION_CAPABILITY (
    PATH_ID
        asc,
    OASIS_CAPABILITY_ID
        asc,
    POST_TO_OASIS_SW
        asc)
    type is SORTED
    usage QUERY
    disable compression
    store in IPT_DEFAULT_AREA;
commit work;
 
create index OPA_CO_HASH_IDX
    on OPA (
    CO_ID)
    type is HASHED
    store in EAS_SCH_MULTI_MA_00023;
commit work;
 
create unique index OPA_NM_IDX
    on OPA (
    OPA_ID
        asc,
    NM
        asc)
    type is SORTED
    node size 774
    usage QUERY
    disable compression
    store in DEFAULT_AREA;
commit work;
 
create unique index PK_SOURCE_SINK
    on SOURCE_SINK (
    SOURCE_SINK
        asc)
    type is SORTED
    store in OASIS_STORAGE_AREA;
commit work;
 
create unique index PK_TRANS_DURATION_TYPE
    on TRANS_DURATION_TYPE (
    CAPACITY_DURATION
        asc)
    type is SORTED
    store in OASIS_STORAGE_AREA;
commit work;
 
create index REQUEST_SEGMENT_IDX
    on REQUEST_SEGMENT (
    REQUEST_ID
        asc)
    type is SORTED;
commit work;
 
create index SCHEDULE_EVENT_END_TIME
    on SCHEDULE_EVENT (
    END_TIME
        asc)
    type is SORTED;
commit work;
 
create index SCHEDULE_EVENT_START_TIME
    on SCHEDULE_EVENT (
    START_TIME
        asc)
    type is SORTED;
commit work;
 
create unique index TCP_ICHG_PRIMARY_INDEX
    on TCP_ICHG (
    ICHG_TYP_ID
        asc,
    TCP_1_CO_ID
        asc,
    TCP_2_CO_ID
        asc)
    type is SORTED
    store in SCH_ICHG_EVN_UA;
commit work;
 
create unique index TRANS_ICHG_RT_HH_PRIMARY_IDX
    on TRANS_ICHG_RT_HH (
    TOP_1_OPA_ID
        asc,
    TOP_2_OPA_ID
        asc,
    ICHG_TYP_ID
        asc,
    SCH_ICHG_DIR_TYP_ID
        asc,
    EST_STR_DT
        asc,
    EVN_DT
        asc,
    EVN_HH
        asc,
    LEG
        asc,
    SEQ_NO
        asc)
    type is SORTED
    usage UPDATE
    disable compression
    store in IPT_DEFAULT_AREA;
commit work;
 
create index TRANS_REQUEST_IDX
    on SCHEDULE_EVENT (
    TRANS_REQUEST_ID
        asc)
    type is SORTED
    store in EAS_SCH_MULTI_MA_00002;
commit work;
 
create unique index XAK1COMPANY
    on COMPANY (
    COMPANY_NAME
        asc)
    type is SORTED;
commit work;
 
create unique index XAK1SERVICE
    on SERVICE (
    SERVICE_NAME
        asc,
    PROVIDER
        asc,
    OFFERING_TYPE
        asc)
    type is SORTED;
commit work;
 
create unique index XAK1SERVICE_POINT
    on SERVICE_POINT (
    SERVICE_POINT_NAME
        asc,
    PROVIDER
        asc)
    type is SORTED;
commit work;
 
create unique index XAK1TRANSMISSION_PATH
    on PATH (
    PATH_NAME
        asc)
    type is SORTED;
commit work;
 
create unique index XAK1USER
    on TSIN_USER (
    "NAME"
        asc,
    COMPANY_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XAK2TRANSMISSION_PATH
    on PATH (
    PROVIDER
        asc,
    PATH_CODE
        asc)
    type is SORTED;
commit work;
 
create unique index XATC_RESULT
    on ATC_RESULT (
    REQUEST_TIME
        asc,
    STUDY_DATE
        asc,
    STUDY_HH
        asc,
    PATH_CODE
        asc,
    CLONE_NAME
        asc,
    STUDY_TYPE
        asc,
    ON_PEAK_SW
        asc)
    type is SORTED
    store in OASIS_STORAGE_AREA;
commit work;
 
create unique index XEVAL_REQUEST
    on EVAL_REQUEST (
    REQUEST_TIME
        asc,
    CLONE_NAME
        asc,
    STUDY_TYPE
        asc)
    type is SORTED;
commit work;
 
create unique index XPKAUDIT_LOG
    on AUDIT_LOG (
    AUDIT_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKCHANGE_DETAILS
    on CHANGE_DETAILS (
    CHANGE_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKCOMPANY
    on COMPANY (
    COMPANY_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKCURTAILMENT
    on CURTAILMENT (
    CURTAILMENT_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKNETWORK_FACTOR
    on NETWORK_FACTOR (
    EVN_DT
        asc,
    NETWORK_SOURCE
        asc,
    NETWORK_SINK
        asc,
    PATH_CODE
        asc)
    type is SORTED
    store in OASIS_STORAGE_AREA;
commit work;
 
create unique index XPKOFFER_TYPE
    on OFFER_TYPE (
    OFFERING_TYPE_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKREQUEST_SEGMENT
    on REQUEST_SEGMENT (
    SEGMENT_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKRE_ASSIGNMENT
    on RE_ASSIGNMENT (
    RA_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKSCHEDULE
    on "SCHEDULE" (
    SCHEDULE_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKSCHEDULE_EVENT
    on SCHEDULE_EVENT (
    SCHEDULE_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKSERVICE
    on SERVICE (
    SERVICE_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKSERVICE_POINT
    on SERVICE_POINT (
    SERVICE_POINT_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKSP_TYPE
    on SP_TYPE (
    SERVICE_POINT_TYPE
        asc)
    type is SORTED;
commit work;
 
create unique index XPKSRC_SNK_TYPE
    on SRC_SNK_TYPE (
    SOURCE_SINK_TYPE
        asc)
    type is SORTED;
commit work;
 
create unique index XPKSTATUS
    on "STATUS" (
    STATUS_ID
        asc)
    type is SORTED
    store in OASIS_STORAGE_AREA;
commit work;
 
create unique index XPKSTATUS_OF_PATH
    on STATUS_OF_PATH (
    PATH_STATUS_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKSTATUS_OF_RECORD
    on STATUS_OF_RECORD (
    STATUS_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKSUMMARY_TYPE
    on SUMMARY_TYPE (
    SUMMARY_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKTRANSMISSIONTYPES
    on TRANSMISSION_CAPABILITY (
    PATH_ID
        asc,
    CAPACITY_TYPE
        asc,
    BEGTIME
        asc)
    type is SORTED
    store in EAS_AUDIT_AREA;
commit work;
 
create unique index XPKTRANSMISSION_CAPABILITY
    on TRANSMISSION_CAPABILITY (
    CAPABILITY_ID
        asc)
    type is SORTED
    store in DEFAULT_AREA;
commit work;
 
create unique index XPKTRANSMISSION_PATH
    on PATH (
    PATH_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKTRANSMISSION_REQUEST
    on TRANSMISSION_REQUEST (
    REQUEST_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKTRANS_REQUEST_STATUS
    on TRANS_REQUEST_STATUS (
    REQUEST_STATUS_ID
        asc)
    type is SORTED;
commit work;
 
create unique index XPKUSER
    on TSIN_USER (
    USER_ID
        asc)
    type is SORTED;
commit work;
 

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                           Storage Map Definitions
--
------------------------------------------------------------------------
--------
create storage map ANCILLARY_REQUEST_MAP
    for ANCILLARY_REQUEST
    store in OASIS_STORAGE_AREA;
 
create storage map ANC_OFFER_MAP
    for ANCILLARY_OFFERING
    store in OASIS_STORAGE_AREA;
 
create storage map ANC_SERV_MAP
    for ANCILLARY_SERVICE
    store in OASIS_STORAGE_AREA;
 
create storage map ATC_REQUEST_MAP
    for ATC_REQUEST
    store in OASIS_STORAGE_AREA;
 
create storage map ATC_RESULT_MAP
    for ATC_RESULT
    store in OASIS_STORAGE_AREA;
 
create storage map AUDIT_LOG_MAP
    for AUDIT_LOG
    store in OASIS_STORAGE_AREA;
 
create storage map CHANGE_DETAILS_MAP
    for CHANGE_DETAILS
    store in OASIS_STORAGE_AREA;
 
create storage map COMPANY_MAP
    for COMPANY
    store in OASIS_STORAGE_AREA;
 
create storage map CONTROL_AREA_MAP
    for CONTROL_AREA
    store in OASIS_STORAGE_AREA;
 
create storage map CURTAILMENT_MAP
    for CURTAILMENT
    store in OASIS_STORAGE_AREA;
 
create storage map MAP_17
    for CO
    store in EAS_SCH_MULTI_MA_00007
    placement via index IDX_HASHED_144
    disable compression;
 
create storage map MAP_27
    for TOP_ICHG
    store in EAS_SCH_MULTI_MA_00012
    placement via index IDX_HASHED_97
    disable compression;
 
create storage map MAP_40
    for CAL_DT
    store in DEFAULT_AREA
    disable compression;
 
create storage map MAP_43
    for CUS
    store in DEFAULT_AREA
    disable compression;
 
create storage map MAP_46
    for DAY_TYP
    store in DEFAULT_AREA
    disable compression;
 
create storage map MAP_6
    for MISC_MEAS_TYP
    store in EAS_SCH_MULTI_MA_00002
    disable compression;
 
create storage map MAP_64
    for TCP
    store in DEFAULT_AREA
    disable compression;
 
create storage map MAP_65
    for TCP_ICHG
    store in DEFAULT_AREA
    disable compression;
 
create storage map MAP_69
    for TOP
    store in DEFAULT_AREA
    disable compression;
 
create storage map MAP_9
    for OPA
    store in EAS_SCH_MULTI_MA_00003
    placement via index IDX_HASHED_13
    disable compression;
 
create storage map NETWORK_FACTOR_MAP
    for NETWORK_FACTOR
    store in OASIS_STORAGE_AREA;
 
create storage map NETWORK_SOURCE_SINK_MAP
    for NETWORK_SOURCE_SINK
    store in OASIS_STORAGE_AREA;
 
create storage map NOTIFY_MESSAGE_LOG_MAP
    for NOTIFY_MESSAGE_LOG
    store in SCH_ICHG_EVN_UA;
 
create storage map OFFER_TYPE_MAP
    for OFFER_TYPE
    store in OASIS_STORAGE_AREA;
 
create storage map PATH_MAP
    for PATH
    store in OASIS_STORAGE_AREA;
 
create storage map REQUEST_SEGMENT_MAP
    for REQUEST_SEGMENT
    store in OASIS_STORAGE_AREA;
 
create storage map RE_ASSIGNMENT_MAP
    for RE_ASSIGNMENT
    store in OASIS_STORAGE_AREA;
 
create storage map SCHEDULE_MAP
    for "SCHEDULE"
    store in OASIS_STORAGE_AREA;
 
create storage map SERVICE_MAP
    for SERVICE
    store in OASIS_STORAGE_AREA;
 
create storage map SERVICE_POINT_MAP
    for SERVICE_POINT
    store in OASIS_STORAGE_AREA;
 
create storage map SP_TYPE_MAP
    for SP_TYPE
    store in OASIS_STORAGE_AREA;
 
create storage map SRC_SNK_TYPE_MAP
    for SRC_SNK_TYPE
    store in OASIS_STORAGE_AREA;
 
create storage map STATUS_MAP
    for "STATUS"
    store in OASIS_STORAGE_AREA;
 
create storage map STATUS_OF_PATH_MAP
    for STATUS_OF_PATH
    store in OASIS_STORAGE_AREA;
 
create storage map STATUS_OF_RECORD_MAP
    for STATUS_OF_RECORD
    store in OASIS_STORAGE_AREA;
 
create storage map SUMMARY_TYPE_MAP
    for SUMMARY_TYPE
    store in OASIS_STORAGE_AREA;
 
create storage map TIME_REF_MAP
    for TIMEZONE_REFERENCE
    store in OASIS_STORAGE_AREA;
 
create storage map TRANSFER_LOSS_REQU_MAP
    for TRANSFER_LOSS_REQUEST
    store in OASIS_STORAGE_AREA;
 
create storage map TRANSMISSION_CAP_MAP
    for TRANSMISSION_CAPABILITY
    store in TRANSMISS_CAP_AREA;
 
create storage map TRANSMISSION_REQUEST_MAP
    for TRANSMISSION_REQUEST
    store in OASIS_STORAGE_AREA;
 
create storage map TRANS_DUR_TYPE_MAP
    for TRANS_DURATION_TYPE
    store in OASIS_STORAGE_AREA;
 
create storage map TRANS_REQUEST_STATUS_MAP
    for TRANS_REQUEST_STATUS
    store in OASIS_STORAGE_AREA;
 
create storage map TSIN_USER_MAP
    for TSIN_USER
    store in OASIS_STORAGE_AREA;
 
commit work;

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                               View Definitions
--
------------------------------------------------------------------------
--------
create view TRANSMISSION_CAPABILITY_UNLOAD
    (CAPABILITY_ID,
     CAPACITY_TYPE,
     SELLER_COMPANY,
     SELLER,
     PATH_ID,
     SALE_REF,
     CAPACITY,
     PRICE,
     SELLER_COMMENTS,
     PROVIDER_COMMENTS,
     BEGTIME,
     TIME_OF_LAST_UPDATE,
     POST_TO_OASIS_SW,
     OASIS_CAPABILITY_ID,
     POSTING_REF,
     EVAL_REQUEST_NUMBER) as
    select
        C1.CAPABILITY_ID,
        C1.CAPACITY_TYPE,
        C1.SELLER_COMPANY,
        C1.SELLER,
        C1.PATH_ID,
        C1.SALE_REF,
        C1.CAPACITY,
        C1.PRICE,
        C1.SELLER_COMMENTS,
        C1.PROVIDER_COMMENTS,
        C1.BEGTIME,
        C1.TIME_OF_LAST_UPDATE,
        C1.POST_TO_OASIS_SW,
        C1.OASIS_CAPABILITY_ID,
        C1.POSTING_REF,
        C1.EVAL_REQUEST_NUMBER
    from TRANSMISSION_CAPABILITY C1
    where ((C1.BEGTIME < DATE VMS ' 1-FEB-1997 00:00:00.00')
        and (((((C1.CAPACITY_TYPE = 3)
        or (C1.CAPACITY_TYPE = 5))
        or (C1.CAPACITY_TYPE = 9))
        or (C1.CAPACITY_TYPE = 11))
        or (C1.CAPACITY_TYPE = 54)));
    
create view ATC_UNLOAD_VW
    (REQUEST_TIME,
     STUDY_TYPE,
     STUDY_DATE,
     STUDY_HH,
     PATH_CODE,
     FIRM_PATH_ATC,
     FIRM_NETWORK_ATC,
     FIRM_POSTED_ATC,
     NFIRM_PATH_ATC,
     NFIRM_NETWORK_ATC,
     NFIRM_POSTED_ATC,
     TTC,
     FIRM_MON_ELM,
     FIRM_CTG_ELM,
     NFIRM_MON_ELM,
     NFIRM_CTG_ELM,
     FIRM_CTG_ID,
     NFIRM_CTG_ID,
     ERROR_MESSAGE,
     EVAL_STATUS,
     CLONE_NAME,
     POST_SW,
     ON_PEAK_SW,
     OASIS_BEGTIME) as
    select
        C1.REQUEST_TIME,
        C1.STUDY_TYPE,
        C1.STUDY_DATE,
        C1.STUDY_HH,
        C1.PATH_CODE,
        C1.FIRM_PATH_ATC,
        C1.FIRM_NETWORK_ATC,
        C1.FIRM_POSTED_ATC,
        C1.NFIRM_PATH_ATC,
        C1.NFIRM_NETWORK_ATC,
        C1.NFIRM_POSTED_ATC,
        C1.TTC,
        C1.FIRM_MON_ELM,
        C1.FIRM_CTG_ELM,
        C1.NFIRM_MON_ELM,
        C1.NFIRM_CTG_ELM,
        C1.FIRM_CTG_ID,
        C1.NFIRM_CTG_ID,
        C1.ERROR_MESSAGE,
        C1.EVAL_STATUS,
        C1.CLONE_NAME,
        C1.POST_SW,
        C1.ON_PEAK_SW,
        C1.OASIS_BEGTIME
    from ATC_RESULT C1
    where (C1.REQUEST_TIME < DATE VMS ' 1-FEB-1997 00:00:00.00');
    
create view REQUEST_SEGMENT_01_VW
    (SEGMENT_ID,
     REQUEST_ID,
     CAPACITY,
     PRICE,
     SEGBEG,
     SEGEND,
     TIME_OF_LAST_UPDATE,
     CBM_TYPE_SW,
     OASIS_REQUEST_ID,
     OASIS_SEGMENT_ID,
     POST_TO_OASIS_SW,
     REQUEST_STATUS,
     BEGTIME,
     ENDTIME,
     SERVICEID,
     SERVICENAME,
     PRICE_UNITS,
     CUSUSERID,
     CUSNAME,
     CUSCOID,
     CUSCONAME,
     PATH_CODE) as
    select
        C1.SEGMENT_ID,
        C1.REQUEST_ID,
        C1.CAPACITY,
        C1.PRICE,
        C1.BEGTIME,
        C1.ENDTIME,
        C1.TIME_OF_LAST_UPDATE,
        C1.CBM_TYPE_SW,
        C1.OASIS_REQUEST_ID,
        C1.OASIS_SEGMENT_ID,
        C1.POST_TO_OASIS_SW,
        C2.REQUEST_STATUS,
        C2.BEGTIME,
        C2.ENDTIME,
        C2.CAPACITY_TYPE,
        C4.SERVICE_NAME,
        C4.PRICE_UNITS,
        C2.CUSTOMER,
        C3.NAME,
        C3.COMPANY_ID,
        C5.FULL_COMPANY_NAME,
        C6.PATH_CODE
    from REQUEST_SEGMENT as C1
    left outer join 
    TRANSMISSION_REQUEST as C2 on (C1.REQUEST_ID = C2.REQUEST_ID)
    left outer join 
    TSIN_USER as C3 on (C2.CUSTOMER = C3.USER_ID)
    left outer join 
    SERVICE as C4 on (C2.CAPACITY_TYPE = C4.SERVICE_ID)
    left outer join 
    COMPANY as C5 on (C3.COMPANY_ID = C5.COMPANY_ID)
    left outer join 
    PATH as C6 on (C2.PATH_ID = C6.PATH_ID);
    
create view SCHEDULE_EVENT_01_VW
    (SCHEDULE_ID,
     SEGMENT_ID,
     TRANS_REQUEST_ID,
     ICHG_TYP_ID,
     IN_ICHG_TYP_ID,
     OUT_ICHG_TYP_ID,
     START_TIME,
     END_TIME,
     CAPACITY,
     OASIS_REQUEST_ID,
     REQUEST_STATUS,
     PATH_CODE,
     TOP_2_OPA_ID,
     SCH_ICHG_DIR_TYP_ID) as
    select
        C1.SCHEDULE_ID,
        C1.SEGMENT_ID,
        C1.TRANS_REQUEST_ID,
        C1.ICHG_TYP_ID,
        C1.IN_ICHG_TYP_ID,
        C1.OUT_ICHG_TYP_ID,
        C1.START_TIME,
        C1.END_TIME,
        C1.CAPACITY,
        C2.OASIS_REQUEST_ID,
        C2.REQUEST_STATUS,
        C3.PATH_CODE,
        C3.TOP_2_OPA_ID,
        C3.SCH_ICHG_DIR_TYP_ID
    from SCHEDULE_EVENT as C1
    left outer join 
    TRANSMISSION_REQUEST as C2 on (C1.TRANS_REQUEST_ID = C2.REQUEST_ID)
    left outer join 
    PATH as C3 on (C2.PATH_ID = C3.PATH_ID);
    
create view SCHEDULE_EVENT_02_VW
    (REQUEST_ID,
     SEGMENT_ID,
     SCHEDULE_ID,
     EVN_DT,
     NXT_DT,
     START_TIME,
     END_TIME,
     CAPACITY,
     REQUEST_STATUS,
     PATH_CODE,
     TOP_2_OPA_ID,
     ICHG_TYP_ID,
     SCH_ICHG_DIR_TYP_ID) as
    select
        C1.TRANS_REQUEST_ID,
        C1.SEGMENT_ID,
        C1.SCHEDULE_ID,
        C2.CAL_DT,
        C2.NXT_DT,
        C1.START_TIME,
        C1.END_TIME,
        C1.CAPACITY,
        C1.REQUEST_STATUS,
        C1.PATH_CODE,
        C1.TOP_2_OPA_ID,
        C1.ICHG_TYP_ID,
        C1.SCH_ICHG_DIR_TYP_ID
    from SCHEDULE_EVENT_01_VW C1, CAL_DT C2
    where ((C2.NXT_DT > C1.START_TIME)
        and (C2.CAL_DT < C1.END_TIME));
    
create view DROP_ATC_RESULTS
    (REQUEST_TIME,
     STUDY_TYPE,
     STUDY_DATE,
     STUDY_HH,
     PATH_CODE,
     FIRM_PATH_ATC,
     FIRM_NETWORK_ATC,
     FIRM_POSTED_ATC,
     NFIRM_PATH_ATC,
     NFIRM_NETWORK_ATC,
     NFIRM_POSTED_ATC,
     TTC,
     FIRM_MON_ELM,
     FIRM_CTG_ELM,
     NFIRM_MON_ELM,
     NFIRM_CTG_ELM,
     FIRM_CTG_ID,
     NFIRM_CTG_ID,
     ERROR_MESSAGE,
     EVAL_STATUS,
     CLONE_NAME,
     POST_SW,
     ON_PEAK_SW,
     OASIS_BEGTIME) as
    select
        C1.REQUEST_TIME,
        C1.STUDY_TYPE,
        C1.STUDY_DATE,
        C1.STUDY_HH,
        C1.PATH_CODE,
        C1.FIRM_PATH_ATC,
        C1.FIRM_NETWORK_ATC,
        C1.FIRM_POSTED_ATC,
        C1.NFIRM_PATH_ATC,
        C1.NFIRM_NETWORK_ATC,
        C1.NFIRM_POSTED_ATC,
        C1.TTC,
        C1.FIRM_MON_ELM,
        C1.FIRM_CTG_ELM,
        C1.NFIRM_MON_ELM,
        C1.NFIRM_CTG_ELM,
        C1.FIRM_CTG_ID,
        C1.NFIRM_CTG_ID,
        C1.ERROR_MESSAGE,
        C1.EVAL_STATUS,
        C1.CLONE_NAME,
        C1.POST_SW,
        C1.ON_PEAK_SW,
        C1.OASIS_BEGTIME
    from ATC_RESULT C1
    where (C1.REQUEST_TIME <= DATE VMS '20-JAN-1997 00:00:00.00');
    
create view CONFIRMED_SCHEDULE_EVENTS_VW
    (SEGMENT_ID,
     CAPACITY,
     START_TIME,
     END_TIME,
     REQUEST_STATUS,
     TIME_OF_LAST_UPDATE) as
    select
        C1.SEGMENT_ID,
        C1.CAPACITY,
        C1.START_TIME,
        C1.END_TIME,
        C2.REQUEST_STATUS,
        C1.TIME_OF_LAST_UPDATE
    from SCHEDULE_EVENT as C1
    inner join 
    TRANSMISSION_REQUEST as C2 on (C1.TRANS_REQUEST_ID = C2.REQUEST_ID)
    where ((C2.REQUEST_STATUS = 5)
        and ((C2.NATIVE_LOAD_SW <> -1)
        or (C2.NATIVE_LOAD_SW is null)));
    
create view SELEVALREQ_VW_3
    (REQUEST_TIME,
     REQUEST_ID,
     "START",
     "STOP",
     SELLERCO,
     DESCRIPTION,
     POR,
     SELLER,
     "SOURCE",
     SINK,
     PATH_ID,
     POINT_OF_DELIVERY,
     POINT_OF_RECEIPT,
     SELLER_CO,
     CUSTOMER,
     POD,
     OASIS_REQUEST_ID,
     UPDATE_FROM_OASIS,
     POST_TO_OASIS_STATUS,
     OASIS_STATUS,
     REQUEST_STATUS,
     CAPACITY_TYPE,
     NATIVE_LOAD_SW,
     PATH_CODE,
     PODP,
     PORP,
     SRCTYPE,
     SINKTYPE,
     OFFER,
     NETSOURCE,
     NETSINK,
     NETWORK_PATH) as
    select
        C1.REQUEST_QUEUE_TIME,
        C1.REQUEST_ID,
        C1.BEGTIME,
        C1.ENDTIME,
        C1.SELLER_COMPANY,
        C2.DESCRIPTION,
        C3.SERVICE_POINT_NAME,
        C4.NAME,
        C1.SOURCE,
        C1.SINK,
        C1.PATH_ID,
        C1.POINT_OF_DELIVERY,
        C1.POINT_OF_RECEIPT,
        C7.COMPANY_NAME,
        C6.COMPANY_NAME,
        C8.SERVICE_POINT_NAME,
        C1.OASIS_REQUEST_ID,
        C1.UPDATE_FROM_OASIS,
        C1.POST_TO_OASIS_STATUS,
        C1.POST_TO_OASIS_SW,
        C1.REQUEST_STATUS,
        C1.CAPACITY_TYPE,
        C1.NATIVE_LOAD_SW,
        C9.PATH_CODE,
        C9.POINT_OF_DELIVERY,
        C9.POINT_OF_RECEIPT,
        C11.DESCRIPTION,
        C12.DESCRIPTION,
        C14.OFFERING_TYPE,
        C10.NETWORK_SERVICE_POINT_NAME,
        C13.NETWORK_SERVICE_POINT_NAME,
        C9.NETWORK_PATH
    from TRANSMISSION_REQUEST as C1
    left outer join 
    TRANS_REQUEST_STATUS as C2 on (C1.REQUEST_STATUS =
C2.REQUEST_STATUS_ID)
    left outer join 
    SERVICE_POINT as C3 on (C1.POINT_OF_RECEIPT = C3.SERVICE_POINT_ID)
    left outer join 
    TSIN_USER as C4 on (C1.SELLER = C4.USER_ID)
    left outer join 
    TSIN_USER as C5
    left outer join 
    COMPANY as C6 on (C5.COMPANY_ID = C6.COMPANY_ID) on (C1.CUSTOMER = 
        C5.USER_ID)
    left outer join 
    COMPANY as C7 on (C1.SELLER_COMPANY = C7.COMPANY_ID)
    left outer join 
    SERVICE_POINT as C8 on (C1.POINT_OF_DELIVERY = C8.SERVICE_POINT_ID)
    left outer join 
    PATH as C9 on (C1.PATH_ID = C9.PATH_ID)
    left outer join 
    SERVICE_POINT as C10 on (C1."SOURCE" = C10.SERVICE_POINT_NAME)
    left outer join 
    SRC_SNK_TYPE as C11 on (C10.SOURCE_SINK_TYPE = C11.SOURCE_SINK_TYPE)
    left outer join 
    SRC_SNK_TYPE as C12
    right outer join 
    SERVICE_POINT as C13 on (C12.SOURCE_SINK_TYPE =
C13.SOURCE_SINK_TYPE) on (
        C1.SINK = C13.SERVICE_POINT_NAME)
    left outer join 
    SERVICE as C14 on (C1.CAPACITY_TYPE = C14.SERVICE_ID)
    left outer join 
    OFFER_TYPE as C15 on (C14.OFFERING_TYPE = C15.OFFERING_TYPE_ID)
    where (((C1.UPDATE_FROM_OASIS = 'NEW')
        or (C1.UPDATE_FROM_OASIS = 'UPDATE'))
        or (((C1.REQUEST_STATUS = 0)
        or (C1.REQUEST_STATUS = 1))
        or (C1.REQUEST_STATUS = 2)))
    order by C1.REQUEST_ID desc;
    
create view TRANS_EVAL_CONFIRM_VW_2
    (ID,
     EVAL_SW,
     MW,
     "SOURCE",
     SINK,
     REQUEST_REF,
     COMMENTS_ON_STATUS,
     CUSTOMER_COMMENTS,
     PRECONFIRM,
     BEGTIME,
     ENDTIME,
     REQUEST_STATUS,
     PATH,
     SEGMENT_ID,
     STARTTIME,
     END_TIME,
     CAPACITY_TYPE,
     FIRM_SW,
     SERVICE_NAME,
     "STATUS",
     MW_VAL,
     PRICE,
     TIME_OF_LAST_UPDATE,
     PRICE_UNITS,
     POR,
     POD,
     CUSTOMER,
     SELLER_COMPANY,
     SELLERS_NAME,
     REQUEST_QUEUE_TIME,
     OASIS_REQUEST_ID,
     UPDATE_FROM_OASIS,
     POST_TO_OASIS_STATUS,
     NATIVE_LOAD_SW,
     POST_TO_OASIS_SW) as
    select
        C1.REQUEST_ID,
        C1.EVAL_SW,
        C1.CAPACITY_TYPE,
        C1.SOURCE,
        C1.SINK,
        C1.REQUEST_REF,
        C1.STATUS_COMMENTS,
        C1.CUSTOMER_COMMENTS,
        C1.PRECONFIRMED,
        C1.BEGTIME,
        C1.ENDTIME,
        C1.REQUEST_STATUS,
        C3.PATH_CODE,
        C2.SEGMENT_ID,
        C2.BEGTIME,
        C2.ENDTIME,
        C4.OFFERING_TYPE,
        C4.FIRM_SW,
        C4.SERVICE_NAME,
        C5.DESCRIPTION,
        C2.CAPACITY,
        C2.PRICE,
        C2.TIME_OF_LAST_UPDATE,
        C4.PRICE_UNITS,
        C6.SERVICE_POINT_NAME,
        C7.SERVICE_POINT_NAME,
        C9.COMPANY_NAME,
        C10.COMPANY_NAME,
        C11.NAME,
        C1.REQUEST_QUEUE_TIME,
        C1.OASIS_REQUEST_ID,
        C1.UPDATE_FROM_OASIS,
        C1.POST_TO_OASIS_STATUS,
        C1.NATIVE_LOAD_SW,
        C1.POST_TO_OASIS_SW
    from TRANSMISSION_REQUEST as C1
    inner join 
    REQUEST_SEGMENT as C2 on (C1.REQUEST_ID = C2.REQUEST_ID)
    left outer join 
    PATH as C3 on (C1.PATH_ID = C3.PATH_ID)
    left outer join 
    SERVICE as C4 on (C1.CAPACITY_TYPE = C4.SERVICE_ID)
    left outer join 
    TRANS_REQUEST_STATUS as C5 on (C1.REQUEST_STATUS =
C5.REQUEST_STATUS_ID)
    left outer join 
    SERVICE_POINT as C6 on (C1.POINT_OF_RECEIPT = C6.SERVICE_POINT_ID)
    left outer join 
    SERVICE_POINT as C7 on (C1.POINT_OF_DELIVERY = C7.SERVICE_POINT_ID)
    left outer join 
    TSIN_USER as C8
    left outer join 
    COMPANY as C9 on (C8.COMPANY_ID = C9.COMPANY_ID) on (C1.CUSTOMER = 
        C8.USER_ID)
    left outer join 
    COMPANY as C10 on (C1.SELLER_COMPANY = C10.COMPANY_ID)
    left outer join 
    TSIN_USER as C11 on (C1.SELLER = C11.USER_ID);
    
create view TRANSMISSION_REQUEST_01_VW
    (REQUEST_ID,
     OASIS_REQUEST_ID,
     SELLER,
     SELLER_COMPANY,
     PATH_ID,
     PATH_CODE,
     PATH_POR,
     PATH_POD,
     POINT_OF_RECEIPT,
     POINT_OF_DELIVERY,
     POR_NAME,
     POD_NAME,
     CAPACITY_TYPE,
     PRICE_UNITS,
     ON_PEAK_SW,
     CUS_USER_ID,
     CUS_USER_NM,
     CUS_CO_ID,
     CUS_CO_NM,
     BEGTIME,
     ENDTIME,
     SALE_REF,
     DEAL_REF,
     REQUEST_QUEUE_TIME,
     REQUEST_REF,
     REQUEST_STATUS,
     STATUS_DESCRIPTION,
     "SOURCE",
     SINK,
     TIME_OF_LAST_UPDATE,
     STATUS_COMMENTS,
     CUSTOMER_COMMENTS,
     SELLER_COMMENTS,
     PROVIDER_COMMENTS,
     PRECONFIRMED,
     PRESCHEDULE,
     ENERGY_RATE,
     LOSS_RATE,
     LOSS_SUPPLIER,
     FUEL_RATE,
     DEPOSIT,
     INTEREST,
     EVAL_SW,
     NATIVE_LOAD_SW) as
    select
        C1.REQUEST_ID,
        C1.OASIS_REQUEST_ID,
        C1.SELLER,
        C1.SELLER_COMPANY,
        C1.PATH_ID,
        C2.PATH_CODE,
        C2.POINT_OF_RECEIPT,
        C2.POINT_OF_DELIVERY,
        C1.POINT_OF_RECEIPT,
        C1.POINT_OF_DELIVERY,
        C7.SERVICE_POINT_NAME,
        C8.SERVICE_POINT_NAME,
        C1.CAPACITY_TYPE,
        C6.PRICE_UNITS,
        C6.ON_PEAK_SW,
        C1.CUSTOMER,
        C3.NAME,
        C3.COMPANY_ID,
        C4.FULL_COMPANY_NAME,
        C1.BEGTIME,
        C1.ENDTIME,
        C1.SALE_REF,
        C1.DEAL_REF,
        C1.REQUEST_QUEUE_TIME,
        C1.REQUEST_REF,
        C1.REQUEST_STATUS,
        C5.DESCRIPTION,
        C1.SOURCE,
        C1.SINK,
        C1.TIME_OF_LAST_UPDATE,
        C1.STATUS_COMMENTS,
        C1.CUSTOMER_COMMENTS,
        C1.SELLER_COMMENTS,
        C1.PROVIDER_COMMENTS,
        C1.PRECONFIRMED,
        C1.PRESCHEDULE,
        C1.ENERGY_RATE,
        C1.LOSS_RATE,
        C1.LOSS_SUPPLIER,
        C1.FUEL_RATE,
        C1.DEPOSIT,
        C1.INTEREST,
        C1.EVAL_SW,
        C1.NATIVE_LOAD_SW
    from TRANSMISSION_REQUEST as C1
    left outer join 
    PATH as C2 on (C1.PATH_ID = C2.PATH_ID)
    left outer join 
    TSIN_USER as C3
    left outer join 
    COMPANY as C4 on (C3.COMPANY_ID = C4.COMPANY_ID) on (C1.CUSTOMER = 
        C3.USER_ID)
    inner join 
    TRANS_REQUEST_STATUS as C5 on (C1.REQUEST_STATUS =
C5.REQUEST_STATUS_ID)
    left outer join 
    SERVICE as C6 on (C1.CAPACITY_TYPE = C6.SERVICE_ID)
    left outer join 
    SERVICE_POINT as C7 on (C1.POINT_OF_RECEIPT = C7.SERVICE_POINT_ID)
    left outer join 
    SERVICE_POINT as C8 on (C1.POINT_OF_DELIVERY = C8.SERVICE_POINT_ID);
    
create view SELEVALREQ2_VW
    (REQUEST_TIME,
     REQUEST_ID,
     "START",
     "STOP",
     SELLERCO,
     DESCRIPTION,
     POR,
     SELLER,
     "SOURCE",
     SINK,
     PATH_ID,
     POINT_OF_DELIVERY,
     POINT_OF_RECEIPT,
     SELLER_CO,
     CUSTOMER,
     POD,
     OASIS_REQUEST_ID,
     UPDATE_FROM_OASIS,
     POST_TO_OASIS_STATUS,
     OASIS_STATUS,
     REQUEST_STATUS,
     CAPACITY_TYPE,
     PATH_CODE,
     PODP,
     PORP,
     SRCTYPE,
     SINKTYPE,
     OFFER,
     NETSOURCE,
     NETSINK,
     NETWORK_PATH) as
    select
        C1.REQUEST_QUEUE_TIME,
        C1.REQUEST_ID,
        C1.BEGTIME,
        C1.ENDTIME,
        C1.SELLER_COMPANY,
        C2.DESCRIPTION,
        C3.SERVICE_POINT_NAME,
        C4.NAME,
        C1.SOURCE,
        C1.SINK,
        C1.PATH_ID,
        C1.POINT_OF_DELIVERY,
        C1.POINT_OF_RECEIPT,
        C7.COMPANY_NAME,
        C6.COMPANY_NAME,
        C8.SERVICE_POINT_NAME,
        C1.OASIS_REQUEST_ID,
        C1.UPDATE_FROM_OASIS,
        C1.POST_TO_OASIS_STATUS,
        C1.POST_TO_OASIS_SW,
        C1.REQUEST_STATUS,
        C1.CAPACITY_TYPE,
        C9.PATH_CODE,
        C9.POINT_OF_DELIVERY,
        C9.POINT_OF_RECEIPT,
        C11.DESCRIPTION,
        C12.DESCRIPTION,
        C14.OFFERING_TYPE,
        C10.NETWORK_SERVICE_POINT_NAME,
        C13.NETWORK_SERVICE_POINT_NAME,
        C9.NETWORK_PATH
    from TRANSMISSION_REQUEST as C1
    left outer join 
    TRANS_REQUEST_STATUS as C2 on (C1.REQUEST_STATUS =
C2.REQUEST_STATUS_ID)
    left outer join 
    SERVICE_POINT as C3 on (C1.POINT_OF_RECEIPT = C3.SERVICE_POINT_ID)
    left outer join 
    TSIN_USER as C4 on (C1.SELLER = C4.USER_ID)
    left outer join 
    TSIN_USER as C5
    left outer join 
    COMPANY as C6 on (C5.COMPANY_ID = C6.COMPANY_ID) on (C1.CUSTOMER = 
        C5.USER_ID)
    left outer join 
    COMPANY as C7 on (C1.SELLER_COMPANY = C7.COMPANY_ID)
    left outer join 
    SERVICE_POINT as C8 on (C1.POINT_OF_DELIVERY = C8.SERVICE_POINT_ID)
    left outer join 
    PATH as C9 on (C1.PATH_ID = C9.PATH_ID)
    left outer join 
    SERVICE_POINT as C10 on (C1."SOURCE" = C10.SERVICE_POINT_NAME)
    left outer join 
    SRC_SNK_TYPE as C11 on (C10.SOURCE_SINK_TYPE = C11.SOURCE_SINK_TYPE)
    left outer join 
    SRC_SNK_TYPE as C12
    right outer join 
    SERVICE_POINT as C13 on (C12.SOURCE_SINK_TYPE =
C13.SOURCE_SINK_TYPE) on (
        C1.SINK = C13.SERVICE_POINT_NAME)
    left outer join 
    SERVICE as C14 on (C1.CAPACITY_TYPE = C14.SERVICE_ID)
    left outer join 
    OFFER_TYPE as C15 on (C14.OFFERING_TYPE = C15.OFFERING_TYPE_ID)
    where (((C1.UPDATE_FROM_OASIS = 'NEW')
        or (C1.UPDATE_FROM_OASIS = 'UPDATE'))
        or (((C1.REQUEST_STATUS = 0)
        or (C1.REQUEST_STATUS = 1))
        or (C1.REQUEST_STATUS = 2)))
    order by C1.REQUEST_ID desc;
    
create view ANCILLARY_REQUEST_01_VW
    (REQUEST_ID,
     OASIS_REQUEST_ID,
     CONTROL_AREA_ID,
     SELLER_COMPANY,
     ANCILLARY_SERVICE_ID,
     CUSTOMER,
     BEGTIME,
     ENDTIME,
     REQUEST_STATUS,
     PRICE,
     SERVICE_DESCRIPTION,
     SELLER,
     DEAL_REF,
     REQUEST_REF,
     SALE_REF,
     CUSTOMER_COMMENTS,
     SELLER_COMMENTS,
     STATUS_COMMENTS,
     PROVIDER_COMMENTS,
     PRECONFIRMED,
     REASSIGNED_REF,
     REQUEST_QUEUE_TIME,
     TIME_OF_LAST_UPDATE,
     TRANS_REQUEST_ID,
     QUANTITY,
     PRICE_UNITS,
     ANC_SERVICE_NAME,
     ANC_SERVICE_DESCRIPTION,
     CUSNAME,
     CUSCOID,
     CUSCONAME) as
    select
        C1.REQUEST_ID,
        C1.OASIS_REQUEST_ID,
        C1.CONTROL_AREA_ID,
        C1.SELLER_COMPANY,
        C1.ANCILLARY_SERVICE_ID,
        C1.CUSTOMER,
        C1.BEGTIME,
        C1.ENDTIME,
        C1.REQUEST_STATUS,
        C1.PRICE,
        C1.SERVICE_DESCRIPTION,
        C1.SELLER,
        C1.DEAL_REF,
        C1.REQUEST_REF,
        C1.SALE_REF,
        C1.CUSTOMER_COMMENTS,
        C1.SELLER_COMMENTS,
        C1.STATUS_COMMENTS,
        C1.PROVIDER_COMMENTS,
        C1.PRECONFIRMED,
        C1.REASSIGNED_REF,
        C1.REQUEST_QUEUE_TIME,
        C1.TIME_OF_LAST_UPDATE,
        C1.TRANS_REQUEST_ID,
        C1.QUANTITY,
        C2.PRICE_UNITS,
        C2.ANC_SERVICE_NAME,
        C2.ANC_SERVICE_DESCRIPTION,
        C3.NAME,
        C3.COMPANY_ID,
        C4.FULL_COMPANY_NAME
    from ANCILLARY_REQUEST as C1
    left outer join 
    ANCILLARY_SERVICE as C2 on (C1.ANCILLARY_SERVICE_ID = 
        C2.ANCILLARY_SERVICE_ID)
    left outer join 
    TSIN_USER as C3 on (C1.CUSTOMER = C3.USER_ID)
    left outer join 
    COMPANY as C4 on (C3.COMPANY_ID = C4.COMPANY_ID);
    
create view CURTPRIORITIES_VW
    (BEG_TIME,
     END_TIME,
     PATH_CODE,
     CURT_SEQ,
     PATHCODE,
     NETWORK_SOURCE,
     NETWORK_SINK,
     NETWORK_RESPONSE_FACTOR,
     EVN_DT,
     REQUEST_ID,
     SEGMENT_ID,
     SERVICE_NAME,
     CAPACITY,
     PRICE,
     PRICE_UNITS,
     REVENUE,
     BEGTIME,
     ENDTIME) as
    select
        C1.BEGTIME,
        C1.ENDTIME,
        C4.PATH_CODE,
        C5.CURT_SEQ,
        C3.PATH_CODE,
        C4.NETWORK_SOURCE,
        C4.NETWORK_SINK,
        C4.NETWORK_RESPONSE_FACTOR,
        C4.EVN_DT,
        C1.REQUEST_ID,
        C1.SEGMENT_ID,
        C5.SERVICE_NAME,
        C1.CAPACITY,
        C1.PRICE,
        C5.PRICE_UNITS,
        (C1.PRICE * C1.CAPACITY),
        C2.BEGTIME,
        C2.ENDTIME
    from REQUEST_SEGMENT as C1
    left outer join 
    TRANSMISSION_REQUEST as C2 on (C1.REQUEST_ID = C2.REQUEST_ID)
    left outer join 
    PATH as C3 on (C2.PATH_ID = C3.PATH_ID)
    left outer join 
    NETWORK_FACTOR as C4 on ((C2."SOURCE" = C4.NETWORK_SOURCE)
            and (C2.SINK = C4.NETWORK_SINK))
    left outer join 
    SERVICE as C5 on (C2.CAPACITY_TYPE = C5.SERVICE_ID)
    order by C4.EVN_DT desc;
    
create view TRANSMISSION_CAPABILITY_01_VW
    (CAPABILITY_ID,
     CAPACITY_TYPE,
     SERVICE_NAME,
     OFFERING_TYPE,
     FIRM_SW,
     SELLER_COMPANY,
     SELLER,
     PATH_ID,
     PATH_CODE,
     SALE_REF,
     CAPACITY,
     PRICE,
     SELLER_COMMENTS,
     PROVIDER_COMMENTS,
     BEGTIME,
     TIME_OF_LAST_UPDATE,
     POST_TO_OASIS_SW,
     OASIS_CAPABILITY_ID,
     POSTING_REF) as
    select
        C1.CAPABILITY_ID,
        C1.CAPACITY_TYPE,
        C3.SERVICE_NAME,
        C3.OFFERING_TYPE,
        C3.FIRM_SW,
        C1.SELLER_COMPANY,
        C1.SELLER,
        C1.PATH_ID,
        C2.PATH_CODE,
        C1.SALE_REF,
        C1.CAPACITY,
        C1.PRICE,
        C1.SELLER_COMMENTS,
        C1.PROVIDER_COMMENTS,
        C1.BEGTIME,
        C1.TIME_OF_LAST_UPDATE,
        C1.POST_TO_OASIS_SW,
        C1.OASIS_CAPABILITY_ID,
        C1.POSTING_REF
    from TRANSMISSION_CAPABILITY as C1
    left outer join 
    PATH as C2 on (C1.PATH_ID = C2.PATH_ID)
    left outer join 
    SERVICE as C3 on (C1.CAPACITY_TYPE = C3.SERVICE_ID);
    
create view SELEVALREQ_VW
    (REQUEST_TIME,
     REQUEST_ID,
     "START",
     "STOP",
     DESCRIPTION,
     POR,
     SELLER,
     "SOURCE",
     SINK,
     PATH_ID,
     POINT_OF_DELIVERY,
     POINT_OF_RECEIPT,
     SELLER_CO,
     CUSTOMER,
     POD,
     OASIS_REQUEST_ID,
     UPDATE_FROM_OASIS,
     POST_TO_OASIS_STATUS,
     OASIS_STATUS,
     REQUEST_STATUS,
     PATH_CODE,
     PODP,
     PORP,
     SRCTYPE,
     SINKTYPE,
     OFFER,
     NETSOURCE,
     NETSINK,
     NETWORK_PATH) as
    select
        C1.REQUEST_QUEUE_TIME,
        C1.REQUEST_ID,
        C1.BEGTIME,
        C1.ENDTIME,
        C2.DESCRIPTION,
        C3.SERVICE_POINT_NAME,
        C4.NAME,
        C1.SOURCE,
        C1.SINK,
        C1.PATH_ID,
        C1.POINT_OF_DELIVERY,
        C1.POINT_OF_RECEIPT,
        C7.COMPANY_NAME,
        C6.COMPANY_NAME,
        C8.SERVICE_POINT_NAME,
        C1.OASIS_REQUEST_ID,
        C1.UPDATE_FROM_OASIS,
        C1.POST_TO_OASIS_STATUS,
        C1.POST_TO_OASIS_SW,
        C1.REQUEST_STATUS,
        C9.PATH_CODE,
        C9.POINT_OF_DELIVERY,
        C9.POINT_OF_RECEIPT,
        C11.DESCRIPTION,
        C12.DESCRIPTION,
        C14.OFFERING_TYPE,
        C10.NETWORK_SERVICE_POINT_NAME,
        C13.NETWORK_SERVICE_POINT_NAME,
        C9.NETWORK_PATH
    from TRANSMISSION_REQUEST as C1
    left outer join 
    TRANS_REQUEST_STATUS as C2 on (C1.REQUEST_STATUS =
C2.REQUEST_STATUS_ID)
    left outer join 
    SERVICE_POINT as C3 on (C1.POINT_OF_RECEIPT = C3.SERVICE_POINT_ID)
    left outer join 
    TSIN_USER as C4 on (C1.SELLER = C4.USER_ID)
    left outer join 
    TSIN_USER as C5
    left outer join 
    COMPANY as C6 on (C5.COMPANY_ID = C6.COMPANY_ID) on (C1.CUSTOMER = 
        C5.USER_ID)
    left outer join 
    COMPANY as C7 on (C1.SELLER_COMPANY = C7.COMPANY_ID)
    left outer join 
    SERVICE_POINT as C8 on (C1.POINT_OF_DELIVERY = C8.SERVICE_POINT_ID)
    left outer join 
    PATH as C9 on (C1.PATH_ID = C9.PATH_ID)
    left outer join 
    SERVICE_POINT as C10 on (C1."SOURCE" = C10.SERVICE_POINT_NAME)
    left outer join 
    SRC_SNK_TYPE as C11 on (C10.SOURCE_SINK_TYPE = C11.SOURCE_SINK_TYPE)
    left outer join 
    SRC_SNK_TYPE as C12
    right outer join 
    SERVICE_POINT as C13 on (C12.SOURCE_SINK_TYPE =
C13.SOURCE_SINK_TYPE) on (
        C1.SINK = C13.SERVICE_POINT_NAME)
    left outer join 
    SERVICE as C14 on (C1.CAPACITY_TYPE = C14.SERVICE_ID)
    left outer join 
    OFFER_TYPE as C15 on (C14.OFFERING_TYPE = C15.OFFERING_TYPE_ID)
    where (((C1.UPDATE_FROM_OASIS = 'NEW')
        or (C1.UPDATE_FROM_OASIS = 'UPDATE'))
        or (((C1.REQUEST_STATUS = 0)
        or (C1.REQUEST_STATUS = 1))
        or (C1.REQUEST_STATUS = 2)))
    order by C1.REQUEST_ID desc;
    
create view TRANS_EVAL_VW
    (REQUEST_ID,
     TRANS_START,
     OASIS_ID,
     TRANS_END,
     REQUEST_STATUS,
     NETPATH,
     PATH_ID,
     EVAL_SW,
     SEGMENT_ID,
     BEGTIME,
     ENDTIME,
     CAPACITY,
     CBM,
     FIRM_SW,
     NETSOURCE,
     NETSINK,
     DESCRIPTION) as
    select
        C1.REQUEST_ID,
        C1.BEGTIME,
        C1.OASIS_REQUEST_ID,
        C1.ENDTIME,
        C1.REQUEST_STATUS,
        C3.NETWORK_PATH,
        C3.PATH_ID,
        C1.EVAL_SW,
        C2.SEGMENT_ID,
        C2.BEGTIME,
        C2.ENDTIME,
        C2.CAPACITY,
        C2.CBM_TYPE_SW,
        C4.FIRM_SW,
        C5.NETWORK_SERVICE_POINT_NAME,
        C6.NETWORK_SERVICE_POINT_NAME,
        C7.DESCRIPTION
    from TRANSMISSION_REQUEST as C1
    left outer join 
    REQUEST_SEGMENT as C2 on (C1.REQUEST_ID = C2.REQUEST_ID)
    left outer join 
    PATH as C3 on (C1.PATH_ID = C3.PATH_ID)
    left outer join 
    SERVICE as C4 on (C1.CAPACITY_TYPE = C4.SERVICE_ID)
    left outer join 
    SERVICE_POINT as C5 on (C1."SOURCE" = C5.SERVICE_POINT_NAME)
    left outer join 
    SERVICE_POINT as C6 on (C1.SINK = C6.SERVICE_POINT_NAME)
    left outer join 
    TRANS_REQUEST_STATUS as C7 on (C1.REQUEST_STATUS =
C7.REQUEST_STATUS_ID);
    
create view TRANS_EVAL_CONFIRM_VW
    (ID,
     EVAL_SW,
     MW,
     "SOURCE",
     SINK,
     REQUEST_REF,
     COMMENTS_ON_STATUS,
     CUSTOMER_COMMENTS,
     PRECONFIRM,
     BEGTIME,
     ENDTIME,
     REQUEST_STATUS,
     PATH,
     SEGMENT_ID,
     STARTTIME,
     END_TIME,
     CAPACITY_TYPE,
     FIRM_SW,
     SERVICE_NAME,
     "STATUS",
     MW_VAL,
     PRICE,
     TIME_OF_LAST_UPDATE,
     PRICE_UNITS,
     POR,
     POD,
     CUSTOMER,
     SELLER_COMPANY,
     SELLERS_NAME,
     REQUEST_QUEUE_TIME,
     OASIS_REQUEST_ID,
     UPDATE_FROM_OASIS,
     POST_TO_OASIS_STATUS,
     POST_TO_OASIS_SW) as
    select
        C1.REQUEST_ID,
        C1.EVAL_SW,
        C1.CAPACITY_TYPE,
        C1.SOURCE,
        C1.SINK,
        C1.REQUEST_REF,
        C1.STATUS_COMMENTS,
        C1.CUSTOMER_COMMENTS,
        C1.PRECONFIRMED,
        C1.BEGTIME,
        C1.ENDTIME,
        C1.REQUEST_STATUS,
        C3.PATH_CODE,
        C2.SEGMENT_ID,
        C2.BEGTIME,
        C2.ENDTIME,
        C4.OFFERING_TYPE,
        C4.FIRM_SW,
        C4.SERVICE_NAME,
        C5.DESCRIPTION,
        C2.CAPACITY,
        C2.PRICE,
        C2.TIME_OF_LAST_UPDATE,
        C4.PRICE_UNITS,
        C6.SERVICE_POINT_NAME,
        C7.SERVICE_POINT_NAME,
        C9.COMPANY_NAME,
        C10.COMPANY_NAME,
        C11.NAME,
        C1.REQUEST_QUEUE_TIME,
        C1.OASIS_REQUEST_ID,
        C1.UPDATE_FROM_OASIS,
        C1.POST_TO_OASIS_STATUS,
        C1.POST_TO_OASIS_SW
    from TRANSMISSION_REQUEST as C1
    inner join 
    REQUEST_SEGMENT as C2 on (C1.REQUEST_ID = C2.REQUEST_ID)
    left outer join 
    PATH as C3 on (C1.PATH_ID = C3.PATH_ID)
    left outer join 
    SERVICE as C4 on (C1.CAPACITY_TYPE = C4.SERVICE_ID)
    left outer join 
    TRANS_REQUEST_STATUS as C5 on (C1.REQUEST_STATUS =
C5.REQUEST_STATUS_ID)
    left outer join 
    SERVICE_POINT as C6 on (C1.POINT_OF_RECEIPT = C6.SERVICE_POINT_ID)
    left outer join 
    SERVICE_POINT as C7 on (C1.POINT_OF_DELIVERY = C7.SERVICE_POINT_ID)
    left outer join 
    TSIN_USER as C8
    left outer join 
    COMPANY as C9 on (C8.COMPANY_ID = C9.COMPANY_ID) on (C1.CUSTOMER = 
        C8.USER_ID)
    left outer join 
    COMPANY as C10 on (C1.SELLER_COMPANY = C10.COMPANY_ID)
    left outer join 
    TSIN_USER as C11 on (C1.SELLER = C11.USER_ID);
    
create view TRANS_EVAL_FILE_VW
    (REQUEST_ID,
     TRANS_START,
     OASIS_ID,
     TRANS_END,
     REQUEST_STATUS,
     NETPATH,
     EVAL_SW,
     SEGMENT_ID,
     BEGTIME,
     ENDTIME,
     CAPACITY,
     CBM,
     FIRM_SW,
     NETSOURCE,
     NETSINK,
     DESCRIPTION) as
    select
        C1.REQUEST_ID,
        C1.BEGTIME,
        C1.OASIS_REQUEST_ID,
        C1.ENDTIME,
        C1.REQUEST_STATUS,
        C3.NETWORK_PATH,
        C1.EVAL_SW,
        C2.SEGMENT_ID,
        C2.BEGTIME,
        C2.ENDTIME,
        C2.CAPACITY,
        C2.CBM_TYPE_SW,
        C4.FIRM_SW,
        C5.NETWORK_SERVICE_POINT_NAME,
        C6.NETWORK_SERVICE_POINT_NAME,
        C7.DESCRIPTION
    from TRANSMISSION_REQUEST as C1
    left outer join 
    REQUEST_SEGMENT as C2 on (C1.REQUEST_ID = C2.REQUEST_ID)
    left outer join 
    PATH as C3 on (C1.PATH_ID = C3.PATH_ID)
    left outer join 
    SERVICE as C4 on (C1.CAPACITY_TYPE = C4.SERVICE_ID)
    left outer join 
    SERVICE_POINT as C5 on (C1."SOURCE" = C5.SERVICE_POINT_NAME)
    left outer join 
    SERVICE_POINT as C6 on (C1.SINK = C6.SERVICE_POINT_NAME)
    left outer join 
    TRANS_REQUEST_STATUS as C7 on (C1.REQUEST_STATUS =
C7.REQUEST_STATUS_ID);
    
create view NEWEVALREQ_VW
    (REQUEST_TIME,
     REQUEST_ID,
     "START",
     "STOP",
     DESCRIPTION,
     POR,
     SELLER,
     "SOURCE",
     SINK,
     PATH_ID,
     POINT_OF_DELIVERY,
     POINT_OF_RECEIPT,
     SELLER_CO,
     CUSTOMER,
     POD,
     OASIS_REQUEST_ID,
     UPDATE_FROM_OASIS,
     POST_TO_OASIS_STATUS,
     OASIS_STATUS,
     REQUEST_STATUS,
     PATH_CODE,
     PODP,
     PORP,
     SRCTYPE,
     SINKTYPE,
     OFFER) as
    select
        C1.REQUEST_QUEUE_TIME,
        C1.REQUEST_ID,
        C1.BEGTIME,
        C1.ENDTIME,
        C2.DESCRIPTION,
        C3.SERVICE_POINT_NAME,
        C4.NAME,
        C1.SOURCE,
        C1.SINK,
        C1.PATH_ID,
        C1.POINT_OF_DELIVERY,
        C1.POINT_OF_RECEIPT,
        C7.COMPANY_NAME,
        C6.COMPANY_NAME,
        C8.SERVICE_POINT_NAME,
        C1.OASIS_REQUEST_ID,
        C1.UPDATE_FROM_OASIS,
        C1.POST_TO_OASIS_STATUS,
        C1.POST_TO_OASIS_SW,
        C1.REQUEST_STATUS,
        C9.PATH_CODE,
        C9.POINT_OF_DELIVERY,
        C9.POINT_OF_RECEIPT,
        C11.DESCRIPTION,
        C12.DESCRIPTION,
        C14.OFFERING_TYPE
    from TRANSMISSION_REQUEST as C1
    left outer join 
    TRANS_REQUEST_STATUS as C2 on (C1.REQUEST_STATUS =
C2.REQUEST_STATUS_ID)
    left outer join 
    SERVICE_POINT as C3 on (C1.POINT_OF_RECEIPT = C3.SERVICE_POINT_ID)
    left outer join 
    TSIN_USER as C4 on (C1.SELLER = C4.USER_ID)
    left outer join 
    TSIN_USER as C5
    left outer join 
    COMPANY as C6 on (C5.COMPANY_ID = C6.COMPANY_ID) on (C1.CUSTOMER = 
        C5.USER_ID)
    left outer join 
    COMPANY as C7 on (C1.SELLER_COMPANY = C7.COMPANY_ID)
    left outer join 
    SERVICE_POINT as C8 on (C1.POINT_OF_DELIVERY = C8.SERVICE_POINT_ID)
    left outer join 
    PATH as C9 on (C1.PATH_ID = C9.PATH_ID)
    left outer join 
    SERVICE_POINT as C10 on (C1."SOURCE" = C10.SERVICE_POINT_NAME)
    left outer join 
    SRC_SNK_TYPE as C11 on (C10.SOURCE_SINK_TYPE = C11.SOURCE_SINK_TYPE)
    left outer join 
    SRC_SNK_TYPE as C12
    right outer join 
    SERVICE_POINT as C13 on (C12.SOURCE_SINK_TYPE =
C13.SOURCE_SINK_TYPE) on (
        C1.SINK = C13.SERVICE_POINT_NAME)
    left outer join 
    SERVICE as C14 on (C1.CAPACITY_TYPE = C14.SERVICE_ID)
    left outer join 
    OFFER_TYPE as C15 on (C14.OFFERING_TYPE = C15.OFFERING_TYPE_ID)
    where (((C1.UPDATE_FROM_OASIS = 'NEW')
        or (C1.UPDATE_FROM_OASIS = 'UPDATE'))
        or (((C1.REQUEST_STATUS = 0)
        or (C1.REQUEST_STATUS = 1))
        or (C1.REQUEST_STATUS = 2)))
    order by C1.REQUEST_ID desc;
    
create view ATC_RESULT_VW
    (REQUEST_TIME,
     STUDY_TYPE,
     STUDY_DATE,
     STUDY_HH,
     PATH_CODE,
     FIRM_PATH_ATC,
     FIRM_NETWORK_ATC,
     FIRM_POSTED_ATC,
     NFIRM_PATH_ATC,
     NFIRM_NETWORK_ATC,
     NFIRM_POSTED_ATC,
     TTC,
     FIRM_MON_ELM,
     FIRM_CTG_ELM,
     NFIRM_MON_ELM,
     NFIRM_CTG_ELM,
     FIRM_CTG_ID,
     NFIRM_CTG_ID,
     ERROR_MESSAGE,
     EVAL_STATUS,
     CLONE_NAME,
     POST_SW,
     ON_PEAK_SW,
     DISP_SW,
     EMS_ORDER_SEQ) as
    select
        C1.REQUEST_TIME,
        C1.STUDY_TYPE,
        C1.STUDY_DATE,
        C1.STUDY_HH,
        C1.PATH_CODE,
        C1.FIRM_PATH_ATC,
        C1.FIRM_NETWORK_ATC,
        C1.FIRM_POSTED_ATC,
        C1.NFIRM_PATH_ATC,
        C1.NFIRM_NETWORK_ATC,
        C1.NFIRM_POSTED_ATC,
        C1.TTC,
        C1.FIRM_MON_ELM,
        C1.FIRM_CTG_ELM,
        C1.NFIRM_MON_ELM,
        C1.NFIRM_CTG_ELM,
        C1.FIRM_CTG_ID,
        C1.NFIRM_CTG_ID,
        C1.ERROR_MESSAGE,
        C1.EVAL_STATUS,
        C1.CLONE_NAME,
        C1.POST_SW,
        C1.ON_PEAK_SW,
        C2.DISP_SW,
        C2.EMS_ORDER_SEQ
    from ATC_RESULT as C1
    left outer join 
    PATH as C2 on (C1.PATH_CODE = C2.PATH_CODE);
    
create view REQUEST_SEGMENT_02_VW
    (REQUEST_ID,
     OASIS_REQUEST_ID,
     REQUEST_STATUS,
     BEGTIME,
     ENDTIME,
     CUS_CO_ID,
     CUS_CO_NM,
     SEGMENT_ID,
     OASIS_SEGMENT_ID,
     SEG_BEGTIME,
     SEG_ENDTIME,
     CAPACITY,
     PRICE,
     SERVICE_ID,
     SERVICE_NAME,
     PRICE_UNITS) as
    select
        C1.REQUEST_ID,
        C1.OASIS_REQUEST_ID,
        C1.REQUEST_STATUS,
        C1.BEGTIME,
        C1.ENDTIME,
        C4.COMPANY_ID,
        C4.FULL_COMPANY_NAME,
        C2.SEGMENT_ID,
        C2.OASIS_SEGMENT_ID,
        C2.BEGTIME,
        C2.ENDTIME,
        C2.CAPACITY,
        C2.PRICE,
        C5.SERVICE_ID,
        C5.SERVICE_NAME,
        C5.PRICE_UNITS
    from TRANSMISSION_REQUEST as C1
    left outer join 
    REQUEST_SEGMENT as C2 on (C1.REQUEST_ID = C2.REQUEST_ID)
    left outer join 
    TSIN_USER as C3 on (C1.CUSTOMER = C3.USER_ID)
    left outer join 
    COMPANY as C4 on (C3.COMPANY_ID = C4.COMPANY_ID)
    left outer join 
    SERVICE as C5 on (C1.CAPACITY_TYPE = C5.SERVICE_ID)
    where (C1.REQUEST_STATUS = 5);
    
create view SCHEDULE_EVENT_03_VW
    (REQUEST_ID,
     OASIS_REQUEST_ID,
     REQUEST_STATUS,
     BEGTIME,
     ENDTIME,
     ENERGY_RATE,
     FUEL_RATE,
     LOSS_SUPPLIER,
     DEPOSIT,
     INTEREST,
     CUS_CO_ID,
     CUS_CO_NM,
     SERVICE_ID,
     SERVICE_NAME,
     PRICE_UNITS,
     PATH_CODE,
     TOP_2_OPA_ID,
     SCH_ICHG_DIR_TYP_ID,
     ICHG_TYP_ID,
     SCHEDULE_ID,
     SEGMENT_ID,
     START_TIME,
     END_TIME,
     CAPACITY,
     IN_ICHG_TYP_ID,
     OUT_ICHG_TYP_ID,
     "COMMENT") as
    select
        C1.REQUEST_ID,
        C1.OASIS_REQUEST_ID,
        C1.REQUEST_STATUS,
        C1.BEGTIME,
        C1.ENDTIME,
        C1.ENERGY_RATE,
        C1.FUEL_RATE,
        C1.LOSS_SUPPLIER,
        C1.DEPOSIT,
        C1.INTEREST,
        C3.COMPANY_ID,
        C3.FULL_COMPANY_NAME,
        C4.SERVICE_ID,
        C4.SERVICE_NAME,
        C4.PRICE_UNITS,
        C5.PATH_CODE,
        C5.TOP_2_OPA_ID,
        C5.SCH_ICHG_DIR_TYP_ID,
        C6.ICHG_TYP_ID,
        C6.SCHEDULE_ID,
        C6.SEGMENT_ID,
        C6.START_TIME,
        C6.END_TIME,
        C6.CAPACITY,
        C6.IN_ICHG_TYP_ID,
        C6.OUT_ICHG_TYP_ID,
        C6.COMMENT
    from TRANSMISSION_REQUEST as C1
    left outer join 
    TSIN_USER as C2 on (C1.CUSTOMER = C2.USER_ID)
    left outer join 
    COMPANY as C3 on (C2.COMPANY_ID = C3.COMPANY_ID)
    left outer join 
    SERVICE as C4 on (C1.CAPACITY_TYPE = C4.SERVICE_ID)
    left outer join 
    PATH as C5 on (C1.PATH_ID = C5.PATH_ID)
    left outer join 
    SCHEDULE_EVENT as C6 on (C1.REQUEST_ID = C6.TRANS_REQUEST_ID)
    where (C1.REQUEST_STATUS = 5);
    
create view UNLOAD_TRANS_CAPABILITY
    (CAPABILITY_ID,
     CAPACITY_TYPE,
     SELLER_COMPANY,
     SELLER,
     PATH_ID,
     SALE_REF,
     CAPACITY,
     PRICE,
     SELLER_COMMENTS,
     PROVIDER_COMMENTS,
     BEGTIME,
     TIME_OF_LAST_UPDATE,
     POST_TO_OASIS_SW,
     OASIS_CAPABILITY_ID,
     POSTING_REF,
     EVAL_REQUEST_NUMBER) as
    select
        C1.CAPABILITY_ID,
        C1.CAPACITY_TYPE,
        C1.SELLER_COMPANY,
        C1.SELLER,
        C1.PATH_ID,
        C1.SALE_REF,
        C1.CAPACITY,
        C1.PRICE,
        C1.SELLER_COMMENTS,
        C1.PROVIDER_COMMENTS,
        C1.BEGTIME,
        C1.TIME_OF_LAST_UPDATE,
        C1.POST_TO_OASIS_SW,
        C1.OASIS_CAPABILITY_ID,
        C1.POSTING_REF,
        C1.EVAL_REQUEST_NUMBER
    from TRANSMISSION_CAPABILITY C1
    where (C1.BEGTIME < DATE VMS ' 1-MAR-1997 00:00:00.00');
    
commit work;

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                             Trigger Definitions
--
------------------------------------------------------------------------
--------
-- no triggers defined

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                              Module Definitions
--
------------------------------------------------------------------------
--------
-- no modules defined

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                          Query Outline Definitions
--
------------------------------------------------------------------------
--------
-- no outlines defined

-- RMU/EXTRACT for DEC Rdb V6.1-02                       10-MAR-1997
11:58:32.91
--
--                            Protection Definitions
--
------------------------------------------------------------------------
--------
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    OPERATOR, DBADM, SECURITY, DISTRIBTRAN
    on database alias RDB$DBHANDLE
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    OPERATOR, DBADM, SECURITY
    on database alias RDB$DBHANDLE
    to SOFT_SUPPORT
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on database alias RDB$DBHANDLE
    to IPT_SUPPORT
    position 3;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on database alias RDB$DBHANDLE
    to DISPATCH
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on database alias RDB$DBHANDLE
    to DISP_SUPPORT
    position 5;
 
grant
    SELECT, SHOW
    on database alias RDB$DBHANDLE
    to TRANS_SUPPORT
    position 6;
 
grant
    SELECT, SHOW
    on database alias RDB$DBHANDLE
    to PUBLIC
    position 7;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table ANCILLARY_OFFERING
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table ANCILLARY_OFFERING
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table ANCILLARY_OFFERING
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table ANCILLARY_OFFERING
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table ANCILLARY_REQUEST
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table ANCILLARY_REQUEST
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table ANCILLARY_REQUEST
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table ANCILLARY_REQUEST
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table ANCILLARY_REQUEST_01_VW
    to [EMS,CLIFTON]
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table ANCILLARY_REQUEST_01_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table ANCILLARY_REQUEST_01_VW
    to DISP_SUPPORT
    position 3;
 
revoke all
    on table ANCILLARY_REQUEST_01_VW
    from PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table ANCILLARY_SERVICE
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table ANCILLARY_SERVICE
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table ANCILLARY_SERVICE
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table ANCILLARY_SERVICE
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table ATC_REQUEST
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table ATC_REQUEST
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table ATC_REQUEST
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table ATC_REQUEST
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table ATC_RESULT
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table ATC_RESULT
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table ATC_RESULT
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table ATC_RESULT
    to PUBLIC
    position 4;
 
grant
    SELECT, SHOW
    on table ATC_RESULT_VW
    to PUBLIC
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table ATC_RESULT_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table ATC_RESULT_VW
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table ATC_UNLOAD_VW
    to [EMS,METZD]
    position 1;
 
revoke all
    on table ATC_UNLOAD_VW
    from PUBLIC
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table AUDIT_LOG
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table AUDIT_LOG
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table AUDIT_LOG
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table AUDIT_LOG
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table CAL_DT
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table CAL_DT
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table CAL_DT
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table CAL_DT
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table CHANGE_DETAILS
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table CHANGE_DETAILS
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table CHANGE_DETAILS
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table CHANGE_DETAILS
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table CO
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table CO
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table CO
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table CO
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table COMPANY
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table COMPANY
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table COMPANY
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table COMPANY
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table CONFIRMED_SCHEDULE_EVENTS_VW
    to [EMS,METZD]
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table CONFIRMED_SCHEDULE_EVENTS_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table CONFIRMED_SCHEDULE_EVENTS_VW
    to DISP_SUPPORT
    position 3;
 
revoke all
    on table CONFIRMED_SCHEDULE_EVENTS_VW
    from PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table CONTROL_AREA
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table CONTROL_AREA
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table CONTROL_AREA
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table CONTROL_AREA
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table CURTAILMENT
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table CURTAILMENT
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table CURTAILMENT
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table CURTAILMENT
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table CURTPRIORITIES_VW
    to [EMS,NEWELL]
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table CURTPRIORITIES_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table CURTPRIORITIES_VW
    to DISP_SUPPORT
    position 3;
 
revoke all
    on table CURTPRIORITIES_VW
    from PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table CUS
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table CUS
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table CUS
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table CUS
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table DAY_TYP
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table DAY_TYP
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table DAY_TYP
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table DAY_TYP
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table DROP_ATC_RESULTS
    to [EMS,METZD]
    position 1;
 
revoke all
    on table DROP_ATC_RESULTS
    from PUBLIC
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table EVAL_REQUEST
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table EVAL_REQUEST
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table EVAL_REQUEST
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table EVAL_REQUEST
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table EVAL_REQUIRED_TIME
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table EVAL_REQUIRED_TIME
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table EVAL_REQUIRED_TIME
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table EVAL_REQUIRED_TIME
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table ICHG_PRC_MISC_FCT
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table ICHG_PRC_MISC_FCT
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table ICHG_PRC_MISC_FCT
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table ICHG_PRC_MISC_FCT
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table MISC_MEAS_TYP
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table MISC_MEAS_TYP
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table MISC_MEAS_TYP
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table MISC_MEAS_TYP
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table NETWORK_FACTOR
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table NETWORK_FACTOR
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table NETWORK_FACTOR
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table NETWORK_FACTOR
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table NETWORK_SOURCE_SINK
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table NETWORK_SOURCE_SINK
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table NETWORK_SOURCE_SINK
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table NETWORK_SOURCE_SINK
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table NETWORK_SOURCE_SINK_VALID
    to [EMS,SU]
    position 1;
 
revoke all
    on table NETWORK_SOURCE_SINK_VALID
    from PUBLIC
    position 2;
 
grant
    SELECT, SHOW
    on table NEWEVALREQ_VW
    to PUBLIC
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table NEWEVALREQ_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table NEWEVALREQ_VW
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table NOTIFY_MESSAGE_LOG
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table NOTIFY_MESSAGE_LOG
    to IPT_SUPPORT
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table NOTIFY_MESSAGE_LOG
    to [EMS,SU]
    position 3;
 
revoke all
    on table NOTIFY_MESSAGE_LOG
    from PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table OFFER_TYPE
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table OFFER_TYPE
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table OFFER_TYPE
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table OFFER_TYPE
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table OPA
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table OPA
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table OPA
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table OPA
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table PATH
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table PATH
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table PATH
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table PATH
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table REQUEST_SEGMENT
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table REQUEST_SEGMENT
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table REQUEST_SEGMENT
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table REQUEST_SEGMENT
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table REQUEST_SEGMENT_01_VW
    to [EMS,CLIFTON]
    position 1;
 
grant
    SELECT, INSERT, UPDATE, SHOW
    on table REQUEST_SEGMENT_01_VW
    to DISP_SUPPORT
    position 2;
 
grant
    SELECT, INSERT, UPDATE, SHOW
    on table REQUEST_SEGMENT_01_VW
    to DISPATCH
    position 3;
 
revoke all
    on table REQUEST_SEGMENT_01_VW
    from PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table REQUEST_SEGMENT_02_VW
    to [EMS,CLIFTON]
    position 1;
 
grant
    SELECT, INSERT, DELETE, SHOW
    on table REQUEST_SEGMENT_02_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, DELETE, SHOW
    on table REQUEST_SEGMENT_02_VW
    to DISP_SUPPORT
    position 3;
 
revoke all
    on table REQUEST_SEGMENT_02_VW
    from PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table RE_ASSIGNMENT
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table RE_ASSIGNMENT
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table RE_ASSIGNMENT
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table RE_ASSIGNMENT
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table "SCHEDULE"
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, UPDATE, SHOW
    on table "SCHEDULE"
    to DISP_SUPPORT
    position 2;
 
grant
    SELECT, SHOW
    on table "SCHEDULE"
    to PUBLIC
    position 3;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SCHEDULE_EVENT
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table SCHEDULE_EVENT
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table SCHEDULE_EVENT
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table SCHEDULE_EVENT
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SCHEDULE_EVENT_01_VW
    to [EMS,CLIFTON]
    position 1;
 
revoke all
    on table SCHEDULE_EVENT_01_VW
    from PUBLIC
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SCHEDULE_EVENT_02_VW
    to [EMS,CLIFTON]
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table SCHEDULE_EVENT_02_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table SCHEDULE_EVENT_02_VW
    to DISP_SUPPORT
    position 3;
 
revoke all
    on table SCHEDULE_EVENT_02_VW
    from PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SCHEDULE_EVENT_03_VW
    to [EMS,CLIFTON]
    position 1;
 
grant
    SELECT, INSERT, DELETE, SHOW
    on table SCHEDULE_EVENT_03_VW
    to DISPATCH
    position 2;
 
revoke all
    on table SCHEDULE_EVENT_03_VW
    from PUBLIC
    position 3;
 
grant
    SELECT, INSERT, DELETE, SHOW
    on table SCHEDULE_EVENT_03_VW
    to DISP_SUPPORT
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SELEVALREQ2_VW
    to [EMS,MCQUEEN]
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table SELEVALREQ2_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table SELEVALREQ2_VW
    to DISP_SUPPORT
    position 3;
 
revoke all
    on table SELEVALREQ2_VW
    from PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SELEVALREQ_VW
    to [EMS,MCQUEEN]
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table SELEVALREQ_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table SELEVALREQ_VW
    to DISP_SUPPORT
    position 3;
 
revoke all
    on table SELEVALREQ_VW
    from PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SELEVALREQ_VW_3
    to [EMS,MCQUEEN]
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table SELEVALREQ_VW_3
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table SELEVALREQ_VW_3
    to DISP_SUPPORT
    position 3;
 
revoke all
    on table SELEVALREQ_VW_3
    from PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SERVICE
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table SERVICE
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table SERVICE
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table SERVICE
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SERVICE_POINT
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table SERVICE_POINT
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table SERVICE_POINT
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table SERVICE_POINT
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SOURCE_SINK
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table SOURCE_SINK
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table SOURCE_SINK
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table SOURCE_SINK
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SP_TYPE
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table SP_TYPE
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table SP_TYPE
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table SP_TYPE
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SRC_SNK_TYPE
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table SRC_SNK_TYPE
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table SRC_SNK_TYPE
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table SRC_SNK_TYPE
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table "STATUS"
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table "STATUS"
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table "STATUS"
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table "STATUS"
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table STATUS_OF_PATH
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table STATUS_OF_PATH
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table STATUS_OF_PATH
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table STATUS_OF_PATH
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table STATUS_OF_RECORD
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table STATUS_OF_RECORD
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table STATUS_OF_RECORD
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table STATUS_OF_RECORD
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table SUMMARY_TYPE
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table SUMMARY_TYPE
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table SUMMARY_TYPE
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table SUMMARY_TYPE
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TCP
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table TCP
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table TCP
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table TCP
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TCP_ICHG
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table TCP_ICHG
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table TCP_ICHG
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table TCP_ICHG
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TIMEZONE_REFERENCE
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table TIMEZONE_REFERENCE
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table TIMEZONE_REFERENCE
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table TIMEZONE_REFERENCE
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TOP
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table TOP
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table TOP
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table TOP
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TOP_ICHG
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table TOP_ICHG
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table TOP_ICHG
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table TOP_ICHG
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TRANSFER_LOSS_REQUEST
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANSFER_LOSS_REQUEST
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANSFER_LOSS_REQUEST
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table TRANSFER_LOSS_REQUEST
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TRANSMISSION_CAPABILITY
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANSMISSION_CAPABILITY
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANSMISSION_CAPABILITY
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table TRANSMISSION_CAPABILITY
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TRANSMISSION_CAPABILITY_01_VW
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANSMISSION_CAPABILITY_01_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANSMISSION_CAPABILITY_01_VW
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table TRANSMISSION_CAPABILITY_01_VW
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TRANSMISSION_CAPABILITY_UNLOAD
    to [EMS,METZD]
    position 1;
 
revoke all
    on table TRANSMISSION_CAPABILITY_UNLOAD
    from PUBLIC
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TRANSMISSION_REQUEST
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANSMISSION_REQUEST
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANSMISSION_REQUEST
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table TRANSMISSION_REQUEST
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TRANSMISSION_REQUEST_01_VW
    to [EMS,CLIFTON]
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANSMISSION_REQUEST_01_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANSMISSION_REQUEST_01_VW
    to DISP_SUPPORT
    position 3;
 
revoke all
    on table TRANSMISSION_REQUEST_01_VW
    from PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TRANS_DURATION_TYPE
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table TRANS_DURATION_TYPE
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table TRANS_DURATION_TYPE
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table TRANS_DURATION_TYPE
    to PUBLIC
    position 4;
 
grant
    SELECT, SHOW
    on table TRANS_EVAL_CONFIRM_VW
    to PUBLIC
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANS_EVAL_CONFIRM_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANS_EVAL_CONFIRM_VW
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TRANS_EVAL_CONFIRM_VW_2
    to [EMS,MCQUEEN]
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANS_EVAL_CONFIRM_VW_2
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANS_EVAL_CONFIRM_VW_2
    to DISP_SUPPORT
    position 3;
 
revoke all
    on table TRANS_EVAL_CONFIRM_VW_2
    from PUBLIC
    position 4;
 
grant
    SELECT, SHOW
    on table TRANS_EVAL_FILE_VW
    to PUBLIC
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANS_EVAL_FILE_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANS_EVAL_FILE_VW
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TRANS_EVAL_VW
    to [EMS,MCQUEEN]
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANS_EVAL_VW
    to DISPATCH
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANS_EVAL_VW
    to DISP_SUPPORT
    position 3;
 
revoke all
    on table TRANS_EVAL_VW
    from PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TRANS_ICHG_RT_HH
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANS_ICHG_RT_HH
    to SOFT_SUPPORT
    position 2;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANS_ICHG_RT_HH
    to DISPATCH
    position 3;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW
    on table TRANS_ICHG_RT_HH
    to IPT_SUPPORT
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TRANS_ICHG_RT_HH
    to [EMS,METZD]
    position 5;
 
grant
    SELECT, SHOW
    on table TRANS_ICHG_RT_HH
    to PUBLIC
    position 6;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TRANS_REQUEST_STATUS
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table TRANS_REQUEST_STATUS
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table TRANS_REQUEST_STATUS
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table TRANS_REQUEST_STATUS
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table TSIN_USER
    to EAS_ADMIN
    position 1;
 
grant
    SELECT, SHOW
    on table TSIN_USER
    to DISPATCH
    position 2;
 
grant
    SELECT, SHOW
    on table TSIN_USER
    to DISP_SUPPORT
    position 3;
 
grant
    SELECT, SHOW
    on table TSIN_USER
    to PUBLIC
    position 4;
 
grant
    SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE, ALTER, DROP, DBCTRL, 
    REFERENCES
    on table UNLOAD_TRANS_CAPABILITY
    to [EMS,METZD]
    position 1;
 
revoke all
    on table UNLOAD_TRANS_CAPABILITY
    from PUBLIC
    position 2;
 
commit work;


---- End of Message ----

	Hi Renee,

	How did the customer create their .SQL file? Could be a problem with the
	RMU extract utility. Thanks for investigating this.

	I'm looking into this problem for you. So far, my testing indicates 
	that the part of the join statements like:

COMPANY as C6 on (C5.COMPANY_ID = C6.COMPANY_ID) on (C1.CUSTOMER = C5.USER_ID)

	are failing with a syntax error both when you use their .SQL file
	in SQL to create the database and in Expert when I try to import the
	logical schema. When I remove the part of the statements from the 
	second ON to the end of the line it works.

	Can you check with someone in the SQL group to see if two ONs is 
	valid syntax? 

	Also I noticed that both SQL and Expert are unable to successfully
	create storage maps which specify the use of storage area 
	OASIS_STORAGE_AREA since it does not exist.  

	Thanks,
	Sheri

Thanks Sheri!  

>	How did the customer create their .SQL file? Could be a problem with the
>	RMU extract utility. Thanks for investigating this.

I sent the customer mail, I'll let you know.


>	are failing with a syntax error both when you use their .SQL file
>	in SQL to create the database and in Expert when I try to import the
>	logical schema. When I remove the part of the statements from the 
>	second ON to the end of the line it works.

I'm so embarrassed!  I never thought to try running the SQL script in SQL!!
Sorry!  Well, lessons we learn now will never be forgotten! :)

>	Can you check with someone in the SQL group to see if two ONs is 
>	valid syntax? 

I'll look into it, but if SQL squawks interactively, bet it isn't valid.
I will check into it tonight.

>	Also I noticed that both SQL and Expert are unable to successfully
>	create storage maps which specify the use of storage area 
>	OASIS_STORAGE_AREA since it does not exist.  

I'll keep this one on the back burner until I find out how she created
the .SQL file.

Thanks again and I'll let you know!

Renee