HCR_SM_ORG_VW

(SQL View)
Index Back

Search Match Organization view

Search Match Organization view. This view selects only EXT_ORG_ID's.

SELECT A.EXT_ORG_ID FROM PS_EXT_ORG_TBL A , PS_INSTALLATION B

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID