data-dictionary
data-dictionary
Breadcrumbs

FPSAPP.WIP_EVENT_TYPES

Data Dictionary

>

FPSAPP Tables

> FPSAPP.WIP_EVENT_TYPES

Table FPSAPP.WIP_EVENT_TYPES"

FPS standard lot event types to use with FK to ensure event_type column in all tables has values from our standard list.

  • Schema: FPSAPP

  • Tablespace: FPSDATA

  • Primary key: EVENT_TYPE

  • Foreign keys: WIP_EVENT_TYPES_FK_PROC_STATE: PROCESS_STATE REFERENCES FPSADMIN.WIP_PROCESS_STATES (PROCESS_STATE)

  • Referenced by: FPSINPUT.WIP_EVENTS (EVENT_TYPE) FPSINPUT.WIP_EVENT_PARMS_BY_TYPE (EVENT_TYPE)


Column

Type

Nullable

Comment

EVENT_TYPE

VARCHAR2(12)

N

Event Type (* from FPSINPUT.EQP_SCHED_EVENTS_MANUAL)

DEFAULT_SEC

NUMBER(6)

DESCRIPTION

VARCHAR2(512)

N

Tool desciption. This value is only used to display in the Dashboard. (* from FPSINPUT.EQP_TOOLS)

IS_AUTO_ONLY

CHAR(1)