GPDE_GR_ALLW_VW

(SQL View)
Index Back

Bracket Value Entries

Bracket Value Entries

SELECT %Substring(A.DATA_KEY1,1,1) ,A.EFFDT ,%Round(A.DATA_VAL2_DEC,0) ,%Round(A.DATA_VAL3_DEC,2) ,A.DATA_VAL3_CURR FROM PS_GP_BRACKET_DTL A ,PS_GP_PIN B WHERE A.PIN_NUM = B.PIN_NUM AND B.PIN_CODE = 'DE_GR_EXEMPTION DEU' AND A.DATA_VAL2_DEC <= 999 AND A.DATA_VAL2_DEC >= 0 AND A.DATA_VAL3_DEC <= 9999999 AND A.DATA_VAL3_DEC >= 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPDE_GR_DEPEND_NBR Character(1) VARCHAR2(1) NOT NULL Number of Dependents
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 GPDE_GR_DEPEND_PCT Number(3,0) SMALLINT NOT NULL Exemption Percent
4 GPDE_GR_DEPEND_AMT Signed Number(14,2) DECIMAL(12,2) NOT NULL Exemption Amount
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code