EXT_ORG_IDORG_CONTACTEFFDTA=Active
I=Inactive
ORG_CNTCT_SF_VW(SQL View) |
Index Back |
|---|---|
Organization Contact SF ViewOrganization contact and location view. |
| SELECT A.EXT_ORG_ID , A.ORG_CONTACT , A.EFFDT , A.EFF_STATUS , A.CONTACT_NAME , A.JOBTITLE , A.EMAILID FROM PS_ORG_CONTACT A |
| # | 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 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |