Database Tables

Key tables:

KCRT_requests
KCRT_request_details
KCRT_req_header_details
KCRT_request_types
KNTA_users

=========================================================

Understanding the relationship between an instance and an objects type:Instances = RequestsInstances of objects are stored in request tables.An object type can = a request type
When writing sql queries, it is necessary to understand that you need to join tables not only on request_id but also request_type_id since there are multiple request types.

======================================================== All of these are potential prefixes to database table names eg: KCRT_REQUESTS

• CRT - Create (Requests)
• DRV - Drive (Project Management)
• DLV - Deliver (Change Management)
• PMO - Programme Management
• PFM - Portfolio Management
• DEM - Demand (Requests)
• DSH - Dashboards
• DSS - ?
• ENV - Environments
• KCST - Kintana Cost
• KNTA - Validations that control ITG
• KRSC - Resource Management
• KRPS - PeopleSoft
• KRQC - Quality Centre
• KRRM - Release Management