MSA Pay Hist for Avg Salary .us



CT_CORE_HR_PAY_PRIOR_TO_PS

Purpose of Query

MSA Pay Hist for Avg Salary - This Query retrieves historical MSA payroll data to determine the employee's average salary for the previous 52 weeks for workers compensation calculations. Employee payroll data is for check date 1-29-1999 through 11-7-2003. The user must enter the Employee ID and a date range.

Payroll data is prior to the use of CORE-CT. The first CORE-CT pay period is pay period end date 10-30-2003.

Folder

WC

Tables

Top Level:

CT_HIST_TOTALS

Join CT_HIST_EMPL

Union CT_HIST_TOTALS

Union CT_HIST_EMPL

Union CT_HIST_DOE

Note: A JOIN is an SQL command that is used to relate two or more data tables (Records in PeopleSoft) based on the use of related (key) fields from one table to the next. Once joined, data can be retrieved without repeating all of the data in every table.

Note: A Union query combines the results of two or more queries into a single result set that includes all the rows that belong to all queries in the union. The two queries must have the same number of columns and compatible data types to unite.

Prompts

Employee ID= - (Equal to)

Beginning Check Date = / Last Check Date = – (Between condition)

Sample Results

Please note, due to page size limitations, sample results may be incomplete.

[pic]

Criteria

CT_CUR_REG_GRS greater than 0

CT_DOE_CURR_AMT greater than 0

CT_DOE_DESC_CD in list

('01','04','05','06','08','09','1A','1B','1D','1E','1F','1G','1H','1J','1K','1L','1M','1R','1S','1T','1W','10','11','12','13','14','15','17','18','19','2B','2C','2D','2E','2F','2J','2K','2L','2X','2Y','2Z','20','21','22','23','24','25','26','27','28','29','4L','4M')

Note: Runtime prompts are included as criteria.

Fields

|Col |Record.Fieldname |Format |Ord |XLAT |Agg |Heading Text |

|1 |A.CT_CHECK_DT |Date |1 |  |  |Check Date |

|2 |A.EMPLID - EmplID |Char11 |  |  |  |Empl ID |

|3 |A.CT_LEVEL1 - Level 1 |Char2 |2 |  |  |Level 1 |

|4 |A.CT_LEVEL2 - Level 2 |Char2 |3 |  |  |Level 2 |

|5 |'' |Char2 |4 |  |  |Earn Cd |

|6 |0 |SNm9.2 |  |  |  |Other Earn |

|7 |B.CT_EE_LAST_NAME |Char16 |  |  |  |Last Name |

|8 |B.CT_EE_FIRST_NAME |Char14 |  |  |  |First Name / MI |

|9 |A.CT_CUR_REG_GRS |SNm11.2 |  |  |  |Base Pay |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download