BUSINESS_UNITSSF_RFND_ORG_SPONSSF_ORG_EMPLID_RELREFUND_SRCH5_VW(SQL View) |
Index Back |
|---|---|
People Search ViewCommon view used when searching for/selecting a person for display/update. This view should be used as the basis for all other views which go against people. The PeopleCode contained on this view is important for any other view which is based on this one - the searching/formatting for names and setting the carry id is done with this code. |
| SELECT A.BUSINESS_UNIT ,A.REFUND_EXT_ORG_ID ,A.COMMON_ID ,B.NAME FROM PS_ITEM_SF A ,PS_SCC_PRI_NAME_VW B WHERE A.COMMON_ID = B.EMPLID AND A.SA_ID_TYPE = 'P' AND A.REFUND_EXT_ORG_ID <> ' ' GROUP BY A.BUSINESS_UNIT, A.COMMON_ID, A.REFUND_EXT_ORG_ID, B.NAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SSF_RFND_ORG_SPON |
Character(11) | VARCHAR2(11) NOT NULL | Sponsor Org ID |
| 3 | SSF_ORG_EMPLID_REL |
Character(11) | VARCHAR2(11) NOT NULL | Related People ID |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |