DP_POLFLD_SELS

(SQL Table)
Index Back

DP_POLFLD_SELS

DP_POLFLD_SELS

  • Related Language Record: DP_PFLDSEL_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET
    2 DP_FIELDID Character(24) VARCHAR2(24) NOT NULL DP_FIELDID
    3 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
    4 DP_DATATYPE Character(1) VARCHAR2(1) NOT NULL DP_DATATYPE
    0=Character
    1=Long Character
    2=Number
    3=Signed Number
    4=Date
    5 DP_AVAILON_IPINQ Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_IPINQ

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: N

    15 DP_AVAILON_PUBIP Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_PUBFCST
    16 DP_AVAILON_PUBINQ Character(1) VARCHAR2(1) NOT NULL DP_AVAILON_WQPURGE