GP_RTO_TRGR_WRK

(SQL Table)
Index Back

Temp Table-RtoTrgr Expn

This is a temporary table used by the retro trigger expansion batch process.

# 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_EVENT_ID Character(10) VARCHAR2(10) NOT NULL Trigger Event ID
4 TRGR_EFFDT Date(10) DATE Trigger Effective Date
5 TRGR_CREATE_TS DateTime(26) TIMESTAMP Trigger Creation Timestamp
6 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id