GP_SEG_TRGR

#	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 Record
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 NOT NULL	Trigger Effective Date Default Value: %Date
6	TRGR_CREATE_TS	DateTime(26)	TIMESTAMP NOT NULL	Trigger Creation Timestamp
7	SEG_TRGR_SRC	Character(1)	VARCHAR2(1) NOT NULL	Segmentation Trigger Source A=Automatically Generated M=Manually Generated Default Value: M
8	SEG_TRGR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Segmentation Trigger Status A=Active C=Cancelled Default Value: A
9	SEG_TRGR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Segmentation Trigger Level E=Payee Level J=Job Level Default Value: E
10	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
11	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
12	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
13	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.
14	TRGR_FLD_VAL_CHAR	Character(25)	VARCHAR2(25) NOT NULL	Character Value
15	TRGR_FLD_VAL_DT	Date(10)	DATE	Date Value
16	TRGR_FLD_VAL_NUM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Numeric Value
17	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence Default Value: 0