Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
RegStatusHistoryOID | int | NOT NULL | Unique ObjectID of each row. Primary key |
PatientVisit_OID | int | NOT NULL | Visit ObjectID related to a RegStatusHistory. Must exist as objectid in HPatientVisit table. |
CreationDTimeMins | smalldatetime | NOT NULL | Creation date time of the row. System date/time defaulted. |
LastCngDtime | datetime | NOT NULL | Last system UTC date /time when row was updated. |
RegStatusMilestone | varchar(10) | NOT NULL | Predefined to match Registration Status from HPatientVisit table. |
| | | Allowable Values: Quick_Reg - Quick Registration, Full_Reg - Full Registration |
MilestoneDTimeMins | smalldatetime | NOT NULL | Date and time when patient visit registration status was created or changed. |