EXT_ORG_IDSAD_INT_CONTR_NLDSAD_BPV_CON_SR4(SQL View) |
Index Back |
|---|---|
BPV COntact viewFS 15062004 |
| SELECT A.EXT_ORG_ID , A.HEGIS_CODE , A.ORG_LOCATION , B.DESCR , A.SAD_INT_CONTR_NLD , A.DESCR50 , C.ADDRESS3 , C.NUM1 , C.NUM2 , C.POSTAL FROM PS_SAD_BPV_CTR_NLD A , PS_ORG_LOCATION B , PS_SAD_BPV_OLD_NLD C WHERE A.SAD_PLAN_SEL_NLD IN ('B','A') AND A.EXT_ORG_ID = B.EXT_ORG_ID AND A.ORG_LOCATION = B.ORG_LOCATION AND %EffdtCheck(ORG_LOCATION B1, B, %CurrentDateIn) AND A.EXT_ORG_ID = C.EXT_ORG_ID(+) AND A.ORG_LOCATION = C.ORG_LOCATION(+) AND 'BUSN' = C.ADDRESS_TYPE(+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 2 | HEGIS_CODE | Character(8) | VARCHAR2(8) NOT NULL | HEGIS Code |
| 3 | ORG_LOCATION | Number(3,0) | SMALLINT NOT NULL | Location Nbr |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | SAD_INT_CONTR_NLD |
Character(16) | VARCHAR2(16) NOT NULL | Internal contract |
| 6 | SAD_BPV_C_DESC_NLD | Character(50) | VARCHAR2(50) NOT NULL | BPV Internship Description |
| 7 | SAD_BPV_STREET_NLD | Character(55) | VARCHAR2(55) NOT NULL | Street |
| 8 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 9 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 10 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |