JPM_PCONTENT_CV

(SQL View)
 Index Back

Catalog Typ in Profile Clairvi

Clone of JPM_JP_CAT_TYPE record for Clairvia Fullsync message

SELECT CATYP.JPM_PROFILE_ID , CATYP.JPM_CAT_TYPE FROM PS_JPM_JP_CAT_TYPE CATYP , PS_JPM_PROFILE_I PRF , PS_JPM_JP_PERTYP_I PRIM , PS_INTEGR_CAT_TYPE ICAT WHERE PRF.JPM_PROFILE_ID = CATYP.JPM_PROFILE_ID AND PRIM.JPM_PRI_PERS_TYPE = PRF.JPM_JP_TYPE AND ICAT.INT_APP_TYPE = 'SCH' AND ICAT.INTEGR_PROD_CD = 'CV' AND ICAT.JPM_CAT_TYPE = CATYP.JPM_CAT_TYPE AND PRF.JPM_JP_PRFL_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM PS_PER_ORG_ASG_INT ASG2 WHERE ASG2.EMPLID = PRF.EMPLID AND ASG2.INT_APP_TYPE = 'SCH' AND ASG2.INTEGR_PROD_CD = 'CV' AND ASG2.ENROLLED_FLAG = 'Y')

# 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.

Prompt Table: JPM_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.

Prompt Table: JPM_CAT_TYPES