LM_CF_NAMES

(SQL Table)
 Index Back

Chart Field Names

Contains all the Chart Fields and how data on how they are used within ELM

  • Related Language Record: LM_CF_NAME_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CHART_FIELD Character(18) VARCHAR2(18) NOT NULL Chart Field code
    2 LM_CF_LONG_NAME Character(30) VARCHAR2(30) NOT NULL Chart Field Long Name
    3 LM_CF_SHORT_NAME Character(15) VARCHAR2(15) NOT NULL Chart Field short Name
    4 LM_CF_PROMPT_TBL Character(15) VARCHAR2(15) NOT NULL Chart Field Prompt Table
    5 LM_CF_USED Character(1) VARCHAR2(1) NOT NULL Is this Chart Field Used

    Y/N Table Edit

    6 LM_CF_REQUIRED Character(1) VARCHAR2(1) NOT NULL Is this Chart Field Required

    Y/N Table Edit

    7 LM_CF_DISPLAY_SEQ Character(2) VARCHAR2(2) NOT NULL Chart Field Display Sequence
    8 LM_SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL System data flag used to distinguish development system data from customer entries
    9 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    10 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    11 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    12 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
    13 LM_CF_USER_OVRD Character(1) VARCHAR2(1) NOT NULL Allow User Override

    Y/N Table Edit

    Default Value: N