SETIDFUND_CODEGVT_BETC_CDGVT_FUNDBETC_VW(SQL View) |
Index Back |
|---|---|
TAS Fund / BETC Code ViewTAS Fund / BETC Code View |
| SELECT B.SETID , B.FUND_CODE , A.GVT_BETC_CD FROM PS_GVT_BETC_DEFN A , PS_GVT_TAS_FUND_CD 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 AND A.GVT_ACTIVE_INDC = 'A' |
| # | 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_BETC_CD |
Character(8) | VARCHAR2(8) NOT NULL | Business Event Type Code |