INSTITUTIONEMPLIDEXT_ORG_IDN=No
Y=Yes
N=No
Y=Yes
AV_CNST_ACC(SQL Table) |
Index Back |
|---|---|
Lifetime Accumulators |
| # | 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 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 4 | LT_CMTMT | Number(16,2) | DECIMAL(15,2) NOT NULL | LTime Commitments |
| 5 | LT_GPP | Number(16,2) | DECIMAL(15,2) NOT NULL | LTime Gifts/Payments |
| 6 | LT_OPL | Number(16,2) | DECIMAL(15,2) NOT NULL | LTime Open Pledges |
| 7 | LT_RCR | Number(16,2) | DECIMAL(15,2) NOT NULL | LTime Hard Credits |
| 8 | FIRST_GY | Number(4,0) | SMALLINT NOT NULL | First Gift Year |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | SESSION_NO | Character(11) | VARCHAR2(11) NOT NULL | Session Nbr |
| 11 | GIFT_NO | Character(11) | VARCHAR2(11) NOT NULL | Gift Nbr |
| 12 | SPLIT_RCG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Split Recognition
N=No Y=Yes |
| 13 | ANON_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Anonymous
N=No Y=Yes |
| 14 | AV_LG_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Largest Gift Business Unit |
| 15 | AV_LG_SESSION_NO | Character(11) | VARCHAR2(11) NOT NULL | Largest Gift Session Number |
| 16 | AV_LG_GIFT_NO | Character(11) | VARCHAR2(11) NOT NULL | Largest Gift Gift Number |
| 17 | AV_LP_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Largest Gift Business Unit |
| 18 | AV_LP_SESSION_NO | Character(11) | VARCHAR2(11) NOT NULL | Largest Gift Session Number |
| 19 | AV_LP_GIFT_NO | Character(11) | VARCHAR2(11) NOT NULL | Largest Gift Gift Number |
| 20 | TOT_LT_MTCH | Number(16,2) | DECIMAL(15,2) NOT NULL | Lifetime Match |
| 21 | MTCH_GIFTS | Number(16,2) | DECIMAL(15,2) NOT NULL | Matched Gifts |
| 22 | TOT_OUT_MTCH | Number(16,2) | DECIMAL(15,2) NOT NULL | Open Matches |
| 23 | LAST_MTCH_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | Last Match |
| 24 | TOT_LT_MTCH_E | Number(16,2) | DECIMAL(15,2) NOT NULL | Lifetime Match |
| 25 | TOT_OUT_MTCH_E | Number(16,2) | DECIMAL(15,2) NOT NULL | Open Matches |
| 26 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |