RB_IMP_STATS_VW

(SQL View)
 Index Back

Import Definition View

Search View for import definition

SELECT A.LI_IMPORT_ID , B.RUN_CNTL_ID , D.PRCSINSTANCE , A.DESCR , B.LI_SCHED_GEN_DATE , A.LI_IMPORT_TYPE_ID , C.DESCR , B.LI_SCHED_GEN_TIME , D.RUNDTTM , D.BEGINDTTM , D.RUNSTATUS FROM PS_RB_IMPORT_DEFN A , PS_RB_IMPT_RUNSPEC B , PS_RB_IMP_TYPE_TBL C , PSPRCSRQST D , PS_RB_IMP_ONE_PROC E WHERE A.LI_IMPORT_TYPE_ID = C.LI_IMPORT_TYPE_ID AND A.LI_IMPORT_ID = B.LI_IMPORT_ID AND B.RUN_CNTL_ID = D.RUNCNTLID AND B.RB_IMPT_PROC_TYPE IN (' ', 'N', 'M', 'W', 'A') AND E.PRCSINSTANCE = D.PRCSINSTANCE AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_RB_IMPORT_DEFN X WHERE X.LI_IMPORT_ID = A.LI_IMPORT_ID AND X.EFFDT <= %CurrentDateIn)

  • Related Language Record: RB_IMP_STAT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LI_IMPORT_ID Character(31) VARCHAR2(31) NOT NULL Import ID

    Prompt Table: RB_IMPT_ACT_VW

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 LI_SCHED_GEN_DATE Date(10) DATE Scheduled Generation Date
    6 LI_IMPORT_TYPE_ID Character(31) VARCHAR2(31) NOT NULL Import Tyoe ID (import with role)
    7 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description
    8 LI_SCHED_GEN_TIME Time(15) TIMESTAMP Scheduled Generation Time
    9 RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
    10 BEGINDTTM DateTime(26) TIMESTAMP Begin Date/Time
    11 RB_TRACKING_STATUS Character(4) VARCHAR2(4) NOT NULL Tracking status for list import
    1=Cancel
    10=Not Successful
    11=Posted
    12=Unable to post
    13=Resend
    14=Posting
    15=Content Generated
    16=Pending
    17=Waiting
    2=Delete
    3=Error
    4=Hold
    5=Queued
    6=Initiated
    7=Processing
    8=Cancelled
    9=Success