PY_RETROTRG_REC (SQL Table)	Index Back
Retro Trigger Record Defn The table will contain the new Trigger Definitions. It will contain one row for each Table on which retro can be generated. For each tables, the user can select if retro is generated when the table changes (such as a new row, or any field that is updated) or when a field changes.

PY_RETROTRG_REC

(SQL Table)

Retro Trigger Record Defn

The table will contain the new Trigger Definitions. It will contain one row for each Table on which retro can be generated. For each tables, the user can select if retro is generated when the table changes (such as a new row, or any field that is updated) or when a field changes.

Parent record: PY_RETROTRG_DEF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RETRO_TRG_PGM_ID Character(3) VARCHAR2(3) NOT NULL This field will define the Retroactive Program ID.

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PY_RETROTBL_DEF

4 TRGR_LVL_OPTN Character(1) VARCHAR2(1) NOT NULL Trigger Level
F=Field
R=Record
Default Value: R

5 RETRO_VALUE_ID Character(3) VARCHAR2(3) NOT NULL Retroactive Value ID. Identifies a set of field values that can be associated with a Retroactive Trigger Definition
Prompt Table: RETROVAL_ID_DVW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RETRO_TRG_PGM_ID	Character(3)	VARCHAR2(3) NOT NULL	This field will define the Retroactive Program ID.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PY_RETROTBL_DEF
4	TRGR_LVL_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Trigger Level F=Field R=Record Default Value: R
5	RETRO_VALUE_ID	Character(3)	VARCHAR2(3) NOT NULL	Retroactive Value ID. Identifies a set of field values that can be associated with a Retroactive Trigger Definition Prompt Table: RETROVAL_ID_DVW