Global Temporary Tables
Global Temporary Tables (GTTs) are the Oracle tables, having data type as private; such that data inserted by a session can be accessed by that session only.
The session-specific rows in a GTT can be preserved for the entire session, as AI report tables are created using ON COMMIT PRESERVE ROWS clause.
The report specific package pkg_rep_linelisting, populates the following report GTTs:
- rep_case_tmp
- rep_event_tmp
- rep_prod_dose_tmp
- rep_evt_assess_tmp
- rep_case_detail_tmp - The Case Detail GTT is populated with user accessible cases in the generic package after applying user data security.
For more information, see: