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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- 925f report of average salaries and fte
- employment outcomes for graduates
- msa pay hist for avg salary us
- 8 tarleton state university
- hypothesis testing of single mean and single proportion
- hr455 ability to calculate and store average wc salary
- affidavit of monthly income and expenses
- welcome to department of administration state of south
- columbia public schools home
Related searches
- how to pay cash for a car
- should i pay cash for a car
- should you pay cash for a car
- buy here pay here for bad credit
- consignment shops that pay cash for clothes
- should you pay cash for house
- should you pay cash for a house
- pay cash for car or finance
- teach for america salary ranges
- disposable pay calculator for garnishment
- how to pay cash for a house
- create pay stubs for income verification