VAPS CHART Table
View exposing legacy VAPS chart or account reference records including account identifiers, supervisory and address fields, department attributes, term attributes, effective and expiration dates, section, titles, and purpose text.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCT |
Legacy VAPS account code. |
VARCHAR2 |
5 |
ADDR |
Mailing or office address associated with the account. |
VARCHAR2 |
30 |
ADDRRM |
Room number associated with the account address. |
VARCHAR2 |
10 |
CONTIN |
Continuation account code associated with the account. |
VARCHAR2 |
5 |
CONTPR |
Continuation project or related continuation reference associated with the account. |
VARCHAR2 |
5 |
DELET |
Indicator identifying whether the account record is marked deleted (Y/N). |
VARCHAR2 |
1 |
DEPT4 |
Four-digit department code associated with the account. |
VARCHAR2 |
4 |
DEPTY |
Department type code associated with the account. |
VARCHAR2 |
2 |
EFFDATE |
Effective date of the account record. |
DATE |
|
EXPDATE |
Expiration date of the account record. |
DATE |
|
PARENT |
Parent account code associated with the account. |
VARCHAR2 |
5 |
PURPOSE |
Primary purpose description associated with the account. |
VARCHAR2 |
40 |
PURPOSE2 |
Secondary purpose description associated with the account. |
VARCHAR2 |
20 |
SECTION |
Section code associated with the account. |
VARCHAR2 |
2 |
SPONDTE |
Sponsor date associated with the account record. |
DATE |
|
SUPER |
Name of the supervisor or responsible person associated with the account. |
VARCHAR2 |
30 |
SUPERRM |
Room number associated with the supervisor or responsible person. |
VARCHAR2 |
10 |
TERM |
Term code associated with the account. |
VARCHAR2 |
1 |
TERMYR |
Fiscal or term year code associated with the account. |
VARCHAR2 |
2 |
TITLE |
Primary title or description associated with the account. |
VARCHAR2 |
40 |
TITLE2 |
Secondary title or abbreviated description associated with the account. |
VARCHAR2 |
20 |