EXT_ORG_IDORG_CONTACT_TYPEPrompt Table: ORG_CNT_TYP_TBL
ORG_CONTACTEFFDTDefault Value: %date
A=Active
I=Inactive
ORG_CNTC_TYP_VW(SQL View) |
Index Back |
|---|---|
Organization Contact ViewOrganization contact and location view. |
| SELECT a.ext_org_id , a.org_contact_type , a.org_contact , a.effdt , a.eff_status , a.contact_name , a.jobtitle 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_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Contact Type
Prompt Table: ORG_CNT_TYP_TBL |
| 3 | ORG_CONTACT |
Number(4,0) | SMALLINT NOT NULL | Contact Nbr |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Contact Name |
| 7 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |