LRM_OPA_INT_HDR

(SQL Table)
 Index Back

LRM/OPA Inetgration HDR rec

LRM/OPA Inetgration Mapping header record

  • Related Language Record: LRM_OPA_HDR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INTEGRATION_ID Character(40) VARCHAR2(40) NOT NULL OPA Data Model ID
    2 ENTITY_NAME Character(50) VARCHAR2(50) NOT NULL Entity Name
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: TL_RECDEFN_VW

    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    6 ENTITY_TYPE Character(3) VARCHAR2(3) NOT NULL OPA Integration Reocrd Type definition
    C=Calculated
    R=Reported
    7 TL_REC_TYPE Character(3) VARCHAR2(3) NOT NULL Record Type
    C=Calculated Record
    E=Exception Record
    H=Header Record
    L=Line Record
    8 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    9 INCLUDE_FLG Character(1) VARCHAR2(1) NOT NULL include flag

    Y/N Table Edit

    Default Value: Y

    10 USER_DEFINED Character(1) VARCHAR2(1) NOT NULL User Defined

    Y/N Table Edit

    Default Value: N

    11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    12 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last Operator to Update
    13 LASTCHANGEDTTM DateTime(26) TIMESTAMP Used to identify the last time the object was changed
    14 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N