SAD_UC_EXTORGVW

(SQL View)
 Index Back

Externgal Org View for UCAS


SELECT EXT_ORG_ID , DESCR FROM PS_EXT_ORG_TBL A WHERE EFFDT = ( SELECT MAX(EFFDT) FROM PS_EXT_ORG_TBL B WHERE A.EXT_ORG_ID = B.EXT_ORG_ID AND EFF_STATUS = 'A') AND EFF_STATUS = 'A'

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