COMP_RATCD_R_VW(SQL View) |
Index Back |
|---|---|
Defaulting Rule Rate Code ViewDefaulting Rule Rate Code View: This view selects Rate Codes and the Defaulting Rules they are assigned to. |
| SELECT C.COMP_RATECD , C.EFFDT , D.CMP_RULE_ID , D.EFFDT , R.COMP_EFFSEQ , D.EFF_STATUS , D.CMP_RULE_DESCR20 , D.CMP_SRC_IND , R.COMPRATE , R.CURRENCY_CD , R.COMP_FREQUENCY , R.COMP_PCT , R.RATE_CODE_GROUP , R.COMP_RATE_POINTS , R.FTE_INDICATOR FROM PS_CMP_RULE_DEFN D ,PS_CMP_RULE_RATECD R ,PS_COMP_RATECD_TBL C WHERE D.CMP_SRC_IND = 'C' AND D.CMP_RULE_ID = R.CMP_RULE_ID AND D.EFFDT = R.EFFDT AND R.COMP_RATECD = C.COMP_RATECD AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_COMP_RATECD_TBL C1 WHERE C1.COMP_RATECD = R.COMP_RATECD AND C1.EFFDT <= R.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMP_RATECD |
Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | CMP_RULE_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Compensation Defaulting Rule Identifier
Prompt Table: CMP_COMBO_RL_VW |
| 4 | CMP_RULE_EFFDT |
Date(10) | DATE | Defaulting Rule Effective Date |
| 5 | COMP_EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Compensation Eff Sequence |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | CMP_RULE_DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Compensation Defaulting Rule Short Description |
| 8 | CMP_SRC_IND | Character(1) | VARCHAR2(1) NOT NULL |
Rate Code Source Indicator
A=Absorbing Premium B=Non-Absorbing Premium C=Combination Rule E=Seniority Pay J=Job Code M=Manual N=None P=Payroll R=Employee Review S=Salary Step |
| 9 | COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Compensation Rate |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 11 | COMP_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly Prompt Table: COMP_FREQ_VW |
| 12 | COMP_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Comp Percent |
| 13 | RATE_CODE_GROUP | Character(6) | VARCHAR2(6) NOT NULL |
Rate Code Group Name
Prompt Table: COMPRT_GRP_TBL |
| 14 | COMP_RATE_POINTS | Number(5,0) | INTEGER NOT NULL | Comp Rate Points |
| 15 | FTE_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Apply FTE for Annualization
Y/N Table Edit Default Value: N |