Generic SMF - Limited Partnership Model Data Map 

LIMITED_PARTNERSHIP table is available only in environments v13.0 and higher.

Element

Optional/ Required

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Optional/ Required

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

accountingMethod

 

string

16025

in_lp_acct_method

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

ACCT_METHOD

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/accountingMethod

accountingReportingFrequency

 

string

16026

in_lp_acct_rep_freq

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

ACCT_REP_FREQ

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/accountingReportingFrequency

accountingReportingType

 

string

16027

in_lp_acct_rep_type

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

ACCT_REP_TYPE

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/accountingReportingType

acquisitionDate

 

date

16055

in_lp_acquisition_date

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

ACQUISITION_DAT

DATE

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/acquisitionDate

advisoryCommitteeMember

 

string

16028

in_lp_advisory_comm_member

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

ADVISORY_COMM_MEMBER

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/advisoryCommitteeMember

affiliateCode

 

string

16029

in_lp_affiliate_code

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

AFFILIATE_CODE

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/affiliateCode

affiliateName

 

string

16030

in_lp_affiliate_name

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

AFFILIATE_NAME

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/affiliateName

assetClass

 

string

16031

in_lp_asset_class

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

ASSET_CLASS

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/assetClass

closeFlag

 

normalizedString

16060

in_lp_close_flag

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

CLOSE_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/closeFlag

collateralType

 

string

16032

in_lp_collateral_type

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

COLLATERAL_TYPE

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/collateralType

companyConsolidated

 

string

16033

in_lp_company_consolidated

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

COMPANY_CONSOLIDATED

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/companyConsolidated

consolidatedFund

 

string

16034

in_lp_consolidated_fund

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

CONSOLIDATED_FUND

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/consolidatedFund

dealEndDate

 

date

16056

in_lp_deal_end_date

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

DEAL_END_DATE

DATE

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/dealEndDate

defaultProbability

 

decimal

16057

in_lp_default_probability

N

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

DEFAULT_PROBABILITY

NIMBER(38,12)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/defaultProbability

federalTaxId

 

string

16035

in_lp_fed_tax_id

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

FED_TAX_ID

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/federalTaxId

financialInterest

 

string

16036

in_lp_financial_interest

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

FINANCIAL_INTEREST

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/financialInterest

forecastCategory

 

string

16037

in_lp_forecast_category

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

FORECAST_CATEGORY

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/forecastCategory

gaapFootnoteCategory

 

string

16038

in_lp_gaap_footnote_category

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

GAAP_FOOTNOTE_CATEGORY

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/gaapFootnoteCategory

gpCountry

 

string

16046

in_lp_gp_country

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

GP_COUNTRY

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/gpCountry

investmentArea

 

string

16041

in_lp_investment_area

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

INVESTMENT_AREA

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/investmentArea

investmentOwned

 

string

16039

in_lp_int_owned

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

INT_OWNED

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/investmentOwned

investmentProductType

 

string

16040

in_lp_investment_prod_type

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

INVESTMENT_PROD_TYPE

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/investmentProductType

lawyer

 

string

16042

in_lp_lawyer_code

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

LAWYER_CODE

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/lawyer

lessee

 

string

16043

in_lp_lessee_code

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

LESSEE_CODE

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/lessee

locationCode

 

string

16044

in_lp_location_code

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

LOCATION_CODE

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/locationCode

nonAdmitted

 

string

16045

in_lp_non_admitted

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

NON_ADMITTED

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/nonAdmitted

partnershipClass

 

string

16047

in_lp_partnership_class

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

PARTNERSHIP_CLASS

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/partnershipClass

partnershipStructure

 

string

16048

in_lp_partnership_structure

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

PARTNERSHIP_STRUCTURE

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/partnershipStructure

relationshipContact

 

string

16049

in_lp_relship_contact_code

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

RELATIONSHIP_CONTACT_CODE

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/relationshipContact

responsibleDepartment

 

string

16050

in_lp_responsible_dept_code

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

RESPONSIBLE_DEPT_CODE

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/responsibleDepartment

statAnnualStatement

 

string

16051

in_lp_stat_annual_statement

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

STAT_ANNUAL_STATEMENT

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/statAnnualStatement

stateTaxId

 

string

16052

in_lp_state_tax_id

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

STATE_TAX_ID

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/stateTaxId

strategyType

 

string

16053

in_lp_strategy_type

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

STRATEGY_TYPE

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/strategyType

syndicator

 

string

16054

in_lp_syndicator

S

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

SYNDICATOR

VARCHAR2(255)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/syndicator

termYears

 

decimal

16059

in_lp_term_years

N

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

TERM_YEARS

NIMBER(38,12)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/termYears

yearOfOrigination

 

integer

16058

in_lp_year_of_origination

N

limited_partnership_model.inc

SECURITYDBO

LIMITED_PARTNERSHIP 

YEAR_OF_ORIGINATION

NIMBER(38)

EagleML/referenceTransaction/genericSMF/limitedPartnershipModel/yearOfOrigination