GIPS Composite Data Map Table

Element

Optional/Required

Value Type

Eagle DB

DB Table

DB Field

Star Tag

DB Field Type

SP Parameter

SP Type

Xpath

Element

Optional/Required

Value Type

Eagle DB

DB Table

DB Field

Star Tag

DB Field Type

SP Parameter

SP Type

Xpath

objectType

Optional

ObjectTypeEnum

not stored in DB

 

 

 

 

EagleML/referenceTransaction/gIPSComposite/objectType

objectId

Optional

ObjectId

not stored in DB

 

 

 

 

EagleML/referenceTransaction/gIPSComposite/objectId

objectDescription

Optional

FeedTypeEnum

not stored in DB 

 

 

 

 

EagleML/referenceTransaction/gIPSComposite/objectDescription

updateTimestamp

Optional

dateTime

RULESDBO

ENTITY_RANGE_DETAILS

update_date

944

DATE

 

 

EagleML/referenceTransaction/gIPSComposite/updateTimestamp

customElements

Not recommended

CustomElements - Complex type

reserved for customizations

EagleML/referenceTransaction/gIPSComposite/customElements

sourceName

Optional

string - used in resolution logic

PACE_MASTERDBO

INTERFACES

short_desc

 

CHAR(15)

 

 

EagleML/referenceTransaction/gIPSComposite/sourceName

updateSource

Optional

string

RULESDBO

ENTITY_RANGE_DETAILS

UPDATE_USER

 

CHAR(30)

in_update_source

S

EagleML/referenceTransaction/gIPSComposite/updateSource

effectiveDate

Optional

date

not stored in DB

 

 

 

 

EagleML/referenceTransaction/gIPSComposite/effectiveDate

languageId

Optional

integer

not stored in DB

 

 

 

 

EagleML/referenceTransaction/gIPSComposite/languageId

tagNochangecase

Optional

string

not stored in DB

4637

 

 

 

EagleML/referenceTransaction/gIPSComposite/tagNochangecase

preserveNull

Optional

string

not stored in DB

 

 

 

 

EagleML/referenceTransaction/gIPSComposite/preserveNull

noLoadValidationFlag

Optional

YesNoOptionEnum

not stored in DB

 

 

 

 

EagleML/referenceTransaction/gIPSComposite/noLoadValidationFlag

compositeID

Required

string

RULESDBO

ENTITY_RANGE_DETAILS

ENTITY_ID

1153

CHAR(8)

in_composite_id

S

EagleML/referenceTransaction/gIPSComposite/compositeID

portfolioID

Required

string

RULESDBO

ENTITY_RANGE_DETAILS

ENTITY_DETAIL_ID

5

CHAR(8)

in_portfolio_id

S

EagleML/referenceTransaction/gIPSComposite/portfolioID

startDate

Optional

date

RULESDBO

ENTITY_RANGE_DETAILS

START_DATE

220

DATE

in_start_date

S

EagleML/referenceTransaction/gIPSComposite/startDate

endDate

Optional

date

RULESDBO

ENTITY_RANGE_DETAILS

END_DATE

221

DATE

in_end_date

S

EagleML/referenceTransaction/gIPSComposite/endDate

startComments

Optional

string

RULESDBO

ENTITY_RANGE_DETAILS

START_COMMENTS

12075

VARCHAR2(2000)

in_start_comments

S

EagleML/referenceTransaction/gIPSComposite/startComments

endComments

Optional

string

RULESDBO

ENTITY_RANGE_DETAILS

END_COMMENTS

2520

VARCHAR2(2000)

in_end_comments

S

EagleML/referenceTransaction/gIPSComposite/endComments

Â