COMP_RATECDLANGUAGE_CDEFFDTCMPRTOT_LNG_VW(SQL View) |
Index Back |
|---|---|
Related Lang - COMP_RT_OT_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 or flat amount. It is designed to be used as prompt table in the pay earnings record for the overtime 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 |