PYE_SOVR_ESP_VW

(SQL View)
 Index Back

HR Payee Supp Elemnt Override

Payee Level Supporting Elements Override. Used as display-only in Contract Data ESP.

SELECT A.EMPLID , A.EMPL_RCD , A.PIN_NUM , B.PIN_NM , B.DESCR , B.PIN_TYPE , A.BGN_DT , A.END_DT , A.SOVR_VAL_CHAR , A.SOVR_VAL_NUM , A.SOVR_VAL_DT , B.FLD_FMT FROM PS_GP_PYE_SOVR A , PS_GP_PIN B WHERE A.PIN_NUM = B.PIN_NUM

# 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 Record
3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %RECNAME_EDIT

4 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
7 BGN_DT Date(10) DATE NOT NULL Begin Date

Default Value: %Date

8 END_DT Date(10) DATE end date
9 SOVR_VAL_CHAR Character(25) VARCHAR2(25) NOT NULL Supporting Element Character Value

Prompt Table: %GP_EDIT_FLD1

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 FLD_FMT Character(1) VARCHAR2(1) NOT NULL Field format for Global Payroll elements
1=Character
2=Date
3=Monetary
4=Decimal
5=Element Pointer
6=Not Applicable