PI_PS_RECORD

(SQL Table)
 Index Back

PI Peoplesoft record

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

  • Related Language Record: PI_PS_REC_LANG

  • Parent Record Of PI_PSREC_FLD PI_PS_REC_VW

    • # 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: RECDEFN_VW

    3 PI_PROCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Process Type
    B=Export/Import
    E=Export
    I=Import

    Default Value: E

    4 DESCRLONG Long Character CLOB Long Description
    5 SELECT_WHERE_TYPE Character(2) VARCHAR2(2) NOT NULL Where Clause Type
    ED=ID, EffDt = Pay End Dt
    EE=ID and Active EffDt
    EI=Empl ID
    EM=ID, all EffDts
    ES=ID, All EffDts , Active EffSeq
    EX=ID, Active EffDt Active EffSeq

    Default Value: EI

    6 INCLD_CO_IN_WHERE Character(1) VARCHAR2(1) NOT NULL Paygroup Company in Where

    Y/N Table Edit

    Default Value: N

    7 INCLD_CNTRY_WHERE Character(1) VARCHAR2(1) NOT NULL Paygroup Country in Where

    Y/N Table Edit

    Default Value: N

    8 DATA_REQUIRED Character(1) VARCHAR2(1) NOT NULL Data Required

    Y/N Table Edit

    Default Value: N

    9 JOB_DATA Character(1) VARCHAR2(1) NOT NULL Job Data

    Y/N Table Edit

    Default Value: N

    10 DED_CALC_DATA Character(1) VARCHAR2(1) NOT NULL Ded Calc Data

    Y/N Table Edit

    Default Value: N