data-dictionary

Prefixes

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