Data Dictionary
>
FPSAPP Tables
> FPSAPP.EQP_REPAIR_REASONS
Table FPSAPP.EQP_REPAIR_REASONS"
This is an optional table that can either be empty, manually updated or populated through the ETL. The usage of this table is to any values of REASON and IS_FIRST_TIME_RIGHT_FAIL = N that the site does not want to consider something that will cause first time right to fail. The default functionality is to consider any reason code after a SDT within a gtg falling first time right. If there are some REASONS that are to be excluded populate them here with IS_FIRST_TIME_RIGHT_FAIL = N. The fundamental assumption is that after a SDT event if there are any UDT events it is likely due to the SDT event not passing or not being performed properly.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: REPAIR_REASON
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
REPAIR_REASON |
VARCHAR2(36) |
N |
These are the values that can be found in EQP_EVENT_HIST REPAIR_REASON. A value from a reasonably short list of user-defined explanations of how the entity will be repaired or what caused it to go down. |
|
DESCRIPTION |
VARCHAR2(256) |
The description that provides more details about the down and repair reason codes. |
|
|
IS_FIRST_TIME_RIGHT_FAIL |
CHAR(1) |
The denotes if this reason should count as a failed SDT episode. The idea is that if a Y flag is seen within the green to green (GTG) episodes after an SDT episode than that means that the SDT PM was not performed first-time-right, FTR. if the flag is set to N than the reason code will not cause a FRT fail. |