...
Field Name | Data Source/Logic | Description (sample) | ||
|---|---|---|---|---|
PHRDEDNSPRIDEN_LAST_NAME |
| The last name of the Employee | ||
SPRIDEN_FIRST_NAME |
| The first name of the Employee | ||
SPRIDEN_ID |
| The Employee ID of the person | ||
SSPRIDEN_CHANGE_IND |
| the change indicator used to verify the current name information is the current one. | ||
PHRJOBS_YEAR |
| The year the pay was earned | ||
PHRDEDNPHRJOBS_PAYNO |
| the month (numerically) the pay was earned within that year. | ||
PHRDEDNPHREARN_BDCAEARN_CODE |
| The BDCA EARN code for the record in question | ||
PHRDEDNPHREARN_EMPLOYEE_AMTRATE |
| The amount the Employee paid into that BDCA code for the PAY Year and Pay Number. | PHRDEDN_EMPLOYER_AMT | PHRDEDN.PHRDEDN_EMPLOYER_rate of pay the employee earns |
AMOUNT |
| The amount the Employer paid into that BDCA code for the PAY Year and Pay Number. | ||
PTRBDCA_LONG_DESC |
| The Description of the BDCA code. | ||
SPBPERS_SSN |
| The SSN of the Employee that paid into the BDCA Code | ||
SPRIDEN_LAST_NAME |
| The last name of the Employee that paid into the BDCA Code | ||
SPRIDEN_FIRST_NAME |
| The first name of the Employee that paid into the BDCA Code | ||
SPRIDEN_MI |
| The middle initial/name of the Employee that paid into the BDCA Code | ||
SSPRIDEN_CHANGE_IND |
| the change indicator used to verify the current name information is the current one. | ||
PHRDEDN_APPLICABLE_GROSS |
| The Gross amount isn’t actually used in the report section and is left in the query as to not change the query in case it messes something up. | ||
SPRIDEN_ID |
| The Employee ID of the person that paid into the BDCA code.the employee earned | ||
CLASSIFICATION |
| The ECLS code converted to Classified or Other. | ||
PTRCALN_FISC_CODE |
| The Fiscal year the OT was earned in. | ||
PHREARN_HRS |
| The number of hours of OT earned. | ||
PTRCALN_PAYNO |
| the month (numerically) the pay was earned within that year. | ||
WC_AMOUNT | .5 * PHREARN.PHREARN_AMT/ 1.5 | The Workers Comp Amount |
🗺 Report Domain
This report is built off SPRIDEN SPBPERS and SPRIDEN tables for the person information, and the PHRDEDN and PTRBDCA PTRCALN, PHREARN, PHRJOBS, and tables for the Amount paid into the BDCA code as well as the description of the code. It comes from Oracle PROD_DB because I am told they need live data.
...