EMPLIDB=Batch
F=Benefits Administration
O=Online
S=Mass Trigger
U=Uncancel
V=Unsuspend
W=Time & Labor
Z=Time & Labor Feed
EMPL_RCDC=Cancelled
I=InProcess
P=Processed
U=UnProcessed
GP_WC_ITERATIVE(SQL View) |
Index Back |
|---|---|
GP WC Iterative TriggerGP WC Iterative Trigger |
| SELECT A.EMPLID , A.COUNTRY , C.CAL_RUN_ID , A.TRGR_CREATE_TS , A.ITER_TRGR_SRC , D.FIRST_NAME , D.LAST_NAME , B.EMPL_RCD , A.ITER_TRGR_STATUS , A.RECNAME , A.FIELDNAME , A.TRGR_FLD_VAL_DT || (CASE WHEN A.TRGR_FLD_VAL_NUM = 0 THEN '' ELSE %NumToChar(A.TRGR_FLD_VAL_NUM) END) || A.TRGR_FLD_VAL_CHAR , C.CAL_ID , C.GP_PAYGROUP FROM PS_GP_ITER_TRGR A , ((PS_JOB B ) LEFT OUTER JOIN PS_PERSON_NAME D ON B.EMPLID = D.EMPLID ) , PS_GP_CAL_RUN_DTL C WHERE ( ( A.EMPLID = B.EMPLID AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_JOB B_ED WHERE B.EMPLID = B_ED.EMPLID AND B.EMPL_RCD = B_ED.EMPL_RCD AND B_ED.EFFDT <= %CurrentDateIn) AND B.EFFSEQ = ( SELECT MAX(B_ES.EFFSEQ) FROM PS_JOB B_ES WHERE B.EMPLID = B_ES.EMPLID AND B.EMPL_RCD = B_ES.EMPL_RCD AND B.EFFDT = B_ES.EFFDT) AND A.ITER_TRGR_STATUS = 'U' AND B.GP_PAYGROUP = C.GP_PAYGROUP AND A.COUNTRY = C.COUNTRY AND C.CALC_TYPE = 'P' AND A.CAL_RUN_ID = C.CAL_RUN_ID AND EXISTS ( SELECT E.GP_PAYGROUP FROM PS_GP_WC_USR_PYGRP E WHERE ( E.GP_PAYGROUP = B.GP_PAYGROUP )) )) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | TRGR_CREATE_TS | DateTime(26) | TIMESTAMP | Trigger Creation Timestamp |
| 5 | ITER_TRGR_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Iterative Trigger Source
B=Batch F=Benefits Administration O=Online S=Mass Trigger U=Uncancel V=Unsuspend W=Time & Labor Z=Time & Labor Feed |
| 6 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 7 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 8 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 9 | ITER_TRGR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Iterative Trigger Status
C=Cancelled I=InProcess P=Processed U=UnProcessed |
| 10 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 11 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 12 | CHARACTER_VALUE | Character(20) | VARCHAR2(20) NOT NULL | character value |
| 13 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 14 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |