GVT_TAS_GWAA=Treasury Central Summ Account
C=Cancelled
F=Clearing/Suspense Account
M=Merged Surplus Account
X=No-Year Account
GVT_TAS_GWA_VW(SQL View) |
Index Back |
|---|---|
TAS View by GWA TAS StringTAS Definition view |
| SELECT GVT_TAS_GWA , GVT_TAS_SP , GVT_TAS_ATA , GVT_TAS_AID , GVT_TAS_BPOA , GVT_TAS_EPOA , GVT_TAS_A , GVT_TAS_MAIN , GVT_TAS_SUB FROM PS_GVT_TAS_DEFN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_TAS_GWA |
Character(26) | VARCHAR2(26) NOT NULL | TAS GWA |
| 2 | GVT_TAS_SP | Character(2) | VARCHAR2(2) NOT NULL | Sub-Level Prefix |
| 3 | GVT_TAS_ATA | Character(3) | VARCHAR2(3) NOT NULL | Allocation Transfer Agency |
| 4 | GVT_TAS_AID | Character(3) | VARCHAR2(3) NOT NULL | TAS Agency Identifier |
| 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_MAIN | Character(4) | VARCHAR2(4) NOT NULL | Main Account |
| 9 | GVT_TAS_SUB | Character(3) | VARCHAR2(3) NOT NULL | Sub Account |