SAD_TAC_PST_VW (SQL View)	Index Back
TAC Load Suspension View This view shows all of the Suspense Records which are ready for Posting and have a POST_PROC_OPTN of 'U' or 'N'

SAD_TAC_PST_VW

(SQL View)

TAC Load Suspension View

This view shows all of the Suspense Records which are ready for Posting and have a POST_PROC_OPTN of 'U' or 'N'

SELECT TEST_ID ,EXT_ADM_APPL_NBR ,LAST_NAME_SRCH ,FIRST_NAME_SRCH FROM PS_SAD_TAC_SUS WHERE EDIT_PROC_OPTN = 'C' AND SRCH_PROC_OPTN = 'C' AND 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 EXT_ADM_APPL_NBR Character(15) VARCHAR2(15) NOT NULL External Application 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	EXT_ADM_APPL_NBR	Character(15)	VARCHAR2(15) NOT NULL	External Application 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