SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
REGION_CDPrompt Table: RS_REGION
BUSINESS_UNITPrompt Table: RS_BUEX_SRCH
RS_REGION_BUEX(SQL Table) |
Index Back |
|---|---|
Link Regions to Business UnitsLinking Regions to Expenses Business Units will assist with viewing historical Utilization Percentage information by Time Reporting Codes (TRC). Each Region can be linked to multiple Business Units, as long as they share the same TRC SetID. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | REGION_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table: RS_REGION |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: RS_BUEX_SRCH |