RG_CHANGE_REQST

(SQL Table)
 Index Back

Change Request

Main table for Change Management Application.

  • Related Language Record: RG_CHANGE_REQ_L

  • Parent Record Of RG_CHANGE_ATCH RG_CHANGE_INTR RG_CHANGE_NOTE RG_CHANGE_PROD RG_CHANGE_RCHG RG_CHANGE_ROBJ RG_CHANGE_STATE

  • Audit Record: RG_CHANGE_AUDIT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CHANGE_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL change request identification is key to change request

    Default Value: NEW

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

    Prompt Table: SP_BU_RG_NONVW

    3 RG_SUMMARY Character(80) VARCHAR2(80) NOT NULL Summary description of a Change Request
    4 RG_REASON Character(4) VARCHAR2(4) NOT NULL Business Reason for Change request

    Prompt Table: RG_UD_REQ_BUSR

    5 BO_ID_REQUESTOR Number(31,0) DECIMAL(31) NOT NULL Change Requester Identification number
    6 ROLE_TYPE_ID_REQ Number(12,0) DECIMAL(12) NOT NULL Change Management application Requester Role Type ID
    7 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
    8 DEPTID Character(15) VARCHAR2(15) NOT NULL Department

    Prompt Table: DEPT_TBL_WRK_VW

    9 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
    10 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.
    11 RG_LOCATION Character(50) VARCHAR2(50) NOT NULL Location field for a Change Request Requestor
    12 RG_REQUEST_TYPE Character(4) VARCHAR2(4) NOT NULL Change Management Type of Change Request.

    Prompt Table: RG_UD_REQ_TYPE

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

    Prompt Table: RG_UD_REQ_SUBTY

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

    Prompt Table: RG_UD_REQ_PRTY

    15 RG_CATEGORY Character(4) VARCHAR2(4) NOT NULL change management change Request Category

    Prompt Table: RG_UD_REQ_CATGY

    16 RG_IMPACT Character(4) VARCHAR2(4) NOT NULL Impact of a Change request..........

    Prompt Table: RG_UD_REQ_IMPCT

    17 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID
    18 BO_ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL BO_ROLE_TYPE_ID
    19 RG_24_7_SCHEDULE Character(1) VARCHAR2(1) NOT NULL Change Management indicator for a Change Request to schedule tasks over all hours and all days between the start date and end date of the Change Request.

    Y/N Table Edit

    Default Value: N

    20 START_DT Date(10) DATE Start date field to store start date value.
    21 START_TIME Time(15) TIMESTAMP Start of Shift
    22 END_DT Date(10) DATE This field stores the end date values.
    23 END_TIME Time(15) TIMESTAMP End of Shift
    24 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    25 RG_DURATION_DAYS Signed Number(6,0) DECIMAL(5) NOT NULL Change Management application Change Request length, days portion.
    26 RG_DURATION_HOURS Signed Number(6,2) DECIMAL(4,2) NOT NULL Change Management length of Change Request hours portion
    27 RG_CHANGE_STATE Character(4) VARCHAR2(4) NOT NULL Change request change State / Phase
    CANC=Canceled
    COMP=Complete
    DEV=Development
    HOLD=On Hold
    IMPL=Implementation
    PEND=Change Pending
    POST=Postmortem Review
    PROP=Proposed
    REJ=Rejected
    RETN=Return for More Information
    REVW=Review

    Prompt Table: RG_CHG_STATE_VW

    28 CHANGE_STATUS Character(4) VARCHAR2(4) NOT NULL status of a Change Request in Change Management application

    Prompt Table: RG_UD_REQ_STATU

    29 RG_SEVERITY Character(4) VARCHAR2(4) NOT NULL Severity code on a Change Request, not used now
    HIGH=High
    LOW=Low
    MED=Medium
    30 RESOLUTION Character(4) VARCHAR2(4) NOT NULL Resolution Identification code used in Change Management Application

    Prompt Table: RG_UD_REQ_RESO

    31 RELEASE_NAME Character(30) VARCHAR2(30) NOT NULL Name of the Release for Change Management application......
    32 MODEL_ID Character(15) VARCHAR2(15) NOT NULL Model Id used in Change Management Phase Models

    Prompt Table: RG_PHS_MODL_VW
    Set Control Field: BUSINESS_UNIT

    33 BO_ID_PREV_OWNER Number(31,0) DECIMAL(31) NOT NULL This field is used to designate the Business Object ID for the previous owner of a Change Request.
    34 REQUESTED_BY_DT Date(10) DATE Change Management Requested By Date on a Change Request. (the requested completion date of the Change Request)
    35 CLOSED_DTTM DateTime(26) TIMESTAMP Date Time stamp for when the case status category was changed to closed.
    36 CLOSED_BY_OPRID Character(30) VARCHAR2(30) NOT NULL This field is indicate closed by oprid.
    37 OUTAGE_DURATION Number(4,0) SMALLINT NOT NULL Outage duration caused by a change.
    38 OUTAGE_UNITS Character(1) VARCHAR2(1) NOT NULL Units of measurment (day, hour, minute) of outage.
    D=Day(s)
    H=Hour(s)
    M=Minute(s)
    39 DESCRLONG Long Character CLOB Long Description
    40 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    41 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    42 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    43 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    44 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    45 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time