GVT_TAS_DEFN(SQL Table) |
Index Back |
|---|---|
TAS DefinitionUsed to define TAS Component. |
| # | 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
Default Value: 000 |
| 9 | GVT_TAS_EFFDT | Date(10) | DATE | TAS Effective Date |
| 10 | DESCR125 | Character(125) | VARCHAR2(125) NOT NULL | Description with 125 character length. Federal CGAC requirement. |
| 11 | GVT_TAS_GWA | Character(26) | VARCHAR2(26) NOT NULL | TAS GWA |