SAD_PB_OINSTVW

(SQL View)

SELECT A.ext_org_id ,A.OTH_NAME_SORT_SRCH ,A.ext_org_type , A.DESCR50 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 OTH_NAME_SORT_SRCH Character(50) VARCHAR2(50) NOT NULL Search Name

3 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID
2	OTH_NAME_SORT_SRCH	Character(50)	VARCHAR2(50) NOT NULL	Search Name
3	EXT_ORG_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Organization Type
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50