JPM_PROPSEQ_VW

(SQL View)
 Index Back

SELECT FIELDNAME , CASE WHEN FIELDNAME = 'JPM_CAT_ITEM_ID' THEN 10 WHEN FIELDNAME = 'JPM_PROFILE_ID' THEN 20 WHEN FIELDNAME = 'EFFDT' THEN 30 WHEN FIELDNAME = 'EFF_STATUS' THEN 40 WHEN FIELDNAME = 'JPM_JP_ITEM_SRC' THEN 50 WHEN FIELDNAME = 'JPM_SOURCE_ID2' THEN 9900 WHEN FIELDNAME = 'JPM_WF_STATUS' THEN 9910 ELSE 1000 + MIN(FIELDNUM) END FROM PSPNLFIELD WHERE PNLNAME IN ('JPM_JP_PRP_DTL_SBP', 'JPM_JP_ITM_DTL_SBP') AND RECNAME IN ('JPM_ITM_PRP_SBR', 'JPM_JP_ITEMS') GROUP BY FIELDNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: PSDBFIELD

2 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

Default Value: 9999