HMCR_SRV_PROMPT

(SQL View)
 Index Back

Services Prompt

View for Services in the HCM Registry

SELECT A.PORTAL_LABEL , A.PORTAL_OBJNAME , A.PORTAL_PRNTOBJNAME , A.PORTAL_STG_NAME , A.PORTAL_URLTEXT , A.VERSION , A.PORTAL_REFTYPE , A.DESCR254 FROM PSPRSMDEFN A , PSPRSMSYSATTRVL B WHERE A.PORTAL_NAME = B.PORTAL_NAME AND A.PORTAL_REFTYPE = B.PORTAL_REFTYPE AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME AND A.PORTAL_NAME = 'HC_REGISTRY' AND A.PORTAL_REFTYPE <> 'F' AND B.PORTAL_ATTR_NAM = 'TYPE' AND B.PORTAL_ATTR_VAL LIKE 'SRV'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HMCR_PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Service/Exception/Type name for storing in cache
2 HMCR_IFC_UUID Character(30) VARCHAR2(30) NOT NULL UUID of the service
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