COMPENSATION_CV

(SQL View)
 Index Back

COMPENSATION msg Clairvia

Clone of COMPENSATION record for Clairvia fullsync message

SELECT COMP.EMPLID , COMP.EMPL_RCD , COMP.EFFDT , COMP.EFFSEQ , COMP.EFFSEQ , COMP.COMP_RATECD , COMP.COMP_RATE_POINTS , COMP.COMPRATE , COMP.COMP_PCT , COMP.COMP_FREQUENCY , COMP.CURRENCY_CD , COMP.MANUAL_SW , COMP.CONVERT_COMPRT , COMP.RATE_CODE_GROUP , COMP.CHANGE_AMT , COMP.CHANGE_PCT , COMP.CHANGE_PTS , COMP.FTE_INDICATOR , COMP.CMP_SRC_IND FROM PS_COMPENSATION COMP , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = COMP.EMPLID AND ASG.EMPL_RCD = COMP.EMPL_RCD AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: JOB.EMPLID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Default Value: JOB.EMPL_RCD

3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: JOB.EFFDT

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

Default Value: JOB.EFFSEQ

5 COMP_EFFSEQ Number(3,0) SMALLINT NOT NULL Compensation Eff Sequence
6 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

Prompt Table: COMP_RATECD_TBL

7 COMP_RATE_POINTS Number(5,0) INTEGER NOT NULL Comp Rate Points
8 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
9 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent
10 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

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

12 MANUAL_SW Character(1) VARCHAR2(1) NOT NULL Manual Switch

Y/N Table Edit

Default Value: N

13 CONVERT_COMPRT Number(19,6) DECIMAL(18,6) NOT NULL Converted Comp Rate
14 RATE_CODE_GROUP Character(6) VARCHAR2(6) NOT NULL Rate Code Group Name

Prompt Table: COMPRT_GRP_TBL

15 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
16 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
17 CHANGE_PTS Signed Number(6,0) DECIMAL(5) NOT NULL Change Points
18 FTE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Apply FTE for Annualization

Y/N Table Edit

Default Value: N

19 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

Default Value: N