DP_EISPECA_VWS

(SQL Table)
Index Back

Sub table to DP_EISPECD_HDR

Contains the 5 views for this spec. Is parent to DP_EISPECD_FLTER, which holds the fields in the 5 views to select by.

  • Parent record: DP_EISPECA_HDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_IMPORTSPEC Character(20) VARCHAR2(20) NOT NULL Specification used for running imports
    2 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

    Prompt Table: DP_SI_VW1USR_VW

    3 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
    4 DP_DESCRIPTION Character(120) VARCHAR2(120) NOT NULL Description
    5 DP_ROLLUPADJ Character(1) VARCHAR2(1) NOT NULL DP_ROLLUPADJ

    Y/N Table Edit

    Default Value: DP_CONFIGVIEWS.DP_ROLLUPADJ