COMP_RATECDLANGUAGE_CDEFFDTCMPRTREG_LNG_VW(SQL View) |
Index Back |
|---|---|
Related Lang - COMP_RT_REG_VWThis is the view used by comp rate codes processing that selects from PS_COMP_RATECD_TBL rate codes for North American payroll where the base pay switch is set to 'N' and rate type is not points. It is designed to be used as prompt table in the pay earnings record for the regular rate code field and in pay other earnings for the rate code field. |
| SELECT COMP_RATECD , LANGUAGE_CD , EFFDT , DESCRSHORT FROM PS_COMP_RATCD_LANG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMP_RATECD |
Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |