Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field Name

Data Source/Logic

Description (sample)

SPRIDEN_LAST_NAME

SPRIDEN.SPRIDEN_LAST_NAME

The last name of the Employee that paid into the BDCA Code

SPRIDEN_FIRST_NAME

SPRIDEN.SPRIDEN_FIRST_NAME

The first name of the Employee that paid into the BDCA Code

SPRIDEN_ID

SPRIDEN.SPRIDEN_ID

The Employee ID of the person that paid 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.

PHRJOBS_YEAR

PHRJOBS.PHRJOBS_YEAR

The year the pay was earned

PHRJOBS_PAYNO

PHRJOBS.PHRJOBS_PAYNO

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

PHREARN_EARN_CODE

PHREARN.PHREARN_EARN_CODE

The EARN code for the record in question

PHREARN_RATE

PHREARN.PHREARN_RATE

The rate of pay the employee earns

AMOUNT

PHREARN.PHREARN_AMT

The amount the the employee earned

CLASSIFICATION

PHRJOBS.PHRJOBS_ECLS_CODE

The ECLS code converted to Classified or Other.

PTRCALN_FISC_CODE

PTRCALN.PTRCALN_FISC_CODE

The Fiscal year the OT was earned in.

PHREARN_HRS

PHREARN.PHREARN_HRS

The number of hours of OT earned.

PTRCALN_PAYNO

PTRCALN.PTRCALN_PAYNO

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

WC_AMOUNT

.5 * PHREARN.PHREARN_AMT/ 1.5

The Workers Comp Amount

...