SIB Projects

Dear Vijayakumar,

Approved, Pls proceed.

Dear Siva,

As discussed , Please fins the approved attachment of new SIB application required documents.

Greetings,

Greetings,

Request you to inform IT team for create the following sub-domains and point them to UAT Server.

1. sibuat.nocpl.in
2. androidsibuat.nocpl.in
3. rosibuat.nocpl.in
4. aosibuat.nocpl.in
5. bmsibuat.nocpl.in
6. sibapiuat.nocpl.in

Dear Shiva,

As per your request subdomain has created done confirmed by IT Team.

Greetings,

Team, we are releasing sourcing Pilot testing App for SIB BC.

SOURCING:

http://cimssoft.in/APKs/SIB/SIB-CB-1-0-0.apk

Kindly test few groups and confirm us before field deployment.

Dear Shiva,

We have tested using few cases, please find the below observation from bank

Customer :
1. Transaction ID and MCO Remark fields are missing in the shared sample file
2. MANDATORY FIELD - REFERENCE CODE CANNOT BE NULL
3. MANDATORY FIELD - PERMANENT ADDRESS LINE1 CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2
4. MANDATORY FIELD - PERMANENT ADDRESS VILLAGE CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2
5. MANDATORY FIELD - PERMANENT ADDRESS STATEUT CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2
6. MANDATORY FIELD - PERMANENT ADDRESS DISTRICT CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2
7. MANDATORY FIELD - PERMANENT ADDRESS PINCODE CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2
8. MANDATORY FIELD - PERMANENT ADDRESS LANDMARK CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2
9. MANDATORY FIELD - CUSTOMER'S NATIONALITY CANNOT BE NULL
10. MANDATORY FIELD - RELIGION CANNOT BE NULL
11. MANDATORY FIELD - CUSTOMER'S OCCUPATION CANNOT BE NULL
12. MANDATORY FIELD - INCOME FROM HIGH RISK COUNTRY CANNOT BE NULL
13. MANDATORY FIELD - CUSTOMER'S CATEGORY CANNOT BE NULL
14. MANDATORY FIELD - LOAN APPLICATION SERIAL NUMBER CANNOT BE NULL
15. MANDATORY FIELD - LOAN APPLIED AMOUNT CANNOT BE NULL
16. MANDATORY FIELD - FILE APPLICATION DATE CANNOT BE NULL
17. MANDATORY FIELD - LOAN TYPE CANNOT BE NULL
18. MANDATORY FIELD - CARD ISSUANCE FLAG CANNOT BE NULL
19. MANDATORY FIELD - BC BRANCH CODE CANNOT BE NULL
20. LA-IS-NOMINEE-MINOR - Is Mandatory
21. LA NOMINEE NAME - Is Mandatory
22. LA-NOMINEE-RELATION Is Mandatory
23. LA-NOMINEE-ADD : Is Mandatory
24. LA-NOMINEE-DOB -Is Mandatory
25. MANDATORY FIELD CANT BE NULL

Center :
1. SERVICINGAGENT should be mandatory
2. MEETING TIME

Group :

1. DISTANCE FROM BRANCH SHOULD BE NUMERIC (Passed value is 0.5, it should be either 1 or 0)
2. MANDATORY FIELD - BRANCHCODE CANNOT BE NULL (Value can be same as center)
3. MANDATORY FIELD - OPERATINGREGIONCODE CANNOT BE NULL (Value can be same as center)
4. MANDATORY FIELD -MEETING TIME CANNOT BE NULL

Greetings,

Team, kindly find the Remarks with respect to each errors, kindly share the Updated Master Document if there is any which certain fields are made mandatory now.

Also kindly update on few queries which we have written in Remarks.

Errors Remarks
Customer File
1. Transaction ID and MCO Remark fields are missing in the shared sample file - No Such Field name exist, kindly update which field you are referring with.
2. MANDATORY FIELD - REFERENCE CODE CANNOT BE NULL - Fixed
3. MANDATORY FIELD - PERMANENT ADDRESS LINE1 CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2-Fixed
4. MANDATORY FIELD - PERMANENT ADDRESS VILLAGE CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2-Fixed
5. MANDATORY FIELD - PERMANENT ADDRESS STATEUT CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2-Fixed
6. MANDATORY FIELD - PERMANENT ADDRESS DISTRICT CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2-Fixed
7. MANDATORY FIELD - PERMANENT ADDRESS PINCODE CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2-Fixed
8. MANDATORY FIELD - PERMANENT ADDRESS LANDMARK CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2-Fixed
9. MANDATORY FIELD - CUSTOMER'S NATIONALITY CANNOT BE NULL - Not Mandatory as per Master Document
10. MANDATORY FIELD - RELIGION CANNOT BE NULL-Not Mandatory as per Master Document
11. MANDATORY FIELD - CUSTOMER'S OCCUPATION CANNOT BE NULL-Not Mandatory as per Master Document
12. MANDATORY FIELD - INCOME FROM HIGH RISK COUNTRY CANNOT BE NULL-Not Mandatory as per Master Document
13. MANDATORY FIELD - CUSTOMER'S CATEGORY CANNOT BE NULL-Not Mandatory as per Master Document
14. MANDATORY FIELD - LOAN APPLICATION SERIAL NUMBER CANNOT BE NULL-Not Mandatory as per Master Document
15. MANDATORY FIELD - LOAN APPLIED AMOUNT CANNOT BE NULL-Not Mandatory as per Master Document
16. MANDATORY FIELD - FILE APPLICATION DATE CANNOT BE NULL-No Such Field name exist, kindly update which field you are referring with.
17. MANDATORY FIELD - LOAN TYPE CANNOT BE NULL-Not Mandatory as per Master Document
18. MANDATORY FIELD - CARD ISSUANCE FLAG CANNOT BE NULL-Not Mandatory as per Master Document
19. MANDATORY FIELD - BC BRANCH CODE CANNOT BE NULL-Not Mandatory as per Master Document
20. LA-IS-NOMINEE-MINOR - Is Mandatory-Not Mandatory as per Master Document, NOCPL not Collecting Minor as Nominee
21. LA NOMINEE NAME - Is Mandatory-Not Mandatory as per Master Document
22. LA-NOMINEE-RELATION Is Mandatory-Not Mandatory as per Master Document
23. LA-NOMINEE-ADD : Is Mandatory-Not Mandatory as per Master Document
24. LA-NOMINEE-DOB -Is Mandatory-Not Mandatory as per Master Document
25. MANDATORY FIELD CANT BE NULL-No Such Field name exist, kindly update which field you are referring with.
Center
1. SERVICINGAGENT should be mandatory-Fixed
2. MEETING TIME Need Clarifications, since NOCPL will decide Meeting time during Disbursement only.
Group
1. DISTANCE FROM BRANCH SHOULD BE NUMERIC (Passed value is 0.5, it should be either 1 or 0)-Fixed
2. MANDATORY FIELD - BRANCHCODE CANNOT BE NULL (Value can be same as center)-Not Mandatory as per Master Document
3. MANDATORY FIELD - OPERATINGREGIONCODE CANNOT BE NULL (Value can be same as center)-Not Mandatory as per Master Document
4. MANDATORY FIELD -MEETING TIME CANNOT BE NULL Need Clarifications, since NOCPL will decide Meeting time during Disbursement only.

Greetings,

Team, we are releasing updated sourcing for Pilot testing App of SIB BC.

SOURCING:

http://cimssoft.in/APKs/SIB/SIB-CB-1.0.1.apk

Kindly test few groups and confirm us before field deployment.

Dear Shiva,

We have tested using few cases, please find the below some requirement from bank

Errors Remarks
Customer File
1. Transaction ID and MCO Remark fields are missing in the shared sample file- attached the new customer sample file
2. MANDATORY FIELD - REFERENCE CODE CANNOT BE NULL Fixed
3. MANDATORY FIELD - PERMANENT ADDRESS LINE1 CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2 Fixed
4. MANDATORY FIELD - PERMANENT ADDRESS VILLAGE CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2 Fixed
5. MANDATORY FIELD - PERMANENT ADDRESS STATEUT CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2 Fixed
6. MANDATORY FIELD - PERMANENT ADDRESS DISTRICT CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2 Fixed
7. MANDATORY FIELD - PERMANENT ADDRESS PINCODE CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2 Fixed
8. MANDATORY FIELD - PERMANENT ADDRESS LANDMARK CANNOT BE NULL WHEN IS-SAME-AS-CUR-ADD IS 2 Fixed
9. MANDATORY FIELD - CUSTOMER'S NATIONALITY CANNOT BE NULL Fixed from Atyati/SIB END
10. MANDATORY FIELD - RELIGION CANNOT BE NULL It should be mandatory updated list is attached
11. MANDATORY FIELD - CUSTOMER'S OCCUPATION CANNOT BE NULL Fixed from Atyati/SIB END
12. MANDATORY FIELD - INCOME FROM HIGH RISK COUNTRY CANNOT BE NULL Fixed from Atyati/SIB END
13. MANDATORY FIELD - CUSTOMER'S CATEGORY CANNOT BE NULL Fixed from Atyati/SIB END
14. MANDATORY FIELD - LOAN APPLICATION SERIAL NUMBER CANNOT BE NULL Fixed from Atyati/SIB END
15. MANDATORY FIELD - LOAN APPLIED AMOUNT CANNOT BE NULL Fixed from Atyati/SIB END
16. MANDATORY FIELD - FILE APPLICATION DATE CANNOT BE NULL Fixed from Atyati/SIB END
17. MANDATORY FIELD - LOAN TYPE CANNOT BE NULL Fixed from Atyati/SIB END
18. MANDATORY FIELD - CARD ISSUANCE FLAG CANNOT BE NULL Fixed from Atyati/SIB END
19. MANDATORY FIELD - BC BRANCH CODE CANNOT BE NULL It should be mandatory , Updated fields list is attached
20. LA-IS-NOMINEE-MINOR - Is Mandatory It should be mandatory , Updated fields list is attached
21. LA NOMINEE NAME - Is Mandatory It should be mandatory , Updated fields list is attached
22. LA-NOMINEE-RELATION Is Mandatory It should be mandatory , Updated fields list is attached
23. LA-NOMINEE-ADD : Is Mandatory It should be mandatory , Updated fields list is attached
24. LA-NOMINEE-DOB -Is Mandatory It should be mandatory , Updated fields list is attached
25. MANDATORY FIELD CANT BE NULL Transaction details field should be mandatory
Center
1. SERVICINGAGENT should be mandatory Fixed
2. MEETING TIME Need Clarifications, since NOCPL will decide Meeting time during Disbursement only.
Group
1. DISTANCE FROM BRANCH SHOULD BE NUMERIC (Passed value is 0.5, it should be either 1 or 0) Fixed
2. MANDATORY FIELD - BRANCHCODE CANNOT BE NULL (Value can be same as center) It should be mandatory and value should be same as mapped.
3. MANDATORY FIELD - OPERATINGREGIONCODE CANNOT BE NULL (Value can be same as center) It should be mandatory and value should be same as mapped.
4. MANDATORY FIELD -MEETING TIME CANNOT BE NULL Need Clarifications, since NOCPL will decide Meeting time during Disbursement only.

Greetings,

As per your revised requirement Herewith we have enclosed updated LAF & LOS documents for verification purpose, kindly check & let us know whether there is any correction or not. if there is no correction, kindly do the next level process.

Dear Shiva,

Below are the observationsfrom Bank.

Center
1. File Sheet name should be “Sheet1”
2. Servicing Agent should be the user created/mapped to the respective branch
3. Geo Classification value should be below mentioned masters
R Rural:10,000-1,00,000
SU Semi Urban:10,000-1,00,000
U Urban:10,000-1,60,000
M Metro:<=1,60,000

Group

1. File Sheet name should be “Sheet1”

Customer

1. File Sheet name should be “Sheet1”
2. REFERENCE CODE SHOULD BE 18 CHARACTERS ONLY
3. BC Branch code should be the value shared in the GEO master excel
4. INCORRECT LOAN NOM RELATION CODE and It should be below value
K23 Neph
K01 Father
K03 Mother
K07 Brother
K02 Husband
K06 Wife
K04 Son
K05 Daughter
K12 Son-in-law
K10 Daughter-in-law
K08 Mother-in-law
K09 Father-in-law
K20 Niece
K14 Other
K11 Sister
K13 Brother-In-law

Loan

1. File Sheet name should be “Sheet1”
2. Bar code should be mandatory and unique for each loan
3. COLLECTOR should be mapped branch user
4. FREQUENCY value should be 4 for the created product
5. ORIGINATOR should be mapped branch user

Greetings,

Kindly find the Status Update and Queries for the Observations.

Center
1. File Sheet name should be “Sheet1” - Fixed
2. Servicing Agent should be the user created/mapped to the respective branch - Required Clarity
3. Geo Classification value should be below mentioned masters - Fixed
R Rural:10,000-1,00,000
SU Semi Urban:10,000-1,00,000
U Urban:10,000-1,60,000
M Metro:<=1,60,000
Group
1. File Sheet name should be “Sheet1” - Fixed
Customer
1. File Sheet name should be “Sheet1” - Fixed
2. REFERENCE CODE SHOULD BE 18 CHARACTERS ONLY - Fixed
3. BC Branch code should be the value shared in the GEO master excel - Fixed
4. INCORRECT LOAN NOM RELATION CODE and It should be below value - Fixed
K23 Neph
K01 Father
K03 Mother
K07 Brother
K02 Husband
K06 Wife
K04 Son
K05 Daughter
K12 Son-in-law
K10 Daughter-in-law
K08 Mother-in-law
K09 Father-in-law
K20 Niece
K14 Other
K11 Sister
K13 Brother-In-law
Loan
1. File Sheet name should be “Sheet1” - Fixed
2. Bar code should be mandatory and unique for each loan - Fixed
3. COLLECTOR should be mapped branch user- Required Gufa Mapped RO Details
4. FREQUENCY value should be 4 for the created product - Fixed
5. ORIGINATOR should be mapped branch user- Required Gufa Mapped RO Details

APK:

SOURCING:

http://cimssoft.in/APKs/SIB/SIBCB1.3.2.apk

Kindly test few groups and confirm us before field deployment.

Dear Shiva,

Please find the response shared by Atyati on the file format shared

Center

1. Pass the mapped agent ID
Response:- pass the Sample value configured in Ganaseva – SIBL13782

Loan

1. NOT A REGISTERED ORIGINATOR  Pass the Mapped user
Response:- pass the Sample value configured in Ganaseva – SIBL13782

2. BARCODE MUST BE NUMERIC ONLY and BARCODE MUST BE MIN OF 1 DIGIT AND MAX OF 12 DIGITS
Response:- Any numeric combination to be passed

Greetings,

The above requirements has updated done. Please check and confirm the same.

Center

1. Pass the mapped agent ID
Response:- pass the Sample value configured in Ganaseva – SIBL13782 - Updated

Loan

1. NOT A REGISTERED ORIGINATOR  Pass the Mapped user
Response:- pass the Sample value configured in Ganaseva – SIBL13782 - Updated

2. BARCODE MUST BE NUMERIC ONLY and BARCODE MUST BE MIN OF 1 DIGIT AND MAX OF 12 DIGITS
Response:- Any numeric combination to be passed - Updated

Dear Shiva,

Please find below observation from bank

The update from Atyati team on the files submitted

Same can be uploaded and photo name should be corrected as below.

NomAadhar_EXternalcustomerID.jpg
ApplPhoto_ExternalcustomerID.jpg
ApplConsent_ExternalcustomerID.jpg
SBAccount_ExternalcustomerID.jpg
Form60_ExternalcustomerID.jpg
PAN_externalcustomerID.jpg
Signature_ExternalcustomerID.jpg
VoterID_ExternalcustomerID.jpg

Ex :

NomAadhar_ CIMS18UP0110558.jpg
ApplPhoto_ CIMS18UP0110558.jpg
ApplConsent_ CIMS18UP0110558.jpg
SBAccount_ CIMS18UP0110558.jpg
Form60_ CIMS18UP0110558.jpg
PAN_ CIMS18UP0110558.jpg
Signature_ CIMS18UP0110558.jpg
VoterID_ CIMS18UP0110558.jpg

Greetings

New requirements has done,kindly check & confirm ASAP

Note :As per your confirmation we have removed Aadhar & Voter Id back copy.

Dear Shiva,

New modification request from bank

Center and Group files are correct. In customer file there is one modification is required

Customer - ANNUAL HOUSEHOLDING INCOME DOES NOT FALL IN THE RANGE SPECIED IN CONSODLITAED MASTER FOR THE MAPPED CENTER

For the above error, in Center we have provided GEO classification is R which means customer annualholding income should be between 1000 to 100000.

So requesting you to change the Annual householding income to less than 1 lakh and share the updated file.

Greetings,

The above modification has done.

Customer - ANNUAL HOUSEHOLDING INCOME DOES NOT FALL IN THE RANGE SPECIED IN CONSODLITAED MASTER FOR THE MAPPED CENTER - Updated

Dear Shiva,

As we discussed The following three requirement are recently received from SIB, kindly check & we have to develop the requirement.

1) Even though the health status of the customer in LMS is not mandatory field( (BT column), kindly make arrangements to capture the data while entering the customer details in LOS for compliance purpose.(CU FILE ENCLOSED)

2 ) We need to Splitting the LOS file in 2 stages

. NOCPL will work on the suggested new Process by Splitting the LOS file in 2 stages.
. Stage 1 : CU/GM/CM + Documents will be shared during the LOS submission.
. SIB team will Verify and give Confirmation based on the Customer Approval/Rejection through MIS.
. Stage 2 : NOCPL will share the Loan File (LN) to SIB team for the Approved cases only.

Insurance Amount has to be available in the Loan Sanction(LM) file passing from NOCPL to SIB.
New Column called insurance amount is added at the end of the file LM File – Column BS (Insurance_amt)
MIS FORMAT: Enclosed

3)As per new requirement we need to deduct the insurance premium amount of borrower & Co borrower in LD file.
previously we have deduct the processing fee + GST from sanction amount, now additionally we have to deduct the amount of insurance premium.
Sanction amount -Processing fee-GST-insurance premium amount = Net disbursement amount.
LD FILE ENCLOSED

S.No. Loan Amount in Rs. Tenure Premium For Member Premium For Guarantors Total Premium Round Value
1 15000 24 Months 209.1675 209.1675 418.335 419
2 18000 24 Months 251.001 251.001 502.002 503
3 21000 24 Months 292.8345 292.8345 585.669 586
4 24000 24 Months 334.668 334.668 669.336 670
5 27000 24 Months 376.5015 376.5015 753.003 754
6 30000 24 Months 418.335 418.335 836.67 837
7 33000 24 Months 460.1685 460.1685 920.337 921
8 36000 24 Months 502.002 502.002 1004.004 1005
9 39000 24 Months 543.8355 543.8355 1087.671 1088
10 42000 24 Months 585.669 585.669 1171.338 1172
11 45000 24 Months 627.5025 627.5025 1255.005 1256

Greetings,

As per banker new requirement has done and find the attached format

APK:

SOURCING:

http://cimssoft.in/APKs/SIB/SIB_CB_1-3-4.apk

Web Portal : sibuat.nocpl.in

Dear Shiva,

We checked it our end , its working . Will check with bank team and update you same.

Once bank confirmation we go for live .