• Replies 3 replies
  • Subscribers 337 subscribers
  • Views 33 views
  • Users 0 members are here
Related

T_SUB_LINEITEM.sli_status_code is NULL

Martin Keen (Past Member)
$organization

When looking at our database, I can see that all entries in the T_SUB_LINEITEM table have a NULL value in the sli_status_code field.

Is this normal or just a peculiarity of our database?

Martin

  • $organization

    I also have NULL

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Martin Keen
    Sent: Tuesday, 8 October 2013 12:02 PM
    To: Brenda Fehlberg
    Subject: [Tessitura Technical Forum] T_SUB_LINEITEM.sli_status_code is NULL

     

    When looking at our database, I can see that all entries in the T_SUB_LINEITEM table have a NULL value in the sli_status_code field.

    Is this normal or just a peculiarity of our database?

    Martin




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • $organization
    The sli_status_code column was retired many years ago so it is normal that it is set to NULL for all records.  The column named sli_status is its newer replacement and you should see this column populated for every row in T_SUB_LINEITEM.
     
    -doug
     
    From: Martin Keen [bounce-martinkeen9803@tessituranetwork.com]
    Sent: Monday, October 07, 2013 6:02 PM
    To: Doug Jones
    Subject: [Tessitura Technical Forum] T_SUB_LINEITEM.sli_status_code is NULL

    When looking at our database, I can see that all entries in the T_SUB_LINEITEM table have a NULL value in the sli_status_code field.

    Is this normal or just a peculiarity of our database?

    Martin




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • $organization in reply to Doug Jones

    Thanks for the info Doug.

    I can see that the sli_status column is correctly populated.

    Martin