GP_WC_SEGMENT

(SQL View)
 Index Back

GP WC Segment

GP WC Segment

SELECT A.EMPLID , A.COUNTRY , A.TRGR_EFFDT , A.TRGR_CREATE_TS , A.SEG_TRGR_SRC , C.FIRST_NAME , C.LAST_NAME , A.EMPL_RCD , A.TRGR_EVENT_ID , B.DESCR , A.SEG_TRGR_LVL , A.SEG_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 , A.TRGR_FLD_VAL_PIN , F.CAL_ID , F.GP_PAYGROUP , F.CAL_RUN_ID FROM PS_GP_SEG_TRGR A , PS_PERSON_NAME C , PS_GP_PYE_PRC_STAT F , PS_GP_SEG_EVT B WHERE ( ( NOT EXISTS ( SELECT D.EMPLID FROM PS_GP_PYE_SEG_STAT D WHERE ( ( D.SEG_BGN_DT = A.TRGR_EFFDT OR D.SEG_END_DT = A.TRGR_EFFDT-1) AND D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD )) AND F.CALC_TYPE = 'P' AND A.EMPLID = C.EMPLID AND A.EMPLID = F.EMPLID AND A.TRGR_EFFDT BETWEEN F.PRD_BGN_DT AND F.PRD_END_DT AND F.SEL_STAT = 'A' AND A.TRGR_EVENT_ID = B.TRGR_EVENT_ID AND A.COUNTRY = B.COUNTRY AND A.COUNTRY = F.COUNTRY AND A.EMPL_RCD = F.EMPL_RCD AND EXISTS ( SELECT E.GP_PAYGROUP FROM PS_GP_WC_USR_PYGRP E WHERE E.GP_PAYGROUP = F.GP_PAYGROUP ) AND A.SEG_TRGR_STATUS <> 'C' ))

# 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 TRGR_EFFDT Date(10) DATE Trigger Effective Date
4 TRGR_CREATE_TS DateTime(26) TIMESTAMP Trigger Creation Timestamp
5 SEG_TRGR_SRC Character(1) VARCHAR2(1) NOT NULL Segmentation Trigger Source
A=Automatically Generated
M=Manually Generated
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 TRGR_EVENT_ID Character(10) VARCHAR2(10) NOT NULL Trigger Event ID
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 SEG_TRGR_LVL Character(1) VARCHAR2(1) NOT NULL Segmentation Trigger Level
E=Payee Level
J=Job Level
12 SEG_TRGR_STATUS Character(1) VARCHAR2(1) NOT NULL Segmentation Trigger Status
A=Active
C=Cancelled
13 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
14 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
15 CHARACTER_VALUE Character(20) VARCHAR2(20) NOT NULL character value
16 TRGR_FLD_VAL_PIN Number(8,0) INTEGER NOT NULL Earning/Deduction element on the trigger definition for a segmentation definition for payee assignment record.
17 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
18 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
19 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id