UPG_BN_GENERIC

(SQL Table)
Index Back

Upgrade: Generic Temp Table

Generic temporary table used during Benefits upgrade processes. Most often used to simply hold key values to avoid self-referencing.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TEMP_KEY11 Character(11) VARCHAR2(11) NOT NULL Key field used in generic temporary table to accomodate application keys of length Char(11).
2 TEMP_KEY2 Character(2) VARCHAR2(2) NOT NULL Key field used in generic temporary table to accomodate application keys of length Char(2).
3 TEMP_KEY4 Character(4) VARCHAR2(4) NOT NULL Key field used in generic temporary table to accomodate application keys of length Char(4).
4 TEMP_KEY6 Character(6) VARCHAR2(6) NOT NULL Key field used in generic temporary table to accomodate application keys of length Char(6).
5 EFFDT Date(10) DATE Effective Date