Data Dictionary
> Prefixes
Table and View Prefixes
|
Prefix |
Description |
|---|---|
|
ADM |
Administration |
|
APF |
For complex queries within APF reports we create a view rather than typing the entire query directly as it is easier to manage. |
|
APP |
Application support |
|
BLD |
Views which help to build queries or scripts |
|
CAL |
Calendar |
|
CFG |
Configurables tables for ADM_LOAD procedures |
|
CHK |
Check error views |
|
CM |
Capacity Model |
|
CTA |
Cycle Time Analyzer |
|
CTM |
Cycle Time |
|
CTR |
Cycle Time Reporting |
|
DASH |
Dashboard |
|
DBC |
Database Checker |
|
DBF |
Database definitions for FPS objects only |
|
DLOP |
Direct Labor Optimizer |
|
DOC |
Documentation |
|
ECT |
Enhanced Cycle Time |
|
ECTA |
Cycle Time Analyzer with Enhanced CT data |
|
ECTFL |
Finished Lot Cycle Time with Enhanced CT data |
|
EQP |
Equipment |
|
ETP |
Enhanced Tool Performance |
|
FBK |
Feedback |
|
FDC |
Fault Detection and Classification |
|
FGB |
Integration with FabGuard Broker |
|
FR |
FabRecover |
|
GEN |
General |
|
GP |
Goal Planner |
|
LOAD |
Tables or base views used in other FPSINPUT views that load the data. Those other views will be either xxx_APD_yyy, xxx_REF_yyy, or APF_xxx. |
|
MES |
Refresh MES tables into FPS schema where we then write REF/APD views for speed purposes. |
|
MHS |
Material Handling |
|
MNT |
Maintenance |
|
MSO |
Metrology Sampling Optimizer |
|
MSOUI |
User Interface for MSO |
|
NMV |
NextMove |
|
PERF |
Historical Performance |
|
RECENT |
View to monitor recent trends, history, and errors on the database |
|
RM |
Reticle Management |
|
RTDLOAD |
Old prefix still used at some sites for tables or views used in RTD ETL reports. |
|
RTG |
Routing |
|
SCH |
Scheduler |
|
SEC |
Security |
|
SITE |
Site specific objects usually in FPSADMIN including administrative procedures. |
|
SITESCH |
Site specific objects for Scheduler |
|
SMMS |
Smart Maintenance Management System |
|
STARTUP |
For ETL Startup Phase |
|
STD |
Standard views for FPSINPUT ETL logic that can be used by the site if necessary |
|
SYSMNTR |
System Monitor |
|
THP |
Throughput |
|
THPT |
Throughput Tracker |
|
UPO |
Use Percent Optimizer |
|
WEB |
For multiple websites |
|
WF |
WIP Flush |
|
WFM |
Multi-facility WIP Flush |
|
WIP |
Lots |