CMP_OPT_VALVW_L

(SQL View)
 Index Back

Value Field View - Rel Lng Tbl

Related Language 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 , D.LANGUAGE_CD , D.LONGNAME FROM PSRECFIELD A , PSRECFIELD B , PSDBFLDLABL C , PSDBFLDLABLLANG D 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 D.FIELDNAME = B.FIELDNAME AND C.LABEL_ID = D.LABEL_ID AND C.DEFAULT_LABEL = 1 AND ((B.RECNAME = A.FIELDNAME AND A.SUBRECORD = 'Y') OR (A.RECNAME = B.RECNAME AND A.SUBRECORD = 'N' AND A.FIELDNAME = B.FIELDNAME))

  • Related Language Record for CMP_OPT_VALUE_V

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name