Code Value Model Data Map Table

Element

Optional/Required

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

Data Type

Xpath

Element

Optional/Required

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

Data Type

Xpath

codeValue

Required

string

 

 

PACE_MASTERDBO

CODE_VALUES

SHORT_DESC

char(20)

../codeValue

codeValueDescription

Optional

string

 

 

PACE_MASTERDBO

CODE_VALUES

LONG_DESC

char(50)

../codeValueDescription

codeValueLongDescription

Optional

string

 

 

PACE_MASTERDBO

EGL_GENERIC_XLATION_ML

DESCRIPTION

carchar(255)

../codeValueLongDescription

obsolete

Optional

string

10495

in_obsolete

PACE_MASTERDBO

CODE_VALUES

OBSOLETE

varchar2(1)

../obsolete

rollForwardFlag

Optional

YesNoOptionEnum

989

in_roll_forward

not stored in DB

 

 

 

../rollForwardFlag

systemControlFlag

Optional

YesNoOptionEnum

1148

 

not stored in DB

 

 

 

../systemControlFlag