Study Progress Versioned Extracts
24R1 Version
You can run specific versions of Study Progress Listing jobs with Study Progress Versioned Extracts in EDC Tools. Each version contains different columns according to the selected release. Refer to the tables below for the columns included in the 24R1 versions of Study Progress Versioned Extract jobs.
Form Progress Versioned Extract
The following columns are included in the 24R1 version of the Form Progress Versioned Extract job:
| Column Header | Description |
|---|---|
| STUDY | Study Label |
| COUNTRY | Study Country Name |
| SITENUM | Site Number |
| SUBJECT | Subject Number |
| SUBSTATUS | Current Subject Status |
| EGROUP | Event Group Label of the Event Group where the Query is |
| EVENT | Event Label of the Event where the Query is |
| ESEQ | Event Group Sequence Number |
| EVENTDT | Event Date entered |
| FORM | Form Label |
| FSEQ | Form Sequence Number |
| FORMSTATUS | Form Status (Planned, Blank, In Progress, Submitted, In Edit) |
| FIRSTSUBMITDT | Datetime when the form was first submitted |
| LASTSUBMITDT | Datetime when the form was last submitted |
| NSUBMITS | Total number of form submissions |
| RESTRICTED | Shows if the Form is Restricted or not (Yes/No value) |
| COMPLETE | Shows if the Form is complete/submitted, including ILB forms (Yes/No value) |
| ILB | Shows if the Form was Intentionally Left Blank (Yes/No value) |
| ILBREAS | The reason the Form was marked as Intentionally Left Blank |
| LATE | Shows if the Form is late based on the Event Date and the number of overdue days allowed (Yes/No value) |
| DAYSOVERDUE | Shows the number of days beyond the overdue date |
| ALLITEMS | Calculates the total number of items on the form |
| ITEMSVAL | Calculates the number of items on the form with a saved value |
| ITEMSVALCHG | Calculates the number of items on the form with at least one data value change |
| SDVPLAN | SDV Review Plan assigned to the Subject |
| SDVOVRPLAN | SDV Review Plan override for the Form (from an override rule) |
| SDVCOMP | Shows whether SDV was completed for the Form |
| SDVREQ | Shows whether SDV is required for the Form |
| SDVREREQ | Shows whether SDV needs to be completed again after being cleared due to updates by the site |
| ITEMSSDVREQCOMP | Number of items on the Form where SDV is required and completed |
| ITEMSSDVREQ | Number of items on the Form where SDV is required |
| SDVPCTCOMP | Percentage of required SDV complete for the Form |
| SDVAGE | How long the Form has been submitted without SDV |
| FIRSTSDVCOMPDT | Date the Form was marked SDV |
| DMRPLAN | DMR Review Plan assigned to the Subject |
| DMROVRPLAN | DMR Review Plan override for the Form (from an override rule) |
| DMRCOMP | Shows whether DMR was completed for the Form |
| DMRREQ | Shows whether DMR is required for the Form |
| DMRREREQ | Shows whether DMR needs to be completed again after being cleared due to updates by the site |
| ITEMSDMRREQCOMP | Number of items on the Form where DMR is required and completed |
| ITEMSDMRREQ | Number of items on the Form where DMR is required |
| DMRPCTCOMP | Percentage of DMR complete for the Form |
| DMRAGE | How long the Form has been submitted without DMR |
| FIRSTDMRCOMPDT | Datetime when the Form was first marked as DMR complete |
| DMRCOMPDT | Date the form was marked DMR |
| FROZEN | Whether or not the Form is frozen (Yes/No value) |
| FROZENDT | Date the Form was frozen |
| LOCKED | Whether or not the Form is locked (Yes/No value) |
| LOCKEDDT | Date the Form was locked |
| SIGNED | Whether or not the Form is signed |
| SIGNEDDT | Date the Form was signed |
| LASTSGNDT | Date the Form was last signed |
| TQUERIES | Total number of queries on the Form |
| OQUERIES | Total number of open queries on the Form |
| AQUERIES | Total number of answered queries on the Form |
| CQUERIES | Total number of closed queries on the Form |
| FORMVOFID | Vof ID of the Form |
| LASTRUN | Datetime when the listing was last run |
Event Progress Versioned Extract
The following columns are included in the 24R1 version of the Event Progress Versioned Extract job:
| Column Header | Description |
|---|---|
| STUDY | Study Name |
| COUNTRY | Study Country Name |
| SITENUM | Site number |
| SUBJECT | Subject number |
| SUBSTATUS | Current Subject status |
| EGROUP | Event Group Label |
| EVENT | Event Label |
| EGSEQ | Event Group Sequence Number |
| EVENTTYPE | Event Type |
| EVENTDT | Event Date entered |
| VISMETHOD | Visit Method selected for this event |
| EVENTSTATUS | Event status (Planned, Blank, In Progress, Submitted, Did Not Occur) |
| DNO | Indicates if the event was marked as Did Not Occur (Yes/No value) |
| DNOREAS | Change Reason entered if the event was marked as Did Not Occur |
| RESTRICTED | Shows if the event is restricted or not (Yes/No value) |
| EPLANNEDDT | The low date relative to study design plan and not considered out of window |
| PLANNEDDT | The date from study design the event was planned for |
| LPLANNEDDT | The high date relative to study design plan and not considered out of window |
| OOW | If the event is out of window (below Early, above Late), or if missing (and past late grace) |
| DAYSOW | If Out of Window, display the number of days out of window |
| SDVPLAN | The SDV plan assigned to subject at time of generation |
| EVDTSDVCOMP | Shows whether the Event Date completed SDV (Yes/No value) |
| EVDTSDVREQ | Shows if SDV was required for the Event Date (Required, Optional, Not Required, Blank) |
| EVDTFSDVCOMPDT | Shows the date that the Event Date first underwent SDV |
| EVDTSDVCOMPDT | Shows the date when the Event Date underwent SDV |
| VMSDVCOMP | Shows whether the Visit Method completed SDV, if configured |
| VMSDVREQ | Shows if SDV was required for the Visit Method (Required, Optional, Not Required, Blank) |
| VMSDVCOMPDT | Shows the date when the Visit Method underwent SDV, if configured |
| TFSDVCOMP | Shows the total number of forms that completed SDV |
| TFSDVREQ | Total number of forms completed for this event, where at least one field is SDV required |
| SFSDVREQ | Number of submitted forms where SDV is required at the event |
| FSDVPCTCOMP | Percentage of forms that underwent SDV at this event |
| SDVCOMPDT | The date on which all forms at this event completed SDV for this subject |
| DMRPLAN | The DMR plan assigned to subject at time of generation |
| EVDTDMRCOMP | Shows whether the Event Date completed DMR (Yes/No value) |
| EVDTDMRREQ | Shows if DMR was required for the Event Date (Required, Optional, Not Required, Blank) |
| EVDTFDMRCOMPDT | Shows the date when the Event Date first underwent DMR |
| EVDTDMRCOMPDT | Shows the date when the Event Date underwent DMR |
| VMDMRCOMP | Shows whether DMR was completed for the Visit Method, if configured |
| VMDMRREQ | Shows if DMR was required for the Visit Method (Required, Optional, Not Required, Blank) |
| VMDMRCOMPDT | Shows the date the Visit Method underwent DMR, if configured |
| TFDMRCOMP | Total number of forms that underwent DMR for this event |
| TFDMRREQ | Total number of forms completed for this event, where at least one field is DMR required |
| SFDMRREQ | Number of submitted forms where DMR is required at the event |
| FDMRPCTCOMP | Percentage of forms that underwent DMR at this event |
| DMRCOMPDT | The date on which all forms at this event completed DMR for this subject |
| EVDTFROZEN | Shows if the Event Date was frozen (Yes/No value) |
| EVDTFROZENDT | The date that the Event Date was frozen |
| EVDTLOCKED | Shows if the Event Date was locked (Yes/No value) |
| EVDTLOCKEDDT | The date that the Event Date was locked |
| EVDTSIGNED | Shows if event date is signed (Yes/No value) |
| EVDTSIGNEDDT | The date when the event date was signed |
| VMFROZEN | Shows whether the Visit Method is frozen, if configured |
| VMFROZENDT | The date when the Visit Method was frozen |
| VMLOCKED | Shows whether the Visit Method is locked, if configured |
| VMLOCKEDDT | The date when the Visit Method was locked |
| VMSIGNED | Shows whether the Visit Method is signed, if configured |
| VMSIGNEDDT | The date when the Visit Method was signed |
| EVSIGNED | Shows whether the event is signed |
| EVSIGNEDDT | The date when the event was signed |
| EVFROZEN | Shows if the event is frozen (Yes/No value) |
| EVFROZENDT | The date when the event was frozen |
| EVLOCKED | Shows if the event is locked (Yes/No value) |
| EVLOCKED | The date when the event was locked |
| EVENTVOFID | Vof ID of the event |
| LASTRUN | Datetime when the listing was last run |
Query Detail Versioned Extract
The following columns are included in the 24R1 version of the Query Detail Versioned Extract job:
| Column Header | Description |
|---|---|
| STUDY | Study Name |
| COUNTRY | Study Country Name |
| SITENUM | Site Number |
| SUBJECT | Subject Number |
| SUBSTATUS | Current Subject Status |
| EGROUP | Event Group Label of the Event Group where the query is |
| EVENT | Event Label of the Event where the query is |
| EGSEQ | Event Group Sequence Number |
| EVENTDT | Event Date entered |
| VISMETHOD | Shows the selected Visit Method, if configured |
| FORM | Form Label of the Form where the query is |
| FSEQ | Form Sequence Number |
| FORMSTATUS | Form Status |
| IGROUP | Item Group Label of the Item Group where the query is |
| IGSEQ | Item Group Sequence Number |
| ITEMEID | External ID (OID) of the item that the query is attached to |
| ITEM | Label of the item that the query is attached to |
| QUERYID | The query name (VV-XXXXX) (not the internal vault ID) |
| QUERYSTATUS | Current Status of the query |
| RESTRICTED | Shows if the query is Restricted or not (Yes/No value) |
| QUERYTEAM | Query Team assigned to the query |
| DAYSUR | Days the query has been unresolved |
| MANUAL | Shows if the query was manually created (Yes/No value) |
| QUERYRULE | If a query rule, the rule that originates the query |
| QTEXT | First message text of the query |
| LQTEXT | Latest query message |
| LQANSTEXT | Last answer of the query |
| NUMMSG | The number of query messages on a query |
| ITEMVALBQ | Value of the item the query is attached to before query creation |
| ITEMVALNOW | Value of the item the query is attached to at the time of run |
| ITEMVALCHG | Shows whether the value of the queried item changed (Yes/No value) |
| QCHGDATA | Shows whether the data changed after query creation (Yes/No value). This field is determined by checking if the item value was modified between creation and closing of the query (by dates). |
| CREATEDDT | Datetime of the creation of the query |
| CREATEDBY | User that created the query (or System) |
| CREATEDBYROLE | Role name of the user that created the query (or System) |
| CREATEDBYQTEAM | Query Team of the user that created the query |
| ANSDT | Datetime of last answer of the query |
| ANSBY | User that last answered the query |
| ANSBYROLE | Role name of the user that last answered the query |
| ANSBYQTEAM | Query Team of the user that last answered the query |
| CLOSEDDT | Datetime of last closing of the query |
| CLOSEDBY | User that last closed the query (or System) |
| CLOSEDBYROLE | Role name of the user that last closed the query (or System) |
| CLOSEDBYQTEAM | Query Team of the user that last closed the query |
| QUERYVOFID | Vault Query Object |
| LASTRUN | Datetime when the listing was last run |
If you have the Show Queries in the User Language setting configured, queries will display in the user’s language, not the vault language.
Subject Progress Versioned Extract
The following columns are included in the 24R1 version of the Subject Progress Versioned Extract job:
| Column Header | Description |
|---|---|
| STUDY | Study Name |
| COUNTRY | Study Country Name |
| SITENUM | Site Number |
| SUBJECT | Subject Number |
| SUBSTATUS | Current Subject status |
| RESTRICTED | Shows if the Subject is Restricted (Yes/No value) |
| MRVISIT | Last visit/event label of scheduled visits |
| MRVISITDT | Last visit/event date of scheduled visits |
| MEMRVISIT | Last visit/Visit Method |
| NXTEVENT | Next visit/event label of scheduled visits |
| ENTRYCOMP | Shows if all forms expected for a Subject have been submitted (Yes/No value) |
| SDVPLAN | SDV Plan assigned to the Subject |
| SDVCOMP | Shows if all forms and all event dates that require SDV have been marked SDV for the Subject |
| FSDVCOMPDT | The date that SDV was completed on all forms for the Subject |
| DMRPLAN | DMR plan assigned to the Subject |
| DMRCOMP | Shows if all forms and all event dates that require DMR have been marked DMR for the Subject |
| FDMRCOMPDT | The date that DMR was completed on all forms for the Subject |
| FROZEN | Shows if all forms and all event dates have been frozen for the Subject |
| LOCKED | Shows if all forms and all event dates have been locked for the Subject |
| SIGNED | Shows if all submitted forms and all event dates have been signed for the Subject |
| CLOSEDQUERIES | Shows if all queries for the Subject have been closed |
| CLEAN | Shows if a Subject is "clean," meaning that all forms are submitted, signed, and locked and all queries are closed. SDV and DMR should also be completed (Yes/No value) |
| NUMFORMS | Total number of forms for Subject |
| FORMSCOMP | Number of forms submitted |
| FORMSINC | Number of forms that are blank or in progress (e.g. forms that are not submitted yet) |
| FSDVCOMP | Number of forms that were marked as SDV reviewed for the subject |
| FSDVREQ | Number of forms that are SDV required for the subject |
| SFSDVREQ | Number of submitted forms that are SDV required for the subject |
| FSDVPCTCOMP | Percentage of forms that were marked as SDV reviewed for the subject compared to the number of forms marked SDV required |
| FNOTSDV | Number of forms submitted that require SDV based on the review plan but have not been marked for SDV |
| EVDTNOTSDV | Number of event dates that require SDV that have not been marked SDV for the Subject |
| VMNOTSDV | Number of Visit Methods that require SDV that have not been marked SDV for the Subject |
| FDMRCOMP | Number of forms that were marked as DMR reviewed for the Subject |
| FDMRREQ | Number of forms that are DMR required for the subject |
| SFDMRREQ | Number of submitted forms that are DMR required for the subject |
| FDMRPCTCOMP | Percentage of forms that were marked as DMR reviewed for the subject compared to the number of forms marked DMR required |
| FNOTDMR | Number of forms submitted that require DMR based on the review plan but have not been marked for DMR |
| EVDTNOTDMR | Number of event dates that require DMR that have not been marked DMR for the Subject |
| VMNOTDMR | Number of Visit Methods that require DMR that have not been marked DMR for the Subject |
| FNOTFROZEN | Total number of submitted forms that are not frozen |
| EVDTNOTFROZEN | Total number of event dates that are not frozen |
| VMNOTFROZEN | Total number of Visit Methods to be frozen |
| FNOTLOCKED | Total number of submitted forms that are not locked |
| EVDTNOTLOCKED | Total number of event dates that are not locked |
| VMNOTLOCKED | Total number of Visit Methods to be locked |
| FNOTSIGNED | Total number of submitted forms that are not signed |
| EVDTNOTSIGNED | Total number of event dates that are not signed |
| VMNOTSIGNED | Total number of Visit Methods to be signed |
| TOTALMC | Total Medical Coding Requests for the Subject |
| MEDDRAMC | Total MedDRA Medical Coding Requests |
| WHORDRUGMC | Total WHODrug Medical Coding Requests |
| MEDDRANC | MedDRA Medical Coding Requests that are not yet coded |
| WHODRUGNC | WHODrug Medical Coding Requests that are not yet coded |
| TQUERIES | Total number of queries |
| OQUERIES | Total number of open queries |
| AQUERIES | Total number of answered queries |
| CQUERIES | Total number of closed queries |
| SUBVOFID | Vof ID of the Subject |
| LASTRUN | Datetime when the listing was last run |