GP_AUD_ED_SVR

(SQL Table)
 Index Back

ED Supporting Element Override

Element Definition Supporting Elements Override.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 PIN_SOVR_NUM Number(8,0) INTEGER NOT NULL Supporting Element PIN Number

Prompt Table: %RECNAME_EDIT

3 BGN_DT Date(10) DATE NOT NULL Begin Date
4 GP_AUD_CHAR_NM1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
5 GP_AUD_LINK1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
6 GP_AUD_CHAR_VAL1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
7 END_DT Date(10) DATE end date
8 ENTRY_TYPE_SOVR Character(3) VARCHAR2(3) NOT NULL entry type sovr

Prompt Table: GP_ENT_SOVR5_VW

9 SOVR_VAL_CHAR Character(25) VARCHAR2(25) NOT NULL Supporting Element Character Value
10 SOVR_VAL_NUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Supporting Element Numeric Value
11 SOVR_VAL_DT Date(10) DATE Date Value
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

13 GROUPBOX_ED9 Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.