CHNG_RQST_FS (SQL View)	Index Back
Change Order Request for SF

CHNG_RQST_FS

(SQL View)

Change Order Request for SF

SELECT a.PROCESS_INSTANCE , a.BUSINESS_UNIT , a.PO_ID , a.CHNG_SOURCE , a.CHNG_DTTM , a.REVIEWED , a.REVIEWED_DT , a.OPRID , a.PO_UPDATED , %subrec(LAST_UPDATE_SBR,a) , a.APPROVED_FLG , a.REASON_CD , a.COMMENTS FROM PS_CHNG_RQST a

# 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 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

4 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

5 CHNG_DTTM DateTime(26) TIMESTAMP Change Request Date/Time
Default Value: %Date

6 REVIEWED Character(1) VARCHAR2(1) NOT NULL Review Complete
N=No
Y=Yes
Y/N Table Edit
Default Value: N

7 REVIEWED_DT Date(10) DATE Reviewed On

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

9 PO_UPDATED Character(1) VARCHAR2(1) NOT NULL Update
N=No
Y=Yes
Y/N Table Edit
Default Value: N

10 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.

11 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.

12 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
D=Denied
N=Not Approved
Y=Approved

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

14 COMMENTS Long Character CLOB Comment

#	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	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	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
5	CHNG_DTTM	DateTime(26)	TIMESTAMP	Change Request Date/Time Default Value: %Date
6	REVIEWED	Character(1)	VARCHAR2(1) NOT NULL	Review Complete N=No Y=Yes Y/N Table Edit Default Value: N
7	REVIEWED_DT	Date(10)	DATE	Reviewed On
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	PO_UPDATED	Character(1)	VARCHAR2(1) NOT NULL	Update N=No Y=Yes Y/N Table Edit Default Value: N
10	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.
11	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.
12	APPROVED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Approved by Auditor D=Denied N=Not Approved Y=Approved
13	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
14	COMMENTS	Long Character	CLOB	Comment