RSF_TR_REORG

(SQL Table)
 Index Back

Territory - Reorganization

Table for Territory Reorganization Requests. Release 9.1 - RSF_TR_REORG AE program is broken down to 3 different AE programs for performance improvement without impacting any UI changes. New fields LEAD_REORG_COMPLET, OPPY_REORG_COMPLET and ACCT_REORG_COMPLET are added. These fields will be updated by RSF_TR_LEAD, RSF_TR_OPPY and RSF_TR_ACCT Application Engine (AE) programs. REORG_STATUS field will be updated to 'Complete' (C) by the above mentioned AE programs only if all the three new files are set to 'Y'. There is no upgrade impact as going forward we will be using the three new AE programs and we should not use RSF_TR_REORG.

  • Related Language Record: RSF_TR_REORG_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REORG_ID Character(15) VARCHAR2(15) NOT NULL Reorganization ID

    Default Value: NEXT

    2 FROM_TREE Character(18) VARCHAR2(18) NOT NULL Current Tree Name

    Default Value: RSF_OPR_DEF_VW.TREE_NAME

    Prompt Table: RSF_OPR_TREE_VW

    3 EFFDT_FROM Date(10) DATE Effective Date From
    4 TO_TREE Character(18) VARCHAR2(18) NOT NULL New Tree Name

    Default Value: RSF_TR_REORG.FROM_TREE

    Prompt Table: RSF_OPR_TREE_VW

    5 EFFDT_TO Date(10) DATE Effective Date To

    Default Value: %date

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    8 REORG_DATE Date(10) DATE Reorginzation Date
    9 REORG_STATUS Character(1) VARCHAR2(1) NOT NULL Reorganization Status
    I=In Progress
    R=Reviewed
    S=Submitted

    Default Value: I

    10 REORG_TOGGLE Character(1) VARCHAR2(1) NOT NULL Refresh
    11 REORG_LOAD_STATUS Character(1) VARCHAR2(1) NOT NULL Reorg Load Status
    C=Complete
    N=New
    P=Processing

    Default Value: N

    12 SUBMIT_STATUS Character(1) VARCHAR2(1) NOT NULL Submit Status
    C=Complete
    N=New
    P=Processing

    Default Value: N

    13 REFRESH_PB Character(1) VARCHAR2(1) NOT NULL Refresh Push Button field for general use.
    14 CREATE_TREE_PB Character(1) VARCHAR2(1) NOT NULL Clone/Update Tree
    15 LEAD_REORG_COMPLET Character(1) VARCHAR2(1) NOT NULL Lead Reorganization completed status.

    Y/N Table Edit

    Default Value: N

    16 OPPY_REORG_COMPLET Character(1) VARCHAR2(1) NOT NULL Lead Reorganization completed status.

    Y/N Table Edit

    Default Value: N

    17 ACCT_REORG_COMPLET Character(1) VARCHAR2(1) NOT NULL Lead Reorganization completed status.

    Y/N Table Edit

    Default Value: N

    18 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    19 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    20 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    21 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    22 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.
    23 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time