flg_p_open vs flg_p_first_raise

[Paragon]

Greetings all. I have looked at the PT3 schema pdf file, but I have a question about the difference between these two columns in the holdem_hand_player_statistics table. Your brief definitions are:

flg_p_open "Open raised pre-flop (True/False)"
flg_p_first_raise "Raised first pre-flop (True/False)"

The second one seems pretty clear -- I am mainly wondering about the difference between the two.

If someone limps, and as my first action pre-flop I choose to raise, does that trigger flg_p_open to be true? If someone raises, and as my first action pre-flop I choose to re-raise (3-bet), does that trigger flg_p_open to be true?

I am used to the phrase "open-limped preflop" as well. But that just means calling, and would NOT cause flg_p_open to be true?

Thanks for any response.

P.S. It would be nice to have a flg_p_open_opp (opportunity to open flag) column as well... Or rather, the broader, flg_p_firstin_opp (opportunity to vpip first preflop). Er, speaking of which, I know in PT2 vpip meant only for pre-flop... Is that the same? e.g., if the big blind gets a free look and bets the flop, he still did not vpip for that hand?

[WhiteRider]

Greetings all. I have looked at the PT3 schema pdf file, but I have a question about the difference between these two columns in the holdem_hand_player_statistics table. Your brief definitions are:

flg_p_open "Open raised pre-flop (True/False)"
flg_p_first_raise "Raised first pre-flop (True/False)"

The second one seems pretty clear -- I am mainly wondering about the difference between the two.

If someone limps, and as my first action pre-flop I choose to raise, does that trigger flg_p_open to be true? If someone raises, and as my first action pre-flop I choose to re-raise (3-bet), does that trigger flg_p_open to be true?

I am used to the phrase "open-limped preflop" as well. But that just means calling, and would NOT cause flg_p_open to be true?

Thanks for any response.

P.S. It would be nice to have a flg_p_open_opp (opportunity to open flag) column as well... Or rather, the broader, flg_p_firstin_opp (opportunity to vpip first preflop). Er, speaking of which, I know in PT2 vpip meant only for pre-flop... Is that the same? e.g., if the big blind gets a free look and bets the flop, he still did not vpip for that hand?

I can't give you a full definitive answer, but flg_p_open means you were first to act and raised (I don't think limping counts.
flg_p_first_raise means you were first to raise, regardless of other limpers before you. (this can be true without flg_p_open being true).
I agree about flg_p_open_opp, and I thought there was one, but off the top of my head I can't remember..

[Josh]

flg_p_open just means that you opened the action, whether it was with a call or a raise.

"If someone limps, and as my first action pre-flop I choose to raise, does that trigger flg_p_open to be true?"
No, but flg_p_first_raise would be true.

"It would be nice to have a flg_p_open_opp (opportunity to open flag) column as well"
It's in there, flg_p_open_opp. At least with the latest version of the schema.

[Paragon]

Thanks for the clarification guys. flg_p_open is basically first person to vpip preflop like you said... And yeah, in Beta 10 the column flg_p_open_opp was added as well, which is convenient.

Another side observation... the pdf on the schema says that for the position column, 8 = small blind and 9 = big blind. I think it is actually reverse.

[Josh]

Yes, 9 is small blind and 8 is big blind.