SSF_DD_SRCH_VW

(SQL View)
Index Back

Search view - Bank Accts page.

Search view for Bank Accounts page.

SELECT B.COMMON_ID ,B.SA_ID_TYPE ,A.NAME ,A.LAST_NAME_SRCH ,A.FIRST_NAME_SRCH FROM PS_PEOPLE_SRCH A ,PS_SSF_BANK_ACCT B WHERE A.EMPLID = B.COMMON_ID AND B.SA_ID_TYPE = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

Prompt Table: PEOPLE_SRCH

2 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person

Default Value: P

3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name