HealthStudLead (ver 20.4.0)
Used to store data related to a Lead screening.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
GradeLevelAtScreen | 20.4.0 | Varchar2(6) | The grade level at the time of the screening. |
HealthMainStudRecID | 20.4.0 | Number(19) | Internal ID supported by a foreign key to the HealthMainStudRec table. Required. |
HealthStudLeadID | 20.4.0 | Number(19) | Unique identifier for this table. Required. |
LeadScreenerTypeLuID | 20.4.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of LeadScreenerTypeCode. |
LeadScreenOutcomeLuID | 20.4.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of LeadScreenOutcomeCode. |
ScreenComment | 20.4.0 | Varchar2(512) | A written comment regarding the screening. |
ScreenDate | 20.4.0 | Date | The date that the screening took place. Required. |
ScreenerName | 20.4.0 | Varchar2(305) | Name of the person who is performing the screening. |
WhenCreated | 20.4.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 20.4.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 20.4.0 | Varchar2(305) | The name of the person who create the record. Defaults to user. |
WhoModified | 20.4.0 | Varchar2(305) | The name of person who modified the record. Defaults to user. |