SIRET_NBR_FRAFUND_CD_FRAGPFR_DUCS_CD_VW(SQL View) |
Index Back |
|---|---|
DUCS Prompt ViewPrompt View for Contact Definition |
| SELECT DISTINCT A.SIRET_NBR_FRA ,A.FUND_CD_FRA ,A.FUND_INST_FRA ,A.DESCR50 FROM PS_FUND_INST_FRA A ,PS_FUND_INST_FRA B WHERE A.FUND_INST_FRA=B.FUND_INST_FRA AND A.EFFDT=( SELECT MAX(AA.EFFDT) FROM PS_FUND_INST_FRA AA WHERE A.FUND_INST_FRA=AA.FUND_INST_FRA AND AA.EFFDT<=%CurrentDateIn AND AA.EFF_STATUS='A' ) AND A.SIRET_NBR_FRA <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SIRET_NBR_FRA |
Character(35) | VARCHAR2(35) NOT NULL | SIRET Number - France |
| 2 | FUND_CD_FRA |
Character(6) | VARCHAR2(6) NOT NULL | Fund Code - France |
| 3 | FUND_INST_FRA | Character(4) | VARCHAR2(4) NOT NULL | Fund Institution Number |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |