OPRIDRUN_CNTL_IDCOMPANYPrompt Table: COMPANY_TBL
EMPLIDPrompt Table: PERSON
WAGE_LOSS_PLANPrompt Table: WAGELS_PLAN_TBL
UI_PAYABLE_DTROE_SEQREASONR_PAY101CN(SQL Table) |
Index Back |
|---|---|
CAN ROE Print ExceptionsCanadian Record of Employment exceptions generated by the ROE Print process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 5 | WAGE_LOSS_PLAN |
Character(3) | VARCHAR2(3) NOT NULL |
Wage Loss Replacement Plan
Prompt Table: WAGELS_PLAN_TBL |
| 6 | UI_PAYABLE_DT |
Date(10) | DATE NOT NULL | Date EI Payable |
| 7 | ROE_SEQ |
Number(1,0) | SMALLINT NOT NULL | ROE Sequence Number |
| 8 | REASON |
Character(30) | VARCHAR2(30) NOT NULL | Reason |