Alias: SWSE#
Unique Keys: _Child Table: _
Parent Table: _
Experience Rules
Table Columns#
Column name | Data Type / Size | Domain | Mand. | Notes |
---|---|---|---|---|
ID | Number(10) | ID | Y | |
SWSR_ID | Number(10) | ID | Y | link to P2K_SA_WAGE_STEP_RULES |
EXPERIENCE_TYPE | Varchar2(2) | X_EXPERIENCE_TYPE | Y | |
PEL_ID_ELIGIBLE | Number(10) | ID | link to P2K_PR_ELEMENTS | |
PEL_ID_WORKED | Number(10) | ID | link to P2K_PR_ELEMENTS | |
PEL_ID_ABSENT | Number(10) | ID | link to P2K_PR_ELEMENTS | |
CREATE_DATE | Date() | DATE | Y | |
CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
CHANGE_DATE | Date() | DATE | Y | |
CHANGE_USER | Varchar2(30) | VARCHAR30 | Y | |
ALLOW_WAGE_STEPPING | Varchar2(1) | TOGGLE | ||
NO_CARRY_FORWARD | Varchar2(1) | TOGGLE |
User Fields: Allowed
Audit Logging: Not Allowed