rxp Table: EOP Synchronization
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rxp Table: EOP Synchronization

Indexes

Name Segment 1
rxp_idx0 cntl_rec_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
cntl_rec_s
00 - Dummy key
CHAR(2) no
stamp_l
Record modification stamp
NUMBER(10) no
submit_eop_c
Portfolio was submitted in current EOP (Y/N)
VARCHAR2(99) yes
complete_eop_c
Portfolio was completed in current EOP (Y/N)
VARCHAR2(99) yes
status_pp_c
Post-portfolio status (I/R/C)
  I - Submit/complete arrays initialized
  R - Post-portfolio is running
  C - Post-portfolio has completed
CHAR(1) yes
por_pp_s
Portfolio under which post-portfolio module running
CHAR(2) yes
eop_end_status_s
EOP Post-portfolio job statuses (N/P/R/F/C)
  Statuses:
    N - No EOP running
    P - Pending
    R - Running
    F - Failed
    C - Completed
  Positions:
    1 - U0497 Collection
    2 - not used
    3 - U0463 Credit Bureau
    4 - U0437 Vertex Interface
    5 - U0488 Cash Control Cleanup
    6-20 - not used
VARCHAR2(20) yes
cstm_before_status_s
Custom before program run status (N/E/S/P/R/C/F).
  The first position is for the before program of EOP Suite.
  The next 99 positions are for the before programs of
  portfolios ' 1' through '99'.
    N - default value at database conversion
    E - the custom program will be executed
    S - the custom program will be skipped
    P - the custom program is about to be run
    R - the custom program is running
    C - the custom program has completed successfully
    F - the custom program has failed
VARCHAR2(100) yes
cstm_after_status_s
Custom after program run status (N/E/S/P/R/C/F)
  The first position is for the after program of EOP Suite.
  The next 99 positions are for the after programs of
  portfolios ' 1' through '99'.
    N - default value at database conversion
    E - the custom program will be executed
    S - the custom program will be skipped
    P - the custom program is about to be run
    R - the custom program is running
    C - the custom program has completed successfully
    F - the custom program has failed
VARCHAR2(100) yes
eop_execution_req_s
EOP execution required (Y/N)
VARCHAR2(99) yes