This topic provides information on Enumeration Configuration.

• Configuration for local enumeration:

  Following table contain origination related database entries in DIGX_FW_CONFIG_ALL_B, DIGX_FW_CONFIG_ALL_Oand DIGX_FW_ENUM_REPRESENTATIONS

  For more information on fields, refer to the field description table.

  Table 10-1 Origination related database entries

  Enumeration <PROP_ID>	Type of Enumeration < PROP_VALUE >	Enum Key <ENUM_FQN>
  OR_TD_MATURITY_INSTRUCTION	LOCAL_CLOSE_ENUM	fetchTDMaturityInstruction
  CHEQUEBOOKLEAVES	LOCAL_OPEN_ENUM	getChequeBookLeaves
  COUNTRY	LOCAL_OPEN_ENUM	getCountry
  ISDCODE	LOCAL_OPEN_ENUM	getISDCode
  OR_APPLICANT_RELATIONS	LOCAL_OPEN_ENUM	fetchApplicantRelations
  OR_DIMENSION_MEASURE_TYPE	LOCAL_OPEN_ENUM	fetchDimensionMeasureType
  OR_DISBURSEMENT_MODE	LOCAL_OPEN_ENUM	fetchDisbursementMode
  OR_EDUCATION_LOAN_ADMISSSION_STATUS	LOCAL_OPEN_ENUM	fetchEducationLoanAdmissionStatus
  OR_EDUCATION_LOAN_COURSE_TYPES	LOCAL_OPEN_ENUM	fetchEducationLoanCourseTypes
  OR_HOME_LOAN_PURPOSE	LOCAL_OPEN_ENUM	fetchHomeLoanPurpose
  OR_INSIDER_PROFILE	LOCAL_OPEN_ENUM	fetchInsiderProfile
  OR_PROPERTY_STATUS	LOCAL_OPEN_ENUM	fetchPropertyStatus
  OR_REPAYMENT_MODE	LOCAL_OPEN_ENUM	fetchRepaymentMode
  OR_STAKEHOLDER_TYPES	LOCAL_OPEN_ENUM	fetchStakeHolderTypes
  OR_STATE	LOCAL_OPEN_ENUM	getUsState
  OR_VEHICLE_CATEGORY	LOCAL_OPEN_ENUM	fetchVehicleCategory
  RELATIONSHIP_SERVING_OFFICER	LOCAL_OPEN_ENUM	getRelationShipServingOfficer
  EMPLOYMENTTYPE	REMOTE_OPEN_ENUM	getEmploymentType
  OR_APPLICANT_DOCUMENT_TYPE	REMOTE_OPEN_ENUM	fetchApplicantDocumentType
  OR_APPLICANT_LOCATION	REMOTE_OPEN_ENUM	fetchApplicantLocation
  OR_COUNTRY_OF_REGISTRATION	REMOTE_OPEN_ENUM	fetchCountryOfRegistration
  OR_CUSTOMER_CATEGORY	REMOTE_OPEN_ENUM	fetchCustomerCategory
  OR_EMPLOYER_NAME	REMOTE_OPEN_ENUM	getEmployerNames
  OR_INSIDER_PROFILE_ROLE	REMOTE_OPEN_ENUM	fetchInsiderProfileRole
  OR_MODE_OF_OPERATION	REMOTE_OPEN_ENUM	fetchModeOfOperation
  OR_PREFERRED_CURRENCY	REMOTE_OPEN_ENUM	fetchPreferredCurrency
  OR_PROFESSIONS	REMOTE_OPEN_ENUM	fetchProfessions
  OR_STATES	REMOTE_OPEN_ENUM	fetchStates
  OR_SUFFIX	REMOTE_OPEN_ENUM	fetchSuffix
  SERVICE_BRANCH	REMOTE_OPEN_ENUM	getServiceBranch
  FINANCIAL_ASSETS_TYPE	REMOTE_OPEN_ENUM	financialAssetsTypes
  FINANCIAL_EXPENSE_FREQUENCY	REMOTE_OPEN_ENUM	getExpenseFrequency
  FINANCIAL_EXPENSE_TYPE	REMOTE_OPEN_ENUM	getFinancialExpense
  FINANCIAL_INCOME_FREQUENCY	REMOTE_OPEN_ENUM	getIncomeFrequency
  FINANCIAL_INCOME_TYPE	REMOTE_OPEN_ENUM	getFinancialIncome
  FINANCIAL_LIABILITY_FREQUENCY	REMOTE_OPEN_ENUM	getLiabilityFrequency
  FINANCIAL_LIABILITY_TYPE	REMOTE_OPEN_ENUM	getFinancialLiability
  GENDER	REMOTE_OPEN_ENUM	getGender
  IDENTIFICATIONTYPES	REMOTE_OPEN_ENUM	GetTaxType
  MARITALSTATUS	REMOTE_OPEN_ENUM	getMaritalStatus
  OR_CITIZENSHIP_BY	REMOTE_OPEN_ENUM	fetchCitizenshipBy
  OR_EMPLOYMENT_CATEGORY	REMOTE_OPEN_ENUM	fetchEmploymentCategory
  OR_ORGANIZATION_CATEGORY	REMOTE_OPEN_ENUM	fetchOrganizationCategory
  OR_ORGANIZATION_OPERATIONS	REMOTE_OPEN_ENUM	fetchOrganizationOperations
  OR_RANK	REMOTE_OPEN_ENUM	fetchRank
  OR_DEPENDENT_TYPE	REMOTE_OPEN_ENUM	fetchDependentType
  OR_CONTACT_SUBTYPE	REMOTE_OPEN_ENUM	fetchContactSubType

• Local Enum Configuration

  Refer to the following SQL script for store enum locally to fetch LOV from the database.

  Insert into DIGX_FW_CONFIG_ALL_B (PROP_ID, PREFERENCE_NAME, PROP_VALUE, DETERMINANT_VALUE, CREATED_BY, 
  CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE) values ('GENDER','EnumerationConfig','LOCAL_OPEN_ENUM',
  'OBDX_BU',null,sysdate,null,null)

  For local enumeration, the respective data is stored in the below table. Refer to column 3 for the ENUM_FQN.

  select * from DIGX_FW_ENUM_REPRESENTATIONS where ENUM_FQN in (‘<Enum Key>’)

• Remote Enum Configuration

  For remote enumeration refer following SQL script.

  The following is an example of an override database entry for existing records in DIGX_FW_CONFIG_ALL_B table.

  Insert into DIGX_FW_CONFIG_ALL_O (PROP_ID, PREFERENCE_NAME,
          PROP_VALUE, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
          LAST_UPDATED_DATE) 
  values ('OR_STATES','EnumerationConfig','REMOTE_OPEN_ENUM','OBDX_BU',null,sysdate,null,null)

  Here OR_STATES fetch the LOV from integrated Mid office enumeration maintenance route via OBRH, so below 2 database sql scripts are required.

  Insert into DIGX_FW_CONFIG_ALL_O (PROP_ID, PREFERENCE_NAME,
          PROP_VALUE, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE) 
  values ('OBDX_BU.com.ofss.digx.extxface.common.adapter.IEnumerationAdapter.fetchStates',
  'ExtxfaceAdapterPreference','com.ofss.digx.extxface.enumeration.impl.EnumerationAdapter',
  '01','ofssuser',sysdate,'ofssuser',sysdate);

  Insert into DIGX_FW_CONFIG_ALL_O (PROP_ID, PREFERENCE_NAME,
          PROP_VALUE, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE) 
  values ('ENUMERATION_LIST_FETCHSTATES','ExtXfaceConfig','com.ofss.digx.extxface.impl.
  endpoint.OBRHEndPoint','OBDX_BU','ofssuser',sysdate,'ofssuser',sysdate);

  Note:

  To convert a remote enumeration to a local one, update the PROP_VALUE from REMOTE_OPEN_ENUM to LOCAL_OPEN_ENUM and make the corresponding entry in the DIGX_FW_ENUM_REPRESENTATIONS table.