HR_EECRS_PAY(SQL View) |
Index Back |
|---|
| SELECT P.COMPANY , P.PAYGROUP , P.PAY_END_DT , E.OFF_CYCLE , E.PAGE_NUM , E.LINE_NUM , E.ADDL_NBR , P.CHECK_DT , P.PERIOD_WEEKS , E.EMPLID , O.ERNCD , E.REG_EARNS , E.REG_EARN_HRS , E.REG_HRLY_EARNS , E.REG_HRS , E.OT_HRLY_EARNS , E.OT_HRS , O.OTH_EARNS , O.OTH_HRS FROM PS_PAY_CALENDAR P , PS_PAY_EARNINGS E LEFT OUTER JOIN PS_PAY_OTH_EARNS O ON O.COMPANY=E.COMPANY AND O.PAYGROUP=E.PAYGROUP AND O.PAY_END_DT=E.PAY_END_DT AND O.OFF_CYCLE=E.OFF_CYCLE AND O.PAGE_NUM=E.PAGE_NUM AND O.LINE_NUM=E.LINE_NUM AND O.ADDL_NBR=E.ADDL_NBR WHERE E.COMPANY = P.COMPANY AND E.PAYGROUP = P.PAYGROUP AND E.PAY_END_DT = P.PAY_END_DT AND E.PAY_LINE_STATUS = 'F' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 3 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 4 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 5 | PAGE_NUM | Number(5,0) | INTEGER NOT NULL | Page Nbr |
| 6 | LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Line Nbr |
| 7 | ADDL_NBR | Number(3,0) | SMALLINT NOT NULL | Additional Pay Line Nbr |
| 8 | CHECK_DT | Date(10) | DATE | Check date. |
| 9 | PERIOD_WEEKS | Number(2,0) | SMALLINT NOT NULL | Weeks in this Period |
| 10 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 11 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 12 | REG_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Regular Earnings |
| 13 | REG_EARN_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Regular Earnings Hours |
| 14 | REG_HRLY_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Regular Hourly Earnings |
| 15 | REG_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Regular Hours |
| 16 | OT_HRLY_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Overtime Hourly Earnings |
| 17 | OT_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Overtime Hours |
| 18 | OTH_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Other Earnings |
| 19 | OTH_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Other hours. |