RA_MKT_CENTERRA_MC_ANCESTOR2(SQL View) |
Index Back |
|---|---|
Marketing Center AncestorsThis view returns not only the immediate marketing center parent but all ancestor marketing centers in the tree heirarchy - stopping at ROOT |
| SELECT RA_MKT_CENTER , RA_PARENT_MKTCTR FROM PS_RA_MC_ANCESTOR1 WHERE RA_PARENT_MKTCTR <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RA_MKT_CENTER |
Character(10) | VARCHAR2(10) NOT NULL | Marketing Center code |
| 2 | RA_PARENT_MKTCTR | Character(10) | VARCHAR2(10) NOT NULL | Parent Marketing Center |