RC_ASSOC_TABLE

(SQL Table)
 Index Back

Case Associtations

This record is used to store the related objects like RMA,SO,Lead, Branch Script and Business Project.

  • Parent record: RC_CASE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_RC_NONVW

    3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    4 BUS_PROC_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Business Project Instance. This is the Business Project instance of a business project.
    5 RC_BRSCR_INSTANCE Number(15,0) DECIMAL(15) NOT NULL Branh Script Instance Number
    6 RC_SRVY_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Case Survey Instance field. Survey Instance built from concatenaton of Case Id and Sequence Number.
    7 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
    8 DLG_BU Character(5) VARCHAR2(5) NOT NULL This field stores the Business Unit that the transactions belong to.
    9 TYPE Character(4) VARCHAR2(4) NOT NULL Association Types
    10 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
    01=MASTER_ITEM_EC
    02=INV_ITEMS_EC
    03=BU_ITM_INV_EC
    04=BU_ITM_WTVL_EC
    05=ITEM_VENDOR_EC
    06=ITM_VNDR_LOC_EC
    07=ITM_VNDR_UOM_EC
    08=ITM_VND_UMPR_EC
    09=INV_ITM_UOM_EC
    10=PUR_ITM_ATTR_EC
    11=MANUFACTURER_EC
    12=ITEM_MFG_EC
    13=EN_REVISION_EC
    11 LINK_CATEGORY Character(5) VARCHAR2(5) NOT NULL This identifies the category that the link will be displayed under
    12 LINK_VERSION Character(4) VARCHAR2(4) NOT NULL Version of Human Resource Management System application.
    12.1=EBS 12.1
    8.0=8.0 SP1
    8.3=8.3
    8.8=8.8
    8.9=8.9
    9.0=9.0
    9.1=9.1
    9.2=9.2
    OTH=Other
    13 RC_LINK Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated
    14 RBB_BPEL_INST_ID Character(100) VARCHAR2(100) NOT NULL Business Process Instance ID
    15 RBB_SERV_OPR_ID Character(100) VARCHAR2(100) NOT NULL Service Operation ID
    16 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    17 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    18 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    19 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    20 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    21 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time