SCR_HDR_VW (SQL View)	Index Back
SCR Approval linkage View that links primary SCR Table to approval route

SCR_HDR_VW

(SQL View)

SCR Approval linkage

View that links primary SCR Table to approval route

SELECT DISTINCT H.SCR_ID , H.SETID , H.SUP_OB_TEMPLATE_ID , H.VENDOR_ID , V.NAME1 , H.LAST_SEQ_NUM , H.EMAILID , H.SCR_STATUS , %subrec(FMS_WHO_SBR, H) , 'RS' , A.OPRID FROM PS_SCR_HEADER H , PS_SCR_AW_ACTN_VW A , PS_VENDOR V WHERE H.SCR_ID=A.SCR_ID AND H.SETID = V.SETID AND H.VENDOR_ID = V.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCR_ID Character(15) VARCHAR2(15) NOT NULL Supplier Change Request ID

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id

4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

6 LAST_SEQ_NUM Number(5,0) INTEGER NOT NULL Last Sequence Number

7 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

8 SCR_STATUS Character(1) VARCHAR2(1) NOT NULL Status
A=Approved
B=Request Editor More Info..
B=Request Editor More Info..
C=Pending Editor Review
C=Pending Editor Review
E=Update Error
I=Integrity Error
M=Request Additional Information
P=Pending Approval
R=Rejected
S=Save for Later
U=Database Updated
W=Withdrawn

9 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.

10 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.

11 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.

12 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.

13 SUPOB_REG_OPT_TYPE Character(2) VARCHAR2(2) NOT NULL On boarding manage invite options
AD=Ad-hoc Tasks
NB=Register New Bidders
NS=Register New Suppliers
NU=Register New User Accounts
PC=Profile Change Request
RB=Request Change for Bidder
RS=Request Supplier Change

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCR_ID	Character(15)	VARCHAR2(15) NOT NULL	Supplier Change Request ID
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	SUP_OB_TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Supplier On boarding template Id
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
6	LAST_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Last Sequence Number
7	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
8	SCR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status A=Approved B=Request Editor More Info.. B=Request Editor More Info.. C=Pending Editor Review C=Pending Editor Review E=Update Error I=Integrity Error M=Request Additional Information P=Pending Approval R=Rejected S=Save for Later U=Database Updated W=Withdrawn
9	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
10	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
11	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
12	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.
13	SUPOB_REG_OPT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	On boarding manage invite options AD=Ad-hoc Tasks NB=Register New Bidders NS=Register New Suppliers NU=Register New User Accounts PC=Profile Change Request RB=Request Change for Bidder RS=Request Supplier Change
14	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).