PV_CHNGRST_D_VW

(SQL View)
 Index Back

Change Order Request Detail


SELECT B.PROCESS_INSTANCE , B.BUSINESS_UNIT , B.REQ_ID , B.LINE_NBR , B.SCHED_NBR , B.CHNG_SOURCE , B.CHNG_DTTM , B.FIELDNAME , ' ' , B.CHNG_TYPE , ' ' , B.CHNG_CHAR_VALUE , B.CHNG_DATE_VALUE , B.CHNG_NBR_VALUE , ' ' , B.PRIOR_CHAR_VALUE , B.PRIOR_DATE_VALUE , B.PRIOR_NBR_VALUE , B.REQ_CHNG_STATUS , B.OPRID_MODIFIED_BY , B.LAST_DTTM_UPDATE , B.BUSINESS_UNIT_PO , B.PO_ID , B.PO_LINE_NBR , B.PO_SCHED_NBR , B.PO_CHNG_DTTM , B.APPR_STATUS , B.MESSAGE_NBR , B.MESSAGE_SET_NBR , B.REASON_SEQ , D.INV_ITEM_ID , D.DESCR254_MIXED , ' ' , ' ' , ' ' , B.LAST_DTTM_UPDATE , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_PV_CHNG_RST_DTL B , PS_REQ_LINE D WHERE B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.REQ_ID = D.REQ_ID AND B.LINE_NBR = D.LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
6 CHNG_SOURCE Character(3) VARCHAR2(3) NOT NULL Change Source
BPA=Contract Release to Single PO
CAP=Contract Batch Auto Approval
CRT=PAR Replenish/Close Backorders
CST=Close Short Purchase Orders
DRP=Order Management Referenced
EDX=PO Acknowledgments
EMC=Req. Requester Mass Change
EPO=eProcurement Change Request
EPR=User Change Request
IMC=Inventory Mass Change
ONL=On-line Purchase Order
PLN=Planning System
PMC=PO Buyer Mass Change
POC=PO Change Batch Process
PRD=Production/Shop Floor

Default Value: EPO

7 CHNG_DTTM DateTime(26) TIMESTAMP Change Request Date/Time

Default Value: %DATETIME

8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
9 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
10 CHNG_TYPE Character(1) VARCHAR2(1) NOT NULL Change Type
C=Change
D=Deleted
H=Hold
I=Inserted
N=New
O=Original
R=Re-open
X=Cancelled

Default Value: C

11 VALUE_CHAR Character(254) VARCHAR2(254) NOT NULL VALUE CHARACTER
12 CHNG_CHAR_VALUE Character(254) VARCHAR2(254) NOT NULL New Field Value
13 CHNG_DATE_VALUE Date(10) DATE New Date Value
14 CHNG_NBR_VALUE Signed Number(30,5) DECIMAL(28,5) NOT NULL New Numeric Value
15 VALUE_CHAR1 Character(254) VARCHAR2(254) NOT NULL VALUE CHARACTER
16 PRIOR_CHAR_VALUE Character(254) VARCHAR2(254) NOT NULL Prior Character Value
17 PRIOR_DATE_VALUE Date(10) DATE Prior Date Value
18 PRIOR_NBR_VALUE Signed Number(30,5) DECIMAL(28,5) NOT NULL Prior Value
19 REQ_CHNG_STATUS Character(2) VARCHAR2(2) NOT NULL Change Request Status
BE=Budget Fail
C=Completed
D=Denied
E=Error
I=Initialize
NC=Budget Not Checked
P=In Process
R=Ready for Process

Default Value: I

20 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
21 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
22 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
23 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
24 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
25 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number
26 PO_CHNG_DTTM DateTime(26) TIMESTAMP Change Request Date/Time
27 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending

Default Value: P

28 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
29 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
30 REASON_SEQ Number(5,0) INTEGER NOT NULL Reason Sequence
31 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDIT_ITEM_ID

32 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
33 REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason Type

Default Value: POC1

34 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

Prompt Table: %EDITTABLE40

35 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
36 ENTERED_DTTM DateTime(26) TIMESTAMP Entered Datetime
37 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
38 CHG_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Change Process Status used for CHNG_RQST_DTL table. This field will replace PROCESS_FLG. New field created so new translate value 'Recycle' can be incuded.
C=Complete
E=Error
N=Initialize
P=In Process
R=Recycle
X=Cancel

Default Value: N

39 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
D=Denied
N=Not Approved
Y=Approved
40 VALUE_STATUS Character(30) VARCHAR2(30) NOT NULL VALUE CHARACTER
41 VALUE_APPROVAL Character(30) VARCHAR2(30) NOT NULL Change Request Approved
42 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr