Admin Per Day RtCreate DtFrequency Abbreviation DescrFrequency Code SkFrequency Unit Of Measure Code SkFrequency UnitsLoad Info SkSource Code SkTenant SkUpdate Dt
| Atomic Warehouse Model Data Model |
| Description | The frequency with which a drug is administered to a patient. The standardized frequency values may appear in alert functionality and/or reports. The frequency describes how often the drug is administered to a patient. |
| Attributes | |
| Admin Per Day Rt |
|
| Create Dt |
|
| Frequency Abbreviation Descr |
|
| Frequency Code Sk |
|
| Frequency Unit Of Measure Code Sk |
|
| Frequency Units |
|
| Load Info Sk |
|
| Source Code Sk |
|
| Tenant Sk |
|
| Update Dt |
|
| Relationship | |
 Frequency Code_Common Code_FK |
|
| Primary Key | |
 Frequency Code PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Admin Per Day Rt
| Description | Defines the number of times per day that a prescribed drug is taken or given. This would be a conversion based on the Frequency Units and Frequency Unit Of Measure if the unit of measure is not "days". For example, if Frequency Units = 6 and Frequency Unit Of Measure = "hours", then Admin Per Day Rt would be 4 (times per day). |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate Precision 9 [FLOAT(9)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Create Dt
| Description | The date upon which this record was created on the source system. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Frequency Abbreviation Descr
| Description | The abbreviation for a Frequency Code. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Frequency Code Sk
| Description | The generated unique key for Common Code table. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Frequency Unit Of Measure Code Sk
| Description | Qualifies the Frequency Units interval. For example, a Frequency Units of 6 could indicate every 6 hours, every 6 days, or every 6 weeks depending on the Frequency Unit Of Measure. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Frequency Units
| Description | Defines the interval of hours, days, weeks, or months upon which a prescribed drug or treatment should be given or taken. For example, a Frequency Units of 6 could indicate every 6 hours, every 6 days, or every 6 weeks depending on the Frequency Unit Of Measure. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Source Code Sk
| Description | The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Update Dt
| Description | The date upon which the frequency code details are edited/updated. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Frequency Code_Common Code_FK
| Is Identifying Relationship | true |
| Child Table | Frequency Code |
| Child Multiplicity | ZERO_TO_ONE |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Common Code |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Frequency Code PK
| Key Attribute | Frequency Code Sk |
| Atomic Warehouse Model Data Model |