# Technical Standards
## 1. Folder Strategy (Box)
- `/input`: Source files.
- `/success`: Original file after COMPLETED status.
- `/error`: Original file + Error CSV after FAILED status or if partial errors exist.
## 2. Implementation Standards
- **Reader**: Must support `.csv`, `.xls`, `.xlsx`.
- **Processor**: 100% logic here. Return a Wrapper object containing [OriginalData, ValidatedEntity, ErrorMessage].
- **Writer**:
- Valid records -> MyBatis -> Stored Procedure.
- Invalid records -> FlatFileItemWriter -> `[filename]_error_[timestamp].csv`.
- **MyBatis**: Use `BATCH` executor and `CALLABLE` statement type.