Technical Specification Template

A number of objects will be built to support this sub-system. Objects are normally located in specific schemas depending on their role:

• CTL: Control information.
• STA: Staged (raw) data.
• VAL: Validated (in terms of datatypes, column widths, etc.) data.
• ODS: Operational Data Store.
• WHS: The data warehouse.
  

CTL:

• Sequences
• SEQ_1
  
• Tables
• TABLE_1
  
• Data
• DATA_1
• Processes
• PROCESS_1
  

STA:

• Sequences
• SEQ_1
  
• Tables
• TABLE_1
  
• Data
• DATA_1
• Processes
• PROCESS_1
  

VAL:

• Sequences
• SEQ_1
  
• Tables
• TABLE_1
  
• Data
• DATA_1
• Processes
• PROCESS_1
  

ODS:

• Sequences
• SEQ_1
  
• Tables
• TABLE_1
  
• Data
• DATA_1
• Processes
• PROCESS_1
  

WHS:

• Sequences
• SEQ_1
  
• Tables
• TABLE_1
  
• Data
• DATA_1
• Processes
• PROCESS_1