LM_STG_POI_TYP

(SQL Table)
 Index Back

POI Type Table

Contains the POI type description.

  • Related Language Record: LM_STG_POI_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 LM_POI_TYPE Character(5) VARCHAR2(5) NOT NULL Person of Interest Type.
    3 LM_EIP_CTRL_ID Number(10,0) DECIMAL(10) NOT NULL EIP Control Id
    4 LM_POI_DESCR Character(30) VARCHAR2(30) NOT NULL POI type description.
    5 LM_POI_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL POI type short description.
    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 LM_POI_JOB_REQ Character(1) VARCHAR2(1) NOT NULL POI type job required.
    8 LM_EIP_PRCS_STTS Character(1) VARCHAR2(1) NOT NULL EIP Process status
    0=Not Processed
    1=Validated
    2=Invalid Data
    3=Loaded Successfully
    4=Invalid EmplRcd Number
    5=Warning Message
    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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    14 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
    A=Add
    C=Change Old (PPR Only)
    D=Delete
    K=Change - Old Values
    N=Change - New Values
    O=Change - Original Values
    15 BASE_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Prompt Table: BSLNGCDXLAT