JPM_CSECTION_VW(SQL View) |
Index Back |
---|---|
Profile Related Content Sect |
SELECT C.JPM_JP_TYPE , P.JPM_CAT_TYPE , C.JPM_CAT_TYPE , C.JPM_JP_SECTION_ID , C.JPM_JP_TABNUM , C.SEQNUM , C.JPM_JP_MULTI_FLG , C.JPM_JP_QUAL_SET , C.JPM_JP_QUAL_SET2 , C.JPM_JP_PSECTION_ID , C.JPM_CAT_REQUIRED , C.JPM_CAT_RLAT_CD , C.JPM_SECT_SUB_FLG FROM PS_JPM_JP_SECTION P , PS_JPM_JP_SECTION C WHERE %EffdtCheck(JPM_JP_TYPES D, P, %CurrentDateIn) AND C.JPM_JP_TYPE = P.JPM_JP_TYPE AND C.EFFDT = P.EFFDT AND C.JPM_JP_PSECTION_ID = P.JPM_JP_SECTION_ID |
# | 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_TABNUM | Number(3,0) | SMALLINT NOT NULL | Tab number to be moved or re-ordered in a JPM Profile Content Section within a Profile Type |
6 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
7 | JPM_JP_MULTI_FLG | Character(1) | VARCHAR2(1) NOT NULL | Mulitple instances indicator for JPM Profile Items |
8 | JPM_JP_QUAL_SET | Character(12) | VARCHAR2(12) NOT NULL | 1st Instance Qualifier Set Name for a JPM Profile Item |
9 | JPM_JP_QUAL_SET2 | Character(12) | VARCHAR2(12) NOT NULL | 2nd Instance Qualifier Set Name for a JPM Profile Item |
10 | JPM_JP_PSECTION_ID | Number(4,0) | SMALLINT NOT NULL | Parent Section Id on Profile Types |
11 | JPM_CAT_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL | Used to indicate that the property, item or relationship must be used. |
12 | 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 |
13 | JPM_SECT_SUB_FLG | Character(1) | VARCHAR2(1) NOT NULL | This flag is used on the profile type section to identify if the section can have subitems or not. |