EMPLID&=Check and Advice
A=Advice
C=Check
M=Manual Check
R=Check Reversal
PY_IC_PAY_VW1(SQL View) |
Index Back |
|---|---|
My Pay |
| SELECT A.EMPLID , A.CHECK_DT , A.SEPCHK , A.FORM_ID, A.PAYCHECK_NBR , A.PAYCHECK_OPTION ,A.TOTAL_GROSS ,TOTAL_DEDUCTIONS ,TOTAL_TAXES , A.NET_PAY , CASE WHEN ( SELECT COUNT(F.PAYCHECK_NBR) FROM PS_PY_SS_PSLP_GDE F WHERE A.EMPLID = F.EMPLID AND A.PAYCHECK_NBR = F.PAYCHECK_NBR AND F.PY_SS_PSLP_STATUS = 'ORIG' AND F.PY_PSLP_VIEW_DT <= %CurrentDateIn ) > 0 THEN 'Y' ELSE 'N' END AS PDF FROM PS_PAY_CHECK A WHERE A.PAYCHECK_STATUS = 'F' AND A.PAYCHECK_OPTION <> 'R' AND (EXISTS ( SELECT 'X' FROM PS_PY_SS_PSLP_GDE B WHERE A.EMPLID = B.EMPLID AND A.PAYCHECK_NBR = B.PAYCHECK_NBR AND B.PY_SS_PSLP_STATUS = 'ORIG' AND B.PY_PSLP_VIEW_DT <= %CurrentDateIn) OR (NOT EXISTS ( SELECT 'X' FROM PS_PY_SS_PSLP_GDE C WHERE A.EMPLID = C.EMPLID AND A.PAYCHECK_NBR = C.PAYCHECK_NBR AND C.PY_SS_PSLP_STATUS = 'ORIG') AND %DateAdd(A.CHECK_DT, (SELECT %Coalesce(MAX(D.PY_SSP_BGNSSDFLT), 0) FROM PS_PY_SSP_OPTN_DTL D WHERE (D.PY_SSP_SETUP_ID = 'PNACAN' AND A.COUNTRY <> 'USA') OR (D.PY_SSP_SETUP_ID = 'PNAUSA' AND A.COUNTRY = 'USA') AND D.COMPANY = A.COMPANY AND D.PAYGROUP = A.PAYGROUP AND D.EFFDT = (SELECT MAX(E.EFFDT) FROM PS_PY_SSP_OPTN_HDR E WHERE (E.PY_SSP_SETUP_ID = 'PNACAN' AND A.COUNTRY <> 'USA') OR (E.PY_SSP_SETUP_ID = 'PNAUSA' AND A.COUNTRY = 'USA')))) <= %CurrentDateIn)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CHECK_DT | Date(10) | DATE | Check date. |
| 3 | SEPCHK | Number(2,0) | SMALLINT NOT NULL | Separate check number. |
| 4 | FORM_ID | Character(6) | VARCHAR2(6) NOT NULL | Form Identification |
| 5 | PAYCHECK_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Paycheck number. |
| 6 | PAYCHECK_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Paycheck Option
&=Check and Advice A=Advice C=Check M=Manual Check R=Check Reversal |
| 7 | TOTAL_GROSS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Total Gross |
| 8 | TOTAL_DEDUCTIONS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Total Deductions |
| 9 | TOTAL_TAXES | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Total Taxes |
| 10 | NET_PAY | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Net Pay |
| 11 | PY_SSP_PDF_FLG | Character(1) | VARCHAR2(1) NOT NULL | Self Service Paycheck in PDF |