2 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 2-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