PIN_NUMCOMP_RATECDPrompt Table: COMP_RATECD_TBL
GP_PKG_RC1_VW(SQL View) |
Index Back |
|---|---|
Package Rate Code viewView used to package Rate Codes. |
| SELECT PIN_NUM + 50000000 , COMP_RATECD , FREQUENCY_CONV_IND , GENER_WARNING_IND , GP_VERSION FROM PS_GP_RATE_CODE |
| # | 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 |
| 4 | GENER_WARNING_IND | Character(1) | VARCHAR2(1) NOT NULL | Generate Warning Indicator for Rate Code record |
| 5 | GP_VERSION | Character(18) | VARCHAR2(18) NOT NULL | Stores element version. |