HCMD_META_VW

(SQL View)
 Index Back

Object Descriptor

Created by Eric Solberg 2/18/02 An object descriptor is an enhanced set of metadata above tools-level metadata that describes objects and relationships.

SELECT HCMD_CLASSID , HCMD_CLASSNAME , HCMD_METATYPE , VERSION , ACTIVE_FLAG , DESCR , HCMD_DISPLAY_LABEL , OBJECTOWNERID , FOUNDATION , HCMD_PRODCATEGORY , HCMD_INDUSTRY , HCMD_USEINUI , HCMD_USEINRULES , HCMD_USEINQUERIES , HCMD_TOOLSRECORD , HCMD_OBJECTUSE , OBJECTTYPENAME , LASTUPDDTTM , LASTUPDOPRID , DESCRLONG ,SYSTEM_DATA_FLG FROM PS_HCMD_META_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HCMD_CLASSID Character(12) VARCHAR2(12) NOT NULL EI_CLASSID
2 HCMD_CLASSNAME Character(30) VARCHAR2(30) NOT NULL Class name for object descriptors.
3 HCMD_METATYPE Character(4) VARCHAR2(4) NOT NULL Object Type
4 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

Default Value: 1

5 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive

Default Value: A

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 HCMD_DISPLAY_LABEL Character(20) VARCHAR2(20) NOT NULL Display Label
8 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

Default Value: AEIM

9 FOUNDATION Character(4) VARCHAR2(4) NOT NULL Foundation
ECM=Enterprise Compensation Mgmt
EIM=Enterprise Incentive Managemnt
EPRF=ePerformance
HCM=Human Capital Management Core
RS=Recruiting Solutions
10 HCMD_PRODCATEGORY Character(4) VARCHAR2(4) NOT NULL Product Category.

Prompt Table: HCMD_PROD_CATG

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

Prompt Table: HCMD_MKT_TMP

12 HCMD_USEINUI Character(1) VARCHAR2(1) NOT NULL Use in UI?

Y/N Table Edit

Default Value: N

13 HCMD_USEINRULES Character(1) VARCHAR2(1) NOT NULL Use in Rules?

Y/N Table Edit

Default Value: N

14 HCMD_USEINQUERIES Character(1) VARCHAR2(1) NOT NULL Use in Queries?

Y/N Table Edit

Default Value: N

15 HCMD_TOOLSRECORD Character(15) VARCHAR2(15) NOT NULL Created by Eric Solberg 2/18/02 Record name associated with object descriptor

Prompt Table: PSRECDEFNPVW

16 HCMD_OBJECTUSE Character(4) VARCHAR2(4) NOT NULL Object usage role in HCMD MetaData system.
ATTM=Attribute Map
CONF=Configuration
KEYM=Key Map
PROD=Production
REPT=Reporting
SRCE=Source View
STAG=Staging
SYST=System
TEMP=Temporary

Default Value: PROD

17 OBJECTTYPENAME Character(8) VARCHAR2(8) NOT NULL Object Type Name- Version/Table reference
18 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
19 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20 DESCRLONG Long Character CLOB Long Description
21 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

Default Value: Y