VAPS CHART Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCT |
XXX |
VARCHAR2 |
5 |
ADDR |
XXX |
VARCHAR2 |
30 |
ADDRRM |
XXX |
VARCHAR2 |
10 |
CONTIN |
XXX |
VARCHAR2 |
5 |
CONTPR |
XXX |
VARCHAR2 |
5 |
DELET |
XXX |
VARCHAR2 |
1 |
DEPT4 |
Department 4 |
VARCHAR2 |
4 |
DEPTY |
XXX |
VARCHAR2 |
2 |
EFFDATE |
XXX |
DATE |
|
EXPDATE |
XXX |
DATE |
|
PARENT |
XXX |
VARCHAR2 |
5 |
PURPOSE |
XXX |
VARCHAR2 |
40 |
PURPOSE2 |
XXX |
VARCHAR2 |
20 |
SECTION |
The section ID |
VARCHAR2 |
2 |
SPONDTE |
XXX |
DATE |
|
SUPER |
XXX |
VARCHAR2 |
30 |
SUPERRM |
XXX |
VARCHAR2 |
10 |
TERM |
The current academic term code (eg. 2000FA, 2000SP) |
VARCHAR2 |
1 |
TERMYR |
XXX |
VARCHAR2 |
2 |
TITLE |
In the OSP AWARD, COST COLLECTOR, and PROJECT OSP tables, this is the Title of a Research Proposal. In KRB_PERSON, TITLE is the position title of the person. In TIP_MATERIAL view it is a TITLE of the course material. |
VARCHAR2 |
40 |
TITLE2 |
XXX |
VARCHAR2 |
20 |