CST_PUBPROFILEDIAG (ver 15.5.1)
This table is a standalone table and stores diagnostic related information for specific profiles. Note: Each entry must have a unique CST_PUBPROFILEID and DIAGNOSTICNAME. This table is available for all states/provinces and may or may not be utilized for your state/province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBPROFILEDIAG record to which the record is associated. Required. (Default – Next value in CST_PUBPROFILEDIAG_SQ sequence) |
CST_PUBPROFILEID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBPROFILE record to which the record is associated. Required. |
DIAGNOSTICNAME | 15.5.1 | VARCHAR2(50) | Name of the diagnostic item being tracked. Required. |
DIAGNOSTICVALUE | 15.5.1 | VARCHAR2(300) | Value of the diagnostic item being tracked. |