A Annexure
Data Transfer from OBCL to OFSAA
For details on data transfer from OBCL to OFSAA, refer the below table.
- Source System - OBCL
- Target System - OFSAA
Table A-1 OBCL OFSAA Data Transfer Details
Data Transferred | Source System Module | OBCL Staging Table Name | Extraction Package Name | Target System Table Name | Extraction Routine | Data Included in the Extraction |
---|---|---|---|---|---|---|
Transactions on loan contracts | OL | AATB_STG_OL_LOAN_CONTRACT_TXNS | AAPKS_EXTRACT_OL_CONTRACT_TXNS | Stg_Loan_Contract_Txns | Daily | New Data |
Loan contract details | OL | AATB_STG_OL_LOAN_CONTRACTS | AAPKS_EXTRACT_OL_LN_CONTRACTS | Stg_Loan_Contracts | Daily | Complete Data |
Repayment schedule of loan contracts | OL | AATB_STG_OL_PAYMENT_SCHEDULE | AAPKS_EXTRACT_OL_PYMNT_SCH | Stg_Payment_Schedule | Daily | Complete Data |
Loan Write-off details | OL | AATB_STG_OL_LOAN_WRITEOFF | AAPKS_EXTRACT_OL_LN_WRITEOFF | Stg_Acct_Write_off_Details | Daily | Complete Data |
Loan Recovery details | OL | AATB_STG_OL_LOAN_RECOVERY | AAPKS_EXTRACT_OL_LN_RECOVERY | Stg_Acct_Recovery_Details | Daily | Complete Data |
Transactions on loan contracts | LB | AATB_STG_LB_LOAN_CONTRACT_TXNS | AAPKS_EXTRACT_LB_CONTRACT_TXNS | Stg_Loan_Contract_Txns | Daily | New Data |
Loan contract details | LB | AATB_STG_LB_LOAN_CONTRACTS | AAPKS_EXTRACT_LB_LN_CONTRACTS | Stg_Loan_Contracts | Daily | Complete Data |