COMP_RATECDEFFDTCMP_RULE_IDPrompt Table: CMP_COMBO_RL_VW
CMP_RULE_EFFDTCOMP_EFFSEQLANGUAGE_CDCOMP_RATCD_R_LN(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 , L.LANGUAGE_CD , L.CMP_RULE_DESCR20 FROM PS_CMP_RULE_DEFN D ,PS_CMP_RULE_DEFN_L L ,PS_CMP_RULE_RATECD R ,PS_COMP_RATECD_TBL C WHERE D.CMP_SRC_IND = 'C' AND L.CMP_RULE_ID = D.CMP_RULE_ID AND L.EFFDT = D.EFFDT 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | CMP_RULE_DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Compensation Defaulting Rule Short Description |