Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.MNT_TECH_CERT_ASSIGNMENTS
Table FPSINPUT.MNT_TECH_CERT_ASSIGNMENTS"
The Certifications that the technicians can perform.
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: MNT_TECH_USERNAME, CERT
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
MNT_TECH_USERNAME |
VARCHAR2(64) |
N |
The unique identifier of a technician that also needs to exist in GEN_USERS. (* from FPSINPUT.MNT_TECHNICIANS) |
|
CERT |
VARCHAR2(64) |
N |
Certifications or skills possible to perform on a specific Tool, or MNT task, or Event_ID from EQP_MNT_FUTURE. (* from FPSINPUT.MNT_CERTIFICATIONS) |
|
CERT_SKILL_LEVEL |
NUMBER(4 |
The level of skill a tech has for a specific certification, can be from 1 - 10, 10 is the best, default value 10 |