Client Communication Data Map Table

Element

Optional /Required

Value Type

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

DB Field Type

DB Required

Xpath

Element

Optional /Required

Value Type

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

DB Field Type

DB Required

Xpath

objectType

Optional

ObjectTypeEnum

 

 

 

not stored in DB

 

 

EagleML/referenceTransaction/clientCommunication/objectType

objectId

Optional

ObjectId

 

 

 

not stored in DB

 

 

EagleML/referenceTransaction/clientCommunication/objectId

objectDescription

Optional

FeedTypeEnum

 

 

 

not stored in DB

 

 

EagleML/referenceTransaction/clientCommunication/objectDescription

updateTimestamp

Optional

dateTime

 

 

 

RULESDBO

CLIENT_COMMUNICATION

UPDATE_DATE

DATE

N

EagleML/referenceTransaction/clientCommunication/updateTimestamp

customElements

Not recommended

CustomElements

 

 

 

reserved for customization

EagleML/referenceTransaction/clientCommunication/customElements

sourceName

Required

string

 

 

 

PACE_MASTERDBO

INTERFACES

SHORT_DESC

VARCHAR2(15)

Y

EagleML/referenceTransaction/clientCommunication/sourceName

updateSource

Required

string

944

in_update_source

S

RULESDBO

CLIENT_COMMUNICATION

UPDATE_SOURCE

VARCHAR2(50)

N

EagleML/referenceTransaction/clientCommunication/updateSource

effectiveDate

Required

date

1109

in_effective_date

S

RULESDBO

CLIENT_COMMUNICATION

EFFECTIVE_DATE

DATE

Y

EagleML/referenceTransaction/clientCommunication/effectiveDate

languageId

Optional

integer

 

 

 

not stored in DB

 

 

EagleML/referenceTransaction/clientCommunication/languageId

tagNochangecase

Optional

string

 

 

 

not stored in DB

 

 

EagleML/referenceTransaction/clientCommunication/tagNochangecase

preserveNull

Optional

string

 

 

 

not stored in DB

 

 

EagleML/referenceTransaction/clientCommunication/preserveNull

noLoadValidationFlag

Optional

YesNoOptionEnum

 

 

 

not stored in DB

 

 

EagleML/referenceTransaction/clientCommunication/noLoadValidationFlag

accountingValidationFlag

Optional

YesNoOptionEnum

 

 

 

not stored in DB

 

 

EagleML/referenceTransaction/clientCommunication/accountingValidationFlag

clientId

Optional

string

 

 

S

RULESDBO

CLIENT

CLIENT_ID

CHAR(20)

Y

EagleML/referenceTransaction/clientCommunication/clientId

clientCommunication

 

 

 

 

 

Client Xref Identifier Model

EagleML/referenceTransaction/clientCommunication/

clientInst

Optional

integer

4245

in_client_inst

N

RULESDBO

CLIENT_COMMUNICATION

CLIENT_INST

NUMBER

Y

EagleML/referenceTransaction/clientCommunication/clientInst

addressType

Optional

string

 

 

 

RULESDBO

CLIENT_ADDRESS

ADDRESS_TYPE

VARCHAR2(20)

Y

EagleML/referenceTransaction/clientCommunication/addressType

addressInst

Optional

integer

3251

in_address_inst

N

RULESDBO

CLIENT_COMMUNICATION

ADDRESS_INST

NUMBER

Y

EagleML/referenceTransaction/clientCommunication/addressInst

communicationType

Required

string

9504

in_comm_type

S

RULESDBO

CLIENT_COMMUNICATION

COMM_TYPE

VARCHAR2(20)

Y

EagleML/referenceTransaction/clientCommunication/communicationType

communicationValue

Optional

string

9505

in_comm_value

S

RULESDBO

CLIENT_COMMUNICATION

COMM_VALUE

VARCHAR2(100)

N

EagleML/referenceTransaction/clientCommunication/communicationValue

note

Optional

string

3461

in_note

S

RULESDBO

CLIENT_COMMUNICATION

NOTE

LONG

N

EagleML/referenceTransaction/clientCommunication/note

instance

Optional

integer

4268

in_instance

S

RULESDBO

CLIENT_COMMUNICATION

INSTANCE

NUMBER

Y

EagleML/referenceTransaction/clientCommunication/instance

Â