DP_PUBSPEC_LNS

(SQL Table)
 Index Back

Sub Table to DP_PUBSPEC_HDR

  • Parent record: DP_PUBSPEC_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

    Prompt Table: DP_VIEW1USER_VW

    2 DP_EXPORTSPEC Character(20) VARCHAR2(20) NOT NULL DP_EXPORTSPEC Date Initials Reference # Description 12/21/09 MP NK-22 Translation Add new label to used in translation

    Prompt Table: DP_PUBSPEC_HDR

    3 DP_SEQNUMBER Number(10,0) DECIMAL(10) NOT NULL MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.
    4 DP_OUTPUTFLD Character(24) VARCHAR2(24) NOT NULL DP_OUTPUTFLD

    Prompt Table: DP_VWFLDSE21_VW

    5 DP_DATATYPE Character(1) VARCHAR2(1) NOT NULL DP_DATATYPE
    0=Character
    1=Long Character
    2=Number
    3=Signed Number
    4=Date