PTIAMDDBROLEVW

(SQL View)
 Index Back

SELECT A.PTIADBNAME ,A.PTIADBDESC ,CASE WHEN A.PTIAPTPATCHREL <> '0' THEN A.PTIATOOLSREL %concat '.' %concat LPAD(A.PTIAPTPATCHREL , 2 , '0') ELSE A.PTIATOOLSREL END ,B.PTIADBROLE FROM PS_PTIAMD_DBDEFN A , PS_PTIAMD_DBROLE B WHERE A.PTIADBNAME = B.PTIADBNAME AND B.PTIADBROLESTS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIADBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
2 PTIADBDESC Character(254) VARCHAR2(254) NOT NULL Description
3 PTIAMDPTVERSION Character(24) VARCHAR2(24) NOT NULL PT Version
4 PTIADBROLE Character(4) VARCHAR2(4) NOT NULL RoleName
EPUM=Source-Current
INST=Customer Instance
OPUM=Source-Old
TRGT=Target
UMON=Usage Monitor
UPDC=CustomisationInstance