JPM_PROPSEQ_VW

(SQL View)
 Index Back

Profile Property Order

Used by ProfileTypePage.ReorderProperties() method to order content section properties in profile type configuration.

SELECT A.FIELDNAME , A.PNLNAME , CASE WHEN FIELDNAME = 'JPM_SOURCE_ID2' THEN 9900 WHEN FIELDNAME = 'JPM_WF_STATUS' THEN 9910 WHEN FIELDNAME = 'LASTUPDDTTM' THEN 9920 WHEN FIELDNAME = 'LASTUPDOPRID' THEN 9930 WHEN A.PNLNAME = 'JPM_JP_ITM_DTL_SBP' THEN 1000 + MIN(FIELDNUM) WHEN A.PNLNAME = 'JPM_JP_PRP_DTL_SBP' THEN 2000 + MIN(FIELDNUM) WHEN A.PNLNAME = 'JPM_JP_EDUC_SBP' THEN 3000 + MIN(FIELDNUM) WHEN A.PNLNAME = 'JPM_JP_COUNTRY_SBP' THEN 4000 + MIN(FIELDNUM) WHEN A.PNLNAME = 'JPM_JP_CAREER_SBP' THEN 5000 + MIN(FIELDNUM) WHEN A.PNLNAME = 'JPM_JP_USER_SBP' THEN 6000 + MIN(FIELDNUM) ELSE 7000 + MIN(FIELDNUM) END FROM PSPNLFIELD A WHERE A.PNLNAME IN ('JPM_JP_ITM_DTL_SBP','JPM_JP_PRP_DTL_SBP','JPM_JP_EDUC_SBP','JPM_JP_COUNTRY_SBP','JPM_JP_CAREER_SBP','JPM_JP_USER_SBP') AND RECNAME IN ('JPM_ITM_PRP_SBR', 'JPM_JP_ITEMS') AND FIELDNAME <> ' ' GROUP BY A.FIELDNAME, A.PNLNAME

# 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 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
3 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

Default Value: 9999