T_REFERENCE_TABLES.[col_valid]

Chris,

That column is a powerbuilder expression that validates the data being entered in the field. This will prevent a user from saving a new row or saving an updated row if the data does not produce a true statement. –According to the documentation from Tessitura.

This is what syntax I see in the column for TR_batch_type, cntl_ind : POS('YN', gettext()) > 0

This seems to be the syntax for almost all of the 67 rows that have a value in that column for our table. Other syntaxes include: POS('YND', gettext()) > 0; POS('FECOA', gettext()) > 0; IsNull(gettext()) OR (long(gettext()) >= 1 and long(gettext()) <= 10) ; POS('1234', gettext()) > 0; POS('1/2/3/4/5/6/7/8/9/10/11/12', gettext()) > 0

Hope this helps you!

Thanks and have a great day!

Naomi Williams

Chris,

That column is a powerbuilder expression that validates the data being entered in the field. This will prevent a user from saving a new row or saving an updated row if the data does not produce a true statement. –According to the documentation from Tessitura.

This is what syntax I see in the column for TR_batch_type, cntl_ind : POS('YN', gettext()) > 0

This seems to be the syntax for almost all of the 67 rows that have a value in that column for our table. Other syntaxes include: POS('YND', gettext()) > 0; POS('FECOA', gettext()) > 0; IsNull(gettext()) OR (long(gettext()) >= 1 and long(gettext()) <= 10) ; POS('1234', gettext()) > 0; POS('1/2/3/4/5/6/7/8/9/10/11/12', gettext()) > 0

Hope this helps you!

Thanks and have a great day!

Naomi Williams