HRS_SCH_JPRP2VW(SQL View) |
Index Back |
---|---|
HRS JO Srch Prop no JPM Intgif JPM integration is off, selects all properties with fieldname JPM_CAT_ITEM_ID or JPM_ADHOC_FLG = Y for the intersection of sections for job opening item's with the primary person profile type's sections with TAM content sections. |
SELECT DISTINCT JOITEM.HRS_JOB_OPENING_ID ,HRSCTCFG.JPM_JP_TYPE ,HRSCTCFG.JPM_CAT_TYPE ,JPMPRIPI.FIELDNAME ,JPMPRIPI.JPM_LABEL_TEXT FROM PS_HRS_SCT_CFG_VW HRSCTCFG , PS_JPM_PRI_P_PRP_I JPMPRIPI , PS_HRS_JO_ITEMS JOITEM , PS_JPM_PRI_P_CAT_I JPMCFG WHERE HRSCTCFG.JPM_JP_TYPE = JPMPRIPI.JPM_JP_TYPE AND HRSCTCFG.JPM_CAT_TYPE = JPMPRIPI.JPM_CAT_TYPE AND JPMCFG.JPM_JP_TYPE = JPMPRIPI.JPM_JP_TYPE AND JPMCFG.JPM_CAT_TYPE =JPMPRIPI.JPM_CAT_TYPE AND JOITEM.JPM_CAT_TYPE = HRSCTCFG.JPM_CAT_TYPE AND (JPMPRIPI.FIELDNAME = 'JPM_CAT_ITEM_ID' OR (JPMCFG.JPM_ADHOC_FLG = 'Y' AND JPMPRIPI.FIELDNAME = 'JPM_ADHOC_DESCR' )) AND JOITEM.EFF_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
2 | JPM_JP_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Profile Type name for a JPM Profile Type |
3 | 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. |
4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
5 | JPM_LABEL_TEXT | Character(30) | VARCHAR2(30) NOT NULL | User defined text to be displayed as a label for a field or property within JPM User Interfaces. |