GPES_S_TRGR_VW (SQL View)	Index Back
Segmentation trg. by paygroup This view selects all segmentation triggers tied to a paygroup.

GPES_S_TRGR_VW

(SQL View)

Segmentation trg. by paygroup

This view selects all segmentation triggers tied to a paygroup.

SELECT DISTINCT T.EMPLID , T.EMPL_RCD , T.COUNTRY , T.TRGR_EVENT_ID , T.TRGR_EFFDT , T.TRGR_CREATE_TS , J.GP_PAYGROUP , X.CALYEAR , X.GPES_MONTH , T.SEG_TRGR_SRC , T.SEG_TRGR_STATUS , T.SEG_TRGR_LVL , T.CAL_RUN_ID , T.RECNAME , T.FIELDNAME , T.TRGR_FLD_VAL_PIN , T.TRGR_FLD_VAL_CHAR , T.TRGR_FLD_VAL_DT , T.TRGR_FLD_VAL_NUM FROM PS_GP_SEG_TRGR T , PS_JOB J , PS_GPES_SYS_CALEND X WHERE T.EMPLID = J.EMPLID AND J.EMPLID = J.EMPLID AND J.EMPL_RCD = J.EMPL_RCD AND J.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB WHERE EMPLID = J.EMPLID AND EMPL_RCD = J.EMPL_RCD AND EFFDT <= T.TRGR_EFFDT) AND J.REG_REGION = 'ESP' AND T.TRGR_EFFDT BETWEEN X.GPES_MONTH_BGN_DT AND X.GPES_MONTH_END_DT AND T.COUNTRY = 'ESP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

4 TRGR_EVENT_ID Character(10) VARCHAR2(10) NOT NULL Trigger Event ID

5 TRGR_EFFDT Date(10) DATE Trigger Effective Date

6 TRGR_CREATE_TS DateTime(26) TIMESTAMP Trigger Creation Timestamp

7 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

8 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year

9 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month

10 SEG_TRGR_SRC Character(1) VARCHAR2(1) NOT NULL Segmentation Trigger Source
A=Automatically Generated
M=Manually Generated
Default Value: M

11 SEG_TRGR_STATUS Character(1) VARCHAR2(1) NOT NULL Segmentation Trigger Status
A=Active
C=Cancelled
Default Value: A

12 SEG_TRGR_LVL Character(1) VARCHAR2(1) NOT NULL Segmentation Trigger Level
E=Payee Level
J=Job Level
Default Value: J

13 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

14 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

15 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

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 TRGR_FLD_VAL_CHAR Character(25) VARCHAR2(25) NOT NULL Character Value

18 TRGR_FLD_VAL_DT Date(10) DATE Date Value

19 TRGR_FLD_VAL_NUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Numeric Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
4	TRGR_EVENT_ID	Character(10)	VARCHAR2(10) NOT NULL	Trigger Event ID
5	TRGR_EFFDT	Date(10)	DATE	Trigger Effective Date
6	TRGR_CREATE_TS	DateTime(26)	TIMESTAMP	Trigger Creation Timestamp
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
9	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
10	SEG_TRGR_SRC	Character(1)	VARCHAR2(1) NOT NULL	Segmentation Trigger Source A=Automatically Generated M=Manually Generated Default Value: M
11	SEG_TRGR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Segmentation Trigger Status A=Active C=Cancelled Default Value: A
12	SEG_TRGR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Segmentation Trigger Level E=Payee Level J=Job Level Default Value: J
13	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
14	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
15	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
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	TRGR_FLD_VAL_CHAR	Character(25)	VARCHAR2(25) NOT NULL	Character Value
18	TRGR_FLD_VAL_DT	Date(10)	DATE	Date Value
19	TRGR_FLD_VAL_NUM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Numeric Value