HRS_SRCH_STYPVW(SQL View) |
Index Back |
---|---|
Cont Sect Srch View w JPM IntIf JPM integration is on, Populates search criteria with the intersection of primary person profile type category types and TAM content sections for JPM section properties that are searchable |
SELECT DISTINCT HRSCTCFG.JPM_JP_TYPE ,HRSCTCFG.JPM_CAT_TYPE FROM PS_HRS_SCT_CFG_VW HRSCTCFG , PS_JPM_PRI_P_PRP_I JPMPRIPI WHERE HRSCTCFG.JPM_JP_TYPE = JPMPRIPI.JPM_JP_TYPE AND HRSCTCFG.JPM_CAT_TYPE = JPMPRIPI.JPM_CAT_TYPE AND JPMPRIPI.JPM_JP_SRCH_FLG = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(12) | VARCHAR2(12) NOT NULL | Profile Type name for a JPM Profile Type | |
2 | 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. |