Submit Views to PSUB
After you create a view definition (see the Data Extract chapter) you must generate the views in the Maintain Data Extract Views window; from the Conduct menu, select Data Extract, then select Data Extract Views. This PSUB job generates Oracle and SAS views from the same definitions.
To create the data extract views (or tables) in the database, Navigate to Conduct, then Data Extract, and finally Data Extract Views. The Data Extract Views window opens. Select the account type of the view and the account that matches the view. The account type is optional, but the account must match the account type.
For all types except Snapshot, the account is study$type. For example: study1$CURRENT. For all the values you provide in the form, there is a LOV. The system fills in the default for the SAS queue name with SYS$BATCH, the View Creation Mode with data_only, and the default for View Maintenance Mode with incremental; see "Full and Incremental Modes". The View Creation Mode parameter applies only to studies where the View Builder is not enabled, and Oracle Clinical ignores the entry in this field unless it is relevant.
The SAS queue name determines how a job is submitted. Oracle Clinical submits one job to the CPU running Oracle Clinical—the batch queue name, which can be seen in the Submission Details window. Oracle Clinical then writes a program to create the corresponding SAS views and submits this program to a potentially different queue, named Queue Name to Submit SAS, of the CPU running SAS.
View Maintenance, like any PSUB job, is automated, occurring as a batch job that can be scheduled.
See the following: