LM_STG_QUAL_INS

(SQL Table)
 Index Back

Staging Table for Qualifier

Staging Table for Qualifier Instance

  • Related Language Record: LM_STG_QINS_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL Category Type
    2 LM_JP_QUAL_SET Character(12) VARCHAR2(12) NOT NULL Qualifier Set
    3 LM_CAT_ITEM_QUAL Character(12) VARCHAR2(12) NOT NULL Category Qualifier field
    4 LM_EIP_CTRL_ID Number(10,0) DECIMAL(10) NOT NULL EIP Control Id
    5 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
    6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    7 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 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
    11 BASE_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Prompt Table: BSLNGCDXLAT