ROE_SPECIAL_PAY(SQL Table) |
Index Back |
|---|---|
CAN ROE Special PaymentsInformation for the special payments (Block 19) to be included for an employee that are reportable on the ROE. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 3 | WAGE_LOSS_PLAN |
Character(3) | VARCHAR2(3) NOT NULL |
Wage Loss Replacement Plan
Prompt Table: WAGELS_PLAN_TBL |
| 4 | UI_PAYABLE_DT |
Date(10) | DATE NOT NULL | Date EI Payable |
| 5 | ROE_SEQ |
Number(1,0) | SMALLINT NOT NULL | ROE Sequence Number |
| 6 | PD_LEAVE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Pay Leave Type
M=Maternity/Parent/Comp Care/FC P=Paid Sick Leave R=Wage Loss Insurance (ROE Ins) W=Wage Loss Insurance (Not Ins) |
| 7 | PD_LEAVE_START_DT | Date(10) | DATE | Paid Leave Start Date |
| 8 | PD_LEAVE_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Paid Leave Amount |
| 9 | PD_LEAVE_INTERVAL | Character(1) | VARCHAR2(1) NOT NULL |
Paid Leave Interval
D=Daily W=Weekly |