Base Information On The Metadata Parameters

In Scope

Technical: SA_PARM | ID: OR-RSA-SA_PARM-RESA_PARM

The PARM table contains the base information on the metadata parameters. These parameters are the central data type for the metadata repository and are used extensively throughout ARI.

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

Information Type: Configuration
Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: SA_PARM

Field Definitions(5)

Rules & Considerations(50)

validation

constraint

Sample Load Data(4)

_scenario	SEQ_NOR	PARM_IDRPK	REALM_IDR	PARM_TYPE_IDR	PHYSICAL_NAMER	ERROR_IND	ACTIVE_IND	LOOKUP_IND	COMMENT_IND	FROM_CLAUSE	DISPLAY_NAME	OVERRIDE_IND	VALUE_COLUMN	WHERE_CLAUSE	DECODE_COLUMN	REALM_KEY_IND	DECODE_PARM_ID	LOOKUP_PARM_ID	OVERRIDE_VALUE	CURRENCY_PARM_ID	CURRENT_USER_IND	GROUP_LOOKUP_IND
Example values from field definitions	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	S	S	S	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	S
default	4	ALT-SA_PARM-002	ALT-SA_PARM-002	ALT-SA_PARM-002	SA Parm Secondary	S	S	S	S	SA Parm-002-ALT	SA Parm Secondary	S	SA Parm-002-ALT	SA Parm-002-ALT	SA Parm-002-ALT	S	ALT-SA_PARM-002	ALT-SA_PARM-002	SA Parm-002-ALT	ALT-SA_PARM-002	S	S
default	6	EDGE-SA_PARM-00	EDGE-SA_PARM-00	EDGE-SA_PARM-00	SA Parm Core	S	S	S	S	SA Parm-003-EDGE	SA Parm Core	S	SA Parm-003-EDGE	SA Parm-003-EDGE	SA Parm-003-EDGE	S	EDGE-SA_PARM-00	EDGE-SA_PARM-00	SA Parm-003-EDGE	EDGE-SA_PARM-00	S	S

Example values from field definitions

SEQ_NOR: 1
PARM_IDRPK: SAMPLE
REALM_IDR: SAMPLE
PARM_TYPE_IDR: SAMPLE
PHYSICAL_NAMER: SAMPLE
ERROR_IND: S
ACTIVE_IND: S
LOOKUP_IND: S
COMMENT_IND: S
FROM_CLAUSE: SAMPLE
DISPLAY_NAME: SAMPLE
OVERRIDE_IND: S
VALUE_COLUMN: SAMPLE
WHERE_CLAUSE: SAMPLE
DECODE_COLUMN: SAMPLE
REALM_KEY_IND: S
DECODE_PARM_ID: SAMPLE
LOOKUP_PARM_ID: SAMPLE
OVERRIDE_VALUE: SAMPLE
CURRENCY_PARM_ID: SAMPLE
CURRENT_USER_IND: S
GROUP_LOOKUP_IND: S

default

SEQ_NOR: 4
PARM_IDRPK: ALT-SA_PARM-002
REALM_IDR: ALT-SA_PARM-002
PARM_TYPE_IDR: ALT-SA_PARM-002
PHYSICAL_NAMER: SA Parm Secondary
ERROR_IND: S
ACTIVE_IND: S
LOOKUP_IND: S
COMMENT_IND: S
FROM_CLAUSE: SA Parm-002-ALT
DISPLAY_NAME: SA Parm Secondary
OVERRIDE_IND: S
VALUE_COLUMN: SA Parm-002-ALT
WHERE_CLAUSE: SA Parm-002-ALT
DECODE_COLUMN: SA Parm-002-ALT
REALM_KEY_IND: S
DECODE_PARM_ID: ALT-SA_PARM-002
LOOKUP_PARM_ID: ALT-SA_PARM-002
OVERRIDE_VALUE: SA Parm-002-ALT
CURRENCY_PARM_ID: ALT-SA_PARM-002
CURRENT_USER_IND: S
GROUP_LOOKUP_IND: S