RSF_TR_REORG_LN(SQL Table) |
Index Back |
---|---|
Related Lang-Territory - ReorgTable 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. |
# | 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |