GPSC_ELM_ED_SVR

(SQL View)
 Index Back

ED Supporting Element Override

Element Definition Supporting Elements Override.

SELECT PIN_NUM , PIN_SOVR_NUM , BGN_DT , END_DT , ENTRY_TYPE_SOVR , SOVR_VAL_CHAR , SOVR_VAL_NUM , SOVR_VAL_DT , CURRENCY_CD FROM PS_GP_ELM_DFN_SOVR WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , PIN_SOVR_NUM , BGN_DT , END_DT , ENTRY_TYPE_SOVR , SOVR_VAL_CHAR , SOVR_VAL_NUM , SOVR_VAL_DT , CURRENCY_CD FROM PS_GPSC_RM_ELM_SOV WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN)

# 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 END_DT Date(10) DATE end date
5 ENTRY_TYPE_SOVR Character(3) VARCHAR2(3) NOT NULL entry type sovr

Prompt Table: GP_ENT_SOVR5_VW

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