GVT_TAS_DEF_LNG(SQL Table) |
Index Back |
|---|---|
TAS DefinitionRelated Language record for GVT_TAS_DEFN. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GVT_TAS_AID |
Character(3) | VARCHAR2(3) NOT NULL |
TAS Agency Identifier
Prompt Table: GVT_TAS_AGENCY |
| 2 | GVT_TAS_MAIN |
Character(4) | VARCHAR2(4) NOT NULL |
Main Account
Prompt Table: GVT_TAS_M_ACCT |
| 3 | GVT_TAS_SP |
Character(2) | VARCHAR2(2) NOT NULL | Sub-Level Prefix |
| 4 | GVT_TAS_ATA |
Character(3) | VARCHAR2(3) NOT NULL | Allocation Transfer Agency |
| 5 | GVT_TAS_BPOA |
Character(4) | VARCHAR2(4) NOT NULL | Begin Period of Availability |
| 6 | GVT_TAS_EPOA |
Character(4) | VARCHAR2(4) NOT NULL | End Period of Availability |
| 7 | GVT_TAS_A |
Character(1) | VARCHAR2(1) NOT NULL |
Availability Type
A=Treasury Central Summ Account C=Cancelled F=Clearing/Suspense Account M=Merged Surplus Account X=No-Year Account |
| 8 | GVT_TAS_SUB |
Character(3) | VARCHAR2(3) NOT NULL | Sub Account |
| 9 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 10 | DESCR125 | Character(125) | VARCHAR2(125) NOT NULL | Description with 125 character length. Federal CGAC requirement. |