TWACS Table Names
TNS 2.9
Click here for the mobile version
ADVSRCHPARMS ADVSRCHPARMSDEF ADVSRCHVECTORS
ADVSRCHVECTORSDEF ALERTMESSAGES ALTERNATEPATHBUILD
ALTIMUSCMDCONFIG ALTIMUSCMDCONFIG_20160308 ALTIMUSCMDPARAM
ALTIMUSCMDPARAM_20151123 ALTIMUSCMDPARAM_20160308 ALTIMUSCMDSUMMARY
ALTIMUSCMDSUMMARY_20160308 ALTIMUSTYPE ALTPMAP
ALTSUB AMRBILLTYPE AMRCALENDAR
AMRCALENDAR_BKUP AMRCLASSTYPE AMRCMDLST
AMRCMDLST2WAY AMRCMDLSTMIT AMRCMDLSTMITDATA
AMRCMDLSTMITFORMRETRY AMRCMDLSTMODE9 AMRCMDLSTMODE9BUILD1
AMRCMDLSTRETRY AMRCOLUMNS AMRCOMMFAIL
AMRDATETIMEFORMAT AMRFAILBILL AMRFILEFORMAT
AMRFILELOOKUP AMRFORBILL AMRHOURLYDATA
AMRHOURLYDATA_BAD AMRINTERVALDATA15 AMRINTERVALDATA30
AMRJOBDATA AMRJOBSUMMARY AMRLORPADTYPE
AMRMESSAGES AMRPADDING AMRQUALITYCODE
AMRREADIND AMRREADINDAUX AMRREADTYPE
AMRSECONDSETID AMRTEMPLATE AMRTOBILL
AMRTOBILLFAIL AMRTYPE AMRUSAGE
ANSITABLE APIIN APIOUT
APMGRPSRCH APMSCHEDGRPSRCH APMTEMPSTOR
APMTRANSLOG BATCH_INPQ BATPRETIQ
BFUCMDPARAM BILLWINDOWPRIORITY BINNINGKWH
BINNINGKWHXREF BINNINGXREF BITMAPXREF
BKUP_OPTIMUM_OBJECT_REFERENCE BUS CANT_USE_GROUPS
CFGFEATURE_CONTROL CFGFEATURE_CONTROL_XREF CFGJOBSTATUS
CFGJOBTYPE CFGSTATEXREF CHASETXREF
CISTIQ CITYSUB CITYSUBXREF
CMDHNDLR_INPQ CMTCMDCONFIG CMTCMDPARAM
CMTCMDSUMMARY CMTTYPE COMMERCIALMETERREGID
COMMFRONTEND CONFIGSVR_INPQ CONFIGTYPE
CONFIG_CHANNEL_DATA CONFIG_CHANNEL_DATA_20151123 CONFIG_CHANNEL_DATA_20160308
CONFIG_CMDLST CONFIG_JOB CONMON_INPQ
CONNECTIONPROFILES CSRHISTORY CSTACCTS
CSTCOMMSTATUSXREF CSTCONTROLSTATEXREF CSTJOB
CSTJOBTYPEXREF CSTLST CSTRESPONSELOG
CYCLEBILLWINDOW DASVR_INPQ DATATYPE
DATATYPECIM DATATYPEMULTISPEAK DCSI_JOB_INTERVALS
DCSI_JOB_QUEUE DCSI_JOB_QUEUE_STATUS DCSI_SCHED_ERR_LOG
DECOCMD DECOPARM DECOTITLE
DELHRLYGRPS DEMANDRESETHISTORY DEMINTERVAL
DETECTXREF DEVICELOCXREF DEVICERELATIONS
DEVICERELATIONXREF DEVICETYPES DFW_APPLY_RCES
DFW_APPLY_SET DFW_DC_STATES DFW_DOWNLOAD_CYCLE
DFW_OUTSTANDING_CMDS DFW_PACKETS DFW_QUERY_PARAMS
DFW_REQUESTED_PACKETS DFW_SCEFAILED_PACKETS DFW_SUB_DOWNLOAD_STATUS
DISASTERRECOVERYBUILD DRR_INPQ DRUCMDLST
DRUCMDLST2WAY DRUJOB DRU_CLP_HISTORY
DRU_CURR_CONFIG DRU_INPQ DRU_KNOWN_PROFILE
DRU_LCSTATUS_HISTORY DRU_LC_HISTORY DRU_PROFILE_HISTORY
DRU_PROFWGT_HISTORY DRU_SHORTCYCLELIM_HISTORY DRU_UVUFSTATUS_HISTORY
DRU_UVUF_HISTORY DSTXREF ECTR_INPQ
ECT_INPQ EMPLOYEE ENCOCMD
ENCODFLT ENCOPARM ENCOTITLE
ENVIRONMENTALLOG ENVIRONMENTLIMIT ENVIRONMENTLIMITDESC
EQUIPMENT EQUIPOPERSTATTEXTXREF EQUIPTEXTXREF
ERR_CORR_COUNT EXCEPTIONLOG EXCHANGEXREF
EXECSQLSVR_INPQ EXTRAREGIDREADS EXT_OUTAGE_MONITOR
EXT_OUTAGE_MONITOR_JOBS EXT_OUTAGE_STATE FEATURESET_NAMEDCFGXREF
FEATURESUBSET FEEDER FIELDFORMATS
FORMRETRYMITALTPATH FORMRETRYMITMODE9 FORMRETRYMITMODE9BUILD1
FUNCGRPPRIORITY FUNC_PRI_DESCR GENCMDR_INPQ
GENERIC_INPQ GENMAINTLOG GPTLOGTYPEXREF
GPTRUNSTATUSXREF GPTR_INPQ GPT_INPQ
GPT_LOG GPT_RUN GRAPHINTERVALDATA15
GRAPHINTERVALDATA30 GRP_SUBID_BLKS GYRBOX_DIAGNOSTIC_COUNTER
HANP_INPQ HOURLY2 HOURLYCONV
HOURLYGROUPINGS HOURLYGROUP_INPQ HRLYGRPS
IHDACCTS IHDMESSAGES IHDMODEXREF
IHDRSP_INPQ IHDSVR_INPQ INBCOMMOPTIONS
INCMD INTERFACETYPE INTERVALCMDPARAM
INTERVALDATARESP INTERVALDECOCMD INTERVALDECOPARM
INTERVALMEDIA_INPQ INTERVAL_CONV INTERVAL_CONV_221
INTERVAL_CONV_221_20151123 INTERVAL_CONV_221_20160308 INTERVAL_CONV_BACKUP
INTERVAL_SRC_REG INTERVAL_SRC_REG_20151123 INTERVAL_SRC_REG_20160308
IPUMAP LCACCTS LCCLASS
LCJOB_CALENDAR LCJOB_CMDLIST LCJOB_DEF
LCLOG LCRESET LCRSVR_INPQ
LCSTATUS LCSVR_INPQ LMSC_ACTIVATION_LOG
LMSC_INPQ LPCMDSUMMARY LPCONFIG
LPSCALOR MANUALCMDDATA MANUALCMDDATA2WAY
MANUALCMD_INPQ METERACCTS METERACCTSDEMAND
METERACCTSILS METERACCTSMIT METERACCTSMITLP
METERACCTSTC METERCFGACCTS METERCFGHISTORY
METERCONALTSTRATLOOKUP METERCONSUMPALARMS METERCONSUMPALARMS_TEMP
METERCONSUMPSTRATEGIES METERCONSUMPSUMMARY METERCONV
METERDEMANDRESPONSELOG METERINGQCSTATUS METERINTERVALINIT
METERMITRESPONSELOG METERMITRESPONSELOGDATA METERPM
METERPRIORITY METERRATECLASS METERSHIFTSCH
METERTCRESPONSELOG METERXREF METER_BLINK_COUNTS
METER_INPQ METER_LOCATIONS METER_NOMINAL_VOLTAGE
METER_VOLTAGE_READINGS METRSP_INPQ MITCMDPARAM
MITCMDSUMMARY MITLPSUPPORT MITRDBUFFCONFIG
MITTYPE MITUPLOADCONFIG MSGSVRCATEGORIES
MSGSVRFROMADDR MSGSVRPROTOCOLS MSGSVRRECIP
MSGSVRSEVERITIES MSGSVRTOADDR MSGSVR_INPQ
MSGSVR_INPQ_HOLD MSGXREF MSPEAKBILLCYCLERSLV
MSPEAKCONFIG MSPEAKINTERFACES MSPEAKINTERFACES_BACKUP
MSPEAKLOG MSPEAKONDEMANDREADS MSPEAKOUTAGEDETECTION
NAMEDCFG NOTDEFXREF NOTIFICATIONS
OASYS_ALARMS ODECLLS ODMARM_INPQ
ODMARM_INPQ_20140605 OMUMAP OMUPARMS
ONEWAYASSIGNMENT OPTIMUM_ANALOGCONDITION OPTIMUM_APPLICATIONPOINT
OPTIMUM_APPLPOINT_SUBSTATIONS OPTIMUM_CD_STATE_CHANGES OPTIMUM_CUSTOMER_INFO
OPTIMUM_DISCONNECTED_METER OPTIMUM_METER_DEFAULTS OPTIMUM_METER_INFO
OPTIMUM_OBJECT_REFERENCE OPTIMUM_PLANNED_OUTAGE OPTIMUM_QUALITY
OPTIMUM_SCADA_ANALOG OPTIMUM_SERVICELOCATION_INFO OPTIMUM_USAGE_MONITORING
OPTIMUM_VOLTAGE_READS ORIGINATORXREF OUTAGE_COUNTS
OUTAGE_DETAIL_CAPABILITIES OUTAGE_DETAIL_CAPS_XREF OUTAGE_DETAIL_FORMAT_XREF
OUTAGE_INTJOB_XREF OUTAGE_RANGES OUTAGE_SUMMARY
OUTCMD OUTDET_JOBDEFS OUTDET_JOBNAMES
OUTDET_JOBS OUTDET_JOB_PARAMS OUTDET_JOB_STATUS_DEFS
OUTDET_LOG OUTDET_STATUS_DEFS PATHHRLYGRPS
PHASECONV PHASEXREF PLANNED_OUTAGES
PREPAYTYPE PROCESSTYPE PRODFEATUREXREF
PRODTYPE_CAPS PRODUCT PRODUCTCFGDEFAULTS
PRODUCTPORT PRODUCTTYPEMODXREF PROD_RCDTYPE_XREF
PROT_DEVICE_NETWORK QUALITYCODECATEGORY QUERY_COLUMNS
RCDCFGDISPLAY RCDCFGPARAM RCDCMDCONFIG
RCDCMDSUMMARY RCDFEATURESET RCDTYPE
RCEDFW_CONTROLQ RCEDFW_INPQ RCETYPE
RCE_FW_INFO RCE_SUPPORTED_OPCODES RDRS_INPQ
REASON RECEIVERXREF RECORDTYPE
RELATEDDEVICEUPDATE RESPONSESTATUSXREF RFDIAGINDHISTORY
RIDSVR_INPQ RPA SBF
SCEDLFW SCEDLFWLOG SCEDLFWSTATUSXREF
SCEDL_INPQ SCEEXT SCEMAIN
SCEMAINT_INPQ SCEMRSP_INPQ SCHCHECK
SDCACTIONSHISTORY SDCALARMS SDCCOMMANDXREF
SDCDELAY SDCDESIRED SDCHISTORY
SDCMETERSTATUS SDCPENDING SDCPENDINGACTIONS
SDCPENDINGACTIONS_BACKUP SDCPENDINGCMDS SDCPENDINGCMDS_BACKUP
SDCREASONS SDCRESPONSEXREF SDCSCHEDULEDXREF
SDCSTATUS SDC_CMDSEQ SDC_DSI_SCHEDULE_RESET
SDC_INPQ SDC_READ_REGISTERS SEARCHHISTORY
SEARCHTHRESHOLD SECURITYRIGHTS SECURITYROLERIGHTS
SECURITYROLES SECURITYUSERROLES SECURITYUSERS
SERIALIZATION SERIALNUMBER SERIALPORT
SERIALPORTREF SERVICETYPE SIGNALXREF
SNAPSHOTLOG SNHRLYGRPS SNPATHHIST
SNPATHHIST_20140610 SPCOMMENTS STATUSDESC
STRATEGIES STRAT_LCCMDS STRAT_LCCMD_DEFS
SUBADCCPSECONDVAR SUBADCCPTHIRDVAR SUBCMDQSTATUS
SUBDIAGDATAXREF SUBDIAGERRCAUSEXREF SUBDIAGERRSTATUSXREF
SUBDIAGNOSTICLOG SUBDIAGTESTXREF SUBHDWVERSIONXREF
SUBLOG SUBMODELCONFKTXTXREF SUBMODELCONFKXREF
SUBPROCSTATUSXREF SUBPRODUCT SUBRESPONSEDATA
SUBSTATETEXTXREF SUBSTATION_LOCATIONS SUBSYSTEM
SVCSCAN_INPQ SVCSCAN_VAL_NAMES SYSMONDEFAULTS
SYSRESPONSEDATA SYSTEM_REFRESH TCLR_INPQ
TCTBATCHSTOR TCTBATCHSTOR2WAY TCTPINGBATCHSTOR
TCTPINGBATCHSTOR2WAY TCTPINGRESPLOG TCTPINGTEMPSTOR
TCTPINGTEMPSTOR2WAY TCTRESPLOG TCTR_INPQ
TCTTEMPSTOR TCTTEMPSTOR2WAY TCTVOLTBATCHSTOR
TCTVOLTBATCHSTOR2WAY TCTVOLTRESPLOG TCTVOLTTEMPSTOR
TCTVOLTTEMPSTOR2WAY TCT_INPQ TEMPCITYSRCH
TEMPCSTACCTS TEMPDEVICERELATIONS TEMPGRAPH
TEMPIEDASSIGN TEMPINTERVALINITRETRY TEMPLCACCTS
TEMPMETERACCTS TEMPMETERPM TEMPMETER_NOMINAL_VOLTAGE
TEMPONEWAYASSIGNMENT TEMPSDCDESIRED TEMPSDCSTATUS
TEMPSERIALNUMBER TEMPSERIALPORT TEMPSERIALPORTREF
TEMPSPCOMMENTS TEMP_AMRCMDLST TEMP_AMRCMDLST2WAY
TEMP_AMRCMDLSTMIT TEMP_AMRCMDLSTMITDATA TEMP_AMRCMDLSTRETRY
TEMP_DCSI_JOB_INTERVALS TEMP_DCSI_JOB_QUEUE TEMP_INCMD
TEMP_METERINGQCSTATUS TEMP_METER_LOCATIONS TEMP_METRSP_INPQ
TEMP_ODMARM_INPQ TEMP_OUTCMD TEMP_RIDSVR_INPQ
TEMP_SDCALARMS TEMP_TNSERRORLOG TIMESLICEPARMS
TNSDEFAULTS TNSERRORLOG TNSEXTINTFIN
TNSEXTINTFOUT TNSINFO TNSROLES
TNSUSERROLES TOU_INPQ TOU_OUTPUT
TRAFFICMONCYCLE TRAFFICMONDATA TRAFFICMONJOB
TRAFFICMON_INPQ TRAFFICMON_JOBSTATUS TRANSACTIONTYPE
TRANSFORMER_LOCATIONS TRBDETAIL TRBDETAILBACKUP
TRBHDRXREF TRBHDRXREF_BACKUP TRBHISTORY
TRBINIT TRBMASK TRBMASK_BACKUP
TRBRSVR_INPQ TRBSVR_INPQ TWFUNC
TWFUNCGRP TWFUNCGRPDET TWFUNCXREF
TWMAINT_BLOCKS TWMAINT_COMPATFUNCS TWMAINT_COMPATIDREF
TWMAINT_INPQ TWMAINT_RESULTS TWMAINT_SLOTS
TWREASSIGN TWRSVR_INPQ TWSETIDXREF
TWSVR_INPQ UNITS UNSACTYLOG
UTILACCTS UTILUSERACCESS UTILUSERACCTS
UTILUSERNOTIF VISITS VOLTMONPRODUCT

Table: DATATYPECIM
Field name Null Type Description
DATATYPEID N NUMBER(22)
CIMVER N VARCHAR2(10)
CIM01 Y NUMBER(22)
CIM02 Y NUMBER(22)
CIM03 Y NUMBER(22)
CIM04 Y NUMBER(22)
CIM05 Y NUMBER(22)
CIM06 Y NUMBER(22)
CIM07 Y NUMBER(22)
CIM08 Y NUMBER(22)
CIM09 Y NUMBER(22)
CIM10 Y NUMBER(22)
CIM11 Y NUMBER(22)
CIM12 Y NUMBER(22)
CIM13 Y NUMBER(22)
CIM14 Y NUMBER(22)
CIM15 Y NUMBER(22)
CIM16 Y NUMBER(22)
CIM17 Y NUMBER(22)
CIM18 Y NUMBER(22)

Table: DATATYPEMULTISPEAK
Field name Null Type Description
DATATYPEID N NUMBER(22)
MULTISPEAKVER N VARCHAR2(10)
MULTISPEAKID Y VARCHAR2(40)
UNITSID Y NUMBER(22)

Table: TNSERRORLOG
Field name Null Type Description
DATETIME Y DATE(7)
SUBSYSID Y NUMBER(22)
EXCEPTIONTYPEID Y NUMBER(22)
EXCEPTIONID Y NUMBER(22)
INFORMATIONDATA Y VARCHAR2(255)

Table: INTERVAL_SRC_REG_20160308
Field name Null Type Description
TYPE Y NUMBER(22)
DATASOURCEID Y NUMBER(22)
UOM Y VARCHAR2(12)
QUANTITYDESC Y VARCHAR2(48)
CONVQUANTITYDESC Y VARCHAR2(48)
DATASOURCEID_FORMAT Y NUMBER(22)
DATATYPEID60 Y NUMBER(22)
DATATYPEID30 Y NUMBER(22)
DATATYPEID15 Y NUMBER(22)
CONVID Y NUMBER(22)
MULTIPLIER Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y NUMBER(22)

Table: CONFIG_CHANNEL_DATA_20160308
Field name Null Type Description
METERCLASS Y NUMBER(22)
CHANNELREG Y NUMBER(22)
CHANNELNUM Y NUMBER(22)
SAMPLERATE Y NUMBER(22)
ACTIVEFLAG N VARCHAR2(2)
SIGNBIT Y NUMBER(22)
DATAORDER Y NUMBER(22)
STORAGELEN Y NUMBER(22)
SCALEFACTOR Y NUMBER(22)
FORMAT Y NUMBER(22)
MODECALC Y NUMBER(22)
DATASOURCEID Y NUMBER(22)
PADBITS Y NUMBER(22)

Table: INTERVAL_CONV_221_20160308
Field name Null Type Description
TYPE Y NUMBER(22)
MODEL Y NUMBER(22)
FIRMWARE Y NUMBER(22)
UOM Y VARCHAR2(12)
SCALEFACTOR Y NUMBER(22)
UTILACCTID Y NUMBER(22)
KN Y NUMBER(22)
MULTIPLIER Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y CHAR(1)

Table: ALTIMUSCMDSUMMARY_20160308
Field name Null Type Description
ALTIMUSTYPEID Y NUMBER(22)
BILLTYPE Y NUMBER(22)
BILLTYPEDESC Y VARCHAR2(10)
NUMBERRDREGCMD Y NUMBER(22)
NUMBERMAPREGCMD Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)

Table: ALTIMUSCMDCONFIG_20160308
Field name Null Type Description
ALTIMUSTYPEID Y NUMBER(22)
BILLTYPE Y NUMBER(22)
BILLTYPEDESC Y VARCHAR2(10)
RDREGCMDSEQNUM Y NUMBER(22)
RDREGCMDLENGTH Y NUMBER(22)
RDREGCMDSEQDELAY Y NUMBER(22)
RDREGCMDSEQRETRY Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)

Table: ALTIMUSCMDPARAM_20160308
Field name Null Type Description
ALTIMUSTYPEID Y NUMBER(22)
BILLTYPE Y NUMBER(22)
BILLTYPEDESC Y VARCHAR2(10)
MAPREGISTERID Y NUMBER(22)
DATAREGISTERID Y NUMBER(22)
DAILYSHIFTREGISTERID Y NUMBER(22)
DATANAMEID Y NUMBER(22)
DATASHORTNAME Y VARCHAR2(8)
DATANAME Y VARCHAR2(30)
DATAADDRESS Y RAW(9)
DATALENGTH Y NUMBER(22)
DATADECOFMT Y NUMBER(22)
DATADPLOC Y NUMBER(22)
DATASELECT Y NUMBER(22)
RDREGSEQ Y NUMBER(22)
MAPREGSEQ Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)
DATATYPEID Y NUMBER(22)
CONVID Y NUMBER(22)
MULTIPLIER Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y NUMBER(22)

Table: INTERVAL_SRC_REG_20151123
Field name Null Type Description
TYPE Y NUMBER(22)
DATASOURCEID Y NUMBER(22)
UOM Y VARCHAR2(12)
QUANTITYDESC Y VARCHAR2(48)
CONVQUANTITYDESC Y VARCHAR2(48)
DATASOURCEID_FORMAT Y NUMBER(22)
DATATYPEID60 Y NUMBER(22)
DATATYPEID30 Y NUMBER(22)
DATATYPEID15 Y NUMBER(22)
CONVID Y NUMBER(22)
MULTIPLIER Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y NUMBER(22)

Table: CONFIG_CHANNEL_DATA_20151123
Field name Null Type Description
METERCLASS Y NUMBER(22)
CHANNELREG Y NUMBER(22)
CHANNELNUM Y NUMBER(22)
SAMPLERATE Y NUMBER(22)
ACTIVEFLAG N VARCHAR2(2)
SIGNBIT Y NUMBER(22)
DATAORDER Y NUMBER(22)
STORAGELEN Y NUMBER(22)
SCALEFACTOR Y NUMBER(22)
FORMAT Y NUMBER(22)
MODECALC Y NUMBER(22)
DATASOURCEID Y NUMBER(22)
PADBITS Y NUMBER(22)

Table: INTERVAL_CONV_221_20151123
Field name Null Type Description
TYPE Y NUMBER(22)
MODEL Y NUMBER(22)
FIRMWARE Y NUMBER(22)
UOM Y VARCHAR2(12)
SCALEFACTOR Y NUMBER(22)
UTILACCTID Y NUMBER(22)
KN Y NUMBER(22)
MULTIPLIER Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y CHAR(1)

Table: ALTIMUSCMDPARAM_20151123
Field name Null Type Description
ALTIMUSTYPEID Y NUMBER(22)
BILLTYPE Y NUMBER(22)
BILLTYPEDESC Y VARCHAR2(10)
MAPREGISTERID Y NUMBER(22)
DATAREGISTERID Y NUMBER(22)
DAILYSHIFTREGISTERID Y NUMBER(22)
DATANAMEID Y NUMBER(22)
DATASHORTNAME Y VARCHAR2(8)
DATANAME Y VARCHAR2(30)
DATAADDRESS Y RAW(9)
DATALENGTH Y NUMBER(22)
DATADECOFMT Y NUMBER(22)
DATADPLOC Y NUMBER(22)
DATASELECT Y NUMBER(22)
RDREGSEQ Y NUMBER(22)
MAPREGSEQ Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)
DATATYPEID Y NUMBER(22)
CONVID Y NUMBER(22)
MULTIPLIER Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y NUMBER(22)

Table: SUBLOG
Field name Null Type Description
TIME_STAMP Y DATE(7)
SUBID Y NUMBER(22)
OLDSUBSTATUS Y NUMBER(22)
OLDSUBSTATE Y NUMBER(22)
NEWSUBSTATUS Y NUMBER(22)
NEWSUBSTATE Y NUMBER(22)

Table: SYSMONDEFAULTS
Field name Null Type Description
SYSMONDEFAULTNAME N VARCHAR2(30)
SYSMONDEFAULTDESC Y VARCHAR2(60)
SYSMONDEFAULTVAL1 N NUMBER(22)
SYSMONDEFAULTTXT1 N VARCHAR2(40)
TRLOGPATH Y VARCHAR2(40)

Table: RCE_SUPPORTED_OPCODES
Field name Null Type Description
PRODUCTTYPE Y NUMBER(22)
PRODUCTMODEL Y NUMBER(22)
OP_221 Y NUMBER(22)
OP_158 Y NUMBER(22)
OP_157 Y NUMBER(22)
OP_92 Y NUMBER(22)
OP_91 Y NUMBER(22)
OP_90 Y NUMBER(22)
OP_89 Y NUMBER(22)
OP_62 Y NUMBER(22)

Table: AMRBILLTYPE
Field name Null Type Description
BILLTYPE N NUMBER(22)
AMRREADIND Y NUMBER(22)
BILLTYPEDESC Y VARCHAR2(10)

Table: SDCDELAY
Field name Null Type Description
TYPE N NUMBER(22)
STATUSUPDTDELAY Y NUMBER(22)

Table: TEMPMETERPM
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
BOXID Y VARCHAR2(8)
SLOT_NUMBER Y NUMBER(22)
TRANSFORMER_METER Y VARCHAR2(1)
POLY_PHASE Y VARCHAR2(1)

Table: METERPM
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
BOXID Y VARCHAR2(8)
SLOT_NUMBER Y NUMBER(22)
TRANSFORMER_METER Y VARCHAR2(1)
POLY_PHASE Y VARCHAR2(1)

Table: SCEEXT
Field name Null Type Description
SUBID N NUMBER(22)
CHANNELSET Y NUMBER(22)
CHANNELMAP Y NUMBER(22)
INBOUNDCURRENT Y NUMBER(22)
SUPPORT_T20 Y NUMBER(22)
NUM_CONCURRENT_FEEDER Y NUMBER(22)

Table: FORMRETRYMITMODE9BUILD1
Field name Null Type Description
UTILACCTID N NUMBER(22)
AMRCALJOBNO N NUMBER(22)
AMRMIT Y NUMBER(22)
AMRPORT N NUMBER(22)
SUBID N NUMBER(22)
PHASE N NUMBER(22)
SIGNAL N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
DETECTION N NUMBER(22)
TWFUNC N NUMBER(22)
TWGRP N NUMBER(22)
TWUNITMAP1 Y NUMBER(22)
TWUNITMAP2 Y NUMBER(22)
TWUNITMAP3 Y NUMBER(22)
TWUNITMAP4 Y NUMBER(22)
TWUNITMAP5 Y NUMBER(22)
TWUNITMAP6 Y NUMBER(22)
TWUNITMAP7 Y NUMBER(22)
TWUNITMAP8 Y NUMBER(22)
TWUNITMAP9 Y NUMBER(22)
TWUNITMAP10 Y NUMBER(22)
TWUNITMAP11 Y NUMBER(22)
TWUNITMAP12 Y NUMBER(22)
TWUNITMAP13 Y NUMBER(22)
TWUNITMAP14 Y NUMBER(22)
TWUNITMAP15 Y NUMBER(22)
TWUNITMAP16 Y NUMBER(22)
TWUNITMAP17 Y NUMBER(22)
TWUNITMAP18 Y NUMBER(22)
TWUNITMAP19 Y NUMBER(22)
TWUNITMAP20 Y NUMBER(22)
TWUNITMAP21 Y NUMBER(22)
TWUNITMAP22 Y NUMBER(22)
TWUNITMAP23 Y NUMBER(22)
TWUNITMAP24 Y NUMBER(22)
TWUNITMAP25 Y NUMBER(22)
TWUNITMAP26 Y NUMBER(22)
TWUNITMAP27 Y NUMBER(22)
TWUNITMAP28 Y NUMBER(22)
TWUNITMAP29 Y NUMBER(22)
TWUNITMAP30 Y NUMBER(22)
TWUNITMAP31 Y NUMBER(22)
TWUNITMAP32 Y NUMBER(22)
METER_RATE_CLASS Y VARCHAR2(9)
TYPE Y NUMBER(22)
AMRREADIND Y NUMBER(22)
USERID N NUMBER(22)
SEQNO N NUMBER(22)
DELAYSEQ Y NUMBER(22)

Table: FORMRETRYMITMODE9
Field name Null Type Description
OUTBOUNDCMDID Y NUMBER(22)
UTILACCTID N NUMBER(22)
AMRCALJOBNO N NUMBER(22)
AMRMIT Y NUMBER(22)
AMRPORT N NUMBER(22)
SUBID N NUMBER(22)
PHASE N NUMBER(22)
SIGNAL N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
DETECTION N NUMBER(22)
TWFUNC N NUMBER(22)
TWGRP N NUMBER(22)
GROUPSIZE N NUMBER(22)
GROUPBASE N NUMBER(22)
TWUNITMAP1 Y NUMBER(22)
TWUNITMAP2 Y NUMBER(22)
TWUNITMAP3 Y NUMBER(22)
TWUNITMAP4 Y NUMBER(22)
TWUNITMAP5 Y NUMBER(22)
TWUNITMAP6 Y NUMBER(22)
TWUNITMAP7 Y NUMBER(22)
TWUNITMAP8 Y NUMBER(22)
METER_RATE_CLASS Y VARCHAR2(9)
TYPE Y NUMBER(22)
AMRREADIND Y NUMBER(22)
USERID N NUMBER(22)
SEQNO N NUMBER(22)
DELAYSEQ Y NUMBER(22)

Table: FORMRETRYMITALTPATH
Field name Null Type Description
USERID Y NUMBER(22)
UTILACCTID Y NUMBER(22)
AMRCALJOBNO N NUMBER(22)
READIND Y NUMBER(22)
SERIALPORT N NUMBER(22)
FUNCTION N NUMBER(22)
MITGROUP N NUMBER(22)
SEQNO N NUMBER(22)
TWUNITMAP1 Y NUMBER(22)
TWUNITMAP2 Y NUMBER(22)
TWUNITMAP3 Y NUMBER(22)
TWUNITMAP4 Y NUMBER(22)
TWUNITMAP5 Y NUMBER(22)
TWUNITMAP6 Y NUMBER(22)
TWUNITMAP7 Y NUMBER(22)
TWUNITMAP8 Y NUMBER(22)
TWUNITMAP9 Y NUMBER(22)
TWUNITMAP10 Y NUMBER(22)
TWUNITMAP11 Y NUMBER(22)
TWUNITMAP12 Y NUMBER(22)
TWUNITMAP13 Y NUMBER(22)
TWUNITMAP14 Y NUMBER(22)
TWUNITMAP15 Y NUMBER(22)
TWUNITMAP16 Y NUMBER(22)
TWUNITMAP17 Y NUMBER(22)
TWUNITMAP18 Y NUMBER(22)
TWUNITMAP19 Y NUMBER(22)
TWUNITMAP20 Y NUMBER(22)
TWUNITMAP21 Y NUMBER(22)
TWUNITMAP22 Y NUMBER(22)
TWUNITMAP23 Y NUMBER(22)
TWUNITMAP24 Y NUMBER(22)
TWUNITMAP25 Y NUMBER(22)
TWUNITMAP26 Y NUMBER(22)
TWUNITMAP27 Y NUMBER(22)
TWUNITMAP28 Y NUMBER(22)
TWUNITMAP29 Y NUMBER(22)
TWUNITMAP30 Y NUMBER(22)
TWUNITMAP31 Y NUMBER(22)
TWUNITMAP32 Y NUMBER(22)
SUBID N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
PHASE N NUMBER(22)
SIGNAL N NUMBER(22)
DETECTION N NUMBER(22)
DELAYSEQ Y NUMBER(22)

Table: AMRCMDLSTMODE9BUILD1
Field name Null Type Description
UTILACCTID N NUMBER(22)
AMRCALJOBNO N NUMBER(22)
AMRMIT N NUMBER(22)
AMRPORT N NUMBER(22)
SUBID N NUMBER(22)
PHASE N NUMBER(22)
SIGNAL N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
DETECTION N NUMBER(22)
TWFUNC N NUMBER(22)
TWGRP N NUMBER(22)
TWUNITMAP1 Y NUMBER(22)
TWUNITMAP2 Y NUMBER(22)
TWUNITMAP3 Y NUMBER(22)
TWUNITMAP4 Y NUMBER(22)
TWUNITMAP5 Y NUMBER(22)
TWUNITMAP6 Y NUMBER(22)
TWUNITMAP7 Y NUMBER(22)
TWUNITMAP8 Y NUMBER(22)
TWUNITMAP9 Y NUMBER(22)
TWUNITMAP10 Y NUMBER(22)
TWUNITMAP11 Y NUMBER(22)
TWUNITMAP12 Y NUMBER(22)
TWUNITMAP13 Y NUMBER(22)
TWUNITMAP14 Y NUMBER(22)
TWUNITMAP15 Y NUMBER(22)
TWUNITMAP16 Y NUMBER(22)
TWUNITMAP17 Y NUMBER(22)
TWUNITMAP18 Y NUMBER(22)
TWUNITMAP19 Y NUMBER(22)
TWUNITMAP20 Y NUMBER(22)
TWUNITMAP21 Y NUMBER(22)
TWUNITMAP22 Y NUMBER(22)
TWUNITMAP23 Y NUMBER(22)
TWUNITMAP24 Y NUMBER(22)
TWUNITMAP25 Y NUMBER(22)
TWUNITMAP26 Y NUMBER(22)
TWUNITMAP27 Y NUMBER(22)
TWUNITMAP28 Y NUMBER(22)
TWUNITMAP29 Y NUMBER(22)
TWUNITMAP30 Y NUMBER(22)
TWUNITMAP31 Y NUMBER(22)
TWUNITMAP32 Y NUMBER(22)
METER_RATE_CLASS Y VARCHAR2(9)
TYPE Y NUMBER(22)

Table: AMRCMDLSTMODE9
Field name Null Type Description
OUTBOUNDCMDID Y NUMBER(22)
UTILACCTID N NUMBER(22)
AMRCALJOBNO N NUMBER(22)
AMRMIT N NUMBER(22)
AMRPORT N NUMBER(22)
SUBID N NUMBER(22)
PHASE N NUMBER(22)
SIGNAL N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
DETECTION N NUMBER(22)
TWFUNC N NUMBER(22)
TWGRP N NUMBER(22)
GROUPSIZE N NUMBER(22)
GROUPBASE N NUMBER(22)
TWUNITMAP1 Y NUMBER(22)
TWUNITMAP2 Y NUMBER(22)
TWUNITMAP3 Y NUMBER(22)
TWUNITMAP4 Y NUMBER(22)
TWUNITMAP5 Y NUMBER(22)
TWUNITMAP6 Y NUMBER(22)
TWUNITMAP7 Y NUMBER(22)
TWUNITMAP8 Y NUMBER(22)
METER_RATE_CLASS Y VARCHAR2(9)
TYPE Y NUMBER(22)

Table: DRR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
PRI Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
EXTYPE Y NUMBER(22)

Table: VOLTMONPRODUCT
Field name Null Type Description
PRODUCTTYPE N NUMBER(22)
PRODUCTMODEL N NUMBER(22)
PRODUCTNAME Y VARCHAR2(25)
UTILACCTID Y NUMBER(22)
PRODUCTMEMADDR Y NUMBER(22)
VOLTAGE_REGISTER Y NUMBER(22)
FM Y NUMBER(22)
FB Y NUMBER(22)
NOMINAL_VOLTAGE Y NUMBER(22)
NUM_PHASES Y NUMBER(22)
VOLTAGE_REGISTER_2 Y NUMBER(22)
VOLTAGE_REGISTER_3 Y NUMBER(22)
REGISTER_LENG Y NUMBER(22)
DECODE_FORMAT Y NUMBER(22)
INVALID_VOLTAGE_VALUE Y NUMBER(22)

Table: VISITS
Field name Null Type Description
ID N NUMBER(22)
SUBSTATION Y VARCHAR2(50)
EMPLOYEE Y VARCHAR2(50)
REASON Y VARCHAR2(50)
NOTE Y VARCHAR2(50)
TIMEENTERED Y DATE(7)
TIMELEFT Y DATE(7)

Table: UTILUSERNOTIF
Field name Null Type Description
UTILACCTID Y NUMBER(22)
UTILUSERNAME Y VARCHAR2(32)
UTILUSERNOTIFTYPE Y VARCHAR2(10)
UTILUSERNOTIFPIN Y NUMBER(22)
UTILUSERNOTIFEXT Y NUMBER(22)
UTILUSERNOTIFMETHODID Y VARCHAR2(60)

Table: UTILUSERACCTS
Field name Null Type Description
UTILACCTID Y NUMBER(22)
UTILUSERNAME N VARCHAR2(32)
UTILUSERFULLNAME Y VARCHAR2(32)
UTILUSERDESC Y VARCHAR2(20)
UTILUSERADDRESS Y VARCHAR2(32)
UTILUSERADDRESS1 Y VARCHAR2(32)
UTILUSERCITY Y VARCHAR2(15)
UTILUSERSTATE Y VARCHAR2(25)
UTILUSERPOSTALCODE Y VARCHAR2(10)
UTILUSERCOUNTRY Y VARCHAR2(15)
UTILUSERROLE Y VARCHAR2(32)
UTILUSERDIR Y VARCHAR2(80)

Table: UTILUSERACCESS
Field name Null Type Description
UTILACCTID Y NUMBER(22)
UTILUSERNAME Y VARCHAR2(32)
UTILUSERACCESSAPP Y VARCHAR2(32)
UTILUSERACCESSROLE Y VARCHAR2(32)

Table: UTILACCTS
Field name Null Type Description
UTILACCT Y VARCHAR2(20)
UTILACCTID Y NUMBER(22)
UTILNAME Y VARCHAR2(32)
UTILADDRESS Y VARCHAR2(32)
UTILADDRESS1 Y VARCHAR2(32)
UTILCITY Y VARCHAR2(15)
UTILSTATE Y VARCHAR2(25)
UTILPOSTALCODE Y VARCHAR2(10)
UTILCOUNTRY Y VARCHAR2(15)
UTILUSERNAME Y VARCHAR2(32)
UTILFILEXFER Y VARCHAR2(10)
UTILACCESSTYPE Y VARCHAR2(10)
UTILXFERPROTOCOL Y VARCHAR2(20)
UTILDIR1 Y VARCHAR2(80)
UTILDIR2 Y VARCHAR2(80)
UTILACCTLOGO Y VARCHAR2(80)

Table: UNSACTYLOG
Field name Null Type Description
DATETIME Y DATE(7)
USERNAME Y VARCHAR2(32)
SUBID N NUMBER(22)
SUBNAME Y VARCHAR2(25)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
DATEEXECUTED Y DATE(7)
ORIGINATORTYPEID Y NUMBER(22)
ORIGINATORTYPE Y VARCHAR2(6)
ORIGINATORID Y NUMBER(22)
EXCHANGETYPEID Y NUMBER(22)
EXCHANGETYPE Y VARCHAR2(6)
EXCHANGEID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
PRI Y NUMBER(22)
PREVEXCHANGEID Y NUMBER(22)
NEXTEXCHANGEID Y NUMBER(22)
EXECUTIONSTATUS Y NUMBER(22)

Table: UNITS
Field name Null Type Description
UNITSID N NUMBER(22)
UNITS N VARCHAR2(40)
UNITSDESC Y VARCHAR2(80)

Table: TWSVR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: TWSETIDXREF
Field name Null Type Description
SETID N VARCHAR2(32)
TABLE_NAME Y VARCHAR2(32)
COLUMN_NAME Y VARCHAR2(32)
HOLDFLAG Y NUMBER(22)

Table: TWRSVR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: TWREASSIGN
Field name Null Type Description
ORIGFUNC Y NUMBER(22)
ORIGGRP Y NUMBER(22)
ORIGUNIT Y NUMBER(22)
DESTFUNC Y NUMBER(22)
DESTGRP Y NUMBER(22)
DESTUNIT Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
REGISTER Y NUMBER(22)
STATUS Y NUMBER(22)

Table: TWMAINT_SLOTS
Field name Null Type Description
ID N NUMBER(22)
BLKID Y NUMBER(22)
SLOTNUM Y NUMBER(22)
TWUNIT Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
TWREG Y NUMBER(22)
TWSTATUS Y NUMBER(22)
MOVEBLKID Y NUMBER(22)
MOVESLTID Y NUMBER(22)
MOVEDIR Y NUMBER(22)
DBFLAG Y NUMBER(22)

Table: TWMAINT_RESULTS
Field name Null Type Description
FUNCCOMPATID Y NUMBER(22)
BLKCOMPATID Y NUMBER(22)
NUMSLOTSMOVED Y NUMBER(22)
SSNTIMESAVED Y NUMBER(22)
GRPTIMESAVED Y NUMBER(22)
REASSIGNTIME Y NUMBER(22)

Table: TWMAINT_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: TWMAINT_COMPATIDREF
Field name Null Type Description
FUNCCOMPATID Y NUMBER(22)
BLKCOMPATID Y NUMBER(22)
BLKSIZE Y NUMBER(22)
SUBID Y NUMBER(22)
STATUS Y VARCHAR2(32)
STATUSDATE Y DATE(7)

Table: TWMAINT_COMPATFUNCS
Field name Null Type Description
FUNCCOMPATID Y NUMBER(22)
TWFUNCSTART Y NUMBER(22)
TWFUNCEND Y NUMBER(22)

Table: TWMAINT_BLOCKS
Field name Null Type Description
ID N NUMBER(22)
BLKCOMPATID Y NUMBER(22)
BLKSIZE Y NUMBER(22)
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
BASE Y NUMBER(22)
FREESLOTS Y NUMBER(22)
ORIGFREESLOTS Y NUMBER(22)

Table: TWFUNCXREF
Field name Null Type Description
TRANSACTIONTYPEID N NUMBER(22)
TWFUNC N NUMBER(22)
TWNXTGRPNO N NUMBER(22)

Table: TWFUNCGRPDET
Field name Null Type Description
TWFUNC N NUMBER(22)
TWGRP N NUMBER(22)
TWUNIT N NUMBER(22)
SERIALNUMBER N NUMBER(22)
TWREG Y NUMBER(22)
TWSTATUS Y NUMBER(22)
TWSTATUSDT Y DATE(7)
RESPONSESTATUSDT Y DATE(7)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
RESPONSESTATUSRCE Y NUMBER(22)

Table: TWFUNCGRP
Field name Null Type Description
TWFUNC N NUMBER(22)
TWGRP N NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)
TYPE Y NUMBER(22)
MODEL Y NUMBER(22)
PROTECTIVEDEVICE Y VARCHAR2(13)
SETID Y VARCHAR2(32)
SETVALUE Y VARCHAR2(80)
TWNXTUNIT Y NUMBER(22)
TWDATE Y DATE(7)
TWFUNCGRPPRIVATE Y NUMBER(22)

Table: TWFUNC
Field name Null Type Description
TWASGNORDER N NUMBER(22)
TWGENERIC Y NUMBER(22)
TWAPPLID Y VARCHAR2(8)
TWFUNCSTART N NUMBER(22)
TWFUNCEND N NUMBER(22)
TWFUNCDESC Y VARCHAR2(50)
SETID Y VARCHAR2(32)
SETVALUE Y VARCHAR2(80)
TWMARKDEL Y NUMBER(22)
TWFUNCPRIVATE Y NUMBER(22)

Table: TRBSVR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: TRBRSVR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: TRBMASK_BACKUP
Field name Null Type Description
PRODUCTTYPE Y NUMBER(22)
PRODUCTMODEL Y NUMBER(22)
MASKREGID Y NUMBER(22)
MASKREGNAME Y VARCHAR2(12)
MASKBIT Y NUMBER(22)
MASKBITDESC Y VARCHAR2(12)
MASKPORT Y NUMBER(22)
MASKREVROT Y NUMBER(22)
MASKONOFF Y NUMBER(22)

Table: TRBMASK
Field name Null Type Description
PRODUCTTYPE Y NUMBER(22)
PRODUCTMODEL Y NUMBER(22)
MASKREGID Y NUMBER(22)
MASKREGNAME Y VARCHAR2(12)
MASKBIT Y NUMBER(22)
MASKBITDESC Y VARCHAR2(12)
MASKPORT Y NUMBER(22)
MASKREVROT Y NUMBER(22)
MASKONOFF Y NUMBER(22)

Table: TRBINIT
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
UTILACCTID N NUMBER(22)
TRBINITREPORTDATETIME Y DATE(7)
TRBINITPROCSTATUS Y NUMBER(22)
TRBINITPROCDATETIME Y DATE(7)
TRBINITPROCTNSSTATUS Y NUMBER(22)
TRBINITPROCSCESTATUS Y NUMBER(22)
TRBINITPROCRCESTATUS Y NUMBER(22)

Table: TRBHISTORY
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
UTILACCTID Y NUMBER(22)
TRBFLAG Y VARCHAR2(12)
TRBBIT Y NUMBER(22)
TRBBITDESC Y VARCHAR2(12)
TRBREPORTDATETIME Y DATE(7)
TRBREVERSEROTATION Y NUMBER(22)
TRBRESETDATETIME Y DATE(7)

Table: TRBHDRXREF_BACKUP
Field name Null Type Description
PRODUCTTYPE Y NUMBER(22)
PRODUCTMODEL Y NUMBER(22)
TROUBLEFLAG1 Y NUMBER(22)
TROUBLEFLAGDESC1 Y VARCHAR2(32)
TROUBLEFLAG2 Y NUMBER(22)
TROUBLEFLAGDESC2 Y VARCHAR2(32)
TROUBLEFLAG3 Y NUMBER(22)
TROUBLEFLAGDESC3 Y VARCHAR2(32)
TROUBLEFLAG4 Y NUMBER(22)
TROUBLEFLAGDESC4 Y VARCHAR2(32)

Table: TRBHDRXREF
Field name Null Type Description
PRODUCTTYPE Y NUMBER(22)
PRODUCTMODEL Y NUMBER(22)
TROUBLEFLAG1 Y NUMBER(22)
TROUBLEFLAGDESC1 Y VARCHAR2(32)
TROUBLEFLAG2 Y NUMBER(22)
TROUBLEFLAGDESC2 Y VARCHAR2(32)
TROUBLEFLAG3 Y NUMBER(22)
TROUBLEFLAGDESC3 Y VARCHAR2(32)
TROUBLEFLAG4 Y NUMBER(22)
TROUBLEFLAGDESC4 Y VARCHAR2(32)

Table: TRBDETAILBACKUP
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
UTILACCTID Y NUMBER(22)
TRBFLAGID Y NUMBER(22)
TRBFLAG Y VARCHAR2(12)
TRBBIT Y NUMBER(22)
TRBBITDESC Y VARCHAR2(12)
TRBREVERSEROTATION Y NUMBER(22)
TRBREPORTDATETIME Y DATE(7)
TRBPROCSTATUS Y NUMBER(22)
TRBPROCDATETIME Y DATE(7)
TRBREPORTCOUNT Y NUMBER(22)
TRBCMDID Y NUMBER(22)
TRBRESET Y NUMBER(22)
TRBRESETDATETIME Y DATE(7)
TRBPROCTNSSTATUS Y NUMBER(22)
TRBPROCSCESTATUS Y NUMBER(22)
TRBPROCRCESTATUS Y NUMBER(22)

Table: TRBDETAIL
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT Y NUMBER(22)
UTILACCTID N NUMBER(22)
TRBFLAGID N NUMBER(22)
TRBFLAG Y VARCHAR2(12)
TRBBIT N NUMBER(22)
TRBBITDESC Y VARCHAR2(12)
TRBREVERSEROTATION Y NUMBER(22)
TRBREPORTDATETIME Y DATE(7)
TRBPROCSTATUS Y NUMBER(22)
TRBPROCDATETIME Y DATE(7)
TRBREPORTCOUNT Y NUMBER(22)
TRBCMDID Y NUMBER(22)
TRBRESET Y NUMBER(22)
TRBRESETDATETIME Y DATE(7)
TRBPROCTNSSTATUS Y NUMBER(22)
TRBPROCSCESTATUS Y NUMBER(22)
TRBPROCRCESTATUS Y NUMBER(22)

Table: TRANSFORMER_LOCATIONS
Contains the X and Y coordinates of transformers indexed by the transformer grid stored in the SERIALNUMBER table
Field name Null Type Description
TRANSFORMERGRID N VARCHAR2(13)
MAP_LOC_X Y FLOAT(22)
MAP_LOC_Y Y FLOAT(22)

Table: TRANSACTIONTYPE
Field name Null Type Description
TRANSACTIONTYPE N VARCHAR2(8)
TRANSACTIONTYPEID N NUMBER(22)

Table: TRAFFICMON_JOBSTATUS
Field name Null Type Description
JOBID N NUMBER(22)
START_TIME Y DATE(7)
STOP_TIME Y DATE(7)
TIME_STARTED Y DATE(7)
TIME_STOPPED Y DATE(7)
DAILY Y NUMBER(22)
STATUS Y NUMBER(22)

Table: TRAFFICMON_INPQ
Field name Null Type Description
ID N NUMBER(22)
STAMP N DATE(7)
CMD N NUMBER(22)
JOBID N NUMBER(22)
FREQ Y NUMBER(22)
DESCRIPTION Y VARCHAR2(100)
STOP_TIME Y DATE(7)
START_TIME Y DATE(7)
DAILY Y NUMBER(22)

Table: TRAFFICMONJOB
Field name Null Type Description
JOBID N NUMBER(22)
DESCRIP Y VARCHAR2(100)
COLLECTFREQ N NUMBER(22)
USERNAME N VARCHAR2(32)
ORACLEUSER N VARCHAR2(32)

Table: TRAFFICMONDATA
Field name Null Type Description
JOBID N NUMBER(22)
CYCLE N NUMBER(22)
SUBID N NUMBER(22)
PRIORITY Y NUMBER(22)
FUNCCODE Y NUMBER(22)
STATE Y NUMBER(22)
ADDRMODE Y CHAR(2)
RCOUNT N NUMBER(22)

Table: TRAFFICMONCYCLE
Field name Null Type Description
JOBID N NUMBER(22)
CYCLE N NUMBER(22)
CYCLETIME N DATE(7)
QUERY_TIME Y NUMBER(22)

Table: TOU_OUTPUT
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
STATUS Y VARCHAR2(10)
MAP Y VARCHAR2(8)
RETRIES Y NUMBER(22)
START_TIME Y DATE(7)
STOP_TIME Y DATE(7)
FILE_PATH Y VARCHAR2(250)
STATUS_DETAIL Y VARCHAR2(250)
TOTAL_COMMANDS Y NUMBER(22)
CHECK_SUM Y NUMBER(22)
NUM_RETRIES Y NUMBER(22)

Table: TOU_INPQ
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
STATUS_TNS Y NUMBER(22)
STATUS_RCE Y NUMBER(22)
STATUS_SCE Y NUMBER(22)
FUNCCODE Y NUMBER(22)
RETURNDATA Y VARCHAR2(15)

Table: TNSUSERROLES
Field name Null Type Description
SUBSYSID N NUMBER(22)
DB_USERNAME N VARCHAR2(32)
ROLE_ID Y NUMBER(22)

Table: TNSROLES
Field name Null Type Description
ROLE_ID N NUMBER(22)
ROLE_NAME N VARCHAR2(10)
ROLE_DESCRIPTION N VARCHAR2(25)

Table: TNSINFO
Field name Null Type Description
DATA Y VARCHAR2(255)
TIMESTAMP Y DATE(7)

Table: TNSEXTINTFOUT
Field name Null Type Description
CSSID Y NUMBER(22)
UNIQUENO Y NUMBER(22)
UTILACCTID Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
READTYPE Y NUMBER(22)
READIND Y NUMBER(22)
KWH Y NUMBER(22)
KW Y NUMBER(22)
ONPEAKKWH Y NUMBER(22)
OFFPEAKKWH Y NUMBER(22)
ONPEAKKW Y NUMBER(22)
OFFPEAKKW Y NUMBER(22)
READDT Y DATE(7)
QUALITYCODE Y NUMBER(22)
RESETCNT Y NUMBER(22)
BLINKCNT Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)

Table: TNSEXTINTFIN
Field name Null Type Description
CSSID Y NUMBER(22)
UNIQUENO Y NUMBER(22)
UTILACCTID Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
READTYPE Y NUMBER(22)
READIND Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)

Table: TNSDEFAULTS
Field name Null Type Description
TNSFUNCID Y NUMBER(22)
TNSFUNCNAME Y VARCHAR2(32)
SUBSYSID Y NUMBER(22)
TNSDEFAULTID Y NUMBER(22)
TNSDEFAULTNAME Y VARCHAR2(32)
TNSDEFAULTVAL1 Y NUMBER(22)
TNSDEFAULTTXT1 Y VARCHAR2(32)

Table: TIMESLICEPARMS
Field name Null Type Description
SUBID N NUMBER(22)
BUSID N NUMBER(22)
STARTHOUR Y NUMBER(22)
STOPHOUR Y NUMBER(22)
WINSPAN Y NUMBER(22)
INITDELAY Y NUMBER(22)
ACTCOMM Y NUMBER(22)
REPCNT Y NUMBER(22)
ACTCOMMVOID Y NUMBER(22)

Table: TEMP_TNSERRORLOG
Field name Null Type Description
DATETIME Y DATE(7)
SUBSYSID Y NUMBER(22)
EXCEPTIONTYPEID Y NUMBER(22)
EXCEPTIONID Y NUMBER(22)
INFORMATIONDATA Y VARCHAR2(255)

Table: TEMP_SDCALARMS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
ALARM_START_TIME N DATE(7)
LAST_ALARM_TIME N DATE(7)
ACKNOWLEDGED N CHAR(1)
ACKNOWLEDGE_TIME Y DATE(7)
ALARM_FLAG Y NUMBER(22)

Table: TEMP_RIDSVR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: TEMP_OUTCMD
Field name Null Type Description
MSEXID N NUMBER(22)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
SUBID Y NUMBER(22)
SUBEXID Y NUMBER(22)
PRIORITY Y NUMBER(22)
EXCHANGETYPEID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
STATE Y NUMBER(22)
DELTA Y NUMBER(22)
STAMP Y DATE(7)
TMOUT Y DATE(7)
REFCNT Y NUMBER(22)
COMMLINETYPE Y NUMBER(22)
SUBDROPID Y NUMBER(22)
COMMID Y NUMBER(22)
SUBCOMMBD Y NUMBER(22)
SUBCOMMPORT Y NUMBER(22)
CCEHDR Y RAW(33)
TRNSHDR Y RAW(49)
TRNSBUF1 Y RAW(255)
TRNSBUF2 Y RAW(255)
TRNSBUF3 Y RAW(255)
TRNSBUF4 Y RAW(255)
TRNSBUF5 Y RAW(255)
TRNSBUF6 Y RAW(255)
TRNSBUF7 Y RAW(255)
TRNSBUF8 Y RAW(255)

Table: TEMP_ODMARM_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: TEMP_METRSP_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: TEMP_METER_LOCATIONS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
MAP_LOC_X Y FLOAT(22)
MAP_LOC_Y Y FLOAT(22)

Table: TEMP_METERINGQCSTATUS
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
TWFUNC Y NUMBER(22)
TWGROUP Y NUMBER(22)
TWUNIT Y NUMBER(22)
SERIALPORT N NUMBER(22)
READDATE N DATE(7)
UTILACCTID N NUMBER(22)
QUALITYCODE N NUMBER(22)
AMRREADIND N NUMBER(22)
AMRCALJOBNO N NUMBER(22)
MSEXCHANGEID Y NUMBER(22)
CMDLSTSETID Y VARCHAR2(32)
CMDLSTSETVALUE Y VARCHAR2(32)
AMRMIT Y NUMBER(22)

Table: TEMP_INCMD
Field name Null Type Description
MSEXID N NUMBER(22)
SUBID Y NUMBER(22)
SUBEXID Y NUMBER(22)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
REFCNT Y NUMBER(22)
TRNSHDR Y RAW(49)
TRNSBUF1 Y RAW(255)
TRNSBUF2 Y RAW(255)
TRNSBUF3 Y RAW(255)
TRNSBUF4 Y RAW(255)
TRNSBUF5 Y RAW(255)
TRNSBUF6 Y RAW(255)
TRNSBUF7 Y RAW(255)
TRNSBUF8 Y RAW(255)

Table: TEMP_DCSI_JOB_QUEUE
Field name Null Type Description
JOBNO Y NUMBER(22)
JOBDESC Y VARCHAR2(255)
NXT_RUN_DATE N DATE(7)
STATUS N VARCHAR2(12)
SCHED_USER_ID1 Y NUMBER(22)
SCHED_USER_ID2 Y NUMBER(22)
COMMAND N VARCHAR2(255)

Table: TEMP_DCSI_JOB_INTERVALS
Field name Null Type Description
JOBNO Y NUMBER(22)
CREATE_DATE Y DATE(7)
START_DATE Y DATE(7)
STOP_DATE Y DATE(7)
CREATE_ID Y NUMBER(22)
RETURN_ID Y NUMBER(22)
REPEAT_UNIT Y VARCHAR2(3)
REPEAT_INTERVAL Y NUMBER(22)
DELAY_FLAG Y NUMBER(22)
MONDAY Y NUMBER(22)
TUESDAY Y NUMBER(22)
WEDNESDAY Y NUMBER(22)
THURSDAY Y NUMBER(22)
FRIDAY Y NUMBER(22)
SATURDAY Y NUMBER(22)
SUNDAY Y NUMBER(22)

Table: TEMP_AMRCMDLSTRETRY
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
CMDLST2WAYFUNCTION N NUMBER(22)
CMDLST2WAYGROUP N NUMBER(22)
UTILACCTID N NUMBER(22)
USERNAME Y VARCHAR2(32)
CMDLSTMSEXID Y NUMBER(22)
METERMITREADTYPE Y NUMBER(22)
METERMITREADIND Y NUMBER(22)
METERMITCMDTYPE Y NUMBER(22)
AMRCALJOBNO N NUMBER(22)
METERMITSEQNO N NUMBER(22)
METERMITQUALITYCODE Y NUMBER(22)
CMDLST2WAYGROUPSIZE Y NUMBER(22)
CMDLST2WAYGROUPBASE Y NUMBER(22)
CMDLST2WAYUNITMAP1 Y NUMBER(22)
CMDLST2WAYUNITMAP2 Y NUMBER(22)
CMDLST2WAYUNITMAP3 Y NUMBER(22)
CMDLST2WAYUNITMAP4 Y NUMBER(22)
CMDLST2WAYUNITMAP5 Y NUMBER(22)
CMDLST2WAYUNITMAP6 Y NUMBER(22)
CMDLST2WAYUNITMAP7 Y NUMBER(22)
CMDLST2WAYUNITMAP8 Y NUMBER(22)
CMDLST2WAYUNITMAP9 Y NUMBER(22)
CMDLST2WAYUNITMAP10 Y NUMBER(22)
CMDLST2WAYUNITMAP11 Y NUMBER(22)
CMDLST2WAYUNITMAP12 Y NUMBER(22)
CMDLST2WAYUNITMAP13 Y NUMBER(22)
CMDLST2WAYUNITMAP14 Y NUMBER(22)
CMDLST2WAYUNITMAP15 Y NUMBER(22)
CMDLST2WAYUNITMAP16 Y NUMBER(22)
CMDLST2WAYUNITMAP17 Y NUMBER(22)
CMDLST2WAYUNITMAP18 Y NUMBER(22)
CMDLST2WAYUNITMAP19 Y NUMBER(22)
CMDLST2WAYUNITMAP20 Y NUMBER(22)
CMDLST2WAYUNITMAP21 Y NUMBER(22)
CMDLST2WAYUNITMAP22 Y NUMBER(22)
CMDLST2WAYUNITMAP23 Y NUMBER(22)
CMDLST2WAYUNITMAP24 Y NUMBER(22)
CMDLST2WAYUNITMAP25 Y NUMBER(22)
CMDLST2WAYUNITMAP26 Y NUMBER(22)
CMDLST2WAYUNITMAP27 Y NUMBER(22)
CMDLST2WAYUNITMAP28 Y NUMBER(22)
CMDLST2WAYUNITMAP29 Y NUMBER(22)
CMDLST2WAYUNITMAP30 Y NUMBER(22)
CMDLST2WAYUNITMAP31 Y NUMBER(22)
CMDLST2WAYUNITMAP32 Y NUMBER(22)

Table: TEMP_AMRCMDLSTMITDATA
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
UTILACCTID Y NUMBER(22)
METERMITPRISEC Y NUMBER(22)
METERMITSEQNO Y NUMBER(22)
METERMITREADDT Y DATE(7)
METERMITSTATUSTNS Y NUMBER(22)
METERMITSTATUSSCE Y NUMBER(22)
METERMITSTATUSRCE Y NUMBER(22)
METERMITQUALITYCODE Y NUMBER(22)
METERMITDATA1ID Y NUMBER(22)
METERMITDATA1 Y NUMBER(22)
METERMITDATA2ID Y NUMBER(22)
METERMITDATA2 Y NUMBER(22)
METERMITDATA3ID Y NUMBER(22)
METERMITDATA3 Y NUMBER(22)
METERMITDATA4ID Y NUMBER(22)
METERMITDATA4 Y NUMBER(22)
METERMITDATA5ID Y NUMBER(22)
METERMITDATA5 Y NUMBER(22)
METERMITDATA6ID Y NUMBER(22)
METERMITDATA6 Y NUMBER(22)
METERMITDEMRESETID Y NUMBER(22)
METERMITDEMRESET Y NUMBER(22)
METERMITLPDATA Y VARCHAR2(24)
METERMITQUALITYFLAG1 Y NUMBER(22)
METERMITQUALITYFLAG2 Y NUMBER(22)
METERMITQUALITYFLAG3 Y NUMBER(22)
METERMITQUALITYFLAG4 Y NUMBER(22)
METERMITRETRYCOUNT Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)
METERMITCURRDATETIME Y DATE(7)

Table: TEMP_AMRCMDLSTMIT
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
CMDLST2WAYFUNCTION Y NUMBER(22)
CMDLST2WAYGROUP Y NUMBER(22)
CMDLST2WAYUNIT Y NUMBER(22)
CMDLST2WAYFLAG Y NUMBER(22)
UTILACCTID Y NUMBER(22)
USERNAME Y VARCHAR2(32)
CMDLSTGROUPID Y NUMBER(22)
CMDLSTMSEXID Y NUMBER(22)
CMDLSTADDRMODE Y NUMBER(22)
METERMITREADTYPE Y NUMBER(22)
METERMITREADIND Y NUMBER(22)
METERMITCMDTYPE Y NUMBER(22)
METERMITSTATUSTNS Y NUMBER(22)
METERMITSTATUSSCE Y NUMBER(22)
METERMITSTATUSRCE Y NUMBER(22)
METERMITQUALITYCODE Y NUMBER(22)
MITPRIMARYDONE Y NUMBER(22)
MITSECONDARYDONE Y NUMBER(22)
CMDLSTSOURCE Y NUMBER(22)
CMDLSTHOLD Y NUMBER(22)
CMDLSTRETRYCT Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)
AMRSCHEDJOBNO Y NUMBER(22)
CMDLSTSTARTDT Y DATE(7)
CMDLSTSTOPDT Y DATE(7)
CMDLSTCUTOFFDT Y DATE(7)
CMDLSTSETID Y VARCHAR2(32)
CMDLSTSETVALUE Y VARCHAR2(32)

Table: TEMP_AMRCMDLST2WAY
Field name Null Type Description
UTILACCTID Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)
AMRREADTYPE Y NUMBER(22)
AMRREADIND Y NUMBER(22)
AMRCURPREV Y NUMBER(22)
AMRPORT Y NUMBER(22)
AMRMIT Y NUMBER(22)
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
TWUNITMAPTOTAL Y NUMBER(22)
TWUNITMAP1 Y NUMBER(22)
TWUNITMAP2 Y NUMBER(22)
TWUNITMAP3 Y NUMBER(22)
TWUNITMAP4 Y NUMBER(22)
TWUNITMAP5 Y NUMBER(22)
TWUNITMAP6 Y NUMBER(22)
TWUNITMAP7 Y NUMBER(22)
TWUNITMAP8 Y NUMBER(22)
TWUNITMAP9 Y NUMBER(22)
TWUNITMAP10 Y NUMBER(22)
TWUNITMAP11 Y NUMBER(22)
TWUNITMAP12 Y NUMBER(22)
TWUNITMAP13 Y NUMBER(22)
TWUNITMAP14 Y NUMBER(22)
TWUNITMAP15 Y NUMBER(22)
TWUNITMAP16 Y NUMBER(22)
TWUNITMAP17 Y NUMBER(22)
TWUNITMAP18 Y NUMBER(22)
TWUNITMAP19 Y NUMBER(22)
TWUNITMAP20 Y NUMBER(22)
TWUNITMAP21 Y NUMBER(22)
TWUNITMAP22 Y NUMBER(22)
TWUNITMAP23 Y NUMBER(22)
TWUNITMAP24 Y NUMBER(22)
TWUNITMAP25 Y NUMBER(22)
TWUNITMAP26 Y NUMBER(22)
TWUNITMAP27 Y NUMBER(22)
TWUNITMAP28 Y NUMBER(22)
TWUNITMAP29 Y NUMBER(22)
TWUNITMAP30 Y NUMBER(22)
TWUNITMAP31 Y NUMBER(22)
TWUNITMAP32 Y NUMBER(22)

Table: TEMP_AMRCMDLST
Field name Null Type Description
UTILACCTID Y NUMBER(22)
USERNAME Y VARCHAR2(32)
CMDLSTGROUPID Y NUMBER(22)
CMDLSTMSEXID Y NUMBER(22)
CMDLSTADDRMODE Y NUMBER(22)
CMDLSTREADTYPE Y NUMBER(22)
CMDLSTREADIND Y NUMBER(22)
CMDLSTCURPREV Y NUMBER(22)
CMDLSTSERIALNUMBER Y NUMBER(22)
CMDLSTPORT Y NUMBER(22)
CMDLST2WAYFUNCTION Y NUMBER(22)
CMDLST2WAYGROUP Y NUMBER(22)
CMDLST2WAYUNIT Y NUMBER(22)
CMDLST2WAYFLAG Y NUMBER(22)
CMDLSTCURDATETIME Y DATE(7)
CMDLSTSTATUSTNS Y NUMBER(22)
CMDLSTSTATUSSCE Y NUMBER(22)
CMDLSTSTATUSRCE Y NUMBER(22)
CMDLSTQUALITYCODE Y NUMBER(22)
CMDLSTTOTALCONSUMPT Y NUMBER(22)
CMDLSTUNITS Y NUMBER(22)
CMDLSTREADDT Y DATE(7)
CMDLSTQUALITYFLAG1 Y NUMBER(22)
CMDLSTQUALITYFLAG2 Y NUMBER(22)
CMDLSTQUALITYFLAG3 Y NUMBER(22)
CMDLSTQUALITYFLAG4 Y NUMBER(22)
CMDLSTOFFSETREAD Y NUMBER(22)
CMDLSTSOURCE Y NUMBER(22)
CMDLSTHOLD Y NUMBER(22)
CMDLSTSEQNO Y NUMBER(22)
CMDLSTRETRYCT Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)
AMRSCHEDJOBNO Y NUMBER(22)
CMDLSTSTARTDT Y DATE(7)
CMDLSTSTOPDT Y DATE(7)
CMDLSTCUTOFFDT Y DATE(7)
CMDLSTSETID Y VARCHAR2(32)
CMDLSTSETVALUE Y VARCHAR2(32)

Table: TEMPSPCOMMENTS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
DATE1 N DATE(7)
METERCUSTOMERACCTNUM Y VARCHAR2(21)
METERNUMBER Y VARCHAR2(21)
TEXTREF1 Y VARCHAR2(15)
TESTDESC Y VARCHAR2(255)

Table: TEMPSERIALPORTREF
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
RATECODE Y VARCHAR2(10)
CASECODE Y VARCHAR2(15)
TEXT1 Y VARCHAR2(15)
TEXT2 Y VARCHAR2(15)
TEXT3 Y VARCHAR2(15)
TEXT4 Y VARCHAR2(15)
TEXT5 Y VARCHAR2(15)
DATE1 Y DATE(7)
DATE2 Y DATE(7)
DATE3 Y DATE(7)
DATE4 Y DATE(7)
DATE5 Y DATE(7)
V1 Y NUMBER(22)
V2 Y NUMBER(22)
V3 Y NUMBER(22)
V4 Y NUMBER(22)
V5 Y NUMBER(22)
PREPAYFLAG Y NUMBER(22)
SERVICE_LOCATION Y VARCHAR2(64)
BILLED_DEMAND Y NUMBER(22)

Table: TEMPSERIALPORT
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
PORTPREMISEID Y VARCHAR2(21)
PORTINSTALLDATE Y DATE(7)
PORTMODIFYDATE Y DATE(7)
PORTDISTRICTNUMBER Y NUMBER(22)
PORTDEVICELOC Y VARCHAR2(6)
PORTACTIVEFLAG Y VARCHAR2(2)
PORTDEVICETYPE Y NUMBER(22)
PORTCONNECTTYPE Y VARCHAR2(9)
PORTCONNECTDATE Y DATE(7)
PORTUSER1 Y VARCHAR2(17)
PORTUSER2 Y VARCHAR2(17)

Table: TEMPSERIALNUMBER
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
UTILACCTID Y NUMBER(22)
TRANSACTIONTYPEID Y NUMBER(22)
PREMISEID Y VARCHAR2(21)
SUBNAME Y VARCHAR2(26)
BUSNAME Y VARCHAR2(9)
FEEDERNAME Y VARCHAR2(13)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)
TYPE Y NUMBER(22)
MODEL Y NUMBER(22)
PROTECTIVEDEVICE Y VARCHAR2(13)
TRANSFORMERGRID Y VARCHAR2(13)
INSTALLDATE Y DATE(7)
DISTRICTNUMBER Y NUMBER(22)
DEVICELOC Y VARCHAR2(6)
ACTIVEFLAG Y VARCHAR2(2)
ONEWAY Y VARCHAR2(2)
INPROG Y VARCHAR2(2)
SEARCH Y VARCHAR2(2)
SEARCHOK Y VARCHAR2(2)
DEASSIGN Y VARCHAR2(2)
DEASSIGNOK Y VARCHAR2(2)
RDREG Y VARCHAR2(2)
RDREGOK Y VARCHAR2(2)
COMPLETE Y VARCHAR2(2)
FAILED Y VARCHAR2(2)
LASTGOODCOMMDT Y DATE(7)
LASTTRYCOMMDT Y DATE(7)
BYTECOUNT Y NUMBER(22)
USEDBYTECOUNT Y NUMBER(22)
TOTCOMMFAILCNT Y NUMBER(22)
CONSECCOMMFAILCNT Y NUMBER(22)
COMMTYPE Y VARCHAR2(9)
DEVICETYPE Y NUMBER(22)
CONNECTTYPE Y VARCHAR2(9)
CONNECTDATE Y DATE(7)
USER1 Y VARCHAR2(17)
USER2 Y VARCHAR2(17)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
RESPONSESTATUSRCE Y NUMBER(22)
RESPONSESTATUSREG Y NUMBER(22)

Table: TEMPSDCSTATUS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SWITCHPOSN Y VARCHAR2(15)
TIMEUPDATED Y DATE(7)
LAST_SW_CMD Y VARCHAR2(9)
LASTCMDDATE Y DATE(7)
AUTOOPN Y CHAR(1)
RCDLOCK Y CHAR(1)

Table: TEMPSDCDESIRED
Field name Null Type Description
GROUPID N NUMBER(22)
SERIALNUMBER N NUMBER(22)
DESIREDSWITCHPOSN Y VARCHAR2(15)
TIMEREQUESTED Y DATE(7)
UTILITY_REASONCODE Y VARCHAR2(50)

Table: TEMPONEWAYASSIGNMENT
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
CLASS_NAME N VARCHAR2(9)
X N NUMBER(22)
Y N NUMBER(22)
SUBGROUP N NUMBER(22)
ASSIGN_STATUS Y NUMBER(22)

Table: TEMPMETER_NOMINAL_VOLTAGE
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
NOMINAL_VOLTAGE N NUMBER(22)
NUM_PHASES Y NUMBER(22)

Table: TEMPMETERACCTS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
METERCUSTOMERACCTNUM Y VARCHAR2(21)
METERRATECLASS Y VARCHAR2(9)
METERTYPE Y VARCHAR2(11)
METERNUMBER Y VARCHAR2(21)
METERROUTEID Y VARCHAR2(9)
METERCYCLENUMBER Y NUMBER(22)
METERINITIALREAD Y NUMBER(22)
METEROFFSETREAD Y NUMBER(22)
METEROFFSETRECALC Y NUMBER(22)
METERCLASS Y NUMBER(22)
METERUSER1 Y VARCHAR2(17)
METERUSER2 Y VARCHAR2(17)
METERINITSTATE Y NUMBER(22)
CT Y NUMBER(22)
VT Y NUMBER(22)

Table: TEMPLCACCTS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
LCPREMISEID Y VARCHAR2(21)
LCCLASS Y VARCHAR2(9)
LCX Y NUMBER(22)
LCY Y NUMBER(22)
LCSUBGRP Y NUMBER(22)
LCACTIVEFLAG Y VARCHAR2(2)
LCSTATUS Y NUMBER(22)
LCINIT Y NUMBER(22)
LCUSER1 Y VARCHAR2(17)
LCUSER2 Y VARCHAR2(17)

Table: TEMPINTERVALINITRETRY
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
METERCLASS Y NUMBER(22)

Table: TEMPIEDASSIGN
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
IEDTRANSACTION N VARCHAR2(1)
IEDMETERNUMBER Y NUMBER(22)
IEDCRC Y NUMBER(22)
TNSCRC Y NUMBER(22)
IEDSTATE N NUMBER(22)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
RESPONSESTATUSRCE Y NUMBER(22)
STAMP Y DATE(7)

Table: TEMPGRAPH
Field name Null Type Description
READ_DATE Y VARCHAR2(80)
MINUTE_15_DATA Y NUMBER(22)

Table: TEMPDEVICERELATIONS
Field name Null Type Description
PRISERIALNUMBER N NUMBER(22)
SECSERIALNUMBER N NUMBER(22)
RELATIONTYPE N NUMBER(22)
USER1 Y VARCHAR2(17)
USER2 Y VARCHAR2(17)
UPDATEFLAG Y NUMBER(22)

Table: TEMPCSTACCTS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
CSTDEVICEID Y VARCHAR2(21)
CSTGPSCOORDINATES Y VARCHAR2(21)
CSTCIRCUITCONFIG Y VARCHAR2(9)
CSTSWITCHGEARTYPE Y VARCHAR2(21)
CSTSWITCHGEARMODEL Y VARCHAR2(21)
CSTSWITCHGEARPHASEA Y VARCHAR2(21)
CSTSWITCHGEARPHASEB Y VARCHAR2(21)
CSTSWITCHGEARPHASEC Y VARCHAR2(21)
CSTSWITCHGEARDT Y DATE(7)
CSTKVARPERPHASE Y VARCHAR2(21)
CSTSTATE Y NUMBER(22)
CSTUSER1 Y VARCHAR2(21)
CSTUSER2 Y VARCHAR2(21)
CSTUSER3 Y VARCHAR2(21)
CSTUSER4 Y VARCHAR2(21)
CSTUSER5 Y VARCHAR2(21)

Table: TEMPCITYSRCH
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
CITYNO N NUMBER(22)
SUBID N NUMBER(22)
UTILACCTID N NUMBER(22)

Table: TCT_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: TCTVOLTTEMPSTOR2WAY
Field name Null Type Description
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
TWGRPSIZE Y NUMBER(22)
TWGRPBASE Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)

Table: TCTVOLTTEMPSTOR
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)

Table: TCTVOLTRESPLOG
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
STAMP Y DATE(7)
OUTSUB Y NUMBER(22)
OUTBUS Y NUMBER(22)
OUTFDR Y NUMBER(22)
OUTPHS Y NUMBER(22)
OUTSIG Y NUMBER(22)
OUTDET Y NUMBER(22)
RSTNS Y NUMBER(22)
RSSCE Y NUMBER(22)
RSRCE Y NUMBER(22)
TCTDATA1 Y NUMBER(22)
VOLTFLUCT Y NUMBER(22)
MEMTYPE Y NUMBER(22)
MEMADDR Y NUMBER(22)

Table: TCTVOLTBATCHSTOR2WAY
Field name Null Type Description
BATCHID Y VARCHAR2(24)
CREATE_DT Y DATE(7)
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
TWGRPSIZE Y NUMBER(22)
TWGRPBASE Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)

Table: TCTVOLTBATCHSTOR
Field name Null Type Description
BATCHID Y VARCHAR2(24)
CREATE_DT Y DATE(7)
SERIALNUMBER Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)

Table: TCTTEMPSTOR2WAY
Field name Null Type Description
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
TWGRPSIZE Y NUMBER(22)
TWGRPBASE Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)

Table: TCTTEMPSTOR
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)

Table: TCTR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: TCTRESPLOG
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
STAMP Y DATE(7)
OUTSUB Y NUMBER(22)
OUTBUS Y NUMBER(22)
OUTFDR Y NUMBER(22)
OUTPHS Y NUMBER(22)
OUTSIG Y NUMBER(22)
OUTDET Y NUMBER(22)
RSTNS Y NUMBER(22)
RSSCE Y NUMBER(22)
RSRCE Y NUMBER(22)
TCTDATA1 Y NUMBER(22)
TCTDATA2 Y NUMBER(22)
TCTDATA3 Y NUMBER(22)
TCTDATA4 Y NUMBER(22)
TCTDATA5 Y NUMBER(22)
NRMLSIGSTR Y NUMBER(22)
ACQWINDOW Y NUMBER(22)
ACQRSVD1 Y NUMBER(22)
ACQRSVD2 Y NUMBER(22)
ACQRSVD3 Y NUMBER(22)
BITCORRCNT Y NUMBER(22)

Table: TCTPINGTEMPSTOR2WAY
Field name Null Type Description
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
TWGRPSIZE Y NUMBER(22)
TWGRPBASE Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)

Table: TCTPINGTEMPSTOR
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)

Table: TCTPINGRESPLOG
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
STAMP Y DATE(7)
OUTSUB Y NUMBER(22)
OUTBUS Y NUMBER(22)
OUTFDR Y NUMBER(22)
OUTPHS Y NUMBER(22)
OUTSIG Y NUMBER(22)
OUTDET Y NUMBER(22)
RSTNS Y NUMBER(22)
RSSCE Y NUMBER(22)
RSRCE Y NUMBER(22)

Table: TCTPINGBATCHSTOR2WAY
Field name Null Type Description
BATCHID Y VARCHAR2(24)
CREATE_DT Y DATE(7)
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
TWGRPSIZE Y NUMBER(22)
TWGRPBASE Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)

Table: TCTPINGBATCHSTOR
Field name Null Type Description
BATCHID Y VARCHAR2(24)
CREATE_DT Y DATE(7)
SERIALNUMBER Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)

Table: TCTBATCHSTOR2WAY
Field name Null Type Description
BATCHID Y VARCHAR2(24)
CREATE_DT Y DATE(7)
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
TWGRPSIZE Y NUMBER(22)
TWGRPBASE Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)

Table: TCTBATCHSTOR
Field name Null Type Description
BATCHID Y VARCHAR2(24)
CREATE_DT Y DATE(7)
SERIALNUMBER Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)

Table: TCLR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: SYSTEM_REFRESH
Field name Null Type Description
SYSTEMNAME Y VARCHAR2(20)
REFRESHRATE Y NUMBER(22)
SLEEPRATE Y NUMBER(22)
ROLE Y VARCHAR2(20)

Table: SYSRESPONSEDATA
Field name Null Type Description
SUBSYSTEMID Y NUMBER(22)
DATETIME Y DATE(7)
USERNAME Y VARCHAR2(32)
SUBID N NUMBER(22)
SUBNAME Y VARCHAR2(25)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
EXCHANGETYPEID Y NUMBER(22)
ORIGINATORID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
RESPONSESTATUS Y NUMBER(22)
RESPONSEDATA Y VARCHAR2(255)

Table: SVCSCAN_VAL_NAMES
Field name Null Type Description
ALTIMUSTYPEID N NUMBER(22)
DATAID N NUMBER(22)
VAL_NUMBER N NUMBER(22)
VAL_NAME N VARCHAR2(20)

Table: SVCSCAN_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
CMDDATA Y VARCHAR2(255)

Table: SUBSYSTEM
Field name Null Type Description
SUBSYSTEMID N NUMBER(22)
SUBSYSTEMNAME Y VARCHAR2(32)
SUBSYSTEMINPQ Y VARCHAR2(32)
SUBSYSTEMNAMEDPIPE Y VARCHAR2(32)
SUBSYSTEMCONNECTSTRING Y VARCHAR2(18)
SUBSYSTEMROUTETOID Y NUMBER(22)

Table: SUBSTATION_LOCATIONS
Contains the X and Y coordinates indexed by the substation ID
Field name Null Type Description
SUBID N NUMBER(22)
MAP_LOC_X Y FLOAT(22)
MAP_LOC_Y Y FLOAT(22)

Table: SUBSTATETEXTXREF
Field name Null Type Description
COMMLINETYPE N NUMBER(22)
SUBSTATE N NUMBER(22)
SUBSTATUS N NUMBER(22)
SUBCONNECTSTATETEXT Y VARCHAR2(30)
SUBCONNECTSTATUSTEXT Y VARCHAR2(30)
SUBCOMMTYPETEXT Y VARCHAR2(30)
BITMAPID Y VARCHAR2(20)
TEXTCOLOR Y VARCHAR2(16)

Table: SUBRESPONSEDATA
Field name Null Type Description
DATETIME Y DATE(7)
USERNAME Y VARCHAR2(32)
SUBID N NUMBER(22)
SUBNAME Y VARCHAR2(25)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
EXCHANGETYPEID Y NUMBER(22)
ORIGINATORID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
RESPONSESTATUS Y NUMBER(22)
RESPONSEDATA Y VARCHAR2(255)

Table: SUBPRODUCT
Field name Null Type Description
SUBMODEL N VARCHAR2(5)
PRODUCTTYPE N NUMBER(22)
PRODUCTMODEL N NUMBER(22)
PRODUCTSRCHINITDEL Y NUMBER(22)
PRODUCTSRCHBURSTLIM Y NUMBER(22)
PRODUCTSRCHTHROTDEL Y NUMBER(22)
PRODUCTMSGCAP Y NUMBER(22)
PRODUCTBURSTCAP Y NUMBER(22)
PRODUCTMSGRECRATE Y NUMBER(22)
PRODUCTREPEATINB Y NUMBER(22)
PRODUCTREPEATRETRY Y NUMBER(22)
PRODUCTMULTIBITHAM Y NUMBER(22)
PRODUCTRETRYDELAY Y NUMBER(22)
PRODUCTSRCHMODE Y NUMBER(22)
PRODUCTSRCHTYPE Y NUMBER(22)

Table: SUBPROCSTATUSXREF
Field name Null Type Description
SUBPROCSTATUS Y NUMBER(22)
SUBPROCSTATUSTEXT Y VARCHAR2(50)

Table: SUBMODELCONFKXREF
Field name Null Type Description
SUBMODEL N VARCHAR2(5)
SCK0CHANGE Y CHAR(1)
SCK0ENABLE Y CHAR(1)
SCK1CHANGE Y CHAR(1)
SCK1ENABLE Y CHAR(1)
SCK2CHANGE Y CHAR(1)
SCK2ENABLE Y CHAR(1)
SCK3CHANGE Y CHAR(1)
SCK3ENABLE Y CHAR(1)
SCK4CHANGE Y CHAR(1)
SCK4ENABLE Y CHAR(1)
SCK5CHANGE Y CHAR(1)
SCK5ENABLE Y CHAR(1)
SCK6CHANGE Y CHAR(1)
SCK6ENABLE Y CHAR(1)
SCK7CHANGE Y CHAR(1)
SCK7ENABLE Y CHAR(1)
SCK8CHANGE Y CHAR(1)
SCK8ENABLE Y CHAR(1)
SCK9CHANGE Y CHAR(1)
SCK9ENABLE Y CHAR(1)
SCK10CHANGE Y CHAR(1)
SCK10ENABLE Y CHAR(1)
SCK11CHANGE Y CHAR(1)
SCK11ENABLE Y CHAR(1)
SCK12CHANGE Y CHAR(1)
SCK12ENABLE Y CHAR(1)
SCK13CHANGE Y CHAR(1)
SCK13ENABLE Y CHAR(1)
SCK14CHANGE Y CHAR(1)
SCK14ENABLE Y CHAR(1)
SCK15CHANGE Y CHAR(1)
SCK15ENABLE Y CHAR(1)
SCK16CHANGE Y CHAR(1)
SCK16ENABLE Y CHAR(1)
SCK17CHANGE Y CHAR(1)
SCK17ENABLE Y CHAR(1)
SCK18CHANGE Y CHAR(1)
SCK18ENABLE Y CHAR(1)
SCK19CHANGE Y CHAR(1)
SCK19ENABLE Y CHAR(1)
SCK20CHANGE Y CHAR(1)
SCK20ENABLE Y CHAR(1)
SCK21CHANGE Y CHAR(1)
SCK21ENABLE Y CHAR(1)
SCK22CHANGE Y CHAR(1)
SCK22ENABLE Y CHAR(1)
SCK23CHANGE Y CHAR(1)
SCK23ENABLE Y CHAR(1)
SCK24CHANGE Y CHAR(1)
SCK24ENABLE Y CHAR(1)
SCK25CHANGE Y CHAR(1)
SCK25ENABLE Y CHAR(1)
SCK26CHANGE Y CHAR(1)
SCK26ENABLE Y CHAR(1)
SCK27CHANGE Y CHAR(1)
SCK27ENABLE Y CHAR(1)
SCK28CHANGE Y CHAR(1)
SCK28ENABLE Y CHAR(1)
SCK29CHANGE Y CHAR(1)
SCK29ENABLE Y CHAR(1)
SCK30CHANGE Y CHAR(1)
SCK30ENABLE Y CHAR(1)
SCK31CHANGE Y CHAR(1)
SCK31ENABLE Y CHAR(1)

Table: SUBMODELCONFKTXTXREF
Field name Null Type Description
SUBMODEL N VARCHAR2(5)
SCK0TEXT Y VARCHAR2(25)
SCK1TEXT Y VARCHAR2(25)
SCK2TEXT Y VARCHAR2(25)
SCK3TEXT Y VARCHAR2(25)
SCK4TEXT Y VARCHAR2(25)
SCK5TEXT Y VARCHAR2(25)
SCK6TEXT Y VARCHAR2(25)
SCK7TEXT Y VARCHAR2(25)
SCK8TEXT Y VARCHAR2(25)
SCK9TEXT Y VARCHAR2(25)
SCK10TEXT Y VARCHAR2(25)
SCK11TEXT Y VARCHAR2(25)
SCK12TEXT Y VARCHAR2(25)
SCK13TEXT Y VARCHAR2(25)
SCK14TEXT Y VARCHAR2(25)
SCK15TEXT Y VARCHAR2(25)
SCK16TEXT Y VARCHAR2(25)
SCK17TEXT Y VARCHAR2(25)
SCK18TEXT Y VARCHAR2(25)
SCK19TEXT Y VARCHAR2(25)
SCK20TEXT Y VARCHAR2(25)
SCK21TEXT Y VARCHAR2(25)
SCK22TEXT Y VARCHAR2(25)
SCK23TEXT Y VARCHAR2(25)
SCK24TEXT Y VARCHAR2(25)
SCK25TEXT Y VARCHAR2(25)
SCK26TEXT Y VARCHAR2(25)
SCK27TEXT Y VARCHAR2(25)
SCK28TEXT Y VARCHAR2(25)
SCK29TEXT Y VARCHAR2(25)
SCK30TEXT Y VARCHAR2(25)
SCK31TEXT Y VARCHAR2(25)

Table: SUBHDWVERSIONXREF
Field name Null Type Description
SUBHDWVERSION Y NUMBER(22)
SUBHDWVERSIONTEXT Y VARCHAR2(24)
SUBHDWREVISION Y NUMBER(22)
SUBHDWREVISIONTEXT Y VARCHAR2(24)
SUBHDWTYPETEXT Y VARCHAR2(24)

Table: SUBDIAGTESTXREF
Field name Null Type Description
DIAGTESTID Y NUMBER(22)
DIAGTESTTEXT Y VARCHAR2(32)

Table: SUBDIAGNOSTICLOG
Field name Null Type Description
DATETIME Y DATE(7)
USERNAME Y VARCHAR2(32)
SUBID N NUMBER(22)
SUBNAME Y VARCHAR2(25)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
EQUIPTYPEID Y NUMBER(22)
EQUIPTYPETEXT Y VARCHAR2(8)
EQUIPID Y NUMBER(22)
SUBDIAGTESTID Y NUMBER(22)
SUBDIAGTESTTEXT Y VARCHAR2(20)
SUBDIAGERRSTATE Y NUMBER(22)
SUBDIAGERRSTATETEXT Y VARCHAR2(20)
SUBDIAGERRSOURCE Y NUMBER(22)
SUBDIAGERRSOURCETEXT Y VARCHAR2(20)
SUBDIAGDATA Y VARCHAR2(40)
SUBDIAGDATA1 Y NUMBER(22)
SUBDIAGDATA2 Y NUMBER(22)
SUBDIAGDATA3 Y NUMBER(22)
SUBDIAGDATA4 Y NUMBER(22)
SUBDIAGDATA5 Y NUMBER(22)
SUBDIAGDATA6 Y NUMBER(22)
SUBDIAGDATA7 Y NUMBER(22)
SUBDIAGDATA8 Y NUMBER(22)
SUBDIAGDATA9 Y NUMBER(22)
SUBDIAGDATA10 Y NUMBER(22)
SUBDIAGDATA11 Y NUMBER(22)

Table: SUBDIAGERRSTATUSXREF
Field name Null Type Description
DIAGERRSTATUSID Y NUMBER(22)
DIAGERRSTATUSTEXT Y VARCHAR2(60)
DIAGERRSTATUSTEXTDETAIL Y VARCHAR2(500)

Table: SUBDIAGERRCAUSEXREF
Field name Null Type Description
DIAGERRCAUSEID Y NUMBER(22)
DIAGERRCAUSETEXT Y VARCHAR2(32)
DIAGERRCAUSETEXTDETAIL Y VARCHAR2(500)

Table: SUBDIAGDATAXREF
Field name Null Type Description
DIAGTESTID Y NUMBER(22)
SUBDIAGDATA1 Y NUMBER(22)
SUBDIAGDATA2 Y NUMBER(22)
SUBDIAGDATA3 Y NUMBER(22)
SUBDIAGDATA4 Y NUMBER(22)
SUBDIAGDATA5 Y NUMBER(22)
SUBDIAGDATA6 Y NUMBER(22)
SUBDIAGDATA7 Y NUMBER(22)
SUBDIAGDATA8 Y NUMBER(22)
SUBDIAGDATA9 Y NUMBER(22)
SUBDIAGDATA10 Y NUMBER(22)
SUBDIAGDATA11 Y NUMBER(22)
SUBDIAGDATATEXT Y VARCHAR2(60)

Table: SUBCMDQSTATUS
Field name Null Type Description
SUBID N NUMBER(22)
SUBMXCMDOUT Y NUMBER(22)
SUBMXSRCHOUT Y NUMBER(22)
SUBCMDOUTCOUNT Y NUMBER(22)
SUBSRCHOUTCOUNT Y NUMBER(22)

Table: SUBADCCPTHIRDVAR
Field name Null Type Description
SUBID N NUMBER(22)
SUBLRTRYLIM Y NUMBER(22)
SUBLRTRYTMR Y NUMBER(22)
SUBLPOLTMR Y NUMBER(22)
SUBLFLGTMR Y NUMBER(22)
SUBIPOLDLY Y NUMBER(22)

Table: SUBADCCPSECONDVAR
Field name Null Type Description
SUBID N NUMBER(22)
SUBENBLXID Y CHAR(1)
SUBENBLREJ Y CHAR(1)
SUBENBLSREJ Y CHAR(1)
SUBENBLUI Y CHAR(1)
SUBENBLSIM Y CHAR(1)
SUBENBLUP Y CHAR(1)
SUBENBLEXA Y CHAR(1)
SUBFILL11 Y CHAR(1)
SUBFILL12 Y CHAR(1)
SUBFILL13 Y CHAR(1)
SUBFILL14 Y CHAR(1)
SUBFILL15 Y CHAR(1)
SUBLTRMWNXZ Y NUMBER(22)
SUBLSREJTHR Y NUMBER(22)
SUBLMXIFLN Y NUMBER(22)
SUBLLCLADLN Y NUMBER(22)
SUBLRMTADLN Y NUMBER(22)
SUBJLCLADRA Y NUMBER(22)
SUBJDROP Y NUMBER(22)

Table: STRAT_LCCMD_DEFS
Field name Null Type Description
LCID N NUMBER(22)
COMMAND N VARCHAR2(20)
ADDR1 N NUMBER(22)
ADDR2 Y NUMBER(22)
SUBID N NUMBER(22)
PORT Y NUMBER(22)
OFFTIME N NUMBER(22)
DELAY N NUMBER(22)
CYCLES N NUMBER(22)
DESCRIP Y VARCHAR2(100)
CHANGE_TIME Y DATE(7)
CHANGE_COMMENT Y VARCHAR2(50)

Table: STRAT_LCCMDS
Field name Null Type Description
STRATID Y NUMBER(22)
STARTTIME N NUMBER(22)
ENDTIME Y NUMBER(22)
FREQUENCY Y NUMBER(22)
LCID Y NUMBER(22)
CHANGE_TIME Y DATE(7)
CHANGE_COMMENT Y VARCHAR2(50)

Table: STRATEGIES
Field name Null Type Description
STRATID N NUMBER(22)
NAME N VARCHAR2(25)
ENABLED N NUMBER(22)
DESCR Y VARCHAR2(100)
CHANGE_TIME Y DATE(7)
CHANGE_COMMENT Y VARCHAR2(50)
ENABLE_CHANGE_TIME Y DATE(7)
ENABLE_CHANGE_COMMENT Y VARCHAR2(50)
LAST_ACTIVATION Y DATE(7)

Table: STATUSDESC
Field name Null Type Description
EXCHANGETYPE Y NUMBER(22)
STATUSTYPE Y NUMBER(22)
STATUSNUMBER N NUMBER(22)
STATUSSHORTDESC Y VARCHAR2(32)
STATUSLONGDESC Y VARCHAR2(160)

Table: SPCOMMENTS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
DATE1 N DATE(7)
METERCUSTOMERACCTNUM Y VARCHAR2(21)
METERNUMBER Y VARCHAR2(21)
TEXTREF1 Y VARCHAR2(15)
TESTDESC Y VARCHAR2(255)

Table: SNPATHHIST_20140610
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
OLDSUBID Y NUMBER(22)
OLDBUSID Y NUMBER(22)
OLDFDRID Y NUMBER(22)
OLDPHASE Y NUMBER(22)
OLDSIGNAL Y NUMBER(22)
OLDDETECTION Y NUMBER(22)
NEWSUBID Y NUMBER(22)
NEWBUSID Y NUMBER(22)
NEWFDRID Y NUMBER(22)
NEWPHASE Y NUMBER(22)
NEWSIGNAL Y NUMBER(22)
NEWDETECTION Y NUMBER(22)
MODDATE Y DATE(7)
TYPE Y CHAR(1)

Table: SNPATHHIST
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
OLDSUBID Y NUMBER(22)
OLDBUSID Y NUMBER(22)
OLDFDRID Y NUMBER(22)
OLDPHASE Y NUMBER(22)
OLDSIGNAL Y NUMBER(22)
OLDDETECTION Y NUMBER(22)
NEWSUBID Y NUMBER(22)
NEWBUSID Y NUMBER(22)
NEWFDRID Y NUMBER(22)
NEWPHASE Y NUMBER(22)
NEWSIGNAL Y NUMBER(22)
NEWDETECTION Y NUMBER(22)
MODDATE Y DATE(7)
TYPE Y CHAR(1)

Table: SNHRLYGRPS
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
HRLYGRP Y NUMBER(22)

Table: SNAPSHOTLOG
Field name Null Type Description
DATETIME Y DATE(7)
USERNAME Y VARCHAR2(32)
SUBID N NUMBER(22)
SUBNAME Y VARCHAR2(25)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
ORIGINATORTYPEID Y NUMBER(22)
ORIGINATORTYPE Y VARCHAR2(6)
ORIGINATORID Y NUMBER(22)
EXCHANGETYPEID Y NUMBER(22)
EXCHANGETYPE Y VARCHAR2(6)
EXCHANGEID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
PRI Y NUMBER(22)
PREVEXCHANGEID Y NUMBER(22)
NEXTEXCHANGEID Y NUMBER(22)
PROCESSINGSTATUSID Y NUMBER(22)
PROCESSINGSTATUSTEXT Y VARCHAR2(30)

Table: SIGNALXREF
Field name Null Type Description
SIGNALNAME Y CHAR(4)
SIGNALNUMBER N NUMBER(22)

Table: SERVICETYPE
Field name Null Type Description
SERVICETYPEID Y NUMBER(22)
SERVICETYPENAME Y VARCHAR2(18)

Table: SERIALPORTREF
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
RATECODE Y VARCHAR2(10)
CASECODE Y VARCHAR2(15)
TEXT1 Y VARCHAR2(15)
TEXT2 Y VARCHAR2(15)
TEXT3 Y VARCHAR2(15)
TEXT4 Y VARCHAR2(15)
TEXT5 Y VARCHAR2(15)
DATE1 Y DATE(7)
DATE2 Y DATE(7)
DATE3 Y DATE(7)
DATE4 Y DATE(7)
DATE5 Y DATE(7)
V1 Y NUMBER(22)
V2 Y NUMBER(22)
V3 Y NUMBER(22)
V4 Y NUMBER(22)
V5 Y NUMBER(22)
PREPAYFLAG Y NUMBER(22)
SERVICE_LOCATION Y VARCHAR2(64)
BILLED_DEMAND Y NUMBER(22)

Table: SERIALPORT
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
PORTPREMISEID Y VARCHAR2(21)
PORTINSTALLDATE Y DATE(7)
PORTMODIFYDATE Y DATE(7)
PORTDISTRICTNUMBER Y NUMBER(22)
PORTDEVICELOC Y VARCHAR2(6)
PORTACTIVEFLAG Y VARCHAR2(2)
PORTDEVICETYPE Y NUMBER(22)
PORTCONNECTTYPE Y VARCHAR2(9)
PORTCONNECTDATE Y DATE(7)
PORTUSER1 Y VARCHAR2(17)
PORTUSER2 Y VARCHAR2(17)

Table: SERIALNUMBER
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
UTILACCTID Y NUMBER(22)
PREMISEID Y VARCHAR2(21)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)
TYPE Y NUMBER(22)
MODEL Y NUMBER(22)
PROTECTIVEDEVICE N VARCHAR2(13)
TRANSFORMERGRID Y VARCHAR2(13)
INSTALLDATE Y DATE(7)
DISTRICTNUMBER Y NUMBER(22)
DEVICELOC Y VARCHAR2(6)
ACTIVEFLAG Y VARCHAR2(2)
ONEWAY Y VARCHAR2(2)
LASTGOODCOMMDT Y DATE(7)
LASTTRYCOMMDT Y DATE(7)
BYTECOUNT Y NUMBER(22)
USEDBYTECOUNT Y NUMBER(22)
TOTCOMMFAILCNT Y NUMBER(22)
CONSECCOMMFAILCNT Y NUMBER(22)
COMMTYPE Y VARCHAR2(9)
DEVICETYPE Y NUMBER(22)
CONNECTTYPE Y VARCHAR2(9)
CONNECTDATE Y DATE(7)
USER1 Y VARCHAR2(17)
USER2 Y VARCHAR2(17)

Table: SERIALIZATION
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
TYPE Y NUMBER(22)

Table: SECURITYUSERS
Field name Null Type Description
SECURITYUSERID N NUMBER(22)
NAME N VARCHAR2(50)
LOGINNAME N VARCHAR2(30)
EMAIL Y VARCHAR2(100)
ACTIVE N NUMBER(22)
MODIFIEDDATE N DATE(7)
MODIFIEDBY N VARCHAR2(50)
PASSWORD N VARCHAR2(100)
PASSWORDCHANGEDDATE N DATE(7)
MUSTCHANGEPASSWORD N NUMBER(22)
UTILACCTID N NUMBER(22)

Table: SECURITYUSERROLES
Field name Null Type Description
SECURITYUSERROLEID N NUMBER(22)
SECURITYUSERID N NUMBER(22)
SECURITYROLEID N NUMBER(22)

Table: SECURITYROLES
Field name Null Type Description
SECURITYROLEID N NUMBER(22)
NAME N VARCHAR2(30)
DESCRIPTION Y VARCHAR2(100)
DEFAULTROLE N NUMBER(22)
MODIFIEDDATE N DATE(7)
MODIFIEDBY N VARCHAR2(50)

Table: SECURITYROLERIGHTS
Field name Null Type Description
SECURITYROLERIGHTID N NUMBER(22)
SECURITYRIGHTID N NUMBER(22)
SECURITYROLEID N NUMBER(22)

Table: SECURITYRIGHTS
Field name Null Type Description
SECURITYRIGHTID N NUMBER(22)
NAME N VARCHAR2(50)
DESCRIPTION Y VARCHAR2(100)
GROUPNAME N VARCHAR2(20)

Table: SEARCHTHRESHOLD
Field name Null Type Description
MODDATE N DATE(7)
AUTOGENERATED N VARCHAR2(1)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)
THRESHOLD Y NUMBER(22)
TYPE Y NUMBER(22)
MODEL Y NUMBER(22)
USER1 Y VARCHAR2(17)
USER2 Y VARCHAR2(17)

Table: SEARCHHISTORY
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
STAGE Y NUMBER(22)
ATTEMPTNUM Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)
SRCHMODE Y NUMBER(22)
SRCHTYPE Y NUMBER(22)
TYPE Y NUMBER(22)
MODEL Y NUMBER(22)
TNSSTATUS Y NUMBER(22)
SCESTATUS Y NUMBER(22)
RCESTATUS Y NUMBER(22)
QUALITYCODE Y NUMBER(22)
SIGNALSTRENGTH Y NUMBER(22)
THRESHOLDCOMPARED Y NUMBER(22)
SECONDSATSUB Y NUMBER(22)
SRCHDATE Y DATE(7)
UTILACCTID Y NUMBER(22)
USER1 Y VARCHAR2(17)
USER2 Y VARCHAR2(17)

Table: SDC_READ_REGISTERS
Field name Null Type Description
TYPE N NUMBER(22)
READTYPE N NUMBER(22)
COMMAND_ID Y NUMBER(22)
READLENGTH Y NUMBER(22)

Table: SDC_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)
SUBSYSTEM Y VARCHAR2(32)
VENDOR Y VARCHAR2(32)

Table: SDC_DSI_SCHEDULE_RESET
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
OPERATION N CHAR(1)
RESET_DATETIME N DATE(7)

Table: SDC_CMDSEQ
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
MAX_CMD_SEQ Y NUMBER(22)
CMD_1 Y VARCHAR2(3)
CMDSEQ_1 Y NUMBER(22)
CMD_2 Y VARCHAR2(3)
CMDSEQ_2 Y NUMBER(22)
CMD_3 Y VARCHAR2(3)
CMDSEQ_3 Y NUMBER(22)
CMD_4 Y VARCHAR2(3)
CMDSEQ_4 Y NUMBER(22)
CMD_5 Y VARCHAR2(3)
CMDSEQ_5 Y NUMBER(22)
CMD_6 Y VARCHAR2(3)
CMDSEQ_6 Y NUMBER(22)
SERIALPORT N NUMBER(22)

Table: SDCSTATUS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SWITCHPOSN Y VARCHAR2(15)
TIMEUPDATED Y DATE(7)
LAST_SW_CMD Y VARCHAR2(9)
LASTCMDDATE Y DATE(7)
AUTOOPN Y CHAR(1)
RCDLOCK Y CHAR(1)
SERIALPORT N NUMBER(22)

Table: SDCSCHEDULEDXREF
Field name Null Type Description
SCHEDULED N NUMBER(22)
SHORTDESC Y VARCHAR2(48)
DESCRIPTION Y VARCHAR2(256)

Table: SDCRESPONSEXREF
Field name Null Type Description
TYPE N NUMBER(22)
CMDSTATUS N NUMBER(22)
MSGTEXT Y VARCHAR2(300)

Table: SDCREASONS
Field name Null Type Description
REASONCODE N VARCHAR2(9)
REASONTEXT Y VARCHAR2(50)

Table: SDCPENDINGCMDS_BACKUP
Field name Null Type Description
MSEXID N NUMBER(22)
GROUPID N NUMBER(22)
TIMESENT Y DATE(7)
SERIALNUMBER Y NUMBER(22)
CMDSENT Y CHAR(3)
REASONCODE Y VARCHAR2(9)
CMDSTATUS Y NUMBER(22)
MAX_CMD_SEQ Y NUMBER(22)
CMDSEQ Y NUMBER(22)
TNSSTAT Y NUMBER(22)
RCESTAT Y NUMBER(22)
SCESTAT Y NUMBER(22)
QC Y NUMBER(22)
SWITCHSTATE Y VARCHAR2(15)
SWITCHDATE Y DATE(7)
LAST_SW_CMD Y VARCHAR2(15)
LAST_SW_STATUS Y NUMBER(22)
ARM Y CHAR(1)
PUSHBUTTON Y CHAR(1)
PB_TIMESTAMP Y DATE(7)
RCDLOCK Y CHAR(1)
AUTOOPN Y CHAR(1)
SW_CMD_STATUS Y NUMBER(22)
LASTOPNSOURCE Y NUMBER(22)
LASTOPNATTEMPED Y NUMBER(22)
OPENCOUNT Y NUMBER(22)
CLOSECOUNT Y NUMBER(22)
MSGTXT Y VARCHAR2(150)
NTUSER Y VARCHAR2(32)
UTILACCTID Y NUMBER(22)
POSTACTIONFLAGS Y VARCHAR2(15)
USERPID Y NUMBER(22)
RETRYCOUNT Y NUMBER(22)
NEXTRETRYTIME Y DATE(7)
ORGRETRIES Y NUMBER(22)
ARMTIMEOUT Y DATE(7)
TIMESCHED Y DATE(7)
TIMECOMPLETE Y DATE(7)
ASSOC_SWITCH_SN Y NUMBER(22)

Table: SDCPENDINGCMDS
Field name Null Type Description
MSEXID N NUMBER(22)
GROUPID N NUMBER(22)
TIMESENT Y DATE(7)
SERIALNUMBER Y NUMBER(22)
CMDSENT Y CHAR(3)
REASONCODE Y VARCHAR2(9)
CMDSTATUS Y NUMBER(22)
MAX_CMD_SEQ Y NUMBER(22)
CMDSEQ Y NUMBER(22)
TNSSTAT Y NUMBER(22)
RCESTAT Y NUMBER(22)
SCESTAT Y NUMBER(22)
QC Y NUMBER(22)
SWITCHSTATE Y VARCHAR2(15)
SWITCHDATE Y DATE(7)
LAST_SW_CMD Y VARCHAR2(15)
LAST_SW_STATUS Y NUMBER(22)
ARM Y CHAR(1)
PUSHBUTTON Y CHAR(1)
PB_TIMESTAMP Y DATE(7)
RCDLOCK Y CHAR(1)
AUTOOPN Y CHAR(1)
SW_CMD_STATUS Y NUMBER(22)
LASTOPNSOURCE Y NUMBER(22)
LASTOPNATTEMPED Y NUMBER(22)
OPENCOUNT Y NUMBER(22)
CLOSECOUNT Y NUMBER(22)
MSGTXT Y VARCHAR2(300)
NTUSER Y VARCHAR2(32)
UTILACCTID Y NUMBER(22)
POSTACTIONFLAGS Y VARCHAR2(15)
USERPID Y NUMBER(22)
RETRYCOUNT Y NUMBER(22)
NEXTRETRYTIME Y DATE(7)
ORGRETRIES Y NUMBER(22)
ARMTIMEOUT Y DATE(7)
TIMESCHED Y DATE(7)
TIMECOMPLETE Y DATE(7)
ASSOC_SWITCH_SN Y NUMBER(22)
SERIALPORT Y NUMBER(22)

Table: SDCPENDINGACTIONS_BACKUP
Field name Null Type Description
GROUPID N NUMBER(22)
TIMESENT Y DATE(7)
SERIALNUMBER N NUMBER(22)
DESIREDACTION Y VARCHAR2(15)
MAX_CMD_SEQ Y NUMBER(22)
CMD_SEQ Y NUMBER(22)
SCHEDULED Y NUMBER(22)
SCHEDID Y NUMBER(22)
MSGTXT Y VARCHAR2(100)
USERNAME Y VARCHAR2(32)
SUBSYSTEM Y VARCHAR2(32)
VENDOR Y VARCHAR2(32)

Table: SDCPENDINGACTIONS
Field name Null Type Description
GROUPID N NUMBER(22)
TIMESENT Y DATE(7)
SERIALNUMBER N NUMBER(22)
DESIREDACTION Y VARCHAR2(15)
MAX_CMD_SEQ Y NUMBER(22)
CMD_SEQ Y NUMBER(22)
SCHEDULED Y NUMBER(22)
SCHEDID Y NUMBER(22)
MSGTXT Y VARCHAR2(300)
USERNAME Y VARCHAR2(32)
SUBSYSTEM Y VARCHAR2(32)
VENDOR Y VARCHAR2(32)
SERIALPORT Y NUMBER(22)

Table: SDCPENDING
Field name Null Type Description
MSEXID N NUMBER(22)
TIMESENT Y DATE(7)
SERIALNUMBER Y NUMBER(22)
CMDCODE Y CHAR(1)
REASONCODE Y VARCHAR2(9)
STATE Y NUMBER(22)
NTUSER Y VARCHAR2(32)
UTILACCTID Y NUMBER(22)
POSTACTIONFLAGS Y VARCHAR2(15)
USERPID Y NUMBER(22)
MSGTEXT Y VARCHAR2(100)
RETRYCOUNT Y NUMBER(22)
NEXTRETRYTIME Y DATE(7)
ORGRETRIES Y NUMBER(22)
ARMTIMEOUT Y DATE(7)
TIMESCHED Y DATE(7)
TIMECOMPLETE Y DATE(7)
ASSOC_SWITCH_SN Y NUMBER(22)
GROUPID N NUMBER(22)

Table: SDCMETERSTATUS
Field name Null Type Description
STATUSTIME N DATE(7)
SERIALNUMBER N NUMBER(22)
SWITCHSTATE Y NUMBER(22)
OPENCOUNT Y NUMBER(22)
CLOSECOUNT Y NUMBER(22)

Table: SDCHISTORY
Field name Null Type Description
MSEXID N NUMBER(22)
GROUPID N NUMBER(22)
TIMESENT Y DATE(7)
SERIALNUMBER Y NUMBER(22)
CMDSENT Y CHAR(3)
REASONCODE Y VARCHAR2(9)
CMDSTATUS Y NUMBER(22)
MAX_CMD_SEQ Y NUMBER(22)
CMDSEQ Y NUMBER(22)
TNSSTAT Y NUMBER(22)
RCESTAT Y NUMBER(22)
SCESTAT Y NUMBER(22)
QC Y NUMBER(22)
SWITCHSTATE Y VARCHAR2(15)
SWITCHDATE Y DATE(7)
LAST_SW_CMD Y VARCHAR2(15)
LAST_SW_STATUS Y NUMBER(22)
ARM Y CHAR(1)
PUSHBUTTON Y CHAR(1)
PB_TIMESTAMP Y DATE(7)
RCDLOCK Y CHAR(1)
AUTOOPN Y CHAR(1)
SW_CMD_STATUS Y NUMBER(22)
LASTOPNSOURCE Y NUMBER(22)
LASTOPNATTEMPED Y NUMBER(22)
OPENCOUNT Y NUMBER(22)
CLOSECOUNT Y NUMBER(22)
MSGTXT Y VARCHAR2(300)
NTUSER Y VARCHAR2(32)
UTILACCTID Y NUMBER(22)
POSTACTIONFLAGS Y VARCHAR2(15)
USERPID Y NUMBER(22)
RETRYCOUNT Y NUMBER(22)
NEXTRETRYTIME Y DATE(7)
ORGRETRIES Y NUMBER(22)
ARMTIMEOUT Y DATE(7)
TIMESCHED Y DATE(7)
TIMECOMPLETE Y DATE(7)
ASSOC_SWITCH_SN Y NUMBER(22)
SERIALPORT Y NUMBER(22)

Table: SDCDESIRED
Field name Null Type Description
GROUPID N NUMBER(22)
SERIALNUMBER N NUMBER(22)
DESIREDSWITCHPOSN Y VARCHAR2(15)
TIMEREQUESTED Y DATE(7)
UTILITY_REASONCODE Y VARCHAR2(50)
SERIALPORT N NUMBER(22)

Table: SDCCOMMANDXREF
Field name Null Type Description
COMMANDID N NUMBER(22)
COMMAND Y CHAR(1)
DESCRIPTION Y VARCHAR2(100)
SDCCOMMAND Y VARCHAR2(15)
CMDREASONCODE Y VARCHAR2(5)
SWITCHACTIONFLAG Y NUMBER(22)
OCDISPLAYORDER Y NUMBER(22)
SWITCHSTATUSFLAG Y NUMBER(22)
SWITCHCOMMANDFLAG Y NUMBER(22)
SWITCHFLAG1 Y NUMBER(22)
SWITCHFLAG2 Y NUMBER(22)
SWITCHTEXT1 Y VARCHAR2(256)
SWITCHTEXT2 Y VARCHAR2(256)
SWITCHTEXT3 Y VARCHAR2(256)
COMMANDSTARTDATE Y DATE(7)
COMMANDENDDATE Y DATE(7)
COMMANDMODIFYDATE Y DATE(7)
COMMANDDATE1 Y DATE(7)

Table: SDCALARMS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
ALARM_START_TIME N DATE(7)
LAST_ALARM_TIME N DATE(7)
ACKNOWLEDGED N CHAR(1)
ACKNOWLEDGE_TIME Y DATE(7)
ALARM_FLAG Y NUMBER(22)

Table: SDCACTIONSHISTORY
Field name Null Type Description
GROUPID N NUMBER(22)
TIMESENT Y DATE(7)
SERIALNUMBER N NUMBER(22)
DESIREDACTION Y VARCHAR2(15)
MAX_CMD_SEQ Y NUMBER(22)
CMD_SEQ Y NUMBER(22)
SCHEDULED Y NUMBER(22)
SCHEDID Y NUMBER(22)
MSGTXT Y VARCHAR2(300)
USERNAME Y VARCHAR2(32)
SUBSYSTEM Y VARCHAR2(32)
VENDOR Y VARCHAR2(32)
SERIALPORT Y NUMBER(22)

Table: SCHCHECK
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SCHEDULENUM Y NUMBER(22)
USERID N NUMBER(22)

Table: SCEMRSP_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: SCEMAINT_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: SCEMAIN
Field name Null Type Description
SUBID N NUMBER(22)
SUBNAME Y VARCHAR2(25)
SUBMODEL Y VARCHAR2(5)
TIMESYNCINT Y NUMBER(22)
TIMESYNCDEL Y NUMBER(22)
TIMESYNCWIN Y NUMBER(22)
ALLT10 Y CHAR(1)
LASTUPDATETBLDT Y DATE(7)
LASTNOTIFDT Y DATE(7)
LASTDWNLDTBLDT Y DATE(7)
LASTOFFLINEDT Y DATE(7)
CHECKDTTNS Y DATE(7)
CHECKDTSCE Y DATE(7)
SETDTTNS Y DATE(7)
SETDTSCE Y DATE(7)
COMMLINETYPE Y NUMBER(22)
SUBDROPID Y NUMBER(22)
COMMID Y NUMBER(22)
SUBCOMMBD Y NUMBER(22)
SUBCOMMPORT Y NUMBER(22)
SUBPHONENUM Y VARCHAR2(50)
SUBCONNECTRETENTIONTIMEMIN Y NUMBER(22)
SUBCONNECTRETENTIONTIMESEC Y NUMBER(22)
SUBCONNECTREDIALTIMEMINSRCH Y NUMBER(22)
SUBCONNECTREDIALTIMESECSRCH Y NUMBER(22)
SUBCONNECTATTEMPTS Y NUMBER(22)
SUBCONNECTATTEMPTSREM Y NUMBER(22)
SUBEXPOFFSETMIN Y NUMBER(22)
SUBEXPOFFSETSEC Y NUMBER(22)
SUBSTATUS Y NUMBER(22)
SUBSTATE Y NUMBER(22)
SUBCONNECTSTATUSTEXT Y VARCHAR2(20)
SUBCONNECTSTATETEXT Y VARCHAR2(20)
SUBVER Y NUMBER(22)
SUBTMSLACT Y NUMBER(22)
SUBRDTBL Y NUMBER(22)
SUBRDTBLE Y NUMBER(22)
SUBWRTBL Y NUMBER(22)
SUBWRTBLE Y NUMBER(22)
SUBSETTBL Y NUMBER(22)
SUBCONFIGKEY Y CHAR(32)
SUBXMAXADDRESS Y NUMBER(22)
SUBXMINADDRESS Y NUMBER(22)
SUBYMAXADDRESS Y NUMBER(22)
SUBYMINADDRESS Y NUMBER(22)
SUBALLOFFTIME Y NUMBER(22)
SUBALLOFFDELAY Y NUMBER(22)
SUBALLOFFCYCLES Y NUMBER(22)
SUBALLOFFPRIORITY Y NUMBER(22)
SUBALLONTIME Y NUMBER(22)
SUBALLONDELAY Y NUMBER(22)
SUBALLONCYCLES Y NUMBER(22)
SUBALLONPRIORITY Y NUMBER(22)
TCPHOST Y VARCHAR2(256)
TCPPORT Y NUMBER(22)
CONNECTIONPROFILEID Y NUMBER(22)

Table: SCEDL_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: SCEDLFWSTATUSXREF
Field name Null Type Description
DLSTATUSID N NUMBER(22)
DLSTATUSTEXT Y VARCHAR2(60)

Table: SCEDLFWLOG
Field name Null Type Description
SUBID N NUMBER(22)
GROUPID Y NUMBER(22)
STAMP Y DATE(7)
FILENAME Y VARCHAR2(80)
FILELENGTH Y NUMBER(22)
FILECRC Y NUMBER(22)
FILEFORMAT Y NUMBER(22)
FIRMWARETYPE Y NUMBER(22)
FIRMWAREVERMAJOR Y NUMBER(22)
FIRMWAREVERMINOR Y NUMBER(22)
FIRMWAREVERBUILD Y NUMBER(22)
DLEQUIPMENTTYPE Y NUMBER(22)
DLEQUIPMENTIDMAX Y NUMBER(22)
DLEQUIPMENTIDMIN Y NUMBER(22)
DLEQUIPMENTID Y NUMBER(22)
DLAREATYPE Y NUMBER(22)
DLPROGCHECKSUM Y NUMBER(22)
DLPROGSIZE Y NUMBER(22)
PROGOFFSET Y NUMBER(22)
AREAFILLTYPE Y NUMBER(22)
DATALENGTH Y NUMBER(22)
NEXTFILEPOINTER Y NUMBER(22)
NEXTSTARTADDRESS Y NUMBER(22)

Table: SCEDLFW
Field name Null Type Description
SUBID N NUMBER(22)
DLSTATUSID Y NUMBER(22)
FILECHECKSUM Y NUMBER(22)
FILECHECKSUMADDR Y NUMBER(22)
FILERECSIZE Y NUMBER(22)
TOTALPACKET Y NUMBER(22)
DLPACKET Y NUMBER(22)
DLPERCENT Y NUMBER(22)
GROUPID Y NUMBER(22)
STAMP Y DATE(7)
FILENAME Y VARCHAR2(80)

Table: SBF
Field name Null Type Description
SBFID N NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)

Table: RPA
Field name Null Type Description
SUBID N NUMBER(22)
RPAID N NUMBER(22)
SYNCSTATE Y NUMBER(22)
EQUIPTYPEID Y NUMBER(22)

Table: RIDSVR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: RFDIAGINDHISTORY
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
RFPORT N NUMBER(22)
PREVRMTRSN Y NUMBER(22)
PRESRMTRSN Y NUMBER(22)
READSTATUS Y NUMBER(22)
READSTATUSDESC Y VARCHAR2(32)
REGID N NUMBER(22)
REGNAME Y VARCHAR2(32)
DIAGDATETIME Y DATE(7)
DIAGBIT0 Y NUMBER(22)
DIAGBIT1 Y NUMBER(22)
DIAGBIT2 Y NUMBER(22)
DIAGBIT3 Y NUMBER(22)
DIAGBIT4 Y NUMBER(22)
DIAGBIT5 Y NUMBER(22)
DIAGBIT6 Y NUMBER(22)
DIAGBIT7 Y NUMBER(22)
DIAGBIT8 Y NUMBER(22)
DIAGBIT9 Y NUMBER(22)
DIAGBIT10 Y NUMBER(22)
DIAGBIT11 Y NUMBER(22)
DIAGBIT12 Y NUMBER(22)
DIAGBIT13 Y NUMBER(22)
DIAGBIT14 Y NUMBER(22)
DIAGBIT15 Y NUMBER(22)

Table: RESPONSESTATUSXREF
Field name Null Type Description
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
RESPONSESTATUSRCE Y NUMBER(22)
RESPONSESTATUSREG Y NUMBER(22)
RESPONSESTATUSTYPE Y NUMBER(22)
RESPONSESTATUSPRIORITY Y NUMBER(22)
RESPONSESTATUSSHORTDESC Y VARCHAR2(32)
RESPONSESTATUSLONGDESC Y VARCHAR2(160)

Table: RELATEDDEVICEUPDATE
Field name Null Type Description
UPDATECODE N NUMBER(22)
SHORTDESC Y VARCHAR2(32)
LONGDESC Y VARCHAR2(160)

Table: RECORDTYPE
Field name Null Type Description
RECORDTYPE N VARCHAR2(8)
RECORDTYPEID Y NUMBER(22)

Table: RECEIVERXREF
Field name Null Type Description
RECEIVERTYPEID Y NUMBER(22)
RECEIVERTYPETEXT Y VARCHAR2(48)

Table: REASON
Field name Null Type Description
REASON Y VARCHAR2(50)

Table: RDRS_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: RCE_FW_INFO
Field name Null Type Description
SERIALNUMBER_FK N NUMBER(22)
FW_MAJOR_VER N NUMBER(22)
FW_MINOR_VER N NUMBER(22)
FW_BUILD_NUM N NUMBER(22)
RCE_STATUS N NUMBER(22)
CYCLE_IDFK Y NUMBER(22)
NUM_ATTEMPTS N NUMBER(22)
TNS Y NUMBER(22)
SCE Y NUMBER(22)
RCE Y NUMBER(22)
FUNC_STATUS Y NUMBER(22)
ERR_CODE Y NUMBER(22)
NUM_MISSING_PACKETS Y NUMBER(22)

Table: RCETYPE
Field name Null Type Description
RCETYPEID N NUMBER(22)
RCETYPENAME Y VARCHAR2(10)

Table: RCEDFW_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: RCEDFW_CONTROLQ
Field name Null Type Description
GROUPID N NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP N DATE(7)
USERNAME Y VARCHAR2(32)
OWNER N VARCHAR2(10)
FUNCCODE N NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: RCDTYPE
Field name Null Type Description
RCDTYPEID N NUMBER(22)
RCDTYPENAME Y VARCHAR2(18)

Table: RCDFEATURESET
Field name Null Type Description
RCDFEATURESETID N NUMBER(22)
LOADLIMITING Y VARCHAR2(3)
INTEGRATEDSD Y VARCHAR2(3)
SOFTFUSE Y VARCHAR2(3)
DEMANDLIMITING Y VARCHAR2(3)
LOADSIDETHRESHOLD Y VARCHAR2(3)
NETWORKRELATED Y VARCHAR2(3)
PREPAYMETERING Y VARCHAR2(3)
REMOTECONFIG N VARCHAR2(3)

Table: RCDCMDSUMMARY
Field name Null Type Description
RCDTYPEID N NUMBER(22)
CMDEXCHANGEID Y NUMBER(22)
TOTALSUBCMDSEQ Y NUMBER(22)
RCDNAMEDCFGID N NUMBER(22)

Table: RCDCMDCONFIG
Field name Null Type Description
RCDTYPEID N NUMBER(22)
SUBCMDNUM Y NUMBER(22)
NUMOFPARAMSELECTED Y NUMBER(22)
CMDEXCHANGEID Y NUMBER(22)
CMDID Y NUMBER(22)
CMDLENGTH Y NUMBER(22)
CMDTABLEID Y NUMBER(22)
CMDOFFSET Y NUMBER(22)
RCDNAMEDCFGID N NUMBER(22)

Table: RCDCFGPARAM
Field name Null Type Description
RCDNAMEDCFGID N NUMBER(22)
CONFIGTYPEID N NUMBER(22)
RCDTYPEID N NUMBER(22)
DATASELECT Y NUMBER(22)
DATAID N NUMBER(22)
DATANAME Y VARCHAR2(48)
VALUE Y NUMBER(22)

Table: RCDCFGDISPLAY
Field name Null Type Description
RCDNAMEDCFGID N NUMBER(22)
CONFIGTYPEID N NUMBER(22)
RCDTYPEID N NUMBER(22)
DISPLAYSELECTED Y NUMBER(22)
DISPLAYID N NUMBER(22)
DISPLAYNAME Y VARCHAR2(255)
DISPLAYVALUE Y VARCHAR2(48)

Table: QUERY_COLUMNS
Field name Null Type Description
QCOL_ID N NUMBER(22)
COL_NAME Y VARCHAR2(255)
COL_TYPE Y NUMBER(22)

Table: QUALITYCODECATEGORY
Field name Null Type Description
QUALITYCODE N NUMBER(22)
QUALITYCODECATEGORY Y NUMBER(22)

Table: PROT_DEVICE_NETWORK
PROASYS traverses the protective device hierarchy based on utility-specific input. The Protective Device Network table stores the utility-specific hierarchy information. The table contains the protective device, the upstream device, and (optionally) the X and Y map coordinates for the devices. PROASYS uses this table if it is populated with hierarchy information. If the table is not populated, PROASYS uses the default hierarchy of substation, bus, feeder, protective device, transformer grid.
Field name Null Type Description
PROTECTIVE_DEVICE N VARCHAR2(20)
ALT_ID Y VARCHAR2(20)
UPSTREAM_DEVICE Y VARCHAR2(20)
DEVICE_TYPE Y VARCHAR2(20)
MAP_LOC_X Y FLOAT(22)
MAP_LOC_Y Y FLOAT(22)

Table: PROD_RCDTYPE_XREF
Field name Null Type Description
PRODUCTTYPE N NUMBER(22)
PRODUCTMODEL N NUMBER(22)
RCDTYPEID N NUMBER(22)

Table: PRODUCTTYPEMODXREF
Field name Null Type Description
SERIALNUMBERSTART N NUMBER(22)
SERIALNUMBERSTOP N NUMBER(22)
PRODUCTTYPE Y NUMBER(22)
PRODUCTMODEL Y NUMBER(22)
DRAWINGNO Y VARCHAR2(20)
DRAWINGNOCOMMENT Y VARCHAR2(32)

Table: PRODUCTPORT
Field name Null Type Description
PRODUCTTYPE Y NUMBER(22)
PRODUCTMODEL Y NUMBER(22)
PRODUCTPORT Y NUMBER(22)
SUBSYSTEMID Y NUMBER(22)
UTILACCTID Y NUMBER(22)
PRODUCTPORTDISPFACT Y NUMBER(22)
PRODUCTPORTINIT Y NUMBER(22)
PRODUCTPORTENABLE Y NUMBER(22)
PRODUCTPORTSERVICE Y NUMBER(22)
PRODUCTPORTINTDEV Y NUMBER(22)
METERTYPE Y VARCHAR2(11)
PRODUCTPORTSHIFTINIT Y NUMBER(22)

Table: PRODUCTCFGDEFAULTS
Field name Null Type Description
PRODUCTTYPE N NUMBER(22)
PRODUCTMODEL N NUMBER(22)
CONFIGTYPEID N NUMBER(22)
NAMEDCFGID Y NUMBER(22)
SWITCHPOSN Y VARCHAR2(15)

Table: PRODUCT
Field name Null Type Description
PRODUCTTYPE N NUMBER(22)
PRODUCTMODEL N NUMBER(22)
PRODUCTNAME Y VARCHAR2(25)
UTILACCTID Y NUMBER(22)
SUBSYSTEMID Y NUMBER(22)
PRODUCTPORTS Y NUMBER(22)
PRODUCTTRBHDR Y NUMBER(22)
PRODUCTCMDAMRSUPPORT Y NUMBER(22)
PRODUCT2WAYSLOTS Y NUMBER(22)
PRODUCTDEACMD Y NUMBER(22)
PRODUCTSRCHINITDEL Y NUMBER(22)
PRODUCTSRCHBURSTLIM Y NUMBER(22)
PRODUCTSRCHTHROTDEL Y NUMBER(22)
PRODUCTMSGCAP Y NUMBER(22)
PRODUCTBURSTCAP Y NUMBER(22)
PRODUCTMSGRECRATE Y NUMBER(22)
PRODUCTREPEATINB Y NUMBER(22)
PRODUCTREPEATRETRY Y NUMBER(22)
PRODUCTMULTIBITHAM Y NUMBER(22)
PRODUCTRETRYDELAY Y NUMBER(22)
PRODUCTSRCHMODE Y NUMBER(22)
PRODUCTSRCHTYPE Y NUMBER(22)
PRODUCTCMDDELAY1 Y NUMBER(22)
PRODUCTCMDDELAY2 Y NUMBER(22)
RCETYPE Y NUMBER(22)
MITTYPE Y NUMBER(22)
PRIMARYDATA Y NUMBER(22)
KH Y NUMBER(22)
KHMULTIPLIER Y NUMBER(22)
KHDIVISOR Y NUMBER(22)
DIALS Y NUMBER(22)
DEMANDMULTIPLIER Y NUMBER(22)
DATEFORMAT Y NUMBER(22)
VOLTAGEMULTIPLIER Y NUMBER(22)
PFMULTIPLIER Y NUMBER(22)
PEAKPFMULTIPLIER Y NUMBER(22)
INVALID_VOLTAGE_VALUE Y NUMBER(22)
SUPPORT_T20 Y NUMBER(22)
WHMULTIPLIER Y NUMBER(22)
WHDIVISOR Y NUMBER(22)

Table: PRODTYPE_CAPS
Field name Null Type Description
PRODTYPE N NUMBER(22)
FASTPOLL_FIXEDHDR Y NUMBER(22)

Table: PRODFEATUREXREF
Field name Null Type Description
PRODUCTTYPE N NUMBER(22)
PRODUCTMODEL N NUMBER(22)
FEATURESETID N NUMBER(22)
CONFIGTYPEID N NUMBER(22)

Table: PROCESSTYPE
Field name Null Type Description
PROCESSTYPE N VARCHAR2(8)
PROCESSTYPEID Y NUMBER(22)

Table: PREPAYTYPE
Field name Null Type Description
PREPAYFLAG Y NUMBER(22)
PREPAYTYPESHORTDESC Y VARCHAR2(30)
PREPAYTYPELONGDESC Y VARCHAR2(80)

Table: PLANNED_OUTAGES
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
START_DATETIME N DATE(7)
END_DATETIME N DATE(7)

Table: PHASEXREF
Field name Null Type Description
PHASENAME Y CHAR(4)
PHASENUMBER N NUMBER(22)

Table: PHASECONV
Field name Null Type Description
SUBID N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
TWACSPHASE N NUMBER(22)
CUSTOMERPHASE N NUMBER(22)

Table: PATHHRLYGRPS
Field name Null Type Description
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)
CURRHRLYGRP Y NUMBER(22)
CURRHRLYGRPCNT Y NUMBER(22)

Table: OUTDET_STATUS_DEFS
Meter status definitions from PROasys jobs.
Field name Null Type Description
STATUS_CODE N NUMBER(22) Status code, linked to OUTDET_LOG
DESCRIPTION Y VARCHAR2(25) Status of meter:
1= Offline
2=Offline Inferred
3=Indeterminate
4=Online.

Table: OUTDET_LOG
Contains a row for each meter that was checked for a job. This table stores the meters serialnumber, results of the check, the date and time the check was performed, any status codes, etc.
Field name Null Type Description
GROUPID N NUMBER(22) The unique identifier for the job.
SERIALNUMBER N NUMBER(22) The serialnumber of the meter for which the record contains the results.
SUBID N NUMBER(22) The identifier of the substation to which the meter is connected
PDD Y VARCHAR2(20)
LATEST_GROUPID N NUMBER(22)
STAMP N DATE(7) The data and time the status was acquired.
STATUS_CODE N NUMBER(22) The status of the meter. This is a foreign key into the OUTDET_STATUS_DEFS table. The values for this column are: 1=Offline, 2=Offline inferred, 3=Indeterminate, and 4 = Online.
TNS_STATUS Y NUMBER(22) The status code returned. If this is not 0 (zero), then issues with the master station prevented communications with the meter.
SCE_STATUS Y NUMBER(22) The status code returned. If this is not 0 (zero), then issues with the substation prevented communications with the meter.
RCE_STATUS Y NUMBER(22) The status code returned. If this is not 0 (zero), then the meter did not respond and is considered offline.
PREV_GROUPID N NUMBER(22)
PREV_STAMP N DATE(7)
PREV_STATUS_CODE N NUMBER(22)
PREV_TNS_STATUS Y NUMBER(22)
PREV_SCE_STATUS Y NUMBER(22)
PREV_RCE_STATUS Y NUMBER(22)
ORG_STAMP N DATE(7)
ORG_STATUS_CODE N NUMBER(22)
ORG_TNS_STATUS Y NUMBER(22)
ORG_SCE_STATUS Y NUMBER(22)
ORG_RCE_STATUS Y NUMBER(22)
NUM_ATTEMPTS Y NUMBER(22) The number of attempts made to communicate with the meter. If the communication was successful for the first time, the value will be "1". Otherwise the value gets incremented with each retry.
PLANNED_OUTAGE Y NUMBER(22) This is set to "1" if the meter is experiencing a planned outage when the communication was attempted. It is set to "0" if the outage was not planned.

Table: OUTDET_JOB_STATUS_DEFS
Field name Null Type Description
STATUS_CODE N CHAR(1)
DESCRIPTION N VARCHAR2(30)

Table: OUTDET_JOB_PARAMS
Results of PROasys jobs.
Field name Null Type Description
GROUPID N NUMBER(22) Used for restoration check. When you submit a restoration job, that job gets its own GROUPID, but the PARENT_GROUPID is set to the GROUPID of the job the restorationwas submitted from.
PARENT_GROUPID Y NUMBER(22)
EVENT_NAME Y VARCHAR2(100) The event name for this job using the event name supplied in the Input Queue.
USERNAME Y VARCHAR2(32) The identifier of the user who submitted or scheduled the job.
JOBDEFID Y NUMBER(22) If the results are from a saved job definition, this contains that job definitions unique ID. Otherwise it will be -1
DETECTION_TYPE N NUMBER(22) Detection type used for the job: 1=Blink Count, 2=voltage, 3=ping.
SELECT_SAMPLE_SIZE N NUMBER(22)
NEARBY_SAMPLE_SIZE N NUMBER(22)
TRAVERSE_NETWORK N NUMBER(22)
ALARM_BLINK_RATE Y FLOAT(22)
ALARM_LO_VOLTPERCENT Y FLOAT(22)
ALARM_HI_VOLTPERCENT Y FLOAT(22)
ALARM_POLYPHASE_VOLT_BALANCE Y FLOAT(22)
INTERRUPT_PARAM1 Y NUMBER(22)
INTERRUPT_PARAM2 Y NUMBER(22)
TIME_JOB_STARTED Y DATE(7)
TIME_JOB_ENDED Y DATE(7)
PREV_TIME_JOB_ENDED Y DATE(7)
ORG_TIME_JOB_ENDED Y DATE(7)
STATUS_CODE N CHAR(1) "S" while job is running, "U" when job is complete.
PRIORITY N NUMBER(22)
GROUP_ADDR_APPID Y VARCHAR2(8)
NUM_RETRIES Y NUMBER(22)
RETRY_DELAY Y NUMBER(22)
AUTO_RESTORATION_CHECK Y NUMBER(22)
NOTIFY_EVENT_FLAGS Y NUMBER(22)
NOTIFY_ADDRESS Y VARCHAR2(200)
EXTERNAL_MONITOR Y NUMBER(22)
AUTO_EXPORT_DAYS Y FLOAT(22)
AUTO_EXPORT_DIRECTORY Y VARCHAR2(100)
AUTO_DELETE_DAYS Y FLOAT(22)
NUM_OFFLINE Y NUMBER(22)
NUM_OFFLINE_INFERRED Y NUMBER(22)
NUM_INDETERMINATE Y NUMBER(22)
NUM_ONLINE Y NUMBER(22)
MAX_JOB_RUNTIME_HRS Y NUMBER(22)

Table: OUTDET_JOBS
Field name Null Type Description
GROUPID N NUMBER(22)
MSEXID Y NUMBER(22)
SERIALNUMBER N NUMBER(22)
SUBID N NUMBER(22)
UTILACCTID Y NUMBER(22)
PDD Y VARCHAR2(20)
PDD_DEPTH N NUMBER(22)
TIME_SUBMITTED Y DATE(7)
TIME_EXPIRES Y DATE(7)
PING_ORDER Y NUMBER(22)
PING_STATUS Y NUMBER(22)
NUM_ATTEMPTS Y NUMBER(22)
USERNAME Y VARCHAR2(32)
PDD_CHECKING Y VARCHAR2(20)
REQUEST_TYPE N NUMBER(22)
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
TWUNIT Y NUMBER(22)

Table: OUTDET_JOBNAMES
Field name Null Type Description
JOBDEFID N NUMBER(22)
JOBNAME N VARCHAR2(50)
OWNER N VARCHAR2(31)
EVENTNAME N VARCHAR2(100)
DETECTION_TYPE N NUMBER(22)
SELECT_SAMPLE N NUMBER(22)
OUTAGE_SAMPLE N NUMBER(22)
TRAVERSE_NET N CHAR(1)
INTERRUPT_PARAM1 Y NUMBER(22)
INTERRUPT_PARAM2 Y NUMBER(22)
ALARM_BLINK_RATE Y FLOAT(22)
ALARM_LO_VOLTPERCENT Y FLOAT(22)
ALARM_HI_VOLTPERCENT Y FLOAT(22)
ALARM_POLYPHASE_VOLT_BALANCE Y FLOAT(22)
JOB_PRIORITY N NUMBER(22)
GROUP_ADDR_APPID Y VARCHAR2(8)
NUM_RETRIES Y NUMBER(22)
RETRY_DELAY Y NUMBER(22)
AUTO_RESTORATION_CHECK Y NUMBER(22)
NOTIFY_EVENT_FLAGS Y NUMBER(22)
NOTIFY_ADDRESS Y VARCHAR2(200)
AUTO_DELETE_DAYS Y FLOAT(22)
AUTO_EXPORT_DAYS Y FLOAT(22)
AUTO_EXPORT_DIRECTORY Y VARCHAR2(100)
CREATE_DATE N DATE(7)
LAST_MOD_DATE N DATE(7)
INITIAL_JOB_STATE Y CHAR(1)
RESUME_JOB_OFFSET_HRS Y NUMBER(22)
RESUME_JOB_TIME_OF_DAY Y DATE(7)
MAX_JOB_RUNTIME_HRS Y NUMBER(22)

Table: OUTDET_JOBDEFS
Field name Null Type Description
JOBDEFID N NUMBER(22)
LINE_ORDER N NUMBER(22)
DEF_LINE N VARCHAR2(100)

Table: OUTCMD
Field name Null Type Description
MSEXID N NUMBER(22)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
SUBID Y NUMBER(22)
SUBEXID Y NUMBER(22)
PRIORITY Y NUMBER(22)
EXCHANGETYPEID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
STATE Y NUMBER(22)
DELTA Y NUMBER(22)
STAMP Y DATE(7)
TMOUT Y DATE(7)
REFCNT Y NUMBER(22)
COMMLINETYPE Y NUMBER(22)
SUBDROPID Y NUMBER(22)
COMMID Y NUMBER(22)
SUBCOMMBD Y NUMBER(22)
SUBCOMMPORT Y NUMBER(22)
CCEHDR Y RAW(33)
TRNSHDR Y RAW(49)
TRNSBUF1 Y RAW(255)
TRNSBUF2 Y RAW(255)
TRNSBUF3 Y RAW(255)
TRNSBUF4 Y RAW(255)
TRNSBUF5 Y RAW(255)
TRNSBUF6 Y RAW(255)
TRNSBUF7 Y RAW(255)
TRNSBUF8 Y RAW(255)

Table: OUTAGE_SUMMARY
One of the two database tables (OUTAGE_COUNTS and OUTAGE_SUMMARY) that store various details about the Universal Metering Transponders (UMTs),S4, and Sentinel transponders. These transponders are capable of acquiring greater levels of outage details than other TWACS transponders.
Field name Null Type Description
SERIALNUMBER N NUMBER(22) The serial number of the selected meter.
PHASE N NUMBER(22)
MANUALCMD_JOBNO Y NUMBER(22)
OASYS_GROUPID N NUMBER(22)
FROM_DATETIME Y DATE(7)
TO_DATETIME Y DATE(7)
OUTAGE_TYPE Y CHAR(1)
RANGEID Y NUMBER(22)
OUTAGE_COUNT Y NUMBER(22)
TNS_STATUS Y NUMBER(22)
SCE_STATUS Y NUMBER(22)
RCE_STATUS Y NUMBER(22)

Table: OUTAGE_RANGES
Field name Null Type Description
RANGEID N NUMBER(22)
MIN_MINUTES Y NUMBER(22)
MAX_MINUTES Y NUMBER(22)

Table: OUTAGE_INTJOB_XREF
Field name Null Type Description
OASYS_GROUPID N NUMBER(22)
MANUALCMD_JOBNO N NUMBER(22)
DATA_FORMAT N NUMBER(22)

Table: OUTAGE_DETAIL_FORMAT_XREF
Field name Null Type Description
DATA_FORMAT N NUMBER(22)
DESCRIP N VARCHAR2(50)

Table: OUTAGE_DETAIL_CAPS_XREF
Field name Null Type Description
CAPABILITY N NUMBER(22)
DESCRIP N VARCHAR2(20)

Table: OUTAGE_DETAIL_CAPABILITIES
Field name Null Type Description
PRODTYPE N NUMBER(22)
PRODMODEL Y NUMBER(22)
FW_VERSION_MAJOR Y NUMBER(22)
FW_VERSION_MINOR Y NUMBER(22)
CAPABILITY N NUMBER(22)
DATA_FORMAT N NUMBER(22)

Table: OUTAGE_COUNTS
One of the two database tables (OUTAGE_COUNTS and OUTAGE_SUMMARY) that store various details about the Universal Metering Transponders (UMTs),S4, and Sentinel transponders. These transponders are capable of acquiring greater levels of outage details than other TWACS transponders.
Field name Null Type Description
SERIALNUMBER N NUMBER(22) The serial number of the selected meter.
PHASE N NUMBER(22) The phase to which the outage information pertains. For three-phase meters, this will be A, B, C, or All.
MANUALCMD_JOBNO Y NUMBER(22)
OASYS_GROUPID N NUMBER(22)
FROM_DATETIME Y DATE(7) The date and time range covered by this record. For the S4 and Sentinel transponders, the From Date/Time is the last date and time a check was performed. This value is dependent on the meter capability.
TO_DATETIME N DATE(7) The date and time range covered by this record. For the S4 and Sentinel transponders. The Date/Time is the date and time of the current check. For the UMT transponders, this value can be the last 15 days worth of data. This value is dependent on the meter capability.
POWERDOWN_TOTAL Y NUMBER(22) The use of this field is for PROASYS internal use only. The blink count total when the outage details were read. For S4 and Sentinel transponders, this register is reset to zero (0) when summary data is read. This column preserves the original blink count value for the meters.
SUSTAINED_OUTAGE_COUNT Y NUMBER(22) The number of interruptions lasting five minutes or more.
MOMENTARY_EVENT_COUNT Y NUMBER(22) The number of multiple momentary interruptions..
MOMENTARY_INTERRUPT_COUNT Y NUMBER(22) The number of interruptions the transponder received that were zero to five minutes in length.
UNKNOWN_DURATION_COUNT Y NUMBER(22) The number of times the meter was on and off line before the substation could send the time sync command.
TNS_STATUS Y NUMBER(22)
SCE_STATUS Y NUMBER(22)
RCE_STATUS Y NUMBER(22)

Table: ORIGINATORXREF
Field name Null Type Description
ORIGINATORTYPEID Y NUMBER(22)
ORIGINATORTYPETEXT Y VARCHAR2(48)

Table: OPTIMUM_VOLTAGE_READS
Field name Null Type Description
INTERFACEID Y NUMBER(22)
MONITOR_ID Y NUMBER(22)
TRANSACTIONID Y VARCHAR2(128)
DETECTTIMESTAMP Y DATE(7)
LAST_CHECKED_AT Y DATE(7)
RESPONSEURL Y VARCHAR2(255)

Table: OPTIMUM_USAGE_MONITORING
Field name Null Type Description
METERNUMBER N VARCHAR2(21)
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID N NUMBER(22)
ORIGINALBILLINGCYCLE Y NUMBER(22)

Table: OPTIMUM_SERVICELOCATION_INFO
Field name Null Type Description
OBJECTID N VARCHAR2(128)
ACTIVEFLAG Y VARCHAR2(128)
BUSNAME Y VARCHAR2(128)
COMMTYPE Y VARCHAR2(128)
CONNECTDATE Y VARCHAR2(128)
CONNECTTYPE Y VARCHAR2(128)
CUSTOMERACCOUNTNUMBER Y VARCHAR2(128)
CYCLENUMBER Y VARCHAR2(128)
DETECTIONPOINT Y VARCHAR2(128)
DEVICELOCATION Y VARCHAR2(128)
DEVICETYPE Y VARCHAR2(128)
DISTRICTNUMBER Y VARCHAR2(128)
FEEDERNAME Y VARCHAR2(128)
INITIALREADING Y VARCHAR2(128)
INSTALLATIONDATEANDTIME Y VARCHAR2(128)
METERCLASS Y VARCHAR2(128)
METERNUMBER Y VARCHAR2(128)
METERSERVICELOCATION Y VARCHAR2(128)
METERTYPE Y VARCHAR2(128)
METERUSER1 Y VARCHAR2(128)
METERUSER2 Y VARCHAR2(128)
MODIFYDATEANDTIME Y VARCHAR2(128)
OFFSETREADING Y VARCHAR2(128)
OFFSETRECALCFLAG Y VARCHAR2(128)
ONEWAYDEVICEFLAG Y VARCHAR2(128)
PHASE Y VARCHAR2(128)
PORTDEVICELOCATION Y VARCHAR2(128)
PORTDISTRICTNUMBER Y VARCHAR2(128)
PORTPREMISESIDNUMBER Y VARCHAR2(128)
PORTUSER1 Y VARCHAR2(128)
PORTUSER2 Y VARCHAR2(128)
PREMISESIDNUMBER Y VARCHAR2(128)
PROTECTIVEDEVICE Y VARCHAR2(128)
RATECLASS Y VARCHAR2(128)
ROUTEID Y VARCHAR2(128)
SERIALNUMBER Y VARCHAR2(128)
SERIALPORT Y VARCHAR2(128)
SERVICELOCATIONCUSTOMER Y VARCHAR2(128)
SIGNAL Y VARCHAR2(128)
SUBSTATIONNAME Y VARCHAR2(128)
TRANSFORMERGRID Y VARCHAR2(128)
TRANSPONDERMODEL Y VARCHAR2(128)
TRANSPONDERTYPE Y VARCHAR2(128)
USER1 Y VARCHAR2(128)
USER2 Y VARCHAR2(128)
LAST_MODIFIED_AT N DATE(7)
IEDACTION Y VARCHAR2(128)
CT Y VARCHAR2(128)
VT Y VARCHAR2(128)

Table: OPTIMUM_SCADA_ANALOG
Field name Null Type Description
POINTID N VARCHAR2(255)
VALUE Y VARCHAR2(255)
UNITSID Y NUMBER(22)
QUALITYID Y NUMBER(22)
ANALOGCONDITIONID Y NUMBER(22)
TIMESTAMP Y DATE(7)
UPDATED_AT N DATE(7)

Table: OPTIMUM_QUALITY
Field name Null Type Description
ID N NUMBER(22)
NAME N VARCHAR2(255)
SHORT_NAME N VARCHAR2(8)

Table: OPTIMUM_PLANNED_OUTAGE
Field name Null Type Description
METERNUMBER N VARCHAR2(21)
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID N NUMBER(22)
START_DATE N DATE(7)
END_DATE N DATE(7)

Table: OPTIMUM_OBJECT_REFERENCE
Field name Null Type Description
METERNUMBER N VARCHAR2(21)
SERIALNUMBER N NUMBER(22)
UTILACCTID N NUMBER(22)
METER_OBJECTID Y VARCHAR2(128)
SERVICELOCATION_OBJECTID Y VARCHAR2(128)
CUSTOMER_OBJECTID Y VARCHAR2(128)
UPDATED_AT N DATE(7)

Table: OPTIMUM_METER_INFO
Field name Null Type Description
ID N NUMBER(22)
INTERFACEID N NUMBER(22)
TRANSACTIONTYPE Y VARCHAR2(128)
ACTIVEFLAG Y VARCHAR2(128)
BUSNAME Y VARCHAR2(128)
COMMTYPE Y VARCHAR2(128)
CONNECTDATE Y VARCHAR2(128)
CONNECTTYPE Y VARCHAR2(128)
CUSTOMERACCOUNTNUMBER Y VARCHAR2(128)
CYCLENUMBER Y VARCHAR2(128)
DETECTIONPOINT Y VARCHAR2(128)
DEVICELOCATION Y VARCHAR2(128)
DEVICETYPE Y VARCHAR2(128)
DISTRICTNUMBER Y VARCHAR2(128)
FEEDERNAME Y VARCHAR2(128)
INITIALREADING Y VARCHAR2(128)
INSTALLATIONDATEANDTIME Y VARCHAR2(128)
METERCLASS Y VARCHAR2(128)
METERNUMBER Y VARCHAR2(128)
METERSERVICELOCATION Y VARCHAR2(128)
METERTYPE Y VARCHAR2(128)
METERUSER1 Y VARCHAR2(128)
METERUSER2 Y VARCHAR2(128)
MODIFYDATEANDTIME Y VARCHAR2(128)
OFFSETREADING Y VARCHAR2(128)
OFFSETRECALCFLAG Y VARCHAR2(128)
ONEWAYDEVICEFLAG Y VARCHAR2(128)
PHASE Y VARCHAR2(128)
PORTDEVICELOCATION Y VARCHAR2(128)
PORTDISTRICTNUMBER Y VARCHAR2(128)
PORTPREMISESIDNUMBER Y VARCHAR2(128)
PORTUSER1 Y VARCHAR2(128)
PORTUSER2 Y VARCHAR2(128)
PREMISESIDNUMBER Y VARCHAR2(128)
PROTECTIVEDEVICE Y VARCHAR2(128)
RATECLASS Y VARCHAR2(128)
ROUTEID Y VARCHAR2(128)
SERIALNUMBER Y VARCHAR2(128)
SERIALPORT Y VARCHAR2(128)
SERVICELOCATIONCUSTOMER Y VARCHAR2(128)
SIGNAL Y VARCHAR2(128)
SUBSTATIONNAME Y VARCHAR2(128)
TRANSFORMERGRID Y VARCHAR2(128)
TRANSPONDERMODEL Y VARCHAR2(128)
TRANSPONDERTYPE Y VARCHAR2(128)
USER1 Y VARCHAR2(128)
USER2 Y VARCHAR2(128)
IEDACTION Y VARCHAR2(128)
CT Y VARCHAR2(128)
VT Y VARCHAR2(128)

Table: OPTIMUM_METER_DEFAULTS
Field name Null Type Description
ID N NUMBER(22)
ACTIVEFLAG Y VARCHAR2(128)
BUSNAME Y VARCHAR2(128)
COMMTYPE Y VARCHAR2(128)
CONNECTDATE Y VARCHAR2(128)
CONNECTTYPE Y VARCHAR2(128)
CUSTOMERACCOUNTNUMBER Y VARCHAR2(128)
CYCLENUMBER Y VARCHAR2(128)
DETECTIONPOINT Y VARCHAR2(128)
DEVICELOCATION Y VARCHAR2(128)
DEVICETYPE Y VARCHAR2(128)
DISTRICTNUMBER Y VARCHAR2(128)
FEEDERNAME Y VARCHAR2(128)
INITIALREADING Y VARCHAR2(128)
INSTALLATIONDATEANDTIME Y VARCHAR2(128)
METERCLASS Y VARCHAR2(128)
METERNUMBER Y VARCHAR2(128)
METERSERVICELOCATION Y VARCHAR2(128)
METERTYPE Y VARCHAR2(128)
METERUSER1 Y VARCHAR2(128)
METERUSER2 Y VARCHAR2(128)
MODIFYDATEANDTIME Y VARCHAR2(128)
OFFSETREADING Y VARCHAR2(128)
OFFSETRECALCFLAG Y VARCHAR2(128)
ONEWAYDEVICEFLAG Y VARCHAR2(128)
PHASE Y VARCHAR2(128)
PORTDEVICELOCATION Y VARCHAR2(128)
PORTDISTRICTNUMBER Y VARCHAR2(128)
PORTPREMISESIDNUMBER Y VARCHAR2(128)
PORTUSER1 Y VARCHAR2(128)
PORTUSER2 Y VARCHAR2(128)
PREMISESIDNUMBER Y VARCHAR2(128)
PROTECTIVEDEVICE Y VARCHAR2(128)
RATECLASS Y VARCHAR2(128)
ROUTEID Y VARCHAR2(128)
SERIALNUMBER Y VARCHAR2(128)
SERIALPORT Y VARCHAR2(128)
SERVICELOCATIONCUSTOMER Y VARCHAR2(128)
SIGNAL Y VARCHAR2(128)
SUBSTATIONNAME Y VARCHAR2(128)
TRANSFORMERGRID Y VARCHAR2(128)
TRANSPONDERMODEL Y VARCHAR2(128)
TRANSPONDERTYPE Y VARCHAR2(128)
USER1 Y VARCHAR2(128)
USER2 Y VARCHAR2(128)
IEDACTION Y VARCHAR2(128)
CT Y VARCHAR2(128)
VT Y VARCHAR2(128)

Table: OPTIMUM_DISCONNECTED_METER
Field name Null Type Description
METERNUMBER N VARCHAR2(21)
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID N NUMBER(22)
DISCONNECTED_AT Y DATE(7)

Table: OPTIMUM_CUSTOMER_INFO
Field name Null Type Description
OBJECTID N VARCHAR2(128)
ACTIVEFLAG Y VARCHAR2(128)
BUSNAME Y VARCHAR2(128)
COMMTYPE Y VARCHAR2(128)
CONNECTDATE Y VARCHAR2(128)
CONNECTTYPE Y VARCHAR2(128)
CUSTOMERACCOUNTNUMBER Y VARCHAR2(128)
CYCLENUMBER Y VARCHAR2(128)
DETECTIONPOINT Y VARCHAR2(128)
DEVICELOCATION Y VARCHAR2(128)
DEVICETYPE Y VARCHAR2(128)
DISTRICTNUMBER Y VARCHAR2(128)
FEEDERNAME Y VARCHAR2(128)
INITIALREADING Y VARCHAR2(128)
INSTALLATIONDATEANDTIME Y VARCHAR2(128)
METERCLASS Y VARCHAR2(128)
METERNUMBER Y VARCHAR2(128)
METERSERVICELOCATION Y VARCHAR2(128)
METERTYPE Y VARCHAR2(128)
METERUSER1 Y VARCHAR2(128)
METERUSER2 Y VARCHAR2(128)
MODIFYDATEANDTIME Y VARCHAR2(128)
OFFSETREADING Y VARCHAR2(128)
OFFSETRECALCFLAG Y VARCHAR2(128)
ONEWAYDEVICEFLAG Y VARCHAR2(128)
PHASE Y VARCHAR2(128)
PORTDEVICELOCATION Y VARCHAR2(128)
PORTDISTRICTNUMBER Y VARCHAR2(128)
PORTPREMISESIDNUMBER Y VARCHAR2(128)
PORTUSER1 Y VARCHAR2(128)
PORTUSER2 Y VARCHAR2(128)
PREMISESIDNUMBER Y VARCHAR2(128)
PROTECTIVEDEVICE Y VARCHAR2(128)
RATECLASS Y VARCHAR2(128)
ROUTEID Y VARCHAR2(128)
SERIALNUMBER Y VARCHAR2(128)
SERIALPORT Y VARCHAR2(128)
SERVICELOCATIONCUSTOMER Y VARCHAR2(128)
SIGNAL Y VARCHAR2(128)
SUBSTATIONNAME Y VARCHAR2(128)
TRANSFORMERGRID Y VARCHAR2(128)
TRANSPONDERMODEL Y VARCHAR2(128)
TRANSPONDERTYPE Y VARCHAR2(128)
USER1 Y VARCHAR2(128)
USER2 Y VARCHAR2(128)
LAST_MODIFIED_AT N DATE(7)
IEDACTION Y VARCHAR2(128)
CT Y VARCHAR2(128)
VT Y VARCHAR2(128)

Table: OPTIMUM_CD_STATE_CHANGES
Field name Null Type Description
METERNUMBER N VARCHAR2(21)
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID N NUMBER(22)
CDSERIALNUMBER Y NUMBER(22)
GROUPID N NUMBER(22)
INITIATECDTIME N DATE(7)
LOADACTION N VARCHAR2(32)
INTERFACEID N NUMBER(22)
TRANSACTIONID Y VARCHAR2(128)
RESPONSEURL Y VARCHAR2(255)
CDSERIALPORT N NUMBER(22)

Table: OPTIMUM_APPLPOINT_SUBSTATIONS
Field name Null Type Description
APPID N NUMBER(22)
SUBID N NUMBER(22)

Table: OPTIMUM_APPLICATIONPOINT
Field name Null Type Description
ID N NUMBER(22)
NAME N VARCHAR2(255)

Table: OPTIMUM_ANALOGCONDITION
Field name Null Type Description
ID N NUMBER(22)
NAME N VARCHAR2(255)

Table: ONEWAYASSIGNMENT
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
CLASS_NAME N VARCHAR2(9)
X N NUMBER(22)
Y N NUMBER(22)
SUBGROUP N NUMBER(22)
ASSIGN_STATUS Y NUMBER(22)

Table: OMUPARMS
Field name Null Type Description
SUBID N NUMBER(22)
OMUID N NUMBER(22)
FIREANGLEA Y NUMBER(22)
FIREANGLEB Y NUMBER(22)
FIREANGLEC Y NUMBER(22)
FIREANGLEAB Y NUMBER(22)
FIREANGLEBC Y NUMBER(22)
FIREANGLECA Y NUMBER(22)
EQUIPTYPEID Y NUMBER(22)
RESERVED1 Y NUMBER(22)
RESERVED2 Y NUMBER(22)
RESERVED3 Y NUMBER(22)

Table: OMUMAP
Field name Null Type Description
SUBID N NUMBER(22)
BUSID N NUMBER(22)
OMUID N NUMBER(22)
EQUIPTYPEID Y NUMBER(22)

Table: ODMARM_INPQ_20140605
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: ODMARM_INPQ
The Input Queue commands enable third party software to interface with PROasys. More information can be found on page 2 of the PROasys Third-Party Interface Technical Manual
Field name Null Type Description
SUBSYSID Y NUMBER(22) The TNS Subsystem issuing the command. Enter a value of 5 for PROasys.
PRIORITY Y NUMBER(22) The priority at which the commands should execute.
STAMP Y DATE(7) The timestamp of the command. Use SYSDATE for the current date and time
USERNAME Y VARCHAR2(32) This can be any user identifier. PROasys uses the Oracle username.
GROUPID Y NUMBER(22) A unique identifier for the job. All commands in the same batch (Start, Add, Close) must have the same GROUPID. The Oracle sequence SEQ_ODMARMGRP is used to generate unique GROUPIDs.
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255) The text of the command.

Table: ODECLLS
Field name Null Type Description
METERCUSTOMERACCTNUM Y VARCHAR2(21)

Table: OASYS_ALARMS
Alarms created by PROasys
Field name Null Type Description
SERIALNUMBER N NUMBER(22) The Serialnumber of device reporting alarm.
FIRST_ALARM_DATE N DATE(7)
LAST_ALARM_DATE N DATE(7)
CLEAR_ALARM_DATE Y DATE(7)
NUM_ALARMS Y NUMBER(22)
LAST_ALARM_GROUPID Y NUMBER(22)
ALARM_TYPE N CHAR(1)

Table: NOTIFICATIONS
Field name Null Type Description
DATETIME Y DATE(7)
SUBID Y NUMBER(22)
SUBNAME Y VARCHAR2(25)
NOTTYPE Y NUMBER(22)
NOTID Y NUMBER(22)
NOTDATA Y VARCHAR2(50)
NOTDATA1 Y NUMBER(22)
NOTDATA2 Y NUMBER(22)
NOTDATA3 Y NUMBER(22)
NOTDATA4 Y NUMBER(22)
NOTDATA5 Y NUMBER(22)
NOTDATA6 Y NUMBER(22)
NOTDATA7 Y NUMBER(22)
NOTDATA8 Y NUMBER(22)
NOTDATAV1 Y NUMBER(22)
NOTDATAV2 Y NUMBER(22)
NOTDATALV1 Y NUMBER(22)
NOTDATAB1 Y NUMBER(22)
NOTDATAB2 Y NUMBER(22)
NOTDATAB3 Y NUMBER(22)
NOTDATAB4 Y NUMBER(22)
NOTDATAB5 Y NUMBER(22)
NOTDATAB6 Y NUMBER(22)
NOTDATAB7 Y NUMBER(22)
NOTDATAB8 Y NUMBER(22)
NOTDATAB11 Y NUMBER(22)
NOTDATAB12 Y NUMBER(22)
NOTDATAB13 Y NUMBER(22)
NOTDATAB14 Y NUMBER(22)
NOTDATAB15 Y NUMBER(22)
NOTDATAB16 Y NUMBER(22)
NOTDATAB17 Y NUMBER(22)
NOTDATAB18 Y NUMBER(22)

Table: NOTDEFXREF
Field name Null Type Description
NOTID N NUMBER(22)
NOTTYPE Y NUMBER(22)
NOTTYPENAME Y VARCHAR2(8)
NOTNAME Y VARCHAR2(50)
NOTCOLOR Y VARCHAR2(16)

Table: NAMEDCFG
Field name Null Type Description
NAMEDCFGID N NUMBER(22)
NAMEDCFGTEXT Y VARCHAR2(255)
CONFIGTYPEID N NUMBER(22)

Table: MSPEAKOUTAGEDETECTION
Field name Null Type Description
INTERFACEID Y NUMBER(22)
MONITOR_ID Y NUMBER(22)
OASYS_JOB Y NUMBER(22)
METERNUMBER Y VARCHAR2(32)
TRANSACTIONID Y VARCHAR2(128)
DETECTTIMESTAMP Y DATE(7)
LAST_CHECKED_AT Y DATE(7)
RESPONSEURL Y VARCHAR2(128)

Table: MSPEAKONDEMANDREADS
Field name Null Type Description
ID Y NUMBER(22)
INTERFACEID Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
METERNUMBER Y VARCHAR2(21)
METERCONVMIT Y NUMBER(22)
REQUESTED_AT Y DATE(7)
READTYPE Y NUMBER(22)
TRANSACTIONID Y VARCHAR2(128)
RESPONSEURL Y VARCHAR2(255)

Table: MSPEAKLOG
Field name Null Type Description
USERID Y VARCHAR2(24)
REQUESTADDRESS Y VARCHAR2(15)
METHODNAME Y VARCHAR2(64)
DESCRIPTION Y VARCHAR2(128)
TIMESTAMP Y DATE(7)
LOGTYPE Y VARCHAR2(24)
LOGLEVEL Y NUMBER(22)

Table: MSPEAKINTERFACES_BACKUP
Field name Null Type Description
COMPANY Y VARCHAR2(32)
COMPANYURL Y VARCHAR2(128)
APPNAME Y VARCHAR2(32)
APPVERSION Y VARCHAR2(32)
LATESTREADING Y NUMBER(22)
RTNUSERID Y VARCHAR2(32)
RTNPWD Y VARCHAR2(32)
RTNCOMPANY Y VARCHAR2(32)
RTNAPPNAME Y VARCHAR2(32)
RTNAPPVERSION Y VARCHAR2(32)
READINGFRESHNESS Y NUMBER(22)
READINGTIMEOUT Y NUMBER(22)
INTERFACEID Y NUMBER(22)
USERID Y VARCHAR2(32)
PWD Y VARCHAR2(32)

Table: MSPEAKINTERFACES
Field name Null Type Description
COMPANY Y VARCHAR2(32)
COMPANYURL Y VARCHAR2(128)
APPNAME Y VARCHAR2(32)
APPVERSION Y VARCHAR2(32)
LATESTREADING Y NUMBER(22)
RTNUSERID Y VARCHAR2(32)
RTNPWD Y VARCHAR2(32)
RTNCOMPANY Y VARCHAR2(32)
RTNAPPNAME Y VARCHAR2(32)
RTNAPPVERSION Y VARCHAR2(32)
READINGFRESHNESS N NUMBER(22)
READINGTIMEOUT N NUMBER(22)
INTERFACEID N NUMBER(22)
USERID Y VARCHAR2(32)
PWD Y VARCHAR2(32)
UTILACCTID Y NUMBER(22)
VALIDATERESPONSEURL Y NUMBER(22)
RESPONDTOINITMETHODS Y NUMBER(22)
GETLATESTONREQUEST N NUMBER(22)

Table: MSPEAKCONFIG
Field name Null Type Description
CONFIGID N NUMBER(22)
VALIDATEHEADER Y NUMBER(22)
LOGLEVEL Y NUMBER(22)

Table: MSPEAKBILLCYCLERSLV
Field name Null Type Description
BCYCLENUMBER Y NUMBER(22)
BCYCLESTRING Y VARCHAR2(16)

Table: MSGXREF
Field name Null Type Description
SUBSYSID N NUMBER(22)
MSGID N NUMBER(22)
MSGTEXT Y CHAR(80)

Table: MSGSVR_INPQ_HOLD
Field name Null Type Description
ID Y NUMBER(22)
PROTOCOLID Y NUMBER(22)
STAMP Y DATE(7)
CATEGORYID Y NUMBER(22)
SEVERITYID Y NUMBER(22)
SUBJECT Y VARCHAR2(255)
BODY Y VARCHAR2(1000)

Table: MSGSVR_INPQ
Field name Null Type Description
ID N NUMBER(22)
PROTOCOLID Y NUMBER(22)
STAMP Y DATE(7)
CATEGORYID Y NUMBER(22)
SEVERITYID Y NUMBER(22)
SUBJECT Y VARCHAR2(255)
BODY Y VARCHAR2(1000)

Table: MSGSVRTOADDR
Field name Null Type Description
CATEGORYID Y NUMBER(22)
SEVERITYID Y NUMBER(22)
DISPLAYNAME Y VARCHAR2(40)
ADDRESS Y VARCHAR2(75)

Table: MSGSVRSEVERITIES
Field name Null Type Description
ID N NUMBER(22)
SHORTDESC Y VARCHAR2(10)
LONGDESC Y VARCHAR2(40)

Table: MSGSVRRECIP
Field name Null Type Description
ID N NUMBER(22)
DISPLAYNAME Y VARCHAR2(40)
ADDRESS Y VARCHAR2(75)

Table: MSGSVRPROTOCOLS
Field name Null Type Description
ID N NUMBER(22)
SHORTDESC Y VARCHAR2(10)
LONGDESC Y VARCHAR2(40)

Table: MSGSVRFROMADDR
Field name Null Type Description
CATEGORYID Y NUMBER(22)
SEVERITYID Y NUMBER(22)
DISPLAYNAME Y VARCHAR2(40)
ADDRESS Y VARCHAR2(75)

Table: MSGSVRCATEGORIES
Field name Null Type Description
ID N NUMBER(22)
SHORTDESC Y VARCHAR2(10)
LONGDESC Y VARCHAR2(40)

Table: MITUPLOADCONFIG
Field name Null Type Description
MITTYPEID Y NUMBER(22)
PRIMARYDATA Y NUMBER(22)
PRIMARYNAME Y VARCHAR2(10)
UPLOADCMDSEQNUM Y NUMBER(22)
UPLOADCMDORDER Y NUMBER(22)
UPLOADCMDBLOCK Y NUMBER(22)
UPLOADCMDOFFSET Y NUMBER(22)
UPLOADCMDADDR Y RAW(4)
UPLOADCMDLENGTH Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)

Table: MITTYPE
Field name Null Type Description
MITTYPEID Y NUMBER(22)
MITTYPENAME Y VARCHAR2(18)
MITTYPEPSWDTEXT Y VARCHAR2(10)
MITTYPEPSWDHEX Y RAW(11)
MITTYPEENCRYPT Y NUMBER(22)
MITTYPELONGNAME Y VARCHAR2(62)

Table: MITRDBUFFCONFIG
Field name Null Type Description
MITTYPEID Y NUMBER(22)
PRIMARYDATA Y NUMBER(22)
PRIMARYNAME Y VARCHAR2(10)
RDBUFFCMDSEQNUM Y NUMBER(22)
RDBUFFCMDOFFSET Y NUMBER(22)
RDBUFFCMDLENGTH Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)

Table: MITLPSUPPORT
Field name Null Type Description
MITTYPEID Y NUMBER(22)
MITTYPENAME Y VARCHAR2(18)

Table: MITCMDSUMMARY
Field name Null Type Description
MITTYPEID Y NUMBER(22)
PRIMARYDATA Y NUMBER(22)
PRIMARYNAME Y VARCHAR2(10)
NUMBERUPLOADCMD Y NUMBER(22)
NUMBERRDBUFFCMD Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)

Table: MITCMDPARAM
Field name Null Type Description
MITTYPEID Y NUMBER(22)
PRIMARYDATA Y NUMBER(22)
PRIMARYNAME Y VARCHAR2(10)
DATANAMEID Y NUMBER(22)
DATASHORTNAME Y VARCHAR2(8)
DATANAME Y VARCHAR2(30)
DATABLOCK Y NUMBER(22)
DATAOFFSET Y NUMBER(22)
DATAADDRESSRAW Y RAW(4)
DATAADDRESSINT Y NUMBER(22)
DATALENGTH Y NUMBER(22)
DATASELECT Y NUMBER(22)
RDBUFFSEQ Y NUMBER(22)
DATATYPE Y NUMBER(22)
DATAEXTRA Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)
DATATYPEID Y NUMBER(22)
CONVID Y NUMBER(22)
MULTIPLIER Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y NUMBER(22)

Table: METRSP_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: METER_VOLTAGE_READINGS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
READ_TIME N DATE(7)
VOLTAGE_PHASE_A Y NUMBER(22)
VOLTAGE_PHASE_B Y NUMBER(22)
VOLTAGE_PHASE_C Y NUMBER(22)

Table: METER_NOMINAL_VOLTAGE
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
NOMINAL_VOLTAGE N NUMBER(22)
NUM_PHASES Y NUMBER(22)
NOMINAL_VOLTAGE_B Y NUMBER(22)
NOMINAL_VOLTAGE_C Y NUMBER(22)

Table: METER_LOCATIONS
Contains the X and Y coordinates of meters, indexed by SERIALNUMBER
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
MAP_LOC_X Y FLOAT(22)
MAP_LOC_Y Y FLOAT(22)

Table: METER_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: METER_BLINK_COUNTS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
READ_TIME N DATE(7)
BLINK_COUNT N NUMBER(22)

Table: METERXREF
Field name Null Type Description
TABLEID Y NUMBER(22)
TABLEKEY Y NUMBER(22)
METERXREFSHORTDESC Y VARCHAR2(30)
METERXREFLONGDESC Y VARCHAR2(80)

Table: METERTCRESPONSELOG
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
USERNAME Y VARCHAR2(32)
METERRESPCUSTOMERACCTNUM Y VARCHAR2(21)
METERTCRESPCURDATETIME Y DATE(7)
METERTCRESPREADTYPE Y NUMBER(22)
METERTCSTATUSTNS Y NUMBER(22)
METERTCSTATUSSCE Y NUMBER(22)
METERTCSTATUSRCE Y NUMBER(22)
METERTCRESPQUALITYCODE Y NUMBER(22)
METERTCRESPTOTALCONSUMPT Y NUMBER(22)
METERTCRESPUNITS Y NUMBER(22)
METERTCRESPREADDT Y DATE(7)
METERTCRESPQUALITYFLAG1 Y NUMBER(22)
METERTCRESPQUALITYFLAG2 Y NUMBER(22)
METERTCRESPQUALITYFLAG3 Y NUMBER(22)
METERTCRESPQUALITYFLAG4 Y NUMBER(22)

Table: METERSHIFTSCH
Field name Null Type Description
UTILACCTID Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)
METERRATECLASSTOUSCH1 Y VARCHAR2(18)
METERRATECLASSTOUSCH2 Y VARCHAR2(18)
METERRATECLASSTOUSCH3 Y VARCHAR2(18)
METERRATECLASSTOUWEEKSCH1 Y VARCHAR2(18)
METERRATECLASSDEMINTID Y NUMBER(22)
METERRATECLASSDEMSUBINTID Y NUMBER(22)
METERRATECLASSOUTDUR Y NUMBER(22)
METERRATECLASSFORDUR Y NUMBER(22)

Table: METERRATECLASS
Field name Null Type Description
UTILACCTID Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)
METERRATECLASSTC Y NUMBER(22)
METERRATECLASSTD Y NUMBER(22)
METERRATECLASSTOU Y NUMBER(22)
METERRATECLASSDEM Y NUMBER(22)
METERRATECLASSCP Y NUMBER(22)

Table: METERPRIORITY
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
PRIORITYDELTA N NUMBER(22)

Table: METERMITRESPONSELOGDATA
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
UTILACCTID Y NUMBER(22)
GROUPID Y NUMBER(22)
METERMITPRISEC Y NUMBER(22)
METERMITSEQNO Y NUMBER(22)
METERMITREADDT Y DATE(7)
METERMITSTATUSTNS Y NUMBER(22)
METERMITSTATUSSCE Y NUMBER(22)
METERMITSTATUSRCE Y NUMBER(22)
METERMITQUALITYCODE Y NUMBER(22)
METERMITDATA1ID Y NUMBER(22)
METERMITDATA1 Y NUMBER(22)
METERMITDATA2ID Y NUMBER(22)
METERMITDATA2 Y NUMBER(22)
METERMITDATA3ID Y NUMBER(22)
METERMITDATA3 Y NUMBER(22)
METERMITDATA4ID Y NUMBER(22)
METERMITDATA4 Y NUMBER(22)
METERMITDATA5ID Y NUMBER(22)
METERMITDATA5 Y NUMBER(22)
METERMITDATA6ID Y NUMBER(22)
METERMITDATA6 Y NUMBER(22)
METERMITDEMRESETID Y NUMBER(22)
METERMITDEMRESET Y NUMBER(22)
METERMITQUALITYFLAG1 Y NUMBER(22)
METERMITQUALITYFLAG2 Y NUMBER(22)
METERMITQUALITYFLAG3 Y NUMBER(22)
METERMITQUALITYFLAG4 Y NUMBER(22)

Table: METERMITRESPONSELOG
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
UTILACCTID Y NUMBER(22)
GROUPID Y NUMBER(22)
USERNAME Y VARCHAR2(32)
METERCUSTOMERACCTNUM Y VARCHAR2(21)
METERMITREADTYPE Y NUMBER(22)
METERMITREADIND Y NUMBER(22)
METERMITCMDTYPE Y NUMBER(22)
METERMITSTATUSTNS Y NUMBER(22)
METERMITSTATUSSCE Y NUMBER(22)
METERMITSTATUSRCE Y NUMBER(22)
METERMITQUALITYCODE Y NUMBER(22)
MITPRIMARYDONE Y NUMBER(22)
MITSECONDARYDONE Y NUMBER(22)

Table: METERINTERVALINIT
Field name Null Type Description
UTILACCTID Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
PREVINTERVAL Y NUMBER(22)
INTERVALINITDATE Y DATE(7)
INTERVALINITSTATE Y NUMBER(22)
INITSTATUSTNS Y NUMBER(22)
INITSTATUSSCE Y NUMBER(22)
INITSTATUSRCE Y NUMBER(22)

Table: METERINGQCSTATUS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
TWFUNC N NUMBER(22)
TWGROUP N NUMBER(22)
TWUNIT N NUMBER(22)
SERIALPORT N NUMBER(22)
READDATE N DATE(7)
UTILACCTID N NUMBER(22)
QUALITYCODE N NUMBER(22)
AMRREADIND N NUMBER(22)
AMRCALJOBNO N NUMBER(22)
MSEXCHANGEID Y NUMBER(22)
CMDLSTSETID Y VARCHAR2(32)
CMDLSTSETVALUE Y VARCHAR2(32)
AMRMIT Y NUMBER(22)

Table: METERDEMANDRESPONSELOG
Field name Null Type Description
UTILACCTID Y NUMBER(22)
USERNAME Y VARCHAR2(32)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
METERCUSTOMERACCTNUM Y VARCHAR2(21)
METERREADTYPE Y NUMBER(22)
METERREADIND Y NUMBER(22)
METERDEMREADDT Y DATE(7)
METERDEMSTATUSTNS Y NUMBER(22)
METERDEMSTATUSSCE Y NUMBER(22)
METERDEMSTATUSRCE Y NUMBER(22)
METERDEMQUALITYCODE Y NUMBER(22)
METERDEMANDCURRENT Y NUMBER(22)
METERDEMANDPREVIOUS Y NUMBER(22)

Table: METERCONV
Field name Null Type Description
UTILACCTID N NUMBER(22)
METERTYPE N VARCHAR2(11)
METERCONVDIALS Y NUMBER(22)
METERCONVKR Y NUMBER(22)
METERCONVKH Y NUMBER(22)
METERCONVMPN Y NUMBER(22)
METERCONVMPD Y NUMBER(22)
METERCONVDWNLROVER Y NUMBER(22)
METERCONVMIT Y NUMBER(22)
METERCONVUM Y VARCHAR2(12)
METERCONVINITENABLE Y NUMBER(22)
METERCONVSHIFT Y NUMBER(22)
METERCONVDIVISOR Y NUMBER(22)
METERCONVDPLOC Y NUMBER(22)
METERCONVDPLOCD Y NUMBER(22)
SERVICETYPEID Y NUMBER(22)
INTERFACETYPEID Y NUMBER(22)
MITTYPEID Y NUMBER(22)
DEMMULTIPLIER Y NUMBER(22)
DEMRNDORTRNC Y NUMBER(22)

Table: METERCONSUMPSUMMARY
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
CURRAMRDATE Y DATE(7)
CURRAMRTC Y NUMBER(22)
CURRAMRJOBNO Y NUMBER(22)
CURRQUALITYCODE Y NUMBER(22)
PREVAMRDATE Y DATE(7)
PREVAMRTC Y NUMBER(22)
PREVAMRJOBNO Y NUMBER(22)
PREVQUALITYCODE Y NUMBER(22)
CONSUMP_STRATEGY_ID Y NUMBER(22)
NUMNEGLIMEXCEEDED N NUMBER(22)
NUMLLIMEXCEEDED N NUMBER(22)
NUMULIMEXCEEDED N NUMBER(22)
CHECKREADINGS N NUMBER(22)

Table: METERCONSUMPSTRATEGIES
Field name Null Type Description
STRATEGY_ID N NUMBER(22)
STRATEGY_NAME Y VARCHAR2(50)
MONITORPERIOD Y NUMBER(22)
LOWERLIMIT Y NUMBER(22)
ALARMEXCEEDLLIMITS N NUMBER(22)
UPPERLIMIT Y NUMBER(22)
ALARMEXCEEDULIMITS N NUMBER(22)
DATE_CREATED Y DATE(7)
DATE_MODIFIED Y DATE(7)

Table: METERCONSUMPALARMS_TEMP
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT Y NUMBER(22)
NEGAMRJOBNO Y NUMBER(22)
NEGTCDELTA Y NUMBER(22)
NEGTIMEDELTAHOURS Y NUMBER(22)
LOAMRJOBNO Y NUMBER(22)
LOTCDELTA Y NUMBER(22)
LOTIMEDELTAHOURS Y NUMBER(22)
HIAMRJOBNO Y NUMBER(22)
HITCDELTA Y NUMBER(22)
HITIMEDELTAHOURS Y NUMBER(22)
LAST_ALARM_DATETIME Y DATE(7)
LAST_ALARM_TYPE Y CHAR(1)

Table: METERCONSUMPALARMS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
NEGAMRJOBNO Y NUMBER(22)
NEGTCDELTA Y NUMBER(22)
NEGTIMEDELTAHOURS Y NUMBER(22)
LOAMRJOBNO Y NUMBER(22)
LOTCDELTA Y NUMBER(22)
LOTIMEDELTAHOURS Y NUMBER(22)
HIAMRJOBNO Y NUMBER(22)
HITCDELTA Y NUMBER(22)
HITIMEDELTAHOURS Y NUMBER(22)
LAST_ALARM_DATETIME Y DATE(7)
LAST_ALARM_TYPE Y CHAR(1)

Table: METERCONALTSTRATLOOKUP
Field name Null Type Description
METHOD N NUMBER(22)
SET_ID N NUMBER(22)
STRATEGY_ID N NUMBER(22)

Table: METERCFGHISTORY
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
CONFIGTYPEID N NUMBER(22)
CURRENTNAMEDCFGID Y NUMBER(22)
PREVNAMEDCFGID Y NUMBER(22)
CONFIGSTATE Y NUMBER(22)
USERID Y VARCHAR2(30)
JOBID Y NUMBER(22)
CONFIGDATE Y DATE(7)
CCESTATUS Y NUMBER(22)
SCESTATUS Y NUMBER(22)
RCESTATUS Y NUMBER(22)

Table: METERCFGACCTS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
CONFIGTYPEID N NUMBER(22)
CURRENTNAMEDCFGID Y NUMBER(22)
PENDINGNAMEDCFGID Y NUMBER(22)
CONFIGSTATE Y NUMBER(22)
USERID Y VARCHAR2(30)
CONFIGDATE Y DATE(7)

Table: METERACCTSTC
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
USERNAME Y VARCHAR2(32)
METERCUSTOMERACCTNUM Y VARCHAR2(21)
METERTCCURDATETIME Y DATE(7)
METERTCREADTYPE Y NUMBER(22)
METERTCSTATUSTNS Y NUMBER(22)
METERTCSTATUSSCE Y NUMBER(22)
METERTCSTATUSRCE Y NUMBER(22)
METERTCQUALITYCODE Y NUMBER(22)
METERTCTOTALCONSUMPT Y NUMBER(22)
METERTCUNITS Y NUMBER(22)
METERTCREADDT Y DATE(7)
METERTCQUALITYFLAG1 Y NUMBER(22)
METERTCQUALITYFLAG2 Y NUMBER(22)
METERTCQUALITYFLAG3 Y NUMBER(22)
METERTCQUALITYFLAG4 Y NUMBER(22)
METERTCOFFSETREAD Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)
REVMETERTCTOTALCONSUMPT Y NUMBER(22)

Table: METERACCTSMITLP
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
UTILACCTID Y NUMBER(22)
METERCUSTOMERACCTNUM Y VARCHAR2(21)
METERMITLPCHANNEL Y NUMBER(22)
METERMITLPINTERVAL Y NUMBER(22)
METERMITLPDATALENGTH Y NUMBER(22)
METERMITLPDATA Y VARCHAR2(591)
AMRCALJOBNO Y NUMBER(22)

Table: METERACCTSMIT
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
UTILACCTID Y NUMBER(22)
USERNAME Y VARCHAR2(32)
METERCUSTOMERACCTNUM Y VARCHAR2(21)
METERMITREADTYPE Y NUMBER(22)
METERMITPRISEC Y NUMBER(22)
METERMITSEQNO Y NUMBER(22)
METERMITREADDT Y DATE(7)
METERMITSTATUSTNS Y NUMBER(22)
METERMITSTATUSSCE Y NUMBER(22)
METERMITSTATUSRCE Y NUMBER(22)
METERMITQUALITYCODE Y NUMBER(22)
METERMITDATA1ID Y NUMBER(22)
METERMITDATA1 Y NUMBER(22)
METERMITDATA2ID Y NUMBER(22)
METERMITDATA2 Y NUMBER(22)
METERMITDATA3ID Y NUMBER(22)
METERMITDATA3 Y NUMBER(22)
METERMITDATA4ID Y NUMBER(22)
METERMITDATA4 Y NUMBER(22)
METERMITDATA5ID Y NUMBER(22)
METERMITDATA5 Y NUMBER(22)
METERMITDATA6ID Y NUMBER(22)
METERMITDATA6 Y NUMBER(22)
METERMITDEMRESETID Y NUMBER(22)
METERMITDEMRESET Y NUMBER(22)
METERMITQUALITYFLAG1 Y NUMBER(22)
METERMITQUALITYFLAG2 Y NUMBER(22)
METERMITQUALITYFLAG3 Y NUMBER(22)
METERMITQUALITYFLAG4 Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)
METERMITCURRDATETIME Y DATE(7)

Table: METERACCTSILS
Field name Null Type Description
UTILACCTID Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
METERILSREADDT Y DATE(7)
METERILSQC Y NUMBER(22)
METERILSQCDESC Y VARCHAR2(4)
METERILSDELTA Y NUMBER(22)

Table: METERACCTSDEMAND
Field name Null Type Description
UTILACCTID Y NUMBER(22)
USERNAME Y VARCHAR2(32)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
METERCUSTOMERACCTNUM Y VARCHAR2(21)
METERREADTYPE Y NUMBER(22)
METERREADIND Y NUMBER(22)
METERDEMREADDT Y DATE(7)
METERDEMSTATUSTNS Y NUMBER(22)
METERDEMSTATUSSCE Y NUMBER(22)
METERDEMSTATUSRCE Y NUMBER(22)
METERDEMQUALITYCODE Y NUMBER(22)
METERDAILYTOTALCONSUMPT Y NUMBER(22)
METERBEFORERESETCOUNT Y NUMBER(22)
METERDEMANDCURRENT Y NUMBER(22)
METERDEMANDPREVIOUS Y NUMBER(22)
METERDEMANDRESETCOUNT Y NUMBER(22)
METERDEMANDPREVIOUSDT Y DATE(7)
METERDEMGROUPID Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)

Table: METERACCTS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
METERCUSTOMERACCTNUM Y VARCHAR2(21)
METERRATECLASS Y VARCHAR2(9)
METERTYPE Y VARCHAR2(11)
METERNUMBER Y VARCHAR2(21)
METERROUTEID Y VARCHAR2(9)
METERCYCLENUMBER Y NUMBER(22)
METERINITIALREAD Y NUMBER(22)
METEROFFSETREAD Y NUMBER(22)
METEROFFSET Y NUMBER(22)
METEROFFSETRECALC Y NUMBER(22)
METERCLASS Y NUMBER(22)
METERINITSTATE Y NUMBER(22)
METERINITRETRY Y NUMBER(22)
METERUSER1 Y VARCHAR2(17)
METERUSER2 Y VARCHAR2(17)
CT Y NUMBER(22)
VT Y NUMBER(22)

Table: MANUALCMD_INPQ
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
OPCODE Y NUMBER(22)
READIND Y VARCHAR2(20)
SETID1 Y VARCHAR2(55)
SETVALUE1 Y VARCHAR2(55)
SETID2 Y VARCHAR2(55)
SETVALUE2 Y VARCHAR2(55)
APPID Y VARCHAR2(55)
REGISTER1 Y VARCHAR2(2000)
REGLENGTH1 Y VARCHAR2(5)
REGDATA1 Y VARCHAR2(12)
REGISTER2 Y VARCHAR2(5)
REGLENGTH2 Y VARCHAR2(5)
REGDATA2 Y VARCHAR2(12)
REGISTER3 Y VARCHAR2(5)
REGLENGTH3 Y VARCHAR2(5)
REGDATA3 Y VARCHAR2(12)
JOBNO Y NUMBER(22)
MSEXID Y NUMBER(22)
RETRYCNT Y NUMBER(22)
RETRYDELAY Y NUMBER(22)

Table: MANUALCMDDATA2WAY
Field name Null Type Description
JOBNO N NUMBER(22)
SERIALNUMBER N NUMBER(22)

Table: MANUALCMDDATA
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT Y NUMBER(22)
READDATE Y DATE(7)
QUALITYCODE Y NUMBER(22)
OPCODE Y VARCHAR2(30)
REGISTER1 Y NUMBER(22)
REGDATA1 Y VARCHAR2(50)
REGISTER2 Y NUMBER(22)
REGDATA2 Y VARCHAR2(50)
REGISTER3 Y NUMBER(22)
REGDATA3 Y VARCHAR2(50)
REGISTER4 Y NUMBER(22)
REGDATA4 Y VARCHAR2(50)
JOBNO N NUMBER(22)
APPID Y VARCHAR2(30)
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
TWUNIT Y NUMBER(22)
TNSSTATUS Y NUMBER(22)
SCESTATUS Y NUMBER(22)
RCESTATUS Y NUMBER(22)
RETRIESDONE Y NUMBER(22)
RETRYTIMES Y NUMBER(22)
RETRYDELAY Y NUMBER(22)
SIGNALSTRENGTH Y VARCHAR2(5)
WINDOWSHIFT Y VARCHAR2(5)
RCEQUALITY Y VARCHAR2(5)
METHODSTATUS Y VARCHAR2(5)
RCE_HEX_DATA_OUT Y VARCHAR2(200)
RCE_HEX_DATA_IN Y VARCHAR2(200)

Table: LPSCALOR
Field name Null Type Description
LPINTERVAL Y NUMBER(22)
LPCHANNELS Y NUMBER(22)
LPSCALEFACTOR Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)

Table: LPCONFIG
Field name Null Type Description
NUMOFCHANNELS Y NUMBER(22)
LPINTERVAL Y NUMBER(22)
DAYSOFLPDATA Y NUMBER(22)
LPMEMORYALLOCATE Y NUMBER(22)
NUMOFBYTEPERDAY Y NUMBER(22)
NUMOFCLASSREADPERDAY Y NUMBER(22)
NUMOFTWACSREADPERDAY Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)

Table: LPCMDSUMMARY
Field name Null Type Description
MITTYPEID Y NUMBER(22)
PRIMARYDATA Y NUMBER(22)
PRIMARYNAME Y VARCHAR2(10)
UPLOADCMDSEQNUM Y NUMBER(22)
RDBUFFCMDTOTAL Y NUMBER(22)
RDBUFFCMDSTART Y NUMBER(22)
RDBUFFCMDEND Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)

Table: LMSC_INPQ
Field name Null Type Description
STRATID N NUMBER(22)
COMMAND N VARCHAR2(4000)
SUBID Y NUMBER(22)
DURATION Y NUMBER(22)
STARTTIME Y DATE(7)
GROUPID Y NUMBER(22)
EXT_ID Y VARCHAR2(4000)

Table: LMSC_ACTIVATION_LOG
Field name Null Type Description
SERVICE Y VARCHAR2(256)
USERNAME Y VARCHAR2(256)
SENTTIME Y TIMESTAMP(6)(11)
EXPIRATIONTIME Y TIMESTAMP(6)(11)
DURATION Y NUMBER(22)
GROUPID Y NUMBER(22)
STRATID Y NUMBER(22)
SUBID Y NUMBER(22)
X Y NUMBER(22)
Y Y NUMBER(22)
SN Y NUMBER(22)
FUNCSTART Y NUMBER(22)
FUNEND Y NUMBER(22)

Table: LCSVR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: LCSTATUS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
OFFTIME Y NUMBER(22)
DELAY Y NUMBER(22)
CYCLES Y NUMBER(22)
CURRENTCYCLE Y NUMBER(22)
CYCLECOUNT Y NUMBER(22)
CYCLETIMER Y NUMBER(22)
SWINDICATOR Y NUMBER(22)
LCACTIVE Y NUMBER(22)
RESPONSESTATUSDT Y DATE(7)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
RESPONSESTATUSRCE Y NUMBER(22)
LCJOBCALID Y NUMBER(22)
LOAD_INTERUPT_CNT Y NUMBER(22)
RELAY_ACTIVATE_CNT Y NUMBER(22)

Table: LCRSVR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: LCRESET
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
RESPONSESTATUSDT Y DATE(7)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
RESPONSESTATUSRCE Y NUMBER(22)

Table: LCLOG
Field name Null Type Description
DATETIME Y DATE(7)
ACTIVITYLOG Y VARCHAR2(50)
SERIALPORT Y NUMBER(22)
OFFTIME Y NUMBER(22)
DELAY Y NUMBER(22)
CYCLE Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
XADDR Y NUMBER(22)
YADDR Y NUMBER(22)
FUNCSTART Y NUMBER(22)
FUNCEND Y NUMBER(22)
SUBID Y NUMBER(22)
GROUPID Y NUMBER(22)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
RESPONSESTATUSRCE Y NUMBER(22)

Table: LCJOB_DEF
Field name Null Type Description
JOBNO N NUMBER(22)
NOTIFICATION Y VARCHAR2(75)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
LCX Y NUMBER(22)
LCY Y NUMBER(22)
CLASS Y VARCHAR2(9)
STRATID Y NUMBER(22)
SUBSTATION Y NUMBER(22)
BUS Y NUMBER(22)
FEEDER Y NUMBER(22)
PHASE Y NUMBER(22)
USER1 Y VARCHAR2(17)
USER2 Y VARCHAR2(17)
SQLTXT Y VARCHAR2(4000)
DATA_READ Y VARCHAR2(48)

Table: LCJOB_CMDLIST
Field name Null Type Description
LCJOBCALID Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
ATTEMPT Y NUMBER(22)
OFFTIME Y NUMBER(22)
DELAY Y NUMBER(22)
CYCLES Y NUMBER(22)
CURRENT_CYCLE Y NUMBER(22)
CYCLE_COUNT Y NUMBER(22)
CYCLE_TIMER Y NUMBER(22)
SW_INDICATOR Y NUMBER(22)
LC_ACTIVE Y NUMBER(22)
LOAD_INTERUPT_CNT Y NUMBER(22)
RELAY_ACTIVATE_CNT Y NUMBER(22)
RESPONSE_STATUS_DT Y DATE(7)
RESPONSE_STATUS_TNS Y NUMBER(22)
RESPONSE_STATUS_SCE Y NUMBER(22)
RESPONSE_STATUS_RCE Y NUMBER(22)

Table: LCJOB_CALENDAR
Field name Null Type Description
LCJOBCALID N NUMBER(22)
JOBNO Y NUMBER(22)
GROUPID Y NUMBER(22)
STARTDATE Y DATE(7)
ENDDATE Y DATE(7)
RESULT Y VARCHAR2(800)

Table: LCCLASS
Field name Null Type Description
UTILACCTID N NUMBER(22)
LCCLASS N VARCHAR2(9)
LCX Y NUMBER(22)
LCY Y NUMBER(22)
LCSUBGRP Y NUMBER(22)
LCMINRUNTIME Y NUMBER(22)
LCMINSHEDTIME Y NUMBER(22)
LCINITFLAG Y VARCHAR2(2)
LCACTIVEFLAG Y VARCHAR2(2)
LCCLASSUSER1 Y VARCHAR2(17)
LCCLASSUSER2 Y VARCHAR2(17)

Table: LCACCTS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
LCPREMISEID Y VARCHAR2(21)
LCCLASS Y VARCHAR2(9)
LCX Y NUMBER(22)
LCY Y NUMBER(22)
LCSUBGRP Y NUMBER(22)
LCACTIVEFLAG Y VARCHAR2(2)
LCSTATUS Y NUMBER(22)
LCSTATUSDT Y DATE(7)
RESPONSESTATUSDT Y DATE(7)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
RESPONSESTATUSRCE Y NUMBER(22)
LCASSIGNRETRY Y NUMBER(22)
LCINIT Y NUMBER(22)
LCINITRETRY Y NUMBER(22)
LCUSER1 Y VARCHAR2(17)
LCUSER2 Y VARCHAR2(17)

Table: IPUMAP
Field name Null Type Description
SUBID N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
DETECTIONPT N NUMBER(22)
IMACRMAID N NUMBER(22)
ISAMUXID N NUMBER(22)
CHANNEL N NUMBER(22)
EQUIPTYPEID Y NUMBER(22)

Table: INTERVAL_SRC_REG
Field name Null Type Description
TYPE N NUMBER(22)
DATASOURCEID N NUMBER(22)
UOM Y VARCHAR2(12)
QUANTITYDESC Y VARCHAR2(48)
CONVQUANTITYDESC Y VARCHAR2(48)
DATASOURCEID_FORMAT Y NUMBER(22)
DATATYPEID60 Y NUMBER(22)
DATATYPEID30 Y NUMBER(22)
DATATYPEID15 Y NUMBER(22)
CONVID Y NUMBER(22)
MULTIPLIER Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y NUMBER(22)

Table: INTERVAL_CONV_BACKUP
Field name Null Type Description
UTILACCTID Y NUMBER(22)
TYPE Y NUMBER(22)
MODEL Y VARCHAR2(10)
METERTYPE Y VARCHAR2(11)
FORM Y VARCHAR2(10)
MULTIPLIER_60 Y NUMBER(22)
MULTIPLIER_30 Y NUMBER(22)
MULTIPLIER_15 Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y NUMBER(22)
UOM Y VARCHAR2(12)
CONTROLID_60 Y VARCHAR2(5)
CONTROLID_30 Y VARCHAR2(5)
CONTROLID_15 Y VARCHAR2(5)

Table: INTERVAL_CONV_221
Field name Null Type Description
TYPE N NUMBER(22)
MODEL N NUMBER(22)
FIRMWARE N NUMBER(22)
UOM N VARCHAR2(12)
SCALEFACTOR N NUMBER(22)
UTILACCTID Y NUMBER(22)
KN Y NUMBER(22)
MULTIPLIER Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y CHAR(1)

Table: INTERVAL_CONV
Field name Null Type Description
UTILACCTID Y NUMBER(22)
TYPE N NUMBER(22)
MODEL N VARCHAR2(10)
METERTYPE Y VARCHAR2(11)
FORM Y VARCHAR2(10)
MULTIPLIER_60 Y NUMBER(22)
MULTIPLIER_30 Y NUMBER(22)
MULTIPLIER_15 Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y NUMBER(22)
UOM Y VARCHAR2(12)
CONTROLID_60 Y VARCHAR2(5)
CONTROLID_30 Y VARCHAR2(5)
CONTROLID_15 Y VARCHAR2(5)

Table: INTERVALMEDIA_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: INTERVALDECOPARM
Field name Null Type Description
PRODUCTTYPE N NUMBER(22)
RCEFIRMWARE N NUMBER(22)
PRODUCTMODEL N NUMBER(22)
INTERVALRATEID N NUMBER(22)
BINNINGMODE N NUMBER(22)
PARMORDER N NUMBER(22)
PARMBYTES Y NUMBER(22)
PARMBITS Y NUMBER(22)
PARMOFFSET Y NUMBER(22)
PARMOUT Y NUMBER(22)
PARMFORMAT Y NUMBER(22)
PARMNAME Y VARCHAR2(48)

Table: INTERVALDECOCMD
Field name Null Type Description
PRODUCTTYPE N NUMBER(22)
RCEFIRMWARE N NUMBER(22)
PRODUCTMODEL N NUMBER(22)
INTERVALRATEID N NUMBER(22)
BINNINGMODE N NUMBER(22)
COMMANDBYTES Y NUMBER(22)
COMMANDPARMS Y NUMBER(22)
COMMANDSUB1 Y NUMBER(22)
COMMANDSUB2 Y NUMBER(22)
COMMANDNAME Y VARCHAR2(48)
NUMOFINTERVAL Y NUMBER(22)
BITSPERBIN Y NUMBER(22)

Table: INTERVALDATARESP
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
AMRDATE Y DATE(7)
SAMPLERATE Y NUMBER(22)
STARTINTERVAL Y NUMBER(22)
CHANNEL Y NUMBER(22)
QUALITYCODE Y NUMBER(22)
BIN1 Y NUMBER(22)
BIN2 Y NUMBER(22)
BIN3 Y NUMBER(22)
BIN4 Y NUMBER(22)
BIN5 Y NUMBER(22)
BIN6 Y NUMBER(22)
BIN7 Y NUMBER(22)
BIN8 Y NUMBER(22)
BIN9 Y NUMBER(22)
BIN10 Y NUMBER(22)
BIN11 Y NUMBER(22)
BIN12 Y NUMBER(22)
BIN13 Y NUMBER(22)
BIN14 Y NUMBER(22)
BIN15 Y NUMBER(22)
BIN16 Y NUMBER(22)

Table: INTERVALCMDPARAM
Field name Null Type Description
METERCLASS N NUMBER(22)
CHANNEL N NUMBER(22)
ACTIVEFLAG N VARCHAR2(2)
INTERVALRATE N NUMBER(22)
DATASOURCEID Y NUMBER(22)

Table: INTERFACETYPE
Field name Null Type Description
INTERFACETYPEID N NUMBER(22)
INTERFACETYPENAME Y VARCHAR2(18)
INTERFACETYPELONGNAME Y VARCHAR2(62)
INTERFACEDIALENCODER Y NUMBER(22)

Table: INCMD
Field name Null Type Description
MSEXID N NUMBER(22)
SUBID Y NUMBER(22)
SUBEXID Y NUMBER(22)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
REFCNT Y NUMBER(22)
TRNSHDR Y RAW(49)
TRNSBUF1 Y RAW(255)
TRNSBUF2 Y RAW(255)
TRNSBUF3 Y RAW(255)
TRNSBUF4 Y RAW(255)
TRNSBUF5 Y RAW(255)
TRNSBUF6 Y RAW(255)
TRNSBUF7 Y RAW(255)
TRNSBUF8 Y RAW(255)
TRANSBUFFER Y BLOB(4000)

Table: INBCOMMOPTIONS
Field name Null Type Description
FDRSPECIAL2B0LABEL Y VARCHAR2(20)
FDRSPECIAL2B0ENABLE Y NUMBER(22)
FDRSPECIAL2B0VALUE Y NUMBER(22)
FDRSPECIAL2B1LABEL Y VARCHAR2(20)
FDRSPECIAL2B1ENABLE Y NUMBER(22)
FDRSPECIAL2B1VALUE Y NUMBER(22)
FDRSPECIAL2B2LABEL Y VARCHAR2(20)
FDRSPECIAL2B2ENABLE Y NUMBER(22)
FDRSPECIAL2B2VALUE Y NUMBER(22)
FDRSPECIAL2B3LABEL Y VARCHAR2(20)
FDRSPECIAL2B3ENABLE Y NUMBER(22)
FDRSPECIAL2B3VALUE Y NUMBER(22)
FDRSPECIAL2B4LABEL Y VARCHAR2(20)
FDRSPECIAL2B4ENABLE Y NUMBER(22)
FDRSPECIAL2B4VALUE Y NUMBER(22)
FDRSPECIAL2B5LABEL Y VARCHAR2(20)
FDRSPECIAL2B5ENABLE Y NUMBER(22)
FDRSPECIAL2B5VALUE Y NUMBER(22)
FDRSPECIAL2B6LABEL Y VARCHAR2(20)
FDRSPECIAL2B6ENABLE Y NUMBER(22)
FDRSPECIAL2B6VALUE Y NUMBER(22)
FDRSPECIAL2B7LABEL Y VARCHAR2(20)
FDRSPECIAL2B7ENABLE Y NUMBER(22)
FDRSPECIAL2B7VALUE Y NUMBER(22)

Table: IHDSVR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: IHDRSP_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: IHDMODEXREF
Field name Null Type Description
IHDMODE N NUMBER(22)
DESCRIP Y VARCHAR2(21)
SHORTDESC Y VARCHAR2(4)

Table: IHDMESSAGES
Field name Null Type Description
MSEXID N NUMBER(22)
GROUPID N NUMBER(22)
PRIORITY N NUMBER(22)
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
SUBID N NUMBER(22)
REPEATSLEFT N NUMBER(22)
FUNCCODE N NUMBER(22)
CMDDATA Y VARCHAR2(255)
LASTSENTDT N DATE(7)
TIMEOUT N DATE(7)

Table: IHDACCTS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
IHDMODE Y NUMBER(22)
CUSTOMERACCTNUM Y VARCHAR2(21)
TIMEZONEOFFSET Y NUMBER(22)
LANGUAGE Y CHAR(2)
COUNTRY Y CHAR(2)
LOWMONEYTHRESHOLD Y NUMBER(22)

Table: HRLYGRPS
Field name Null Type Description
HRLYGRP Y NUMBER(22)
BLKCNT Y NUMBER(22)

Table: HOURLYGROUP_INPQ
Field name Null Type Description
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRIORITY Y NUMBER(22)
TIMEOUT Y DATE(7)
MSEXID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: HOURLYGROUPINGS
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
TWUNIT Y NUMBER(22)
GRPHOUR Y VARCHAR2(32)
TYPE Y NUMBER(22)
MODEL Y NUMBER(22)
SUBID Y NUMBER(22)
STAMP Y DATE(7)
TWSTATUS Y NUMBER(22)

Table: HOURLYCONV
Field name Null Type Description
UTILACCTID Y NUMBER(22)
METERTYPE N VARCHAR2(11)
HMULTIPLIER Y NUMBER(22)
HDIVISOR Y NUMBER(22)
HDECIMALS Y NUMBER(22)
HROUND Y NUMBER(22)
HUOM Y VARCHAR2(12)

Table: HOURLY2
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
METERUSER1 Y VARCHAR2(17)
METERUSER2 Y VARCHAR2(17)

Table: HANP_INPQ
Field name Null Type Description
SUBSYSID N NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
MSEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
ATTEMPTS_LEFT Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(500)

Table: GYRBOX_DIAGNOSTIC_COUNTER
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
DATETIME Y DATE(7)
GYRBOX Y VARCHAR2(16)
GYRBOX_DATAID Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)

Table: GRP_SUBID_BLKS
Field name Null Type Description
HRLYGRP Y NUMBER(22)
SUBID Y NUMBER(22)
BLKCNT Y NUMBER(22)

Table: GRAPHINTERVALDATA30
Field name Null Type Description
UTILACCTID Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
INTERVALREADDT Y DATE(7)
INTERVAL30QC Y NUMBER(22)
INTERVAL30QCDESC Y VARCHAR2(4)
INTERVAL30DELTA Y NUMBER(22)

Table: GRAPHINTERVALDATA15
Field name Null Type Description
UTILACCTID Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
INTERVALREADDT Y DATE(7)
INTERVAL15QC Y NUMBER(22)
INTERVAL15QCDESC Y VARCHAR2(4)
INTERVAL15DELTA Y NUMBER(22)

Table: GPT_RUN
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
STARTDTTM Y DATE(7)
STATUS Y NUMBER(22)
CNCLPEND Y NUMBER(22)
RDCHNLCNT Y NUMBER(22)
RESETALRMCNT Y NUMBER(22)
SCANRETRYCNT Y NUMBER(22)
READCH0RETCNT Y NUMBER(22)
READCH1RETCNT Y NUMBER(22)
READCH2RETCNT Y NUMBER(22)
READCH3RETCNT Y NUMBER(22)
READCH4RETCNT Y NUMBER(22)
READCH5RETCNT Y NUMBER(22)
READCH6RETCNT Y NUMBER(22)
READCH7RETCNT Y NUMBER(22)
READCH8RETCNT Y NUMBER(22)
READCH9RETCNT Y NUMBER(22)
READCH10RETCNT Y NUMBER(22)
READCH11RETCNT Y NUMBER(22)
READCH12RETCNT Y NUMBER(22)
RESETCH0RETCNT Y NUMBER(22)
RESETCH1RETCNT Y NUMBER(22)
RESETCH2RETCNT Y NUMBER(22)
RESETCH3RETCNT Y NUMBER(22)
RESETCH4RETCNT Y NUMBER(22)
RESETCH5RETCNT Y NUMBER(22)
RESETCH6RETCNT Y NUMBER(22)
RESETCH7RETCNT Y NUMBER(22)
RESETCH8RETCNT Y NUMBER(22)
RESETCH9RETCNT Y NUMBER(22)
RESETCH10RETCNT Y NUMBER(22)
RESETCH11RETCNT Y NUMBER(22)
RESETCH12RETCNT Y NUMBER(22)

Table: GPT_LOG
Field name Null Type Description
LOGTIME Y DATE(7)
SERIALNUMBER N NUMBER(22)
LOGDESC Y VARCHAR2(255)
LOGTYPE Y NUMBER(22)
RPTCG Y NUMBER(22)

Table: GPT_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: GPTR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: GPTRUNSTATUSXREF
Field name Null Type Description
STATUS Y NUMBER(22)
DESCRIPTION Y VARCHAR2(50)

Table: GPTLOGTYPEXREF
Field name Null Type Description
LOGTYPE Y NUMBER(22)
TYPEDESC Y VARCHAR2(26)

Table: GENMAINTLOG
Field name Null Type Description
UTILACCTID Y NUMBER(22)
STAMP Y DATE(7)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
TRANSACTIONTYPE Y CHAR(8)
RECORDTYPE Y CHAR(8)
DATA Y CHAR(128)

Table: GENERIC_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: GENCMDR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: FUNC_PRI_DESCR
Field name Null Type Description
FUNCCODE N NUMBER(22)
PRIORITY Y NUMBER(22)
DESCR N VARCHAR2(30)

Table: FUNCGRPPRIORITY
Field name Null Type Description
TWFUNC N NUMBER(22)
TWGRP N NUMBER(22)
PRIORITYDELTA N NUMBER(22)

Table: FIELDFORMATS
Field name Null Type Description
NAME N VARCHAR2(20)
OPERATION N VARCHAR2(10)
LENGTH Y NUMBER(22)
CHARACTER Y VARCHAR2(1)
DIRECTION Y VARCHAR2(10)

Table: FEEDER
Field name Null Type Description
SUBID N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
FEEDERNAME Y VARCHAR2(12)
MULTIBIT Y CHAR(1)
ERRDETCORR Y CHAR(1)
UNITCHSET Y CHAR(1)
UNITCHMAP Y NUMBER(22)
GROUPCHSET Y CHAR(1)
GROUPCHMAP Y NUMBER(22)
GROUPCHMAP1 Y CHAR(1)
GROUPCHMAP2 Y CHAR(1)
GROUPCHMAP3 Y CHAR(1)
GROUPCHMAP4 Y CHAR(1)
GROUPCHMAP5 Y CHAR(1)
GROUPCHMAP6 Y CHAR(1)
PHASEDELAYLG Y NUMBER(22)
PHASEDELAYLL Y NUMBER(22)
DETWINCNT Y NUMBER(22)
DETWINDEG Y NUMBER(22)
DETWINBIT Y NUMBER(22)
INBSCANEU Y NUMBER(22)
INBSCAPHA Y NUMBER(22)
EQUIPTYPEID Y NUMBER(22)
FDRSPECIAL1 Y NUMBER(22)
FDRSPECIAL2 Y NUMBER(22)
FDRSPECIAL3 Y NUMBER(22)
UNITCHASETVAL Y NUMBER(22)
GROUPCHASETVAL Y NUMBER(22)
FDRSPECIAL2B0 Y NUMBER(22)
FDRSPECIAL2B1 Y NUMBER(22)
FDRSPECIAL2B2 Y NUMBER(22)
FDRSPECIAL2B3 Y NUMBER(22)
FDRSPECIAL2B4 Y NUMBER(22)
FDRSPECIAL2B5 Y NUMBER(22)
FDRSPECIAL2B6 Y NUMBER(22)
FDRSPECIAL2B7 Y NUMBER(22)

Table: FEATURESUBSET
Field name Null Type Description
RCDFEATURESETID N NUMBER(22)
RCDFEATURESUBSETID N NUMBER(22)

Table: FEATURESET_NAMEDCFGXREF
Field name Null Type Description
FEATURESETID N NUMBER(22)
NAMEDCFGID N NUMBER(22)
CONFIGTYPEID N NUMBER(22)

Table: EXT_OUTAGE_STATE
Field name Null Type Description
MONITOR_ID N NUMBER(22)
SERIALNUMBER N NUMBER(22)
MONITOR_START_TIME N DATE(7)
CURR_STATE Y NUMBER(22)
CURR_STATE_DATETIME Y DATE(7)
CURR_STATE_COUNT Y NUMBER(22)
CURR_STATE_CHANGE_SEQ Y NUMBER(22)
PREV_STATE Y NUMBER(22)
PREV_STATE_DATETIME Y DATE(7)
PREV_STATE_COUNT Y NUMBER(22)
LAST_CHECK_DATETIME Y DATE(7)
NEXT_RESEND_DATETIME Y DATE(7)
EXT_USER1 Y VARCHAR2(25)

Table: EXT_OUTAGE_MONITOR_JOBS
Field name Null Type Description
MONITOR_ID N NUMBER(22)
JOBDEFID N NUMBER(22)

Table: EXT_OUTAGE_MONITOR
Field name Null Type Description
MONITOR_ID N NUMBER(22)
EXT_APPLICATION N VARCHAR2(20)
EXT_APPL_ID N NUMBER(22)
EXT_APPL_LAST_CHECK_DATETIME Y DATE(7)
EXT_APPL_LAST_STATE_CHANGE_SEQ Y NUMBER(22)
MONITOR_JOB_ID Y NUMBER(22)
OUTAGE_GROUPID Y NUMBER(22)
OUTAGE_JOB_INIT Y DATE(7)
CURR_OUTAGE_JOB_STATE Y CHAR(1)
RESEND_INTERVAL Y NUMBER(22)
EXT_MONITOR_EXPIRATION Y DATE(7)
EXT_USER1_TEXT Y VARCHAR2(100)
EXT_USER1_NUM Y NUMBER(22)

Table: EXTRAREGIDREADS
Field name Null Type Description
GROUPNAME Y VARCHAR2(50)
REGISTERNAME Y VARCHAR2(255)
REGISTERID Y NUMBER(22)
REGISTERLENGTH Y NUMBER(22)
REGISTERTYPE Y NUMBER(22)
SHIFTCOMMAND Y NUMBER(22)
SEQUENCE Y NUMBER(22)
SEQUENCEDELAY Y NUMBER(22)
WRITEDATA Y VARCHAR2(15)

Table: EXECSQLSVR_INPQ
Field name Null Type Description
ID Y NUMBER(22)
STATUS Y VARCHAR2(1)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
COMMAND Y VARCHAR2(255)
SVCNUM Y NUMBER(22)

Table: EXCHANGEXREF
Field name Null Type Description
EXCHANGETYPEID Y NUMBER(22)
EXCHANGETYPETEXT Y VARCHAR2(48)

Table: EXCEPTIONLOG
Field name Null Type Description
DATETIME Y DATE(7)
USERNAME Y VARCHAR2(32)
SUBID N NUMBER(22)
SUBNAME Y VARCHAR2(25)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
EXCEPTIONDATETIME Y DATE(7)
EXCEPTIONTYPEID Y NUMBER(22)
EXCEPTIONTYPETEXT Y VARCHAR2(8)
EXCEPTIONID Y NUMBER(22)
EXCEPTIONIDNAME Y VARCHAR2(40)
INFORMATIONDATA Y VARCHAR2(255)

Table: ERR_CORR_COUNT
Field name Null Type Description
BIT_CORR_COUNT Y NUMBER(22)
BIT_CORR_DESC Y VARCHAR2(80)

Table: EQUIPTEXTXREF
Field name Null Type Description
EQUIPTYPEID N NUMBER(22)
EQUIPTYPETEXT Y VARCHAR2(8)
EQUIPTYPETEXTLONG Y VARCHAR2(71)

Table: EQUIPOPERSTATTEXTXREF
Field name Null Type Description
EQUIPOPERSTATUS N NUMBER(22)
EQUIPSTATE Y VARCHAR2(35)
EQUIPTYPEID N NUMBER(22)
EQUIPDIAGNOSTIC Y CHAR(1)

Table: EQUIPMENT
Field name Null Type Description
SUBID N NUMBER(22)
EQUIPTYPEID N NUMBER(22)
EQUIPID N NUMBER(22)
EQUIPOPERSTATUS Y NUMBER(22)
EQUIPSTATE Y CHAR(8)
OMUPHASIGMAPA Y CHAR(1)
OMUPHASIGMAPB Y CHAR(1)
OMUPHASIGMAPC Y CHAR(1)
OMUPHASIGMAPAB Y CHAR(1)
OMUPHASIGMAPBC Y CHAR(1)
OMUPHASIGMAPCA Y CHAR(1)
IMACRMAID Y NUMBER(22)
ISAMUXID Y NUMBER(22)
CHANNEL Y NUMBER(22)
EQUIPHDWVER Y CHAR(6)
EQUIPHDWREV Y CHAR(6)
EQUIPSFWVER Y CHAR(6)
EQUIPSFWREV Y CHAR(6)
EQUIPFPGAVER Y CHAR(6)
EQUIPFPGAREV Y CHAR(6)
EQUIPCONFVER Y CHAR(6)
EQUIPCONFREV Y CHAR(6)

Table: ENVIRONMENTLIMITDESC
Field name Null Type Description
EQUIPTYPEID N NUMBER(22)
EQUIPTYPETEXT Y VARCHAR2(8)
LIMITTYPE Y NUMBER(22)
LIMITNAME Y VARCHAR2(20)
MONEQUIPID Y NUMBER(22)
MONEQUIPNAME Y VARCHAR2(5)
EQUIPMONITOREDID Y NUMBER(22)
EQUIPMONITOREDNAME Y VARCHAR2(5)
MINLIMIT Y NUMBER(22)
MINLIMITDEFAULT Y NUMBER(22)
MAXLIMIT Y NUMBER(22)
MAXLIMITDEFAULT Y NUMBER(22)
LIMITUM Y VARCHAR2(2)
SCALEFACTOR Y NUMBER(22)
SCALEFACTORDEFAULT Y NUMBER(22)

Table: ENVIRONMENTLIMIT
Field name Null Type Description
SUBID N NUMBER(22)
EQUIPTYPEID N NUMBER(22)
EQUIPID N NUMBER(22)
LIMITTYPE N NUMBER(22)
MINLIMIT Y NUMBER(22)
MINLIMITDEFAULT Y NUMBER(22)
MAXLIMIT Y NUMBER(22)
MAXLIMITDEFAULT Y NUMBER(22)
LIMITUM Y VARCHAR2(2)
SCALEFACTOR Y NUMBER(22)
SCALEFACTORDEFAULT Y NUMBER(22)

Table: ENVIRONMENTALLOG
Field name Null Type Description
DATETIME Y DATE(7)
USERNAME Y VARCHAR2(32)
SUBID N NUMBER(22)
SUBNAME Y VARCHAR2(25)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
EQUIPTYPEID Y NUMBER(22)
EQUIPTYPETEXT Y VARCHAR2(8)
EQUIPID Y NUMBER(22)
LIMITTYPE Y NUMBER(22)
LIMITNAME Y VARCHAR2(20)
MINLIMIT Y NUMBER(22)
MAXLIMIT Y NUMBER(22)
ENVIRONMENTALLIMIT Y NUMBER(22)
LIMITUM Y VARCHAR2(2)

Table: ENCOTITLE
Field name Null Type Description
TITLEID N NUMBER(22)
EXCHANGETYPEID N NUMBER(22)
TITLENAME Y VARCHAR2(48)

Table: ENCOPARM
Field name Null Type Description
EXCHANGETYPEID N NUMBER(22)
COMMANDID N NUMBER(22)
TITLEID Y NUMBER(22)
PARMORDER Y NUMBER(22)
PARMMIN Y NUMBER(22)
PARMMAX Y NUMBER(22)
PARMDEF Y NUMBER(22)
PARMBYTES Y NUMBER(22)
PARMBITS Y NUMBER(22)
PARMOFFSET Y NUMBER(22)
PARMNAME Y VARCHAR2(48)

Table: ENCODFLT
Field name Null Type Description
EXCHANGETYPEID N NUMBER(22)
COMMANDID N NUMBER(22)
TITLEID Y NUMBER(22)
DFLTCCETIMEOUT Y NUMBER(22)
DFLTSCETIMEOUT Y NUMBER(22)
DFLT1WAYREPEAT Y NUMBER(22)
DFLT2WAYRETRY Y NUMBER(22)
DFLTCCEPRIORITY1 Y NUMBER(22)
DFLTCCEPRIORITY2 Y NUMBER(22)
DFLTSCEPRIORITY1 Y NUMBER(22)
DFLTSCEPRIORITY2 Y NUMBER(22)
DFLTRCEINBOUND Y NUMBER(22)
DFLTRCEADDRMODE Y NUMBER(22)
DFLTRCERESPMODE Y NUMBER(22)
DFLTRCECMDGEN Y NUMBER(22)
DFLTRESPFMT Y NUMBER(22)
DFLTCCERETRYDELAY Y NUMBER(22)

Table: ENCOCMD
Field name Null Type Description
EXCHANGETYPEID N NUMBER(22)
COMMANDID N NUMBER(22)
TITLEID Y NUMBER(22)
COMMANDBYTES Y NUMBER(22)
COMMANDPARMS Y NUMBER(22)
RESPONSEBYTES Y NUMBER(22)
COMMANDNAME Y VARCHAR2(48)

Table: EMPLOYEE
Field name Null Type Description
ID N NUMBER(22)
FNAME Y VARCHAR2(50)
LNAME Y VARCHAR2(50)

Table: ECT_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: ECTR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: DSTXREF
Field name Null Type Description
YEAR N NUMBER(22)
DST_BEGIN Y DATE(7)
DST_END Y DATE(7)

Table: DRU_UVUF_HISTORY
Field name Null Type Description
CMDREQ_DATETIME Y DATE(7)
CMDSENT_DATETIME Y DATE(7)
GROUPID N NUMBER(22)
ADDR_MODE N NUMBER(22)
PRI_ADDRESS N VARCHAR2(10)
SEC_ADDRESS N NUMBER(22)
UV1_TRIP_THRESHOLD Y NUMBER(22)
UV1_TRIP_DURATION_SEC Y NUMBER(22)
UV1_CLR_THRESHOLD Y NUMBER(22)
UV1_CLR_DURATION_SEC Y NUMBER(22)
UV1_ACTION_BITMAP Y NUMBER(22)
UV1_PORTS_BITMAP Y NUMBER(22)
UV1_LOAD_TO_SHED Y NUMBER(22)
UV1_CONTROL_METHOD Y NUMBER(22)
UV2_TRIP_THRESHOLD Y NUMBER(22)
UV2_TRIP_DURATION_SEC Y NUMBER(22)
UV2_CLR_THRESHOLD Y NUMBER(22)
UV2_CLR_DURATION_SEC Y NUMBER(22)
UV2_ACTION_BITMAP Y NUMBER(22)
UV2_PORTS_BITMAP Y NUMBER(22)
UV2_LOAD_TO_SHED Y NUMBER(22)
UV2_CONTROL_METHOD Y NUMBER(22)
UF1_TRIP_THRESHOLD Y NUMBER(22)
UF1_TRIP_DURATION_SEC Y NUMBER(22)
UF1_CLR_THRESHOLD Y NUMBER(22)
UF1_CLR_DURATION_SEC Y NUMBER(22)
UF1_ACTION_BITMAP Y NUMBER(22)
UF1_PORTS_BITMAP Y NUMBER(22)
UF1_LOAD_TO_SHED Y NUMBER(22)
UF1_CONTROL_METHOD Y NUMBER(22)
UF2_TRIP_THRESHOLD Y NUMBER(22)
UF2_TRIP_DURATION_SEC Y NUMBER(22)
UF2_CLR_THRESHOLD Y NUMBER(22)
UF2_CLR_DURATION_SEC Y NUMBER(22)
UF2_ACTION_BITMAP Y NUMBER(22)
UF2_PORTS_BITMAP Y NUMBER(22)
UF2_LOAD_TO_SHED Y NUMBER(22)
UF2_CONTROL_METHOD Y NUMBER(22)
ARCHIVED N CHAR(1)
TNS_STAT Y NUMBER(22)
SCE_STAT Y NUMBER(22)
RCE_STAT Y NUMBER(22)

Table: DRU_UVUFSTATUS_HISTORY
Field name Null Type Description
CMDREQ_DATETIME N DATE(7)
CMDSENT_DATETIME Y DATE(7)
GROUPID N NUMBER(22)
SERIALNUMBER N NUMBER(22)
UV1_COUNTER Y NUMBER(22)
UV2_COUNTER Y NUMBER(22)
UF1_COUNTER Y NUMBER(22)
UF2_COUNTER Y NUMBER(22)
ARCHIVED N CHAR(1)
TNS_STAT Y NUMBER(22)
SCE_STAT Y NUMBER(22)
RCE_STAT Y NUMBER(22)

Table: DRU_SHORTCYCLELIM_HISTORY
Field name Null Type Description
CMDREQ_DATETIME Y DATE(7)
CMDSENT_DATETIME Y DATE(7)
GROUPID N NUMBER(22)
ADDR_MODE N NUMBER(22)
PRI_ADDRESS N VARCHAR2(10)
SEC_ADDRESS N NUMBER(22)
MIN_RUN_TIME N NUMBER(22)
MIN_SHED_TIME N NUMBER(22)
ARCHIVED N CHAR(1)
TNS_STAT Y NUMBER(22)
SCE_STAT Y NUMBER(22)
RCE_STAT Y NUMBER(22)

Table: DRU_PROFWGT_HISTORY
Field name Null Type Description
CMDREQ_DATETIME Y DATE(7)
CMDSENT_DATETIME Y DATE(7)
GROUPID N NUMBER(22)
ADDR_MODE N NUMBER(22)
PRI_ADDRESS N VARCHAR2(10)
SEC_ADDRESS N NUMBER(22)
PROFILE_WEIGHTING N NUMBER(22)
ARCHIVED N CHAR(1)
TNS_STAT Y NUMBER(22)
SCE_STAT Y NUMBER(22)
RCE_STAT Y NUMBER(22)

Table: DRU_PROFILE_HISTORY
Field name Null Type Description
CMDREQ_DATETIME Y DATE(7)
CMDSENT_DATETIME Y DATE(7)
GROUPID N NUMBER(22)
SERIALNUMBER N NUMBER(22)
PORTNUMBER N NUMBER(22)
STARTING_HOUR N NUMBER(22)
NUM_HOURS N NUMBER(22)
ARCHIVED N CHAR(1)
TNS_STAT Y NUMBER(22)
SCE_STAT Y NUMBER(22)
RCE_STAT Y NUMBER(22)

Table: DRU_LC_HISTORY
Field name Null Type Description
CMDREQ_DATETIME Y DATE(7)
CMDSENT_DATETIME Y DATE(7)
GROUPID N NUMBER(22)
LC_MODE N NUMBER(22)
ADDR_MODE N NUMBER(22)
PRI_ADDRESS N VARCHAR2(10)
SEC_ADDRESS N NUMBER(22)
LOAD_TO_SHED N NUMBER(22)
DURATION_SECONDS N NUMBER(22)
CONTROL_METHOD Y NUMBER(22)
ARCHIVED N CHAR(1)
TNS_STAT Y NUMBER(22)
SCE_STAT Y NUMBER(22)
RCE_STAT Y NUMBER(22)

Table: DRU_LCSTATUS_HISTORY
Field name Null Type Description
CMDREQ_DATETIME N DATE(7)
CMDSENT_DATETIME Y DATE(7)
GROUPID N NUMBER(22)
SERIALNUMBER N NUMBER(22)
PORTNUMBER N NUMBER(22)
ACTUAL_LEFT_OVER_LOAD_MIN Y NUMBER(22)
LAST_CONTROL_DATETIME Y DATE(7)
CONTROL_INDICATORS Y NUMBER(22)
ARCHIVED N CHAR(1)
TNS_STAT Y NUMBER(22)
SCE_STAT Y NUMBER(22)
RCE_STAT Y NUMBER(22)
DISPATCHABLE_LOAD_MIN Y NUMBER(22)
COMPUTED_RUN_TIME_MIN Y NUMBER(22)
LOAD_RUN_TIME_MIN Y NUMBER(22)
JOBNAME Y VARCHAR2(20)

Table: DRU_KNOWN_PROFILE
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
PORTNUMBER N NUMBER(22)
HOUR_00_VALUE Y NUMBER(22)
HOUR_00_DATETIME Y DATE(7)
HOUR_01_VALUE Y NUMBER(22)
HOUR_01_DATETIME Y DATE(7)
HOUR_02_VALUE Y NUMBER(22)
HOUR_02_DATETIME Y DATE(7)
HOUR_03_VALUE Y NUMBER(22)
HOUR_03_DATETIME Y DATE(7)
HOUR_04_VALUE Y NUMBER(22)
HOUR_04_DATETIME Y DATE(7)
HOUR_05_VALUE Y NUMBER(22)
HOUR_05_DATETIME Y DATE(7)
HOUR_06_VALUE Y NUMBER(22)
HOUR_06_DATETIME Y DATE(7)
HOUR_07_VALUE Y NUMBER(22)
HOUR_07_DATETIME Y DATE(7)
HOUR_08_VALUE Y NUMBER(22)
HOUR_08_DATETIME Y DATE(7)
HOUR_09_VALUE Y NUMBER(22)
HOUR_09_DATETIME Y DATE(7)
HOUR_10_VALUE Y NUMBER(22)
HOUR_10_DATETIME Y DATE(7)
HOUR_11_VALUE Y NUMBER(22)
HOUR_11_DATETIME Y DATE(7)
HOUR_12_VALUE Y NUMBER(22)
HOUR_12_DATETIME Y DATE(7)
HOUR_13_VALUE Y NUMBER(22)
HOUR_13_DATETIME Y DATE(7)
HOUR_14_VALUE Y NUMBER(22)
HOUR_14_DATETIME Y DATE(7)
HOUR_15_VALUE Y NUMBER(22)
HOUR_15_DATETIME Y DATE(7)
HOUR_16_VALUE Y NUMBER(22)
HOUR_16_DATETIME Y DATE(7)
HOUR_17_VALUE Y NUMBER(22)
HOUR_17_DATETIME Y DATE(7)
HOUR_18_VALUE Y NUMBER(22)
HOUR_18_DATETIME Y DATE(7)
HOUR_19_VALUE Y NUMBER(22)
HOUR_19_DATETIME Y DATE(7)
HOUR_20_VALUE Y NUMBER(22)
HOUR_20_DATETIME Y DATE(7)
HOUR_21_VALUE Y NUMBER(22)
HOUR_21_DATETIME Y DATE(7)
HOUR_22_VALUE Y NUMBER(22)
HOUR_22_DATETIME Y DATE(7)
HOUR_23_VALUE Y NUMBER(22)
HOUR_23_DATETIME Y DATE(7)

Table: DRU_INPQ
Field name Null Type Description
SUBSYSID N NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
ATTEMPTS_LEFT Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(500)

Table: DRU_CURR_CONFIG
Field name Null Type Description
MIN_RUN_TIME2 Y NUMBER(22)
MIN_SHED_TIME2 Y NUMBER(22)
SERIALNUMBER N NUMBER(22)
PROFILE_WEIGHTING Y NUMBER(22)
COLD_LOAD_PICKUP Y NUMBER(22)
UV1_TRIP_THRESHOLD Y NUMBER(22)
UV1_TRIP_DURATION_SEC Y NUMBER(22)
UV1_CLR_THRESHOLD Y NUMBER(22)
UV1_CLR_DURATION_SEC Y NUMBER(22)
UV1_ACTION_BITMAP Y NUMBER(22)
UV1_PORTS_BITMAP Y NUMBER(22)
UV1_LOAD_TO_SHED Y NUMBER(22)
UV1_CONTROL_METHOD Y NUMBER(22)
UV2_TRIP_THRESHOLD Y NUMBER(22)
UV2_TRIP_DURATION_SEC Y NUMBER(22)
UV2_CLR_THRESHOLD Y NUMBER(22)
UV2_CLR_DURATION_SEC Y NUMBER(22)
UV2_ACTION_BITMAP Y NUMBER(22)
UV2_PORTS_BITMAP Y NUMBER(22)
UV2_LOAD_TO_SHED Y NUMBER(22)
UV2_CONTROL_METHOD Y NUMBER(22)
UF1_TRIP_THRESHOLD Y NUMBER(22)
UF1_TRIP_DURATION_SEC Y NUMBER(22)
UF1_CLR_THRESHOLD Y NUMBER(22)
UF1_CLR_DURATION_SEC Y NUMBER(22)
UF1_ACTION_BITMAP Y NUMBER(22)
UF1_PORTS_BITMAP Y NUMBER(22)
UF1_LOAD_TO_SHED Y NUMBER(22)
UF1_CONTROL_METHOD Y NUMBER(22)
UF2_TRIP_THRESHOLD Y NUMBER(22)
UF2_TRIP_DURATION_SEC Y NUMBER(22)
UF2_CLR_THRESHOLD Y NUMBER(22)
UF2_CLR_DURATION_SEC Y NUMBER(22)
UF2_ACTION_BITMAP Y NUMBER(22)
UF2_PORTS_BITMAP Y NUMBER(22)
UF2_LOAD_TO_SHED Y NUMBER(22)
UF2_CONTROL_METHOD Y NUMBER(22)
MIN_RUN_TIME Y NUMBER(22)
MIN_SHED_TIME Y NUMBER(22)

Table: DRU_CLP_HISTORY
Field name Null Type Description
CMDREQ_DATETIME Y DATE(7)
CMDSENT_DATETIME Y DATE(7)
GROUPID N NUMBER(22)
ADDR_MODE N NUMBER(22)
PRI_ADDRESS N VARCHAR2(10)
SEC_ADDRESS N NUMBER(22)
READ_OR_WRITE N CHAR(1)
CLP_ENABLED N NUMBER(22)
ARCHIVED N CHAR(1)
TNS_STAT Y NUMBER(22)
SCE_STAT Y NUMBER(22)
RCE_STAT Y NUMBER(22)

Table: DRUJOB
Field name Null Type Description
GROUPID N NUMBER(22)
JOBNAME Y VARCHAR2(20)

Table: DRUCMDLST2WAY
Field name Null Type Description
GROUPID N NUMBER(22)
SERIALPORT N NUMBER(22)
TYPE N NUMBER(22)
TWFUNC N NUMBER(22)
TWGRP N NUMBER(22)
TWUNITMAPTOTAL Y NUMBER(22)
TWUNITMAP1 Y NUMBER(22)
TWUNITMAP2 Y NUMBER(22)
TWUNITMAP3 Y NUMBER(22)
TWUNITMAP4 Y NUMBER(22)
TWUNITMAP5 Y NUMBER(22)
TWUNITMAP6 Y NUMBER(22)
TWUNITMAP7 Y NUMBER(22)
TWUNITMAP8 Y NUMBER(22)
TWUNITMAP9 Y NUMBER(22)
TWUNITMAP10 Y NUMBER(22)
TWUNITMAP11 Y NUMBER(22)
TWUNITMAP12 Y NUMBER(22)
TWUNITMAP13 Y NUMBER(22)
TWUNITMAP14 Y NUMBER(22)
TWUNITMAP15 Y NUMBER(22)
TWUNITMAP16 Y NUMBER(22)
TWUNITMAP17 Y NUMBER(22)
TWUNITMAP18 Y NUMBER(22)
TWUNITMAP19 Y NUMBER(22)
TWUNITMAP20 Y NUMBER(22)
TWUNITMAP21 Y NUMBER(22)
TWUNITMAP22 Y NUMBER(22)
TWUNITMAP23 Y NUMBER(22)
TWUNITMAP24 Y NUMBER(22)
TWUNITMAP25 Y NUMBER(22)
TWUNITMAP26 Y NUMBER(22)
TWUNITMAP27 Y NUMBER(22)
TWUNITMAP28 Y NUMBER(22)
TWUNITMAP29 Y NUMBER(22)
TWUNITMAP30 Y NUMBER(22)
TWUNITMAP31 Y NUMBER(22)
TWUNITMAP32 Y NUMBER(22)

Table: DRUCMDLST
Field name Null Type Description
GROUPID N NUMBER(22)
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
MSEXID Y NUMBER(22)
TYPE Y NUMBER(22)
ADDRMODE Y NUMBER(22)
SETID Y VARCHAR2(8)
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
TWUNIT Y NUMBER(22)
TWFLAG Y NUMBER(22)
READDATE Y DATE(7)
TNSSTATUS Y NUMBER(22)
SCESTATUS Y NUMBER(22)
RCESTATUS Y NUMBER(22)

Table: DISASTERRECOVERYBUILD
Field name Null Type Description
TWFUNC N NUMBER(22)
TWGRP N NUMBER(22)
AMRCALJOBNO N NUMBER(22)
SUBID N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
PHASE N NUMBER(22)
SIGNAL N NUMBER(22)
DETECTION N NUMBER(22)
PROTECTIVEDEVICE Y VARCHAR2(14)
UTILACCTID Y NUMBER(22)
AMRREADTYPE Y NUMBER(22)
AMRREADIND Y NUMBER(22)
AMRCURPREV Y NUMBER(22)
AMRPORT Y NUMBER(22)
AMRMIT N NUMBER(22)
INTERVALTIME N NUMBER(22)
TWUNITMAPTOTAL Y NUMBER(22)
TWUNITMAP1 Y NUMBER(22)
TWUNITMAP2 Y NUMBER(22)
TWUNITMAP3 Y NUMBER(22)
TWUNITMAP4 Y NUMBER(22)
TWUNITMAP5 Y NUMBER(22)
TWUNITMAP6 Y NUMBER(22)
TWUNITMAP7 Y NUMBER(22)
TWUNITMAP8 Y NUMBER(22)
TWUNITMAP9 Y NUMBER(22)
TWUNITMAP10 Y NUMBER(22)
TWUNITMAP11 Y NUMBER(22)
TWUNITMAP12 Y NUMBER(22)
TWUNITMAP13 Y NUMBER(22)
TWUNITMAP14 Y NUMBER(22)
TWUNITMAP15 Y NUMBER(22)
TWUNITMAP16 Y NUMBER(22)
TWUNITMAP17 Y NUMBER(22)
TWUNITMAP18 Y NUMBER(22)
TWUNITMAP19 Y NUMBER(22)
TWUNITMAP20 Y NUMBER(22)
TWUNITMAP21 Y NUMBER(22)
TWUNITMAP22 Y NUMBER(22)
TWUNITMAP23 Y NUMBER(22)
TWUNITMAP24 Y NUMBER(22)
TWUNITMAP25 Y NUMBER(22)
TWUNITMAP26 Y NUMBER(22)
TWUNITMAP27 Y NUMBER(22)
TWUNITMAP28 Y NUMBER(22)
TWUNITMAP29 Y NUMBER(22)
TWUNITMAP30 Y NUMBER(22)
TWUNITMAP31 Y NUMBER(22)
TWUNITMAP32 Y NUMBER(22)

Table: DFW_SUB_DOWNLOAD_STATUS
Field name Null Type Description
CYCLE_ID N NUMBER(22)
SUBID N NUMBER(22)
LAST_PACKET_SENT N NUMBER(22)
LAST_PACKET_DATETIME Y DATE(7)

Table: DFW_SCEFAILED_PACKETS
Field name Null Type Description
CYCLE_ID N NUMBER(22)
SUBID N NUMBER(22)
PACKET_ID N NUMBER(22)

Table: DFW_REQUESTED_PACKETS
Field name Null Type Description
CYCLE_ID N NUMBER(22)
SERIALNUMBER N NUMBER(22)
PACKET_ID N NUMBER(22)
REQUEST_COUNT N NUMBER(22)

Table: DFW_QUERY_PARAMS
Field name Null Type Description
PARAM_ID Y NUMBER(22)
COL_NUM_IDFK Y NUMBER(22)
CYCLE_IDFK Y NUMBER(22)
QUERY_TYPE Y NUMBER(22)
CHAR_VALUE Y VARCHAR2(1024)
DISP_VALUE Y VARCHAR2(500)

Table: DFW_PACKETS
Field name Null Type Description
PACKET_ID Y NUMBER(22)
DFW_CYCLE_IDFK Y NUMBER(22)
PACKET Y RAW(25)

Table: DFW_OUTSTANDING_CMDS
Field name Null Type Description
MSEXID N NUMBER(22)
SUBEXID N NUMBER(22)
CTRL_FUNC N NUMBER(22)
FUNC_PARAMS Y VARCHAR2(32)
DFW_CYCLE_IDFK Y NUMBER(22)
SUBID N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
PHASE N NUMBER(22)
SIGNAL N NUMBER(22)
DETECTION N NUMBER(22)
SERIALNUMBER Y NUMBER(22)
TWFUNC Y NUMBER(22)
TWGRP Y NUMBER(22)
TWGRPBASE Y NUMBER(22)
TWGRPSIZE Y NUMBER(22)
GROUP_APPID Y VARCHAR2(8)
APPLY_SET_IDFK Y NUMBER(22)
NUM_ATTEMPTS N NUMBER(22)
TIMEOUT N DATE(7)

Table: DFW_DOWNLOAD_CYCLE
Field name Null Type Description
DFW_CYCLE_ID N NUMBER(22)
CYCLE_NAME Y VARCHAR2(32)
CYCLE_STATE Y NUMBER(22)
INIT_NUM_REQ Y NUMBER(22)
INIT_NUM_ERR Y NUMBER(22)
INIT_NUM_SUCCESS Y NUMBER(22)
LAST_PACKET_SENT Y NUMBER(22)
RETRIES Y NUMBER(22)
REPEATS Y NUMBER(22)
GROUP_APPID Y VARCHAR2(8)
FULL_AUTO Y NUMBER(22)
PRIORITY Y NUMBER(22)
SUCCESS_THRESHOLD Y NUMBER(22)
PATCH_FILE_PATH Y VARCHAR2(255)
STREAM_ID Y NUMBER(22)
PACKET_SIZE Y NUMBER(22)
EXPIRATION Y NUMBER(22)
PATCH_LEN Y NUMBER(22)
PROTOCOL Y NUMBER(22)
RCE_TYPE Y NUMBER(22)
RCE_MODEL Y NUMBER(22)
NUM_PKTS Y NUMBER(22)
FW_VERSION Y NUMBER(22)
FW_BUILD_NUM Y NUMBER(22)
TO_VERSION Y NUMBER(22)
TO_BUILD_NUM Y NUMBER(22)
BOOT_LOADER_VERSION Y NUMBER(22)
APPLY_WAIT_TIME Y NUMBER(22)
LAST_APPLY_SET Y NUMBER(22)
CHANGE_TYPE_TO Y NUMBER(22)
MIN_RECEIVED_PACKETS Y NUMBER(22)
MAX_PACKET_REPEATS Y NUMBER(22)
MAX_APPLY_REPEATS Y NUMBER(22)

Table: DFW_DC_STATES
Field name Null Type Description
STATE_ID N NUMBER(22)
STATE_NAME N VARCHAR2(25)

Table: DFW_APPLY_SET
Field name Null Type Description
SETID N NUMBER(22)
SET_NAME Y VARCHAR2(80)
CYCLE_IDFK Y NUMBER(22)
STATUS_IDFK Y NUMBER(22)
NUM_REQ Y NUMBER(22)
NUM_ERR Y NUMBER(22)
NUM_SUCCESS Y NUMBER(22)

Table: DFW_APPLY_RCES
Field name Null Type Description
SETID_FK N NUMBER(22)
SERIALNUM_FK N NUMBER(22)

Table: DEVICETYPES
Field name Null Type Description
DEVICETYPE Y NUMBER(22)
DEVCAP Y VARCHAR2(20)

Table: DEVICERELATIONXREF
Device relationship cross reference for OC
Field name Null Type Description
RELATIONTYPE N NUMBER(22) Relationship Code.
  • 1
  • 2
  • 3
DESCRIP N VARCHAR2(21) Device Type.
  • In-Home Display
  • DSI Module
  • Demand Response Unit
SHORTDESC N VARCHAR2(4) Abbreviation for device type.
  • IHD
  • DSI
  • DRU

Table: DEVICERELATIONS
Field name Null Type Description
PRISERIALNUMBER N NUMBER(22)
SECSERIALNUMBER N NUMBER(22)
RELATIONTYPE N NUMBER(22)
USER1 Y VARCHAR2(17)
USER2 Y VARCHAR2(17)
UPDATEFLAG Y NUMBER(22)

Table: DEVICELOCXREF
Field name Null Type Description
DEVICELOC Y VARCHAR2(6)
DEVICELOCLONGDESC Y VARCHAR2(32)

Table: DETECTXREF
Field name Null Type Description
DETECTNAME Y CHAR(4)
DETECTNUMBER N NUMBER(22)

Table: DEMINTERVAL
Field name Null Type Description
DEMINTERVALMIN Y NUMBER(22)
DEMSUBINTERVALMIN Y NUMBER(22)

Table: DEMANDRESETHISTORY
Field name Null Type Description
UTILACCTID Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
METERREADTYPE Y NUMBER(22)
METERREADIND Y NUMBER(22)
METERBEFORERESETDT Y DATE(7)
METERBEFORERESETCOUNTER Y NUMBER(22)
METERAFTERRESETDT Y DATE(7)
METERAFTERRESETCOUNTER Y NUMBER(22)
METERRESETSTATUSTNS Y NUMBER(22)
METERRESETSTATUSSCE Y NUMBER(22)
METERRESETSTATUSRCE Y NUMBER(22)
METERRESETQUALITYCODE Y NUMBER(22)
METERRESET2WAYFUNCTION Y NUMBER(22)
METERRESET2WAYGROUP Y NUMBER(22)
METERRESET2WAYUNIT Y NUMBER(22)
METERRESETRETRYCOUNT Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)

Table: DELHRLYGRPS
Field name Null Type Description
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)
HRLYGRP Y NUMBER(22)

Table: DECOTITLE
Field name Null Type Description
TITLEID N NUMBER(22)
EXCHANGETYPEID N NUMBER(22)
TITLENAME Y VARCHAR2(48)

Table: DECOPARM
Field name Null Type Description
EXCHANGETYPEID N NUMBER(22)
COMMANDID N NUMBER(22)
TITLEID Y NUMBER(22)
PARMORDER Y NUMBER(22)
PARMBYTES Y NUMBER(22)
PARMBITS Y NUMBER(22)
PARMOFFSET Y NUMBER(22)
PARMOUT Y NUMBER(22)
PARMFORMAT Y NUMBER(22)
PARMNAME Y VARCHAR2(48)

Table: DECOCMD
Field name Null Type Description
EXCHANGETYPEID N NUMBER(22)
COMMANDID N NUMBER(22)
TITLEID Y NUMBER(22)
COMMANDBYTES Y NUMBER(22)
COMMANDPARMS Y NUMBER(22)
COMMANDSUB1 Y NUMBER(22)
COMMANDSUB2 Y NUMBER(22)
COMMANDNAME Y VARCHAR2(48)

Table: DCSI_SCHED_ERR_LOG
Field name Null Type Description
ERR_DATE Y DATE(7)
ERR_DESC Y VARCHAR2(255)

Table: DCSI_JOB_QUEUE_STATUS
Field name Null Type Description
CURR_STATUS Y VARCHAR2(8)
SINCE_DATE Y DATE(7)
INTERVAL_AMT Y NUMBER(22)
INTERVAL_UNIT Y VARCHAR2(3)

Table: DCSI_JOB_QUEUE
Field name Null Type Description
JOBNO N NUMBER(22)
JOBDESC Y VARCHAR2(255)
NXT_RUN_DATE N DATE(7)
STATUS N VARCHAR2(12)
SCHED_USER_ID1 Y NUMBER(22)
SCHED_USER_ID2 Y NUMBER(22)
COMMAND N VARCHAR2(255)

Table: DCSI_JOB_INTERVALS
Field name Null Type Description
JOBNO N NUMBER(22)
CREATE_DATE Y DATE(7)
START_DATE Y DATE(7)
STOP_DATE Y DATE(7)
CREATE_ID Y NUMBER(22)
RETURN_ID Y NUMBER(22)
REPEAT_UNIT Y VARCHAR2(3)
REPEAT_INTERVAL Y NUMBER(22)
DELAY_FLAG Y NUMBER(22)
MONDAY Y NUMBER(22)
TUESDAY Y NUMBER(22)
WEDNESDAY Y NUMBER(22)
THURSDAY Y NUMBER(22)
FRIDAY Y NUMBER(22)
SATURDAY Y NUMBER(22)
SUNDAY Y NUMBER(22)

Table: DATATYPE
Field name Null Type Description
DATATYPEID N NUMBER(22)
DATATYPE N VARCHAR2(40)
DATATYPEDESC Y VARCHAR2(80)

Table: DASVR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: CYCLEBILLWINDOW
Field name Null Type Description
CALDATE N DATE(7)
CYCLELIST N VARCHAR2(50)

Table: CSTRESPONSELOG
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
CSTSTATE Y NUMBER(22)
CSTVOLTAGE Y NUMBER(22)
CSTNEUTRALCURRENT Y NUMBER(22)
DIAGNOSTIC Y NUMBER(22)
CMDSENTDT Y DATE(7)
LOWVOLWARNCNT Y NUMBER(22)
LOWVOLALARMCNT Y NUMBER(22)
HIGHVOLWARNCNT Y NUMBER(22)
HIGHVOLALARMCNT Y NUMBER(22)
VOLNORMINALCNT Y NUMBER(22)
VOLCNTSTARTDT Y DATE(7)
OPENSTATUSCNT Y NUMBER(22)
CLOSESTATUSCNT Y NUMBER(22)
STATUSCNTSTARTDT Y DATE(7)
NEUTRALCURRENTINPUT Y NUMBER(22)
SERVICEVOLT Y NUMBER(22)
CAPBANKCONNECTION Y NUMBER(22)
SENSE1CONFIG Y NUMBER(22)
SENSE2CONFIG Y NUMBER(22)
HEADERALARMBIT Y NUMBER(22)
EXESTATUSFLAG Y NUMBER(22)
EXEERRORCODE Y NUMBER(22)
COMMSTATUS Y NUMBER(22)
GROUPID Y NUMBER(22)
RESPONSESTATUSDT Y DATE(7)
RESPONSESTATUSTNS Y NUMBER(22)
RESPONSESTATUSSCE Y NUMBER(22)
RESPONSESTATUSRCE Y NUMBER(22)
USERNAME Y VARCHAR2(32)
LOCALREMOTE Y NUMBER(22)
ALARM Y NUMBER(22)

Table: CSTLST
Field name Null Type Description
JOBID N NUMBER(22)
SERIALNUMBER Y NUMBER(22)

Table: CSTJOBTYPEXREF
Field name Null Type Description
JOBTYPEID Y NUMBER(22)
JOBTYPETEXT Y VARCHAR2(20)

Table: CSTJOB
Field name Null Type Description
JOBID N NUMBER(22)
JOBNAME Y VARCHAR2(41)
JOBTYPE Y NUMBER(22)
DCSIJOBNO Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SUBID Y NUMBER(22)
BUSID Y NUMBER(22)
FDRID Y NUMBER(22)
PHASE Y NUMBER(22)
PREMISEID Y VARCHAR2(21)
CSTDEVICEID Y VARCHAR2(21)
CSTGPSCOORDINATES Y VARCHAR2(21)
CSTCIRCUITCONFIG Y VARCHAR2(9)
CSTSWITCHGEARTYPE Y VARCHAR2(21)
CSTSWITCHGEARMODEL Y VARCHAR2(21)
CSTSWITCHGEARPHASEA Y VARCHAR2(21)
CSTSWITCHGEARPHASEB Y VARCHAR2(21)
CSTSWITCHGEARPHASEC Y VARCHAR2(21)
CSTSWITCHGEARDT Y DATE(7)
CSTKVARPERPHASE Y VARCHAR2(21)
CSTUSER1 Y VARCHAR2(21)
CSTUSER2 Y VARCHAR2(21)
CSTUSER3 Y VARCHAR2(21)
CSTUSER4 Y VARCHAR2(21)
CSTUSER5 Y VARCHAR2(21)

Table: CSTCONTROLSTATEXREF
Field name Null Type Description
STATEID Y NUMBER(22)
STATETEXT Y VARCHAR2(20)

Table: CSTCOMMSTATUSXREF
Field name Null Type Description
STATUSID N NUMBER(22)
SHORTDESC Y VARCHAR2(20)
LONGDESC Y VARCHAR2(60)

Table: CSTACCTS
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID Y NUMBER(22)
CSTDEVICEID Y VARCHAR2(21)
CSTGPSCOORDINATES Y VARCHAR2(21)
CSTCIRCUITCONFIG Y VARCHAR2(9)
CSTSWITCHGEARTYPE Y VARCHAR2(21)
CSTSWITCHGEARMODEL Y VARCHAR2(21)
CSTSWITCHGEARPHASEA Y VARCHAR2(21)
CSTSWITCHGEARPHASEB Y VARCHAR2(21)
CSTSWITCHGEARPHASEC Y VARCHAR2(21)
CSTSWITCHGEARDT Y DATE(7)
CSTKVARPERPHASE Y VARCHAR2(21)
CSTSTATE Y NUMBER(22)
CSTUSER1 Y VARCHAR2(21)
CSTUSER2 Y VARCHAR2(21)
CSTUSER3 Y VARCHAR2(21)
CSTUSER4 Y VARCHAR2(21)
CSTUSER5 Y VARCHAR2(21)

Table: CSRHISTORY
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
METERACCTNUMBER Y VARCHAR2(21)
METERNUMBER Y VARCHAR2(21)
METERRDDATE Y DATE(7)
METERKWH Y VARCHAR2(12)
METERKW Y VARCHAR2(9)
METERONPEAKKWH Y VARCHAR2(12)
METEROFFPEAKKWH Y VARCHAR2(12)
METERONPEAKKW Y VARCHAR2(9)
METEROFFPEAKKW Y VARCHAR2(9)
RESETFLAG Y VARCHAR2(1)
RETYPE Y VARCHAR2(2)
METERRATECLASS Y VARCHAR2(9)
USERNAME Y VARCHAR2(15)
RESETCOUNT Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)

Table: CONNECTIONPROFILES
Field name Null Type Description
CONNECTIONPROFILEID N NUMBER(22)
CONNECTIONPROFILENAME N VARCHAR2(50)
READTIMEOUT Y NUMBER(22)
WRITETIMEOUT Y NUMBER(22)
CONNECTATTEMPTS Y NUMBER(22)
READRETRIES Y NUMBER(22)
POLLINGINTERVAL Y NUMBER(22)
PINGTIMEOUT Y NUMBER(22)
STANDARDFLAG Y NUMBER(22)

Table: CONMON_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: CONFIG_JOB
Field name Null Type Description
CFGJOBID N NUMBER(22)
CFGJOBTYPE N NUMBER(22)
CFGJOBNAME Y VARCHAR2(255)
CFGJOBSTATUS Y NUMBER(22)
TOTALNUMOFUNITS Y NUMBER(22)
CFGTYPE Y NUMBER(22)
CFGJOBSTARTDATE Y DATE(7)
CFGJOBENDDATE Y DATE(7)
UTILACCTID Y NUMBER(22)
USERID Y VARCHAR2(30)
SCHEDSTARTJOBNO Y NUMBER(22)
SCHEDENDJOBNO Y NUMBER(22)

Table: CONFIG_CMDLST
Field name Null Type Description
CFGJOBID N NUMBER(22)
CFGJOBTYPE N NUMBER(22)
CFGJOBNAME Y VARCHAR2(255)
CFGJOBSTATUS Y NUMBER(22)
CONFIGTYPE N NUMBER(22)
CONFIGSTATE Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
NAMEDCFGID Y NUMBER(22)
NAMEDCFGTEXT Y VARCHAR2(255)
CCESTATUS Y NUMBER(22)
SCESTATUS Y NUMBER(22)
RCESTATUS Y NUMBER(22)
EXCHANGEIDDONE Y NUMBER(22)
CCECRC Y NUMBER(22)
NUMBEROFTRIES Y NUMBER(22)
CFGJOBDATE Y DATE(7)

Table: CONFIG_CHANNEL_DATA
Field name Null Type Description
METERCLASS N NUMBER(22)
CHANNELREG Y NUMBER(22)
CHANNELNUM N NUMBER(22)
SAMPLERATE Y NUMBER(22)
ACTIVEFLAG N VARCHAR2(2)
SIGNBIT Y NUMBER(22)
DATAORDER Y NUMBER(22)
STORAGELEN Y NUMBER(22)
SCALEFACTOR Y NUMBER(22)
FORMAT Y NUMBER(22)
MODECALC Y NUMBER(22)
DATASOURCEID Y NUMBER(22)
PADBITS Y NUMBER(22)

Table: CONFIGTYPE
Field name Null Type Description
CONFIGTYPEID Y NUMBER(22)
CONFIGTYPENAME Y VARCHAR2(48)

Table: CONFIGSVR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: COMMFRONTEND
Field name Null Type Description
COMMID N NUMBER(22)
COMMIDNAME Y VARCHAR2(16)
COMMBD N NUMBER(22)
COMMPORT N NUMBER(22)
COMMPORTNAME Y VARCHAR2(16)
COMMLINETYPE Y NUMBER(22)
COMMPORTF1 Y CHAR(1)
COMMPORTF2 Y CHAR(1)
COMMPORTF3 Y CHAR(1)
COMMPORTF4 Y CHAR(1)
COMMPORTF5 Y CHAR(1)
COMMNAME Y VARCHAR2(32)
COMMCMDMSG Y VARCHAR2(20)
COMMDLAVAIL Y DATE(7)
COMMBVAR Y VARCHAR2(32)
COMMLSCE Y NUMBER(22)
COMMLSCEUP Y NUMBER(22)
COMMSCEPTR Y NUMBER(22)
COMMLTMSY Y NUMBER(22)
COMMLTMSLT Y NUMBER(22)
COMMLCMDWS Y NUMBER(22)
COMMLCMDSLT Y NUMBER(22)
COMMLLONKENBT Y NUMBER(22)
COMMLDLYAVL Y NUMBER(22)
COMMBSTAT Y VARCHAR2(16)

Table: COMMERCIALMETERREGID
Field name Null Type Description
COMMERCIALMETERTYPE Y NUMBER(22)
COMMERCIALMETERTYPEID Y NUMBER(22)
COMMERCIALMETERRATECLASS Y VARCHAR2(9)
COMMERCIALMETERREGISTIDKWH Y NUMBER(22)
COMMERCIALMETERREGISTIDKW Y NUMBER(22)
COMMERCIALMETERREGISTIDOPKWH Y NUMBER(22)
COMMERCIALMETERREGISTIDOFFPKWH Y NUMBER(22)
COMMERCIALMETERREGISTIDOPKW Y NUMBER(22)
COMMERCIALMETERREGISTIDOFFPKW Y NUMBER(22)
COMMERCIALMETERKWHDESC Y VARCHAR2(12)
COMMERCIALMETERKWDESC Y VARCHAR2(12)
COMMERCIALMETEROPKWHDESC Y VARCHAR2(12)
COMMERCIALMETEROFFPKWHDESC Y VARCHAR2(12)
COMMERCIALMETEROPKWDESC Y VARCHAR2(12)
COMMERCIALMETEROFFPKWDESC Y VARCHAR2(12)
COMMERCIALMETERREGISTIDKWDATE Y NUMBER(22)
COMMERCIALMETERKWDATEDESC Y VARCHAR2(12)
COMMERCIALMETERREGISTIDKWPREV Y NUMBER(22)
COMMERCIALMETERKWPREVDESC Y VARCHAR2(12)
COMMERCIALMETERREGISTIDKWPRVDT Y NUMBER(22)
COMMERCIALMETERKWDATEPREVDESC Y VARCHAR2(12)
COMMERCIALMETERREGISTIDDEMRSET Y NUMBER(22)
COMMERCIALMETERDEMRESETDESC Y VARCHAR2(12)

Table: CMTTYPE
Field name Null Type Description
CMTTYPEID Y NUMBER(22)
CMTTYPENAME Y VARCHAR2(18)
CMTTYPEPSWDTEXT Y VARCHAR2(10)
CMTTYPEPSWDHEX Y RAW(11)
CMTTYPEENCRYPT Y NUMBER(22)
CMTTYPELONGNAME Y VARCHAR2(62)

Table: CMTCMDSUMMARY
Field name Null Type Description
CMTTYPEID Y NUMBER(22)
BILLTYPE Y NUMBER(22)
BILLTYPEDESC Y VARCHAR2(10)
NUMBERRDREGCMD Y NUMBER(22)
NUMBERMAPREGCMD Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)

Table: CMTCMDPARAM
Field name Null Type Description
CMTTYPEID N NUMBER(22)
BILLTYPE N NUMBER(22)
BILLTYPEDESC Y VARCHAR2(10)
MAPREGISTERID Y NUMBER(22)
DATAREGISTERID Y NUMBER(22)
DAILYSHIFTREGISTERID Y NUMBER(22)
DATANAMEID N NUMBER(22)
DATASHORTNAME Y VARCHAR2(8)
DATANAME Y VARCHAR2(30)
DATAADDRESSRAW Y RAW(3)
DATALENGTH Y NUMBER(22)
DATADECOFMT Y NUMBER(22)
DATADPLOC Y NUMBER(22)
DATASELECT Y NUMBER(22)
RDREGSEQ Y NUMBER(22)
MAPREGSEQ Y NUMBER(22)
METERRATECLASS N VARCHAR2(9)
DATATYPEID Y NUMBER(22)
CONVID Y NUMBER(22)
MULTIPLIER Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y NUMBER(22)

Table: CMTCMDCONFIG
Field name Null Type Description
CMTTYPEID Y NUMBER(22)
BILLTYPE Y NUMBER(22)
BILLTYPEDESC Y VARCHAR2(10)
RDREGCMDSEQNUM Y NUMBER(22)
RDREGCMDLENGTH Y NUMBER(22)
RDREGCMDSEQDELAY Y NUMBER(22)
RDREGCMDSEQRETRY Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)

Table: CMDHNDLR_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: CITYSUBXREF
Field name Null Type Description
CITYNO N NUMBER(22)
SUBID N NUMBER(22)
SUBNAME Y VARCHAR2(25)

Table: CITYSUB
Field name Null Type Description
CITYNM N VARCHAR2(32)
CITYNO N NUMBER(22)

Table: CISTIQ
Field name Null Type Description
TRANSACTIONTYPE N VARCHAR2(9)
MODULEID N NUMBER(22)
SERIALPORT Y NUMBER(22)
TABLENAME Y VARCHAR2(30)
COLUMNNAME Y VARCHAR2(30)
COLUMNTEXT Y VARCHAR2(30)
COLUMNVALUE Y NUMBER(22)

Table: CHASETXREF
Field name Null Type Description
CHASET N CHAR(1)
CHASET1 Y CHAR(1)
CHASETVAL Y NUMBER(22)
CHA1 Y NUMBER(22)
CHA1BITVAL Y NUMBER(22)
CHA2 Y NUMBER(22)
CHA2BITVAL Y NUMBER(22)
CHA3 Y NUMBER(22)
CHA3BITVAL Y NUMBER(22)
CHA4 Y NUMBER(22)
CHA4BITVAL Y NUMBER(22)
CHA5 Y NUMBER(22)
CHA5BITVAL Y NUMBER(22)
CHA6 Y NUMBER(22)
CHA6BITVAL Y NUMBER(22)

Table: CFGSTATEXREF
Field name Null Type Description
CFGSTATEID Y NUMBER(22)
CFGSTATEDESC N VARCHAR2(255)

Table: CFGJOBTYPE
Field name Null Type Description
JOBTYPEID Y NUMBER(22)
JOBTYPENAME N VARCHAR2(48)

Table: CFGJOBSTATUS
Field name Null Type Description
JOBSTATUSID Y NUMBER(22)
JOBSTATUSNAME N VARCHAR2(255)

Table: CFGFEATURE_CONTROL_XREF
Field name Null Type Description
FEATURECONTROLID N NUMBER(22)
RCDTYPEID N NUMBER(22)
DATAID N NUMBER(22)

Table: CFGFEATURE_CONTROL
Field name Null Type Description
FEATURECONTROLID N NUMBER(22)
FEATURECONTROLDESC N VARCHAR2(48)

Table: CANT_USE_GROUPS
Field name Null Type Description
HRLYGRP Y NUMBER(22)

Table: BUS
Field name Null Type Description
SUBID N NUMBER(22)
BUSID N NUMBER(22)
BUSNAME Y VARCHAR2(8)
TIMESLICEACT Y CHAR(1)
TIMESLICEENABLE Y CHAR(1)
EQUIPTYPEID Y NUMBER(22)
TIMESLICESAVESTATE Y CHAR(1)

Table: BKUP_OPTIMUM_OBJECT_REFERENCE
Field name Null Type Description
METERNUMBER N VARCHAR2(21)
SERIALNUMBER N NUMBER(22)
UTILACCTID N NUMBER(22)
METER_OBJECTID Y VARCHAR2(128)
SERVICELOCATION_OBJECTID Y VARCHAR2(128)
CUSTOMER_OBJECTID Y VARCHAR2(128)
UPDATED_AT N DATE(7)

Table: BITMAPXREF
THIS TABLE HOLDS THE BITMAPS USED BY THE SCEMAIN APPLICATION.
Field name Null Type Description
ID Y VARCHAR2(20)
NAME Y VARCHAR2(20)
BITMAP Y LONG RAW(0)

Table: BINNINGXREF
Field name Null Type Description
INQC N NUMBER(22)
REPOUTQC Y VARCHAR2(2)
OUTQC Y VARCHAR2(3)
REPOUTVALUE Y VARCHAR2(2)
OUTVALUE Y VARCHAR2(12)
REPINVBINQC Y VARCHAR2(2)
INVBINQC Y VARCHAR2(3)
REPINVBINVALUE Y VARCHAR2(2)
INVBINVALUE Y VARCHAR2(12)

Table: BINNINGKWHXREF
Field name Null Type Description
ALTIMUSTYPEID Y NUMBER(22)
BILLTYPE Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)
DATANAMEID Y NUMBER(22)

Table: BINNINGKWH
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID N NUMBER(22)
LOGDATE Y DATE(7)
KWH Y NUMBER(22)

Table: BILLWINDOWPRIORITY
Field name Null Type Description
BILLINGWINDOWDAY N NUMBER(22)
PRIORITYDELTA N NUMBER(22)

Table: BFUCMDPARAM
Field name Null Type Description
BFUMETERID Y NUMBER(22)
BFUTYPEID Y NUMBER(22)
BILLTYPE Y NUMBER(22)
MAPREGISTERID Y NUMBER(22)
METERRATECLASS Y VARCHAR2(9)
DATAORDER Y NUMBER(22)
DATATYPEID Y NUMBER(22)
DATABLOCK Y NUMBER(22)
DATAOFFSET Y NUMBER(22)

Table: BATPRETIQ
Field name Null Type Description
TRANSACTIONTYPE N VARCHAR2(9)
RECORDTYPE N VARCHAR2(9)
SERIALNUMBER N NUMBER(22)
PROCESSTYPE Y VARCHAR2(9)
TRANSACTIONTYPEID Y NUMBER(22)
RECORDTYPEID Y NUMBER(22)
DATA Y VARCHAR2(383)
RECORDORDER Y NUMBER(22)
STAMP Y DATE(7)

Table: BATCH_INPQ
Field name Null Type Description
SUBSYSID Y NUMBER(22)
PRIORITY Y NUMBER(22)
STAMP Y DATE(7)
USERNAME Y VARCHAR2(32)
GROUPID Y NUMBER(22)
PRI Y NUMBER(22)
TNSCMDTIMEOUT Y DATE(7)
SUBCMDTIMEOUT Y NUMBER(22)
SUBID Y NUMBER(22)
MSEXID Y NUMBER(22)
SUBEXID Y NUMBER(22)
FUNCCODE Y NUMBER(22)
EXTYPE Y NUMBER(22)
UTILACCTID Y NUMBER(22)
CMDDATA Y VARCHAR2(255)

Table: APMTRANSLOG
Field name Null Type Description
TIMESTAMP Y DATE(7)
SERIALNUMBER Y NUMBER(22)
OLDSUBID Y NUMBER(22)
OLDBUSID Y NUMBER(22)
OLDFDRID Y NUMBER(22)
OLDPHASE Y NUMBER(22)
OLDSIGNAL Y NUMBER(22)
OLDDETECTION Y NUMBER(22)
NEWSUBID Y NUMBER(22)
NEWBUSID Y NUMBER(22)
NEWFDRID Y NUMBER(22)
NEWPHASE Y NUMBER(22)
NEWSIGNAL Y NUMBER(22)
NEWDETECTION Y NUMBER(22)
LOG_COMMENT Y VARCHAR2(255)
TRANTYPE Y VARCHAR2(1)
LOGTYPE Y VARCHAR2(1)

Table: APMTEMPSTOR
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
SEQNO Y NUMBER(22)
APMSUBID Y NUMBER(22)
APMBUSID Y NUMBER(22)
APMFDRID Y NUMBER(22)
PHASE Y NUMBER(22)
SIGNAL Y NUMBER(22)
DETECTION Y NUMBER(22)
STATUS Y CHAR(1)

Table: APMSCHEDGRPSRCH
Field name Null Type Description
SERIALNUMBER Y NUMBER(22)
LINKNO Y NUMBER(22)

Table: APMGRPSRCH
Field name Null Type Description
SUBSYSID Y NUMBER(22)
GROUPID Y NUMBER(22)
SERIALNUMBER N NUMBER(22)
SUBID N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
PHASE N NUMBER(22)
SIGNAL N NUMBER(22)
DETECTION N NUMBER(22)
PROTECTIVEDEVICE N VARCHAR2(13)
ISUBID Y NUMBER(22)
IBUSID Y NUMBER(22)
IFDRID Y NUMBER(22)
IPHASE Y NUMBER(22)
ISIGNAL Y NUMBER(22)
IDETECTION Y NUMBER(22)
USEALTPMAP Y NUMBER(22)
STATUS Y CHAR(1)

Table: APIOUT
Field name Null Type Description
CSSID Y NUMBER(22)
UNIQUENO Y NUMBER(22)
UTILACCTID Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
READTYPE Y NUMBER(22)
READIND Y NUMBER(22)
KWH Y NUMBER(22)
KW Y NUMBER(22)
ONPEAKKWH Y NUMBER(22)
OFFPEAKKWH Y NUMBER(22)
ONPEAKKW Y NUMBER(22)
OFFPEAKKW Y NUMBER(22)
READDT Y DATE(7)
QUALITYCODE Y NUMBER(22)
RESETCNT Y NUMBER(22)
BLINKCNT Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)
SUBNAME Y VARCHAR2(25)
BUSNAME Y VARCHAR2(8)
FEEDERNAME Y VARCHAR2(12)
PHASENAME Y CHAR(4)
DETECTNAME Y CHAR(4)
SIGNALNAME Y CHAR(4)

Table: APIIN
Field name Null Type Description
CSSID Y NUMBER(22)
UNIQUENO Y NUMBER(22)
UTILACCTID Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
READTYPE Y NUMBER(22)
READIND Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)

Table: ANSITABLE
Field name Null Type Description
RCDTYPEID N NUMBER(22)
DATAID N NUMBER(22)
EXCHANGEID Y NUMBER(22)
COMMANDID Y NUMBER(22)
COMMANDNAME Y VARCHAR2(48)
LENGTH N NUMBER(22)
TABLEID N NUMBER(22)
OFFSET N NUMBER(22)
PARMNAME Y VARCHAR2(48)

Table: AMRUSAGE
Field name Null Type Description
USAGEID N NUMBER(22)
USAGENAME Y VARCHAR2(30)

Table: AMRTYPE
Field name Null Type Description
TYPEID N NUMBER(22)
TYPENAME Y VARCHAR2(30)

Table: AMRTOBILLFAIL
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
AMRCALJOBNO Y NUMBER(22)
AMRCLASSID N NUMBER(22)
AMRREADIND Y VARCHAR2(4)
METERRATECLASS Y VARCHAR2(9)
METERACCTNUMBER Y VARCHAR2(21)
METERNUMBER Y VARCHAR2(21)
SETID Y VARCHAR2(32)
SETVALUE Y VARCHAR2(32)
METERQUALITYCODE Y VARCHAR2(2)
METERCYCLENUMBER Y NUMBER(22)
METERUSER1 Y VARCHAR2(17)
METERUSER2 Y VARCHAR2(17)
METERREADDT Y DATE(7)
PREMISEID Y VARCHAR2(21)
PHASE Y NUMBER(22)
METERROUTEID Y VARCHAR2(9)
REGISTER1 Y VARCHAR2(20)
REGISTER2 Y VARCHAR2(20)
REGISTER3 Y VARCHAR2(20)
REGISTER4 Y VARCHAR2(20)
REGISTER5 Y VARCHAR2(20)
REGISTER6 Y VARCHAR2(20)
REGISTER7 Y VARCHAR2(20)
REGISTER8 Y VARCHAR2(20)
REGISTER9 Y VARCHAR2(20)
REGISTER10 Y VARCHAR2(20)
REGISTER11 Y VARCHAR2(20)
REGISTER12 Y VARCHAR2(20)
REGISTER13 Y VARCHAR2(20)
REGISTER14 Y VARCHAR2(20)
REGISTER15 Y VARCHAR2(20)
REGISTER16 Y VARCHAR2(20)
METERDEMRESETCOUNT Y NUMBER(22)

Table: AMRTOBILL
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
AMRCALJOBNO Y NUMBER(22)
AMRCLASSID N NUMBER(22)
AMRREADIND Y VARCHAR2(4)
METERRATECLASS Y VARCHAR2(9)
METERACCTNUMBER Y VARCHAR2(21)
METERNUMBER Y VARCHAR2(21)
SETID Y VARCHAR2(32)
SETVALUE Y VARCHAR2(32)
METERQUALITYCODE Y VARCHAR2(2)
METERCYCLENUMBER Y NUMBER(22)
METERUSER1 Y VARCHAR2(17)
METERUSER2 Y VARCHAR2(17)
METERREADDT Y DATE(7)
PREMISEID Y VARCHAR2(21)
PHASE Y NUMBER(22)
METERROUTEID Y VARCHAR2(9)
REGISTER1 Y VARCHAR2(20)
REGISTER2 Y VARCHAR2(20)
REGISTER3 Y VARCHAR2(20)
REGISTER4 Y VARCHAR2(20)
REGISTER5 Y VARCHAR2(20)
REGISTER6 Y VARCHAR2(20)
REGISTER7 Y VARCHAR2(20)
REGISTER8 Y VARCHAR2(20)
REGISTER9 Y VARCHAR2(20)
REGISTER10 Y VARCHAR2(20)
REGISTER11 Y VARCHAR2(20)
REGISTER12 Y VARCHAR2(20)
REGISTER13 Y VARCHAR2(20)
REGISTER14 Y VARCHAR2(20)
REGISTER15 Y VARCHAR2(20)
REGISTER16 Y VARCHAR2(20)
METERDEMRESETCOUNT Y NUMBER(22)

Table: AMRTEMPLATE
Field name Null Type Description
TEMPLATEID N NUMBER(22)
TEMPLATENAME N VARCHAR2(50)
USAGEID N NUMBER(22)
TYPEID N NUMBER(22)
DATETIMEID N NUMBER(22)
LENGTHOFLINE N NUMBER(22)
QUALITYCODEID N NUMBER(22)
OPFILENAME N VARCHAR2(100)
BKOPFILENAME Y VARCHAR2(100)
SIGNID Y VARCHAR2(1)
TWACSHDRTLR Y VARCHAR2(1)

Table: AMRSECONDSETID
Field name Null Type Description
SETID N VARCHAR2(32)
SETVALUE N VARCHAR2(32)
AMRCALJOBNO N NUMBER(22)

Table: AMRREADTYPE
Field name Null Type Description
AMRREADTYPE N NUMBER(22)
AMRREADTYPEDESC Y VARCHAR2(12)
AMRCMDLIST Y NUMBER(22)
AMRMETERACCTS Y NUMBER(22)
AMRRESPONSELOG Y NUMBER(22)

Table: AMRREADINDAUX
Field name Null Type Description
AMRREADIND N NUMBER(22)
RECURCMD Y VARCHAR2(4000)
USEAMRJOBDATA Y NUMBER(22)
LONGDESC Y VARCHAR2(4000)
COMMSTR Y VARCHAR2(255)
PRIMARYDATA Y NUMBER(22)
CMDLSTDESC Y VARCHAR2(250)

Table: AMRREADIND
Field name Null Type Description
AMRREADIND N NUMBER(22)
AMRREADINDDESC Y VARCHAR2(21)
AMRREADINDSHORTDESC Y VARCHAR2(4)

Table: AMRQUALITYCODE
Field name Null Type Description
QUALITYCODEID N NUMBER(22)
QUALITYCODEVALUE Y VARCHAR2(50)

Table: AMRPADDING
Field name Null Type Description
PADID N NUMBER(22)
PADNAME Y VARCHAR2(15)
PADVALUE Y VARCHAR2(1)

Table: AMRMESSAGES
Field name Null Type Description
MSGID N NUMBER(22)
MSGNAME Y VARCHAR2(100)

Table: AMRLORPADTYPE
Field name Null Type Description
LORPADID N NUMBER(22)
LORPADNAME Y VARCHAR2(15)

Table: AMRJOBSUMMARY
Field name Null Type Description
AMRCALJOBNO N NUMBER(22)
MAPMTRCNT Y NUMBER(22)
NONMAPMTRCNT Y NUMBER(22)
FAILURES Y NUMBER(22)

Table: AMRJOBDATA
Field name Null Type Description
AMRCALJOBNO N NUMBER(22)
CALHISTDATE Y NUMBER(22)
CALHISTHOUR Y NUMBER(22)
HISTDATE Y DATE(7)
CHANNEL Y NUMBER(22)
BILLCYCLEDATE Y DATE(7)
REPEATINTERVAL Y NUMBER(22)
BILLTYPE Y NUMBER(22)

Table: AMRINTERVALDATA30
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
LOGDATE N DATE(7)
QUALITYCODE01 Y NUMBER(22)
INTERVALDATA01 Y NUMBER(22)
QUALITYCODE02 Y NUMBER(22)
INTERVALDATA02 Y NUMBER(22)
QUALITYCODE03 Y NUMBER(22)
INTERVALDATA03 Y NUMBER(22)
QUALITYCODE04 Y NUMBER(22)
INTERVALDATA04 Y NUMBER(22)
QUALITYCODE05 Y NUMBER(22)
INTERVALDATA05 Y NUMBER(22)
QUALITYCODE06 Y NUMBER(22)
INTERVALDATA06 Y NUMBER(22)
QUALITYCODE07 Y NUMBER(22)
INTERVALDATA07 Y NUMBER(22)
QUALITYCODE08 Y NUMBER(22)
INTERVALDATA08 Y NUMBER(22)
QUALITYCODE09 Y NUMBER(22)
INTERVALDATA09 Y NUMBER(22)
QUALITYCODE10 Y NUMBER(22)
INTERVALDATA10 Y NUMBER(22)
QUALITYCODE11 Y NUMBER(22)
INTERVALDATA11 Y NUMBER(22)
QUALITYCODE12 Y NUMBER(22)
INTERVALDATA12 Y NUMBER(22)
QUALITYCODE13 Y NUMBER(22)
INTERVALDATA13 Y NUMBER(22)
QUALITYCODE14 Y NUMBER(22)
INTERVALDATA14 Y NUMBER(22)
QUALITYCODE15 Y NUMBER(22)
INTERVALDATA15 Y NUMBER(22)
QUALITYCODE16 Y NUMBER(22)
INTERVALDATA16 Y NUMBER(22)
QUALITYCODE17 Y NUMBER(22)
INTERVALDATA17 Y NUMBER(22)
QUALITYCODE18 Y NUMBER(22)
INTERVALDATA18 Y NUMBER(22)
QUALITYCODE19 Y NUMBER(22)
INTERVALDATA19 Y NUMBER(22)
QUALITYCODE20 Y NUMBER(22)
INTERVALDATA20 Y NUMBER(22)
QUALITYCODE21 Y NUMBER(22)
INTERVALDATA21 Y NUMBER(22)
QUALITYCODE22 Y NUMBER(22)
INTERVALDATA22 Y NUMBER(22)
QUALITYCODE23 Y NUMBER(22)
INTERVALDATA23 Y NUMBER(22)
QUALITYCODE24 Y NUMBER(22)
INTERVALDATA24 Y NUMBER(22)
QUALITYCODE25 Y NUMBER(22)
INTERVALDATA25 Y NUMBER(22)
QUALITYCODE26 Y NUMBER(22)
INTERVALDATA26 Y NUMBER(22)
QUALITYCODE27 Y NUMBER(22)
INTERVALDATA27 Y NUMBER(22)
QUALITYCODE28 Y NUMBER(22)
INTERVALDATA28 Y NUMBER(22)
QUALITYCODE29 Y NUMBER(22)
INTERVALDATA29 Y NUMBER(22)
QUALITYCODE30 Y NUMBER(22)
INTERVALDATA30 Y NUMBER(22)
QUALITYCODE31 Y NUMBER(22)
INTERVALDATA31 Y NUMBER(22)
QUALITYCODE32 Y NUMBER(22)
INTERVALDATA32 Y NUMBER(22)
QUALITYCODE33 Y NUMBER(22)
INTERVALDATA33 Y NUMBER(22)
QUALITYCODE34 Y NUMBER(22)
INTERVALDATA34 Y NUMBER(22)
QUALITYCODE35 Y NUMBER(22)
INTERVALDATA35 Y NUMBER(22)
QUALITYCODE36 Y NUMBER(22)
INTERVALDATA36 Y NUMBER(22)
QUALITYCODE37 Y NUMBER(22)
INTERVALDATA37 Y NUMBER(22)
QUALITYCODE38 Y NUMBER(22)
INTERVALDATA38 Y NUMBER(22)
QUALITYCODE39 Y NUMBER(22)
INTERVALDATA39 Y NUMBER(22)
QUALITYCODE40 Y NUMBER(22)
INTERVALDATA40 Y NUMBER(22)
QUALITYCODE41 Y NUMBER(22)
INTERVALDATA41 Y NUMBER(22)
QUALITYCODE42 Y NUMBER(22)
INTERVALDATA42 Y NUMBER(22)
QUALITYCODE43 Y NUMBER(22)
INTERVALDATA43 Y NUMBER(22)
QUALITYCODE44 Y NUMBER(22)
INTERVALDATA44 Y NUMBER(22)
QUALITYCODE45 Y NUMBER(22)
INTERVALDATA45 Y NUMBER(22)
QUALITYCODE46 Y NUMBER(22)
INTERVALDATA46 Y NUMBER(22)
QUALITYCODE47 Y NUMBER(22)
INTERVALDATA47 Y NUMBER(22)
QUALITYCODE48 Y NUMBER(22)
INTERVALDATA48 Y NUMBER(22)
INTERVALCHANNEL N NUMBER(22)

Table: AMRINTERVALDATA15
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
LOGDATE N DATE(7)
QUALITYCODE01 Y NUMBER(22)
INTERVALDATA01 Y NUMBER(22)
QUALITYCODE02 Y NUMBER(22)
INTERVALDATA02 Y NUMBER(22)
QUALITYCODE03 Y NUMBER(22)
INTERVALDATA03 Y NUMBER(22)
QUALITYCODE04 Y NUMBER(22)
INTERVALDATA04 Y NUMBER(22)
QUALITYCODE05 Y NUMBER(22)
INTERVALDATA05 Y NUMBER(22)
QUALITYCODE06 Y NUMBER(22)
INTERVALDATA06 Y NUMBER(22)
QUALITYCODE07 Y NUMBER(22)
INTERVALDATA07 Y NUMBER(22)
QUALITYCODE08 Y NUMBER(22)
INTERVALDATA08 Y NUMBER(22)
QUALITYCODE09 Y NUMBER(22)
INTERVALDATA09 Y NUMBER(22)
QUALITYCODE10 Y NUMBER(22)
INTERVALDATA10 Y NUMBER(22)
QUALITYCODE11 Y NUMBER(22)
INTERVALDATA11 Y NUMBER(22)
QUALITYCODE12 Y NUMBER(22)
INTERVALDATA12 Y NUMBER(22)
QUALITYCODE13 Y NUMBER(22)
INTERVALDATA13 Y NUMBER(22)
QUALITYCODE14 Y NUMBER(22)
INTERVALDATA14 Y NUMBER(22)
QUALITYCODE15 Y NUMBER(22)
INTERVALDATA15 Y NUMBER(22)
QUALITYCODE16 Y NUMBER(22)
INTERVALDATA16 Y NUMBER(22)
QUALITYCODE17 Y NUMBER(22)
INTERVALDATA17 Y NUMBER(22)
QUALITYCODE18 Y NUMBER(22)
INTERVALDATA18 Y NUMBER(22)
QUALITYCODE19 Y NUMBER(22)
INTERVALDATA19 Y NUMBER(22)
QUALITYCODE20 Y NUMBER(22)
INTERVALDATA20 Y NUMBER(22)
QUALITYCODE21 Y NUMBER(22)
INTERVALDATA21 Y NUMBER(22)
QUALITYCODE22 Y NUMBER(22)
INTERVALDATA22 Y NUMBER(22)
QUALITYCODE23 Y NUMBER(22)
INTERVALDATA23 Y NUMBER(22)
QUALITYCODE24 Y NUMBER(22)
INTERVALDATA24 Y NUMBER(22)
QUALITYCODE25 Y NUMBER(22)
INTERVALDATA25 Y NUMBER(22)
QUALITYCODE26 Y NUMBER(22)
INTERVALDATA26 Y NUMBER(22)
QUALITYCODE27 Y NUMBER(22)
INTERVALDATA27 Y NUMBER(22)
QUALITYCODE28 Y NUMBER(22)
INTERVALDATA28 Y NUMBER(22)
QUALITYCODE29 Y NUMBER(22)
INTERVALDATA29 Y NUMBER(22)
QUALITYCODE30 Y NUMBER(22)
INTERVALDATA30 Y NUMBER(22)
QUALITYCODE31 Y NUMBER(22)
INTERVALDATA31 Y NUMBER(22)
QUALITYCODE32 Y NUMBER(22)
INTERVALDATA32 Y NUMBER(22)
QUALITYCODE33 Y NUMBER(22)
INTERVALDATA33 Y NUMBER(22)
QUALITYCODE34 Y NUMBER(22)
INTERVALDATA34 Y NUMBER(22)
QUALITYCODE35 Y NUMBER(22)
INTERVALDATA35 Y NUMBER(22)
QUALITYCODE36 Y NUMBER(22)
INTERVALDATA36 Y NUMBER(22)
QUALITYCODE37 Y NUMBER(22)
INTERVALDATA37 Y NUMBER(22)
QUALITYCODE38 Y NUMBER(22)
INTERVALDATA38 Y NUMBER(22)
QUALITYCODE39 Y NUMBER(22)
INTERVALDATA39 Y NUMBER(22)
QUALITYCODE40 Y NUMBER(22)
INTERVALDATA40 Y NUMBER(22)
QUALITYCODE41 Y NUMBER(22)
INTERVALDATA41 Y NUMBER(22)
QUALITYCODE42 Y NUMBER(22)
INTERVALDATA42 Y NUMBER(22)
QUALITYCODE43 Y NUMBER(22)
INTERVALDATA43 Y NUMBER(22)
QUALITYCODE44 Y NUMBER(22)
INTERVALDATA44 Y NUMBER(22)
QUALITYCODE45 Y NUMBER(22)
INTERVALDATA45 Y NUMBER(22)
QUALITYCODE46 Y NUMBER(22)
INTERVALDATA46 Y NUMBER(22)
QUALITYCODE47 Y NUMBER(22)
INTERVALDATA47 Y NUMBER(22)
QUALITYCODE48 Y NUMBER(22)
INTERVALDATA48 Y NUMBER(22)
QUALITYCODE49 Y NUMBER(22)
INTERVALDATA49 Y NUMBER(22)
QUALITYCODE50 Y NUMBER(22)
INTERVALDATA50 Y NUMBER(22)
QUALITYCODE51 Y NUMBER(22)
INTERVALDATA51 Y NUMBER(22)
QUALITYCODE52 Y NUMBER(22)
INTERVALDATA52 Y NUMBER(22)
QUALITYCODE53 Y NUMBER(22)
INTERVALDATA53 Y NUMBER(22)
QUALITYCODE54 Y NUMBER(22)
INTERVALDATA54 Y NUMBER(22)
QUALITYCODE55 Y NUMBER(22)
INTERVALDATA55 Y NUMBER(22)
QUALITYCODE56 Y NUMBER(22)
INTERVALDATA56 Y NUMBER(22)
QUALITYCODE57 Y NUMBER(22)
INTERVALDATA57 Y NUMBER(22)
QUALITYCODE58 Y NUMBER(22)
INTERVALDATA58 Y NUMBER(22)
QUALITYCODE59 Y NUMBER(22)
INTERVALDATA59 Y NUMBER(22)
QUALITYCODE60 Y NUMBER(22)
INTERVALDATA60 Y NUMBER(22)
QUALITYCODE61 Y NUMBER(22)
INTERVALDATA61 Y NUMBER(22)
QUALITYCODE62 Y NUMBER(22)
INTERVALDATA62 Y NUMBER(22)
QUALITYCODE63 Y NUMBER(22)
INTERVALDATA63 Y NUMBER(22)
QUALITYCODE64 Y NUMBER(22)
INTERVALDATA64 Y NUMBER(22)
QUALITYCODE65 Y NUMBER(22)
INTERVALDATA65 Y NUMBER(22)
QUALITYCODE66 Y NUMBER(22)
INTERVALDATA66 Y NUMBER(22)
QUALITYCODE67 Y NUMBER(22)
INTERVALDATA67 Y NUMBER(22)
QUALITYCODE68 Y NUMBER(22)
INTERVALDATA68 Y NUMBER(22)
QUALITYCODE69 Y NUMBER(22)
INTERVALDATA69 Y NUMBER(22)
QUALITYCODE70 Y NUMBER(22)
INTERVALDATA70 Y NUMBER(22)
QUALITYCODE71 Y NUMBER(22)
INTERVALDATA71 Y NUMBER(22)
QUALITYCODE72 Y NUMBER(22)
INTERVALDATA72 Y NUMBER(22)
QUALITYCODE73 Y NUMBER(22)
INTERVALDATA73 Y NUMBER(22)
QUALITYCODE74 Y NUMBER(22)
INTERVALDATA74 Y NUMBER(22)
QUALITYCODE75 Y NUMBER(22)
INTERVALDATA75 Y NUMBER(22)
QUALITYCODE76 Y NUMBER(22)
INTERVALDATA76 Y NUMBER(22)
QUALITYCODE77 Y NUMBER(22)
INTERVALDATA77 Y NUMBER(22)
QUALITYCODE78 Y NUMBER(22)
INTERVALDATA78 Y NUMBER(22)
QUALITYCODE79 Y NUMBER(22)
INTERVALDATA79 Y NUMBER(22)
QUALITYCODE80 Y NUMBER(22)
INTERVALDATA80 Y NUMBER(22)
QUALITYCODE81 Y NUMBER(22)
INTERVALDATA81 Y NUMBER(22)
QUALITYCODE82 Y NUMBER(22)
INTERVALDATA82 Y NUMBER(22)
QUALITYCODE83 Y NUMBER(22)
INTERVALDATA83 Y NUMBER(22)
QUALITYCODE84 Y NUMBER(22)
INTERVALDATA84 Y NUMBER(22)
QUALITYCODE85 Y NUMBER(22)
INTERVALDATA85 Y NUMBER(22)
QUALITYCODE86 Y NUMBER(22)
INTERVALDATA86 Y NUMBER(22)
QUALITYCODE87 Y NUMBER(22)
INTERVALDATA87 Y NUMBER(22)
QUALITYCODE88 Y NUMBER(22)
INTERVALDATA88 Y NUMBER(22)
QUALITYCODE89 Y NUMBER(22)
INTERVALDATA89 Y NUMBER(22)
QUALITYCODE90 Y NUMBER(22)
INTERVALDATA90 Y NUMBER(22)
QUALITYCODE91 Y NUMBER(22)
INTERVALDATA91 Y NUMBER(22)
QUALITYCODE92 Y NUMBER(22)
INTERVALDATA92 Y NUMBER(22)
QUALITYCODE93 Y NUMBER(22)
INTERVALDATA93 Y NUMBER(22)
QUALITYCODE94 Y NUMBER(22)
INTERVALDATA94 Y NUMBER(22)
QUALITYCODE95 Y NUMBER(22)
INTERVALDATA95 Y NUMBER(22)
QUALITYCODE96 Y NUMBER(22)
INTERVALDATA96 Y NUMBER(22)
INTERVALCHANNEL N NUMBER(22)

Table: AMRHOURLYDATA_BAD
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
LOGDATE N DATE(7)
QUALITYCODE01 Y NUMBER(22)
HOURLYDATA01 Y NUMBER(22)
QUALITYCODE02 Y NUMBER(22)
HOURLYDATA02 Y NUMBER(22)
QUALITYCODE03 Y NUMBER(22)
HOURLYDATA03 Y NUMBER(22)
QUALITYCODE04 Y NUMBER(22)
HOURLYDATA04 Y NUMBER(22)
QUALITYCODE05 Y NUMBER(22)
HOURLYDATA05 Y NUMBER(22)
QUALITYCODE06 Y NUMBER(22)
HOURLYDATA06 Y NUMBER(22)
QUALITYCODE07 Y NUMBER(22)
HOURLYDATA07 Y NUMBER(22)
QUALITYCODE08 Y NUMBER(22)
HOURLYDATA08 Y NUMBER(22)
QUALITYCODE09 Y NUMBER(22)
HOURLYDATA09 Y NUMBER(22)
QUALITYCODE10 Y NUMBER(22)
HOURLYDATA10 Y NUMBER(22)
QUALITYCODE11 Y NUMBER(22)
HOURLYDATA11 Y NUMBER(22)
QUALITYCODE12 Y NUMBER(22)
HOURLYDATA12 Y NUMBER(22)
QUALITYCODE13 Y NUMBER(22)
HOURLYDATA13 Y NUMBER(22)
QUALITYCODE14 Y NUMBER(22)
HOURLYDATA14 Y NUMBER(22)
QUALITYCODE15 Y NUMBER(22)
HOURLYDATA15 Y NUMBER(22)
QUALITYCODE16 Y NUMBER(22)
HOURLYDATA16 Y NUMBER(22)
QUALITYCODE17 Y NUMBER(22)
HOURLYDATA17 Y NUMBER(22)
QUALITYCODE18 Y NUMBER(22)
HOURLYDATA18 Y NUMBER(22)
QUALITYCODE19 Y NUMBER(22)
HOURLYDATA19 Y NUMBER(22)
QUALITYCODE20 Y NUMBER(22)
HOURLYDATA20 Y NUMBER(22)
QUALITYCODE21 Y NUMBER(22)
HOURLYDATA21 Y NUMBER(22)
QUALITYCODE22 Y NUMBER(22)
HOURLYDATA22 Y NUMBER(22)
QUALITYCODE23 Y NUMBER(22)
HOURLYDATA23 Y NUMBER(22)
QUALITYCODE24 Y NUMBER(22)
HOURLYDATA24 Y NUMBER(22)
INTERVALCHANNEL Y NUMBER(22)

Table: AMRHOURLYDATA
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
LOGDATE N DATE(7)
QUALITYCODE01 Y NUMBER(22)
HOURLYDATA01 Y NUMBER(22)
QUALITYCODE02 Y NUMBER(22)
HOURLYDATA02 Y NUMBER(22)
QUALITYCODE03 Y NUMBER(22)
HOURLYDATA03 Y NUMBER(22)
QUALITYCODE04 Y NUMBER(22)
HOURLYDATA04 Y NUMBER(22)
QUALITYCODE05 Y NUMBER(22)
HOURLYDATA05 Y NUMBER(22)
QUALITYCODE06 Y NUMBER(22)
HOURLYDATA06 Y NUMBER(22)
QUALITYCODE07 Y NUMBER(22)
HOURLYDATA07 Y NUMBER(22)
QUALITYCODE08 Y NUMBER(22)
HOURLYDATA08 Y NUMBER(22)
QUALITYCODE09 Y NUMBER(22)
HOURLYDATA09 Y NUMBER(22)
QUALITYCODE10 Y NUMBER(22)
HOURLYDATA10 Y NUMBER(22)
QUALITYCODE11 Y NUMBER(22)
HOURLYDATA11 Y NUMBER(22)
QUALITYCODE12 Y NUMBER(22)
HOURLYDATA12 Y NUMBER(22)
QUALITYCODE13 Y NUMBER(22)
HOURLYDATA13 Y NUMBER(22)
QUALITYCODE14 Y NUMBER(22)
HOURLYDATA14 Y NUMBER(22)
QUALITYCODE15 Y NUMBER(22)
HOURLYDATA15 Y NUMBER(22)
QUALITYCODE16 Y NUMBER(22)
HOURLYDATA16 Y NUMBER(22)
QUALITYCODE17 Y NUMBER(22)
HOURLYDATA17 Y NUMBER(22)
QUALITYCODE18 Y NUMBER(22)
HOURLYDATA18 Y NUMBER(22)
QUALITYCODE19 Y NUMBER(22)
HOURLYDATA19 Y NUMBER(22)
QUALITYCODE20 Y NUMBER(22)
HOURLYDATA20 Y NUMBER(22)
QUALITYCODE21 Y NUMBER(22)
HOURLYDATA21 Y NUMBER(22)
QUALITYCODE22 Y NUMBER(22)
HOURLYDATA22 Y NUMBER(22)
QUALITYCODE23 Y NUMBER(22)
HOURLYDATA23 Y NUMBER(22)
QUALITYCODE24 Y NUMBER(22)
HOURLYDATA24 Y NUMBER(22)
INTERVALCHANNEL N NUMBER(22)

Table: AMRFORBILL
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
METERACCTNUMBER Y VARCHAR2(12)
METERNUMBER Y VARCHAR2(12)
METERKWH Y VARCHAR2(8)
METERKWHDT Y VARCHAR2(20)
METERONPEAKKWH Y VARCHAR2(8)
METERONPEAKKW Y VARCHAR2(9)
METEROFFPEAKKWH Y VARCHAR2(8)
METEROFFPEAKKW Y VARCHAR2(9)
METERMAXKWCURR Y VARCHAR2(9)
METERMAXKWPREV Y VARCHAR2(9)
METERMAXKWDT Y VARCHAR2(20)
SETID Y VARCHAR2(32)
SETVALUE Y VARCHAR2(32)
METERRATECLASS Y VARCHAR2(9)
METERCYCLENUMBER Y NUMBER(22)
METERUSER1 Y VARCHAR2(17)
METERUSER2 Y VARCHAR2(17)

Table: AMRFILELOOKUP
Field name Null Type Description
ID N NUMBER(22)
NAME Y VARCHAR2(30)

Table: AMRFILEFORMAT
Field name Null Type Description
COLUMNID N NUMBER(22)
TEMPLATEID N NUMBER(22)
VALUENAME Y VARCHAR2(50)
POSITIONSTART N NUMBER(22)
POSITIONEND N NUMBER(22)
PADID Y NUMBER(22)
LEFTORRIGHTPAD Y NUMBER(22)
FORMATID Y NUMBER(22)

Table: AMRFAILBILL
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
METERACCTNUMBER Y VARCHAR2(12)
METERNUMBER Y VARCHAR2(12)
METERKWH Y VARCHAR2(8)
METERKWHDT Y VARCHAR2(20)
METERONPEAKKWH Y VARCHAR2(8)
METERONPEAKKW Y VARCHAR2(9)
METEROFFPEAKKWH Y VARCHAR2(8)
METEROFFPEAKKW Y VARCHAR2(9)
METERMAXKWCURR Y VARCHAR2(9)
METERMAXKWPREV Y VARCHAR2(9)
METERMAXKWDT Y VARCHAR2(20)
SETID Y VARCHAR2(32)
SETVALUE Y VARCHAR2(32)
METERQUALITYCODE Y VARCHAR2(2)
METERRATECLASS Y VARCHAR2(9)
METERCYCLENUMBER Y NUMBER(22)
METERUSER1 Y VARCHAR2(17)
METERUSER2 Y VARCHAR2(17)

Table: AMRDATETIMEFORMAT
Field name Null Type Description
DATETIMEID N NUMBER(22)
DATETIMEVALUE Y VARCHAR2(30)

Table: AMRCOMMFAIL
Field name Null Type Description
UTILACCTID Y NUMBER(22)
SERIALNUMBER Y NUMBER(22)
SERIALPORT Y NUMBER(22)
FIRSTCOMMDT Y DATE(7)
CURRCOMMDT Y DATE(7)
COMMFAILCOUNT Y NUMBER(22)

Table: AMRCOLUMNS
Field name Null Type Description
COLUMNID N NUMBER(22)
COLUMNNAME Y VARCHAR2(100)
COLUMNDATATYPE Y VARCHAR2(10)

Table: AMRCMDLSTRETRY
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
CMDLST2WAYFUNCTION N NUMBER(22)
CMDLST2WAYGROUP N NUMBER(22)
UTILACCTID N NUMBER(22)
USERNAME Y VARCHAR2(32)
CMDLSTMSEXID Y NUMBER(22)
METERMITREADTYPE Y NUMBER(22)
METERMITREADIND Y NUMBER(22)
METERMITCMDTYPE Y NUMBER(22)
AMRCALJOBNO N NUMBER(22)
METERMITSEQNO N NUMBER(22)
METERMITQUALITYCODE Y NUMBER(22)
CMDLST2WAYGROUPSIZE Y NUMBER(22)
CMDLST2WAYGROUPBASE N NUMBER(22)
CMDLST2WAYUNITMAP1 N NUMBER(22)
CMDLST2WAYUNITMAP2 N NUMBER(22)
CMDLST2WAYUNITMAP3 Y NUMBER(22)
CMDLST2WAYUNITMAP4 Y NUMBER(22)
CMDLST2WAYUNITMAP5 Y NUMBER(22)
CMDLST2WAYUNITMAP6 Y NUMBER(22)
CMDLST2WAYUNITMAP7 Y NUMBER(22)
CMDLST2WAYUNITMAP8 Y NUMBER(22)
CMDLST2WAYUNITMAP9 Y NUMBER(22)
CMDLST2WAYUNITMAP10 Y NUMBER(22)
CMDLST2WAYUNITMAP11 Y NUMBER(22)
CMDLST2WAYUNITMAP12 Y NUMBER(22)
CMDLST2WAYUNITMAP13 Y NUMBER(22)
CMDLST2WAYUNITMAP14 Y NUMBER(22)
CMDLST2WAYUNITMAP15 Y NUMBER(22)
CMDLST2WAYUNITMAP16 Y NUMBER(22)
CMDLST2WAYUNITMAP17 Y NUMBER(22)
CMDLST2WAYUNITMAP18 Y NUMBER(22)
CMDLST2WAYUNITMAP19 Y NUMBER(22)
CMDLST2WAYUNITMAP20 Y NUMBER(22)
CMDLST2WAYUNITMAP21 Y NUMBER(22)
CMDLST2WAYUNITMAP22 Y NUMBER(22)
CMDLST2WAYUNITMAP23 Y NUMBER(22)
CMDLST2WAYUNITMAP24 Y NUMBER(22)
CMDLST2WAYUNITMAP25 Y NUMBER(22)
CMDLST2WAYUNITMAP26 Y NUMBER(22)
CMDLST2WAYUNITMAP27 Y NUMBER(22)
CMDLST2WAYUNITMAP28 Y NUMBER(22)
CMDLST2WAYUNITMAP29 Y NUMBER(22)
CMDLST2WAYUNITMAP30 Y NUMBER(22)
CMDLST2WAYUNITMAP31 Y NUMBER(22)
CMDLST2WAYUNITMAP32 Y NUMBER(22)

Table: AMRCMDLSTMITFORMRETRY
Field name Null Type Description
USERID Y NUMBER(22)
UTILACCTID Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)
READTYPE Y NUMBER(22)
READIND Y NUMBER(22)
SERIALPORT Y NUMBER(22)
AMRMIT Y NUMBER(22)
FUNCTION Y NUMBER(22)
MITGROUP Y NUMBER(22)
SEQNO Y NUMBER(22)
TWUNITMAPTOTAL Y NUMBER(22)
TWUNITMAP1 Y NUMBER(22)
TWUNITMAP2 Y NUMBER(22)
TWUNITMAP3 Y NUMBER(22)
TWUNITMAP4 Y NUMBER(22)
TWUNITMAP5 Y NUMBER(22)
TWUNITMAP6 Y NUMBER(22)
TWUNITMAP7 Y NUMBER(22)
TWUNITMAP8 Y NUMBER(22)
TWUNITMAP9 Y NUMBER(22)
TWUNITMAP10 Y NUMBER(22)
TWUNITMAP11 Y NUMBER(22)
TWUNITMAP12 Y NUMBER(22)
TWUNITMAP13 Y NUMBER(22)
TWUNITMAP14 Y NUMBER(22)
TWUNITMAP15 Y NUMBER(22)
TWUNITMAP16 Y NUMBER(22)
TWUNITMAP17 Y NUMBER(22)
TWUNITMAP18 Y NUMBER(22)
TWUNITMAP19 Y NUMBER(22)
TWUNITMAP20 Y NUMBER(22)
TWUNITMAP21 Y NUMBER(22)
TWUNITMAP22 Y NUMBER(22)
TWUNITMAP23 Y NUMBER(22)
TWUNITMAP24 Y NUMBER(22)
TWUNITMAP25 Y NUMBER(22)
TWUNITMAP26 Y NUMBER(22)
TWUNITMAP27 Y NUMBER(22)
TWUNITMAP28 Y NUMBER(22)
TWUNITMAP29 Y NUMBER(22)
TWUNITMAP30 Y NUMBER(22)
TWUNITMAP31 Y NUMBER(22)
TWUNITMAP32 Y NUMBER(22)

Table: AMRCMDLSTMITDATA
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
UTILACCTID N NUMBER(22)
METERMITPRISEC N NUMBER(22)
METERMITSEQNO N NUMBER(22)
METERMITREADDT Y DATE(7)
METERMITSTATUSTNS Y NUMBER(22)
METERMITSTATUSSCE Y NUMBER(22)
METERMITSTATUSRCE Y NUMBER(22)
METERMITQUALITYCODE Y NUMBER(22)
METERMITDATA1ID Y NUMBER(22)
METERMITDATA1 Y NUMBER(22)
METERMITDATA2ID Y NUMBER(22)
METERMITDATA2 Y NUMBER(22)
METERMITDATA3ID Y NUMBER(22)
METERMITDATA3 Y NUMBER(22)
METERMITDATA4ID Y NUMBER(22)
METERMITDATA4 Y NUMBER(22)
METERMITDATA5ID Y NUMBER(22)
METERMITDATA5 Y NUMBER(22)
METERMITDATA6ID Y NUMBER(22)
METERMITDATA6 Y NUMBER(22)
METERMITDEMRESETID Y NUMBER(22)
METERMITDEMRESET Y NUMBER(22)
METERMITLPDATA Y VARCHAR2(24)
METERMITQUALITYFLAG1 Y NUMBER(22)
METERMITQUALITYFLAG2 Y NUMBER(22)
METERMITQUALITYFLAG3 Y NUMBER(22)
METERMITQUALITYFLAG4 Y NUMBER(22)
METERMITRETRYCOUNT Y NUMBER(22)
AMRCALJOBNO N NUMBER(22)
METERMITCURRDATETIME Y DATE(7)

Table: AMRCMDLSTMIT
Field name Null Type Description
SERIALNUMBER N NUMBER(22)
SERIALPORT N NUMBER(22)
CMDLST2WAYFUNCTION Y NUMBER(22)
CMDLST2WAYGROUP Y NUMBER(22)
CMDLST2WAYUNIT Y NUMBER(22)
CMDLST2WAYFLAG Y NUMBER(22)
UTILACCTID N NUMBER(22)
USERNAME Y VARCHAR2(32)
CMDLSTGROUPID Y NUMBER(22)
CMDLSTMSEXID Y NUMBER(22)
CMDLSTADDRMODE Y NUMBER(22)
METERMITREADTYPE N NUMBER(22)
METERMITREADIND Y NUMBER(22)
METERMITCMDTYPE Y NUMBER(22)
METERMITSTATUSTNS Y NUMBER(22)
METERMITSTATUSSCE Y NUMBER(22)
METERMITSTATUSRCE Y NUMBER(22)
METERMITQUALITYCODE Y NUMBER(22)
MITPRIMARYDONE Y NUMBER(22)
MITSECONDARYDONE Y NUMBER(22)
CMDLSTSOURCE Y NUMBER(22)
CMDLSTHOLD Y NUMBER(22)
CMDLSTRETRYCT Y NUMBER(22)
AMRCALJOBNO N NUMBER(22)
AMRSCHEDJOBNO Y NUMBER(22)
CMDLSTSTARTDT Y DATE(7)
CMDLSTSTOPDT Y DATE(7)
CMDLSTCUTOFFDT Y DATE(7)
CMDLSTSETID Y VARCHAR2(32)
CMDLSTSETVALUE Y VARCHAR2(32)

Table: AMRCMDLST2WAY
Field name Null Type Description
UTILACCTID N NUMBER(22)
AMRCALJOBNO N NUMBER(22)
AMRREADTYPE N NUMBER(22)
AMRREADIND N NUMBER(22)
AMRCURPREV Y NUMBER(22)
AMRPORT N NUMBER(22)
AMRMIT Y NUMBER(22)
TWFUNC N NUMBER(22)
TWGRP N NUMBER(22)
TWUNITMAPTOTAL Y NUMBER(22)
TWUNITMAP1 Y NUMBER(22)
TWUNITMAP2 Y NUMBER(22)
TWUNITMAP3 Y NUMBER(22)
TWUNITMAP4 Y NUMBER(22)
TWUNITMAP5 Y NUMBER(22)
TWUNITMAP6 Y NUMBER(22)
TWUNITMAP7 Y NUMBER(22)
TWUNITMAP8 Y NUMBER(22)
TWUNITMAP9 Y NUMBER(22)
TWUNITMAP10 Y NUMBER(22)
TWUNITMAP11 Y NUMBER(22)
TWUNITMAP12 Y NUMBER(22)
TWUNITMAP13 Y NUMBER(22)
TWUNITMAP14 Y NUMBER(22)
TWUNITMAP15 Y NUMBER(22)
TWUNITMAP16 Y NUMBER(22)
TWUNITMAP17 Y NUMBER(22)
TWUNITMAP18 Y NUMBER(22)
TWUNITMAP19 Y NUMBER(22)
TWUNITMAP20 Y NUMBER(22)
TWUNITMAP21 Y NUMBER(22)
TWUNITMAP22 Y NUMBER(22)
TWUNITMAP23 Y NUMBER(22)
TWUNITMAP24 Y NUMBER(22)
TWUNITMAP25 Y NUMBER(22)
TWUNITMAP26 Y NUMBER(22)
TWUNITMAP27 Y NUMBER(22)
TWUNITMAP28 Y NUMBER(22)
TWUNITMAP29 Y NUMBER(22)
TWUNITMAP30 Y NUMBER(22)
TWUNITMAP31 Y NUMBER(22)
TWUNITMAP32 Y NUMBER(22)

Table: AMRCMDLST
Field name Null Type Description
UTILACCTID N NUMBER(22)
USERNAME Y VARCHAR2(32)
CMDLSTGROUPID Y NUMBER(22)
CMDLSTMSEXID Y NUMBER(22)
CMDLSTADDRMODE Y NUMBER(22)
CMDLSTREADTYPE N NUMBER(22)
CMDLSTREADIND N NUMBER(22)
CMDLSTCURPREV Y NUMBER(22)
CMDLSTSERIALNUMBER N NUMBER(22)
CMDLSTPORT N NUMBER(22)
CMDLST2WAYFUNCTION Y NUMBER(22)
CMDLST2WAYGROUP Y NUMBER(22)
CMDLST2WAYUNIT Y NUMBER(22)
CMDLST2WAYFLAG Y NUMBER(22)
CMDLSTCURDATETIME Y DATE(7)
CMDLSTSTATUSTNS Y NUMBER(22)
CMDLSTSTATUSSCE Y NUMBER(22)
CMDLSTSTATUSRCE Y NUMBER(22)
CMDLSTQUALITYCODE Y NUMBER(22)
CMDLSTTOTALCONSUMPT Y NUMBER(22)
CMDLSTUNITS Y NUMBER(22)
CMDLSTREADDT Y DATE(7)
CMDLSTQUALITYFLAG1 Y NUMBER(22)
CMDLSTQUALITYFLAG2 Y NUMBER(22)
CMDLSTQUALITYFLAG3 Y NUMBER(22)
CMDLSTQUALITYFLAG4 Y NUMBER(22)
CMDLSTOFFSETREAD Y NUMBER(22)
CMDLSTSOURCE Y NUMBER(22)
CMDLSTHOLD Y NUMBER(22)
CMDLSTSEQNO Y NUMBER(22)
CMDLSTRETRYCT Y NUMBER(22)
AMRCALJOBNO N NUMBER(22)
AMRSCHEDJOBNO Y NUMBER(22)
CMDLSTSTARTDT Y DATE(7)
CMDLSTSTOPDT Y DATE(7)
CMDLSTCUTOFFDT Y DATE(7)
CMDLSTSETID Y VARCHAR2(32)
CMDLSTSETVALUE Y VARCHAR2(32)

Table: AMRCLASSTYPE
Field name Null Type Description
CLASSID N NUMBER(22)
CLASSTYPE Y VARCHAR2(30)
METERCONVMIT Y NUMBER(22)
MITTYPEID Y NUMBER(22)

Table: AMRCALENDAR_BKUP
Field name Null Type Description
UTILACCTID Y NUMBER(22)
AMRCALDATE Y DATE(7)
AMRRUN Y VARCHAR2(9)
AMRCALSTARTDT Y DATE(7)
AMRCALSTOPDT Y DATE(7)
AMRCALCUTOFFDT Y DATE(7)
AMRCALSETID Y VARCHAR2(32)
AMRCALSETVALUE Y VARCHAR2(32)
AMRCALPORT Y NUMBER(22)
AMRREADTYPE Y NUMBER(22)
AMRREADIND Y NUMBER(22)
AMRCALJOBNO Y NUMBER(22)
AMRSCHEDJOBNO Y NUMBER(22)
AMRAPMFLAG Y NUMBER(22)

Table: AMRCALENDAR
Field name Null Type Description
UTILACCTID Y NUMBER(22)
AMRCALDATE Y DATE(7)
AMRRUN Y VARCHAR2(9)
AMRCALSTARTDT Y DATE(7)
AMRCALSTOPDT Y DATE(7)
AMRCALCUTOFFDT Y DATE(7)
AMRCALSETID Y VARCHAR2(32)
AMRCALSETVALUE Y VARCHAR2(32)
AMRCALPORT Y NUMBER(22)
AMRREADTYPE Y NUMBER(22)
AMRREADIND Y NUMBER(22)
AMRCALJOBNO N NUMBER(22)
AMRSCHEDJOBNO Y NUMBER(22)
AMRAPMFLAG Y NUMBER(22)

Table: ALTSUB
Field name Null Type Description
SUBID N NUMBER(22)
ALTSUBID N NUMBER(22)
ALTBUSID N NUMBER(22)
ALTFEEDERID N NUMBER(22)
ALTPHASE N NUMBER(22)
ALTSIGNAL N NUMBER(22)
ALTDETECTION N NUMBER(22)

Table: ALTPMAP
Field name Null Type Description
PRISUBID Y NUMBER(22)
PRIBUSID Y NUMBER(22)
PRIFDRID Y NUMBER(22)
ALTSUBID Y NUMBER(22)
ALTBUSID Y NUMBER(22)
ALTFDRID Y NUMBER(22)
MODDATE Y DATE(7)

Table: ALTIMUSTYPE
Field name Null Type Description
ALTIMUSTYPEID N NUMBER(22)
ALTIMUSTYPENAME Y VARCHAR2(18)
ALTIMUSTYPEPSWDTEXT Y VARCHAR2(3)
ALTIMUSTYPEPSWDHEX Y RAW(4)
ALTIMUSTYPEENCRYPT Y NUMBER(22)
ALTIMUSTYPELONGNAME Y VARCHAR2(62)

Table: ALTIMUSCMDSUMMARY
Field name Null Type Description
ALTIMUSTYPEID N NUMBER(22)
BILLTYPE N NUMBER(22)
BILLTYPEDESC Y VARCHAR2(10)
NUMBERRDREGCMD Y NUMBER(22)
NUMBERMAPREGCMD Y NUMBER(22)
METERRATECLASS N VARCHAR2(9)

Table: ALTIMUSCMDPARAM
Field name Null Type Description
ALTIMUSTYPEID N NUMBER(22)
BILLTYPE N NUMBER(22)
BILLTYPEDESC Y VARCHAR2(10)
MAPREGISTERID Y NUMBER(22)
DATAREGISTERID Y NUMBER(22)
DAILYSHIFTREGISTERID Y NUMBER(22)
DATANAMEID N NUMBER(22)
DATASHORTNAME Y VARCHAR2(8)
DATANAME Y VARCHAR2(30)
DATAADDRESS Y RAW(9)
DATALENGTH Y NUMBER(22)
DATADECOFMT Y NUMBER(22)
DATADPLOC Y NUMBER(22)
DATASELECT Y NUMBER(22)
RDREGSEQ Y NUMBER(22)
MAPREGSEQ Y NUMBER(22)
METERRATECLASS N VARCHAR2(9)
DATATYPEID Y NUMBER(22)
CONVID Y NUMBER(22)
MULTIPLIER Y NUMBER(22)
DIVISOR Y NUMBER(22)
DECIMALS Y NUMBER(22)
ROUND Y NUMBER(22)

Table: ALTIMUSCMDCONFIG
Field name Null Type Description
ALTIMUSTYPEID N NUMBER(22)
BILLTYPE N NUMBER(22)
BILLTYPEDESC Y VARCHAR2(10)
RDREGCMDSEQNUM N NUMBER(22)
RDREGCMDLENGTH Y NUMBER(22)
RDREGCMDSEQDELAY Y NUMBER(22)
RDREGCMDSEQRETRY Y NUMBER(22)
METERRATECLASS N VARCHAR2(9)

Table: ALTERNATEPATHBUILD
Field name Null Type Description
TWFUNC N NUMBER(22)
TWGRP N NUMBER(22)
AMRCALJOBNO N NUMBER(22)
SUBID N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
PHASE N NUMBER(22)
SIGNAL N NUMBER(22)
DETECTION N NUMBER(22)
PROTECTIVEDEVICE Y VARCHAR2(14)
UTILACCTID Y NUMBER(22)
AMRREADTYPE Y NUMBER(22)
AMRREADIND Y NUMBER(22)
AMRCURPREV Y NUMBER(22)
AMRPORT Y NUMBER(22)
AMRMIT N NUMBER(22)
TWUNITMAPTOTAL Y NUMBER(22)
TWUNITMAP1 Y NUMBER(22)
TWUNITMAP2 Y NUMBER(22)
TWUNITMAP3 Y NUMBER(22)
TWUNITMAP4 Y NUMBER(22)
TWUNITMAP5 Y NUMBER(22)
TWUNITMAP6 Y NUMBER(22)
TWUNITMAP7 Y NUMBER(22)
TWUNITMAP8 Y NUMBER(22)
TWUNITMAP9 Y NUMBER(22)
TWUNITMAP10 Y NUMBER(22)
TWUNITMAP11 Y NUMBER(22)
TWUNITMAP12 Y NUMBER(22)
TWUNITMAP13 Y NUMBER(22)
TWUNITMAP14 Y NUMBER(22)
TWUNITMAP15 Y NUMBER(22)
TWUNITMAP16 Y NUMBER(22)
TWUNITMAP17 Y NUMBER(22)
TWUNITMAP18 Y NUMBER(22)
TWUNITMAP19 Y NUMBER(22)
TWUNITMAP20 Y NUMBER(22)
TWUNITMAP21 Y NUMBER(22)
TWUNITMAP22 Y NUMBER(22)
TWUNITMAP23 Y NUMBER(22)
TWUNITMAP24 Y NUMBER(22)
TWUNITMAP25 Y NUMBER(22)
TWUNITMAP26 Y NUMBER(22)
TWUNITMAP27 Y NUMBER(22)
TWUNITMAP28 Y NUMBER(22)
TWUNITMAP29 Y NUMBER(22)
TWUNITMAP30 Y NUMBER(22)
TWUNITMAP31 Y NUMBER(22)
TWUNITMAP32 Y NUMBER(22)

Table: ALERTMESSAGES
Field name Null Type Description
ALERTNUMBER N NUMBER(22)
ALERTMESSAGE Y VARCHAR2(256)
ALERTPRIORITY N NUMBER(22)

Table: ADVSRCHVECTORSDEF
Field name Null Type Description
SUBID N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
VECTORCLASSID N NUMBER(22)
VECTORADAPTION Y NUMBER(22)
VECTORRSVD1 Y NUMBER(22)
VECTORRSVD2 Y NUMBER(22)
VECTORRSVD3 Y NUMBER(22)
VECTORRAB Y NUMBER(22)
VECTORRBC Y NUMBER(22)
VECTORRRCA Y NUMBER(22)
VECTORRXY Y NUMBER(22)
VECTORRYZ Y NUMBER(22)
VECTORRRZX Y NUMBER(22)
VECTORRAX Y NUMBER(22)
VECTORRBY Y NUMBER(22)
VECTORRCZ Y NUMBER(22)
VECTORPA Y NUMBER(22)
VECTORPB Y NUMBER(22)
VECTORPC Y NUMBER(22)
VECTORPX Y NUMBER(22)
VECTORPY Y NUMBER(22)
VECTORPZ Y NUMBER(22)
VECTORRSVD Y NUMBER(22)

Table: ADVSRCHVECTORS
Field name Null Type Description
SUBID N NUMBER(22)
BUSID N NUMBER(22)
FDRID N NUMBER(22)
VECTORCLASSID N NUMBER(22)
VECTORADAPTION Y NUMBER(22)
VECTORRSVD1 Y NUMBER(22)
VECTORRSVD2 Y NUMBER(22)
VECTORRSVD3 Y NUMBER(22)
VECTORRAB Y NUMBER(22)
VECTORRBC Y NUMBER(22)
VECTORRCA Y NUMBER(22)
VECTORRXY Y NUMBER(22)
VECTORRYZ Y NUMBER(22)
VECTORRZX Y NUMBER(22)
VECTORRAX Y NUMBER(22)
VECTORRBY Y NUMBER(22)
VECTORRCZ Y NUMBER(22)
VECTORPA Y NUMBER(22)
VECTORPB Y NUMBER(22)
VECTORPC Y NUMBER(22)
VECTORPX Y NUMBER(22)
VECTORPY Y NUMBER(22)
VECTORPZ Y NUMBER(22)
VECTORRSVD Y NUMBER(22)

Table: ADVSRCHPARMSDEF
Field name Null Type Description
ADVSRCHTYPE N NUMBER(22)
ADVSRCHORIGINID N NUMBER(22)
ADVSRCHDATE Y DATE(7)
ADVSRCHRSVD1 Y NUMBER(22)
ADVSRCHCOMMAND Y NUMBER(22)
ADVSRCHINITIALDEL Y NUMBER(22)
ADVSRCHBPP Y NUMBER(22)
ADVSRCHPATTERNLEN Y NUMBER(22)
ADVSRCHREPEATDEL Y NUMBER(22)
ADVSRCHPATTERN Y RAW(5)
ADVSRCHRSVD2 Y NUMBER(22)

Table: ADVSRCHPARMS
Field name Null Type Description
SUBID N NUMBER(22)
ADVSRCHTYPE N NUMBER(22)
ADVSRCHORIGINID N NUMBER(22)
ADVSRCHDATE Y DATE(7)
ADVSRCHRSVD1 Y NUMBER(22)
ADVSRCHCOMMAND Y NUMBER(22)
ADVSRCHINITIALDEL Y NUMBER(22)
ADVSRCHBPP Y NUMBER(22)
ADVSRCHPATTERNLEN Y NUMBER(22)
ADVSRCHREPEATDEL Y NUMBER(22)
ADVSRCHPATTERN Y RAW(5)
ADVSRCHRSVD2 Y NUMBER(22)