CMP_OPT_VALUE_V

(SQL View)
 Index Back

RC Dflt Value Fields View

View of the fields from the Rate Code Defaulting Values Table that can be used as Prerequisite Fields in the Rate Code Defaulting Options.

SELECT B.FIELDNAME , C.LONGNAME , B.EDITTABLE FROM PSRECFIELD A , PSRECFIELD B , PSDBFLDLABL C WHERE A.RECNAME = 'CMP_RULE_VALUES' AND A.FIELDNAME <> 'CMP_RULE_ID' AND A.FIELDNAME <> 'EFFDT' AND A.FIELDNAME <> 'CMP_RULE_OPER_SEQ' AND A.FIELDNAME <> 'CMP_VALUE_SEQ' AND A.FIELDNAME <> 'CMP_FLD_VALUE' AND A.FIELDNAME <> 'CMP_FLD_VALUE_DT' AND A.FIELDNAME <> 'CMP_FLD_VALUE_DTTM' AND A.FIELDNAME <> 'CMP_FLD_VALUE_TM' AND B.FIELDNAME = C.FIELDNAME AND ((B.RECNAME = A.FIELDNAME AND A.SUBRECORD = 'Y') OR (A.RECNAME = B.RECNAME AND A.SUBRECORD = 'N' AND A.FIELDNAME = B.FIELDNAME)) AND C.DEFAULT_LABEL = 1

  • Related Language Record: CMP_OPT_VALVW_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CMP_PROMPT_FIELD Character(18) VARCHAR2(18) NOT NULL Name of Prompt Field
    2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    3 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table