Internal Value for Approval Status

This post is mainly for my own reference purpose. The internal field name for approval status of a list/library item is _ModerationStatus, which has corresponding values and it is type of ModStat:

Status	Internal Value
Approved	0
Rejected	1
Pending	2
Draft	3

Sample usage for these values in CAML query : Retrieve all Approved documents from a particular document library

CAML query would look something like below:

<Where><Eq><FieldRef Name=’_ModerationStatus’ /><Value Type=’ModStat’>0</Value></Eq></Where>

Referance:

http://sharepointwriting.blogspot.com.tr/2011/10/internal-value-for-approval-status.html