EXT_ORG_IDORG_CONTACTEFFDTA=Active
I=Inactive
ORG_CONTACT_VW(SQL View) |
Index Back |
|---|---|
Organization Contact ViewOrganization contact and location view. |
| SELECT A.EXT_ORG_ID , A.ORG_CONTACT , A.EFFDT , A.EFF_STATUS , A.CONTACT_NAME , A.JOBTITLE , B.ADDRESS1 , B.CITY , B.STATE , B.POSTAL , A.EMAILID FROM PS_ORG_CONTACT A , PS_ORG_LOCATION B WHERE A.EXT_ORG_ID = B.EXT_ORG_ID AND A.ORG_LOCATION = B.ORG_LOCATION AND %EffdtCheck(ORG_LOCATION B1, B, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 2 | ORG_CONTACT |
Number(4,0) | SMALLINT NOT NULL | Contact Nbr |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Contact Name |
| 6 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 7 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 8 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 9 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 10 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 11 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |