data-dictionary

FPSBASE.DASH_P_MNT_TECHN_CERT_ASGNS

Data Dictionary

>

FPSBASE Views

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSAPP.DASH_P_MNT_TECHN_CERT_ASGNS

This view provides mnt_tech_cert_assignments to the dashboard.

Column

Comment

MNT_TECH_USERNAME

The unique identifier of a technician that also needs to exist in GEN_USERS. (* inherited from FPSINPUT.MNT_TECHNICIANS)

CERT

Certifications or skills possible to perform on a specific Tool, or MNT task, or Event_ID from EQP_MNT_FUTURE. (* inherited from FPSINPUT.MNT_CERTIFICATIONS)

CERT_SKILL_LEVEL

The level of skill a tech has for a specific certification, can be from 1 - 10, 10 is the best, default value 10 (* inherited from FPSINPUT.MNT_TECH_CERT_ASSIGNMENTS)