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

Parents
  • 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!
Reply
  • 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!
Children