Data Dictionary
>
FPSAPP Tables
> FPSAPP.MHS_CARRIER_STATES
Table FPSAPP.MHS_CARRIER_STATES"
List of FPS defined values allowed for the carrier state. Restricting carrier_state to a value defined in this table allows our applications to make specific references to these values.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: CARRIER_STATE
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
CARRIER_STATE |
VARCHAR2(18) |
N |
Carrier state indicates the current state of the carrier. The value must be one of those defined by FPS in FPSADMIN.MHS_CARRIER_STATES. This is a very short list of simple states like OK or WARN or DOWN in contrast to the complex options available for equipment states. This would be used as a filter/sort on what carriers could be selected when a carrier is needed. For example, when a lot is split we need to find another carrier for the split lot and we would prefer one with state of OK then WARN but we could not choose one which was DOWN. (* from FPSINPUT.MHS_CARRIERS) |