Table Detail Report

SERV_RES_IDENTIFIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Service Resource Identifier
Definition: Textual Identifiers for the Service Resources that represent Pharmacy locations
Table Type: REFERENCE





Column Detail - SERV_RES_IDENTIFIER


Column Name Type Null? Definition
SERVICE_RESOURCE_CD DOUBLE N A unique internal identifier for this service resource
SERV_RES_IDENTIFIER_ID DOUBLE N Unique id for Serv_res_identifier table
SERV_RES_IDENT_TYPE_CD DOUBLE N Identifies type of identifier information
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VALUE CHAR(200) N Pharamcy Service Resource Identifier information
VALUE_KEY VARCHAR(200) N Pharmacy Identifier information (Capitolized, and Indexed)
VALUE_KEY_A_NLS VARCHAR(800) Y VALUE_KEY_A_NLS column
VALUE_KEY_NLS VARCHAR(202) N Pharmacy Identifier information (Capitolized, and Indexed)



Relationship Detail - SERV_RES_IDENTIFIER


Child Column in SERV_RES_IDENTIFIER(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


SIG_CODES



Column Section Top of Page


Table-level Detail

Description: Sig Codes - Stores SIG code of Prescriptions
Definition: Sig Codes - Stores SIG Codes for Prescriptions
Table Type: REFERENCE





Column Detail - SIG_CODES


Column Name Type Null? Definition
DESCRIPTION VARCHAR(200) Y Translation for SIG Code (i.e. BID = twice a day)
FIELD_TYPE_CD DOUBLE N Field Type
LANGUAGE_CD DOUBLE N Language
SIG_CD DOUBLE N sig
SIG_TYPE_CD DOUBLE N Sig Type
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VALUE DOUBLE Y Stores specific numeric values


WARNING_LABEL



Column Section Top of Page


Table-level Detail

Description: Warning Label
Definition: Stores Warning Label details which could be associated to drugs/pharmacy medications
Table Type: REFERENCE





Column Detail - WARNING_LABEL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LABEL_FULL_TEXT VARCHAR(255) Y Full Text of Labels
LABEL_NBR DOUBLE Y Label Number
LABEL_NBR_SEQ DOUBLE N Sequence which will allow multiple rows with the same label_nbr and language_cd to be unique.
LABEL_TEXT VARCHAR(100) Y Truncated Label Text
LANGUAGE_CD DOUBLE N The language the label_text field is written in.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
WARNING_LABEL_ID DOUBLE N Warning Label Id


WARNING_LABEL_XREF



Column Section Top of Page


Table-level Detail

Description: Warning Label Cross Reference
Definition: Stores warning label details associated to a drug/pharmacy medication
Table Type: REFERENCE





Column Detail - WARNING_LABEL_XREF


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LABEL_NBR DOUBLE N Label number
LABEL_NBR_SEQ DOUBLE N Sequence which will allow multiple rows with the same label_number and nomenclature_id to be unique.
NOMENCLATURE_ID DOUBLE N nomenclature id
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
WARNING_LABEL_XREF_ID DOUBLE N Unique, generated key for a row in this table.