MEMBERSHIP_NBR_FRAEFFDTDefault Value: %date
Prompt Table: FUND_INST_FRA
CT_FND_P_FRAVW(SQL View) |
Index Back |
|---|---|
Other Contracts View |
| SELECT A.MEMBERSHIP_NBR_FRA , A.EFFDT , A.DESCR50 , B.FUND_INST_FRA FROM PS_CNTRCT_FUND_FRA A , PS_FUND_INST_FRA B WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CNTRCT_FUND_FRA WHERE MEMBERSHIP_NBR_FRA = A.MEMBERSHIP_NBR_FRA AND EFFDT <= %CurrentDateIn) AND A.FUND_INST_FRA = B.FUND_INST_FRA AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_FUND_INST_FRA WHERE FUND_INST_FRA = A.FUND_INST_FRA AND EFFDT <= A.EFFDT) AND B.EFF_STATUS = 'A' AND B.FND_INST_TYPE_FRA NOT IN ('A', 'C') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MEMBERSHIP_NBR_FRA |
Character(20) | VARCHAR2(20) NOT NULL | Membership Number - France |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 4 | FUND_INST_FRA | Character(4) | VARCHAR2(4) NOT NULL |
Fund Institution Number
Prompt Table: FUND_INST_FRA |