CMP_RULE_RQ_FLD

(SQL View)
 Index Back

Defaulting Rule Req Fields Vw

View of the Required Fields of a Defaulting Rule This view selects the required record fields of a Field of a Defaulting Rules eligible for a Job row before the Job Data component is modified. This view is used for the Compensation Defaulting processing.

SELECT RD.CMP_RULE_ID , RD.EFFDT , RW.CMP_RULE_OPER_SEQ , RF.CMP_RECORD_FIELD , RW.RECNAME , RW.FIELDNAME , RF.CMP_PROMPT_FIELD FROM PS_CMP_RULE_DEFN RD ,PS_CMP_RULE_WHERE RW ,PS_CMP_OPT_REQ_FLD RF WHERE RW.CMP_RULE_ID = RD.CMP_RULE_ID AND RW.EFFDT = RD.EFFDT AND RF.RECNAME = RW.RECNAME AND RF.FIELDNAME = RW.FIELDNAME

# 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_RECORD_FIELD Character(18) VARCHAR2(18) NOT NULL Name of related Record Field
5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 CMP_PROMPT_FIELD Character(18) VARCHAR2(18) NOT NULL Name of Prompt Field