UPG_PYGRP_RETRO(SQL Table) |
Index Back |
---|---|
Upgrade Paygroup RetroThis 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 |