GVT_BETC_DEFN(SQL Table) |
Index Back |
|---|---|
BETCUsed to define Business Event Type 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 | GVT_BETC_CD |
Character(8) | VARCHAR2(8) NOT NULL | Business Event Type Code |
| 10 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 11 | GVT_PYMT_OR_CLLCTN | Character(1) | VARCHAR2(1) NOT NULL |
Payment or collection
C=Collection P=Payment |
| 12 | GVT_ADJUSTMENT | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment
Y/N Table Edit Default Value: N |
| 13 | GVT_ACTIVE_INDC | Character(1) | VARCHAR2(1) NOT NULL |
Active Indicator
A=Active I=Inactive Default Value: A |