Pre-defined Periodic Report Variables
Oracle Argus Dossier provides a number of pre-defined periodic report variables. When using these variables in your template scripts, be aware of the following:
- The system only considers encoded events for SOC-based variables; it ignores all unencoded events.
- For all variables that return a count, return a 0 when the result is NULL.
- When a variable returns multiple values, those values are separated with a forward slash ( / ) character.
- For all variables that return a frequency value, print the value with a % sign and round it to two (2) decimal places.
- All SQL statements for pregnancy cases consider any populated neonate.
The following table lists and describes the pre-defined periodic report variables available for your use.
Variable | Description |
---|---|
#REPORT_NUMBER |
The Report Number entered in the report header configuration in the Subject Tab. |
#TRADE_NAME |
The Trade Name entered in the report header configuration. By default, Oracle Argus Safety pre-populates the configured Trade Name for the ingredients. You may change these defaults by editing the name. |
#GENERIC_NAME |
The ingredients that the report has been configured to run against. |
#REPORT_START_DATE |
The inclusion period start date for the report (Scheduling Tab). |
#REPORT_END_DATE |
The inclusion period end date for the report (Scheduling Tab). |
#IBD |
The earliest birth date for the product licenses included in the report. If configured to do so, Oracle Argus Safety pre-populates this value. This value can be changed if necessary. |
#COUNTRY_IBD |
The name of the country with the earliest license date based on the products in the report configuration. |
#TOTAL_COUNTRIES_MARKET |
The total number of countries where both of the following are true: The selected products have a marketed license. The selected products do not have a withdrawn date. |
#TOTAL_CASES |
The total number of adverse events being reported on. This value is based on the cases selected for the report. |
#TOTAL_CASES_SERIOUS |
The total number of serious cases included in the generated report. A case is considered serious if any event in the case has a seriousness check box checked. |
#TOTAL_CASES_NON_SERIOUS |
The total number of non-serious cases included in the generated report. A case is considered non-serious if all of the events do not have the Seriousness check box checked. |
#TOTAL_CASES_SP |
The total number of spontaneous cases included in the generated report. A case is considered spontaneous when the Report Type is not marked as Include in Clinical Trial in List Maintenance. |
#TOTAL_CASES_SP_LIT |
The total number of spontaneous literature cases included in the generated report. A case is considered spontaneous literature when both of the following are true: The Report Type is not marked as Include in Clinical Trial Include as Literature is checked in List Maintenance. |
#TOTAL_CASES_SOC_PRIMARY("soc_name") |
The total number of cases where the primary event has been encoded using the same System Organ Class as specified in soc_name. |
#TOTAL_CASES_SOC("soc_name") |
The total number of cases where any event has been encoded using the same System Organ Class as specified in soc_name. |
#TOTAL_CASES_SOC_SERIOUS("soc_name") |
The total number of serious cases where both of the following are true: Any event has been encoded using the same System Organ Class as specified. The same event is serious. |
#TOTAL_CASES_SOC_NON_SERIOUS ("soc_name") |
The total number of non-serious cases where both of the following are true: Any event has been encoded using the same System Organ Class as specified. The same event is non-serious. |
#TOTAL_CASES_SOC_UNLISTED ("soc_name") |
The total number of cases where both of the following are true: The event assessment for the product is Unlisted. Any event has been encoded with the specified System Organ Class. |
#TOTAL_CASES_SOC_SERIOUS_UNLISTED ("soc_name") |
The total numbers of cases where both of the following are true: The event assessment for the product is Unlisted. Any serious event has been encoded with the specified System Organ Class. |
#LISTOFTERMS_SOC_SERIOUS_UNLISTED ("soc_name") |
The Event name as coded for cases where both of the following are true: The event assessment for the product is Unlisted. Any serious event has been encoded with the specified System Organ Class. Multiple Terms must be separated with a forward slash ( / ). |
#SUBMISSION_DATE |
The date the report is due. The system calculates this date based on the values in the Scheduling tab for the report configuration. |
#SOC_NAME_TOP(x) |
The System Organ Class with the highest count based on the cases within report and the specified level. SOC term name with the xth highest occurrence in the case series. For example; #SOC_NAME_TOP(2) returns the name of the SOC with the second highest occurrence in the line listings. If there is more than one SOC at this level, the application uses a forward slash ( / ) to separate them when it prints the report. |
#SOC_COUNT_TOP(x) |
The total count of the System Organ Class that has the highest count based on the cases within the PSUR Report and the level as specified. SOC term count that has the xth highest occurrence in the case series. For example, #SOC_COUNT_TOP(2) returns the total number of occurrences for the SOC with the second highest occurrence in the line listings". |
#SOC_FREQUENCY_TOP(x) |
The frequency of occurrence (across all cases in the report) of the System Organ Class that has the xth highest count based on the cases in the report. Frequency of occurrence of events in the SOC that has the xth highest occurrence. For example, #SOC_FREQUENCY_TOP(2) = #SOC_COUNT_TOP(2) / #TOTAL_CASES |
#SOC_PT_NAME_TOP(x,y) |
The PT term name with the yth highest occurrence in the xth highest SOC occurrence. For example; #SOC_PT_NAME_TOP(2,3) returns the third most frequent Preferred Term name of the second most frequent SOC for the cases in the PSUR. |
#SOC_PT_COUNT_TOP(x,y) |
The number of occurrences of the PT name with the yth highest occurrence in the xth highest SOC occurrence. For example; #SOC_PT_COUNT_TOP(2,3) returns the number of the third most frequent Preferred Term of the second most frequent SOC for the line listings. |
#TOTAL_COUNTRIES_COUNT__REPORT |
The total number of countries from the Country of Incidence field (in the Case Form) based on the cases in the report. |
#TOTAL_CASES_COUNT_DRUGINTERACTIONS |
The total number of cases where any product on the Case Form (Product tab) has Yes specified for Interactions |
#TOTAL_CASES_COUNT_DRUGABUSE |
The total number of cases where any product on the Case Form (Product Tab) has True specified for Abuse |
#TOTAL_CASES_COUNT_PROSPECTPREGNANCY |
The total number of cases where both of the following are true: The patient is Pregnant. The pregnancy type is Prospective. (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_RETROPREGNANCY |
The total number of cases where the following are true: The patient is Pregnant. The pregnancy type is Retrospective. (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_PENDINGDELIVERY_PROSPECT |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type Prospective. The delivery date is greater than the current date. (Case Form | Patient Tab | Pregnancy Details). If you do not enter a delivery date, the application ignores the case. |
#TOTAL_CASES_COUNT_ELECTIVETERMINATIONS__PROSPECT |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The birth type is Elective Termination (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_SPONTANEOUSABORTIONS__PROSPECT |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The birth type is Spontaneous Abortions (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_FREQUENCY_SPONTANEOUSABORTIONS__PROSPECT |
The frequency of occurrence of cases where all of the following are true: The patient is Pregnant The pregnancy type is Prospective The birth type is Spontaneous Abortions and the pregnancy type is either Prospective or Retrospective. Computed as: ('= #TOTAL_CASES_COUNT_SPONTANEOUSABORTIONS / (#TOTAL_CASES_PROSPECT_PREGNANCY+#TOTAL_CASES_RETRO_PREGNANCY)" |
#TOTAL_CASES_COUNT_NORMALOUTCOME__PROSPECT |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The fetal outcome is Normal. (Case Form | Patient Tab | Pregnancy Details) |
#TOTAL_CASES_COUNT_FOLLOWUPLOST_PROSPECT |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The birth type is Lost to F/U (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_FOLLOWUPDONE_PROSPECT |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The birth type is not Lost to F/U (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_ABNORMALOUTCOME_PROSPECT |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type Prospective. The fetal outcome is not Normal. (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_CAMAJOR_PROSPECT |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The fetal outcome is CA Major (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_FREQUENCY_CAMAJOR_PROSPECT |
The frequency of occurrence of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The fetal outcome is CA Major and is not Normal (Case Form | Patient Tab | Pregnancy Details) |
#TOTAL_CASES_COUNT_CAMINOR_PROSPECT |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The fetal outcome is CA Minor (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_FREQUENCY_CAMINOR_PROSPECT |
The frequency of occurrence of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The fetal outcome is CA Minor and is not Normal (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_PREMATURE_PROSPECT |
Total # of Cases w/ProsPregnancy with premature birth type. |
#TOTAL_CASES_FREQUENCY_PREMATURE_PROSPECT |
The frequency of occurrence of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The birth type is Premature and the pregnancy type is Prospective (Case Form | Patient Tab | Pregnancy Details) |
#TOTAL_CASES_COUNT_STILLBIRTH_PROSPECT |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The birth type is Still Birth (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_FREQUENCY_STILLBIRTH_PROSPECT |
The frequency of occurrence of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The birth type is Still Birth and the pregnancy type is Prospective (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_PENDINGDELIVERY_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The delivery date is greater than the current date. (Case Form | Patient Tab | Pregnancy Details) If delivery date is not entered, the application ignores the case. |
#TOTAL_CASES_COUNT_ELECTIVETERMINATIONS_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The birth type is Elective Termination (Case Form | Patient Tab | Pregnancy Details)". |
#TOTAL_CASES_COUNT_SPONTANEOUSABORTIONS_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The birth type is Spontaneous Abortion (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_FREQUENCY_SPONTANEOUSABORTIONS_RETRO |
The frequency of occurrence in cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The birth type is Spontaneous and the pregnancy type is either Prospective or Retrospective. Computed as: ('= #TOTAL_CASES_COUNT_SPONTANEOUSABORTIONS_RETRO / (#TOTAL_CASES_PROSPECT_PREGNANCY+#TOTAL_CASES_RETRO_PREGNANCY)". |
#TOTAL_CASES_COUNT_NORMALOUTCOME_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The fetal outcome is Normal (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_FOLLOWUPLOST_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The birth type is Lost to F/U (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_FOLLOWUPDONE_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The birth type is not Lost to F/U (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_ABNORMALOUTCOME_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The fetal outcome is not Normal (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_CAMAJOR_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The fetal outcome is CA Major (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_FREQUENCY_CAMAJOR_RETRO |
The frequency of occurrence of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The fetal outcome is CA Major and is not Normal (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_CAMINOR_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The fetal outcome is CA Minor (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_FREQUENCY_CAMINOR_RETRO |
The frequency of occurrence of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The fetal outcome is CA Minor and is not Normal (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_PREMATURE_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The birth type is Premature (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_FREQUENCY_PREMATURE_RETRO |
The frequency of occurrence of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The birth type is Premature and the pregnancy type is Prospective (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_STILLBIRTH_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The birth type is Still Birth (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_FREQUENCY_STILLBIRTH_RETRO |
The frequency of occurrence of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The birth type is Still Birth and the pregnancy type is Prospective (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_CA_ALL |
The total number of cases where both of the following are true: The patient is Pregnant. The fetal outcome is either CA Major OR CA Minor (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_PERINATAL_PROSPECT |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The fetal outcome is Perinatal complication (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_PERINATAL_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The fetal outcome is Perinatal complication (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_POSTNATAL_PROSPECT |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Prospective. The fetal outcome is Post-perinatal complication (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_POSTNATAL_RETRO |
The total number of cases where all of the following are true: The patient is Pregnant. The pregnancy type is Retrospective. The fetal outcome is Post-perinatal complication (Case Form | Patient Tab | Pregnancy Details). |
#TOTAL_CASES_COUNT_PEDIATRICS |
The total number of cases where both of the following are true: The patient's age group has been selected The group has been configured with the E2B codes of either 1,2 or 3 in list maintenance. |
#SOC_NAME_TOP_PEDIATRICS(x) |
The SOC with the largest number based on the level specified where the patient's age group is with the E2B code value of 1,2 or 3 in list maintenance. |
#SOC_COUNT_TOP_PEDIATRICS(x) |
The largest number of SOC based on the level specified where the patient's age group is with the E2B code value of 1,2 or 3 in list maintenance. |
#SOC_FREQUENCY_TOP_PEDIATRICS(x) |
The frequency of occurrence of events in the SOC that has the xth highest occurrence in pediatrics (E2B code of 1, 2 or 3 in list maintenance). |
#TOTAL_CASES_COUNT_ELDERLY |
The total number of cases where both of the following are true: The patient's age group has been selected The group has been configured with the E2B codes of 6 in list maintenance. |
#SOC_NAME_TOP_ELDERLY(x) |
The SOC with the largest number based on the level specified where the patient's age group is with the E2B code value of 6 in list maintenance. |
#SOC_COUNT_TOP_ELDERLY(x) |
The largest number of SOC based on the level specified where the patient's age group is with the of 6 in list maintenance. |
#SOC_FREQUENCY_TOP_ELDERLY(x) |
The frequency of occurrence of events in the SOC that has the xth highest occurrence in pediatrics (E2B code of 6 in list maintenance). |
#DEV_INTERNATIONAL_BIRTHDATE |
The DIBD date of the product. |
Parent topic: Template Scripting Elements