HealthStudCathetersMonitor (ver24.6.0)
This table stores student Catheters monitoring results corresponding to the record in HeathStudMonitor table. A foreign key is in place for 1:1 relationship between these 2 tables.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
CatheterSize | 24.6.0 | Varchar2(30) | The actual size of the Catheter used. Optional. |
CatheterType | 24.6.0 | Varchar2(30) | The name of the Catheter type used |
ColorID | 24.6.0 | Number(10,2) | CodesetID corresponding to color of the sample is stored in this column (Yellow, Amber/Orange, Pink/Red, Other). Optional. |
ClarityID | 24.6.0 | Number(10,2) | CodesetID corresponding to clarity of the sample is stored in this column (Clear, Cloudy, Dark). Optional. |
HealthStudCathetersMonitorID | 24.6.0 | Number(16,0) | The unique sequential number generated by the application. Indexed. Required. |
HealthStudMonitorID | 24.6.0 | Number(16,0) | The monitoring ID stored in the HealthStudMonitor table. Foreign key to the HealthStudMonitor table. |
Odor | 24.6.0 | Number(1,0) | The column to check whether the sample has an odor or not |
Output | 24.6.0 | Number(10,2) | The actual amount of sample for catheter monitoring. Valid values: 0 to 999.99. Optional. |
PerformedBy | 24.6.0 | Number(10,2) | CodesetID corresponding to who performed the catheters monitoring is stored in this column (School Nurse, Self (Student)). Optional. |
TypeOfCatheterizationID | 24.6.0 | Number(10,2) | CodesetID corresponding to catheter type is stored in this column (Clean Intermittent, Other). Optional. |
WhenCreated | 24.6.0 | Date | The date and time the record was created. Defaults to system date. Required. |
WhenModified | 24.6.0 | Date | The date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 24.6.0 | Varchar2(305) | The name of the person who created the record. Defaults to user. Required. |
WhoModified | 24.6.0 | Varchar2(305) | The name of the person who modified the record. Defaults to user. Required. |