Entity Vision Prescription Fact

DescriptionAn order requested for a patient that is for opthalmology services or products.

For example:
Right eye patch for 5 days

Attributes
Accession NumAccession Num
Advanced Beneficiary Notice CdAdvanced Beneficiary Notice Cd
Advanced Beneficiary Notice Code SkAdvanced Beneficiary Notice Code Sk
Advanced Beneficiary Notice Override Reason CdAdvanced Beneficiary Notice Override Reason Cd
Advanced Beneficiary Notice Override Reason Code SkAdvanced Beneficiary Notice Override Reason Code Sk
AWM Load Info SkAWM Load Info Sk
Bifocals IndBifocals Ind
Calendar DkCalendar Dk
Call Back Phone NumCall Back Phone Num
Clinical Order DkClinical Order Dk
Clinical Order SkClinical Order Sk
Contact Lenses Prescription IndContact Lenses Prescription Ind
Current IndCurrent Ind
Diagnostic Service Section CdDiagnostic Service Section Cd
Diagnostic Service Section Code SkDiagnostic Service Section Code Sk
DWM Load Info SkDWM Load Info Sk
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Enterer Authorization Mode CdEnterer Authorization Mode Cd
Enterer Authorization Mode Code SkEnterer Authorization Mode Code Sk
Enterer Organization CdEnterer Organization Cd
Enterer Organization Code SkEnterer Organization Code Sk
Entering Device NmEntering Device Nm
Expiration DtExpiration Dt
Eyeglasses Prescription IndEyeglasses Prescription Ind
Filler Order NumFiller Order Num
Fillers Expected Availability TsFillers Expected Availability Ts
Left Lens Bifocal AddLeft Lens Bifocal Add
Left Lens Cylindrical AxisLeft Lens Cylindrical Axis
Left Lens Cylindrical PowerLeft Lens Cylindrical Power
Left Lens Spherical PowerLeft Lens Spherical Power
Order Action Reason CdOrder Action Reason Cd
Order Action Reason Code SkOrder Action Reason Code Sk
Order Action Status CdOrder Action Status Cd
Order Action Status Code SkOrder Action Status Code Sk
Order Discontinue TsOrder Discontinue Ts
Order Mode CdOrder Mode Cd
Order Mode Code SkOrder Mode Code Sk
Order Signed IndOrder Signed Ind
Order Status CdOrder Status Cd
Order Status Code SkOrder Status Code Sk
Order Status Modifier CdOrder Status Modifier Cd
Order Status Modifier Code SkOrder Status Modifier Code Sk
Order Status TsOrder Status Ts
Order Transaction TsOrder Transaction Ts
Order Type CdOrder Type Cd
Order Type Code SkOrder Type Code Sk
Parent Order NumParent Order Num
Patient DkPatient Dk
Patient SkPatient Sk
Placer Group NumPlacer Group Num
Placer Order NumPlacer Order Num
Plan Member DkPlan Member Dk
Plan Member SkPlan Member Sk
Practitioner DkPractitioner Dk
Practitioner SkPractitioner Sk
Provider DkProvider Dk
Response CdResponse Cd
Response Code SkResponse Code Sk
Result Handling CdResult Handling Cd
Result Handling Code SkResult Handling Code Sk
Right Lens Bifocal AddRight Lens Bifocal Add
Right Lens Cylindrical AxisRight Lens Cylindrical Axis
Right Lens Cylindrical PowerRight Lens Cylindrical Power
Right Lens Spherical PowerRight Lens Spherical Power
Sensitivity Level CdSensitivity Level Cd
Sensitivity Level Code SkSensitivity Level Code Sk
Source CdSource Cd
Source Code SkSource Code Sk
Tenant SkTenant Sk
Valid From TsValid From Ts
Valid To TsValid To Ts
Vision Prescription Fact BkVision Prescription Fact Bk
Vision Prescription Fact DkVision Prescription Fact Dk
Vision Prescription Fact SkVision Prescription Fact Sk

Relationship
Vision Prescription Order Fact_Calendar Dimension_FKVision Prescription Order Fact_Calendar Dimension_FK
Vision Prescription Order Fact_Patient Dimension_FKVision Prescription Order Fact_Patient Dimension_FK
Vision Prescription Order Fact_Plan Member Dimension_FKVision Prescription Order Fact_Plan Member Dimension_FK
Vision Prescription Order Fact_Practitioner Dimension_FKVision Prescription Order Fact_Practitioner Dimension_FK
Vision Prescription Order Fact_Provider Dimension_FKVision Prescription Order Fact_Provider Dimension_FK
Vision Prescription Order Fact_Clinical Order Dimension_FKVision Prescription Order Fact_Clinical Order Dimension_FK

Primary Key
Vision Prescription Fact PKVision Prescription Fact PK

Dependencies
 
 

Reverse Dependencies
 

Attribute Details

 Accession Num
DescriptionA workflow-management generated number that identifies the filler order (diagnostic service) for an imaging order. This identifier corresponds one-to-one to the order filler number but is used in internal tracking of the work within a diagnostic imaging service department.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Advanced Beneficiary Notice Cd
DescriptionIndicates the status of the patient's or the patient's representative's consent for responsibility to pay for potentially uninsured services. This element is introduced to satisfy CMS Medical Necessity requirements for outpatient services. This element indicates (a) whether the associated diagnosis codes for the service are subject to medical necessity procedures (b) whether, for this type of service, the patient has been informed that they may be responsible for payment for the service, and (c) whether the patient agrees to be billed for this service.

For Example:
Service is subject to medical necessity procedures
Patient has been informed of responsibility, and agrees to pay for service
Patient has been informed of responsibility, and asks that the payer be billed
Advanced Beneficiary Notice has not been signed
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Advanced Beneficiary Notice Code Sk
DescriptionIndicates the status of the patient's or the patient's representative's consent for responsibility to pay for potentially uninsured services. This element is introduced to satisfy CMS Medical Necessity requirements for outpatient services. This element indicates (a) whether the associated diagnosis codes for the service are subject to medical necessity procedures (b) whether, for this type of service, the patient has been informed that they may be responsible for payment for the service, and (c) whether the patient agrees to be billed for this service.

For Example:
Service is subject to medical necessity procedures
Patient has been informed of responsibility, and agrees to pay for service
Patient has been informed of responsibility, and asks that the payer be billed
Advanced Beneficiary Notice has not been signed
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Advanced Beneficiary Notice Override Reason Cd
DescriptionIndicates the reason why the patient did not sign an Advanced Beneficiary Notice. The reason may be coded or it may be a free text entry.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Advanced Beneficiary Notice Override Reason Code Sk
DescriptionIndicates the reason why the patient did not sign an Advanced Beneficiary Notice. The reason may be coded or it may be a free text entry.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 AWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Bifocals Ind
DescriptionIndicates whether or not the prescription is for bifocal eyeglasses.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Calendar Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Call Back Phone Num
DescriptionThe telephone number to call for clarification of a request or other information regarding the order.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Clinical Order Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Clinical Order Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Contact Lenses Prescription Ind
DescriptionIndicates whether or not the Vision Prescription is for contact lenses.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Current Ind
DescriptionSet to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Diagnostic Service Section Cd
DescriptionIndicates the section of the diagnostic service where the observation was performed. If the study was performed by an outside service, the identification of that service should also be recorded.

For Example:
Audiology
Blood Gases
Blood Bank
Cardiac Ultrasound
Cardiac Catheterization
CAT Scan
Chemistry
Cytopathology
Electrocardiac
Electroneuro
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Diagnostic Service Section Code Sk
DescriptionIndicates the section of the diagnostic service where the observation was performed. If the study was performed by an outside service, the identification of that service should also be recorded.

For Example:
Audiology
Blood Gases
Blood Bank
Cardiac Ultrasound
Cardiac Catheterization
CAT Scan
Chemistry
Cytopathology
Electrocardiac
Electroneuro
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 DWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Enterer Authorization Mode Cd
DescriptionIndicates the form of authorization a recorder had from the responsible practitioner to create or change an order.

For Example:
Electronic
E-mail
Fax
In Person
Mail
Paper
Phone
Reflexive (Automated system)
Video-conference
Voice
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Enterer Authorization Mode Code Sk
DescriptionIndicates the form of authorization a recorder had from the responsible practitioner to create or change an order.

For Example:
Electronic
E-mail
Fax
In Person
Mail
Paper
Phone
Reflexive (Automated system)
Video-conference
Voice
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Enterer Organization Cd
DescriptionIndicates the organization that the enterer belonged to at the time he/she enters/maintains the order, such as medical group or department.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Enterer Organization Code Sk
DescriptionIndicates the organization that the enterer belonged to at the time he/she enters/maintains the order, such as medical group or department.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Entering Device Nm
DescriptionIdentifies the physical device (terminal, PC) used to enter the order.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Expiration Dt
DescriptionThe date upon which the Vision Prescription expires.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Eyeglasses Prescription Ind
DescriptionIndicates whether or not the Vision Prescription is for eyeglasses.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Filler Order Num
DescriptionThe identifying number associated with the filling application.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Fillers Expected Availability Ts
DescriptionThe date and time the filler expects the services to be available. For Example, When a prescription is ready for pickup or when a supply will be sent or picked up, or for when a laboratory result is expected to be available.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Left Lens Bifocal Add
DescriptionIndicates the spherical power of the prescribed left lens in diopters to correct the near vision in case of bifocal lens.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Left Lens Cylindrical Axis
DescriptionIndicates the angle in degrees of the cylindrical correction for the left lens.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Left Lens Cylindrical Power
DescriptionIndicates the cylindrical power of the prescribed left lens in diopters to correct the distance or near vision.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Left Lens Spherical Power
DescriptionIndicates the spherical power of the prescribed left lens in diopters to correct the distance or near vision.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Action Reason Cd
DescriptionIndicates the reason for the order action event.

For Example:
Patient refused
Patient discharged
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Action Reason Code Sk
DescriptionIndicates the reason for the order action event.

For Example:
Patient refused
Patient discharged
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Action Status Cd
DescriptionIndicates the action associated with an order.

For Example:
Cancel
On Hold
Pending
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Order Action Status Code Sk
DescriptionIndicates the action associated with an order.

For Example:
Cancel
On Hold
Pending
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Order Discontinue Ts
DescriptionThe date and time an order was stopped or discontinued.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Mode Cd
DescriptionThe mode of the order. 

For Example:
Normal order (Default)
Future order
Standing order
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Mode Code Sk
DescriptionThe mode of the order. 

For Example:
Normal order (Default)
Future order
Standing order
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Signed Ind
DescriptionIndicates if this is a signed order.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Status Cd
DescriptionIndicates the current status of an order.

For Example:
Some, but not all, results available
Order was cancelled
Order is completed
Order was discontinued
Error, order not found
Order is on hold
In process, unspecified
Order has been replaced
In process, scheduled
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Status Code Sk
DescriptionIndicates the current status of an order.

For Example:
Some, but not all, results available
Order was cancelled
Order is completed
Order was discontinued
Error, order not found
Order is on hold
In process, unspecified
Order has been replaced
In process, scheduled
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Status Modifier Cd
DescriptionIndicates the modifier who refined the order status. May be used to provide additional levels of specificity or additional information for the defined order status codes.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Status Modifier Code Sk
DescriptionIndicates the modifier who refined the order status. May be used to provide additional levels of specificity or additional information for the defined order status codes.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Status Ts
DescriptionA date and time that specifies the start of the Order Status.

For example:
A pharmacy order becomes 'on hold' and the accompanying status timestamp is YYYY/DD/MM 00:00
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Transaction Ts
DescriptionThe date and time of the event that initiated the order.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Type Cd
DescriptionIndicates whether the order is to be executed in an inpatient setting or an outpatient setting.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Order Type Code Sk
DescriptionIndicates whether the order is to be executed in an inpatient setting or an outpatient setting.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Parent Order Num
DescriptionA number which uniquely represents an order in the operational system. The identifier code for the parent order which caused this observation/test/battery to be performed.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Placer Group Num
DescriptionA number used to identify a group of orders.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Placer Order Num
DescriptionThe placer application's order number for the service/material being ordered.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Plan Member Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Plan Member Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Practitioner Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Practitioner Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Response Cd
DescriptionIndicates the amount of information to be returned from the filler. Sometimes the requested level of response may not be possible immediately, but when it is possible, the filler (receiving) application must send the information.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Response Code Sk
DescriptionIndicates the amount of information to be returned from the filler. Sometimes the requested level of response may not be possible immediately, but when it is possible, the filler (receiving) application must send the information.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Result Handling Cd
DescriptionIndicates how the handling of the order result is to be managed. For example, an order may specify that the result (e.g., an x-ray film) should be given to the patient for return to the requestor.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Result Handling Code Sk
DescriptionIndicates how the handling of the order result is to be managed. For example, an order may specify that the result (e.g., an x-ray film) should be given to the patient for return to the requestor.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Right Lens Bifocal Add
DescriptionIndicates the spherical power of the prescribed right lens in diopters to correct the near vision in case of bifocal lens.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Right Lens Cylindrical Axis
DescriptionIndicates the angle in degrees of the cylindrical correction for the right lens.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Right Lens Cylindrical Power
DescriptionIndicates the cylindrical power of the prescribed right lens in diopters to correct the distance or near vision.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Right Lens Spherical Power
DescriptionIndicates the spherical power of the prescribed right lens in diopters to correct the distance or near vision.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sensitivity Level Cd
DescriptionThe level of security and/or sensitivity surrounding the order.

For Example:
Very restricted
Restricted
Usual control
Employee
Unwed mother
Very important person or celebrity
Psychiatric patient
AIDS patient
HIV(+) patient
Alcohol/drug treatment patient
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sensitivity Level Code Sk
DescriptionThe level of security and/or sensitivity surrounding the order.

For Example:
Very restricted
Restricted
Usual control
Employee
Unwed mother
Very important person or celebrity
Psychiatric patient
AIDS patient
HIV(+) patient
Alcohol/drug treatment patient
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Cd
DescriptionThe code that corresponds to the Source Code Sk.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Vision Prescription Fact Bk
DescriptionConcatenated values of a set of business attributes that uniquely identify the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Vision Prescription Fact Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keytrue



 Vision Prescription Fact Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Vision Prescription Order Fact_Calendar Dimension_FK
Is Identifying Relationshipfalse
Child TableVision Prescription Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCalendar Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Vision Prescription Order Fact_Patient Dimension_FK
Is Identifying Relationshipfalse
Child TableVision Prescription Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Vision Prescription Order Fact_Plan Member Dimension_FK
Is Identifying Relationshipfalse
Child TableVision Prescription Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePlan Member Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Vision Prescription Order Fact_Practitioner Dimension_FK
Is Identifying Relationshipfalse
Child TableVision Prescription Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePractitioner Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Vision Prescription Order Fact_Provider Dimension_FK
Is Identifying Relationshipfalse
Child TableVision Prescription Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableProvider Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Vision Prescription Order Fact_Clinical Order Dimension_FK
Is Identifying Relationshipfalse
Child TableVision Prescription Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableClinical Order Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Vision Prescription Fact PK
Key AttributeVision Prescription Fact Dk