PROCESS_INSTANCEEMPLID_BGRPCAL_RUN_IDA=All Payees
N=Not Applicable
T=Terminated Payees
Y=Active Payees
GPAU_STP_FIN_VW(SQL View) |
Index Back |
|---|---|
Final Pay IndicatorFinal Pay Indicator |
| SELECT STP.PROCESS_INSTANCE , STP.EMPLID_BGRP , STP.CAL_RUN_ID , CASE WHEN STP.GPAU_STP_FINAL_PAY <> ' ' THEN STP.GPAU_STP_FINAL_PAY ELSE STP1.GPAU_STP_FINAL_PAY END FROM PS_GPAU_STP_TMPSTG STP , PS_GPAU_STP_TMPXML STP1 WHERE STP.PROCESS_INSTANCE = STP1.PROCESS_INSTANCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID_BGRP |
Character(14) | VARCHAR2(14) NOT NULL | Emplid |
| 3 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | GPAU_STP_FINAL_PAY | Character(1) | VARCHAR2(1) NOT NULL |
Final Event Indicator - Single Touch Payroll
A=All Payees N=Not Applicable T=Terminated Payees Y=Active Payees |