SETIDTAS_ATTRIBF2_TAS_ATT_VW(SQL View) |
Index Back |
|---|---|
Prompt view for TAS |
| SELECT DISTINCT B.SETID , A.TAS_STRING , A.DESCR125 FROM PS_TAS_DEFN_TBL A , PS_TAS_FUND_cd_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 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | TAS_ATTRIB |
Character(27) | VARCHAR2(27) NOT NULL | Treasury Symbol Attribute |
| 3 | DESCR125 | Character(125) | VARCHAR2(125) NOT NULL | Description with 125 character length. Federal CGAC requirement. |