RG_P_MDL_USE_VW

(SQL View)
 Index Back

Phase Model Use Table

Phase Models use table for a Change Request

SELECT U.SETID , U.MODEL_USE_ID , U.START_DT , U.END_DT , U.RG_REQUEST_TYPE , U.RG_REQ_SUB_TYPE , U.RG_PRIORITY , U.MODEL_ID , H.DESCR FROM PS_RG_PHS_MODL_USE U , PS_RG_PHS_MODL_HDR H WHERE U.SETID = H.SETID AND U.MODEL_ID = H.MODEL_ID AND (U.END_DT > %CurrentDateIn OR U.END_DT IS NULL)

  • Related Language Record: RG_P_MDL_UE_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

    Prompt Table: SP_SETID_NONVW

    2 MODEL_USE_ID Character(15) VARCHAR2(15) NOT NULL Model Use ID for Change Management Phase Models
    3 START_DT Date(10) DATE NOT NULL Start date field to store start date value.
    4 END_DT Date(10) DATE This field stores the end date values.
    5 RG_REQUEST_TYPE Character(4) VARCHAR2(4) NOT NULL Change Management Type of Change Request.

    Prompt Table: RG_UD_REQ_TYPE

    6 RG_REQ_SUB_TYPE Character(4) VARCHAR2(4) NOT NULL Change Management change Request Sub Type

    Prompt Table: RG_UD_REQ_SUBTY

    7 RG_PRIORITY Character(4) VARCHAR2(4) NOT NULL change management

    Prompt Table: RG_UD_REQ_PRTY

    8 MODEL_ID Character(15) VARCHAR2(15) NOT NULL Model Id used in Change Management Phase Models

    Prompt Table: RG_PHS_MODL_HDR

    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description