| # |
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
|
| 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
Default Value: HCM
|
| 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:
HCMD_RECDFN_PVW
|
| 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.
Y/N Table Edit
Default Value: N
|