PY_RETROTRG_FLD (SQL Table)	Index Back
Retro Trg Field Definition 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_FLD

(SQL Table)

Retro Trg Field Definition

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_REC

# 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
Prompt Table: EARNINGS_CLE_VW

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: PY_RETROTBL_USE

6 VALUE_BASED_IND Character(1) VARCHAR2(1) NOT NULL Dependent on Field Value
Y/N Table Edit
Default Value: N

7 ALL_ERNCDS Character(1) VARCHAR2(1) NOT NULL All Earnings Codes
Y/N Table Edit
Default Value: N

#	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 Prompt Table: EARNINGS_CLE_VW
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: PY_RETROTBL_USE
6	VALUE_BASED_IND	Character(1)	VARCHAR2(1) NOT NULL	Dependent on Field Value Y/N Table Edit Default Value: N
7	ALL_ERNCDS	Character(1)	VARCHAR2(1) NOT NULL	All Earnings Codes Y/N Table Edit Default Value: N