SAD_LST_SUS_VW (SQL View)	Index Back
LSAT Suspense View This view shows all of the Suspense Records for LSAT Test ID which are ready for Searc/Match Post.

SAD_LST_SUS_VW

(SQL View)

LSAT Suspense View

This view shows all of the Suspense Records for LSAT Test ID which are ready for Searc/Match Post.

SELECT S.TEST_ID ,S1.TEST_SELECT_LSAC , S.TEST_REC_NBR ,S.LAST_NAME_SRCH ,S.FIRST_NAME_SRCH FROM PS_SAD_TEST_SUSPN S ,PS_SAD_LAW_SUS S1 WHERE S.TEST_REC_NBR = S1.TEST_REC_NBR AND S.EDIT_PROC_OPTN = 'C' AND (S.SRCH_PROC_OPTN = 'P' AND S.POST_PROC_OPTN = 'A') OR (S.SRCH_PROC_OPTN = 'C' AND S.POST_PROC_OPTN IN ('U','N'))

# 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_SELECT_LSAC Character(1) VARCHAR2(1) NOT NULL LSAT/LSDAS Test Score
L=LSAT Test Score
S=LSDAS Test Score

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

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

5 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_SELECT_LSAC	Character(1)	VARCHAR2(1) NOT NULL	LSAT/LSDAS Test Score L=LSAT Test Score S=LSDAS Test Score
3	TEST_REC_NBR	Number(9,0)	DECIMAL(9) NOT NULL	Test Type Record Nbr
4	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
5	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name