PI_CHECK

(SQL Table)
 Index Back

PI Imported Check Data

Payroll Interface Import Check Data

  • Parent Record Of PI_DED_DETAIL PI_EARN_DETAIL PI_TAX_DETAIL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PI_RUN_NUM Number(4,0) SMALLINT NOT NULL Payroll Interface Run Number

    Prompt Table: PI_RUN_TBL

    2 PI_SYSTEM_ID Character(4) VARCHAR2(4) NOT NULL Payroll Interface System ID

    Prompt Table: PI_SYSTEM_TBL

    3 PI_CONFIG_ID Character(6) VARCHAR2(6) NOT NULL PI Configuration ID
    4 PI_PAY_GROUP1 Character(6) VARCHAR2(6) NOT NULL PI Paygroup 1
    5 PI_PAY_GROUP2 Character(6) VARCHAR2(6) NOT NULL PI Paygroup 2
    6 PI_EMPLID Character(20) VARCHAR2(20) NOT NULL Payroll Interface EMPLID
    7 PAY_END_DT Date(10) DATE Pay Period End Date
    8 PI_CHECK_NBR Character(10) VARCHAR2(10) NOT NULL Payroll Check Number
    9 PI_CHECK_TYPE Character(4) VARCHAR2(4) NOT NULL Payroll Check Type
    10 PI_CHECK_CODE Character(4) VARCHAR2(4) NOT NULL Payroll Check Code
    11 PI_VOID_IND Character(4) VARCHAR2(4) NOT NULL Payroll Void Check Indicator
    12 PI_TAX_METHOD Character(4) VARCHAR2(4) NOT NULL Payroll Tax Calc Method
    13 PI_PAY_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Payroll Pay Frequency
    14 PI_NAME_LAST Character(30) VARCHAR2(30) NOT NULL PI Employee Last Name
    15 PI_NAME_FIRST Character(30) VARCHAR2(30) NOT NULL PI Employee First Name
    16 CHECK_DT Date(10) DATE Check date.
    17 PI_TOTAL_GROSS Signed Number(20,3) DECIMAL(18,3) NOT NULL Total Gross
    18 PI_TOTAL_DEDUCT Signed Number(20,3) DECIMAL(18,3) NOT NULL Total Deductions
    19 PI_TOTAL_TAXES Signed Number(20,3) DECIMAL(18,3) NOT NULL Total Taxes
    20 PI_NET_PAY Signed Number(20,3) DECIMAL(18,3) NOT NULL Net Py
    21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    22 PI_CHECK_KEY1 Character(10) VARCHAR2(10) NOT NULL User Defined Search Key 1
    23 PI_CHECK_KEY2 Character(10) VARCHAR2(10) NOT NULL User Defined Search Key 2
    24 PI_CHECK_FLD1 Character(10) VARCHAR2(10) NOT NULL User Defined Data Field 1
    25 PI_CHECK_FLD2 Character(10) VARCHAR2(10) NOT NULL User Defined Data Field 2
    26 PI_CHECK_FLD3 Character(10) VARCHAR2(10) NOT NULL User Defined Data Field 3
    27 PI_CHECK_FLD4 Character(10) VARCHAR2(10) NOT NULL User Defined Data Field 4
    28 PI_CHECK_FLD5 Character(10) VARCHAR2(10) NOT NULL User Defined Data Field 5
    29 PI_CHECK_AMT1 Signed Number(20,3) DECIMAL(18,3) NOT NULL User Defined Amount 1
    30 PI_CHECK_AMT2 Signed Number(20,3) DECIMAL(18,3) NOT NULL User Defined Check Amount 2
    31 PI_CHECK_RT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL User Defined Check Rate 1