Alias: PPCD#
(P2K_PR_PC_DETAILS)Unique Keys:
Child Table:
Parent Table:
ERD: ERD-PR10
Pc Details
Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | Y | |
| PPCR_ID | Number(10) | ID | Y | link to P2K_PR_PC_RULES |
| PPC_ID | Number(10) | ID | Y | link to P2K_PR_PAY_COMPONENTS |
| PEL_ID | Number(10) | ID | link to P2K_PR_ELEMENTS | |
| DSC_ID | Number(10) | ID | link to P2K_CM_STATISTIC_COMPONENTS | |
| MVR_ID | Number(10) | ID | link to P2K_AM_USER_VARIABLES | |
| PC_DETAIL_TYPE | Varchar2(2) | X_PC_DETAIL_TYPE | Y | |
| CREATE_DATE | Date() | DATE | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | Date() | DATE | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y | |
| PC_CALC_METHOD | Varchar2(2) | X_PC_CALC_METHOD | ||
| PC_RATE_SOURCE | Varchar2(2) | X_PC_RATE_SOURCE | ||
| ENTER_RATE | Varchar2(1) | TOGGLE | ||
| ENTER_VALUE | Varchar2(1) | TOGGLE | ||
| ENTER_USER_VARIABLE | Varchar2(1) | TOGGLE | ||
| ENTER_ELEMENT | Varchar2(1) | TOGGLE | ||
| ENTER_DISTRIBUTION | Varchar2(1) | TOGGLE | ||
| HIGHER_OF_RATE | Varchar2(1) | X_HIGHER_OF_RATE | ||
| HIGHEST_RATE_OF_DAY | Varchar2(2) | X_HIGHEST_RATE_OF_DAY | ||
| CUSTOM_RATE_LOGIC | Varchar2(2) | X_CUSTOM_RATE_LOGIC | ||
| SALARY_RATE_METHOD | Varchar2(2) | X_SALARY_RATE_METHOD |
User Fields: Allowed
Audit Logging: Allowed
