PHRDEDN_YEAR

PHRDEDN.PHRDEDN_YEAR

The year the pay was earned

PHRDEDN_PAYNO

PHRDEDN.PHRDEDN_PAYNO

the month (numerically) the pay was earned within that year.

CLASSIFICATION

pebempl.pebempl_ecls_code

The ECLS code converted to be either Classified, Certificated or Student as defined by PAYROLL.

PHRDEDN_EARNBDCA_CODE

PHRDEDN.PHRDEDN_EARNBDCA_CODEthe

Earn Code the pay is under.The BDCA code for the record in question

PHRDEDN_HRSEMPLOYEE_AMT

PHRDEDN.PHRDEDN_EMPLOYEE_HRSAMT

The Hrs worked for that earn codePHRDEDN_RATEamount the Employee paid into that BDCA code for the PAY Year and Pay Number.

PHRDEDN_EMPLOYER_AMT

PHRDEDN.PHRDEDN_RATEEMPLOYER_AMT

The rate at which those hrs are paid for the position and that earn code.

PHRDEDN_AMT

PHRDEDN.PHRDEDN_AMT

The Amount earned based off multiplying the Hrs and the Rateamount the Employer paid into that BDCA code for the PAY Year and Pay Number.

PTRBDCA_LONG_DESC

PTRBDCA.PTRBDCA_LONG_DESC

The Description of the BDCA code.

SPBPERS_SSN

SPBPERS.SPBPERS_SSN

The SSN of the Employee that earned the money.paid into the BDCA Code

SPRIDEN_LAST_NAME

SPRIDEN.SPRIDEN_LAST_NAME

The last name of the Employee that earned the money.paid into the BDCA Code

SPRIDEN_FIRST_NAME

SPRIDEN.SPRIDEN_FIRST_NAME

The first name of the Employee that earned the money.paid into the BDCA Code

SPRIDEN_MI

SPRIDEN.SPRIDEN_MI

The middle initial/name of the Employee that earned the money.

SUMOFFEDERAL

PHRDEDN.PHRDEDN_EMPLOYEE_AMT

the sum of the amount paid to federal for this income determined by the BDCA code of 800

SUMOFSTATE

PHRDEDN.PHRDEDN_EMPLOYEE_AMT

Tthe sum of the amount paid to state for this income determined by the BDCA code of 801

SUMOFFICA

PHRDEDN.PHRDEDN_EMPLOYEE_AMT

the sum of the amount paid to FICAfor this income determined by the BDCA code of 802

SUMOFMEDI

PHRDEDN.PHRDEDN_EMPLOYEE_AMT

the sum of the amount paid to MEDI for this income determined by the BDCA code of 803

SUMOFRETIREMENT

PHRDEDN.PHRDEDN_EMPLOYEE_AMT

the sum of the amount paid to retirement for this income determined by the BDCA code of 1R1, 1R2, 1R6, 1R7 OR 1R5 as told to us by Payroll

SUMOFTAX_SHELTER

PHRDEDN.PHRDEDN_EMPLOYEE_AMT

the sum of the amount paid to Tax Shelter for this income determined by the BDCA codes 1st character being 9

SUMOFVOL_DED

PHRDEDN.PHRDEDN_EMPLOYEE_AMT

the sum of the amount paid to Tax Shelter for this income determined by the BDCA codes 1st character being 0, 2, 3, 4, 5, 7 or the 1st 2 being 1A,1D,1H OR 1L

SUMOFPHRHIST_GROSS

PHRHIST.PHRHIST_GROSS

the sum of the PHRHIST_GROSS

SUMOFPHRHIST_NET

PHRHIST.PHRHIST_NET

the sum of the PHRHIST_NET

PHRDEDN_PICT_CODE

PHRDEDN.PHRDEDN_PICT_CODE

Used to join the proper PHRDEDN Record and PHRHIST records as well as PHRDEDN and PHREARN records.. Shows up in the data grid because we didn’t exclude it, however is not actually used in the report that was built off this query that Payroll uses.

PHRHIST_TYPE_IND

PHRHIST.PHRHIST_TYPE_IND

This is used as part of the criteria for the data, however is not actually used in the report that was built off this query that Payroll uses.

PHRHIST_EVENT_DATE

PHRHIST.PHRHIST_EVENT_DATE

the date the data was written to the PHRHIST table.

PHRDEDN_SEQ_NO

PHRDEDN.PHRDEDN_SEQ_NO

The sequence number associated with the event

PHREARN_POSN

PHREARN.PHREARN_POSN

The Position this entry is forpaid into the BDCA Code

SSPRIDEN_CHANGE_IND

SPRIDEN.SPRIDEN_CHANGE_IND

the change indicator used to verify the current name information is the current one.

PHRDEDN_APPLICABLE_GROSS

PHRDEDN.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

SPRIDEN.SPRIDEN_ID

The Employee ID of the person that paid into the BDCA code.