PSIMPFIELD

(SQL Table)
Index Back

Import Field

  • Parent record: PSIMPDEFN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IMPNAME Character(18) VARCHAR2(18) NOT NULL Import Definition Name (see PSIMPDEFN).
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    3 STARTLOC Number(5,0) INTEGER NOT NULL Start Location
    4 LENGTH Number(5,0) INTEGER NOT NULL Length
    5 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    6 DATETYPE Number(2,0) SMALLINT NOT NULL Date Type
    7 BYPASS Number(5,0) INTEGER NOT NULL Bypass
    8 IMPDEFAULT Character(18) VARCHAR2(18) NOT NULL Import Default
    9 XLATCOUNT Number(5,0) INTEGER NOT NULL Import Translate Count