HMCR_REG_SRCH

(SQL View)
 Index Back

SELECT PORTAL_OBJNAME , PORTAL_LABEL , PORTAL_PRNTOBJNAME , PORTAL_STG_NAME , PORTAL_URLTEXT , VERSION , PORTAL_REFTYPE , DESCR254 FROM PSPRSMDEFN WHERE PORTAL_NAME = 'HC_REGISTRY' AND PORTAL_REFTYPE <> 'F' AND PORTAL_OBJNAME LIKE 'HC_UUID%' AND PORTAL_OBJNAME NOT LIKE '%_L'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HMCR_IFC_UUID Character(30) VARCHAR2(30) NOT NULL UUID of the service
2 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
3 PORTAL_PRNTOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Parent Object Name
4 PORTAL_STG_NAME Character(30) VARCHAR2(30) NOT NULL Portal Registry Storage Name
5 PORTAL_URLTEXT Long Character CLOB Portal URL Logical Text
6 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
7 PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
C=Content
F=Folder
8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254