TAS_GWABETC_CDCA_TASBETC_S_VW(SQL View) |
Index Back |
|---|---|
String TAS BETC ViewView for String TAS BETC combinations |
| SELECT B.TAS_STRING , A.BETC_CD FROM PS_BETC_DEFN_TBL A , PS_TAS_DEFN_TBL B WHERE A.AGENCY_ID1 = B.AGENCY_ID1 AND A.MAIN_ACCOUNT = B.MAIN_ACCOUNT AND A.SUB_LEVEL_CD = B.SUB_LEVEL_CD AND A.ALLO_TR_AGENCY = B.ALLO_TR_AGENCY AND A.BEGIN_PERIOD_AVAIL = B.BEGIN_PERIOD_AVAIL AND A.END_PERIOD_AVAIL = B.END_PERIOD_AVAIL AND A.AVAIL_TYPE_CD = B.AVAIL_TYPE_CD AND A.SUB_ACCOUNT = B.SUB_ACCOUNT AND A.ACTIVE_INACTIVE = 'A' AND A.ADJUSTMENT = 'N' AND B.INTERNAL_TAS_SW = 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TAS_GWA |
Character(26) | VARCHAR2(26) NOT NULL | TAS GWA |
| 2 | BETC_CD |
Character(8) | VARCHAR2(8) NOT NULL | Business Event Type Code |