...
| Page Properties |
|---|
Summary | This analytical view gives an overview of the rates from all the Payscales. |
|---|
Keywords | Payscale, Rates |
|---|
Category | Analytical View |
|---|
|
Description
This analytical view gives an overview of the rates from all the Payscales.
...
| Expand |
|---|
|
| Code Block |
|---|
select
'1' as PIN,
'1' as NUMORGID,
'1' as EMPLOYMENTSTARTDATE,
'1' as EMPLOYMENTENDDATE ,
C0.REGULATIVECODE as 'Table',
C0.REGULATIVENAME as Table_Name,
C1.PAYSCALECODE as 'Payscale_Code',
C1.PAYSCALENAME as 'Payscale_Name',
convert (varchar, LN.Line) + ' ' + LN.NAME as 'Rate_Line',
Cl.Col as 'Seniority_Column',
C0.CURRENCYCODE as 'Currency',
Isnull(TRY_CONVERT(Decimal(10,2),C1R.Rate),0.00) as [Rate],
CASE when (C1R.Formula is NULL or C1R.Formula = '') then convert (Decimal(10,2), '0.00')
ELSE TRY_CONVERT(Decimal(10,2),C1R.Rate)
END Formula
from PWPSC000 C0
left join PWPSC001 C1 on C1.SEQNO=C0.SEQNO
left join PWPSC_RATES_LINES LN on LN.SEQNO=C0.SEQNO
left join PWPSC_RATES_COLUMNS CL on CL.SEQNO=C0.SEQNO
left join PWPSC001_RATES C1R on C1R.SeqNo=C0.SEQNO and LN.LineId=C1R.LineId and CL.ColId=C1R.ColId and C1.ID=C1R.ID |
|
...
Fields Definition
Fields Definition in General Codes > Datab Migning Code setup.
...