CMP_RUL_ELIG_VW

(SQL View)
 Index Back

Eligible Defaulting Rules View

Eligible Defaulting Rules View. This view is a join of the following Defaulting Rules tables: Defaulting Rules Definition Defaulting Rules Criteria Defaulting Rules Values The view is used to scroll in Job Code Defaulting Rules and Salary Step Defaulting Rules.

SELECT RD.CMP_RULE_ID , RD.EFFDT , RW.CMP_RULE_OPER_SEQ , RV.CMP_VALUE_SEQ , RD.EFF_STATUS , RD.CMP_SRC_IND , RW.RECNAME , RW.FIELDNAME , RW.CMP_RULE_SQL_OPER , RV.CMP_FLD_VALUE , RV.CMP_FLD_VALUE_DT , RV.CMP_FLD_VALUE_DTTM , RV.CMP_FLD_VALUE_TM , RV.SETID , RV.ACTION , RV.COMPANY , RV.PAYGROUP , RV.SAL_ADMIN_PLAN , RV.GRADE , RV.RATING_MODEL , RV.OPRCLASS , RV.TARIFF_GER , RV.GVT_NOA_CODE , RV.GVT_RTND_PAY_PLAN , RV.GVT_RTND_SAL_PLAN , RV.GVT_RTND_GRADE , RV.GVT_SUB_AGENCY , RV.ACTION_ITA , RV.SEQUENCE_NBR , RV.LABOR_AGREEMENT , RV.EMPL_CTG , RV.EMPL_CTG_L1 , RV.EMPLID FROM PS_CMP_RULE_DEFN RD ,PS_CMP_RULE_WHERE RW ,PS_CMP_RULE_VALUES RV WHERE RW.CMP_RULE_ID = RD.CMP_RULE_ID AND RW.EFFDT = RD.EFFDT AND RV.CMP_RULE_ID = RW.CMP_RULE_ID AND RV.EFFDT = RW.EFFDT AND RV.CMP_RULE_OPER_SEQ = RW.CMP_RULE_OPER_SEQ

# 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 Effective Date

Default Value: %date

3 CMP_RULE_OPER_SEQ Number(3,0) SMALLINT NOT NULL Operand Sequence Number
4 CMP_VALUE_SEQ Number(3,0) SMALLINT NOT NULL Sequence
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
6 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
7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
9 CMP_RULE_SQL_OPER Character(1) VARCHAR2(1) NOT NULL SQL Operator
A=Equals
F=In List
G=Not In List
10 CMP_FLD_VALUE Character(50) VARCHAR2(50) NOT NULL Field Value

Prompt Table: %EDITTABLE

11 CMP_FLD_VALUE_DT Date(10) DATE Date
12 CMP_FLD_VALUE_DTTM DateTime(26) TIMESTAMP Date Time
13 CMP_FLD_VALUE_TM Time(15) TIMESTAMP Time
14 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

15 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

16 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

17 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: PAYGROUP_TBL

18 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

Prompt Table: SAL_PLAN_TBL

19 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

Prompt Table: SAL_GRADE_TBL

20 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

Prompt Table: RATING_MDL_TBL

21 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

Prompt Table: OPRCLASS_VW

22 TARIFF_GER Character(2) VARCHAR2(2) NOT NULL Tariff
01=Metal Processing
02=Banking
03=Building and Civil Engineering
04=Clothing Industry
05=Chemical Industry
06=Printing Industry
07=Retail Trade
08=Fossil Oil and Gas Extraction
09=Glass Industry
10=Wholesale and Foreign Trade
11=Wood Processing
12=Rubber Processing
13=Ceramics
14=Agriculture
15=Leather Processing
16=Public Sector
17=Paper Industry
18=Paper Processing
19=Sawing Industry
20=German Seaports
21=Hard-Coal Mining
22=Textile Industry
23=Insurance
24=Housing Industry
25=Periodical Publishers
26=Newspaper Publishers
27=Tobacco Industry
23 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code

Prompt Table: GVT_NOAC_TBL

24 GVT_RTND_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Retained Pay Plan

Prompt Table: GVT_RTND_PP_VW

25 GVT_RTND_SAL_PLAN Character(4) VARCHAR2(4) NOT NULL Retained Pay Table

Prompt Table: GVT_RTND_SP_VW

26 GVT_RTND_GRADE Character(3) VARCHAR2(3) NOT NULL Retained Grade

Prompt Table: GVT_RTND_SG_VW

27 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency

Prompt Table: GVT_SUBAGCY_TBL

28 ACTION_ITA Character(3) VARCHAR2(3) NOT NULL Turnover - Action
HIR=Hire
LAY=Lay off
LEA=Leave of Absence
TER=Termination
29 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
30 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

Prompt Table: EMPL_CTG

31 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category

Prompt Table: EMPL_CTG_L1_VW

32 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory

Prompt Table: EMPL_CTG_L2_VW

33 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON