PY_IC_PI_ERN_VW(SQL View) |
Index Back |
|---|---|
WEB-PayChk Rvw EarningsThis view has been created for the WEB Paycheck Review. It is based on the PAY_EARNINGS record. It contains payroll affecting information such as earnings, hours, location, tax information, etc. Each pay earning record may have one or more subordinate Pay Other Earnings record(s). A view was created to shield the user from base-record peopleocode getting executed. Changes made to the record PAY_EARNINGS would need to be analyzed and made to W3PY_CHK_ERN_VW, if necessary. |
| SELECT COMPANY , PAYGROUP , PAY_END_DT , OFF_CYCLE , PAGE_NUM , LINE_NUM , ADDL_NBR , SEPCHK , HOURLY_RT , ERNCD_REG_HRS , ERNCD_OT_HRS , REG_HRS , OT_HRS , REG_HRLY_EARNS , OT_HRLY_EARNS , ERNCD_REG_EARNS , REG_EARNS , REG_EARN_HRS , STATE , COMP_RATECD_REG , COMP_RATECD_OT , COMPRATE_USED_REG , COMPRATE_USED_OT , SHIFT_RT , RATE_USED , EARNS_BEGIN_DT , EARNS_END_DT , FLSA_STATUS FROM PS_PAY_EARNINGS |
| # | 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 NOT NULL | Pay Period End Date |
| 4 | OFF_CYCLE |
Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit Default Value: N |
| 5 | PAGE_NUM |
Number(4,0) | SMALLINT NOT NULL | Page # |
| 6 | LINE_NUM |
Number(2,0) | SMALLINT NOT NULL | Line # |
| 7 | ADDL_NBR |
Number(3,0) | SMALLINT NOT NULL | Additional Pay Line # |
| 8 | SEPCHK | Number(1,0) | SMALLINT NOT NULL | Separate check number. |
| 9 | HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
| 10 | ERNCD_REG_HRS | Character(3) | VARCHAR2(3) NOT NULL |
Regular Hours Earnings Type
Default Value: PAYGROUP_TBL.ERNCD_REG_HRS |
| 11 | ERNCD_OT_HRS | Character(3) | VARCHAR2(3) NOT NULL | OT Hours Earnings Type |
| 12 | REG_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Regular Hours |
| 13 | OT_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Overtime Hours |
| 14 | REG_HRLY_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Regular Hourly Earnings |
| 15 | OT_HRLY_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Overtime Hourly Earnings |
| 16 | ERNCD_REG_EARNS | Character(3) | VARCHAR2(3) NOT NULL |
Regular Earns Earnings Type
Default Value: PAYGROUP_TBL.ERNCD_REG_EARNS |
| 17 | REG_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Regular Earnings |
| 18 | REG_EARN_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Regular Earnings Hours |
| 19 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 20 | COMP_RATECD_REG | Character(6) | VARCHAR2(6) NOT NULL | Regular Comp Rate Code |
| 21 | COMP_RATECD_OT | Character(6) | VARCHAR2(6) NOT NULL | Overtime Comp Rate Code |
| 22 | COMPRATE_USED_REG | Number(19,6) | DECIMAL(18,6) NOT NULL | Comp Rate Used for Regular |
| 23 | COMPRATE_USED_OT | Number(19,6) | DECIMAL(18,6) NOT NULL | Comp Rate Used for Overtime |
| 24 | SHIFT_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Shift Differential Rate |
| 25 | RATE_USED | Character(1) | VARCHAR2(1) NOT NULL |
Rate Used
A=Alternative Rate F=FLSA Rate H=Hourly Rate |
| 26 | EARNS_BEGIN_DT | Date(10) | DATE | Earnings Begin Date |
| 27 | EARNS_END_DT | Date(10) | DATE | Earnings End Date |
| 28 | FLSA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
FLSA Status field
A=Administrative C=Computer Employee E=Executive H=Highly Compensated Employees M=Management N=Nonexempt O=Outside Salesperson P=Professional V=Nonexempt Alt Overtime X=No FLSA Required |