Data Framework - Common Data Model(DF) PDM Diagram_V1.1_(2017-05-22)

Data Framework – Common Data Model (DF)Physical Data Model DiagramInformation in this document is subject to change without notice.No part of this document may be reproduced or transmitted in any form or by any means,for any purpose, without the express written permission of TEMENOS HEADQUARTERS SA.© 2016 Temenos Headquarters SA - all rights reserved.

Data Framework – Common Data Model (DF)PDM DiagramContentsData Framework – Common Data Model (DF)..................................................................................... 1Common Reference Data – PDM Diagram ............................................................................................ 3Date & World Calendar Support – PDM Diagram ............................................................................... 4Conformed Business Dimensions – PDM Diagram.............................................................................. 52

Data Framework – Common Data Model (DF)PDM DiagramCommon Reference Data – PDM DiagramCommon Reference Data is a common set of tables across the entire reporting database that serves as reference orlookup for information held within reporting database. These tables include both Global Reference Data (LikeCountry, Currency, etc.) as well as Temenos Specific Reference Data (Like Transaction Types, Channels, etc). Theyare used to support and provide semantics or meaning to the T24 information held within the Reporting Database.for example, what language a description might be in, or what currency an amount might be in or what industry acustomer might have an occupation in. TRAN_COMBINE_TXN INDUSTRY TARGET CUSTOMER_STATUS DIM_CHANNEL CHANNEL_UNSUPRES Industry_Id: number NOT NULL Target_Id: number NOT NULL C hannel_Id: number NOT NULL (FK) Transaction_Id: number NOT NULL (FK) C ustomer_Status_Id: number NOT NULL Channel_Id: number NOT NULL C hnl_Inputter_Mvref: number NOT NULL Com_Txn_Mvref: number NOT NULL Industry_C ode: number(4) NOT NULL Target_C ode: number(4) NOT NULL Unsuppress: varchar(15) NULL High_Risk: varchar(3) NULL Inputter: varchar(40) NULL C ustomer_Status: number(4) NULL Valid_Ind: varchar(1) NULL Combine_Txn: varchar(3) NULL Inputter: varchar(40) NULL Authoriser: varchar(40) NULL Inputter: varchar(40) NULL Valid_From: datetime NULL BAL_TYPE_VIRBAL Authoriser: varchar(40) NULL Record_Status: varchar(4) NULL Authoriser: varchar(40) NULL Valid_To: datetime NULL Bal_Type_Id: number NOT NULL (FK) DIM_TRANSACTIONTYPE Record_Status: varchar(4) NULL C urr_No: number(4) NULL Record_Status: varchar(4) NULL Channel_Type: varchar(15) NULL Virtu_Bal_Mvref: NUMBER NOT NULL C urr_No: number(4) NULL C o_Code: varchar(11) NULL C urr_No: number(4) NULL Channels: varchar(20) NOT NULL Virtual_Bal: varchar(35) NULL Transaction_Id: number NOT NULL C o_Code: varchar(11) NULL Dept_C ode: varchar(4) NULL C o_Code: varchar(11) NULL Record_Status: varchar(4) NULL Dept_C ode: varchar(4) NULL Auditor_C ode: varchar(16) NULL Dept_C ode: varchar(4) NULL Inputter: varchar(40) NULL Valid_Ind: varchar(1) NULL Auditor_C ode: varchar(16) NULL Audit_Date_Time: varchar(15) NULL Auditor_C ode: varchar(16) NULL Authoriser: varchar(40) NULL Valid_From: datetime NULL Audit_Date_Time: varchar(15) NULL Date_Time: varchar(15) NULL Audit_Date_Time: varchar(15) NULL Curr_No: number(4) NULL Valid_To: datetime NULL Date_Time: varchar(15) NULL Date_Time: varchar(15) NULL Co_C ode: varchar(11) NULL Transaction_C ode: number NOT NULL TARGET_DESCRIPTION Dept_Code: varchar(4) NULL C heque_Ind: varchar(1) NULL INDUSTRY_DESCRIPTION CUSTOMER_STATUS_DESCRIPTION Auditor_Code: varchar(16) NULL Mandatory_Ref_No: varchar(1) NULL Industry_Id: number NOT NULL (FK) Target_Id: number NOT NULL (FK) C ustomer_Status_Id: number NOT NULL (FK) Audit_Date_Time: varchar(15) NULL Debit_Credit_Ind: varchar(6) NULL Language_Id: number NOT NULL (FK) Language_Id: number NOT NULL (FK) Language_Id: number NOT NULL (FK) Date_Time: varchar(15) NULL C o_Code: varchar(11) NULL Swift_Narrative: varchar(4) NULL Description: varchar(35) NULL Description: varchar(35) NULL Description: varchar(35) NULL DIM_BAL_TYPE Record_Status: varchar(4) NULL Short_Name: varchar(35) NULL Short_Name: varchar(35) NULL Inputter: varchar(40) NULL Bal_Type_Id: number NOT NULLTRAN_CHARGE_KEY Authoriser: varchar(40) NULL CALENDAR_DATE_DESCRIPTION LANGUAGE CHANNEL_DESCRIPTION Transaction_Id: number NOT NULL (FK) Short_Desc: varchar(15) NULL Calendar_Id: integer NOT NULL (FK) Valid_Ind: varchar(1) NULL Chg_Narr_Mvref: number NOT NULL Stmt_Narr: varchar(25) NULL Date_Value: datetime NOT NULL (FK) Language_Id: number NOT NULL C hannel_Id: number NOT NULL (FK) Valid_From: datetime NULL Charge_Key: varchar(7) NULL Data_C apture: varchar(1) NULL Language_Id: number NOT NULL (FK) Language_Id: number NOT NULL (FK) Valid_To: datetime NULL Immediate_Charge: varchar(2) NULL Month_Name: varchar(20) NULL Mnemonic: varchar(10) NOT NULL Balance_Type_Id: varchar(20) NOT NULL CURRENCY_CCYMKT Default_Value_Date: varchar(8) NULL Description: varchar(35) NULL Desc: varchar(35) NULL Reporting_Type: varchar(15) NULL Currency_Id: number NOT NULL (FK) Exposure_Date: varchar(8) NULL USER Iso_C ode: varchar(2) NULL Short_Name: varchar(15) NULL Fin_System: varchar(3) NULL Ccy_Cmkt_Mvref: number NOT NULL Turnover_C harge: varchar(2) NULL User_Identifier: number NOT NULL Language_Code: varchar(3) NOT NULL Linked_Live_Type: varchar(20) NULL Currency_Market: number(2) NULL Unit_C ost: decimal(18) NULL Language_Id: number NOT NULL (FK) Date_Format: varchar(1) NULL BAL_TYPE_DESCRIPTION Fwd_Linked_Type: varchar(12) NULL Quotation_Susp: varchar(20) NULL Initiation: varchar(8) NULL T24_User_Identifier: varchar(18) NULL Amount_Format: varchar(2) NULL Self_Balancing: varchar(2) NULL Mid_Reval_Rate: decimal(16) NULL Stmt_Narr_Ref: varchar(5) NULL User_Name: varchar(18) NULL Min_Mand_Length: integer NULL Language_Id: number NOT NULL (FK) Suspend_Balance: varchar(2) NULL Default_Spread: decimal(11) NULL Force_Def_Exp_Date: varchar(1) NULL C ompany_Code: varchar(18) NULL Attributes: varchar(40) NULL Bal_Type_Id: number NOT NULL (FK) Activity_Update: varchar(2) NULL Buy_Rate: decimal(16) NULL Narr_Type: varchar(8) NULL Record_Status: varchar(4) NULL Sub_Type_Allowed: varchar(2) NULL Sell_Rate: decimal(16) NULL C ombine_Prod_C at: varchar(5) NULL TRAN_TYPE_DESCRIPTION Curr_No: number(4) NULL Description: varchar(35) NULL Sub_Type_Activity: varchar(2) NULL Upto_Small_Amt: decimal(18) NULL C ombine_System_Id: varchar(6) NULL Transaction_Id: number NOT NULL (FK) Authoriser: varchar(40) NULL Movement_Suppress: varchar(2) NULL Trsy_Small_Sprd: decimal(11) NULL Exp_Key: varchar(11) NULL Language_Id: number NOT NULL (FK) Co_C ode: varchar(11) NULL PARTY_RELATION_DESCRIPTION Mis_Update: varchar(2) NULL Cust_Small_Sprd: decimal(11) NULL C hq_Type: varchar(4) NULL Narrative: varchar(30) NULL Dept_Code: varchar(4) NULL Entry_Type: varchar(7) NULL Negotiable_Amt: decimal(18) NULL Update_Int_Pools: varchar(3) NULL Auditor_Code: varchar(16) NULL Relation_Code: number NOT NULL Record_Status: varchar(4) NULL Trsy_Med_Spread: decimal(11) NULL C urr_No: number(4) NULL SECTOR_DESCRIPTION Audit_Date_Time: varchar(15) NULL Language_Id: number NOT NULL (FK) C urr_No: number(4) NULL Cust_Med_Spread: decimal(11) NULL Dept_C ode: varchar(4) NULL Sector_Id: number NOT NULL (FK) Inputter: varchar(40) NULL Authoriser: varchar(40) NULL Reval_Rate: decimal(16) NULL Auditor_C ode: varchar(16) NULL Language_Id: number NOT NULL (FK) Date_Time: varchar(15) NULL Description: varchar(35) NULL C o_Code: varchar(11) NULL Audit_Date_Time: varchar(15) NULL Description: varchar(35) NULL Audit_Date_Time: varchar(40) NULL Dept_C ode: varchar(4) NULL CURRENCY_LCLREF Dispo_Exempt: varchar(3) NULL Short_Name: varchar(35) NULL Auditor_C ode: varchar(11) NULL Auditor_C ode: varchar(16) NULL C urrency_Id: number NOT NULL (FK) Date_Time: varchar(15) NULL Authoriser: varchar(40) NULL Audit_Date_Time: varchar(15) NULL C cy_Lcref_Mvref: number NOT NULL CURRENCY_DESCRIPTION C o_Code: varchar(15) NULL Signed_Type: varchar(2) NULL Dft_Ccy_Unit: varchar(10) NULL SECTOR Currency_Id: number NOT NULL (FK) C urr_No: NUMBER(4) NULL Exclude_Cr_C heck: varchar(3) NULL Language_Id: number NOT NULL (FK) Date_Time: varchar(40) NULL Inputter: varchar(40) NULL CURRENCY_EQCCY_LIAMT Sector_Id: number NOT NULL Ccy_Name: varchar(35) NULL Dept_C ode: varchar(4) NULL Date_Time: varchar(15) NULL C urrency_Id: number NOT NULL (FK) Country_Description: varchar(35) NULL Inputter: varchar(40) NULL C cy_Eqccy_Mvref: number NOT NULL Sector_Code: number(4) NOT NULL Record_Status: varchar(4) NULL Equivalent_Ccy: varchar(3) NULL Inputter: varchar(40) NULL Rev_Rel_Desc: varchar(3) NULL Trsy_Limit_Amt: decimal(18) NULL Authoriser: varchar(40) NULL Reverse_Relation: varchar(35) NULL Record_Status: varchar(4) NULL Curr_No: number(4) NULL PRODUCT_DESCRIPTION PARTY_ROLE_DESCRIPTION Co_C ode: varchar(11) NULL Dept_C ode: varchar(4) NULL Product_Id: number NOT NULL (FK) Role_Id: VARC HAR(20) NOT NULL Auditor_C ode: varchar(16) NULL Language_Id: number NOT NULL (FK) Language_Id: number NOT NULL (FK) Audit_Date_Time: varchar(15) NULL Risk_Expo_Type: varchar(3) NULL Description: varchar(35) NULL Description: varchar(35) NULL Date_Time: varchar(15) NULL Short_Name: varchar(35) NULL Audit_Date_Time: varchar(15) NULL Auditor_C ode: varchar(16) NULL DIM_CURRENCY DIM_PRODUCT Authoriser: varchar(40) NULL C o_Code: varchar(11) NULL C urrency_Id: number NOT NULL Product_Id: number NOT NULL C urr_No: NUMBER(4) NULL Date_Time: varchar(15) NULL Valid_Ind: varchar(1) NULL Valid_Ind: varchar(1) NULL Dept_C ode: varchar(4) NULL Valid_From: datetime NULL Valid_From: datetime NULL Inputter: varchar(40) NULL Valid_To: datetime NULL Valid_To: datetime NULL Other_Info_Req: varchar(3) NULL C urrency_C ode: varchar(3) NOT NULL System_Ind: varchar(2) NULL Record_Status: varchar(4) NULL Number_C cy_C ode: number(3) NULL Mnemonic: varchar(10) NULL Record_Status: varchar(4) NULL Ac_Contingent: number(35) NULL CONTRACTTXNTYPE_DESC LANG_LOCAL_REF Inputter: varchar(40) NULL Inputter: varchar(40) NULL Authoriser: varchar(40) NULL Authoriser: varchar(40) NULL C ontract_Txn_Type_Id: number NOT NULL (FK) Language_Id: number NOT NULL (FK) C o_C ode: varchar(11) NULL C o_Code: varchar(11) NULL Language_Id: number NOT NULL (FK) Lan_Lncllref_Mvref: number NOT NULL Rank: number(3) NULL Processing_Time: datetime NULL No_Of_Decimals: number(1) NULL C ategory_C ode: number(6) NULL Description: varchar(35) NULL Local_Ref: varchar(35) NULL Quotation_C ode: number(1) NULL Mi_Categ_Group: varchar(6) NULL Short_Desc: varchar(35) NULL Quotation_Pips: number(1) NULL Mi_Entry_Type_Dft: varchar(4) NULL Days_Delivery: number(2) NULL C onsolidate_Ent: varchar(20) NULL Days_Forward: number(2) NULL Position_Type: varchar(2) NULL Interest_Day_Basis: varchar(12) NULL Record_Status: varchar(4) NULL Rate_Allowance: decimal(16) NULL C urr_No: number(4) NULL Fixing_Date: datetime NULL Dept_Code: varchar(4) NULL C urr_No: number(4) NULL Auditor_C ode: varchar(16) NULL Dept_C ode: varchar(4) NULL Audit_Date_Time: varchar(15) NULL Auditor_C ode: varchar(16) NULL Date_Time: varchar(15) NULL Audit_Date_Time: varchar(15) NULL Min_Round_Amount: decimal(6) NULL PRODUCT_PLALLOC DIM_CONTRACTTXNTYPE C ash_Only_Rounding: varchar(3) NULL Min_Round_Type: varchar(4) NULL Product_Id: number NOT NULL (FK) Contract_Txn_Type_Id: number NOT NULL C ash_Round_Type: varchar(4) NULL Mipl_Mvref: number NOT NULL Precious_Metal: varchar(3) NULL Valid_Ind: varchar(1) NULL C ountry_Code: varchar(2) NULL Mi_Pl_Alloc2_Id: varchar(35) NULL Valid_From: datetime NULL Fixed_Rate: decimal(16) NULL Valid_To: datetime NULL Fixed_C cy: varchar(3) NULL Inputter: varchar(40) NULL Fixed_Start_Date: datetime NULL Authoriser: varchar(40) NULL Base_C cy_Rank: number(3) NULL Transaction_Code: varchar(3) NULL Available_Date: datetime NULL Record_Status: varchar(4) NULL Blocked_Date: datetime NULL Curr_No: number(4) NULL C ls_Ccy: varchar(3) NULL Co_C ode: varchar(11) NULL C ut_Off_Time: varchar(6) NULL Dept_C ode: varchar(4) NULL Date_Time: varchar(15) NULL Auditor_C ode: varchar(16) NULL Override: varchar(500) NULL Audit_Date_Time: varchar(15) NULL Reversal_Marker: varchar(9) NULL Description: varchar(35) NULL Date_Time: varchar(15) NULL3

Data Framework – Common Data Model (DF)PDM DiagramDate & World Calendar Support – PDM DiagramDate & world Calendar Support represents the various tables that allow aggregation of transactional data based oncalendar attributes (both – the Gregorian Calendar as well as any other world calendar). It consists of a DateDimension and additional tables to extend its capabilities to allow other calendar dates as well. CA LENDAR BA NKING_DA TE C ale ndar_Id: integer NOT NULL C ale ndar_Nam e: va rcha r(20) NOT NULL Ba nking_Da te : date time NOT NULL Com pa ny_C ode: va rcha r(15) NOT NULLDIM_DA TE CA LENDA R_DATE Processing_Tim e : datetime NOT NULL Date_Va lue : datetime NOT NULL Ca lenda r_Id: inte ge r NO T NULL (FK) Acco unting_Stage: va rchar(25) NULL Da te_Va lue: da tetim e NO T NULL (FK) To da y: da te time NULL Day_O f_W e ek: integer NOT NULL Ve rsion: varchar(1) NULL Day_O f_Mo nth: integer NOT NULL Ca lenda r_Da te _Value: datetime NOT NULL La st_W orking_Day: datetime NULL W e ek _O f_Mo nth: integer NOT NULL Da y_O f_W ee k: integer NULL Ne xt_W o rking_Day: datetime NULL Q ua rter_O f_Yea r: integer NOT NULL Da y_O f_Month: integer NULL Lo ca l_P aym ent_Da y: datetime NULL Day_O f_Ye ar: integer NOT NULL W e ek _O f_Mo nth: integer NULL Lo ca l_Dispo _Day: datetime NULL W e ek _O f_Yea r: integer NOT NULL Q uarter_O f_Yea r: integer NULL Ba ck _Value _Minim um: datetime NULL Month: inte ge r NO T NULL Da y_O f_Ye ar: inte ger NULL Ba ck _Value _Max im um: datetime NULL Month_Nam e : varcha r(20) NOT NULL W e ek _O f_Ye ar: integer NULL Fo rw_Value_Minim um : datetime NULL Yea r: integer NO T NULL Mo nth: integer NULL Fo rw_Value_Max im um : datetime NULL Yea r: integer NULL Julia n_Da te : num ber(7) NULL Reco rd_Sta tus: varcha r(4) NULL CA LENDA R_DA TE_DESCRIPTION Curr_No: num ber(4) NULL Authorise r: va rchar(40) NULL C alenda r_Id: integer NO T NULL (FK) Co_Co de : varcha r(11) NULL Date_Va lue : datetim e NO T NULL (FK) Dept_C ode: va rcha r(4) NULL Language_Id: num ber NO T NULL (FK) Audito r_C ode: va rcha r(16) NULL Audit_Da te_Tim e : varchar(15) NULL Month_Nam e : varcha r(20) NULL Pe riod_End: da te time NULL Co_Ba tch_Status: varcha r(1) NULL Current_Da y: varchar(9) NULL La st_P eriod_End: datetime NULL Bk _Bal_Date_Sta rt: da te time NULL Inputte r: va rchar(40) NULL Date _Tim e: va rcha r(15) NULL O ve rride: va rcha r(500) NULL4

Data Framework – Common Data Model (DF)PDM DiagramConformed Business Dimensions – PDM Diagram PO ST_ REST_ TXN_CODE POSTING_RESTRICT PARTY_LEGALID PARTY_OVRRIDE Posting_Restrict_Id: numberNOT NULL(FK) Party_Id: number NOT NULL (FK) Txn_Code_Mvref: numberNOT NULL Posting_Restrict_Id: numberNOT NULL Party_Id: number NOT NULL (FK) Party_Override_Mvref: numberNOT NULL Party_Legalid_Mvref: numberNOT NULL Override: varchar(35) NULL Txn_Code: varchar(3) NULL Posting_Restr_Code: number(4) NULL Override_Reason: varchar(35) NULL Restriction_Type: varchar(6) NULL Legal_Id: varchar(35) NULL POST_REST_DESC Inputter: varchar(40) NULL Legal_Doc_Name: varchar(35) NULL PARTY_PIVOT_RATE Posting_Restrict_Id: numberNOT NULL(FK) Authoriser: varchar(40) NULL Legal_Iss_Auth: varchar(20) NULL Party_Id: number NOT NULL (FK) Language_Id: numberNOT NULL(FK) Record_Status: varchar(4) NULL Legal_Iss_Date: datetime NULL Party_Pivotrate_Mvref: numberNOT NULL Description: varchar(35) NULL Allow_Txn: varchar(1) NULL Legal_Exp_Date: datetime NULL Alt_Override: varchar(35) NULL Legal_Holder_Name: varchar(100) NULL Customer_Rating: varchar(10) NULL DAO_COMP_RESTR Audit_Date_Time: varchar(15) NULL Legal_Id_Doc_Name: varchar(55) NULL Holdings_Pivot: varchar(15) NULL Officer_Id: number NOT NULL (FK) Auditor_Code: varchar(16) NULL Dao_Comprestr_Mvref: numberNOT NULL Block_Reason_Codes: varchar(35) NULL PARTY_VISTYPE PARTY_INFO_FIELDS Co_Code: varchar(11) NULL Party_Id: number NOT NULL (FK) Restr_To_Comps: varchar(11) NULL Curr_No: number(4) NULL Party_Id: number NOT NULL (FK) Party_Infofld_Mvref: numberNOT NULL Prohibit_Comps: varchar(11) NULL Date_Time: varchar(15) NULL Party_Vis_Mvref: numberNOT NULL Text: varchar(35) NULL Dept_Code: varchar(4) NULL Interests: varchar(35) NULL Dispo_Officer: varchar(4) NULL Vis_Type: varchar(10) NULL Spoken_Language: varchar(10) NULL Override: varchar(500) NULL Vis_Comment: varchar(35) NULL Pastimes: varchar(35) NULL Unblock_Reason_Codes: varchar(30) NULL Vis_Int_Review: varchar(35) NULL Further_Details: varchar(35) NULL Other_Nationality: varchar(9) NULL DIM _ OFFICER DIM_COMPANY PARTY_FVIS_TYPE DIM_ PARTY Party_Id: number NOT NULL (FK) PARTY_ESYSID Officer_Id: number NOT NULL Company_Id: numberNOT NULL Party_Fvis_Mvref: numberNOT NULL Party_Id: numberNOT NULL Party_Id: number NOT NULL (FK) Former_Vis_Type: varchar(10) NULL Party_Esysid_Mvref: numberNOT NULL Valid_Ind: varchar(1) NULL Valid_Ind: varchar(1) NULL Former_Vis_Comment: varchar(255) NULL Valid_Ind: varchar(1) NULL Valid_From: datetime NULL Valid_From: datetime NULL Valid_From: datetime NULL Extern_Sys_Id: varchar(50) NULL Valid_To: datetime NULL Valid_To: datetime NULL CO M PANY_ SPLFIN Valid_To: datetime NULL Extern_Cus_Id: varchar(50) NULL Dept_Acct_Off_Code: varchar(20) NOT NULL Company_Code: varchar(11) NOT NULL Company_Id: numberNOT NULL(FK) Co_Code: varchar(11) NULL Area: varchar(100) NULL Local_Currency: varchar(3) NULL Comp_Splfin_Mvref: numberNOT NULL Customer_Code: number(10) NOT NULL PARTY_PVNAME Name: varchar(100) NULL Co_Code: varchar(11) NOT NULL Spl_Fin_File: varchar(40) NULL Sector: number(4) NOT NULL Party_Id: number NOT NULL (FK) Delivery_Point: varchar(16) NOT NULL Language_Code: varchar(2) NOT NULL Spl_Fin_Com: varchar(11) NULL Account_Officer: number(4) NULL Party_Pvname_Mvref: numberNOT NULL Dept_Level: varchar(2) NULL Description: varchar(36) NULL Spl_Fin_Mne: varchar(3) NULL Dept_Account_Officer: varchar(36) NULL Previous_Name: varchar(35) NULL Description: varchar(35) NULL Mnemonic: varchar(3) NOT NULL Industry: number(4) NULL Change_Date: datetime NULL Dept_Parent: number(4) NULL Record_Status: varchar(4) NULL COMPANY_SPLCUST Industry_Desc: varchar(100) NULL Change_Reason: varchar(35) NULL Mnemonic: varchar(10) NULL Inputter: varchar(40) NULL Company_Id: numberNOT NULL(FK) Target: number(4) NULL Department: varchar(4) NULL Authoriser: varchar(40) NULL Comp_Splcust_Mvref: numberNOT NULL Target_Desc: varchar(100) NULL PARTY_CHTYPE Co_Code: varchar(11) NULL Name_Address: varchar(500) NULL Spl_Cust_File: varchar(40) NULL Nationality: varchar(2) NULL Party_Id: number NOT NULL (FK) Record_Status: varchar(4) NULL Local_Country: varchar(2) NULL Spl_Cust_Com: varchar(11) NULL Customer_Status: number(4) NULL Party_Chtype_Mvref: numberNOT NULL Inputter: varchar(40) NULL Local_Region: varchar(5) NULL Spl_Cust_Mne: varchar(3) NULL Customer_Status_Desc: varchar(100) NULL Com_Type: varchar(35) NULL Authoriser: varchar(40) NULL Last_Year_End: datetime NULL Residence: varchar(2) NULL Prefer_Channel: varchar(20) NULL Telephone_No: varchar(15) NULL Customer_Company: varchar(11) NULL COMPANY_PGM_AUTO Contact_Date: datetime NULL Fax_No: varchar(15) NULL Customer_Mnemonic: number(3) NULL Company_Id: numberNOT NULL(FK) Introducer: varchar(35) NULL PARTY_OTHFREL Telex_No: varchar(8) NULL Currency_Company: varchar(11) NULL Comp_Pgmaid_Mvref: numberNOT NULL Birth_Incorp_Date: datetime NULL Party_Id: number NOT NULL (FK) Curr_No: number(4) NULL Currency_Mnemonic: number(3) NULL Pgm_Auto_Id: varchar(40) NULL Language: number(2) NOT NULL Party_Finrel_Mvref: NUMBER NOT NULL Dept_Code: varchar(4) NULL Nostro_Company: varchar(11) NULL Title: varchar(35) NULL Auditor_Code: varchar(16) NULL Nostro_Mnemonic: number(3) NULL COMPANY_ACCOMPANY Given_Names: varchar(50) NULL Oth_Fin_Rel: NUMBER(3) NULL Audit_Date_Time: varchar(15) NULL Default_Cust_Com: varchar(11) NULL Company_Id: numberNOT NULL(FK) Family_Name: varchar(50) NULL Oth_Fin_Inst: varchar(35) NULL Alt_Dept_Level: varchar(2) NULL Default_Cust_Mne: number(3) NULL Comp_Acccomp_Mvref: numberNOT NULL Gender: varchar(10) NULL Alt_Dept_Parent: number(4) NULL Ftd_Company_Code: varchar(11) NULL Accounting_Company: varchar(11) NULL Date_Of_Birth: datetime NULL PARTY_RESIDENCE_STATUS Accept_Message: varchar(3) NULL Ftd_Mnemonic: varchar(5) NULL Marital_Status: varchar(15) NULL Party_Id: number NOT NULL (FK) Customer_Id: varchar(10) NULL Finan_Finan_Com: varchar(11) NULL COMPANY_NAME No_Of_Dependents: number(2) NULL Party_Resstatus_Mvref: NUMBER NOT NULL Date_Time: varchar(15) NULL Finan_Finan_Mne: number(3) NULL Company_Id: numberNOT NULL(FK) Mnemonic: varchar(10) NOT NULL Residence_Status: varchar(35) NULL Stat_Rep_Area: varchar(30) NULL Language_Id: numberNOT NULL(FK) Record_Status: varchar(4) NULL Residence_Type: varchar(35) NULL DAO_EVENT Stat_Rep_Name: varchar(20) NULL Company_Name: varchar(22) NOT NULL Inputter: varchar(40) NULL Residence_Since: datetime NULL Stat_Rep_Deliv: varchar(10) NULL Authoriser: varchar(40) NULL Residence_Value: DECIMAL(19) NULL Officer_Id: number NOT NULL (FK) Mgmt_Rep_Area: varchar(30) NULL COMPANY_BRCLOSED Delivery_Address: varchar(100) NULL Mortgage_Amt: DECIMAL(19) NULL Dao_Events_Mvref: numberNOT NULL Mgmt_Rep_Name: varchar(20) NULL Company_Id: numberNOT NULL(FK) Customer_No: number(10) NULL Mgmt_Rep_Deliv: varchar(10) NULL Comp_Brclose_Mvref: numberNOT NULL Review_Frequency: varchar(17) NULL PARTY_POSTREST Dept_Acct_Off_Code: varchar(20) NULL Consolidation_Mark: varchar(1) NULL Branch_Closed: datetime NULL Global_Customer: number(10) NULL Party_Id: number NOT NULL (FK) Event: varchar(35) NULL Default_No_Of_Auth: number(1) NULL Customer_Liability: number(10) NULL Party_Postres_Mvref: numberNOT NULL Request_Id: varchar(35) NULL Rate_System: varchar(13) NULL COMPANY_BKNO Curr_No: number(4) NULL Mv_Alert_Res6: NUMBER(55) NULL Default_Finan_Com: varchar(11) NULL Company_Id: numberNOT NULL(FK) Dept_Code: varchar(4) NULL Posting_Restrict: NUMBER(2) NULL Mv_Alert_Res5: NUMBER(55) NULL Default_Finan_Mne: number(3) NULL Comp_Bkno_Mvref: numberNOT NULL Auditor_Code: varchar(16) NULL Mv_Alert_Res4: NUMBER(55) NULL Nostro_Sub_Div: varchar(4) NULL Acc_Bkno_Prefix: NUMBER(8) NULL Audit_Date_Time: varchar(15) NULL PARTY_TEXT Mv_Alert_Res3: NUMBER(55) NULL Inter_Com_Category: varchar(6) NULL Sector_Name: varchar(25) NULL Party_Id: number NOT NULL (FK) Mv_Alert_Res2: NUMBER(55) NULL Local_Process_Name: varchar(8) NULL COMPANY_APPLICATION Dispo_Officer: number(4) NULL Language_Id: numberNOT NULL(FK) Mv_Alert_Res1: NUMBER(55) NULL Default_Rate_Allow: varchar(6) NULL Company_Id: numberNOT NULL(FK) Confid_Txt: varchar(3) NULL Fcy_Conv_Toler_Min: DECIMAL(6) NULL Comp_App_Mvref: numberNOT NULL Dispo_Exempt: varchar(3) NULL Town_Country: varchar(60) NULL DAO_EVENT_FIELD Fcy_Conv_Toler_Max: DECIMAL(6) NULL Applications: varchar(6) NULL Issue_Cheques: varchar(3) NULL Post_Code: varchar(35) NULL Charge_Calculation: varchar(1) NULL Cls_Cparty: varchar(3) NULL Country: varchar(60) NULL Officer_Id: number NOT NULL (FK) Inactivity_Months: number(4) NULL PARTY_REF_DATE Fx_Comm_Group_Id: number(3) NULL Short_Name: varchar(35) NOT NULL Dao_Event_Mvref: numberNOT NULL(FK) Sub_Division_Code: number(4) NULL Party_Id: number NOT NULL (FK) Residence_Region: varchar(9) NULL Name_1: varchar(35) NOT NULL Dao_Event_Svref: numberNOT NULL Swift_Add_Com_Ref: varchar(6) NULL Party_Refdate_Mvref: numberNOT NULL Company_Book: varchar(11) NULL Name_2: varchar(35) NULL Dc_Tolerance_Rate: DECIMAL(6) NULL Ref_Data_Item: varchar(35) NULL Asset_Class: varchar(3) NULL Street: varchar(60) NULL Field: varchar(25) NULL Dc_Max_Round_Amt: DECIMAL(6) NULL Ref_Data_Value: varchar(35) NULL No_Update_Crm: varchar(3) NULL Address: varchar(500) NULL Operand: varchar(35) NULL Acct_Checkdig_Type: varchar(25) NULL Net_Monthly_In: decimal(19) NULL Value: varchar(35) NULL Account_Mask: varchar(21) NULL PARTY_PRO_TYPE Net_Monthly_Out: decimal(19) NULL PARTY_OTHOFFICER Curr_No: number(4) NULL Party_Id: number NOT NULL (FK) Customer_Since: number(11) NULL Party_Id: number NOT NULL (FK) Dept_Code: varchar(4) NULL Party_Protyp_Mvref: numberNOT NULL Customer_Type: varchar(35) NULL Party_Othoff_Mvref: numberNOT NULL Auditor_Code: varchar(16) NULL Cr_Profile_Type: varchar(35) NULL Date_Last_Verified: varchar(15) NULL Audit_Date_Time: varchar(15) NULL Cr_Profile: varchar(35) NULL Domicile: varchar(9) NULL Other_Officer: number(4) NULL Book: varchar(3) NULL Calc_Risk_Class: varchar(10) NULL Relative_Time: varchar(6) NULL PARTY_CR_PROFILE Manual_Risk_Class: varchar(10) NULL PARTY_CONTACT Separate_Eod: varchar(3) NULL Party_Id: number NOT NULL (FK) Last_Kyc_Review_Date: datetime NULL Party_Id: number NOT NULL (FK) Cons_Key_Co: varchar(11) NULL Party_Crprofile_Mvref: numberNOT NULL Auto_Next_Kyc_Review_Date: datetime NULL Party_Contact_Mvref: numberNOT NULL Company_Group: number(3) NULL Cr_User_Profile_Type: varchar(35) NULL Manual_Next_Kyc_Review_Date: datetime NULL Official_Holiday: varchar(4) NULL Cr_Calc_Profile: varchar(35) NULL Last_Suit_Review_Date: datetime NULL Phone_1: varchar(17) NULL Branch_Holiday: varchar(4) NULL Cr_User_Profile: varchar(35) NULL Auto_Next_Suit_Review_Date: datetime NULL Sms_1: varchar(17) NULL Batch_Holiday: varchar(4) NULL Cr_Calc_Reset_Date: datetime NULL Manual_Next_Suit_Review_Date: datetime NULL Email_1: varchar(50) NULL Financial_Com: varchar(11) NULL Kyc_Relationship: varchar(35) NULL Addr_Location: varchar(10) NULL Financial_Mne: number(3) NULL Secure_Message: varchar(3) NULL Def_Rating_Agency: varchar(10) NULL Aml_Check: varchar(4) NULL PARTY_NW_ALT_ID L_B2_Rating_Agy: varchar(10) NULL Aml_Result: varchar(14) NULL Party_Id: number NOT NULL (FK) Financial_Year_End: varchar(13) NULL Last_Aml_Result_Date: datetime NULL Party_Nwaltid_Mvref: NUMBER NOT NULL Cust_Retention: varchar(10) NULL Kyc_Complete: varchar(4) NULL Alt_Cus_Id: varchar(35) NULL Prospect_Allowed: varchar(3) NULL Internet_Banking_Service: varchar(4) NULL Social_Ntw_Ids: varchar(70) NULL Company_Schema: varchar(3) NULL Mobile_Banking_Service: varchar(4) NULL Iban_Bank_Id: varchar(35) NULL Allow_Bulk_Process: varchar(6) NULL PARTY_ LCREF Iban_Branch_Id: varchar(35) NULL Report_Template: varchar(35) NULL Party_Id: number NOT NULL (FK) Time_Zone: varchar(50) NULL Merged_To: varchar(35) NULL Party_Lcref_Mvref: numberNOT NULL Parent_Company: varchar(11) NULL Merged_Status: varchar(35) NULL Cu_Eff_Date: varchar(20) NULL Date_Time: varchar(15) NULL Person_Entity_Id: varchar(10) NULL Creditor_Id: varchar(20) NULL Reg_Country: varchar(35) NULL Segment: varchar(20) NULL Date_Time: varchar(15) NULL Account_Officer_Desc: varchar(100) NULL PARTY_SEC_DETAIL Party_Id: number NOT NULL (FK) PARTY_MANDATE Party_Sec_Mvref: numberNOT NULL Party_Id: number NOT NULL (FK) Off_Phone: varchar(17) NULL Party_Mandate_Mvref: numberNOT NULL Tax_Id: varchar(35) NULL Fax_1: varchar(17) NULL Mandate_Appl: varchar(35) NULL Mandate_Reg: varchar(35) NULL PARTY_EMP_STATUS Mandate_Record: varchar(35) NULL Party_Id: number NOT NULL (FK) Emp_Stat_Mvref: NUMBER NOT NULL PARTY_RISK_TYPE Employment_Status: varchar(35) NULL Occupation: varchar(35) NULL Party_Id: number NOT NULL (FK) Employers_Name: varchar(35) NULL Party_Ristyp_Mvref: NUMBER NOT NULL Employers_Buss: varchar(35) NULL Employment_Start: datetime NULL Risk_Asset_Type: varchar(7) NULL Customer_Currency: varchar(3) NULL Risk_Level: NUMBER(2) NULL Salary: decimal(19) NULL Risk_Tolerance: NUMBER(2) NULL Annual_Bonus: decimal(19) NULL Risk_From_Date: datetime NULL Salary_Date_Freq: varchar(17) NULL Job_Title: varchar(10) NULL Employers_Add: varchar(500) NULL5