DP_FIELDSEL1_VW

(SQL View)
 Index Back

Demand History Inquiry

Date Initials Reference # Description 12/29/09 TH ICE 1949616000 Use Source Code field instead of Source Cd for Review Demand History

SELECT DP_FIELDID , DP_CAPTION , DP_DATATYPE FROM PS_DP_FIELD_SELS WHERE DP_AVAILON_DHISINQ = 'Y' AND DP_FIELDID <> 'SOURCE_CD' OR DP_FIELDID = 'SOURCE_CODE'

  • Related Language Record: DP_FIELDSEL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_FIELDID Character(24) VARCHAR2(24) NOT NULL DP_FIELDID
    2 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
    3 DP_DATATYPE Character(1) VARCHAR2(1) NOT NULL DP_DATATYPE
    0=Character
    1=Long Character
    2=Number
    3=Signed Number
    4=Date