GVT_TAS_FUND_CD(SQL Table) |
Index Back |
|---|---|
TAS FUND Code TableDefine TAS/Fund Code |
| # | 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 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 10 | FUND_CODE |
Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_ALL_VW |