EMP_PAYMENT_TYPEC=Check
D=Direct Deposit
Z=Total:
PAYCHECK_NBR$=Issue Check
C=Checking
L=Liability
N=Non Applicable
S=Savings
X=Expense
PY_IC_PI_DISTRB(SQL Table) |
Index Back |
|---|---|
WEB - Paychk Rvw -DistributionRecord created to support WEB-enabled Paycheck Review. This record contains the paycheck distribution information. It will be used to show the user how payment was made to him (which account, how much, check# and so on). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMP_PAYMENT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Employee Payment Type
C=Check D=Direct Deposit Z=Total: |
| 2 | PRIORITY | Number(3,0) | SMALLINT NOT NULL | Priority |
| 3 | PAYCHECK_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Paycheck number. |
| 4 | ACCOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Account Type
$=Issue Check C=Checking L=Liability N=Non Applicable S=Savings X=Expense |
| 5 | ACCOUNT_NUM | Character(17) | VARCHAR2(17) NOT NULL | Account Number |
| 6 | DEPOSIT_AMOUNT | Number(11,2) | DECIMAL(10,2) NOT NULL | Deposit Amount |