SCR_ID_HST_VW (SQL View)	Index Back
SCR ID Nbrs Adjustment View

SCR_ID_HST_VW

(SQL View)

SCR ID Nbrs Adjustment View

SELECT DISTINCT SCR_ID ,STD_ID_NUM_QUAL FROM PS_SCR_ID_NBRS_HST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCR_ID	Character(15)	VARCHAR2(15) NOT NULL	Supplier Change Request ID
2	STD_ID_NUM_QUAL	Character(3)	VARCHAR2(3) NOT NULL	Standard ID Number