PIN_NUMCOMP_RATECDPrompt Table: COMP_RATECD_TBL
Y/N Table Edit
Default Value: Y
Y/N Table Edit
GP_RATE_CODE(SQL Table) |
Index Back |
|---|---|
Rate Code DefinitionRate code rule definitions - Main record. |
| # | 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 Default Value: Y |
| 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. |