COMPANYPrompt Table: COMPANY_TBL
PAYGROUPPrompt Table: PAYGROUP_TBL
EMPLIDPAY_CHK_MOD_VW(SQL View) |
Index Back |
|---|---|
U.S. Pay Check View SummaryThis record contains emplooyee paycheck key information. |
| SELECT DISTINCT A.COMPANY ,A.PAYGROUP ,A.EMPLID ,A.NAME FROM PS_PAY_CHECK A ,PS_PAY_EARNINGS B ,PS_PAYGROUP_TBL C WHERE A.COMPANY=B.COMPANY AND A.PAYGROUP=B.PAYGROUP AND A.PAY_END_DT=B.PAY_END_DT AND A.OFF_CYCLE=B.OFF_CYCLE AND A.PAGE_NUM=B.PAGE_NUM AND A.LINE_NUM=B.LINE_NUM AND A.SEPCHK=B.SEPCHK AND B.PAY_LINE_STATUS IN ('C','F','V') AND A.COMPANY=C.COMPANY AND A.PAYGROUP=C.PAYGROUP AND C.COUNTRY<>'CAN' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |