Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Problem_Transition
Touchworks 25.2
[dbo].[Problem_Transition]
MS_Description
Problem Transition from one problem to another
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
ProblemHeaderToID
[dbo].[uniqueid]
9
NOT NULL
Target Problem Header Identifier. Link to Problem_Header.ID
ProblemHeaderFromID
[dbo].[uniqueid]
9
NOT NULL
Source Problem Header Identifier. Link to Problem_Header.ID
TransitionProviderID
[dbo].[uniqueid]
9
NOT NULL
Provider who performed the transition. Link to IDX_User.ID
ProblemTransDTTM
datetime
8
NOT NULL
Problem Transitioned date and time
ProblemToID
[dbo].[uniqueid]
9
NOT NULL
((0))
Problem version transitioned to. Link to Problem.ID
ProblemFromID
[dbo].[uniqueid]
9
NOT NULL
((0))
Problem version transitioned from. Link to Problem.ID