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 |
