Client - Client Relationship Model Data Map Table
- Natalie Gesin (Deactivated)
- Dmitry Donosiyan (Unlicensed)
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|
clientRelationshipSwitch | Optional | ClientRelationshipTableEnum |
| in_switch | I | not stored in DB, used for resolution logic |
| EagleML/referenceTransaction/client/clientRelationship/clientRelationshipSwitch | ||
entity | Optional | EntityCommonIdModel | 5 | in_entity_id | S | EagleML/referenceTransaction/client/clientRelationship/entity/ | ||||
relationshipType | Optional | string | 4051 | in_relationship_type | S | RULESDBO | CLIENT_RELATIONSHIPS | RELATIONSHIP_TYPE | CHAR(20) | EagleML/referenceTransaction/client/clientRelationship/relationshipType |
crStartDate | Optional | date | 1322 | in_start_date | S | RULESDBO | CLIENT_RELATIONSHIPS | START_DATE | DATE | EagleML/referenceTransaction/client/clientRelationship/crStartDate |
crEndDate | Optional | date | 1319 | in_end_date | S | RULESDBO | CLIENT_RELATIONSHIPS | END_DATE | DATE | EagleML/referenceTransaction/client/clientRelationship/crEndDate |
crFlag | Optional | integer | 4052 | in_cr_flag | I | RULESDBO | CLIENT_RELATIONSHIPS | CR_FLAG | NUMBER | EagleML/referenceTransaction/client/clientRelationship/crFlag |
investmentTeamCode | Optional | string | 4053 | in_investment_team_code | S | RULESDBO | CLIENT_RELATIONSHIPS | INVESTMENT_TEAM_CODE | VARCHAR2(10) | EagleML/referenceTransaction/client/clientRelationship/investmentTeamCode |
crStatusFlag | Optional | YesNoOptionEnum | 4281 | in_status_flag | S | RULESDBO | CLIENT_RELATIONSHIPS | STATUS_FLAG | CHAR(1) | EagleML/referenceTransaction/client/clientRelationship/crStatusFlag |
relatnToBeneficialOwnr | Optional | string | 9506 | in_relatn_to_beneficial_ownr | S | RULESDBO | CLIENT_RELATIONSHIPS | RELATN_TO_BENEFICIAL_OWNR | VARCHAR2(30) | EagleML/referenceTransaction/client/clientRelationship/relatnToBeneficialOwnr |
tierFlag | Optional | YesNoOptionEnum | 8165 | in_tier_flag | S | RULESDBO | CLIENT_RELATIONSHIPS | TIER_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/client/clientRelationship/tierFlag |
pEntity | Optional | EntityCommonIdModel | 2495 | in_p_entity_id | S | EagleML/referenceTransaction/client/clientRelationship/pEntity/ | ||||
crUserChar1 | Optional | string | 2497 | in_user_char1 | S | RULESDBO | CLIENT_RELATIONSHIPS | USER_CHAR1 | VARCHAR2(32) | EagleML/referenceTransaction/client/clientRelationship/crUserChar1 |
crUserChar2 | Optional | string | 2498 | in_user_char2 | S | RULESDBO | CLIENT_RELATIONSHIPS | USER_CHAR2 | VARCHAR2(32) | EagleML/referenceTransaction/client/clientRelationship/crUserChar2 |
crUserNum1 | Optional | decimal | 2499 | in_user_num1 | F | RULESDBO | CLIENT_RELATIONSHIPS | USER_NUM1 | NUMBER(38,12) | EagleML/referenceTransaction/client/clientRelationship/crUserNum1 |
crUserNum2 | Optional | decimal | 2500 | in_user_num2 | F | RULESDBO | CLIENT_RELATIONSHIPS | USER_NUM2 | NUMBER(38,12) | EagleML/referenceTransaction/client/clientRelationship/crUserNum2 |
crUserNum3 | Optional | decimal | 2501 | in_user_num3 | F | RULESDBO | CLIENT_RELATIONSHIPS | USER_NUM3 | NUMBER(28,12) | EagleML/referenceTransaction/client/clientRelationship/crUserNum3 |
sharesAuthorized | Optional | decimal | 2496 | in_shares_authorized | F | RULESDBO | CLIENT_RELATIONSHIPS | SHARES_AUTHORIZED | NUMBER(38,12) | EagleML/referenceTransaction/client/clientRelationship/sharesAuthorized |
bhWaterMarkIncFee | Optional | decimal | 2488 | in_bh_water_mark_inc_fee | F | RULESDBO | CLIENT_RELATIONSHIPS | BH_WATER_MARK_INC_FEE | NUMBER(38,12) | EagleML/referenceTransaction/client/clientRelationship/bhWaterMarkIncFee |
hurdlePercentage | Optional | decimal | 2489 | in_hurdle_percentage | F | RULESDBO | CLIENT_RELATIONSHIPS | HURDLE_PERCENTAGE | NUMBER(38,12) | EagleML/referenceTransaction/client/clientRelationship/hurdlePercentage |
lossRecoveryPercentage | Optional | decimal | 2491 | in_loss_recovery_percentage | F | RULESDBO | CLIENT_RELATIONSHIPS | LOSS_RECOVERY_PERCENTAGE | NUMBER(28,12) | EagleML/referenceTransaction/client/clientRelationship/lossRecoveryPercentage |
lossRecoveryIncPercentage | Optional | decimal | 2490 | in_loss_recovery_inc_pct | F | RULESDBO | CLIENT_RELATIONSHIPS | LOSS_RECOVERY_INC_PERCENTAGE | NUMBER(28,12) | EagleML/referenceTransaction/client/clientRelationship/lossRecoveryIncPercentage |
newIssueFlag | Optional | YesNoOptionEnum | 2494 | in_new_issue_flag | S | RULESDBO | CLIENT_RELATIONSHIPS | NEW_ISSUE_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/client/clientRelationship/newIssueFlag |
minFee | Optional | decimal | 2493 | in_min_fee | F | RULESDBO | CLIENT_RELATIONSHIPS | MIN_FEE | NUMBER(38,2) | EagleML/referenceTransaction/client/clientRelationship/minFee |
maxFee | Optional | decimal | 2492 | in_max_fee | F | RULESDBO | CLIENT_RELATIONSHIPS | MAX_FEE | NUMBER(38,2) | EagleML/referenceTransaction/client/clientRelationship/maxFee |
frequency | Optional | YesNoOptionEnum | 1335 | in_frequency | F | RULESDBO | CLIENT_RELATIONSHIPS | FREQUENCY | VARCHAR2(1) | EagleML/referenceTransaction/client/clientRelationship/frequency |
crInstance | Optional | integer | 4049 | in_instance | I | RULESDBO | CLIENT_RELATIONSHIPS | INSTANCE | NUMBER | EagleML/referenceTransaction/client/clientRelationship/crInstance |
crdUserChar1 | Optional | string | 5192 | in_crd_user_char1 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR1 | VARCHAR2(100) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar1 |
crdUserChar2 | Optional | string | 5193 | in_crd_user_char2 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR2 | VARCHAR2(100) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar2 |
crdUserChar3 | Optional | string | 5194 | in_crd_user_char3 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR3 | VARCHAR2(100) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar3 |
crdUserChar4 | Optional | string | 5195 | in_crd_user_char4 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR4 | VARCHAR2(100) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar4 |
crdUserChar5 | Optional | string | 5196 | in_crd_user_char5 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR5 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar5 |
crdUserChar6 | Optional | string | 5197 | in_crd_user_char6 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR6 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar6 |
crdUserChar7 | Optional | string | 5198 | in_crd_user_char7 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR7 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar7 |
crdUserChar8 | Optional | string | 5199 | in_crd_user_char8 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR8 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar8 |
crdUserChar9 | Optional | string | 5200 | in_crd_user_char9 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR9 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar9 |
crdUserChar10 | Optional | string | 5201 | in_crd_user_char10 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR10 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar10 |
crdUserChar11 | Optional | string | 5202 | in_crd_user_char11 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR11 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar11 |
crdUserChar12 | Optional | string | 5203 | in_crd_user_char12 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR12 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar12 |
crdUserChar13 | Optional | string | 5204 | in_crd_user_char13 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR13 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar13 |
crdUserChar14 | Optional | string | 5205 | in_crd_user_char14 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR14 | VARCHAR2(20) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar14 |
crdUserChar15 | Optional | string | 5206 | in_crd_user_char15 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR15 | VARCHAR2(255) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar15 |
crdUserChar16 | Optional | string | 5207 | in_crd_user_char16 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR16 | VARCHAR2(3) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar16 |
crdUserChar17 | Optional | string | 5208 | in_crd_user_char17 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR17 | VARCHAR2(3) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar17 |
crdUserChar18 | Optional | string | 5209 | in_crd_user_char18 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR18 | VARCHAR2(3) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar18 |
crdUserChar19 | Optional | string | 5210 | in_crd_user_char19 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR19 | VARCHAR2(3) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar19 |
crdUserChar20 | Optional | string | 5211 | in_crd_user_char20 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR20 | VARCHAR2(3) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar20 |
crdUserChar21 | Optional | string | 5212 | in_crd_user_char21 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR21 | VARCHAR2(3) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar21 |
crdUserChar22 | Optional | string | 5213 | in_crd_user_char22 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR22 | VARCHAR2(3) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar22 |
crdUserChar23 | Optional | string | 5214 | in_crd_user_char23 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR23 | VARCHAR2(3) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar23 |
crdUserChar24 | Optional | string | 5215 | in_crd_user_char24 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR24 | VARCHAR2(3) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar24 |
crdUserChar25 | Optional | string | 5216 | in_crd_user_char25 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR25 | VARCHAR2(3) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar25 |
crdUserChar26 | Optional | string | 5217 | in_crd_user_char26 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR26 | VARCHAR2(50) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar26 |
crdUserChar27 | Optional | string | 5218 | in_crd_user_char27 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR27 | VARCHAR2(50) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar27 |
crdUserChar28 | Optional | string | 5219 | in_crd_user_char28 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR28 | VARCHAR2(50) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar28 |
crdUserChar29 | Optional | string | 5220 | in_crd_user_char29 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR29 | VARCHAR2(50) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar29 |
crdUserChar30 | Optional | string | 5221 | in_crd_user_char30 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_CHAR30 | VARCHAR2(50) | EagleML/referenceTransaction/client/clientRelationship/crdUserChar30 |
crdUserDate1 | Optional | date | 5182 | in_crd_user_date1 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_DATE1 | DATE | EagleML/referenceTransaction/client/clientRelationship/crdUserDate1 |
crdUserDate2 | Optional | date | 5183 | in_crd_user_date2 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_DATE2 | DATE | EagleML/referenceTransaction/client/clientRelationship/crdUserDate2 |
crdUserDate3 | Optional | date | 5184 | in_crd_user_date3 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_DATE3 | DATE | EagleML/referenceTransaction/client/clientRelationship/crdUserDate3 |
crdUserDate4 | Optional | date | 5185 | in_crd_user_date4 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_DATE4 | DATE | EagleML/referenceTransaction/client/clientRelationship/crdUserDate4 |
crdUserDate5 | Optional | date | 5186 | in_crd_user_date5 | S | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_DATE5 | DATE | EagleML/referenceTransaction/client/clientRelationship/crdUserDate5 |
crdUserNum1 | Optional | decimal | 5187 | in_crd_user_num1 | F | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_NUM1 | NUMBER(28,12) | EagleML/referenceTransaction/client/clientRelationship/crdUserNum1 |
crdUserNum2 | Optional | decimal | 5188 | in_crd_user_num2 | F | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_NUM2 | NUMBER(28,12) | EagleML/referenceTransaction/client/clientRelationship/crdUserNum2 |
crdUserNum3 | Optional | decimal | 5189 | in_crd_user_num3 | F | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_NUM3 | NUMBER(28,12) | EagleML/referenceTransaction/client/clientRelationship/crdUserNum3 |
crdUserNum4 | Optional | decimal | 5190 | in_crd_user_num4 | F | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_NUM4 | NUMBER(28,12) | EagleML/referenceTransaction/client/clientRelationship/crdUserNum4 |
crdUserNum5 | Optional | decimal | 5191 | in_crd_user_num5 | F | RULESDBO | CLIENT_RELATIONSHIP_DETAIL | CRD_USER_NUM5 | NUMBER(28,12) | EagleML/referenceTransaction/client/clientRelationship/crdUserNum5 |