The DEFECTACTIVITYITEM table stores information about past or future activities for a defect. Activities can be any action involved in processing or resolving a defect. The DEFECTACTIVITYITEM table stores information such as item, user, received date, activity rate type, time units used for processing the activity, elapsed hours, and total fee. Your company may use this information for creating budgets or for billing.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
DEFECTACTIVITYITEMID (PK) |
STANDARDID |
NOT NULL |
DEFECTACTIVITYITEM_DEFECTACTIVITYITEMID_PK(AK) |
|
|
|
DEFECTID (FK) |
STANDARDID |
NOT NULL |
DEFECTACTIVITYITEM_DEFECTID (CA) |
(Many) to (One) |
|
|
DEFECTACTIVITYCODE |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
RATETYPEDESC (FK) |
varchar(80) |
NULLS |
|
(Many) to (One) |
|
|
DEFECTSTATUSCODE |
STANDARDID |
NULLS |
|
|
|
|
PERFORMEDBYID (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
PERFORMEDDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
COMPLETEDDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
UNITS |
float |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
RATE |
float |
NULLS |
|
|
|
|
NOTES |
TEXTBLOB(16) |
NULLS |
|
|
|
|
USERFIELD1 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD2 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD3 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD4 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD5 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD6 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD7 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD8 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD9 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD10 |
varchar(80) |
NULLS |
|
|
|
|
ELAPSEDUNITS |
float |
NULLS |
|
|
|
|
TOTALRATE |
float |
NULLS |
|
|
|