AV_ACCOUNT_TBL(SQL Table) |
Index Back |
---|---|
Account Designation TableAccount Designation Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: AV_OPR_DEF_TBL.SETID Prompt Table: SETID_TBL |
2 | DESIGNATION | Character(11) | VARCHAR2(11) NOT NULL | Designation |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %DATE |
4 | AV_DES_NAME | Character(30) | VARCHAR2(30) NOT NULL | Designation Name |
5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
6 | ACCOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Account Type
$=Issue Check C=Checking L=Liability N=Non Applicable S=Savings X=Expense |
7 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Item Type
Prompt Table: AV_ITEM_TYPE_VW |
8 | ACAD_ORG | Character(10) | VARCHAR2(10) NOT NULL |
Academic Organization
Prompt Table: ACAD_ORG_TBL_VW |
9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: AV_DEPT_VW |
10 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL |
Campus
Prompt Table: CAMPUS_TBL |
11 | DESCR60_SRCH | Character(60) | VARCHAR2(60) NOT NULL |
Formal Description
Default Value: AV_ACCOUNT_TBL.AV_DES_NAME |
12 | AV_CASE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
CASE Type
C=Current Unrestricted E=Endowment & Similar L=Loan Funds N=Non-Gift P=Plant Funds R=Current Restricted |
13 | AV_CASE_PRPS | Character(4) | VARCHAR2(4) NOT NULL |
CASE Purpose
A=Financial Aid B=Land & Buildings C=Chairs E=Equipment F=Faculty/Staff Compen J=Student Projects L=Library M=Academic Divisions N=Non-Gift O=Other Restricted Purposes P=Prizes R=Research S=Special Programs T=Athletics U=Unrestricted X=Public Service & Ext |
14 | AV_FASB_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
FASB Type
1=Unrestricted 2=Temp. Restricted 3=Perm. Restricted 4=Agency |
15 | AV_MTCH_GFT_TP | Character(6) | VARCHAR2(6) NOT NULL |
Matching Gift Type
Prompt Table: AV_MTCH_GFT_TBL |
16 | AV_INST_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Designation Type
Prompt Table: AV_INST_TYP_TBL |
17 | STAFF_ID | Character(11) | VARCHAR2(11) NOT NULL |
Staff ID
Prompt Table: AV_STAFF_ST2_VW |
18 | GIFT_EVENT_3CS | Character(10) | VARCHAR2(10) NOT NULL |
Event ID
Prompt Table: EVNT_3CS_TBL |
19 | PURPOSE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Role
Prompt Table: AV_PRPS_VW |
20 | PLDG_EVENT_3CS | Character(10) | VARCHAR2(10) NOT NULL |
Event ID
Prompt Table: EVNT_3CS_TBL |
21 | PLDG_PURPOSE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Purpose Code
Prompt Table: AV_PRPS_VW |
22 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTN_SCRTY |
23 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
24 | COMMENTS | Long Character | CLOB | Comment |