Line Of Credit Facility Data Map Table

objectType

ObjectTypeEnum

not stored in DB

EagleML/referenceTransaction/lineOfCreditFacility/objectType

objectId

ObjectId

not stored in DB

EagleML/referenceTransaction/lineOfCreditFacility/objectId

objectDescription

FeedTypeEnum

not stored in DB

EagleML/referenceTransaction/lineOfCreditFacility/objectDescription

updateTimestamp

Required

dateTime

SECURITYDBO

LINE_OF_CREDIT

UPDATE_DATE

DATE

EagleML/referenceTransaction/lineOfCreditFacility/updateTimestamp

customElements

Not recommended

CustomElements - Complex type

EagleML/referenceTransaction/lineOfCreditFacility/customElements/

sourceName

string 

EagleML/referenceTransaction/lineOfCreditFacility/sourceName

updateSource

Required

string

SECURITYDBO

LINE_OF_CREDIT

UPDATE_SOURCE

VARCHAR2(255)

EagleML/referenceTransaction/lineOfCreditFacility/updateSource

effectiveDate

Required

date

SECURITYDBO

LINE_OF_CREDIT

EFFECTIVE_DATE

DATE

EagleML/referenceTransaction/lineOfCreditFacility/effectiveDate

languageId

integer

not stored in DB

EagleML/referenceTransaction/lineOfCreditFacility/languageId

tagNochangecase

string

not stored in DB

EagleML/referenceTransaction/lineOfCreditFacility/tagNochangecase

preserveNull

string

not stored in DB

EagleML/referenceTransaction/lineOfCreditFacility/preserveNull

noLoadValidationFlag

YesNoOptionEnum

not stored in DB

EagleML/referenceTransaction/lineOfCreditFacility/noLoadValidationFlag

accountingValidationFlag

YesNoOptionEnum

not stored in DB

EagleML/referenceTransaction/lineOfCreditFacility/accountingValidationFlag

facilityId

Required

string

SECURITYDBO

LINE_OF_CREDIT

FACILITY_ID

VARCHAR2(255)

EagleML/referenceTransaction/lineOfCreditFacility/facilityId

facilityType

string

SECURITYDBO

LINE_OF_CREDIT

FACILITY_TYPE

VARCHAR2(255)

EagleML/referenceTransaction/lineOfCreditFacility/facilityType

facilityName

string

SECURITYDBO

LINE_OF_CREDIT

FACILITY_NAME

VARCHAR2(255)

EagleML/referenceTransaction/lineOfCreditFacility/facilityName

durationOfFacilityInDays

decimal

SECURITYDBO

LINE_OF_CREDIT

DUR_OF_FACILITY_IN_DAYS

NUMBER(38,12)

EagleML/referenceTransaction/lineOfCreditFacility/durationOfFacilityInDays

allowLoanMaturityInDays

decimal

SECURITYDBO

LINE_OF_CREDIT

ALLOW_LOAN_MAT_IN_DAYS

NUMBER(38,12)

EagleML/referenceTransaction/lineOfCreditFacility/allowLoanMaturityInDays

allowMultipleFacilitiesFlag

YesNoOptionEnum

SECURITYDBO

LINE_OF_CREDIT

MULTIPLE_FACILITIES

VARCHAR2(1)

EagleML/referenceTransaction/lineOfCreditFacility/allowMultipleFacilitiesFlag

agentFeeDollars

decimal

SECURITYDBO

LINE_OF_CREDIT

AGENT_FEE_DOLLARS

NUMBER(38,12)

EagleML/referenceTransaction/lineOfCreditFacility/agentFeeDollars

agentFeeBasisPoints

decimal

SECURITYDBO

LINE_OF_CREDIT

AGENT_FEE_BASIS_POINTS

NUMBER(38,12)

EagleML/referenceTransaction/lineOfCreditFacility/agentFeeBasisPoints

agentFeeTerms

string

SECURITYDBO

LINE_OF_CREDIT

AGENT_FEE_TERMS

VARCHAR2(255)

EagleML/referenceTransaction/lineOfCreditFacility/agentFeeTerms

upfrontFeeBasisPoints

decimal

SECURITYDBO

LINE_OF_CREDIT

UPFRONT_FEE_BASIS_POINTS

NUMBER(38,12)

EagleML/referenceTransaction/lineOfCreditFacility/upfrontFeeBasisPoints

upfrontFeeDollars

decimal

SECURITYDBO

LINE_OF_CREDIT

UPFRONT_FEE_DOLLARS

NUMBER(38,12)

EagleML/referenceTransaction/lineOfCreditFacility/upfrontFeeDollars

commitmentFeeBasisPoints

decimal

SECURITYDBO

LINE_OF_CREDIT

COMMITMENT_FEE_BASIS_PTS

NUMBER(38,12)

EagleML/referenceTransaction/lineOfCreditFacility/commitmentFeeBasisPoints

commitmentFeePayDescription

string

SECURITYDBO

LINE_OF_CREDIT

COMMITMENT_FEE_PAY_DESC

VARCHAR2(1000)

EagleML/referenceTransaction/lineOfCreditFacility/commitmentFeePayDescription

commitmentFeeCalcDays

decimal

SECURITYDBO

LINE_OF_CREDIT

COMMITMENT_FEE_CALC_DAYS

NUMBER(38,12)

EagleML/referenceTransaction/lineOfCreditFacility/commitmentFeeCalcDays

defaultRatePercent

decimal

SECURITYDBO

LINE_OF_CREDIT

DEFAULT_RATE_PERCENT

NUMBER(38,12)

EagleML/referenceTransaction/lineOfCreditFacility/defaultRatePercent

defaultTermsDescription

string

SECURITYDBO

LINE_OF_CREDIT

DEFAULT_TERMS_DESCRIPTION

VARCHAR2(1000)

EagleML/referenceTransaction/lineOfCreditFacility/defaultTermsDescription

amount

decimal

SECURITYDBO

LINE_OF_CREDIT

AMOUNT

NUMBER(38,12)

EagleML/referenceTransaction/lineOfCreditFacility/amount

paymentTiming

decimal

SECURITYDBO

LINE_OF_CREDIT

PAYMENT_TIMING

NUMBER(38,12)

EagleML/referenceTransaction/lineOfCreditFacility/paymentTiming

paymentTimezone

string

SECURITYDBO

LINE_OF_CREDIT

PAYMENT_TIMEZONE

VARCHAR2(255)

EagleML/referenceTransaction/lineOfCreditFacility/paymentTimezone

paymentTimeOfDay

string

SECURITYDBO

LINE_OF_CREDIT

PAYMENT_TIME_OF_DAY

VARCHAR2(2)

EagleML/referenceTransaction/lineOfCreditFacility/paymentTimeOfDay

locEntity

LOC Entity Model - see extra table below

EagleML/referenceTransaction/lineOfCreditFacility/locEntity/

locIssuer

LOC Issuer Model - see extra table below

EagleML/referenceTransaction/lineOfCreditFacility/locIssuer/

LOC Entity Model

Entity Common Id Model

../

startDate

date

SECURITYDBO

LOC_ENTITY_RELATIONSHIP

START_DATE

DATE

../startDate

endDate

date

SECURITYDBO

LOC_ENTITY_RELATIONSHIP

END_DATE

DATE

../endDate

withdrawalIndicator

normalizedString

SECURITYDBO

LOC_ENTITY_RELATIONSHIP

WITHDRAWAL_INDICATOR

VARCHAR2(1)

../withdrawalIndicator

locAverageOutstanding

decimal

SECURITYDBO

LOC_ENTITY_RELATIONSHIP

LOC_AVG_OUSTANDING

NUMBER(38,12)

../locAverageOutstanding

locDaysInUse

decimal

SECURITYDBO

LOC_ENTITY_RELATIONSHIP

LOC_DAYS_IN_USE

NUMBER(38,12)

../locDaysInUse

LOC Issuer Model 

Issuer Identifiers Model

../

relationshipType

string

SECURITYDBO

LOC_ISSUER_RELATIONSHIP

RELATIONSHIP_TYPE

VARCHAR2(255)

../relationshipType

startDate

date

SECURITYDBO

LOC_ISSUER_RELATIONSHIP

START_DATE

DATE

../startDate

endDate

date

SECURITYDBO

LOC_ISSUER_RELATIONSHIP

END_DATE

DATE

../endDate

amount

decimal

SECURITYDBO

LOC_ISSUER_RELATIONSHIP

AMOUNT

NUMBER(38,12)

../amount