JPM_CAT_TYPEPrompt Table: JPM_CAT_TYPE_VW
JPM_CAT_TYPE2Prompt Table: JPM_CT_NOHOC_VW
C=Is a child of
I=Supports
P=Is a parent of
R=Is Supported By
Y/N Table Edit
Default Value: N
JPM_CAT_T_RLAT(SQL Table) |
Index Back |
|---|---|
Cat Type RelationshipsRelationship defintions for a Content Type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_CAT_TYPE |
Character(12) | VARCHAR2(12) NOT NULL |
The name of the type of items that will be used in a Catalog and or in a Profile.
Prompt Table: JPM_CAT_TYPE_VW |
| 2 | JPM_CAT_TYPE2 |
Character(12) | VARCHAR2(12) NOT NULL |
Secondary content item type (as in a related item- such as a child or a supporting item of another item).
Prompt Table: JPM_CT_NOHOC_VW |
| 3 | JPM_CAT_RLAT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Talent Mgmt - Describes the relationship of one Catalog Item to another Catalog Item.
C=Is a child of I=Supports P=Is a parent of R=Is Supported By |
| 4 | 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 |