OPR_DEF_TBL_RG

(SQL Table)
Index Back

Change Management

Operator default information for Change management

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 RG_REQUEST_TYPE Character(4) VARCHAR2(4) NOT NULL Change Management Type of Change Request.

Prompt Table: RG_UD_REQ_TYPE

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

Prompt Table: RG_UD_REQ_SUBTY

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

Prompt Table: RG_UD_REQ_STATU

6 RG_REASON Character(4) VARCHAR2(4) NOT NULL Business Reason for Change request

Prompt Table: RG_UD_REQ_BUSR

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

Prompt Table: RG_UD_REQ_PRTY

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

Prompt Table: RG_UD_REQ_CATGY

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

Prompt Table: RG_UD_REQ_IMPCT

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

Prompt Table: RG_PHS_MODL_HDR