DP_ANALFLDS_VW

(SQL View)
 Index Back

View of the PSANALFIELDS

SELECT DP_PSAPPS_FIELDID , DP_CAPTION , DP_FIELDLENGTH FROM PS_DP_PSANALFIELDS WHERE DP_VALIDINDP = 'Y' AND DP_VALIDINIP = 'Y' AND (DP_FIELDTYPE = '1' OR DP_FIELDTYPE = '2')

SELECT DP_PSAPPS_FIELDID , DP_CAPTION , DP_FIELDLENGTH , DP_FIELDTYPE , DP_VALIDINDP , DP_VALIDINIP FROM PS_DP_PSANALFIELDS WHERE DP_VALIDINDP = 'Y' OR DP_VALIDINIP = 'Y' AND (DP_FIELDTYPE = '1' OR DP_FIELDTYPE = '2')

  • Related Language Record: DP_ANALFLDS_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_PSAPPS_FIELDID Character(18) VARCHAR2(18) NOT NULL DP_PSAPPS_FIELDID
    2 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
    3 DP_FIELDLENGTH Number(2,0) SMALLINT NOT NULL DP_FIELDLENGTH
    4 DP_FIELDTYPE Character(1) VARCHAR2(1) NOT NULL DP_FIELDTYPE
    1=Character
    2=Numeric
    5 DP_VALIDINDP Character(1) VARCHAR2(1) NOT NULL DP_VALIDINDP

    Y/N Table Edit

    Default Value: N

    6 DP_VALIDINIP Character(1) VARCHAR2(1) NOT NULL DP_VALIDINIP

    Y/N Table Edit

    Default Value: N