LM_ORGANIZATION

(SQL Table)
 Index Back

Organization information

This record contains all customer information a company has.

  • Related Language Record: LM_ORG_LANG

  • Parent Record Of LM_ORG_ADDR LM_ORG_CHARTFLD LM_ORG_EMAIL LM_ORG_PHONE LM_ORG_PYT_DEFS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID

    Default Value: 999999999999999

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
    6 LM_ALT_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Alternate Character Customer Description
    7 LM_ORG_SDESCR Character(10) VARCHAR2(10) NOT NULL Organization Short Description
    8 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number

    Prompt Table: LM_LE_VW

    9 LM_ORG_TYPE Character(15) VARCHAR2(15) NOT NULL Organization Type
    10 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID

    Prompt Table: LM_PERS_DTL_VW

    11 LM_MANAGER_POSN Character(8) VARCHAR2(8) NOT NULL Manager Position

    Prompt Table: LM_POSITION

    12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    13 LM_TAXPAYER_ID Character(14) VARCHAR2(14) NOT NULL Taxpayer ID
    14 LM_PARENT_COMPANY Number(15,0) DECIMAL(15) NOT NULL Parent Company

    Prompt Table: LM_NAME_SRCH_VW

    15 LM_COMPANY_URL Character(254) VARCHAR2(254) NOT NULL Company URL
    16 LM_STOCK_SYMBOL Character(10) VARCHAR2(10) NOT NULL Stock Symbol
    17 LM_INDUSTRY Character(4) VARCHAR2(4) NOT NULL Industry
    CORE=Core
    EDUC=Education
    FNSV=Financial Services
    GOVT=Government
    HLTH=Health Care
    RETL=Retail
    TRAN=Transportation
    UTIL=Utilities
    18 LM_BUSINESS Character(4) VARCHAR2(4) NOT NULL Business
    19 LM_CUSTOMER_TYPE Character(1) VARCHAR2(1) NOT NULL Customer Type
    1=New Customer
    2=Returning Customer
    3=Preferred Customer
    4=Former Customer
    20 LM_MARKET Character(3) VARCHAR2(3) NOT NULL Market
    21 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Business Unit

    Prompt Table: LM_BUS_UNIT_VW

    22 LM_HR_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    23 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    24 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    25 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    26 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
    27 LM_ACCOUNT Character(20) VARCHAR2(20) NOT NULL Account Chart Field

    Prompt Table: %EDITTABLE9

    28 LM_ALTACCT Character(20) VARCHAR2(20) NOT NULL Alternate Account Chartfield

    Prompt Table: %EDITTABLE11

    29 LM_BUDGET_REF Character(20) VARCHAR2(20) NOT NULL Budget Reference Chartfield

    Prompt Table: %EDITTABLE13

    30 LM_CHARTFIELD1 Character(20) VARCHAR2(20) NOT NULL Chartfield 1

    Prompt Table: %EDITTABLE15

    31 LM_CHARTFIELD2 Character(20) VARCHAR2(20) NOT NULL Chartfield 2

    Prompt Table: %EDITTABLE16

    32 LM_CHARTFIELD3 Character(20) VARCHAR2(20) NOT NULL Chartfield 3

    Prompt Table: %EDITTABLE17

    33 LM_CLASS_FLD Character(20) VARCHAR2(20) NOT NULL Class Chart Field

    Prompt Table: %EDITTABLE7

    34 LM_FUND_CODE Character(20) VARCHAR2(20) NOT NULL Fund Code

    Prompt Table: %EDITTABLE6

    35 LM_HR_DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: LM_DEPT_CF_VW

    36 LM_OPERATING_UNIT Character(20) VARCHAR2(20) NOT NULL Operating Unit ChartField

    Prompt Table: %EDITTABLE12

    37 LM_PRODUCT Character(20) VARCHAR2(20) NOT NULL Product Chartfield

    Prompt Table: %EDITTABLE14

    38 LM_PROGRAM_CODE Character(20) VARCHAR2(20) NOT NULL Program Chart Field

    Prompt Table: %EDITTABLE8

    39 LM_PROJECT_ID Character(20) VARCHAR2(20) NOT NULL Project Chart Field

    Prompt Table: %EDITTABLE10

    40 LM_HR_MANAGER_ID Character(15) VARCHAR2(15) NOT NULL HR Manager ID
    41 LM_ENABLE_CASH Character(1) VARCHAR2(1) NOT NULL Enable Cash ?

    Y/N Table Edit

    Default Value: N

    42 LM_ENABLE_CHECK Character(1) VARCHAR2(1) NOT NULL Enable Check?

    Y/N Table Edit

    Default Value: N

    43 LM_ENABLE_CHGBK Character(1) VARCHAR2(1) NOT NULL Enable Chargebacks?

    Y/N Table Edit

    Default Value: N

    44 LM_ENABLE_CRCARD Character(1) VARCHAR2(1) NOT NULL Enable Credit Card?

    Y/N Table Edit

    Default Value: N

    45 LM_ENABLE_PO Character(1) VARCHAR2(1) NOT NULL Enable Purchase Order?

    Y/N Table Edit

    Default Value: N

    46 LM_ENABLE_TU Character(1) VARCHAR2(1) NOT NULL Enable Training Units?

    Y/N Table Edit

    Default Value: N

    47 LM_ENABLE_DISCOUNT Character(1) VARCHAR2(1) NOT NULL Enable Discount?

    Y/N Table Edit

    Default Value: N

    48 LM_PYMT_DISCOUNT Number(3,0) SMALLINT NOT NULL Payment Discount

    Default Value: 0

    49 LM_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
    50 LM_HR_COMPANY Character(3) VARCHAR2(3) NOT NULL HR's Company ID brought over during synchronization.