SETIDREGION_CDRS_REGION_TRC(SQL View) |
Index Back |
|---|---|
Region TRCsReturns the appropriate list of Time Reporting Codes for each Region. |
| SELECT DISTINCT A.SETID , A.REGION_CD , C.TRC , C.DESCR FROM %Table(RS_REGION_BUEX) A , %Table(RS_REGION_SETID) B , %Table(EX_TRC_MAP_TBL) C WHERE A.BUSINESS_UNIT = B.SETCNTRLVALUE AND B.SETID = C.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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. |
| 3 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |