OPRIDEMPLIDPrompt Table: PERS_SRCH_GBL
C=Complete
D=Delete
F=XML File Failed
G=Generate
H=Hold
R=XML File Rejected
X=XML File Created
UI_PAYABLE_DTROE_SRCH(SQL View) |
Index Back |
|---|---|
Search Vw-CAN ROESearch view for Record-of-Employment tables. |
| SELECT B.OPRID ,B.ROWSECCLASS ,B.EMPLID ,B.NAME ,A.ROE_PROCESS ,A.ROE_NBR ,A.ROE_SERIAL_NUM ,C.NATIONAL_ID ,A.UI_PAYABLE_DT ,A.ROE_DT FROM PS_ROE A ,PS_PERS_SRCH_GBL B ,PS_PERS_NID C ,PS_PAYGROUP_TBL D WHERE A.EMPLID=B.EMPLID AND B.EMPLID=C.EMPLID AND C.COUNTRY = 'CAN' AND C.NATIONAL_ID_TYPE = 'PR' AND A.COMPANY = D.COMPANY AND A.PAYGROUP = D.PAYGROUP AND A.UI_PAYABLE_DT >= ( SELECT MAX(E.EFFDT) FROM PS_PAYGROUP_TBL E WHERE E.COMPANY = A.COMPANY AND E.PAYGROUP = A.PAYGROUP AND E.EFFDT <= A.UI_PAYABLE_DT AND E.EFF_STATUS = 'A' AND C.COUNTRY = E.COUNTRY) |
| # | 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 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | ROE_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
ROE Process
C=Complete D=Delete F=XML File Failed G=Generate H=Hold R=XML File Rejected X=XML File Created |
| 6 | ROE_NBR | Character(8) | VARCHAR2(8) NOT NULL | Internal ROE Number |
| 7 | ROE_SERIAL_NUM | Character(9) | VARCHAR2(9) NOT NULL | ROE Serial Number |
| 8 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 9 | UI_PAYABLE_DT |
Date(10) | DATE | Date EI Payable |
| 10 | ROE_DT | Date(10) | DATE | ROE Date Created/Completed |