Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Work order status fields

SOLVED
Go to solution
Highlighted
Deepak Rathi
Acclaimed Contributor

Work order status fields

ASS_ASSIGNSTATUS field in ITSM_WORKORDERS table is a 18 digit number.

Can anyone help me in decoding what that number means. I mean is there a table where in I can look what each number means i.e whether the status is New, Open, Closed ... etc

Thanks
5 REPLIES
George M. Meneg
Honored Contributor

Re: Work order status fields

Hello,

ASS_ASSIGNSTATUS is foreign key to ITSM_CODES that holds the "Assignment;Status" entity.
menes fhtagn
Deepak Rathi
Acclaimed Contributor

Re: Work order status fields

Thanks for the prompt reply. We have our status fields as New, Open or Closed. I don't see any column in ITSM_CODES wherein I can find if the code indicates New, Open etc.
George M. Meneg
Honored Contributor
Solution

Re: Work order status fields

Hello,

The text is stored on table "ITSM_CODES_LOCALE". You should join it with ITSM_CODES on ITSM_CODES_LOCALE.CDL_COD.OID=ITSM_CODES.CDL_OID
menes fhtagn
Deepak Rathi
Acclaimed Contributor

Re: Work order status fields

Thanks. That solved my problem.
Mark O'Loughlin
Honored Contributor

Re: Work order status fields

Hi,

please assign George points as he has clearly helped you resolve you query.
//Add this to "OnDomLoad" event