PI_DEFN_FILE

(SQL Table)
 Index Back

PYI File definition

Payroll Interface File definition

  • Related Language Record: PI_DEFN_F_LANG

  • Parent Record Of PI_DEFN_RECORD PI_DEFN_R_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PI_FILE_ID Character(6) VARCHAR2(6) NOT NULL Payroll Interface File ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 PI_SYSTEM_ID Character(4) VARCHAR2(4) NOT NULL Payroll Interface System ID

    Prompt Table: PI_SYSTEM_TBL

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

    Default Value: E

    8 PI_FILE_TYPE Character(1) VARCHAR2(1) NOT NULL Payroll Interface File Type
    C=Comma Separated (CSV)
    L=Logical
    O=Other Delimited
    P=Physical
    T=Tab Delimited
    9 PI_RECORD_LEN Number(4,0) SMALLINT NOT NULL PI Record Length
    10 EXT_FLDID_IND Character(1) VARCHAR2(1) NOT NULL External Field ID Indicator

    Y/N Table Edit

    Default Value: N

    11 CONVERT_CASE Character(1) VARCHAR2(1) NOT NULL Convert Case

    Y/N Table Edit

    12 MAX_FLDS_PER_REC Number(3,0) SMALLINT NOT NULL Max Fields Per Output Rec
    13 INCL_HEADER_IND Character(1) VARCHAR2(1) NOT NULL Include Header

    Y/N Table Edit

    14 DATA_DELIMITER Character(1) VARCHAR2(1) NOT NULL Data Delimiter

    Default Value: PI_SYSTEM_TBL.DATA_DELIMITER