Alias: IVPPYD#
The INF_CV_PAYMENTRULES table is used to import the rules for disbursing an employee’s pay into the software data structures. Payment Rules are a date sensitive means of indicating the method(s) by which an employee elects to receive their pay. This may include payment by check, and/or an unlimited number of direct deposits.Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | ||
| ENTITY_CODE | Varchar2(16) | CODE | Y | |
| PERSON_CODE | Varchar2(16) | CODE | Y | |
| EMPLOYMENT_TYPE | Varchar2(30) | VARCHAR30 | ||
| HIRE_DATE | Date() | DATE | ||
| EFFECTIVE | Date() | EFFECTIVE | Y | |
| EXPIRY | Date() | EXPIRY | Y | |
| CHANGE_CODE | Varchar2(16) | CODE | ||
| PAYMENT_RULE_TYPE | Varchar2(30) | VARCHAR30 | Y | |
| COUNTRY_CODE | Varchar2(16) | CODE | ||
| BANK_TRANSIT_CODE | Varchar2(16) | CODE | ||
| BANK_ACCOUNT | Varchar2(30) | VARCHAR30 | ||
| BANK_ACCOUNT_TYPE | Varchar2(30) | VARCHAR30 | ||
| SPLIT_SEQUENCE | Number(5) | NUMBER5 | ||
| AMOUNT | Number(18) | AMT12V6 | ||
| NET_PAY_PERCENT | Number(5) | PERCENT | ||
| PAY_REMAINING | Varchar2(4) | VARCHAR4 | ||
| PAID_TO_ORDER_OF | Varchar2(50) | VARCHAR50 | ||
| DEPOSIT_START_DATE | Date() | DATE | ||
| PRENOTE_REQUIRED | Varchar2(4) | VARCHAR4 | ||
| PRENOTE_DATE | Date() | DATE | ||
| BANK_TRANSIT_CODE_PAYBY | Varchar2(16) | CODE | ||
| BANK_ACCOUNT_PAYBY | Varchar2(30) | VARCHAR30 | ||
| PRIME_DEPOSIT | Varchar2(4) | VARCHAR4 | ||
| CREATE_DATE | Date() | DATE | ||
| CREATE_USER | Varchar2(30) | VARCHAR30 | ||
| CHANGE_DATE | Date() | DATE | ||
| CHANGE_USER | Varchar2(30) | VARCHAR30 |
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation