EXT_ORG_IDPrompt Table: EXT_ORG_TBL
ORG_LOCATIONPrompt Table: SAD_BPV_LOC_NLD
ORG_CONTACTPrompt Table: SAD_BPV_OCO_NLD
EFFDTA=Active
I=Inactive
Prompt Table: ORG_CNT_TYP_TBL
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
SAD_BPV_ORG_LVW(SQL View) |
Index Back |
|---|---|
Organization Contact TableFS 03052004 |
| SELECT A.EXT_ORG_ID , A.ORG_LOCATION , A.ORG_CONTACT , B.EFFDT , B.EFF_STATUS , B.ORG_CONTACT_TYPE , B.CONTACT_NAME , C.SEX FROM PS_SAD_BPV_CNL_NLD A , PS_ORG_CONTACT B , PS_SAD_BPV_OCO_NLD C WHERE A.EXT_ORG_ID = B.EXT_ORG_ID AND A.ORG_CONTACT = B.ORG_CONTACT AND C.EXT_ORG_ID = B.EXT_ORG_ID AND C.ORG_CONTACT = B.ORG_CONTACT |
| # | 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: EXT_ORG_TBL |
| 2 | ORG_LOCATION |
Number(3,0) | SMALLINT NOT NULL |
Location Nbr
Prompt Table: SAD_BPV_LOC_NLD |
| 3 | ORG_CONTACT |
Number(4,0) | SMALLINT NOT NULL |
Contact Nbr
Prompt Table: SAD_BPV_OCO_NLD |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | ORG_CONTACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Contact Type
Prompt Table: ORG_CNT_TYP_TBL |
| 7 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Contact Name |
| 8 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |