Table 24. CreateCustomerPartyEBM
|
Oracle FLEXCUBE Service Name |
Oracle FLEXCUBE Interface Object |
Oracle FLEXCUBE Interface Column |
Siebel Contact Business Compon-ent |
|
Siebel Account Business Compon-ent |
|
/Identification /ID |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIER /Customer-Full /CUSTNO |
Contact |
Integration Id |
Account |
Integration Id |
/Identification /Application ObjectKey /ContextID |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIER /Customer-Full/CTYPE |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyLocation /Location Reference /Address /LineOne |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIER/Customer-Full /ADDRLN1 |
CUT Address |
Street Address |
CUT Address |
Street Address |
/PartyLocation /Location Reference /Address /LineTwo |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/ADDRLN2 |
CUT Address |
Street Address 2 |
CUT Address |
Street Address 2 |
/PartyLocation /Location Reference /Address /LineThree |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/ADDRLN3 |
CUT Address |
City |
CUT Address |
City |
/PartyLocation /Location Reference /Address /LineFour |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/ADDRLN4 |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyLocation /Location Reference /Address /CountryCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/COUNTRY |
CUT Address |
Country |
CUT Address |
Country |
/PartyLocation /Location Reference /Location Identification /Alternate ObjectKey/Id |
Not applicable |
Not applicable |
Value provided is Y (Indicating primary address) |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyContact /Contact /Contact PhoneCommunication/ PhoneCommunication /Complete Number |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCust personal/TEL |
Contact |
Work Phone# |
Not applicable |
Not applicable |
/PartyContact /Contact /ContactFax Communica tion /FaxCommun ication /Complete Number |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCust personal /FAX |
Contact |
Fax Phone # |
Not applicable |
Not applicable |
/PartyContact /Contact /ContactEmail Communica tion /EmailComm unication/URI |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCust personal /EMAIL |
Contact |
Email Address |
Not applicable |
Not applicable |
/Person /GenderCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCust personal /SEX |
Contact |
M/F |
Not applicable |
Not applicable |
/Person /MaritalStatus Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCust domestic /MARTIAL STAT |
Contact |
Marital Status |
Not applicable |
Not applicable |
/Person /BirthDate Time |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /DOB |
Contact |
Birth Date |
Not applicable |
Not applicable |
/Person /Language Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/LANG |
Contact |
Language Code |
Not applicable |
Not applicable |
/Person /Nationality CountryCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal NLTY |
Contact |
Citizenship |
Not applicable |
Not applicable |
/Person /RentOrOwn Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Cust domestic/ACCOMADATE |
Contact |
Own or Rent |
Not applicable |
Not applicable |
/Person /Deceased Indicator |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/DEAD |
Contact |
Deceased Flag |
Not applicable |
Not applicable |
/Person /PersonName /FirstName |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/FSTNAME |
Contact |
First Name |
Not applicable |
Not applicable |
/Person /PersonName /MiddleName |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/MIDNAME |
Contact |
Middle Name |
Not applicable |
Not applicable |
/Person /PersonName /FamilyName |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /LSTNAME |
Contact |
Last Name |
Not applicable |
Not applicable |
/Person /PersonName /Title |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /TITLE |
Contact |
M/M |
Not applicable |
Not applicable |
/Person /PersonName /Alias |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/SNAME |
Contact |
Alias |
Not applicable |
Not applicable |
/Person /Education Record /MajorCourse Category |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Cust domestic /EDUSTAT |
Contact |
FINS Education |
Not applicable |
Not applicable |
/Person /Employment Record /Employer Organization Name |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Custprof /CURREMP |
Contact |
Employer Name Free Text |
Not applicable |
Not applicable |
/Person /Employment Record /JobTitle |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Custprof/CURRDESIG |
Contact |
Job Title |
Not applicable |
Not applicable |
/Organization /Name |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Custcorp/CORPNAME |
Not applicable |
Not applicable |
Account |
Name |
/Organization /LineOf Business |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Custcorp/CORPDESC |
Not applicable |
Not applicable |
Account |
Line of Business |
/Person /TaxPayer Identification Number |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/SSN |
Contact |
SSN |
Not applicable |
Not applicable |
/Organization /Home CountryCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/NLTY |
Not applicable |
Not applicable |
BIB Account BC |
Country of Incorpora- tion |
/Organization /BankBranch Reference /BankBranch Identification /ID |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/LBRN |
Not applicable |
Not applicable |
BIB Account BC |
Branch Code |
/LevelCode |
Not applicable |
Not applicable |
Values will be PROSPECT,CUSTOMER |
Contact |
Status |
Account |
Account Status |
/TypeCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/CTYPE |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/TaxCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/TAXGROUP |
Contact |
Tax Code |
BIB Account BC |
Tax Code |
/Status/Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/CCATEG |
Contact |
Type |
Account |
Type |
/Customer PartyCredit Profile/Credit RatingCode |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/CRRATE |
BIB Contact BC |
Credit Rating |
Account |
Credit Rating |
/PartyRelated Party /PartyRelated PersonParty /PersonParty Reference /PartyIdentifi cation/ID |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Custaccdet/Relation-ship-Linkage/CUSTOMER |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyRelated Party/Party RelatedPerson Party/Person Party Reference/PartyIdentific ation/Application ObjectKey/ID |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Custaccdet/Relation-ship-Linkage /XREF |
Party Relation ship To |
Related Party Id |
Party Relation ship To |
Related Party Id |
/PartyRelated Party/PartyRelated PersonParty/PersonParty Reference/PartyIdentific ation/Application ObjectKey/ContextID |
Not applicable |
Not applicable |
Values provided are I,C (Individual,Corporate) |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
/PartyRelated Party/Party Relationship /Relationship Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Custaccdet /Relation-ship-Linkage/RELATION-SHIP |
Party Relation ship To |
Relation ship Type |
Party Relation ship To |
Relation ship Type |
Not provided by Oracle FLEXCUBE Universal Banking |
Not applicable |
Not applicable |
Not applicable |
Party Relation ship To |
Calculated Related Party Type |
Party Relation ship To |
Calculated Related Party Type |
/Customer PartySpecific ation /Specification /Name |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/UIDNAME |
Contact |
ID Type |
Not applicable |
Not applicable |
/Customer PartySpecific ation /Specification /ValueText |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/UIDVAL |
Contact |
ID Informa-tion |
Not applicable |
Not applicable |
/Customer PartyFinancialServiceProfile /Financial Institution Branch BusinessUnit Reference/BusinessUnit Identification/iD |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/LBRN |
BIB Contact BC |
BIB Contact BC |
Not applicable |
Not applicable |
/PartyContact/Contact/Preferred Communica tionChannel Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/MEDIA |
Contact |
Preferred Communication Method |
Account |
Preferred Communication Method |
/Person/PersonalNationalIdentitiy /Identification /ID |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /PPTNO |
Contact |
Other ID Number |
Not applicable |
Not applicable |
/Customer PartyFinancialServiceProfile /Relationship PricingAllowed Indicator |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full /RPCUST |
BIB Contact BC |
RP Customer |
BIB Account BC |
Relation ship Pricing Customer Flag |
/Person/ MinorIndicator |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /MINOR |
BIB Contact BC |
Minor Indicator |
Not applicable |
Not applicable |
/Resident Indicator |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Cust domestic /STATUS |
BIB Contact BC |
Permenant Resident |
Not applicable |
Not applicable |
/PartyRelated Party/PartyRelated PersonParty /PersonParty Reference/PersonName /FullName |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Cust domestic /SPNAME |
Contact |
Spouse Name |
Not applicable |
Not applicable |
/Person /TotalDepend entCount |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Cust domestic /DEPOTH |
BIB Contact BC |
Number Of Depend- ents |
Not applicable |
Not applicable |
/Person/Employment Record /PositionType Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /Custprof /EMPSTAT |
BIB Contact BC |
Employ- ment Status |
Not applicable |
Not applicable |
/Person/Employment Record/Employment Duration |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal/Custprof /EMP TENURE |
BIB Contact BC |
Years Employed |
Not applicable |
Not applicable |
/Person /Personal Income Amount |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /Custprof /SALARY |
FIN Contact Income |
Amount |
Not applicable |
Not applicable |
/Potential Revenue Amount |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /Custprof /OTH INCOME |
FIN Contact Income |
Amount |
Not applicable |
Not applicable |
/Organization /Incorporat ionDate |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full /Custcorp /INCORPDT |
Not applicable |
Not applicable |
Account |
Date Formed |
/Organization /Organization FinancialStatement /Organization Financial Number /Amount |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full /Custcorp /NET WORTH |
Not applicable |
Not applicable |
BIB Account BC |
Customer Networth Amount |
/Person/Person Financial Profile /Financial Profile/Status/Code /Organization /Organization Financial Profile/Financial Profile/Status/Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full /KYCSTAT |
BIB Contact BC |
KYC Status |
BIB Account BC |
KYC Status Flag |
/Organization /ShortName |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/SNAME |
Not applicable |
Not applicable |
Account |
Alias |
/Customer PartyFinancial ServiceProfile /AntiMoney Laundering CheckReq uiredIndicator |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full /AMLREQD |
BIB Contact BC |
AML Required |
BIB Account BC |
AML Required Flag |
/Classification Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/CUST CLASSFN |
Contact |
Customer Value |
Account |
Account Value |
/Customer PartySpecific ation /Specification /ValueText |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/FLGUTL TYPRVDR |
Not applicable |
Not applicable |
Account |
Service Provider Flag |
/Customer PartyFinancial ServiceProfile /Financial Institution Reference/PartyIdentific ation/ID |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/LBRN |
BIB Contact |
Bank Code |
BIB Account BC |
Bank Code |
/Person /Person Financial Profile/Financial Profile/Status/SubStatus Code /Organization/Organization Financial Profile/Financial Profile/Status/SubStatus Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/FROZEN |
BIB Contact BC |
Frozen |
BIB Account BC |
Frozen Flag |
/Status /SubStatus Code |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full /WHRUNKN |
BIB Contact BC |
Where abouts Unknown |
BIB Account BC |
Where abouts Unknown Flag |
/PartyRelated Party/PartyRelated PersonParty/PersonParty Reference/PersonName/FullName |
FCUBS Customer Service |
ST-New Customer-Notify-MSG.xsd |
FCUBS_ NOTIFICA-TION /FCUBS_ NOTIF_ IDENTIFIERCustomer-Full/Cust personal /GUARDIAN |
BIB Contact BC |
Guardian Name |
Not applicable |
Not applicable |
/Customer PartyCredit Profile/Identification /ID |
EL Customer Liab Service |
GE-LiabilityCreate-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/LIABLITY NO |
BIB Contact BC |
Liability Number |
BIB Account BC |
Liability Number |
/Customer PartyCredit Profile/CreditLimit Amount |
EL Customer Liab Service |
GE-LiabilityCreate-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/OVERALL LIMIT |
BIB Contact BC |
Overall Limit Amount |
BIB Account BC |
Overall Limit Amount |
/Customer PartyCredit Profile/CurrencyCode |
EL Customer Liab Service |
GE-LiabilityCreate-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/LIABLITY CCY |
BIB Contact BC |
Limit Currency Code |
BIB Account BC |
Limit Currency Code |
/Customer PartyCredit Profile/TotalUtilized LineOfCredit Amount |
EL Customer Liab Service |
GE-LiabilityCreate-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/UTILISA TIONAMT |
BIB Contact BC |
Total Utilized Amount |
BIB Account BC |
Total Utilized Amount |
/Customer PartyCredit Profile/LastCredit ReviewDate |
EL Customer Liab Service |
GE-LiabilityCreate-Req-Full-MSG.xsd |
GEM_REQ_ENV/GEM_BODY/Liablity-Full/REVISION DATE |
BIB Contact BC |
Revision Date |
BIB Account BC |
Revision Date |