VMI_MANAGER_VW

(SQL View)
 Index Back

VMI Role Users View

Date Init. Issue # Description 071304 JJM F-CJORG-G7A99 Created view for field VMI_MANAGER prompt table

SELECT B.ROLEUSER , A.DESCR FROM PS_ROLEXLATOPR A , PSROLEUSER B WHERE A.ROLEUSER = B.ROLEUSER AND B.ROLENAME = 'VMI Manager'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VMI_MANAGER Character(30) VARCHAR2(30) NOT NULL VMI Manager
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description