GP_RTO_TRGR

#	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 Prompt Table: GP_USER_CNTR_VW
3	TRGR_EVENT_ID	Character(10)	VARCHAR2(10) NOT NULL	Trigger Event ID Prompt Table: GP_RTO_EVT
4	TRGR_EFFDT	Date(10)	DATE	Trigger Effective Date
5	TRGR_CREATE_TS	DateTime(26)	TIMESTAMP	Trigger Creation Timestamp
6	RTO_TRGR_SRC	Character(1)	VARCHAR2(1) NOT NULL	Retro Trigger Source A=Automatically Generated F=Benefits Administration M=Manually Generated S=Mass Trigger U=Utility Generated Default Value: M
7	TRGR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of a retro trigger. Contains code set (translate values) C=Cancelled I=In Process P=Processed U=Unprocessed Default Value: U
8	TRGR_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Trigger Tag
9	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
10	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
11	TRGR_FLD_VAL_CHAR	Character(25)	VARCHAR2(25) NOT NULL	Character Value
12	TRGR_FLD_VAL_DT	Date(10)	DATE	Date Value
13	TRGR_FLD_VAL_NUM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Numeric Value
14	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id