Model / INT / STSMAP

INT — Universal Interaction Journal

STSMAP

9 fields · 4 key · 1 foreign keys · sourced from EVEglyphDesign canonical structure.

Status crosswalk. Salesforce case statuses, ServiceNow incident states, telephony dispositions and a parish register's own words all resolve to one canonical status set, while the source value stays on the interaction line untouched. Normalisation that destroys the original is not normalisation, it is loss.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
SOR_CLV keysystema originis clavisSource system keyEGD_SRCSYSCHAR 10SYSRC
FNS_OBI_TBL keyfons obiectum tabulaSource object or table nameEGD_SRCTYPCHAR 40
FNS_STA_VAL keyfons status valorSource status valueEGD_SRCSTACHAR 40
STA_FNS_VALstatus fons valorCanonical status the source value resolves toEGD_STATUSCHAR 10
STA_DSCstatus descriptioCanonical status descriptionTEXT60CHAR 60
OPNCLSOpen, closed or cancelled classificationEGD_OPNCLSCHAR 1
STA_GSVstatus gradus servitiiStatus stops the service level clockXFELDCHAR 1
STA_TML_SORstatus terminale systema originisStatus is terminal in the source systemXFELDCHAR 1

Foreign keys

FieldCheck tableCheck field
SRCSYSSYSRCSRCSYS

View STSMAP.yaml in the repository