GP_NRP_PYESV_VW

(SQL View)
 Index Back

Payee Supp Elmt Ovrd - View

Payee Level Supporting Elements Override - Packaging View

SELECT EMPLID ,EMPL_RCD ,PIN_NUM + 50000000 ,BGN_DT ,END_DT ,SOVR_VAL_CHAR ,SOVR_VAL_NUM ,SOVR_VAL_DT ,CURRENCY_CD ,ENTRY_TYPE_SOVR FROM PS_GP_PYE_SOVR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %RECNAME_EDIT

4 BGN_DT Date(10) DATE NOT NULL Begin Date

Default Value: %Date

5 END_DT Date(10) DATE end date
6 SOVR_VAL_CHAR Character(25) VARCHAR2(25) NOT NULL Supporting Element Character Value
7 SOVR_VAL_NUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Supporting Element Numeric Value
8 SOVR_VAL_DT Date(10) DATE Date Value
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

10 ENTRY_TYPE_SOVR Character(3) VARCHAR2(3) NOT NULL entry type sovr

Prompt Table: GP_ENT_SOVR4_VW