SAD_PB_OINSTVW1

(SQL View)

SELECT A.ext_org_id , A.DESCR50 ,A.OTH_NAME_SORT_SRCH ,A.ext_org_type ,b.country FROM PS_EXT_ORG_TBL A JOIN ps_org_location B ON A.ext_org_id = B.ext_org_id AND A.org_location = B.org_location WHERE %EffdtCheck(EXT_ORG_TBL EFF1, A,%CurrentDateIn) AND %EffdtCheck(ORG_LOCATION EFF2, B,%CurrentDateIn) AND B.country <> 'GBR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

3 OTH_NAME_SORT_SRCH Character(50) VARCHAR2(50) NOT NULL Search Name

4 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type
Prompt Table: SCC_ORG_TYP_TBL

5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
3	OTH_NAME_SORT_SRCH	Character(50)	VARCHAR2(50) NOT NULL	Search Name
4	EXT_ORG_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Organization Type Prompt Table: SCC_ORG_TYP_TBL
5	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL