ExternalSMRCodes Tables
The config_lookUp_externalSMRCodes_latest and config_lookUp_externalSMRCodes_changelog tables stores the externalSMRCodes and their corresponding jobCodes from lookUp config.
🔹 Standard Columns​
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
document_name | STRING | YES | Name of the Firestore document |
document_event_id | STRING | YES | Unique ID representing the document event (change ID) |
document_timestamp | TIMESTAMP | YES | Timestamp when the document event occurred |
document_operation | STRING | YES | Type of Firestore operation (e.g., CREATE, UPDATE, DELETE) |
document_id | STRING | YES | ID of the Firestore document |
externalCode | STRING | YES | External SMR code or reference |
jobCode | STRING | YES | Code identifying the job |