JPM_PROFILE_IDJPM_CAT_TYPEJPM_JP_QUAL_VW3(SQL View) |
Index Back |
|---|---|
Instance Qualifier RetrievalGet Instance Qualifier1 and 2 for each content type |
| SELECT A.JPM_PROFILE_ID , C.JPM_CAT_TYPE , C.JPM_JP_QUAL_SET , C.JPM_JP_QUAL_SET2 FROM PS_JPM_PROFILE A , PS_JPM_JP_SECTION C WHERE A.JPM_JP_TYPE = C.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_SECTION C1, C, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_PROFILE_ID |
Character(12) | VARCHAR2(12) NOT NULL | The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile. |
| 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_JP_QUAL_SET | Character(12) | VARCHAR2(12) NOT NULL | 1st Instance Qualifier Set Name for a JPM Profile Item |
| 4 | JPM_JP_QUAL_SET2 | Character(12) | VARCHAR2(12) NOT NULL | 2nd Instance Qualifier Set Name for a JPM Profile Item |