RB_IMP_EDIT_LVW

(SQL View)
Index Back

Import Definition View

Search View for import definition

SELECT A.LI_IMPORT_ID , B.RUN_CNTL_ID , A.LANGUAGE_CD , A.DESCR , C.DESCR FROM PS_RB_IMPORT_LNG A , PS_RB_IMPT_RUNSPEC B , PS_RB_IMP_TYPE_LNG C , PS_RB_IMPORT_DEFN D WHERE D.LI_IMPORT_TYPE_ID = C.LI_IMPORT_TYPE_ID AND A.LI_IMPORT_ID = D.LI_IMPORT_ID AND A.EFFDT = D.EFFDT AND A.LI_IMPORT_ID = B.LI_IMPORT_ID AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_RB_IMPORT_LNG X WHERE X.LI_IMPORT_ID = A.LI_IMPORT_ID AND X.EFFDT <= %CurrentDateIn)

  • Related Language Record for RB_IMP_EDIT_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description