SAD_TEST_SRC_VW (SQL View)	Index Back
Test Load Suspension View This view shows all of the Suspense Records which are ready for Saerch/Match.

SAD_TEST_SRC_VW

(SQL View)

Test Load Suspension View

This view shows all of the Suspense Records which are ready for Saerch/Match.

SELECT TEST_ID ,TEST_REC_NBR ,LAST_NAME_SRCH ,FIRST_NAME_SRCH FROM PS_SAD_TEST_SUSPN WHERE EDIT_PROC_OPTN = 'C' AND SRCH_PROC_OPTN = 'P' AND POST_PROC_OPTN = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID
Prompt Table: SAD_TST_SCTY_VW

2 TEST_REC_NBR Number(9,0) DECIMAL(9) NOT NULL Test Type Record Nbr

3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

4 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID Prompt Table: SAD_TST_SCTY_VW
2	TEST_REC_NBR	Number(9,0)	DECIMAL(9) NOT NULL	Test Type Record Nbr
3	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
4	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name