StudyParticipantCompliance


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ParticipantIdentifier varchar 100 √ null
FileDate datetime2 16,7 √ null
Phase varchar 250 √ null
HighAdherenceFullComplianceDays int 4 √ null
LastHighAdherenceFullComplianceDay datetime2 16,7 √ null
LastPROMPTKeepAlive datetime2 16,7 √ null
LastPROMPTKeepAlive_DTO datetimeoffset 20,7 √ null
LastOmronBP datetime2 16,7 √ null
LastOmronBP_DTO datetimeoffset 20,7 √ null
LastBreatheSession datetime2 16,7 √ null
LastBreatheSession_DTO datetimeoffset 20,7 √ null
LastAppleWatchWear datetime2 16,7 √ null
LastAppleWatchWear_DTO datetimeoffset 20,7 √ null
PROMPTVersion varchar 250 √ null
iOSVersion varchar 250 √ null
WatchOSVersion varchar 250 √ null
LongitudinalBaseCompletionMonths nvarchar 2147483647 √ null
LongitudinalGoldCompletionMonths nvarchar 2147483647 √ null
HighAdherenceComplianceDates nvarchar 2147483647 √ null
FileName varchar 250 √ null
FileCreationDate datetime2 16,7 √ null
ProcessedDate datetime2 16,7 √ null

Relationships