Lu tables - dssg/cta-sim GitHub Wiki

Below are the column types for the look-up tables.

LU_DAYMAP

DAYMAP_ID           NUMBER(2) NOT NULL,
DAYMAP              CHAR(8) NOT NULL,
DAYTYPE_ID          NUMBER(1) NOT NULL,
LEGACYFREQUENCYCODE NUMBER(2),
COMMENTS            VARCHAR2(255),
NEXTDAYID           NUMBER(1)

LU_DAYMAP2

DAYTYPEID NUMBER(1) NOT NULL,
DAYMAP_ID NUMBER(2)

LU_DAYTYPE

DAYTYPEID NUMBER NOT NULL,
DAYNAME   VARCHAR2(9)

LU_DIR

DIR_ID      NUMBER(2) NOT NULL,
DIR         VARCHAR2(3) NOT NULL,
MINHEADING  NUMBER(3) NOT NULL,
MAXHEADING  NUMBER(3) NOT NULL,
DESCRIPTION VARCHAR2(5)

LU_DIRECTION

DIRECTION_ID NUMBER(2) NOT NULL,
DIRECTION    VARCHAR2(16) NOT NULL,
SHORTDIR     VARCHAR2(2),
DIR_GROUP    NUMBER(1)

LU_EVENT

EVENT_ID NUMBER,
EVENT    VARCHAR2(20)

LU_ROUTE

ROUTE_ID       INTEGER NOT NULL,
ROUTESORT      VARCHAR2(5) NOT NULL,
ROUTE          VARCHAR2(4) NOT NULL,
NAME           VARCHAR2(255) NOT NULL,
ROUTETYPE_ID   NUMBER(1) NOT NULL,
LIFT           NUMBER(1) NOT NULL,
OWL            NUMBER(1) NOT NULL,
TITLE6         NUMBER(1) NOT NULL,
GARAGE_ID      NUMBER(1),
GARAGE2_ID     NUMBER(1),
HASTUS_ROUTEID VARCHAR2(5),
MH_KEY         NUMBER(1),
AFCROUTE       NUMBER(3)

LU_ROUTESTATUS

ROUTESTATUS_ID   NUMBER(2),
ROUTESTATUS_DESC VARCHAR2(20)

LU_ROUTETYPE

ROUTETYPE_ID   NUMBER(2) NOT NULL,
ROUTETYPE_DESC VARCHAR2(20)

LU_SCHDTYP

SCHDTYPID      NUMBER NOT NULL,
CTA_SCHD       VARCHAR2(15),
DAY_TYPE1      VARCHAR2(1),
DAY_TYPE2      VARCHAR2(2),
DAY_TYPE3      VARCHAR2(3),
DAY_TYPE_NAME  VARCHAR2(9),
DAY_TYPE_NAMES VARCHAR2(9),
DAY_TYPE_LONG  VARCHAR2(20)

LU_TIMEPERIOD

TIMEPERIODID NUMBER NOT NULL,
TIMEPERIOD   VARCHAR2(10),
STARTTIME    VARCHAR2(8),
ENDTIME      VARCHAR2(8),
MINSECONDS   NUMBER(6),
MAXSECONDS   NUMBER(6),
RT_FACTOR    NUMBER(2),
PEAK         NUMBER(2)

LU_TIMEPOINTSTATUS

TIMEPOINTSTATUS_ID   NUMBER(2) NOT NULL,
TIMEPOINTSTATUS_DESC VARCHAR2(30)

LU_TIMEPOINTTYPE

TIMEPOINTTYPE_ID   NUMBER(2) NOT NULL,
TIMEPOINTTYPE_DESC VARCHAR2(50)

LU_TRIPTYPE

TRIPTYPE_ID NUMBER(1) NOT NULL,
TRIPTYPE    VARCHAR2(50)

LU_WORKSTATUS

WORKSTATUS_ID   NUMBER(2) NOT NULL,
WORKSTATUS_DESC VARCHAR2(50)