|
|
|
|
Columns
Column name |
Data type |
Description |
|---|---|---|
PATIENTGUID |
VARCHAR2(36) |
InForm patient identifier. |
VISITGUID |
VARCHAR2(36) |
InForm visit identifier. |
VISITINDEX |
FLOAT |
InForm visit index, if the visit is repeating. |
PAGEGUID |
VARCHAR2(36) |
InForm page identifier. |
PAGEINDEX |
FLOAT |
InForm page index, if the page is repeating. |
RECREVISIONNUMBER |
NUMBER |
Revision number (timestamp) of the status change for the form. The highest number is the current revision. |
PFDATETIME |
DATE |
Date and time when the status of the form changed in the InForm software. |
USERGUID |
VARCHAR2(36) |
GUID of the InForm user who caused the status change. |
LOCKEDSTATE |
NUMBERPS(38,0) |
Flag indicating whether the form is locked:
|
FROZENSTATE |
NUMBERPS(38,0) |
Flag indicating whether the form is frozen:
|
SIGNEDSTATE |
NUMBERPS(38,0) |
Flag indicating whether the form is signed:
|
FORMSTATE |
NUMBERPS(38,0) |
Bitmask summarizing the state of the form. The value is the sum of all of the form state bit values that apply. These values are described in FORMSTATE values. |
