PAY_DISTRIBUTN

(SQL Table)
 Index Back

Payroll Deposit Distribution

This record contains the details of an emplooyees direct deposit advices.

  • Parent record: PAY_CHECK

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

    Y/N Table Edit

    5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #

    Prompt Table: PAY_PAGE

    6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #

    Prompt Table: PAY_LINE

    7 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.

    Prompt Table: PAY_CHECK

    8 PRIORITY Number(3,0) SMALLINT NOT NULL Priority
    9 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
    10 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
    11 ACCOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Account Type
    $=Issue Check
    C=Checking
    L=Liability
    N=Non Applicable
    S=Savings
    X=Expense
    12 ACCOUNT_NUM Character(17) VARCHAR2(17) NOT NULL Account Number
    13 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
    14 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID
    15 DEPOSIT_AMOUNT Number(11,2) DECIMAL(10,2) NOT NULL Deposit Amount