HCMD_OBJS_PVW

(SQL View)
Index Back

Obj Descriptor Base Class View


SELECT DERIVED.HCMD_CLASSID , BASE.HCMD_METATYPE , BASE.HCMD_CLASSNAME , BASE.DESCR , BASE.HCMD_PRODCATEGORY , BASE.HCMD_INDUSTRY FROM PS_HCMD_OBJS_TBL DERIVED , PS_HCMD_META_TBL BASE WHERE (DERIVED.HCMD_CLASSID = BASE.HCMD_CLASSID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HCMD_CLASSID Character(12) VARCHAR2(12) NOT NULL EI_CLASSID
2 HCMD_METATYPE Character(4) VARCHAR2(4) NOT NULL Object Type
3 HCMD_CLASSNAME Character(30) VARCHAR2(30) NOT NULL Class name for object descriptors.
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 HCMD_PRODCATEGORY Character(4) VARCHAR2(4) NOT NULL Product Category.

Prompt Table: HCMD_PROD_CATG

6 HCMD_INDUSTRY Character(4) VARCHAR2(4) NOT NULL Industry Template.

Prompt Table: HCMD_MKT_TMP