CMP_RULE_RATECD

(SQL Table)
Index Back

Defaulting Rule Rate Codes

Defaulting Rule Rate Codes

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CMP_RULE_ID Character(15) VARCHAR2(15) NOT NULL Compensation Defaulting Rule Identifier
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

Prompt Table: BASE_RATECD_VW

4 COMP_EFFSEQ Number(3,0) SMALLINT NOT NULL Compensation Eff Sequence
5 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

7 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

8 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent
9 RATE_CODE_GROUP Character(6) VARCHAR2(6) NOT NULL Rate Code Group Name

Prompt Table: COMPRT_GRP_TBL

10 COMP_RATE_POINTS Number(5,0) INTEGER NOT NULL Comp Rate Points
11 FTE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Apply FTE for Annualization

Y/N Table Edit

Default Value: N