PTFP_PARMS

(SQL Table)
Index Back

Feed Data Source Parameters

  • Related Language Record: PTFP_PARMS_LANG
  • Parent record: PTFP_FEED
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTFP_FEED_ID Character(30) VARCHAR2(30) NOT NULL Feed ID (see PSFP_FEED).

    Prompt Table: PTFP_FEED

    2 PTFP_FIELD_NAME Character(40) VARCHAR2(40) NOT NULL Field Name
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 PTFP_USAGE_TYPE Character(3) VARCHAR2(3) NOT NULL Usage Type
    ADM=Admin Specified
    FIX=Fixed
    INT=Internal Use
    NOT=Not Used
    SYS=System Variable
    USR=User Specified
    5 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

    Y/N Table Edit

    6 PTFP_VALUE Character(254) VARCHAR2(254) NOT NULL Default Value
    7 ORDERNO Number(5,0) INTEGER NOT NULL Sort Order