RB_MIGR_ACT_VW

(SQL View)
 Index Back

MIgr actions defns.

Record used for storing Migration Action definitions

SELECT setid , mig_action_id , source_product_id , target_product_id , descr254 , rb_hlev_id , mig_act_status , start_dt , end_dt , public_migr_flag FROM PS_RB_MIG_ACT_TBL

  • Related Language Record: RB_MIGR_ACT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    2 MIG_ACTION_ID Character(10) VARCHAR2(10) NOT NULL Field used for storing migration action id

    Default Value: NEXT

    3 SOURCE_PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL field used for storing Source Product ID value

    Prompt Table: RB_CPRD_MLPB_VW

    4 TARGET_PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Field used to store Porduct ID of a target

    Prompt Table: RB_CPRD_ML_DVW

    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    6 RB_HLEV_ID Character(20) VARCHAR2(20) NOT NULL Field used for storing multilevel structure level id information

    Prompt Table: RB_HLEV_DFN_VW

    7 MIG_ACT_STATUS Character(4) VARCHAR2(4) NOT NULL Field used for storing migration action status
    ACTV=Active
    INAC=Inactive
    8 START_DT Date(10) DATE NOT NULL Start date field to store start date value.
    9 END_DT Date(10) DATE NOT NULL This field stores the end date values.
    10 PUBLIC_MIGR_FLAG Character(1) VARCHAR2(1) NOT NULL Field used for storing Public Migration Flag Value

    Y/N Table Edit

    Default Value: Y