PI_PSREC_FLD

(SQL Table)
 Index Back

PI Peoplesoft Field Definition

Payroll Interface Peoplesoft Field Definition. The Peoplesoft field IDs listed in this table are the only ones available for the Payroll Interface Export process.

  • Parent record: PI_PS_RECORD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PI_SYSTEM_ID Character(4) VARCHAR2(4) NOT NULL Payroll Interface System ID

    Prompt Table: PI_SYSTEM_TBL

    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PI_RECFLD_VW

    3 PI_PROCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Process Type
    B=Export/Import
    E=Export
    I=Import
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: ZZZ_PI_RCFLD_VW

    5 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    6 KEY_FIELD_IND Character(1) VARCHAR2(1) NOT NULL Key Field Indicator

    Y/N Table Edit

    Default Value: N

    7 EFFDT_IND Character(1) VARCHAR2(1) NOT NULL Effective Date
    0=No
    1=Yes

    Y/N Table Edit

    Default Value: N

    8 EFFSEQ_IND Character(1) VARCHAR2(1) NOT NULL Effective Sequence

    Y/N Table Edit

    Default Value: N

    9 ORDER_BY_SEQ Number(2,0) SMALLINT NOT NULL Order by Sequence
    10 COLLATE_ORDER Character(1) VARCHAR2(1) NOT NULL Collate Order
    A=Ascending
    D=Descending