SETIDFUND_CODEGVT_TAS_FUND_VW(SQL View) |
Index Back |
|---|---|
TAS Fund Code ViewTAS Fund Code View |
| SELECT A.SETID , A.FUND_CODE , B.GVT_TAS_GWA FROM PS_GVT_TAS_FUND_CD A , PS_GVT_TAS_DEFN B WHERE A.GVT_TAS_AID = B.GVT_TAS_AID AND A.GVT_TAS_MAIN = B.GVT_TAS_MAIN AND A.GVT_TAS_SP = B.GVT_TAS_SP AND A.GVT_TAS_ATA = B.GVT_TAS_ATA AND A.GVT_TAS_BPOA = B.GVT_TAS_BPOA AND A.GVT_TAS_EPOA = B.GVT_TAS_EPOA AND A.GVT_TAS_A = B.GVT_TAS_A AND A.GVT_TAS_SUB = B.GVT_TAS_SUB |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | FUND_CODE |
Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 3 | GVT_TAS_GWA | Character(26) | VARCHAR2(26) NOT NULL | TAS GWA |