FT_CAT_I_RLAT(SQL Table) |
Index Back |
|---|---|
Catalog RelationshipsTalent Mgmt - Defines relationship between Catalog Items. |
| # | 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_TYPES |
| 2 | JPM_CAT_ITEM_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
Prompt Table: JPM_CAT_ITEMS |
| 3 | 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_CAT_TYP2_VW |
| 4 | JPM_CAT_ITEM_ID2 |
Character(12) | VARCHAR2(12) NOT NULL |
Secondary content item id (as in a related item- such as a child or a supporting item of another item).
Prompt Table: JPM_CAT_ITM2_VW |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 7 | 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 |
| 8 | JPM_MANDATORY | Character(1) | VARCHAR2(1) NOT NULL |
jpm
N=No Y=Yes Y/N Table Edit Default Value: N |
| 9 | FT_ALTERNATE_REC | Character(50) | VARCHAR2(50) NOT NULL | Source Record |
| 10 | FT_ALTERNATE_KEY | Character(254) | VARCHAR2(254) NOT NULL | Alternate Key |