PY_RETROTRG_VAL (SQL Table)	Index Back
Retro Trg Field Value Defn The table will contain the new Trigger Definitions. If in the PY_RETROTRG_REC, the user selected that retro will be generated when a field changes, the user will define which fields will trigger retro. Depending on the field, the user can select that retro will be generated whenever the field changes (such as if salary changes, generate retro), or it could generate retro when the value changes to a specific value. For example: if the employment status changes to Pay Rate Changes, the user would probably want retro generated, but if it changes to Bonus, then he probably would not want retro to generate.

PY_RETROTRG_VAL

(SQL Table)

Retro Trg Field Value Defn

The table will contain the new Trigger Definitions. If in the PY_RETROTRG_REC, the user selected that retro will be generated when a field changes, the user will define which fields will trigger retro. Depending on the field, the user can select that retro will be generated whenever the field changes (such as if salary changes, generate retro), or it could generate retro when the value changes to a specific value. For example: if the employment status changes to Pay Rate Changes, the user would probably want retro generated, but if it changes to Bonus, then he probably would not want retro to generate.

Parent record: PY_RETROTRG_FLD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

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 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

7 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

8 TRGR_FLD_VAL_CHAR Character(25) VARCHAR2(25) NOT NULL Character Value
Prompt Table: %EDITTABLE

9 TRGR_FLD_VAL_DT Date(10) DATE Date Value
Prompt Table: %EDITTABLE

10 TRGR_FLD_VAL_NUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Numeric Value
Prompt Table: %EDITTABLE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
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	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
8	TRGR_FLD_VAL_CHAR	Character(25)	VARCHAR2(25) NOT NULL	Character Value Prompt Table: %EDITTABLE
9	TRGR_FLD_VAL_DT	Date(10)	DATE	Date Value Prompt Table: %EDITTABLE
10	TRGR_FLD_VAL_NUM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Numeric Value Prompt Table: %EDITTABLE