DP_VWKYFLDS_VW

(SQL View)
Index Back

Join Key Fields to View

Join Key Fields to Forecast View

SELECT CF.DP_CONFIGVIEW , DF.DP_USERDATACODE , CF.DP_CONFIGLEVEL , CF.DP_INVISIBLE , CF.DP_CONFIGFIELDSEQ , CF.DP_FIELDID , DF.DP_PSAPPS_FIELDID FROM PS_DP_CONFIGLVLFLD CF , PS_DP_USERDATAFLDS DF WHERE CF.DP_FIELDID = DF.DP_FIELDID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
2 DP_USERDATACODE Character(20) VARCHAR2(20) NOT NULL DP_USERDATACODE
3 DP_CONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_CONFIGLEVEL
4 DP_INVISIBLE Character(1) VARCHAR2(1) NOT NULL DP_INVISIBLE
5 DP_CONFIGFIELDSEQ Number(5,0) INTEGER NOT NULL DP_CONFIGFIELDSEQ
6 DP_FIELDID Character(24) VARCHAR2(24) NOT NULL DP_FIELDID
7 DP_PSAPPS_FIELDID Character(18) VARCHAR2(18) NOT NULL DP_PSAPPS_FIELDID