ReSA Employee

In Scope

Technical: SA_EMPLOYEE | ID: OR-RSA-SA_EMPLOYEE-RESA_EMPLOYEE

This table has been made redundant with migration to ADF and field level access is handled using application roles and privileges.

See how this object fits into Sales Audit

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: SA_EMPLOYEE

Field Definitions(5)

Rules & Considerations(15)

validation

constraint

Sample Load Data(4)

_scenario	NAMER	EMP_IDRPK	EMP_TYPER	CASHIER_INDR	SALESPERSON_INDR	EMAIL	PHONE	USER_ID
Example values from field definitions	SAMPLE	SAMPLE	SAMPLE	S	S	SAMPLE	SAMPLE	SAMPLE
default	SA Employee-002-ALT	ALT-SA_EMP	SA Emp	S	S	SA Employee-002-ALT	SA Employee-002-ALT	ALT-SA_EMPLOYE-002
default	SA Employee-003-EDGE	EDGE-SA_EM	SA Emp	S	S	SA Employee-003-EDGE	SA Employee-003-EDGE	EDGE-SA_EMPLOYE-003

Example values from field definitions

NAMER: SAMPLE
EMP_IDRPK: SAMPLE
EMP_TYPER: SAMPLE
CASHIER_INDR: S
SALESPERSON_INDR: S
EMAIL: SAMPLE
PHONE: SAMPLE
USER_ID: SAMPLE

default

NAMER: SA Employee-002-ALT
EMP_IDRPK: ALT-SA_EMP
EMP_TYPER: SA Emp
CASHIER_INDR: S
SALESPERSON_INDR: S
EMAIL: SA Employee-002-ALT
PHONE: SA Employee-002-ALT
USER_ID: ALT-SA_EMPLOYE-002

default

NAMER: SA Employee-003-EDGE
EMP_IDRPK: EDGE-SA_EM
EMP_TYPER: SA Emp
CASHIER_INDR: S
SALESPERSON_INDR: S
EMAIL: SA Employee-003-EDGE
PHONE: SA Employee-003-EDGE
USER_ID: EDGE-SA_EMPLOYE-003

Rule Validation Summary

Source Rule Count: 21
Governed Rule Count: 15