When extracting data or building reports in the Report Builder, each record contains a type and a status.


Record Type:

1 = Final Record

2 = Draft Record

3 = Auto-Validate Record (test records)



Form Status:

1 = Saved Final without errors - Record Inserted without Errors

2 = Saved Final with errors - Record Inserted with Errors

3 = Record updated without errors

4 = Record updated with errors

5 = Record Unlocked

6 = Saved as draft

7 = Unlocked by edit check

8 = Manually frozen

9 = Manually thawed

100 = Record deleted

101 = Record Undeleted

104 = Subject Migrated to new version



10-20 are reserved for the study designer to use in the study configuration review workflow. These identify the review level status. The final review level would be a record that has gone through all stages of the record lifecycle


Example:

10 = Monitor Review

11 = Data Manager Review

12 = Investigator Review