The DEFECTACTIVITYRATE table stores information about the rates for the type of action involved in processing or resolving a defect. As an example, the rate type code could contain "Repair", the rate type description could contain "Repair defect rate /hr" and the rate amount could contain "$35".
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
DEFECTACTIVITYRATEID (PK) |
STANDARDID(12) |
NOT NULL |
DEFECTACTIVITYRATE_DEFECTACTIVITYRATEID_PK (CA) |
(One) to (Many) |
|
|
RATETYPECODE |
STANDARDID(12) |
NOT NULL |
|
|
|
|
RATETYPEDESC |
varchar(80) |
NULLS |
DEFECTACTIVITYRATE_RATETYPEDESC (IE) |
|
|
|
RATEAMOUNT |
float(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|