SAD_UC_APRVW

(SQL View)
 Index Back

Prompt on active APR codes


SELECT B.OPRID , A.sad_uc_dom , A.sad_uc_domtext FROM PS_SAD_UC_APR A , PS_OPR_DEF_TBL_CS B WHERE A.INSTITUTION=B.INSTITUTION AND A.sad_uc_active_ind='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SAD_UC_DOM Character(3) VARCHAR2(3) NOT NULL Country
3 SAD_UC_DOMTEXT Character(250) VARCHAR2(250) NOT NULL Description