JPM_JP_TYPEJPM_CAT_TYPEJPM_CAT_TYPE2C=Is a child of
I=Supports
P=Is a parent of
R=Is Supported By
JPM_PF_ITMSECVW(SQL View) |
Index Back |
|---|---|
JPM Item Section viewJPM Item Section view |
| SELECT A.JPM_JP_TYPE ,A.JPM_CAT_TYPE , B.JPM_CAT_TYPE ,B.JPM_JP_SECTION_ID ,B.JPM_JP_PSECTION_ID ,B.JPM_CAT_RLAT_CD FROM PS_JPM_JP_SECTION A , PS_JPM_JP_SECTION B WHERE B.JPM_JP_PSECTION_ID>0 AND B.JPM_CAT_RLAT_CD = 'C' AND B.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_JPM_JP_TYPES X WHERE X.JPM_JP_TYPE = B.JPM_JP_TYPE AND X.EFFDT <= %CurrentDateIn AND X.JPM_JP_TYPE_STATUS = 'A') AND A.JPM_JP_TYPE=B.JPM_JP_TYPE AND A.JPM_JP_SECTION_ID=B.JPM_JP_PSECTION_ID AND A.EFFDT = B.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_JP_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Profile Type name for a JPM Profile Type |
| 2 | 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. |
| 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). |
| 4 | JPM_JP_SECTION_ID | Number(4,0) | SMALLINT NOT NULL | JPM |
| 5 | JPM_JP_PSECTION_ID | Number(4,0) | SMALLINT NOT NULL | Parent Section Id on Profile Types |
| 6 | 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 |