HMCR_SRV_VER_VW

(SQL View)
 Index Back

Service Version View

Joins the portal definition table to the portal attibutes table for the HC_REGISTRY portal.

SELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , A.PORTAL_LABEL , B.PORTAL_ATTR_VAL FROM PSPRSMDEFN A , PSPRSMSYSATTRVL B WHERE A.PORTAL_REFTYPE = 'C' AND B.PORTAL_NAME = A.PORTAL_NAME AND B.PORTAL_REFTYPE = 'C' AND B.PORTAL_OBJNAME = A.PORTAL_OBJNAME AND B.PORTAL_ATTR_NAM = 'VERSION'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
3 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
4 PORTAL_ATTR_VAL Long Character CLOB The value of the folder or content reference