UPG_PYGRP_RETRO

(SQL Table)
Index Back

Upgrade Paygroup Retro

This record is for the user upgrade default values for the new Retro Trigger Program ID field on the paygroup table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
3 RETRO_TRG_PGM_ID Character(3) VARCHAR2(3) NOT NULL This field will define the Retroactive Program ID.

Prompt Table: PY_RETROTRG_DEF

4 UPG_PYGRP_RTRO_FLG Character(1) VARCHAR2(1) NOT NULL Paygroup Retro Trigger Program ID update status.
C=Created
N=Not Updated
U=Updated