AV_CNST_ACC_DES(SQL Table) |
Index Back |
---|---|
Constituent Accumulators DesigConstituent Accumulators by Fiscal Year, Business Unit, and Designation. Used on the Giving Profile and the Commitment Summary |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution | |
2 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
3 | Character(11) | VARCHAR2(11) NOT NULL | External Org ID | |
4 | Number(4,0) | SMALLINT NOT NULL | Fiscal Year | |
5 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
6 | Character(11) | VARCHAR2(11) NOT NULL | Designation | |
7 | AV_FY_GPP | Number(16,2) | DECIMAL(15,2) NOT NULL | Total Giving |
8 | AV_FY_PL_BAL | Number(16,2) | DECIMAL(15,2) NOT NULL | Pledge Balance |
9 | AV_FY_G_RCG | Number(16,2) | DECIMAL(15,2) NOT NULL | Recognition Credits |
10 | AV_FY_P_RCG | Number(16,2) | DECIMAL(15,2) NOT NULL | Recognition Pledge Balance |