TAS_GWALANGUAGE_CDIPAC_RGWA_VW_LG(SQL View) |
Index Back |
|---|---|
Search view for Receiver TAS |
| SELECT DISTINCT A.TAS_GWA , B.SUB_CLASS , B.SUB_LEVEL_CD , B.AGENCY_ID1 , B.LANGUAGE_CD , B.DESCR125 FROM PS_TAS_DEFN_TBL A , PS_TAS_DEFN_LANG B WHERE A.AGENCY_ID1 = B.AGENCY_ID1 AND A.SUB_CLASS = B.SUB_CLASS AND A.SUB_LEVEL_CD = B.SUB_LEVEL_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TAS_GWA |
Character(26) | VARCHAR2(26) NOT NULL | TAS GWA |
| 2 | SUB_CLASS | Character(2) | VARCHAR2(2) NOT NULL | Sub Class |
| 3 | SUB_LEVEL_CD | Character(2) | VARCHAR2(2) NOT NULL | Sub level prefix code |
| 4 | AGENCY_ID1 | Character(3) | VARCHAR2(3) NOT NULL | TAS agency id |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR125 | Character(125) | VARCHAR2(125) NOT NULL | Description with 125 character length. Federal CGAC requirement. |