EXT_ORG_IDPrompt Table: AV_EXT_ORG_SRCH
ORG_CONTACTPrompt Table: PEOPLE_SRCH
Default Value: EXT_ORG_TBL.ORG_LOCATION
Prompt Table: ORG_LOCATION
Prompt Table: ORG_DEPT
Prompt Table: ORG_CNT_TYP_TBL
AV_ORG_CNTCT_VW(SQL View) |
Index Back |
|---|---|
Organization Contact TableUSE AV_ORG_CONTACT_VW to get information about a matching gift contact's address within an organization. The address information is maintained in the organization location table and gets associated to a contact by setting either the department number or the location number in this table. |
| SELECT A.EXT_ORG_ID , A.ORG_CONTACT , A.EMPLID , A.CONTACT_NAME , A.JOBTITLE , A.ORG_LOCATION , A.ORG_DEPARTMENT , A.EMAILID , A.ORG_CONTACT_TYPE , A.URL_ADDRESS FROM PS_ORG_CONTACT A WHERE ORG_CONTACT_TYPE='MG' AND %EffdtCheck( ORG_CONTACT A1, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: AV_EXT_ORG_SRCH |
| 2 | ORG_CONTACT |
Number(4,0) | SMALLINT NOT NULL | Contact Nbr |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 4 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Contact Name |
| 5 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 6 | ORG_LOCATION | Number(3,0) | SMALLINT NOT NULL |
Location Nbr
Default Value: EXT_ORG_TBL.ORG_LOCATION Prompt Table: ORG_LOCATION |
| 7 | ORG_DEPARTMENT | Number(3,0) | SMALLINT NOT NULL |
Department Nbr
Prompt Table: ORG_DEPT |
| 8 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 9 | ORG_CONTACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Contact Type
Prompt Table: ORG_CNT_TYP_TBL |
| 10 | URL_ADDRESS | Character(254) | VARCHAR2(254) NOT NULL | URL Address |