posting status flag values

Q: What are the various values for tckmast.posting_status

A: This numeric value is based on the following constants:

POST_TD_BASIS = 1;
POST_SD_BASIS = 2;
POST_PRIMARY = 4;
POST_CLOSEDOUT = 8;

These constants are OR'ed together to get a final value for posting_status. Unless a trade is being booked before its trade date (very uncommon), it almost always will have TD_BASIS set. Same-day trades get SD_BASIS right away; otherwise, the Nightly program takes care of this. An unsettled trade has a value of 1. A settled trade has a value of 3. "2" is impossible, since a ticket cannot settle before it is traded.

PRIMARY and CLOSEDOUT are only used in commercial paper underwriting system, and they are mutually exclusive.

Last updated: 04/28/05