DP_FIELD_SELS

(SQL Table)
Index Back

System Table

  • Related Language Record: DP_FLDSELS_LNG
  • Parent Record Of DPA_INQFORMLINE DP_INQFORMLINES DP_IPINQFORMLIN
  • # 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
    4 DP_ISUDFLD Character(1) VARCHAR2(1) NOT NULL DP_ISUDFLD

    Y/N Table Edit

    5 DP_ISVIEWINFO Character(1) VARCHAR2(1) NOT NULL DP_ISVIEWINFO

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N

    7 DP_AVAILON_MAMAINT Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_MAMAINT

    Y/N Table Edit

    Default Value: N

    8 DP_AVAILON_POLSETS Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_POLSETS

    Y/N Table Edit

    Default Value: N

    9 DP_AVAILON_FCINQ Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_FCINQ

    Y/N Table Edit

    Default Value: N

    10 DP_AVAILON_FCITCAP Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_FCITCAP

    Y/N Table Edit

    11 DP_AVAILON_FCREF Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_FCREF

    Y/N Table Edit

    12 DP_AVAILON_ERRSEL Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_ERRSEL

    Y/N Table Edit

    13 DP_AVAILON_ARTOUSE Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_ARTOUSE

    Y/N Table Edit

    14 DP_AVAILON_ADJHIST Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_ADJHIST

    Y/N Table Edit

    15 DP_AVAILON_SUMM Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_SUMM

    Y/N Table Edit

    16 DP_AVAILON_EVINQ Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_EVINQ

    Y/N Table Edit

    17 DP_AVAILON_FCINQCH Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_FCINQCH

    Y/N Table Edit

    18 DP_AVAILON_ADJCHRT Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_ADJCHRT

    Y/N Table Edit

    19 DP_AVAILON_EIFCI Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_EIFCI

    Y/N Table Edit

    20 DP_AVAILON_FUNCAUD Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_FUNCAUD

    Y/N Table Edit

    21 DP_AVAILON_ROLESEC Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_ROLESEC

    Y/N Table Edit

    22 DP_AVAILON_EIUPD Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_EIUPD

    Y/N Table Edit

    23 DP_AVAILON_PUBFCST Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_PUBFCST

    Y/N Table Edit

    24 DP_AVAILON_PUBFLTR Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_PUBFLTR

    Y/N Table Edit

    25 DP_AVAILON_PUBARAY Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_PUBFLTR

    Y/N Table Edit

    Default Value: N

    26 DP_AVAILON_WQPURGE Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_WQPURGE

    Y/N Table Edit

    27 DP_AVAILON_BAMSPEC Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_BAMSPEC

    Y/N Table Edit

    28 DP_AVAILON_INTADJ Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_INTADJ

    Y/N Table Edit

    29 DP_AVAILON_INTDMD Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_INTDMD

    Y/N Table Edit

    30 DP_AVAILON_INTFCI Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_INTFCI

    Y/N Table Edit

    31 DP_AVAILON_INTUP Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_INTUP

    Y/N Table Edit

    32 DP_AVAILON_AHISSEL Character(1) VARCHAR2(1) NOT NULL Adjustment History

    Y/N Table Edit

    33 DP_AVAILON_BPPUB Character(1) VARCHAR2(1) NOT NULL Publish for Business Planning

    Y/N Table Edit

    34 DP_AVAILON_PUBINQ Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_WQPURGE

    Y/N Table Edit

    35 DP_AVAILON_DPIFACE Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_ARTOUSE
    36 DP_AVAILON_MMSELCT Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_CSUMG

    Y/N Table Edit

    Default Value: N

    37 DP_AVAILON_DHISINQ Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_CSUMG
    38 DP_AVAILON_DYNREL Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_PUBFLTR

    Y/N Table Edit

    Default Value: N

    39 DP_AVAILON_PRORATE Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_SUMM
    40 DP_AVAILON_IIMP Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_CSUMG

    Default Value: N

    41 DP_AVAILON_EIMPADJ Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_CSUMG

    Default Value: N

    42 DP_AVAILON_EIMPDMD Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_CSUMG

    Default Value: N

    43 DP_AVAILON_EIMPFCI Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_CSUMG

    Default Value: N

    44 DP_AVAILON_EIMPUPD Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_CSUMG

    Default Value: N