AV_TRUST_TBL

(SQL Table)
Index Back

Trust Table

This table holds all information pertaining to a specific Trust Account.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 PG_TYPE Character(1) VARCHAR2(1) NOT NULL Planned Giving Type
B=Bequest
G=Gift Annuity
P=Pooled Income
T=Trust

Default Value: T

4 PGIVING_NBR Character(9) VARCHAR2(9) NOT NULL Planned Giving Number
5 TRUST_NAME Character(60) VARCHAR2(60) NOT NULL Trust Name
6 TRUST_ID Character(20) VARCHAR2(20) NOT NULL Trust ID
7 TRUST_TYPE Character(3) VARCHAR2(3) NOT NULL Trust Type

Prompt Table: AV_TRUST_T_TBL

8 TRUST_CTGY Character(3) VARCHAR2(3) NOT NULL Trust Category

Prompt Table: AV_TRUST_C_TBL

9 TRUST_TERM Character(2) VARCHAR2(2) NOT NULL Trust Term

Prompt Table: AV_TRUST_R_TBL

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: AV_INSTALL_INST.BASE_CURRENCY

Prompt Table: CURRENCY_CD_TBL

11 TRUST_PRINCIPAL Number(16,2) DECIMAL(15,2) NOT NULL Principal
12 TRUST_STATUS Character(2) VARCHAR2(2) NOT NULL Trust Status
A=Active
I=Inactive
M=Matured
U=Under Agreement
13 TRUST_INCP_DT Date(10) DATE Inception Date

Default Value: %date

14 START_DT Date(10) DATE Start Date
15 TRUST_EST_MAT Date(10) DATE Estimated Maturity
16 TRUST_FEES Number(16,2) DECIMAL(15,2) NOT NULL Trustee Fees
17 TRUST_PAY_TYPE Character(1) VARCHAR2(1) NOT NULL Payout Type
F=Fixed Amount
P=Percent

Default Value: F

18 TRUST_PAT_TERM Character(1) VARCHAR2(1) NOT NULL Payout Term
A=Annually
B=Bi-Monthly
H=Bi-Annually
M=Monthly
Q=Quarterly
19 TRUST_AMT Number(16,2) DECIMAL(15,2) NOT NULL Amount
20 TRUST_PCT Number(6,2) DECIMAL(5,2) NOT NULL Percent
21 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code

Prompt Table: AV_INTV_CMP_VW

22 TRUST_INCOME Number(16,2) DECIMAL(15,2) NOT NULL Total Income
23 TRUST_CONTRIBUTION Number(16,2) DECIMAL(15,2) NOT NULL Total Contributions
24 PG_IRREVOCABLE Character(1) VARCHAR2(1) NOT NULL Irrevocable
N=No
Y=Yes

Default Value: N

25 INST_ACT_VAL Number(16,2) DECIMAL(15,2) NOT NULL Inst Actual Value
26 INST_EST_VAL Number(16,2) DECIMAL(15,2) NOT NULL Inst Est Value
27 DESCRLONG Long Character CLOB Long Description