generate_production_request
Creates a formatted production deployment request email following BSG's mandatory format. Automatically flags schedule conflicts, schema problems, and policy compliance issues.
Instructions
Generates a formatted production deployment request email following BSG's mandatory format. Includes automatic warnings for schedule issues, schema problems, and BSG policy compliance.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db_origin | No | Source database name | integraDBData |
| solicitante | Yes | Name of the person making the request | |
| time_window | No | Time window for deployment e.g. '18:00 - 20:00 hrs' (optional) | |
| validations | Yes | List of validations performed in DEV environment | |
| db_destination | No | Target database name | integraDB |
| requirement_id | Yes | Requirement identifier (e.g. 'OP-1234') | |
| scheduled_date | No | Scheduled deployment date in YYYY-MM-DD format (optional) | |
| script_filename | No | Attached script filename (optional) | |
| change_description | Yes | Brief and direct description of the DDL change | |
| requirement_description | Yes | Brief description of the requirement |