COLLECT_ORG_VW(SQL View) |
Index Back |
---|---|
Organization Collection ID VwThis view is used as a prompt for COLLECTION ID in COMM_VAR_DATA. EXT_ORG_ID is the primary key. |
select EXT_ORG_ID, BUSINESS_UNIT, COLLECTION_ID FROM PS_COLLECTION_SF WHERE EXT_ORG_ID <> ' ' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(11) | VARCHAR2(11) NOT NULL | External Org ID | |
2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
3 | Number(12,0) | DECIMAL(12) NOT NULL | Collection ID |