10 Enumeration Configuration
This topic provides information on Enumeration Configuration.
- Configuration for local enumeration:
Following table contain origination related database entries in DIGX_CFG_CONFIG_ALL_B and 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 OR_RANK REMOTE_OPEN_ENUM getRank OR_REJECT_REASONS REMOTE_OPEN_ENUM fetchRejectReasons OR_SERVICE_MEMBER_RELATIONSHIP REMOTE_OPEN_ENUM fetchServiceMemberRelationship - Local Enum Configuration
Refer to the following SQL script for store enum locally to fetch LOV from the database.
Insert into DIGX_CFG_CONFIG_ALL_B (PROP_ID,PROFILE,PROP_VALUE,ENTITY_SPECIFIC,EDITABLE,MANDATORY_OVERRIDE,PROPERTY_GROUP,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATED_DATE,OBJECT_VERSION_NUMBER,MODULE,IS_ENUMERATED,SEQUENCE,VALIDATION,OBJECT_STATUS) values ('EnumerationConfig.GENDER','DEV','LOCAL_OPEN_ENUM','N','Y','N',null,'SYSTEM',sysdate,'sys',sysdate,1,'origination','N',-1,'.*',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_CFG_CONFIG_ALL_B table.
Insert into DIGX_CFG_CONFIG_ALL_B (PROP_ID,PROFILE,PROP_VALUE,ENTITY_SPECIFIC,EDITABLE,MANDATORY_OVERRIDE,PROPERTY_GROUP,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATED_DATE,OBJECT_VERSION_NUMBER,MODULE,IS_ENUMERATED,SEQUENCE,VALIDATION) values ('EnumerationConfig.OR_STATES','DEV','REMOTE_OPEN_ENUM','N','Y','Y',null,'SYSTEM',sysdate,'sys',sysdate,1,'origination','N',-1,'.*');Here OR_STATES fetch the LOV from integrated Mid office enumeration maintenance route via OBRH.
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.