Service Desk Practitioners Forum
cancel

Work order status fields

SOLVED
Go to solution
Highlighted
Deepak Rathi
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
Acclaimed 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
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
Acclaimed 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
Contributor.

Re: Work order status fields

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

Re: Work order status fields

Hi,

please assign George points as he has clearly helped you resolve you query.