Deployed jobs
Scheduled jobs
ETL Process from SAS populates Data into Oracle tables

Seaware to SAS Goneaway and Deceased

SEAWARE

bsasexract schema

Tables

CLIENT_CLASS_CODE

Package

SCDL

Stored Procedure

Extract_Client_Class_Code

Extract_Client_Updates

ODD_BUTLINS Schema

Tables

BUT_ODD_CLIENT_CLASS_CODE

SCV_BUTLINS Schema

Tables

DIM_CLIENT_CLASS_CODE

FCT_CLIENT_CLASS_CODE

STAGING_BUTLINS Schema

Tables

P001_FCT_CLIENT_CLASS_CODE

SCV_BUTLINS_BI

View

BI_CLIENT_CLASS_CODE

MART_BUTLINS

MView

CLIENT_CLASS_CODE

SAS

SAS DI Jobs

P001_Daily_Seaware

P001_10_510_Migrate_Client_Class_Code

P001_30_Maintain_Client_Class_Code

P001_35_90_Client_Class_Code

P001_60_Writeback_Client_Class_Code

P010_Daily_Summaries

P010_200_Housekeeping

P010_215_Client_Class_Code_Suppression

SAS Library

Butlins SCDL

CLIENT_CLASS_CODE

CLIENT_UPDATES

Butlins ODD

BUT_ODD_CLIENT_CLASS_CODE

Butlins SCV

DIM_CLIENT_CLASS_CODE

FCT_CLIENT_CLASS_CODE

Butlins Mart

CLIENT_CLASS_CODE

Butlns Staging

P001_FCT_CLIENT_CLASS_CODE

SAS Management Console

SAS Platform Manager