GP_SEG_TRG_WRK

(SQL Table)
Index Back

Upgrade - Work table

Work Table for Segmentation trigger-upgrade

# 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