GPSC_ELM_RC

(SQL View)
 Index Back

Rate Code Definition

Rate code rule definitions - Main record.

SELECT PIN_NUM , COMP_RATECD , FREQUENCY_CONV_IND , GENER_WARNING_IND , GP_VERSION FROM PS_GP_RATE_CODE WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , COMP_RATECD , FREQUENCY_CONV_IND , GENER_WARNING_IND , GP_VERSION FROM PS_GPSC_RM_RATE_CD 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 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

Prompt Table: COMP_RATECD_TBL

3 FREQUENCY_CONV_IND Character(1) VARCHAR2(1) NOT NULL Frequency Conversion Indicator for Rate Code record

Y/N Table Edit

4 GENER_WARNING_IND Character(1) VARCHAR2(1) NOT NULL Generate Warning Indicator for Rate Code record

Y/N Table Edit

5 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.