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.